Hi
I have a running Matomo instance since years. I have updated it few weeks ago I think for the latest time (not sure of running version right now due to the problem explained below).
I have not logged into the admin interface since a month I think. Now when I try to access it, I get that error:
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement/Pdo.php:233 Stack trace: #0 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement/Pdo.php(233): PDOStatement->execute() #1 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO mat...', Array) #4 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/core/Session/SaveHandler/DbTable.php(124): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO mat...', Array) #5 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/core/Session/SaveHandler/DbTable.php(158): Piwik\Session\SaveHandler\DbTable->query('INSERT INTO mat...', Array) #6 [internal function]: Piwik\Session\SaveHandler\DbTable->write('b0ee382a8987004...', 'a:1:{s:4:"data"...') #7 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Session.php(718): session_write_close() #8 [internal function]: Zend_Session::writeClose(true) #9 {main} Next Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement/Pdo.php:236 Stack trace: #0 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO mat...', Array) #3 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/core/Session/SaveHandler/DbTable.php(124): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO mat...', Array) #4 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/core/Session/SaveHandler/DbTable.php(158): Piwik\Session\SaveHandler\DbTable->query('INSERT INTO mat...', Array) #5 [internal function]: Piwik\Session\SaveHandler\DbTable->write('b0ee382a8987004...', 'a:1:{s:4:"data"...') #6 /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Session.php(718): session_write_close() #7 [internal function]: Zend_Session::writeClose(true) #8 {main} thrown in /home/clients/4b960358965e0fb89c78a755b1dbfcbf/sites/matomo.mydomain.com/libs/Zend/Db/Statement/Pdo.php on line 236
Matomo still logs properly the visits on website registered in it as I can see the stats changing through the API.
The hoster confirms there was no change in their infrastructure and that everything runs fine on their side. They state it might a timeout in SQL request done by matomo or in PHP.
The db size is nearly 200M.
I have done some searches on Internet but nothing helped so far.
Any suggestions ? Thanks
Vincèn