New errors after update to 9.0.6

9.0.x
help

#1

Hi,
since I've updated to 9.0.6, I have slowly response of myserver and a lot of errors in owncloud.log. This errors are new.

I have things like this :

n exception occurred while executing 'UPDATE oc_appconfig SET
configvalue = ? WHERE (appid = ?) AND (configkey = ?) AND
(configvalue <> ?)' with params ["510", "backgroundjob",
"lastjob", "510"]:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

and

Error PHP Error while sending QUERY packet. PID=42580 at
/var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91

or
whereas my sqld and apache are running well.

If anyone had a clue ? Or is there a way to revert back to the previous version ?

Thanks

Please help us by providing the following info. Before posting please also check the pinned "Known issues" threads and make sure that you're running the latest available version for your oC release: https://owncloud.org/changelog/

Steps to reproduce
Log after a user log in

Expected behaviour
Tell us what should happen

Actual behaviour
Owncloud errors

Server configuration
Operating system: centos6.7
Web server:Apache
Database:mysql
PHP version:5.5
ownCloud version (see ownCloud admin page):9.0.6
Updated from an older ownCloud or fresh install:update from 9.0.5 (official repo)
Special configuration (external storage, external authentication, reverse proxy, server-side-encryption):

LDAP connector
ownCloud log (data/owncloud.log)

An
exception occurred while executing 'UPDATE oc_appconfig SET
configvalue = ? WHERE (appid = ?) AND (configkey = ?) AND
(configvalue <> ?)' with params ["510", "backgroundjob",
"lastjob", "510"]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

			2016-11-23T10:11:57+01:00			



			Error			

			core			

			Error while running background job (class:

OCA\Files\BackgroundJob\ScanFiles, arguments: ):
{"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An
exception occurred while executing 'INSERT INTO oc_preferences
(userid, appid, configkey, configvalue) VALUES(?, ?, ?, ?)' with
params [\"ochr-e1m036\", \"user_ldap\", \"displayName\",
\"OCHR-e1m036\"]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server
has gone away","Code":0,"Trace":"#0
\/var\/www\/html\/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\/html\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(996):

Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),
Object(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO oc...',
Array)\n#2
\/var\/www\/html\/owncloud\/lib\/private\/db\/connection.php(205):
Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO
oc...',
Array, Array)\n#3
\/var\/www\/html\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php(208):
OC\DB\Connection->executeUpdate('INSERT INTO `*P...', Array,
Array)\n#4
\/var\/www\/html\/owncloud\/lib\/private\/db\/querybuilder\/querybuilder.php(141):
Doctrine\DBAL\Query\QueryBuilder->execute()\n#5
\/var\/www\/html\/owncloud\/lib\/private\/db\/connection.php(276):
OC\DB\QueryBuilder\QueryBuilder->execute()\n#6
\/var\/www\/html\/owncloud\/lib\/private\/allconfig.php(224):
OC\DB\Connection->setValues('preferences', Array, Array, Array)\n#7
\/var\/www\/html\/owncloud\/apps\/user_ldap\/lib\/user\/user.php(373):
OC\AllConfig->setUserValue('ochr-e1m036', 'user_ldap',
'displayName', 'OCHR-e1m036')\n#8
\/var\/www\/html\/owncloud\/apps\/user_ldap\/lib\/user\/user.php(388):
OCA\user_ldap\lib\user\User->store('displayName',
'OCHR-e1m036')\n#9
\/var\/www\/html\/owncloud\/apps\/user_ldap\/lib\/user\/user.php(182):
OCA\user_ldap\lib\user\User->composeAndStoreDisplayName('OCHR-e1m036')\n#10
\/var\/www\/html\/owncloud\/apps\/user_ldap\/lib\/access.php(734):
OCA\user_ldap\lib\user\User->processAttributes(Array)\n#11
\/var\/www\/html\/owncloud\/apps\/user_ldap\/lib\/access.php(706):
OCA\user_ldap\lib\Access->batchApplyUserAttributes(Array)\n#12
\/var\/www\/html\/owncloud\/apps\/user_ldap\/user_ldap.php(192):
OCA\user_ldap\lib\Access->fetchListOfUsers('(&(&(|(objectcl...',
Array, 500, NULL)\n#13
\/var\/www\/html\/owncloud\/lib\/private\/user\/manager.php(211):
OCA\user_ldap\USER_LDAP->getUsers('', 500, NULL)\n#14
\/var\/www\/html\/owncloud\/apps\/files\/lib\/backgroundjob\/scanfiles.php(104):
OC\User\Manager->search('', 500)\n#15
\/var\/www\/html\/owncloud\/lib\/private\/backgroundjob\/job.php(52):
OCA\Files\BackgroundJob\ScanFiles->run(NULL)\n#16
\/var\/www\/html\/owncloud\/lib\/private\/backgroundjob\/timedjob.php(53):
OC\BackgroundJob\Job->execute(Object(OC\BackgroundJob\JobList),
Object(OC\Log))\n#17 \/var\/www\/html\/owncloud\/cron.php(173):
OC\BackgroundJob\TimedJob->execute(Object(OC\BackgroundJob\JobList),
Object(OC\Log))\n#18
{main}","File":"\/var\/www\/html\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":115}

			2016-11-23T10:11:57+01:00			



			Error			

			PHP			

			Error while sending QUERY packet. PID=42580 at

/var/www/html/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php#91

Integrity status for oC9+

Login as admin user into your ownCloud and access
http://example.com/index.php/settings/integrity/failed
paste the results here.

#2

Hi,

there is a part in the documentation how to resolve such "mysql server gone away" messages:

https://doc.owncloud.org/server/latest/admin_manual/configuration_database/linux_database_configuration.html#how-to-workaround-general-error-2006-mysql-server-has-gone-away


#3

thanks realrancor for the link. The max_allowed_packet in my.cnf seems to be the faulty parameter.
Increasing it of 10% seems to do the trick.for the moment

I just don't understand the fact that it occurs just after the 9.0.6 update, this errors were not here last week. May be a coincidence with a higher usage of my server at the same moment, that's the magic of IT :slight_smile: