Announcement

mhdali93

New member

Registered: 2021-08-27

Posts: 2

Livehelperchat: Multiple user on web chat shows mysql deadlock error

A query failed internally in Persistent Object: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction Query: 'INSERT INTO `lh_generic_bot_pending_event` ( `chat_id`, `trigger_id` ) VALUES ( :ezcValue1, :ezcValue2 )' - #0 /var/www/livehelperchat/lhc_web/ezcomponents/PersistentObject/src/handlers/save_handler.php(315): ezcPersistentSession->performQuery(Object(ezcQueryInsert))
#1 /var/www/livehelperchat/lhc_web/ezcomponents/PersistentObject/src/handlers/save_handler.php(103): ezcPersistentSaveHandler->saveInternal(Object(erLhcoreClassModelGenericBotPendingEvent), false, Object(ezcPersistentNativeGenerator))
#2 /var/www/livehelperchat/lhc_web/ezcomponents/PersistentObject/src/persistent_session.php(454): ezcPersistentSaveHandler->saveOrUpdate(Object(erLhcoreClassModelGenericBotPendingEvent), Array, Array)
#3 /var/www/livehelperchat/lhc_web/lib/core/lhcore/lhdbtrait.php(16): ezcPersistentSession->saveOrUpdate(Object(erLhcoreClassModelGenericBotPendingEvent), Array, Array)
#4 /var/www/livehelperchat/lhc_web/lib/core/lhgenericbot/actionTypes/lhgenericbotactionconditions.php(145): erLhcoreClassModelGenericBotPendingEvent->saveThis()
#5 /var/www/livehelperchat/lhc_web/lib/core/lhgenericbot/lhgenericbotworkflow.php(1567): erLhcoreClassGenericBotActionConditions::process(Object(erLhcoreClassModelChat), Array, Object(erLhcoreClassModelGenericBotTrigger), Array)
#6 /var/www/livehelperchat/lhc_web/lib/core/lhgenericbot/lhgenericbotworkflow.php(1600): erLhcoreClassGenericBotWorkflow::processTrigger(Object(erLhcoreClassModelChat), Object(erLhcoreClassModelGenericBotTrigger), false, Array)
#7 /var/www/livehelperchat/lhc_web/lib/core/lhgenericbot/lhgenericbotworkflow.php(317): erLhcoreClassGenericBotWorkflow::processTrigger(Object(erLhcoreClassModelChat), Object(erLhcoreClassModelGenericBotTrigger), false, Array)
#8 /var/www/livehelperchat/lhc_web/lib/core/lhgenericbot/lhgenericbotworkflow.php(233): erLhcoreClassGenericBotWorkflow::sendDefault(Object(erLhcoreClassModelChat), 1, Object(erLhcoreClassModelmsg))
#9 /var/www/livehelperchat/lhc_web/cache/compiledtemplates/bc5488e50919ea2d5be3706c316de553.php(2): erLhcoreClassGenericBotWorkflow::userMessageAdded(Object(erLhcoreClassModelChat), Object(erLhcoreClassModelmsg))
#10 /var/www/livehelperchat/lhc_web/lib/core/lhcore/lhmodule.php(96): include('/var/www/livehe...')
#11 /var/www/livehelperchat/lhc_web/lib/core/lhcore/lhmodule.php(555): erLhcoreClassModule::runModule()
#12 /var/www/livehelperchat/lhc_web/index.php(50): erLhcoreClassModule::moduleInit()
#13 {main} | 5_

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Livehelperchat: Multiple user on web chat shows mysql deadlock error

This is not happening on local environment or with high load clients. Means eitehr your server is to slow, either you have somewhere infinitive loop which couses it.

mhdali93

New member

Registered: 2021-08-27

Posts: 2

Re: Livehelperchat: Multiple user on web chat shows mysql deadlock error

This is not happening on local environment or with high load clients. Means eitehr your server is to slow, either you have somewhere infinitive loop which couses it.

It is happening with only 2 users using the web chat hosted on aws ubuntu server

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: Livehelperchat: Multiple user on web chat shows mysql deadlock error

You can contact me on discord if you want personal look.