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

14.0.4: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE oc_filecache #12699

Closed
windsource opened this issue Nov 27, 2018 · 7 comments
Closed

14.0.4: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE oc_filecache #12699

windsource opened this issue Nov 27, 2018 · 7 comments
Labels
bug needs info

Comments

@windsource
Copy link

I have just updated to 14.0.4 and still get the error

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE oc_filecache SET mtime = GREATEST(mtime, ?), etag = ? WHERE (storage = ?) AND (path_hash IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))' with params [1543347882, "5bfd9eaa96a43", 4]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Steps to reproduce

  1. Create a folder with about 100 photos locally and sync that with the Nextcloud
  2. Use the iOS mobile app, goto the tab 'media' then click 'select media folder' and choose the folder that you just uploaded
  3. Click OK

Now a lot of thumbnails need to be created by the server and the error appears in the server logs.

Expected behaviour

No error should be logged.

Actual behaviour

The error appears in the log

Server configuration

Server configuration 
ok 200 OK 14.0.4.2 yes yes \OC\Memcache\Redis none yes \OC\Memcache\Redis no 917776732160 0.5 0.34 0.59 16352588 12711584 8380412 8234748 37 0 2 42946 4 2 2 0 5 2 0 3 3 0 0 3 1 1 Apache/2.4.25 (Debian) 7.2.12 536870912 3600 535822336 mysql 10.3.10 34004992 1 1 2
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<ocs>
<meta>
<status>ok</status>
<statuscode>200</statuscode>
<message>OK</message>
</meta>
<meta>...</meta>
<data>
<nextcloud>
<system>
<version>14.0.4.2</version>
<theme/>
<enable_avatars>yes</enable_avatars>
<enable_previews>yes</enable_previews>
<memcache.local>\OC\Memcache\Redis</memcache.local>
<memcache.distributed>none</memcache.distributed>
<filelocking.enabled>yes</filelocking.enabled>
<memcache.locking>\OC\Memcache\Redis</memcache.locking>
<debug>no</debug>
<freespace>917776732160</freespace>
<cpuload>
<element>0.5</element>
<element>0.34</element>
<element>0.59</element>
</cpuload>
<cpuload>...</cpuload>
<mem_total>16352588</mem_total>
<mem_free>12711584</mem_free>
<swap_total>8380412</swap_total>
<swap_free>8234748</swap_free>
<apps>
<num_installed>37</num_installed>
<num_updates_available>0</num_updates_available>
<app_updates/>
</apps>
<apps>...</apps>
</system>
<system>...</system>
<storage>
<num_users>2</num_users>
<num_files>42946</num_files>
<num_storages>4</num_storages>
<num_storages_local>2</num_storages_local>
<num_storages_home>2</num_storages_home>
<num_storages_other>0</num_storages_other>
</storage>
<storage>...</storage>
<shares>
<num_shares>5</num_shares>
<num_shares_user>2</num_shares_user>
<num_shares_groups>0</num_shares_groups>
<num_shares_link>3</num_shares_link>
<num_shares_link_no_password>3</num_shares_link_no_password>
<num_fed_shares_sent>0</num_fed_shares_sent>
<num_fed_shares_received>0</num_fed_shares_received>
<permissions_3_1>3</permissions_3_1>
<permissions_0_17>1</permissions_0_17>
<permissions_0_31>1</permissions_0_31>
</shares>
<shares>...</shares>
</nextcloud>
<nextcloud>...</nextcloud>
<server>
<webserver>Apache/2.4.25 (Debian)</webserver>
<php>
<version>7.2.12</version>
<memory_limit>536870912</memory_limit>
<max_execution_time>3600</max_execution_time>
<upload_max_filesize>535822336</upload_max_filesize>
</php>
<php>...</php>
<database>
<type>mysql</type>
<version>10.3.10</version>
<size>34004992</size>
</database>
<database>...</database>
</server>
<server>...</server>
<activeUsers>
<last5minutes>1</last5minutes>
<last1hour>1</last1hour>
<last24hours>2</last24hours>
</activeUsers>
<activeUsers>...</activeUsers>
</data>
<data>...</data>
</ocs>
<ocs>...</ocs>

Operating system: Ubuntu 18.04

Web server: Apache

Database: MariaDB 10.x

PHP version: Using the docker image nextcloud:14.0.4

Nextcloud version: Using the docker image nextcloud:14.0.4

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

Where did you install Nextcloud from: Using the docker image nextcloud:14.0.4

Signing status:

Signing status 
No errors have been found.

List of activated apps:

App list 
Enabled:
  - accessibility: 1.0.1
  - activity: 2.7.0
  - calendar: 1.6.4
  - cloud_federation_api: 0.0.1
  - comments: 1.4.0
  - contacts: 2.1.7
  - dav: 1.6.0
  - drawio: 0.9.1
  - federatedfilesharing: 1.4.0
  - federation: 1.4.0
  - files: 1.9.0
  - files_markdown: 2.0.5
  - files_pdfviewer: 1.3.2
  - files_sharing: 1.6.2
  - files_texteditor: 2.6.0
  - files_trashbin: 1.4.1
  - files_versions: 1.7.1
  - files_videoplayer: 1.3.0
  - firstrunwizard: 2.3.0
  - gallery: 18.1.0
  - logreader: 2.0.0
  - lookup_server_connector: 1.2.0
  - nextcloud_announcements: 1.3.0
  - notifications: 2.2.1
  - oauth2: 1.2.1
  - password_policy: 1.4.0
  - provisioning_api: 1.4.0
  - richdocuments: 3.0.5
  - serverinfo: 1.4.0
  - sharebymail: 1.4.0
  - support: 1.0.0
  - survey_client: 1.2.0
  - systemtags: 1.4.0
  - theming: 1.5.0
  - twofactor_backupcodes: 1.3.1
  - updatenotification: 1.4.1
  - workflowengine: 1.4.0
Disabled:
  - admin_audit
  - deck
  - encryption
  - files_external
  - user_external
  - user_ldap

Nextcloud configuration:

Config report 
{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "cloud.hocodo.de"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/cloud.hocodo.de",
        "dbtype": "mysql",
        "version": "14.0.4.2",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "filelocking.enabled": true,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0
        },
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "htaccess.RewriteBase": "\/",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "theme": "",
        "loglevel": 2,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25"
    }
}

Are you using external storage, if yes which one: no

Are you using encryption: no

Are you using an external user-backend, if yes which one: no

Client configuration

Browser: Chrome

Operating system: MacOS

Logs

Nextcloud log (data/nextcloud.log)

Nextcloud log 
{"reqId":"ZfWZY0FVguVtYcnZLA6X","level":3,"time":"2018-11-27T19:44:43+00:00","remoteAddr":"188.195.116.22","user":"holger","app":"index","method":"GET","url":"\/index.php\/core\/preview.png?file=Temp\/Testbilder4\/Testbild4%20-%20189.jpg&x=240&y=426&a=1&mode=cover","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))' with params [1543347882, \"5bfd9eaa7231d\", 4]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":0,"Trace":[{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":128,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))' with params [1543347882, \"5bfd9eaa7231d\", 4]:\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":"\/var\/www\/html\/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"},"UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",{"1":1543347882,"2":"5bfd9eaa7231d","3":4}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",[1543347882,"5bfd9eaa7231d",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa7231d","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":102,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",["touch","create","write"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":210,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":118,"function":"getMaxPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\Node\\File"},"image\/jpeg"]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 189.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/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":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",[1543347882,"5bfd9eaa7231d",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa7231d","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":102,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",["touch","create","write"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":210,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":118,"function":"getMaxPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\Node\\File"},"image\/jpeg"]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 189.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/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":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":105,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",[1543347882,"5bfd9eaa7231d",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', 'a0a2a01a5bfd9da8fe88153f4d112177'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa7231d","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":102,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg",["touch","create","write"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46369\/3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":210,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["3024-4032-max.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":118,"function":"getMaxPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\Node\\File"},"image\/jpeg"]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 189.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":105}},"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (iOS) Nextcloud-iOS\/2.22.5","version":"14.0.4.2"}
{"reqId":"lus6oRd7eFxaIJLkhKmG","level":3,"time":"2018-11-27T19:44:43+00:00","remoteAddr":"188.195.116.22","user":"holger","app":"index","method":"GET","url":"\/index.php\/core\/preview.png?file=Temp\/Testbilder4\/Testbild4%20-%203.jpg&x=240&y=426&a=1&mode=cover","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))' with params [1543347882, \"5bfd9eaa96a43\", 4]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction","Code":0,"Trace":[{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":128,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))' with params [1543347882, \"5bfd9eaa96a43\", 4]:\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":"\/var\/www\/html\/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"},"UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",{"1":1543347882,"2":"5bfd9eaa96a43","3":4}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",[1543347882,"5bfd9eaa96a43",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa96a43","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":90,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",["touch"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":380,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":145,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\SimpleFS\\SimpleFile"},683,512,false,4032,3024]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},683,512,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 3.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/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":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",[1543347882,"5bfd9eaa96a43",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa96a43","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":90,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",["touch"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":380,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":145,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\SimpleFS\\SimpleFile"},683,512,false,4032,3024]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},683,512,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 3.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/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":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":105,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1006,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, ?), `etag` = ? WHERE (`storage` = ?) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",[1543347882,"5bfd9eaa96a43",4],[1,2,1]]},{"file":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Query\/QueryBuilder.php","line":208,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `mtime` = GREATEST(`mtime`, :dcValue1), `etag` = :dcValue2 WHERE (`storage` = :dcValue3) AND (`path_hash` IN ('d41d8cd98f00b204e9800998ecf8427e', '365b26642f524d56d2fa53da7a8458d9', '9af9c3d83bec564b56ec03b2e740c288', '1fb23f05313296b7b7cbceec5cb92d64'))",{"dcValue1":1543347882,"dcValue2":"5bfd9eaa96a43","dcValue3":4},{"dcValue1":1,"dcValue2":2,"dcValue3":1}]},{"file":"\/var\/www\/html\/lib\/private\/DB\/QueryBuilder\/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Propagator.php","line":90,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Cache\/Updater.php","line":138,"function":"propagateChange","class":"OC\\Files\\Cache\\Propagator","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882,0]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":320,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":1164,"function":"writeUpdate","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":{"__class__":"OC\\Files\\Cache\\Propagator"},"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",1543347882]},{"file":"\/var\/www\/html\/lib\/private\/Files\/View.php","line":567,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["touch","\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg",["touch"],null]},{"file":"\/var\/www\/html\/lib\/private\/Files\/Node\/Folder.php","line":181,"function":"touch","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocroxelaeafd\/preview\/46408\/683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Files\/SimpleFS\/SimpleFolder.php","line":83,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":380,"function":"newFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->","args":["683-512.jpg"]},{"file":"\/var\/www\/html\/lib\/private\/Preview\/Generator.php","line":145,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\SimpleFS\\SimpleFolder"},{"__class__":"OC\\Files\\SimpleFS\\SimpleFile"},683,512,false,4032,3024]},{"file":"\/var\/www\/html\/lib\/private\/PreviewManager.php","line":205,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},683,512,false,"cover","image\/jpeg"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":175,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,false,"cover"]},{"file":"\/var\/www\/html\/core\/Controller\/PreviewController.php","line":110,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[{"__class__":"OC\\Files\\Node\\File"},240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":166,"function":"getPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":["Temp\/Testbilder4\/Testbild4 - 3.jpg",240,426,true,true,"cover"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Http\/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/App.php","line":118,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OC\\Core\\Controller\\PreviewController"},"getPreview"]},{"file":"\/var\/www\/html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreview",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"core.Preview.getPreview"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/private\/Route\/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"_route":"core.Preview.getPreview"}]},{"file":"\/var\/www\/html\/lib\/base.php","line":987,"function":"match","class":"OC\\Route\\Router","type":"->","args":["\/core\/preview.png"]},{"file":"\/var\/www\/html\/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"\/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":105}},"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (iOS) Nextcloud-iOS\/2.22.5","version":"14.0.4.2"}
@nextcloud-bot
Copy link
Member

GitMate.io thinks possibly related issues are #12343 (Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_filecache ), #5625 (Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO oc_filecache), #6160 (Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO "oc_filecache" ), and #11136 (Preview generation in gallery generates deadlock in database).

@windsource
Copy link
Author

I think it is very similar to #11136. I also upgraded from Nextcloud 13 to 14 and also use the gallery / media preview to reproduce the problem. But the referenced issue also does not have a solution yet.
I have configured MariaDB to use transaction-isolation = READ-COMMITTED so I don't know what to do solve this problem.

@ChristophWurst
Copy link
Member

Just to be sure: did you read https://docs.nextcloud.com/server/14/admin_manual/configuration_database/linux_database_configuration.html?

@ChristophWurst
Copy link
Member

Do you have many users or a large amount of data that is transferred?

@windsource
Copy link
Author

Hi @ChristophWurst , I read the [Database configuration] page and I use Nextcloud alone that means there is not much activity on the Nextcloud server. I can reproduce the problem 100% when generating new preview images in the gallery (also from the browser).
I migrated a Nextcloud 13 manual installation to Nextcloud 14 using docker. I use the image https://github.com/nextcloud/docker. The MariaDB is configured for TRANSACTION_READ_COMMITTED transaction isolation level. I use the docker image as is and just changed the config/config.php file. Actually I have no clue where in the docker image the php configuration is located but I also don't know if this related to my problem.
The rest of the installation runs fine. The problem is just with generating preview images.

@skjnldsv
Copy link
Member

I would say duplicate of #12343
See #12369

@MorrisJobke
Copy link
Member

I would say duplicate of #12343

Yep. Thus closing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug needs info
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@MorrisJobke @ChristophWurst @windsource @skjnldsv @nextcloud-bot