"Serialization failure" in laravel.log

Version ie

5.10.31

Environment

Docker

Describe the bug

I was looking the laravel.log file and found several “serialization failure” error codes. Is this something I should be concerned about? Is there a fix?

[2024-10-08 04:25:01] production.ERROR: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1728361501) or (`reserved_at` <= 1638361501)) order by `id` asc limit 1 for update) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1728361501) or (`reserved_at` <= 1638361501)) order by `id` asc limit 1 for update) at /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)

Hi,

I suggest creating a discussion on GitHub to ask this.

1 Like

Done, thanks for the suggestion, @hillel