SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: de...

[marvinroman]

Illuminate\Database\QueryException

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: delete from sessions where last_activity <= 1685150713)

🎯 Illuminate\Database\Connection::runQueryCallback
📄 /app/vendor/laravel/framework/src/Illuminate/Database/Connection.php

758  // lot more helpful to the developer instead of just the database's errors.
759  catch (Exception $e) {
760*     throw new QueryException(
761          $query, $this->prepareBindings($bindings), $e
762      );

Open in Flare

[marvinroman]

Add slow logging to database to help determine what is causing deadlocks.

[mysqld]
slow_query_log=1
long_query_time=0.1
log_queries_not_using_indexes=1

[flare-error-tracker]

Because you closed this issue the following error in Flare was marked as resolved: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: delete from sessions where last_activity <= 1685150713)

[jobara]

The related PR (#1782) that closed this was to add additional logging to determine the cause, not a fix for the issue.

[flare-error-tracker]

Because you reopened this issue the following error in Flare was reopened: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: delete from sessions where last_activity <= 1685150713)

[jobara]

Hasn't re-ocurred for a while.