Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
amateusz opened this issue Nov 2, 2018 · 8 comments · Fixed by #12411
Closed

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

amateusz opened this issue Nov 2, 2018 · 8 comments · Fixed by #12411
Labels
bug
Milestone
Nextcloud 15

Comments

@amateusz
Copy link

amateusz commented Nov 2, 2018 •
edited
Loading

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
Copy link
Member

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
Copy link
Author

amateusz commented Nov 3, 2018 •
edited
Loading

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
Copy link

obel1x commented Nov 4, 2018

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

@obel1x obel1x mentioned this issue Nov 6, 2018
Closed
@amateusz
Copy link
Author

amateusz commented Nov 7, 2018

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 🥇

@amateusz amateusz closed this as completed Nov 7, 2018
@MorrisJobke
Copy link
Member

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

@MorrisJobke MorrisJobke reopened this Nov 9, 2018
@amateusz
Copy link
Author

amateusz commented Nov 9, 2018

I'm giving it a shot

@MorrisJobke
Copy link
Member

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 added a commit that referenced this issue Nov 12, 2018
@MorrisJobke
Fix UniqueConstraintViolationException while insert into oc_filecache
89ba561 
* fixes #6160 by not being prone to the race condition in insertIfNotExists
* fixes #12228 by not using a query that can result in a deadlock
* replaces the insertIfNotExists call with an insert which is wrapped into a try-catch block

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
@MorrisJobke MorrisJobke mentioned this issue Nov 12, 2018
Merged
@MorrisJobke
Copy link
Member

Fix for this is in #12411

MorrisJobke added a commit that referenced this issue Nov 12, 2018
@MorrisJobke
Fix UniqueConstraintViolationException while insert into oc_filecache
93c62d7 
* fixes #6160 by not being prone to the race condition in insertIfNotExists
* fixes #12228 by not using a query that can result in a deadlock
* replaces the insertIfNotExists call with an insert which is wrapped into a try-catch block

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
@MorrisJobke MorrisJobke added this to the Nextcloud 15 milestone Nov 12, 2018
MorrisJobke added a commit that referenced this issue Nov 13, 2018
@MorrisJobke
Fix UniqueConstraintViolationException while insert into oc_filecache
4426800 
* fixes #6160 by not being prone to the race condition in insertIfNotExists
* fixes #12228 by not using a query that can result in a deadlock
* replaces the insertIfNotExists call with an insert which is wrapped into a try-catch block

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
MorrisJobke added a commit that referenced this issue Nov 13, 2018
@MorrisJobke
Fix UniqueConstraintViolationException while insert into oc_filecache
0737a6f 
* fixes #6160 by not being prone to the race condition in insertIfNotExists
* fixes #12228 by not using a query that can result in a deadlock
* replaces the insertIfNotExists call with an insert which is wrapped into a try-catch block

Signed-off-by: Morris Jobke <hey@morrisjobke.de>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
Nextcloud 15
Development

Successfully merging a pull request may close this issue.

Fix UniqueConstraintViolationException while insert into oc_filecache nextcloud/server
4 participants
@MorrisJobke @amateusz @obel1x @nextcloud-bot