Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
uaoleg opened this issue Oct 8, 2022 · 2 comments
Open

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

uaoleg opened this issue Oct 8, 2022 · 2 comments

Comments

@uaoleg
Copy link

uaoleg commented Oct 8, 2022

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
@Simone-98
Copy link

Hi,
i have the same problem, if you found a solution, can you write here?
i do not undestand how to fix that,
Thanks

@uaoleg
Copy link
Author

uaoleg commented Nov 4, 2024

@Simone-98 no I didn't figure out a solution. You can try to use a different Queue driver

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@uaoleg @Simone-98