Redis ingest with pulse:work on multiple server fails with SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock;

[MoishyTlushTakin]

Pulse Version

1.4.2

Laravel Version

12.0.9

PHP Version

8.3

Livewire Version

3.4.9

Database Driver & Version

Aws 8.0.mysql_aurora.3.08.2

Description

When deploy app on multiple ec2 instances and each run supervisor that run artisan pulse:work it fails due DB deadlock

Steps To Reproduce

Just run two pulse:work process at the same time with the same connection

[github-actions[bot]]

Thank you for reporting this issue!

As Laravel is an open source project, we rely on the community to help us diagnose and fix issues as it is not possible to research and fix every issue reported to us via GitHub.

If possible, please make a pull request fixing the issue you have described, along with corresponding tests. All pull requests are promptly reviewed by the Laravel team.

Thank you!