INSERT INTO ezsession cause timeout and crash

Tuesday 22 July 2008 9:42:08 am

Hi,

I have a real problem with a site.
There was more than 1000 anonymous user inline at the same time.
The site crash.

error.log says :

[ Jul 22 2008 17:25:21 ] [82.245.188.40] eZMySQLDB:
Query error: Lock wait timeout exceeded; Try restarting transaction. Query: INSERT INTO ezsession
                    ( session_key, expiration_time, data, user_id )
                    VALUES ( '03ff8b9f6d016394bc9c1c34097f4097', '1216999243', 'eZUserLoggedInID|i:10;eZUserInfoCache_Timestamp|i:1216739730;eZUserInfoCache|a:1:{i:10;a:5:{s:16:\"contentobject_id\";s:2:\"10\";s:5:\"login\";s:9:\"anonymous\";s:5:\"email\";s:12:\"[email protected]\";s:13:\"password_hash\";s:32:\"4e6f6184135228ccd45f8233d72a0363\";s:18:\"password_hash_type\";s:1:\"2\";}}AccessArray|a:3:{s:7:\"content\";a:2:{s:4:\"read\";a:2:{s:6:\"p_1387\";a:1:{s:7:\"Section\";a:12:{i:0;s:1:\"1\";i:1;s:2:\"12\";i:2;s:2:\"25\";i:3;s:2:\"32\";i:4;s:2:\"44\";i:5;s:2:\"45\";i:6;s:2:\"47\";i:7;s:2:\"48\";i:8;s:2:\"49\";i:9;s:2:\"50\";i:10;s:2:\"51\";i:11;s:1:\"8\";}}s:6:\"p_1389\";a:2:{s:5:\"Class\";a:2:{i:0;s:2:\"26\";i:1;s:1:\"5\";}s:7:\"Section\";a:1:{i:0;s:1:\"3\";}}}s:10:\"tipafriend\";a:1:{s:1:\"*\";s:1:\"*\";}}s:4:\"user\";a:1:{s:5:\"login\";a:1:{s:6:\"p_1388\";a:1:{s:10:\"SiteAccess\";a:1:{i:0;s:10:\"3430272718\";}}}}s:3:\"rss\";a:1:{s:4:\"feed\";a:1:{s:1:\"*\";s:1:\"*\";}}}AccessArrayTimestamp|i:1216739730;eZRoleLimitationValueList_Timestamp|i:1216739730;eZUserGroupsCache_Timestamp|i:1216739730;eZUserGroupsCache|a:2:{i:0;s:2:\"42\";i:1;s:1:\"4\";}eZRoleLimitationValueList|a:1:{i:0;s:0:\"\";}eZRoleIDList_Timestamp|i:1216739730;eZRoleIDList|a:1:{i:0;s:1:\"1\";}eZUserDiscountRulesTimestamp|i:1216739730;eZUserDiscountRules10|a:0:{}eZGlobalSection|a:1:{s:2:\"id\";s:1:\"1\";}LastAccessesURI|s:34:\"/culture/genealogie/nom_de_famille\";LastAccessedModifyingURI|s:34:\"/culture/genealogie/nom_de_famille\";', '10' )

I looked at the anonymous user account and I saw that this user can support 1000 connection at the same time.

The problem comas from that ?

I need assistance :)

Best regards.

Laurent

Any idea?