Hi,
I have installed nextcloud 13.0.4 (centos 7, apache 2.4.27 + php 7.1 (mod_php) + mariadb-server-5.5.53). It works but I see intermittent but persistent errors in logs like this:
[Wed Jun 13 15:28:01.356154 2018] [php7:error] [pid 9000] [client 10.200.204.127:50439] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105\nStack trace:\n#0 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute(NULL)\n#1 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1006): Doctrine\DBAL\Driver\PDOStatement->execute()\n#2 /var/www/html/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate(āUPDATE oc_file...', Array, Array)\n#3 /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\\DB\\Connection->executeUpdate('UPDATE
oc_fileā¦ā, Array, Array)\n#4 /var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()\n#5 /var/www/html/nextcloud/lib/private/Lock/DBLockingProvider.php(280): OC\DB\QueryBuilder\Qu in /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 115
Additional config info:
- default-storage-engine = INNODB
- transaction_isolation = READ-COMMITTED
- binlog_format=row (I cannot disable binlog because I am using a master/slave mariadb cluster)
- ldap authentication
The requests causing theses errors seem to be always requests like this:
UPDATE oc_file_locks
SET lock
= lock
-1 WHERE (key
IN (āfiles/ad7a5fc3ac762b0184ff05cd4a8f7e1aā, āfiles/4aa8bdd3dfd2a72345818e66951d7240ā, āfiles/978b7f1854a93cea27b9e58460b8c1c5ā, āfiles/a619516dc0706358f266e873ab1eef97ā, āfiles/15b5a6c7abf6be5211c23f64b6c11988ā, āfiles/42eb610ac323c7c99208f787e3ab7eb7ā, āfiles/4e66c81f48a454bbe868f3f2b2ba2fa4ā, āfiles/ded8b5e5380bc55643d0d710aa1ab07aā, āfiles/ff7ea957c98f5ae3669ab20f5011098cā, āfiles/97d4b810deb1644f153122b347bab0ecā))
(I see that with āSHOW ENGINE INNODB STATUSā request).
I am the only user for now (cronjobs are also configured using crontab). I am just testing basic nextcloud feature using the web interface. I have seen these bug reports which may be related:
Do you have any suggestion?
Thanks in advance,
Mathieu