XF 1.4 Storage Engine Error 188

[Blackbeard]

I'm getting the following error

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Got error 188 from storage engine - library/Zend/Db/Statement/Mysqli.php:214

The Stack trace is different each time, so I know it has to be server side related, as it's hitting multiple sites that are being ran.

I've never see error 188... any input would be awesome!

 

[Mike]

Can you show an example backtrace?

I popped 188 into "perror" and got nothing on one server and "FTS query exceeds result cache limit" on another which led to: http://blog.zinctech.com/?q=node/78 Is it a full text search query and are you using InnoDB for that table?

 

[Blackbeard]

#0 /home/vhosts/*****.com/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/vhosts/*****.com/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/vhosts/*****.com/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_sess...', Array)
#3 /home/vhosts/*****.com/library/XenForo/Session.php(805): Zend_Db_Adapter_Abstract->update('xf_session', Array, 'session_id = 'c...')
#4 /home/vhosts/*****.com/library/XenForo/Session.php(541): XenForo_Session->saveSessionToSource('c4f70ce5408b49b...', true)
#5 /home/vhosts/*****.com/library/XenForo/Controller.php(414): XenForo_Session->save()
#6 /home/vhosts/*****.com/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#7 /home/vhosts/*****.com/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#8 /home/vhosts/*****.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/vhosts/*****.com/index.php(13): XenForo_FrontController->run()
#10 {main}

#0 /home/vhosts/****.com/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/vhosts/****.com/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/vhosts/****.com/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_sess...', Array)
#3 /home/vhosts/****.com/library/XenForo/Session.php(805): Zend_Db_Adapter_Abstract->update('xf_session', Array, 'session_id = 'e...')
#4 /home/vhosts/****.com/library/XenForo/Session.php(541): XenForo_Session->saveSessionToSource('e70dbb79f295724...', true)
#5 /home/vhosts/****.com/library/XenForo/Controller.php(414): XenForo_Session->save()
#6 /home/vhosts/****.com/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#7 /home/vhosts/****.com/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#8 /home/vhosts/****.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/vhosts/****.com/index.php(13): XenForo_FrontController->run()
#10 {main}

 

[Mike]

Not search related. What MySQL version are you running? (Are you running MariaDB?)

 

[Blackbeard]

We are using RDS from Amazon.

 

[Mike]

Ahh, I wonder if that is an RDS specific error code. You may need to contact Amazon directly for further information on what it means.