spatie/fork - Concurency Broken - v1.2.4 => v1.2.5

[sadiqsalau]

Laravel Version

12.12.0

PHP Version

8.3.20

Database Driver & Version

mariadb Ver 15.1 Distrib 10.6.21-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

Description

I'm using spatie/fork as the driver for concurrency in laravel, I started noticing severe crashes in scheduled tasks that uses concurrency e.g PDO errors, at first I thought it was an issue with my code, did a lot of refactoring, but still got the same problems.

Finally I decided to downgraded packages, I downgraded spatie/fork to v1.2.4 and everything started working as usual, in order to confirm that this was the issue, I upgraded and downgraded again. Same results, v1.2.5 errors, v1.2.4 stable.

v1.2.5

[2025-05-02 15:10:15] production.ERROR: SQLSTATE[HY093]: Invalid parameter number (Connection: mariadb, SQL: select * from `accounts` where exists (select * from `subscriptions` where `accounts`.`user_id` = `subscriptions`.`user_id` and `status` = active and `ends_at` > 2025-05-02 15:10:15)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: HY093): SQLSTATE[HY093]: Invalid parameter number (Connection: mariadb, SQL: select * from `accounts` where exists (select * from `subscriptions` where `accounts`.`user_id` = `subscriptions`.`user_id` and `status` = active and `ends_at` > 2025-05-02 15:10:15))

Another error

SQLSTATE[HY093]: Invalid parameter number (Connection: mysql, SQL: select * from `farmers` where `id` = 77 limit 1)

v1.2.4

Everything went back to normal, why is it messing with PDO and mysql, what changed...

I have decided to go through the diff and I discovered the culprit..

https://github.com/spatie/fork/blob/0fe5055b39d4043c39cfe97e201e76d364424a55/src/Fork.php#L136

The function call:

posix_kill(getmypid(), SIGKILL); 

After the introduction of this, things started crashing...

Steps To Reproduce

Simply running queries with bindings inside a background process.

[AndrewMast]

Shouldn't this issue be opened on the spatie/fork repository?

[crynobone]

Hey there, thanks for reporting this issue.

We'll need more info and/or code to debug this further. Can you please create a repository with the command below, commit the code that reproduces the issue as one separate commit on the main/master branch and share the repository here?

Please make sure that you have the latest version of the Laravel installer in order to run this command. Please also make sure you have both Git & the GitHub CLI tool properly set up.

laravel new bug-report --github="--public"

Do not amend and create a separate commit with your custom changes. After you've posted the repository, we'll try to reproduce the issue.

Thanks!

[macropay-solutions]

posix_kill(getmypid(), SIGKILL);

posix required for correct handling of process termination for Alpine Linux.

Can you confirm you have this module @sadiqsalau ?

[sadiqsalau]

I have finally discovered this is an issue with laravel itself not spatie, I will try to create a demo repository..

Well written queries throws bindings error..

[crynobone]

Hey there,

We're closing this issue because it's inactive, already solved, old, or not relevant anymore. Feel free to open up a new issue if you're still experiencing this problem.