"Migrating Keywords into Tags" unable to finish

yyeric

Joined: 2009-04-19
Posts: 7
Posted: Tue, 2009-05-12 12:12

I run "migrating keywords into tags" maintenance module everytime I update images to the gallery. Whenever i run this function, it never finishes in the first time i tried. I need to try a few times to complete this operation.

No error message, it always stops at somewhere 90% of the progress bar.

Could anyone give me a clue as to how to solve this?

Ta


Gallery URL = http://gallery.canberrapictorial.com.au/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.6 cgi
Webserver = Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_jk/1.2.25
Database = mysqlt 5.0.67-community-log, lock.system=flock
Toolkits = ArchiveUpload, SquareThumb, ImageMagick, Exif, Getid3, jpegtran, LinkItemToolkit, Thumbnail, Gd
Acceleration = full/21600, full/21600
Operating system = Linux sphinx.techservers.com.au 2.6.9-023stab033.6-enterprise #1 SMP Tue Nov 7 16:16:56 MSK 2006 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Rows in GalleryAccessMap table = 37
Rows in GalleryAccessSubscriberMap table = 2623
Rows in GalleryUser table = 2
Rows in GalleryItem table = 2622
Rows in GalleryAlbumItem table = 44
Rows in GalleryCacheMap table = 2031
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2009-05-12 18:12

If it just stops then I suspect you are hitting a resource limit on your host.
If you enable debug mode when you try the operation it might have a clue or the apache error log migh give a clue.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
yyeric

Joined: 2009-04-19
Posts: 7
Posted: Tue, 2009-05-12 23:15

Thanks Dave,

I have switched on the debug mode and received below message:

Fatal error: Cannot use object of type GalleryStatus as array in /home/canberra/public_html/galleries/modules/core/AdminMaintenance.inc on line 128

I have not changed this file at all though.

Line 128 is doing this list ($ret1, $success, $details) = $task->run();

PS, I have attached the screenshot of the error message. There you can see that it probably hasn't hit the memory limit?

Any input will help.

Eric
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2009-05-13 02:41

Does it always stop at the same item (2529)?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
yyeric

Joined: 2009-04-19
Posts: 7
Posted: Wed, 2009-05-13 05:43

Hi Dave,

Yes, for the total item of images (2578) it always stops at 2529. If the total is different, it will constantly stop at another figure.

Before this time, I was able to restart the process and it might go all the way, but not today.

Cheers,

Eric
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2009-05-13 10:35

Then I suspect that possibly that item 2529 is corrupt. Delete that item and try again then re add that item. Other than that....no ideas.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
yyeric

Joined: 2009-04-19
Posts: 7
Posted: Wed, 2009-05-13 12:24

Thanks very much Dave, I removed item 2529 and it's gallery and started again. It worked. However I received below errors from the debug mode if you are interested

Quote:
Error (ERROR_STORAGE_FAILURE) : Empty sequence id!

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 494 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage.class at line 1871 (GalleryStorageExtras::_getUniqueIdWithConnection)
* in modules/core/classes/helpers/MaintenanceHelper_simple.class at line 100 (MySqlStorage::getUniqueId)
* in modules/core/AdminMaintenance.inc at line 132 (MaintenanceHelper_simple::addRun)
* in ??? at line 0 (AdminMaintenanceController::runTask)
* in modules/core/classes/GalleryTemplateAdapter.class at line 1092
* in g2data/smarty/templates_c/%%4146392312/matrix/%%3A^3A8^3A818B59%%theme.tpl.php at line 81 (GalleryTemplateAdapter::trailer)
* in lib/smarty/Smarty.class.php at line 1255
* in modules/core/classes/GallerySmarty.class at line 61 (Smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 241 (GallerySmarty::fetch)
* in main.php at line 506 (GalleryTemplate::display)
* in main.php at line 104
* in main.php at line 88

At the item 2578, the error is

Quote:
mysqlt error: [2006: MySQL server has gone away] in EXECUTE("update g2_SequenceId set id=LAST_INSERT_ID(id+1);") mysqlt error: [2006: MySQL server has gone away] in EXECUTE("create table g2_SequenceId (id int not null)") mysqlt error: [2006: MySQL server has gone away] in EXECUTE("select count(*) from g2_SequenceId LIMIT 1") mysqlt error: [2006: MySQL server has gone away] in EXECUTE("insert into g2_SequenceId values (0)") mysqlt error: [2006: MySQL server has gone away] in EXECUTE("update g2_SequenceId set id=LAST_INSERT_ID(id+1);")

However, removing the gallery and starting over worked. interestingly.

Thanks Dave

Eric
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2009-05-13 13:24
Quote:
mysqlt error: [2006: MySQL server has gone away]

Seems that your DB server is having connectivity issues.
I would make frequent backups in case your DB gets hosed/corrupted even worse.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team