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
[3.0.0-b1] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away #10744
Comments
That sounds like your database server is crashing and restarted. What's your hosting type? |
My database server is done. It hosting by OVH Web hosting and I can connect to this database with phpmyadmin. |
Hello. I had same error messages (hosting by OVH). |
That not resolve my issue. I don't known what I can make to resolve this issue. |
It seems that this issue occurs only for "superusers", in attempt to load "administration page" or "profile page". In this case, PIWIK does not access quicky enough to the page and the error message appears. |
I confirm only "superuser" have this issue. Other users with "admin access" for all site have not this issue. |
Have you had a look at http://piwik.org/faq/troubleshooting/faq_183/ ? Maybe it helps to fix the issue. The queries look normal otherwise. |
I have seen this faq but I can't change my MYSQL configuration. Piwik Db was hosted on OVH web hosting. I have this issue only since 3.0.0-b1 upgrade. |
The traceback : #0 /home/perhonen/piwik/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/perhonen/piwik/core/Db/Adapter/Pdo/Mysql.php(241): Zend_Db_Statement->execute(Array) #2 /home/perhonen/piwik/libs/Zend/Db/Adapter/Abstract.php(827): Piwik\Db\Adapter\Pdo\Mysql->query('SELECT option_v...', 'apapillon2_defa...') #3 /home/perhonen/piwik/core/Db.php(259): Zend_Db_Adapter_Abstract->fetchOne('SELECT option_v...', 'apapillon2_defa...') #4 /home/perhonen/piwik/core/Option.php(179): Piwik\Db::fetchOne('SELECT option_v...', 'apapillon2_defa...') #5 /home/perhonen/piwik/core/Option.php(46): Piwik\Option->getValue('apapillon2_defa...') #6 /home/perhonen/piwik/plugins/UsersManager/API.php(175): Piwik\Option::get('apapillon2_defa...') #7 /home/perhonen/piwik/plugins/UsersManager/API.php(110): Piwik\Plugins\UsersManager\API->getPreferenceValue('apapillon2', 'defaultReport') #8 /home/perhonen/piwik/plugins/UsersManager/UserPreferences.php(65): Piwik\Plugins\UsersManager\API->getUserPreference('apapillon2', 'defaultReport') #9 /home/perhonen/piwik/plugins/UsersManager/UserPreferences.php(39): Piwik\Plugins\UsersManager\UserPreferences->getDefaultReport() #10 /home/perhonen/piwik/plugins/Goals/Menu.php(21): Piwik\Plugins\UsersManager\UserPreferences->getDefaultWebsiteId() #11 /home/perhonen/piwik/core/Menu/MenuAdmin.php(132): Piwik\Plugins\Goals\Menu->configureAdminMenu(Object(Piwik\Menu\MenuAdmin)) #12 /home/perhonen/piwik/core/Plugin/Controller.php(644): Piwik\Menu\MenuAdmin->getMenu() #13 /home/perhonen/piwik/plugins/CoreHome/Controller.php(165): Piwik\Plugin\Controller->setGeneralVariablesView(Object(Piwik\View)) #14 /home/perhonen/piwik/plugins/CoreHome/Controller.php(203): Piwik\Plugins\CoreHome\Controller->getDefaultIndexView() #15 [internal function]: Piwik\Plugins\CoreHome\Controller->index() #16 /home/perhonen/piwik/core/FrontController.php(518): call_user_func_array(Array, Array) #17 /home/perhonen/piwik/core/FrontController.php(122): Piwik\FrontController->doDispatch(NULL, NULL, NULL) #18 /home/perhonen/piwik/core/dispatch.php(34): Piwik\FrontController->dispatch() #19 /home/perhonen/piwik/index.php(27): require_once('/home/perhonen/...') #20 {main} |
I have max_allowed_packet = 16777216 and wait_timeout = 60. |
Does OVH not allow you to change this value? Try to email them, they might show you a way to do it, or can maybe change it for you? |
Hello
What is changed since? |
I totally agree with zebig. I made different tests :
I tested with copy of my database on another MySQL server with I think this issue come from Web server or PHP but not Mysql configuration. You can find my PHP info on : https://perhonen.fr/projects/info.php |
Ok I'm so sorry but now I don't have any issue on OVH web hosting with superuser but I don't know why. |
FYI it doesn't mask the reason of errors, but it actually solves the error properly here. what happens is your packet of data containing your piwik pre-processed reports is too big for the default value in MySQL. |
Since update to 3.0.0-b1, when I login, I got this error : SQLSTATE[HY000]: General error: 2006 MySQL server has gone away.
My SQL log :
The text was updated successfully, but these errors were encountered: