(ERROR_COLLISION) : Too many thumbnails

laddil

Joined: 2005-11-06
Posts: 7

Posted: Sun, 2005-11-06 17:38

There was another post in another forum about this, but it was dismissed as an alpha version isn't in the upgrade path... The upgrade process from Gallery 2 RC2 to Gallery 2 Claimed to go smoothly, but one day I recieved support emails that error collisions are occuring, but the thumbnails are being successfully created and the images are being added properly.

The error text given is as follows:

Quote:

Error Detail -
Error (ERROR_COLLISION) : Too many thumbnails or preferreds (type: 1, count: 1)

* in modules/core/classes/GalleryDerivativeImage.class at line 140 (gallerystatus::error)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 486 (galleryderivativeimage::create)
* in modules/core/classes/GalleryCoreApi.class at line 1513 (galleryitemhelper_medium::addexistingitemtoalbum)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 230 (gallerycoreapi::addexistingitemtoalbum)
* in modules/core/classes/GalleryCoreApi.class at line 1499 (galleryitemhelper_medium::additemtoalbum)
* in modules/core/ItemAddFromBrowser.inc at line 89 (gallerycoreapi::additemtoalbum)
* in modules/core/ItemAdd.inc at line 94 (itemaddfrombrowser::handlerequest)
* in main.php at line 174 (itemaddcontroller::handlerequest)
* in main.php at line 87
* in main.php at line 80

System Information
Gallery version 2.0.1
PHP version 4.4.0-gentoo-r1 apache2handler
Webserver Apache
Database mysql 4.1.14-log
Toolkits ImageMagick, NetPBM, Gd
Operating system Linux richie 2.6.13-gentoo-r5 #1 SMP Sun Oct 30 12:50:08 MST 2005 x86_64
Browser Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8a1) Gecko/20040520

I'm assuming there is a next-ID entry in the database somewhere that wasn't properly updated. Any ideas what to do to fix it?

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sun, 2005-11-06 17:49

please enable buffered debug mode

FAQ: How to set/use Gallery in debug mode?

and try to add another image.

also check your database, table sequenceId. there should only be a single row in this table.

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Mon, 2005-11-21 00:01

Same problem. Any help appreciated. Thanks in advnace. -Ivan

Error Detail -
Error (ERROR_COLLISION) : Too many thumbnails or preferreds (type: 1, count: 1)

* in modules/core/classes/GalleryDerivativeImage.class at line 140 (gallerystatus::error)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 486 (galleryderivativeimage::create)
* in modules/core/classes/GalleryCoreApi.class at line 1513 (galleryitemhelper_medium::addexistingitemtoalbum)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 230 (gallerycoreapi::addexistingitemtoalbum)
* in modules/core/classes/GalleryCoreApi.class at line 1499 (galleryitemhelper_medium::additemtoalbum)
* in modules/core/ItemAddFromBrowser.inc at line 89 (gallerycoreapi::additemtoalbum)
* in modules/core/ItemAdd.inc at line 94 (itemaddfrombrowser::handlerequest)
* in main.php at line 174 (itemaddcontroller::handlerequest)
* in main.php at line 87
* in main.php at line 80

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Mon, 2005-11-21 19:40

Any solutions? I posted on my hosting's support forum and got: "uninstall imagemagick and netpbm from the modules then install and configure them again followed by phsyically deleting the cache dir in g2data and rebuilding all thumbs/deritives" Any help much appreciated. -Ivan

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Mon, 2005-11-21 19:58

i don't know how you managed to get this problem, but right now, there is already an entry in the db for a thumbnail for item 3481 .

1. try clearing / deleting the db cache:
site admin -> maintenance -> delete db cache

if that doesn't help, you'll have to manually edit your database.

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Tue, 2005-11-22 05:58

Valiant,

Thanks for getting back. This happened after I moved servers. I tried deleting the db cache to no avail. What will I need to do to the database?

Thanks again for your time,

Ivan

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Tue, 2005-11-22 11:28

first
select child.g_id deriv.g_derivativeType from g2_ChildEntity child, g2_Derivative deriv where child.g_parentId = 3481 and child.g_id = deriv.g_id;

or something like that to see what there currently is.

laddil

Joined: 2005-11-06
Posts: 7

Posted: Tue, 2005-11-22 17:23

With debugging information turned on, have been unable to determine what is wrong =/

Anyways, here's the full text, as the faq suggests not posting that much to the forums:

http://meow.dyndns.org/gallery/Error.htm

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Wed, 2005-11-23 01:12

valiant wrote:

first
select child.g_id deriv.g_derivativeType from g2_ChildEntity child, g2_Derivative deriv where child.g_parentId = 3481 and child.g_id = deriv.g_id;

or something like that to see what there currently is.

What do I do after I find the what the current id is? Thanks, Ivan

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2005-11-23 04:41

mudanoman
please post the result of the query here.

laddil
that's weird. from your output:
SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1329 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

can you run this query manually?

and can you run:

SELECT g2_ChildEntity.g_id FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1329 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

and post the results?
did you also delete the db cache? pretty much everything i wrote in this thread applies to both of your cases.

laddil

Joined: 2005-11-06
Posts: 7

Posted: Wed, 2005-11-23 05:33

I did try deleting the cache when I read that. I didn't make a mention of it because I figured it might not be the same thing. Anyways, I ran the querries and here's basically what I found.

Quote:

SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1329 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

result: 0. Possibly because the image in question was deleted after uploading...

SELECT g2_ChildEntity.g_id FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1329 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

Result: Empty set.

Hmm... Not useful But my first guess is because I'm debugging, and deleted the original images I uploaded for that debug output, the numbers would be blank. So, I uploaded a new image to get a fresh debug output and use some new numbers:

Quote:

New querries:
(mysql): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1332 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

Result:
[COUNT(g2_ChildEntity.g_id)]
1

SELECT g2_ChildEntity.g_id FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 1332 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

Result: [g_id]
1333

Hope that helps!

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Wed, 2005-11-23 07:16

Quote:

New querries:
(mysql): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 3528 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

Result:
[COUNT(g2_ChildEntity.g_id)]
1

SELECT g2_ChildEntity.g_id FROM g2_ChildEntity, g2_Derivative WHERE (g2_ChildEntity.g_parentId = 3528 AND g2_Derivative.g_derivativeType = 1) AND (g2_ChildEntity.g_id = g2_Derivative.g_id)

Result: [g_id]
3529

deleted database cache

Valiant,

I look forward to hearing from you.

Thanks again,

Ivan

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2005-11-23 12:39

mudanoman

ok, delete the row with g_id = 3529 in db tables:
- g2_DerivativeImage
- g2_Derivate
- g2_ChildEntity
- g2_Entity

afterwards, delete the db cache in /lib/support/ -> cache
also delete the derivative cache (unless you want to manually delete this entry (1-3 files) in g2data/cache/derivative/3/5/3529*

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2005-11-23 12:44

laddil
so when uploading this item 1332 with thumbnail 1333, you got the same error again?
you get this error for each item you upload??

please check:
FAQ: How can I make sure that my installation files are all intact?

can you reproduce it when only gd is active? and if only netpbm is active?

if you install a second g2 in parallel on the server, can you reproduce the same issue with the fresh g2?

laddil

Joined: 2005-11-06
Posts: 7

Posted: Wed, 2005-11-23 13:20

The error occurs on every new upload, 100% reproducable. Only one file may be uploaded at a time, as it aborts on error.
The thumbnail and image are created successfully and are viewable.

By saying only, I assume you nean the graphics modules and not all modules in general.
On a fresh install, the error does not occur. I'm assuming it's something in the database that I have to modify. I will back up the database and try following the modifications given to Mud next.

Thank you.

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Wed, 2005-11-23 13:39

Quote:

Only one file may be uploaded at a time, as it aborts on error.

another error?

if you deactivate the create thumbnail option when adding items (bottom of the add items -> from browser page), you shouldn't get this error.

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Sun, 2005-11-27 01:53

Valiant,

I appreciate the response. My gallery is not letting me login for some odd reason, so I have put fixing the error on hold. I will report back with my findings.

Thanks,

Ivan

laddil

Joined: 2005-11-06
Posts: 7

Posted: Sun, 2005-11-27 03:52

Deactivating the create thumbnail option still causes this error.

Using the java-upload causes the same error... 100% repeatable.

Using the non-java or java upload the results are the same, the first image successfully uploads the rest are aborted/discarded.

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sun, 2005-11-27 09:30

@login:
delete your cookie cache in your browser

@thumbnail error persists:

no idea what's going on there.

gotta repeast a question i already asked:

Quote:

also check your database, table sequenceId. there should only be a single row in this table.

laddil

Joined: 2005-11-06
Posts: 7

Posted: Sun, 2005-11-27 13:51

Hmmm... There's two again. When I checked before, there was two and I deleted one. Now there is two again.

Strange... They both have the same value though.

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sun, 2005-11-27 14:18

there's definitely something wrong.
delete both entries and insert a new one which is slightly greater than the maximal g_id from g2_Entity and slighty higher than the max value from g2_AccessSubscriberMap

afterwards, delete the db / entity cache in
yourgalleryUrl/lib/support/ -> cache

mudanoman

Joined: 2005-09-13
Posts: 13

Posted: Tue, 2005-11-29 05:02

Valiant I tried deleting the rows as well as cache, but the same error message still seems to pop up. Any thing else I can try? Thanks, Ivan

laddil

Joined: 2005-11-06
Posts: 7

Posted: Tue, 2005-11-29 15:48

Same here. The g_Id was already 20-30 numbers higher then the g2_AccessSubscriberMap ID, but I bumped it up anyhow.

ralf

Joined: 2006-03-17
Posts: 2

Posted: Fri, 2006-03-17 06:57

I am having a similar problem, and after trying everything mentioned I got still no success.
The problem occured after I had some problems with my g2_AccessSubscriberMap and g2_AccessMap.
I get this error when uploading items to a new album, uploading to existing albums works.

Hope someone knows how to fix this, thanks in advance.

I attached the debugs output.

ralf

Joined: 2006-03-17
Posts: 2

Posted: Tue, 2006-03-21 08:00

I discovered the reason for the problem. Somehow, the main gallery settings contained two active entries for resized images of the same size. After deleting the duplicate target size, everything works fine again. One could consider this as a bug, but I can't reproduce it.

Thanks, best regards Ralf

rick7

Joined: 2005-03-02
Posts: 168

Posted: Fri, 2006-04-21 21:33

ralf wrote:

I discovered the reason for the problem. Somehow, the main gallery settings contained two active entries for resized images of the same size. After deleting the duplicate target size, everything works fine again. One could consider this as a bug, but I can't reproduce it.

Thanks, best regards Ralf

Hi, I'm having this "Too many thumbnails or preferreds" problem also. Can you explain your solution a bit more? I'm not sure what you mean by "main gallery settings contained two active entries for resized images of the same size." Thanks.

(ERROR_COLLISION) : Too many thumbnails

XUser login