yii2-queue icon indicating copy to clipboard operation
yii2-queue copied to clipboard

yii\db\Exception: Packets out of order. Expected 1 received 0

Open uaoleg opened this issue 2 years ago • 0 comments

What steps will reproduce the problem?

Succesfully run a heavy job (about 10-20 mins)

What's expected?

Job is released (row is deleted from DB table)

What do you get instead?

yii\db\Exception: Packets out of order. Expected 1 received 0 at this point https://github.com/yiisoft/yii2-queue/blob/master/src/drivers/db/Queue.php#L226

Also after this error Yii2 Queue is trying to execute the job once again though canRetry() method always return false.

Additional info

Q A
Yii version 2.0.45
PHP version 7.4.3
MySQL version 8.0.28
Operating system Linux

uaoleg avatar Oct 08 '22 16:10 uaoleg