1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Storage Engine Error 188

Discussion in 'Troubleshooting and Problems' started by TheComputerGuy, Oct 20, 2015.

  1. TheComputerGuy

    TheComputerGuy Active Member

    I'm getting the following error
    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!

     
  2. Mike

    Mike XenForo Developer Staff Member

    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?
     
  3. TheComputerGuy

    TheComputerGuy Active Member

    Code:
    #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}
    
    Code:
    #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}
     
  4. Mike

    Mike XenForo Developer Staff Member

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

    TheComputerGuy Active Member

    We are using RDS from Amazon.
     
  6. Mike

    Mike XenForo Developer Staff Member

    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.
     

Share This Page