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.

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

Wrong COM_STMT_PREPARE response size #14329

Closed
LiohMoeller opened this issue Apr 9, 2019 · 2 comments
Closed

Wrong COM_STMT_PREPARE response size #14329

LiohMoeller opened this issue Apr 9, 2019 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@LiohMoeller
Copy link

Sometimes when I try to connect or run the archiver I got an error like:

./console core:archive
WARNING [2019-04-09 11:40:15] 31996 /usr/share/nginx/html/libs/Zend/Db/Statement/Mysqli.php(70): Warning - Wrong COM_STMT_PREPARE response size. Received 1 - Matomo 3.9.1 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
WARNING [2019-04-09 11:40:15] 31996 /usr/share/nginx/html/libs/Zend/Db/Statement/Mysqli.php(70): Warning - Packets out of order. Expected 1 received 2. Packet size=79 - Matomo 3.9.1 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)
WARNING [2019-04-09 11:40:15] 31996 /usr/share/nginx/html/libs/Zend/Db/Statement/Mysqli.php(70): Warning - mysqli::prepare(): MySQL server has gone away - Matomo 3.9.1 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)

[Zend_Db_Statement_Mysqli_Exception]
Mysqli prepare error: MySQL server has gone away

When I re-run the archiver it works again after a while.

@fdellwing
Copy link
Contributor

This was a big issue a while ago in Laravel, but I never saw it in Matomo.

Could you take a closer look at your PHP error log and the mysql log?

@tsteur
Copy link
Member

tsteur commented Apr 9, 2019

Could we move this to the forum as the warning suggests? It sounds like some server configuration issue. Maybe this is of help? https://groups.google.com/forum/#!msg/codership-team/tMlZYnp3MC0/Om4QzBmqr4IJ or https://groups.google.com/forum/#!topic/proxysql/noyc-lI9gTk
Happy to reopen though if there's something to do in Matomo

@tsteur tsteur closed this as completed Apr 9, 2019
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Apr 9, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

3 participants