Ongoing thumbnail creation issues.

silsurf

Joined: 2007-10-26
Posts: 20
Posted: Mon, 2008-01-28 16:27

I have had issues creating new thumbails ever since installing Gallery2. But, it is better than it has been based on the support I have received here. Currently when I run the thumbnail creation maintainance function I get a result such as below. I am not that great at troubleshooting this stuff and would appreciate and thoughts on what to do next.

Thanks,

Henry

file_exists(/home/8839/domains/frenchtoastandhugs.com/html/gallery2/g2data/cache/entity/3/4/3445.inc)
file_exists(/home/8839/domains/frenchtoastandhugs.com/html/gallery2/g2data/cache/derivative/3/4/3445.dat)
file_exists(/home/8839/domains/frenchtoastandhugs.com/html/gallery2/g2data/cache/entity/3/4/3444.inc)
getParameter lock.system for core plugin
file_exists(/home/8839/domains/frenchtoastandhugs.com/html/gallery2/g2data/cache/module/core/0/0/0.inc)
fopen(/home/8839/domains/frenchtoastandhugs.com/html/gallery2/g2data/locks/3445,
wb+, 0)
flock(Resource id #2354, 6, )
mysqlt error: [2013: Lost connection to MySQL server during query] in
EXECUTE("SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (3445)")

(mysqlt): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (3445)

2013: Lost connection to MySQL server during query

adodb_mysqlt._execute(SELECT g_id, g_entityType FROM
g2_Entity WHERE g_id IN (3445)) % line
870, file: adodb.inc.php

adodb_mysqlt.execute(SELECT g_id,
g_entityType FROM g2_Entity WHERE g_id IN (?), Array[1]) % line 2041, file: GalleryStorageExtras.class

gallerystorageextras._identifyentities(Array[1]) % line 98, file: GalleryStorageExtras.class

gallerystorageextras.loadentities(Array[1]) % line 298, file: GalleryStorage.class

mysqlstorage.loadentities(Array[1]) % line 518, file: GalleryStorageExtras.class

Error: building 3445: Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 2060 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 98 (gallerystorageextras::_identifyentities)
* in modules/core/classes/GalleryStorage.class at line 298 (gallerystorageextras::loadentities)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 518 (mysqlstorage::loadentities)
* in modules/core/classes/GalleryStorage.class at line 354 (gallerystorageextras::refreshentity)
* in modules/core/classes/GalleryEntity.class at line 343 (mysqlstorage::refreshentity)
* in modules/core/classes/helpers/GalleryDerivativeHelper_advanced.class at line 833 (galleryderivativeimage::refresh)
* in modules/core/classes/GalleryCoreApi.class at line 914 (galleryderivativehelper_advanced::rebuildcache)
* in modules/core/classes/helpers/GalleryDerivativeHelper_simple.class at line 49 (gallerycoreapi::rebuildderivativecache)
* in modules/core/classes/GalleryCoreApi.class at line 901 (galleryderivativehelper_simple::rebuildcacheifnotcurrent)
* in modules/core/classes/BuildDerivativesTask.class at line 99 (gallerycoreapi::rebuildderivativecacheifnotcurrent)
* in modules/core/AdminMaintenance.inc at line 90 (buildderivativestask::run)
* in ??? at line 0 (adminmaintenancecontroller::runtask)
* in modules/core/classes/GalleryTemplateAdapter.class at line 915
* in g2data/smarty/templates_c/%%3032077378/%%3A^3A8^3A818B59%%theme.tpl.php at line 69 (gallerytemplateadapter::trailer)
* in lib/smarty/Smarty.class.php at line 1258
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 209 (gallerysmarty::fetch)
* in main.php at line 473 (gallerytemplate::display)
* in main.php at line 94
* in main.php at line 83

Login or register to post comments
floridave
floridave's picture

Joined: 2003-12-22
Posts: 11212
Posted: Mon, 2008-01-28 18:01
Quote:
2013: Lost connection to MySQL server during query

Seems you have a connection issue between your web server the the DB server.
See if your host has any insite.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

Login or register to post comments
silsurf

Joined: 2007-10-26
Posts: 20
Posted: Mon, 2008-05-12 17:05

my host found the following forum link, which sounds perfect to my situation, alas I need some help with the specifics.

Another user had this solution to the non-appearing thumbnails, my questions are listed below.

1) I mass updated the file permissions on the machine itself to the Gallery folder.
(You mean changing all g2data/* to 777??)

2) I switched from PathInfo to ModRewrite for the URLs. This will give you prettier links and better performance.
(where do I do this, in the site admin of Gallery2?)

3) I migrated the database from InnoDB to MyISAM. InnoDB is usually the faster choice but the host sucks so MyISAM is doing way better. This will resolve the disk space errors too.
(where do I do this, in the site admin of Gallery2?)

Oh and you will need to fix any links to the images to the new ones or they will not work properly.
(please explain, I have over 4000 images on my site and as much info as you can give would be greatly appreciated.)

Henry

Login or register to post comments