Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions

You are not logged in.

Announcement

#1 2021-08-27 06:53:19

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_

Offline

#2 2021-08-27 07:31:29

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.

Offline

#3 2021-08-27 08:58:08

mhdali93
New member
Registered: 2021-08-27
Posts: 2

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

remdex wrote:

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

Offline

#4 2021-08-28 03:37:09

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.

Offline

Board footer