Deadlock Problem with mariadb:latest

[Tockra]

Hi,

this is related with #494 .
There seems to be problems with the latest mariadb image.

If you use mariadb:10.3 there is no problem, if you use mariadb:latest you get errors like in #494

Example Sync-Error:

 13.10.2018 11:56:10,                     Dreamedit/vusolose/userbouquet.dbe00.tv_org,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/vusolose/userbouquet.dbe00.tv_org - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424572, 223, "5ebc52ee3af39eb7ed1bdc98b38b0580", 1539424572, 27, 172, "", "a123a247800228731b5c866c1faf6075", "files\/Documents\/Dreamedit\/vusolose\/userbouquet.dbe00.tv_org", "userbouquet.dbe00.tv_org", 2, 2, "a123a247800228731b5c866c1faf6075"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:56:10,                     Dreamedit/vusolose/userbouquet.dbe00.tv_bak,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/vusolose/userbouquet.dbe00.tv_bak - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424572, 223, "b60a3ab2f6009c9c55f254875803c554", 1539424572, 27, 172, "", "11655efa200fc5fa8689c0525df6f678", "files\/Documents\/Dreamedit\/vusolose\/userbouquet.dbe00.tv_bak", "userbouquet.dbe00.tv_bak", 2, 2, "11655efa200fc5fa8689c0525df6f678"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:56:04,                         Dreamedit/settings/userbouquet.dbe01.tv,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/settings/userbouquet.dbe01.tv - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424566, 421, "530584ece3aab8cf5f3f74274a9fa8e2", 1539424566, 27, 170, "", "33f85ef5fb392da059a566c5cb9534ec", "files\/Documents\/Dreamedit\/settings\/userbouquet.dbe01.tv", "userbouquet.dbe01.tv", 2, 2, "33f85ef5fb392da059a566c5cb9534ec"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:56:04,                     Dreamedit/settings/userbouquet.dbe00.tv_org,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/settings/userbouquet.dbe00.tv_org - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424566, 910, "01fed0cfb71a7549006defcd1b493c47", 1539424566, 27, 170, "", "024bd2d60db2277376d9947a26d54869", "files\/Documents\/Dreamedit\/settings\/userbouquet.dbe00.tv_org", "userbouquet.dbe00.tv_org", 2, 2, "024bd2d60db2277376d9947a26d54869"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:56:04,                     Dreamedit/settings/userbouquet.dbe00.tv_bak,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/settings/userbouquet.dbe00.tv_bak - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424566, 223, "d54049de11efe3cf682241207422b20f", 1539424566, 27, 170, "", "3847fec493061deae47006353e713fa1", "files\/Documents\/Dreamedit\/settings\/userbouquet.dbe00.tv_bak", "userbouquet.dbe00.tv_bak", 2, 2, "3847fec493061deae47006353e713fa1"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:56:01,                                          Dreamedit/ssleay32.dll,            Nextcloud\Projekte,Error transferring http://homemedia/remote.php/dav/files/Tockra/Documents/Dreamedit/ssleay32.dll - server replied: Internal Server Error (An exception occurred while executing 'INSERT INTO `filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["3", "15", 1539424563, 357888, "5304c3c28e56defe419cc518fed1032c", 1539424563, 27, 139, "", "930664725c7e9957cd0e9a2c67af5f4e", "files\/Documents\/Dreamedit\/ssleay32.dll", "ssleay32.dll", 2, 2, "930664725c7e9957cd0e9a2c67af5f4e"]:

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)
 13.10.2018 11:55:57,                                                     Desktop.ini,            Nextcloud\Projekte,Die Datei ist in der Ignorierliste geführt.

[pierreozoux]

Do you think it is related to this docker image? (Looks like not) looks like related to either mariadb docker image or nextcloud php code.

[Tockra]

Yeah you are right, but I thought here is the better place, because I don't know which mariadb Version is used in the latest docker image ^^
But I think I should add this issue at the nextcloud github repo