INSERT INTO ezsession cause timeout and crash

Previous topic

Install & configuration

Next topic

Author	Message
laurent le cadet	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:\"nospam@ez.no\";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?
Stéphane Couzinier	Monday 11 August 2008 2:15:05 pm hi reduce session timeout. maybe it will reduce the number of line in the table http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/session During this pb did you had a lot of traffic in your web site? Maybe your have something to check in your Mysql conf. http://ez.no/developer/articles/tuning_mysql_for_ez_publish/mysql_configuration http://www.kouz-cooking.fr

Author

Message

laurent le cadet

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:\"nospam@ez.no\";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?

Stéphane Couzinier

Monday 11 August 2008 2:15:05 pm

reduce session timeout. maybe it will reduce the number of line in the table
http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/session

During this pb did you had a lot of traffic in your web site?
Maybe your have something to check in your Mysql conf.
http://ez.no/developer/articles/tuning_mysql_for_ez_publish/mysql_configuration

http://www.kouz-cooking.fr