Error Core on NC 10.0.1

ℹ️ Support
1

Hi there,

Any idea how to fix this ?
Multiple times this error on:

  • NC 10.0.1
  • Ubuntu 14.4
  • Apache 5.5.9
  • MySQL 5.5.49

Exception: {“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing ‘SELECT uid, displayname FROM ufpusers WHERE LOWER(uid) = LOWER(?)’ with params [“admin”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:0,“Trace”:"#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))\n#1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(175): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT uid, `…’, Array)\n#2 /var/www/owncloud/lib/private/legacy/db/statementwrapper.php(74): Doctrine\DBAL\Statement->execute(Array)\n#3 /var/www/owncloud/lib/private/User/Database.php(233): OC_DB_StatementWrapper->execute(Array)\n#4 /var/www/owncloud/lib/private/User/Database.php(280): OC\User\Database->loadUser(‘admin’)\n#5 /var/www/owncloud/lib/private/User/Manager.php(140): OC\User\Database->userExists(‘admin’)\n#6 /var/www/owncloud/lib/private/User/Session.php(197): OC\User\Manager->get(‘admin’)\n#7 /var/www/owncloud/lib/private/L10N/Factory.php(132): OC\User\Session->getUser()\n#8 /var/www/owncloud/lib/private/legacy/l10n.php(313): OC\L10N\Factory->findLanguage(‘search’)\n#9 /var/www/owncloud/lib/private/legacy/util.php(511): OC_L10N::findLanguage(‘search’)\n#10 /var/www/owncloud/lib/private/legacy/util.php(484): OC_Util::addTranslations(‘search’)\n#11 /var/www/owncloud/lib/private/legacy/template.php(136): OC_Util::addScript(‘search’, ‘search’, true)\n#12 /var/www/owncloud/lib/private/legacy/template.php(74): OC_Template::initTemplateEngine(‘error’)\n#13 /var/www/owncloud/lib/private/legacy/template.php(347): OC_Template->__construct(’’, ‘exception’, ‘error’, false)\n#14 /var/www/owncloud/remote.php(83): OC_Template::printExceptionErrorPage(Object(Doctrine\DBAL\Exception\DriverException))\n#15 /var/www/owncloud/remote.php(168): handleException(Object(Doctrine\DBAL\Exception\DriverException))\n#16 {main}",“File”:"/var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",“Line”:116}

2

Hi,

What are the results for the functionality of NC? What does still work and what doesn’t?

The part of the error message that sticks out for me is:
General error: 2006 MySQL server has gone away

On https://dev.mysql.com/doc/refman/5.7/en/gone-away.html it reads:

B.5.2.9 MySQL server has gone away

      This section also covers the related Lost connection
      to server during query error.
    
      The most common reason for the MySQL server has gone
      away error is that the server timed out and closed
      the connection. In this case, you normally get one of the
      following error codes (which one you get is operating
      system-dependent).

Error Code | Description
CR_SERVER_GONE_ERROR | The client couldn’t send a question to the server.
CR_SERVER_LOST | The client didn’t get an error when writing to the server, but it didn’t get a full answer (or any answer) to the question.

3

Hi,
NC crashes and needs to be rebooted.
It happens when I use the Bookmark feature from the browser. But not only, but systematically with this bookmarking feature.
It usually does not prevent the bookmark to be recorded.
Thanks for your help,
n.

4

NC can’t connect to the database any more. This can have many reasons (database doesn’t have enough memory, max. connections is reached, …). Please check your database logfiles, use script such as tuning-primer.sh to check your configuration settings against the runtime variables (it gives you hints if you have set too low or too large limits).