Exception: Doctrine\\DBAL\\Exception\\DriverException | cannot start web service

Let's say the the problem is something like this:
– erroneous parsing of a filepath
– therefore invalid file cache (my uneducated guess: but not necesarrily broken database)
What would be the approach then? I'd be happy to rename/remove those offending files with fancy filepaths, clean the file cache and rerun the scan.
Do you think it is a viable course to take? How to debug more.. Thanks,
–Mateusz

Steps to reproduce

initiate
add a FTP local network external storage
wait for Nextcloud to scan the external storage

Expected behaviour

regular Nextcloud start

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:
Armbian 5.25 Debian 8 Jessie 4.14.70

Web server:
Apache 2.4.25, with HTTP2 enabled

Database:
MariaDB 10

PHP version:
PHP 7.2

Nextcloud version: (see Nextcloud admin page)
14.0.3.0

Updated from an older Nextcloud/ownCloud or fresh install:
Fresh

Where did you install Nextcloud from:
NextcloudPi flavour run as docker container

List of activated apps:
Nextcloud configuration:

App list:

I'm unable to run any php command

config.php:

<?php
$CONFIG = array (
  'passwordsalt' => 'xxxxxxxxxxxxxxxxx',
  'secret' => 'xxxxxxxxxxxxxxx',
  'trusted_domains' => 
  array (
    0 => 'xxxxlhost',
    1 => 'xxxx17.0.2',
    2 => 'xxxxgepi.local',
    3 => 'xxxxngepi',
    4 => 'xxxxxxx.club',
    5 => 'xxxx168.0.11',
    6 => 'xxxxk.club',
    7 => 'xxxxcloudpi',
    8 => 'xxxxcloudpi.lan',
  ),
  'datadirectory' => '/data/app/data',
  'dbtype' => 'mysql',
  'version' => '14.0.3.0',
  'overwrite.cli.url' => 'https://xxxxxxx.club/',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'ncadmin',
  'dbpassword' => 'xxxxxxxxxxxxxxxxxxxxx',
  'installed' => true,
  'instanceid' => 'ockss4hwkl9y',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
    'timeout' => 0.0,
    'password' => 'xxxxxxxxxxxxxxxxxxxxxxxx',
  ),
  'mail_smtpmode' => 'sendmail',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_from_address' => 'admin',
  'mail_domain' => 'ownyourbits.com',
  'overwriteprotocol' => 'https',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 0,
  'htaccess.RewriteBase' => '/',
);

Are you using external storage, if yes which one: local/smb/sftp/...
– federated Nextcloud over internet
– FTP local storage

Are you using encryption: yes/no
no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no

Logs

Web server error log

Web server keep spitting JSONs like this:

{"reqId":"riZBS6fd7hYtkmSh6w4d","level":0,"time":"2018-10-29T18:50:36+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params [\"7\", \"14\", 1494090201, 655, \"5bd7567c5e78c\", 1494090201, 27, 29827, \"\", \"883e7a025438168eebe9e9a6385f2c73\", \"mateusz\\\/komputerowe\\\/backupy\\\/ptaszor_z_windowsa\\\/MIOD-PITNY\\\/Data\\\/$OF\\\/76637\\\/24955 (2017_05_06 17_54_27 UTC).pyc\", \"24955 (2017_05_06 17_54_27 UTC).pyc\", 5, 5, \"883e7a025438168eebe9e9a6385f2c73\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":0,"Trace":[{"file":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":128,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params [\"7\", \"14\", 1494090201, 655, \"5bd7567c5e78c\", 1494090201, 27, 29827, \"\", \"883e7a025438168eebe9e9a6385f2c73\", \"mateusz\\\/komputerowe\\\/backupy\\\/ptaszor_z_windowsa\\\/MIOD-PITNY\\\/Data\\\/$OF\\\/76637\\\/24955 (2017_05_06 17_54_27 UTC).pyc\", \"24955 (2017_05_06 17_54_27 UTC).pyc\", 5, 5, \"883e7a025438168eebe9e9a6385f2c73\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",{"errorInfo":["40001",1213,"Deadlock found when trying to get lock; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1015,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["40001",1213,"Deadlock found when trying to get lock; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",{"1":"7","2":"14","3":1494090201,"4":655,"5":"5bd7567c5e78c","6":1494090201,"7":27,"8":29827,"9":"","10":"883e7a025438168eebe9e9a6385f2c73","11":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","12":"24955 (2017_05_06 17_54_27 UTC).pyc","13":5,"14":5,"15":"883e7a025438168eebe9e9a6385f2c73"}]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"],[]]},{"file":"\/data\/app\/lib\/private\/DB\/Adapter.php","line":114,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":254,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Cache.php","line":272,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":128,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":29827,"checksum":"","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc"}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":114,"function":"insert","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":292,"function":"put","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":221,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""},-1]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":438,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",3,"29827",false,true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":406,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true,0]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":338,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":521,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":532,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":522,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637"]},{"file":"\/data\/app\/lib\/private\/Files\/Utils\/Scanner.php","line":173,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":88,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":112,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[{"__class__":"OC\\User\\User"}]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/TimedJob.php","line":55,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]},{"file":"\/data\/app\/cron.php","line":123,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php","Line":115,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":"40001","Trace":[{"file":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1008,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"],[]]},{"file":"\/data\/app\/lib\/private\/DB\/Adapter.php","line":114,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":254,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Cache.php","line":272,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":128,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":29827,"checksum":"","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc"}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":114,"function":"insert","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":292,"function":"put","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":221,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""},-1]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":438,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",3,"29827",false,true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":406,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true,0]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":338,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":521,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":532,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":522,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637"]},{"file":"\/data\/app\/lib\/private\/Files\/Utils\/Scanner.php","line":173,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":88,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":112,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[{"__class__":"OC\\User\\User"}]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/TimedJob.php","line":55,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]},{"file":"\/data\/app\/cron.php","line":123,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":107,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":"40001","Trace":[{"file":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":105,"function":"execute","class":"PDOStatement","type":"->","args":[["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1008,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"],[]]},{"file":"\/data\/app\/lib\/private\/DB\/Adapter.php","line":114,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0",["7","14",1494090201,655,"5bd7567c5e78c",1494090201,27,29827,"","883e7a025438168eebe9e9a6385f2c73","mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","24955 (2017_05_06 17_54_27 UTC).pyc",5,5,"883e7a025438168eebe9e9a6385f2c73"]]},{"file":"\/data\/app\/lib\/private\/DB\/Connection.php","line":254,"function":"insertIfNotExist","class":"OC\\DB\\Adapter","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Cache.php","line":272,"function":"insertIfNotExist","class":"OC\\DB\\Connection","type":"->","args":["*PREFIX*filecache",{"mimepart":"7","mimetype":"14","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"parent":29827,"checksum":"","path_hash":"883e7a025438168eebe9e9a6385f2c73","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc","storage":5},["storage","path_hash"]]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":128,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":29827,"checksum":"","path":"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc","name":"24955 (2017_05_06 17_54_27 UTC).pyc"}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Wrapper\/CacheWrapper.php","line":114,"function":"insert","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":292,"function":"put","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""}]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":221,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",{"mimetype":"application\/octet-stream","mtime":1494090201,"size":655,"etag":"5bd7567c5e78c","storage_mtime":1494090201,"permissions":27,"scan_permissions":27,"parent":"29827","checksum":""},-1]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":438,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc",3,"29827",false,true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":406,"function":"handleChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true,0]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":338,"function":"scanChildren","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3,"29827",true]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":521,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637",2,3]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":532,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"\/data\/app\/lib\/private\/Files\/Cache\/Scanner.php","line":522,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[{"__class__":"Closure"},"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637"]},{"file":"\/data\/app\/lib\/private\/Files\/Utils\/Scanner.php","line":173,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":[]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":88,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->","args":[""]},{"file":"\/data\/app\/apps\/files\/lib\/BackgroundJob\/ScanFiles.php","line":112,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[{"__class__":"OC\\User\\User"}]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->","args":[null]},{"file":"\/data\/app\/lib\/private\/BackgroundJob\/TimedJob.php","line":55,"function":"execute","class":"OC\\BackgroundJob\\Job","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]},{"file":"\/data\/app\/cron.php","line":123,"function":"execute","class":"OC\\BackgroundJob\\TimedJob","type":"->","args":[{"__class__":"OC\\BackgroundJob\\JobList"},{"__class__":"OC\\Log"}]}],"File":"\/data\/app\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":105}},"CustomMessage":"Exception while scanning file \"mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc\""},"userAgent":"--","version":"14.0.3.0"}

few more of them here https://paste.ee/p/36Mch) the only difference is the filename in question

Nextcloud log (data/nextcloud.log)

Nextcloud log

The whole log is 32MiB. There is one very strange line which is 9MiB long… it includes some paths in it, which I enclose below. Seems like parsing of # sign is dodgy.. idk

filename as in log this is strange. those `#` characters

"mateusz/komputerowe/backupy/ptaszor_z_windowsa/MIOD-PITNY/Data/D/Ptaszor/Programowanie__/web/angluar2/tutorial/sample-Groceries/node_modules/es5-ext/array/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/_is-extensible (2017_01_18 21_28_48 UTC).js/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/valid-array (2017_01_18 21_28_48 UTC).js/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#//#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#/#"

actual filepath

"mateusz/komputerowe/backupy/ptaszor_z_windowsa/MIOD-PITNY/Data/D/Ptaszor/Programowanie__/web/angluar2/tutorial/sample-Groceries/node_modules/es5-ext/array/#/<many folders here>

BONUS offending command log

file content:

sudo -u www-data php occ files:scan --all

log

root@7c72ebb97d68:/# /usr/local/bin/ncp-scan                       
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'ncadmin'@'localhost' (using password: YES) in /data/app/lib/private/DB/Connection.php:64
Stack trace:
#0 /data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\DB\Connection->connect()
#1 /data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /data/app/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /data/app/lib/private/DB/ConnectionFactory.php(152): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /data/app/lib/private/Server.php(630): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#9 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IDBConnecti...')
#11 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query('OCP\\IDBConnecti...')
#12 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#13 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('DatabaseConnect...')
#14 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('DatabaseConnect...')
#15 /data/app/lib/private/Server.php(1532): OC\ServerContainer->query('DatabaseConnect...')
#16 /data/app/lib/private/Server.php(352): OC\Server->getDatabaseConnection()
#17 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#18 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\Authenticati...')
#19 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#20 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query('OC\\Authenticati...')
#21 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#22 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#23 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#24 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query('OC\\Authenticati...')
#25 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#26 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#27 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#28 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query('OC\\Authenticati...')
#29 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#30 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\Authenticati...')
#31 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...')
#32 /data/app/lib/private/Server.php(364): OC\ServerContainer->query('OC\\Authenticati...')
#33 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#34 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OCP\\IUserSessio...')
#35 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OCP\\IUserSessio...')
#36 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query('OCP\\IUserSessio...')
#37 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#38 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('UserSession')
#39 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('UserSession')
#40 /data/app/lib/private/Server.php(1408): OC\ServerContainer->query('UserSession')
#41 /data/app/lib/private/Server.php(683): OC\Server->getUserSession()
#42 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#43 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\App\\AppManag...')
#44 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\App\\AppManag...')
#45 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query('OC\\App\\AppManag...')
#46 /data/app/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#47 /data/app/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('AppManager')
#48 /data/app/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('AppManager')
#49 /data/app/lib/private/Server.php(1703): OC\ServerContainer->query('AppManager')
#50 /data/app/lib/private/legacy/app.php(342): OC\Server->getAppManager()
#51 /data/app/lib/private/legacy/app.php(113): OC_App::getEnabledApps()
#52 /data/app/lib/base.php(654): OC_App::loadApps(Array)
#53 /data/app/lib/base.php(1068): OC::init()
#54 /data/app/console.php(46): require_once('/data/app/lib/b...')
#55 /data/app/occ(11): require_once('/data/app/conso...')
#56 {main}

Every other occ command throws the same trace

I'm very eager to perform any additional tests per request 🙄

GitMate.io thinks possibly related issues are #7191 (Crash on start with An exception occurred while executing 'CREATE table oc_locks_w2g), #5625 (Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_filecache), #8825 (PostgreSQL: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO "oc_schedulingobjects"), #9462 (Exception during scan), and #6860 (appstoreFetcher Exception).

I've taken a closer look at the logs using a JSON browser and there are three consecutive exceptions thrown:

order	Exception	Message	in file
oldest	`PDOException`	`SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction`	`/data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php`:105
middle	`Doctrine\DBAL\Driver\PDOException`	`SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction`	`/data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php`:107
newest	`Doctrine\DBAL\Exception\DriverException`	An exception occurred while executing 'INSERT INTO `oc_filecache` (`mimepart`,`mimetype`,`mtime`,`size`,`etag`,`storage_mtime`,`permissions`,`parent`,`checksum`,`path_hash`,`path`,`name`,`storage`) SELECT ?,?,?,?,?,?,?,?,?,?,?,?,? FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ? HAVING COUNT(*) = 0' with params ["7", "14", 1494090201, 655, "5bd7567c5e78c", 1494090201, 27, 29827, "", "883e7a025438168eebe9e9a6385f2c73", "mateusz\/komputerowe\/backupy\/ptaszor_z_windowsa\/MIOD-PITNY\/Data\/$OF\/76637\/24955 (2017_05_06 17_54_27 UTC).pyc", "24955 (2017_05_06 17_54_27 UTC).pyc", 5, 5, "883e7a025438168eebe9e9a6385f2c73"]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction	`/data/app/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php`:115

And then there is a summarizing CustomMessage: Exception while scanning file "mateusz/komputerowe/backupy/ptaszor_z_windowsa/MIOD-PITNY/Data/$OF/76637/24955 (2017_05_06 17_54_27 UTC).pyc" which confirms my observation, that file scan caused the the crash.

Any clue what can I do next ?

can you have a look in my version of adapter.php as written in #6160 an Test it on a testing machine?
Regards, Daniel

Ok, so I finally had time to investigate, and indeed → your commit fixes the issue: https://github.com/obel1x/server/commit/2370e7b0bdbf1915c7914ba283547caff2787602

Thank you very much 🥇

As the linked PR was superseded by #12371 could you give this a try as well?

I'm giving it a shot

I'm giving it a shot

Ah this seems to be the deadlock that needs to be fixed in a different way. I'm already on it, but don't have a PR ready yet.

Fix UniqueConstraintViolationException while insert into oc_filecache

Fix for this is in #12411

Fix UniqueConstraintViolationException while insert into oc_filecache

Navigation Menu

Repository navigation

Exception: Doctrine\\DBAL\\Exception\\DriverException | cannot start web service #12228

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Logs

Web server error log

Nextcloud log (data/nextcloud.log)

BONUS offending command log

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Exception: Doctrine\\DBAL\\Exception\\DriverException | cannot start web service #12228

Description

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Logs

Web server error log

Nextcloud log (data/nextcloud.log)

BONUS offending command log

Activity

nextcloud-bot commented on Nov 2, 2018

amateusz commented on Nov 3, 2018

obel1x commented on Nov 4, 2018

amateusz commented on Nov 7, 2018

MorrisJobke commented on Nov 9, 2018

amateusz commented on Nov 9, 2018

MorrisJobke commented on Nov 9, 2018

MorrisJobke commented on Nov 12, 2018

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions