Error server side Apache2 and sync problems


#1

Hi friends,
I have some problem with the sync between two computers Linux Ubuntu 14.04.

On Apache error log I can see many errors as this one:

[Wed Jul 05 17:49:23.511533 2017] [:error] [pid 30357] [client 79.60.53.47:59455] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91\nStack trace:\n#0 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(NULL)\n#1 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/owncloud/lib/private/DB/Connection.php(209): Doctrine\\DBAL\\Connection->executeUpdate('UPDATEoc_file...', Array, Array)\n#3 /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('UPDATE *PREFIX...', Array, Array)\n#4 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/owncloud/lib/private/Lock/DBLockingProvider.php(277): OC\\DB\\QueryBuilder\\QueryBuilder->execute in /var/www/owncloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 115

And

[Wed Jul 05 17:54:06.090953 2017] [:error] [pid 30357] [client 79.60.53.47] ModSecurity: Error reading request body: Partial results are valid but processing is incomplete [hostname "www.teatroscientifico.com"] [uri "/owncloud/remote.php/webdav/CHIAVETTA/AGGIORNATI/Documenti Jana/Teatro Scientifico/CARNET VERONA/2017/MARZO 2017 al Teatro Laboratorio.odt-chunking-4164290425-2-0"] [unique_id "WV0Lkn8AAQEAAHaVHgMAAAAJ"]

Could it depend on these errors?

many thanks


#2

Hi

What version of owncloud are you running? More info about your setup would be great


#3

Hi Dmitry and thanks for your help!

I had solved this issues some time ago.
The problem was generated following a provider (and Owncloud version) change.

For solve I've followed this post

Thanks!


#4

Thanks for the feedback and for providing the solution