ZfExtended_Log on dfki.translate5.net: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

XMLWordPrintable

    • Type: Bug
    • Resolution: Cannot Reproduce
    • None
    • Affects Version/s: None
    • Component/s: None
    • Environment:

      On dfki.t5.net occured a DB dead lock.
      See also:

      More current traceback:

      Betreff: 	Portal_Log on www.beo-doc.de: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try r
Datum: 	Tue, 25 Nov 2014 13:32:47 +0100
Von: 	beoSphere <portal@beo-doc.de>
An: 	beoSphere <portal@beo-doc.de>


Portal_Log on www.beo-doc.de: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `LEK_task` SET `lockingUser` = ?, `locked` = ?, `lockedInternalSessionUniqId` = ? WHERE (not locked is null and (lockedInternalSessionUniqId not in (select internalSessionUniqId from sessionMapInternalUniqId m, session s  where s.modified + lifetime >= UNIX_TIMESTAMP() and s.session_id = m.session_id) or lockedInternalSessionUniqId is null))



#0 /usr/share/php/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /usr/share/php/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `LEK_tas...', Array)
#3 /usr/share/php/Zend/Db/Adapter/Abstract.php(635): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `LEK_tas...', Array)
#4 /usr/share/php/Zend/Db/Table/Abstract.php(1133): Zend_Db_Adapter_Abstract->update('LEK_task', Array, 'not locked is n...')
#5 /var/www/html/portal-3.0.27/application/modules/editor/Models/Task.php(486): Zend_Db_Table_Abstract->update(Array, 'not locked is n...')
#6 /var/www/html/portal-3.0.27/application/modules/editor/Controllers/TaskController.php(135): editor_Models_Task->cleanupLockedJobs()
#7 /usr/share/php/Zend/Controller/Action.php(516): editor_TaskController->indexAction()
#8 /var/www/html/portal-3.0.27/library/ZfExtended/Controllers/RestController.php(174): Zend_Controller_Action->dispatch('indexAction')
#9 /usr/share/php/Zend/Controller/Dispatcher/Standard.php(308): ZfExtended_RestController->dispatch('indexAction')
#10 /usr/share/php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /usr/share/php/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()
#12 /usr/share/php/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /var/www/html/portal-3.0.27/library/ZfExtended/BaseIndex.php(167): Zend_Application->run()
#14 /var/www/html/portal-3.0.27/public/index.php(10): ZfExtended_BaseIndex->startApplication()
#15 {main}



Eingeloggter User:

object(ArrayObject)#399 (1) {
  ["storage":"ArrayObject":private]=>
  array(19) {
    ["data"]=>
    object(stdClass)#258 (12) {
      ["id"]=>
      string(4) "1692"
      ["userGuid"]=>
      string(38) "{0BDE4CCC-D222-6C87-3D41-CC83F6A73CB4}"
      ["firstName"]=>
      string(4) "Test"
      ["surName"]=>
      string(4) "Demo"
      ["gender"]=>
      string(1) "m"
      ["login"]=>
      string(22) "xxxxxx
      ["email"]=>
      string(22) "xxxxxx"
      ["editable"]=>
      string(1) "1"
      ["locale"]=>
      string(2) "de"
      ["roles"]=>
      array(5) {
        [0]=>
        string(21) "writeOfferAndProjects"
        [1]=>
        string(6) "editor"
        [2]=>
        string(25) "accessExternalApplication"
        [3]=>
        string(5) "basic"
        [4]=>
        string(8) "noRights"
      }
      ["passwd"]=>
      string(8) "********"
      ["userName"]=>
      string(9) "Test Demo"
    }
    ["roles"]=>
    array(5) {
      [0]=>
      string(21) "writeOfferAndProjects"
      [1]=>
      string(6) "editor"
      [2]=>
      string(25) "accessExternalApplication"
      [3]=>
      string(5) "basic"
      [4]=>
      string(8) "noRights"
    }
    ["employeeId"]=>
    int(1692)
    ["employeeGUID"]=>
    string(38) "{0BDE4CCC-D222-6C87-3D41-CC83F6A73CB4}"
    ["locale"]=>
    string(2) "de"
    ["eMail"]=>
    string(22) "portal_demo@beo-doc.de"
    ["passwd"]=>
    string(32) "162ae68b6d8933f243b1c77827372111"
    ["companyId"]=>
    int(46)
    ["surname"]=>
    string(4) "Demo"
    ["firstname"]=>
    string(4) "Test"
    ["gender"]=>
    string(1) "m"
    ["seeAllProjects"]=>
    int(1)
    ["seeAllOffers"]=>
    int(1)
    ["seeAllInvoices"]=>
    int(1)
    ["userName"]=>
    string(9) "Test Demo"
    ["userGuid"]=>
    string(38) "{0BDE4CCC-D222-6C87-3D41-CC83F6A73CB4}"
    ["companyGUID"]=>
    string(38) "{7EDAEDC9-56BF-46A7-BD0A-EF2439A70D50}"
    ["companyName"]=>
    string(4) "demo"
    ["login"]=>
    string(22) "portal_demo@beo-doc.de"
  }
}
Aufgerufene URL inkl. ggf. vorhandener POST-Parameter als get-Parameter: 

/portal/public/editor/task/index/page/1/start/0/limit/20/format/json

      The traceback was as follows:

      ZfExtended_Log on dfki.translate5.net: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction


#0 /webs/web1870/html/zend/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /webs/web1870/html/zend/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /webs/web1870/html/zend/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `LEK_tas...', Array)
#3 /webs/web1870/html/zend/Zend/Db/Adapter/Abstract.php(633): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `LEK_tas...', Array)
#4 /webs/web1870/html/zend/Zend/Db/Table/Abstract.php(1120): Zend_Db_Adapter_Abstract->update('LEK_taskUserAss...', Array, Array)
#5 /webs/web1870/html/dfkiTranslate5Net/application/modules/editor/Models/TaskUserAssoc.php(312): Zend_Db_Table_Abstract->update(Array, Array)
#6 /webs/web1870/html/dfkiTranslate5Net/application/modules/editor/Controllers/TaskController.php(126): editor_Models_TaskUserAssoc->cleanupLocked()
#7 /webs/web1870/html/zend/Zend/Controller/Action.php(513): editor_TaskController->indexAction()
#8 /webs/web1870/html/dfkiTranslate5Net/library/ZfExtended/Controllers/RestController.php(150): Zend_Controller_Action->dispatch('indexAction')
#9 /webs/web1870/html/zend/Zend/Controller/Dispatcher/Standard.php(295): ZfExtended_RestController->dispatch('indexAction')
#10 /webs/web1870/html/zend/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(REST_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /webs/web1870/html/zend/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#12 /webs/web1870/html/zend/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /webs/web1870/html/dfkiTranslate5Net/library/ZfExtended/BaseIndex.php(174): Zend_Application->run()
#14 /webs/web1870/html/dfkiTranslate5Net/public/index.php(43): ZfExtended_BaseIndex->startApplication()
#15 {main}Aufgerufene URL inkl. ggf. vorhandener POST-Parameter als get-Parameter: 

/editor/task/index/page/1/start/0/limit/20/format/json

            Assignee:
            Unassigned
            Reporter:
            Marc Mittag [Administrator]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: