"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: 22892
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

AttachmentSize
screen.JPG20.43 KB
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 22892
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: 22892
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: 22892
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