# SQLSTATE\[HY000\] 1205 Lock wait timeout exceeded
**URL:** https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278
**Category:** Shopware 3.5
**Tags:** general
**Created:** [11. Juli 2014 um 11:32 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278 "2014-07-11T11:32:17Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@dewib](https://forum.shopware.com/u/dewib)
#### Post date: [11. Juli 2014 um 11:32 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278/1 "2014-07-11T11:32:17Z")
Hallo, ich bekomme immer mal wieder (beinahe täglich) folgende Fehlermeldung: `[2014-07-11 11:08:46] core.ERROR: exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /www/htdocs/w00e7113/oberland.la/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:854 Stack trace: #0 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(854): PDOStatement-\>execute() #1 /www/htdocs/w00e7113/oberland.la/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(481): Doctrine\DBAL\Connection-\>executeUpdate('UPDATE s\_blog S...', Array, Array) #2 /www/htdocs/w00e7113/oberland.la/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(369): Doctrine\ORM\Persisters\BasicEntityPersister-\>updateTable(Object(Shopware\Models\Blog\Blog), 's\_blog', Array, NULL) #3 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1000): Doctrine\ORM\Persisters\BasicEntityPersister-\>update(Object(Shopware\Models\Blog\Blog)) #4 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(341): Doctrine\ORM\UnitOfWork-\>executeUpdates(Object(Doctrine\ORM\Mapping\ClassMetadata)) #5 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork-\>commit(Object(Shopware\Models\Blog\Blog)) #6 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Controllers/Frontend/Blog.php(319): Doctrine\ORM\EntityManager-\>flush(Object(Shopware\Models\Blog\Blog)) #7 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Blog-\>detailAction() #8 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('detailAction') #9 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #11 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /www/htdocs/w00e7113/oberland.la/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'UPDATE s\_blog SET views = ? WHERE id = ?' with params [332, 11]: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /www/htdocs/w00e7113/oberland.la/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(863): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'UPDATE s\_blog S...', Array) #1 /www/htdocs/w00e7113/oberland.la/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(481): Doctrine\DBAL\Connection-\>executeUpdate('UPDATE s\_blog S...', Array, Array) #2 /www/htdocs/w00e7113/oberland.la/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(369): Doctrine\ORM\Persisters\BasicEntityPersister-\>updateTable(Object(Shopware\Models\Blog\Blog), 's\_blog', Array, NULL) #3 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1000): Doctrine\ORM\Persisters\BasicEntityPersister-\>update(Object(Shopware\Models\Blog\Blog)) #4 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(341): Doctrine\ORM\UnitOfWork-\>executeUpdates(Object(Doctrine\ORM\Mapping\ClassMetadata)) #5 /www/htdocs/w00e7113/oberland.la/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork-\>commit(Object(Shopware\Models\Blog\Blog)) #6 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Controllers/Frontend/Blog.php(319): Doctrine\ORM\EntityManager-\>flush(Object(Shopware\Models\Blog\Blog)) #7 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Blog-\>detailAction() #8 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('detailAction') #9 /www/htdocs/w00e7113/oberland.la/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #11 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #15 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/w00e7113/oberland.la/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /www/htdocs/w00e7113/oberland.la/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /www/htdocs/w00e7113/oberland.la/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} [] []` Weiß jemand woran das liegen könnte? Habe bereits den Parameter „innodb\_lock\_wait\_timeout“ von 50 auf 100 Sekunden verdoppelt, aber das bringt nicht wirklich eine Verbesserung.
---
### Author:  [@dewib](https://forum.shopware.com/u/dewib)
#### Post date: [18. Juli 2014 um 21:19 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278/2 "2014-07-18T21:19:35Z")
Niemand eine Idee?
---
### Author:  [@donderda](https://forum.shopware.com/u/donderda)
#### Post date: [26. Januar 2017 um 07:16 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278/3 "2017-01-26T07:16:31Z")
Ich wühle den Thread mal wieder hoch, wir bekommen eine ähnliche Fehlermeldung. Hat jemand eine Idee, wie das gefixt werden könnte?
---
### Author:  [@Misengo](https://forum.shopware.com/u/Misengo)
#### Post date: [21. März 2017 um 08:34 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278/4 "2017-03-21T08:34:23Z")
Same here. Jemand ne Idee?
---
### Author:  [@hth](https://forum.shopware.com/u/hth)
#### Post date: [21. März 2017 um 09:00 UTC](https://forum.shopware.com/t/sqlstate-hy000-1205-lock-wait-timeout-exceeded/21278/5 "2017-03-21T09:00:38Z")
Um die Inetgrität der Datenbank zu gewährleisten, können nicht zwei unabhängige Prozesse parallel Schreibzugriffe auf eine Tabelle durchführen. Einer der Prozesse muss warten. Übersteigt die Wartezeit den in der DB-Konfiguration eingestellten Time-Out-Wert, entsteht dieser Fehler.
Falls ein Prozess - von Shopware oder einem Plugin oder z. B. einem DB-Backup des Hosting - regelmäßig einfriert, kann man dies in Mysql-Konsole mit Show processlist versuchen einzugrenzen.
Alternativ kann man den Time-Out-Wert des Mysql-Servers hoch setzen. In den Default-Einstellungen ist der Time-Out relaiv hoch, tritt dieser Fehlertyp dennoch häufiger auf, ist es wahrscheinlich am sinnvollsten auf leistungsfähigeres System zu setzen.