Errors when "building all thumbnails/resizes" function

webmonkey

Joined: 2003-12-05
Posts: 8
Posted: Fri, 2009-11-13 23:32

Hi, I have Gallery 2.X on my Windows 2003 server, running XAMPP (Apache 2.2, PHP 5.2). Whenever I run the "build all thumbnails/resizes" function in the 'Maintenance' section, I get the following output error:

Debug output for failed items:
file_exists(F:\xampp\g2data\cache\entity/1/1/112.inc)
file_exists(F:\xampp\g2data\cache\derivative/1/1/112.dat)
file_exists(F:\xampp\g2data\cache\entity/1/1/110.inc)
getParameter lock.system for core plugin
--------------------------------------------------------------------------------
(mysqli): SET NAMES "utf8"
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(113, 1, 1258154841)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId
ASC LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (112) OR
g_writeEntityId IN (112)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (113)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): DELETE FROM g2_Lock WHERE g_freshUntil < 1258154812
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(114, 1, 1258154842)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId
ASC LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (112) OR
g_writeEntityId IN (112)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (114)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): DELETE FROM g2_Lock WHERE g_freshUntil < 1258154813
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(115, 1, 1258154843)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT g_lockId FROM g2_Lock WHERE g_request=1 ORDER BY g_lockId
ASC LIMIT 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): SELECT COUNT(*) FROM g2_Lock WHERE g_readEntityId IN (112) OR
g_writeEntityId IN (112)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (115)
--------------------------------------------------------------------------------

Error: building 112: Error (ERROR_LOCK_TIMEOUT)in modules\core\classes\GalleryStorage\GalleryStorageExtras.class at line 716 (GalleryCoreApi::error) in modules\core\classes\GalleryStorage.class at line 396 (GalleryStorageExtras::acquireWriteLock) in modules\core\classes\DatabaseLockSystem.class at line 42 (GalleryStorage::acquireWriteLock) in modules\core\classes\GalleryLockSystem.class at line 147 (DatabaseLockSystem::_acquireLock) in modules\core\classes\helpers\GalleryLockHelper_simple.class at line 176 (GalleryLockSystem::acquireWriteLock) in modules\core\classes\GalleryCoreApi.class at line 2291 (GalleryLockHelper_simple::acquireWriteLock) in modules\core\classes\helpers\GalleryDerivativeHelper_advanced.class at line 833 (GalleryCoreApi::acquireWriteLock) in modules\core\classes\GalleryCoreApi.class at line 997 (GalleryDerivativeHelper_advanced::rebuildCache) in modules\core\classes\helpers\GalleryDerivativeHelper_simple.class at line 50 (GalleryCoreApi::rebuildDerivativeCache) in modules\core\classes\GalleryCoreApi.class at line 984 (GalleryDerivativeHelper_simple::rebuildCacheIfNotCurrent) in modules\core\classes\BuildDerivativesTask.class at line 113 (GalleryCoreApi::rebuildDerivativeCacheIfNotCurrent) in modules\core\AdminMaintenance.inc at line 128 (BuildDerivativesTask::run) in ??? at line 0 (AdminMaintenanceController::runTask) in modules\core\classes\GalleryTemplateAdapter.class at line 1092in F:\xampp\g2data\smarty\templates_c\%%687683871\matrix\%%3A^3A8^3A818B59%%theme.tpl.php at line 74 (GalleryTemplateAdapter::trailer) in lib\smarty\Smarty.class.php at line 1255in 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 104in main.php at line 88

On another related note, Gallery seems to freeze or not respond when I upload large photos individually. After this, the large photos are not appearing on the webstite, rather only "containers" which indicate broken links to images are shown.

Please help.
Thanks in advance!

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Tue, 2009-11-17 20:25

FAQ: I suddenly got an "ERROR_LOCK_TIMEOUT" message, what do I do?

Quote:
On another related note, Gallery seems to freeze or not respond when I upload large photos individually. After this, the large photos are not appearing on the webstite, rather only "containers" which indicate broken links to images are shown.

Post your system information and a link to phpinfo:
FAQ: What information is required when I ask for help in the forums?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here