Oops… there was a problem during the request (error reading communication packets)


(Joao Araujo) #1

Hi Piwik Community,

I have seen some people having this or similar problems but i still can’t find a solution for the following issue.

I am testing Piwik 2.15 on my local website (localhost) and I’m getting a MySQL error:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away - caused by plugin Actions in the Visits Over Time board

followed by several “Oops…” errors in most of the boards (Length of Visits, Referrer Websites, Visits by Server Time, Goals Overview, Visitor Browser, Search Engines) which I believe being the same errors as before.

The MySQL error log shows:
2016-01-04T14:18:05.716081Z 212 [Note] Aborted connection 212 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:05.757111Z 213 [Note] Aborted connection 213 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:05.764115Z 214 [Note] Aborted connection 214 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:05.836166Z 216 [Note] Aborted connection 216 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:05.852178Z 211 [Note] Aborted connection 211 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:05.989274Z 217 [Note] Aborted connection 217 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:07.506346Z 218 [Note] Aborted connection 218 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)
2016-01-04T14:18:07.553384Z 219 [Note] Aborted connection 219 to db: ‘piwik’ user: ‘sa’ host: ‘localhost’ (Got an error reading communication packets)

As for the MySQL general log, we can see it is populating the tables as it should (eg. when I refresh the website):

2016-01-04T14:39:40.696943Z 249 Query INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, idaction_url, idaction_url_ref, idaction_name_ref, server_time, time_spent_ref_action, idaction_name, custom_float) VALUES (‘4’,‘1’,’-éeøó\0³Ž’,‘3’,‘0’,‘0’,‘2016-01-04 14:39:39’,‘0’,‘2’,‘63’)
2016-01-04T14:39:40.825010Z 249 Quit

After some reading around here, if have set the:
max_allowed_packet=1024M on my.ini
wait_timeout=999999 on my.ini
memory_limit=1024M on php.ini

I can also see that some boards only show the error if set the date for today - which is my goal for testing purposes.

I am using:
Windows Server 2012
IIS 8
PHP 7
MySQL 5.7
Latest Chrome / Firefox

Can you help me with this?

Thank you!
J


(Matthieu Aubry) #2

Hi there,

this bug was fixed in our latest beta. please ugprade to latest beta! I would like to test early beta and RC releases, how do I enable automatic updates to use these development versions? - Analytics Platform - Matomo