punkch
commented
4 years ago I am experiencing similar issue from several days now, but I though it has something to do with my mysql setup.
I first noticed it with the craft_queue table, then I increased the innodb_lock_wait_timeout to 120 (default is 50). I've stopped seeing the issue with craft_queue, but it started with craft_elements and craft_structureelements.
I have tried to repair table and indexes by executing i.e. ALTER TABLE craft_elements ENGINE=InnoDB with no joy.
At the moment, I have the innodb_lock_wait_timeout set to 500 and haven't seen the error for about one hour.
Let me know if I can provide you with more information.
Stacktrace of the error:
2019-10-15 10:45:38 [-][68][-][error][yii\db\Exception] PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction in /var/www/vendor/yiisoft/yii2/db/Command.php:1290
Stack trace:
#0 /var/www/vendor/yiisoft/yii2/db/Command.php(1290): PDOStatement->execute()
#1 /var/www/vendor/yiisoft/yii2/db/Command.php(1091): yii\db\Command->internalExecute('UPDATE `craft_e...')
#2 /var/www/vendor/yiisoft/yii2/db/ActiveRecord.php(332): yii\db\Command->execute()
#3 /var/www/vendor/yiisoft/yii2/db/BaseActiveRecord.php(810): yii\db\ActiveRecord::updateAll(Array, Array)
#4 /var/www/vendor/yiisoft/yii2/db/ActiveRecord.php(676): yii\db\BaseActiveRecord->updateInternal(NULL)
#5 /var/www/vendor/yiisoft/yii2/db/BaseActiveRecord.php(681): yii\db\ActiveRecord->update(false, NULL)
#6 /var/www/vendor/craftcms/cms/src/services/Elements.php(1912): yii\db\BaseActiveRecord->save(false)
#7 /var/www/vendor/craftcms/cms/src/services/Elements.php(488): craft\services\Elements->_saveElementInternal(Object(craft\elements\Entry), true, false)
#8 /var/www/vendor/craftcms/cms/src/controllers/EntryRevisionsController.php(224): craft\services\Elements->saveElement(Object(craft\elements\Entry))
#9 [internal function]: craft\controllers\EntryRevisionsController->actionSaveDraft()
#10 /var/www/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#11 /var/www/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#12 /var/www/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('save-draft', Array)
#13 /var/www/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('save-draft', Array)
#14 /var/www/vendor/craftcms/cms/src/web/Application.php(299): yii\base\Module->runAction('entry-revisions...', Array)
#15 /var/www/vendor/craftcms/cms/src/web/Application.php(566): craft\web\Application->runAction('entry-revisions...', Array)
#16 /var/www/vendor/craftcms/cms/src/web/Application.php(278): craft\web\Application->_processActionRequest(Object(craft\web\Request))
#17 /var/www/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
#18 /var/www/web/index.php(28): yii\base\Application->run()
#19 {main}
Next yii\db\Exception: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
The SQL being executed was: UPDATE `craft_elements` SET `draftId`=1761, `fieldLayoutId`=29, `enabled`=1, `archived`=0, `dateUpdated`='2019-10-15 08:43:37' WHERE `id`=38514 in /var/www/vendor/yiisoft/yii2/db/Schema.php:664
Stack trace:
#0 /var/www/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'UPDATE `craft_e...')
#1 /var/www/vendor/yiisoft/yii2/db/Command.php(1091): yii\db\Command->internalExecute('UPDATE `craft_e...')
#2 /var/www/vendor/yiisoft/yii2/db/ActiveRecord.php(332): yii\db\Command->execute()
#3 /var/www/vendor/yiisoft/yii2/db/BaseActiveRecord.php(810): yii\db\ActiveRecord::updateAll(Array, Array)
#4 /var/www/vendor/yiisoft/yii2/db/ActiveRecord.php(676): yii\db\BaseActiveRecord->updateInternal(NULL)
#5 /var/www/vendor/yiisoft/yii2/db/BaseActiveRecord.php(681): yii\db\ActiveRecord->update(false, NULL)
#6 /var/www/vendor/craftcms/cms/src/services/Elements.php(1912): yii\db\BaseActiveRecord->save(false)
#7 /var/www/vendor/craftcms/cms/src/services/Elements.php(488): craft\services\Elements->_saveElementInternal(Object(craft\elements\Entry), true, false)
#8 /var/www/vendor/craftcms/cms/src/controllers/EntryRevisionsController.php(224): craft\services\Elements->saveElement(Object(craft\elements\Entry))
#9 [internal function]: craft\controllers\EntryRevisionsController->actionSaveDraft()
#10 /var/www/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#11 /var/www/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#12 /var/www/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('save-draft', Array)
#13 /var/www/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('save-draft', Array)
#14 /var/www/vendor/craftcms/cms/src/web/Application.php(299): yii\base\Module->runAction('entry-revisions...', Array)
#15 /var/www/vendor/craftcms/cms/src/web/Application.php(566): craft\web\Application->runAction('entry-revisions...', Array)
#16 /var/www/vendor/craftcms/cms/src/web/Application.php(278): craft\web\Application->_processActionRequest(Object(craft\web\Request))
#17 /var/www/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
#18 /var/www/web/index.php(28): yii\base\Application->run()
#19 {main}
Additional Information:
Array
(
[0] => HY000
[1] => 1205
[2] => Lock wait timeout exceeded; try restarting transaction
)
"
Show matching entries
Hide matching entries
Add field to summary line
timestamp: "2019-10-15T08:45:38.925367Z"
}Additional info
- Craft version: 3.3.7 & 3.3.9
- PHP version: 7.3.9
- Database driver & version: MySQL 5.7.14 (Google Cloud SQL with replication and sql_mode=TRADITIONAL)
- Plugins: heavy use of Neo v2.5.4
mdominguez
angrybrad
brandonkelly
mtwalsh
aaronbushnell
Description
Unable to get passed the admin login screen after logging in with the correct credentials. Error looks like it has something to do with the queue table.
Screenshot of the queue table: screenshot (is the amount of rows here normal?)
If you need our db, tell me where to send it :)
This is the exact error in Bugsnag:
Additional info