Hallo,
wir betreiben seit kurzer Zeit eine Galerie, allerdings kommt schon bei minimaler Last, 5 Benutzer gleichzeitig, folgender Fehler:
Quote:
Database Error
An error has occurred while interacting with the database.
Back to the Gallery
Error Detail +
Error (ERROR_STORAGE_FAILURE)
in modules\core\classes\GalleryStorage.class at line 480 (GalleryCoreApi::error)
in modules\core\classes\Gallery.class at line 202 (GalleryStorage::search)
in modules\core\classes\helpers\GalleryChildEntityHelper_simple.class at line 162 (Gallery::search)
in modules\core\classes\helpers\GalleryChildEntityHelper_simple.class at line 92 (GalleryChildEntityHelper_simple::_fetchChildItemIds)
in modules\core\classes\GalleryCoreApi.class at line 2396 (GalleryChildEntityHelper_simple::fetchChildDataItemIds)
in modules\core\classes\GalleryTheme.class at line 1252 (GalleryCoreApi::fetchChildDataItemIds)
in themes\matrix\theme.inc at line 87 (GalleryTheme::loadCommonTemplateData)
in modules\core\classes\GalleryTheme.class at line 932 (MatrixTheme::showPhotoPage)
in modules\core\classes\GalleryView.class at line 308 (GalleryTheme::loadTemplate)
in main.php at line 441 (GalleryView::doLoadTemplate)
in main.php at line 94
in main.php at line 83
Debug Output
file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter language.useBrowserPref for core plugin file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\module/core/0/0/0.inc) Warning: Unable to select locale de_DE controller , view Loading plugin core Class not defined, trying to include it. file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/core/module.inc) core plugin successfully instantiated file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\versions.dat) file(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\versions.dat, ) getParameter id.anonymousUser for core plugin [1190033321] can't guarantee 5 -- extending! file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\entity/0/0/5.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/core/ShowItem.inc) getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin getParameter id.anonymousUser for core plugin getParameter id.adminGroup for core plugin Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost;DATABASE=gallery;UID=admgallery;PWD=admgalleryadmin
version=2.7
file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\module/_all/0/0/GalleryStorage_describeMap.inc) (ado_mssql): SELECT top 1 g_userId FROM g2_UserGroupMap WHERE g_userId=5 AND g_groupId=3 file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\entity/1/9/197.inc) file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\entity/1/8/185.inc) getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\theme/matrix/0/0/0.inc) file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\theme/matrix/1/8/185.inc) (ado_mssql): SELECT g2_Group.g_id, g2_Group.g_groupName FROM g2_UserGroupMap, g2_Group WHERE g2_Group.g_id = g2_UserGroupMap.g_groupId AND g2_UserGroupMap.g_userId = 5 ORDER BY g2_Group.g_groupName (ado_mssql): SELECT g_module, g_permission, g_description, g_bits, g_flags FROM g2_PermissionSetMap realpath(C:\Inetpub\wwwroot\Gallery\gallery2\modules\core\classes/../../..) Binding text domain: modules_core -> C:\Inetpub\wwwroot\Gallery\gallery2/modules/core/locale realpath(C:\Inetpub\wwwroot\Gallery\gallery2\modules\core\classes/../../..) Binding text domain: modules_comment -> C:\Inetpub\wwwroot\Gallery\gallery2/modules/comment/locale realpath(C:\Inetpub\wwwroot\Gallery\gallery2\modules\core\classes/../../..) Binding text domain: modules_rating -> C:\Inetpub\wwwroot\Gallery\gallery2/modules/rating/locale realpath(C:\Inetpub\wwwroot\Gallery\gallery2\modules\core\classes/../../..) Binding text domain: modules_shutterfly -> C:\Inetpub\wwwroot\Gallery\gallery2/modules/shutterfly/locale (ado_mssql): SELECT DISTINCT g2_AccessMap.g_accessListId FROM g2_AccessMap WHERE g2_AccessMap.g_userOrGroupId IN (5,4) AND g2_AccessMap.g_permission & 1 = 1 (ado_mssql): SELECT top 1 g_itemId FROM g2_AccessSubscriberMap WHERE g_itemId=197 AND g_accessListId IN (538,601) (ado_mssql): UPDATE g2_ItemAttributesMap SET g_viewCount = g2_ItemAttributesMap.g_viewCount + 1 WHERE g_itemId=197 file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\modules\core\classes/../../../themes/local/matrix) getParameter misc.markup for core plugin file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/search/Preloads.inc) file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/core/Preloads.inc) file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/core/Preloads.inc) file_exists(C:\Inetpub\wwwroot\Gallery\gallery2/modules/icons/classes/IconsImpl.class) getParameter iconpack for icons plugin file_exists(C:\Inetpub\wwwroot\Gallery\gallery2\g2data\cache\module/icons/0/0/0.inc) getParameter acceleration for core plugin getParameter id.anonymousUser for core plugin Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok (ado_mssql): SELECT g_parentSequence FROM g2_ItemAttributesMap WHERE g_itemId=197 (ado_mssql): SELECT g2_AccessSubscriberMap.g_itemId, g2_AccessMap.g_permission FROM g2_AccessMap, g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId IN (7,316,182,184,185) AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId AND g2_AccessMap.g_userOrGroupId IN (5,4) ado_mssql error: [1205: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 89) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.] in EXECUTE(" SELECT g2_ChildEntity.g_id, g2_ItemAttributesMap.g_orderWeight FROM g2_ChildEntity INNER JOIN g2_ItemAttributesMap ON g2_ChildEntity.g_id = g2_ItemAttributesMap.g_itemId INNER JOIN g2_DataItem ON g2_ChildEntity.g_id = g2_DataItem.g_id INNER JOIN g2_AccessSubscriberMap ON g2_ChildEntity.g_id = g2_AccessSubscriberMap.g_itemId WHERE g2_ChildEntity.g_parentId = 185 AND g2_AccessSubscriberMap.g_accessListId IN (538,601) ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id") (ado_mssql): SELECT g2_ChildEntity.g_id, g2_ItemAttributesMap.g_orderWeight FROM g2_ChildEntity INNER JOIN g2_ItemAttributesMap ON g2_ChildEntity.g_id = g2_ItemAttributesMap.g_itemId INNER JOIN g2_DataItem ON g2_ChildEntity.g_id = g2_DataItem.g_id INNER JOIN g2_AccessSubscriberMap ON g2_ChildEntity.g_id = g2_AccessSubscriberMap.g_itemId WHERE g2_ChildEntity.g_parentId = 185 AND g2_AccessSubscriberMap.g_accessListId IN (538,601) ORDER BY g2_ItemAttributesMap.g_orderWeight, g2_ChildEntity.g_id 1205: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 89) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Hat irgendwer eine Idee woran das liegen könnte?
Zusätzlich kommt nach einiger Zeit Betrieb mit diesem Fehler grundsätzlich noch
Quote:
PHP Access Violation
was das PHPBB2 auf dem Server ebenfalls abstürzen läßt und sich nur durch einen Neustart beheben läßt.
Hat jemand einen Rat?
Gallery version: 2.2.2-typical
PHP Version: 5.2.2
Graphik Tool: GD
Getestet und nachgestellt werden konnte der Fehler inzwischen auf 2 unterschiedlichen Servern.
Server1:
IIS Version: 6.0
Betriebssystem / Distribution: Windows Server 2003 SP1
Server2:
IIS Version: 5.0
Betriebssystem / Distribution: Windows Server 2000 SP4