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

[amateusz]

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

1. initiate
2. add a FTP local network external storage
3. 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 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 🙄

[nextcloud-bot]

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).

[amateusz]

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 ?

[obel1x]

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

[amateusz]

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 🥇

[MorrisJobke]

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

[amateusz]

I'm giving it a shot

[MorrisJobke]

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.

[MorrisJobke]

Fix for this is in #12411