any help is greatly appreciated.....
current config
Gallery version = 2.2.4 core 1.2.0.6
PHP version = 5.2.8 cgi-fcgi
Webserver = Abyss/2.6.0.0-X1-Win32 AbyssLib/2.6.0.0
Database = mysqli 5.5.10, lock.system=database
Toolkits = Exif, LinkItemToolkit, Thumbnail, Gd, SquareThumb, Ffmpeg, ImageMagick
Acceleration = full/3600, full/172800
Operating system = Windows NT WIN-7NS9CKG13L6 6.1 build 7600
Default theme = matrix
gettext = disabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16
Rows in GalleryAccessMap table = 159
Rows in GalleryAccessSubscriberMap table = 10680
Rows in GalleryUser table = 6
Rows in GalleryItem table = 10676
Rows in GalleryAlbumItem table = 250
Rows in GalleryCacheMap table = 28
debug during gallery thumbnail resize in maint.
Debug output for failed items:
file_exists(C:\g2 data\cache\entity/1/7/17165.inc)
file_exists(C:\g2 data\cache\derivative/1/7/17165.dat)
file_exists(C:\g2 data\cache\entity/1/7/17164.inc)
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(166414, 1, 1303782486)
(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 (17165) OR
g_writeEntityId IN (17165)
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (166414)
(mysqli): DELETE FROM g2_Lock WHERE g_freshUntil < 1303782457
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(166415, 1, 1303782487)
(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 (17165) OR
g_writeEntityId IN (17165)
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (166415)
(mysqli): DELETE FROM g2_Lock WHERE g_freshUntil < 1303782459
(mysqli): update g2_SequenceLock set id=LAST_INSERT_ID(id+1);
(mysqli): INSERT INTO g2_Lock (g_lockId, g_request, g_freshUntil)
VALUES(166416, 1, 1303782489)
(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 (17165) OR
g_writeEntityId IN (17165)
(mysqli): DELETE FROM g2_Lock WHERE g_lockId IN (166416)
Error: building 17165: Error (ERROR_LOCK_TIMEOUT)
* in modules\core\classes\GalleryStorage\GalleryStorageExtras.class at line 718 (GalleryCoreApi::error)
* in modules\core\classes\GalleryStorage.class at line 380 (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 2193 (GalleryLockHelper_simple::acquireWriteLock)
* in modules\core\classes\helpers\GalleryDerivativeHelper_advanced.class at line 828 (GalleryCoreApi::acquireWriteLock)
* 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 C:\g2 data\smarty\templates_c\%%466471731\%%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 480 (GalleryTemplate::display)
* in main.php at line 94
* in main.php at line 83
Posted: Tue, 2011-04-26 01:54
Posts: 8339
was the old server windows also?
make sure all files in C:\g2 data are r/w via the webserver user.
also you can change the locking technique from DB to File in G2 Admin -> General
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 8
Yes. was a hardware install of server 2003. now running on a server 2008 vm instance. both were set as database locking. all files/folders have proper permsissions.
thanx though
Posts: 8
resolved.