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

Error while sending STMT_CLOSE packet [3.8.1-b1] #14012

Closed
robles-design opened this issue Jan 23, 2019 · 11 comments
Closed

Error while sending STMT_CLOSE packet [3.8.1-b1] #14012

robles-design opened this issue Jan 23, 2019 · 11 comments
Labels
worksforme The issue cannot be reproduced and things work as intended.

Comments

@robles-design
Copy link

Hello,

I'm getting the following error in my php-logs since version 3.8. I've updated to 3.8.1-b1, but the error is still there:
[PHP Warning: Error while sending STMT_CLOSE packet. PID=20377 in /www/htdocs/piwik/libs/Zend/Db/Statement/Mysqli.php on line 105

Best regards
Robert

@fdellwing
Copy link
Contributor

Please take a look at your PHP error log and your MySQL error log.

@robles-design
Copy link
Author

This is my php error log created via .htaccess. It's a shared host I don't have access to the real logs.

@tsteur
Copy link
Member

tsteur commented Jan 23, 2019

I don't think we can do much here. Looks like some DB issue to me. Has this happened before? For how long have you been using Matomo? Did it happen with 3.8.0?

@robles-design
Copy link
Author

Yes, as I mentioned in my first post I'm getting the error since 3.8. That's why I updated to 3.8.1-b1 yesterday. There are some new errors now (3 times):
Error in Matomo: Zend_Session is currently marked as read-only.

There weren't any errors before version 3.8. I noticed the errors yesterday, because there were some Ooops warnings in the front end and I took a look in the logs. After the update to 3.8.1-b1 the Ooops warnings popped up two or three times again. Then I deleted all tmp files in the matomo directory and the Ooops warnings are gone now, but the errors in the php error log are still rising. Last one from 23-Jan-2019 17:40:04, German timezone.

@tsteur
Copy link
Member

tsteur commented Jan 24, 2019

@diosmosis do you maybe have any ideas? not sure how this could happen and whether it is related to us. Wondering if it's due to changing the Dbtable session adapter or some general session work.

@tsteur
Copy link
Member

tsteur commented Jan 24, 2019

I reckon maybe the Error in Matomo: Zend_Session is currently marked as read-only. errors are unrelated. Not sure.

@diosmosis
Copy link
Member

@tsteur found this comment in another project: walkor/workerman#357 (comment) seems to suggest the problem occurs because something closes the connection and then php tries to close it itself. Possibly done at the end of a request?

@robles-design might be helpful to contact the web host in this case, though it is strange it would start happening after an update.

@robles-design
Copy link
Author

robles-design commented Jan 24, 2019

Ok, the good news: no new errors in the php error log since yesterday. Last one was Error in Matomo: Zend_Session is currently marked as read-only.

The bad news: it all starts again. Maybe it's related with the A/B-testing plugin, because the Oops warnings popped up first in one of the A/B tests, is there again and stays there even after a reload (see screenshot from today). It displays new entries in the overview.
matomo-ab-test-oops

Then going to the admin page I get this messages:
WARNING: /www/htdocs/piwik/core/DataTable/Row.php(623): Warning - Cannot use a scalar value as an array - Matomo 3.8.1-b1 - Please report this message in the Matomo forums: https://forum.matomo.org (please do a search first as it might have been reported already)

After a reload the admin messages are gone.

Matomo-Version: 3.8.1-b1
MySQL-Version: 5.7.21-nmm1-log
PHP-Version: 7.2.13-nmm1

@robles-design
Copy link
Author

No more errors in the php error log since 23-Jan-2019, but the A/B-testing plugin doesn't work (see last post). Any ideas?

@robles-design
Copy link
Author

robles-design commented Jan 28, 2019

Update: Since yesterday the A/B-testing plugin is working again, no more Oops warnings, nothing changed. Today I've updated to Matomo 3.8.1 and all works fine.

Thanks for your support. You can close this ticket now.

@tsteur
Copy link
Member

tsteur commented Jan 28, 2019

Awesome glad it works now 👍 feel free to contact us directly through shop at innocraft.com if you otherwise experience any trouble re a/b testing.

@tsteur tsteur added the worksforme The issue cannot be reproduced and things work as intended. label Jan 28, 2019
@mattab mattab closed this as completed Jan 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

5 participants