Accessing files on external storage (WebDAV) results in exception(s) after system/owncloud update

Server
, ,
1

Steps to reproduce

  1. Run owncloud 10.0.8 server on a raspberry pi with raspian (jessy)
  2. Update jessy to stretch, afterwards update stretch to buster
  3. Update owncloud 10.0.8 to owncloud 10.4.0

I suspect, I broke something while updating from jessy to buster, maybe a (now) missing or misconfigured package which might be necessary to successfully connect the external storage using WebDAV or a. I conducted the owncloud admin manual for requirements and searched the owncloud central forums, but could not figure out any solution by myself…

Expected behaviour

Accessing/Syncing files on external storage access connected via WebDAV is expected to work with updated system after step 3 as it did with system in step 1.

Actual behaviour

Accessing folders on the external storage works, but accessing files does not (accessing being reading/writing/adding/deleting files).
The owncloud error log shows several GET/PUT/PROPFIND/MKCOL Exceptions (see below).

Server configuration

Operating system:

  • Raspian Buster
$ uname -a
Linux pij-owncloud 4.19.97-v7+ #1294 SMP Thu Jan 30 13:15:58 GMT 2020 armv7l GNU/Linux

Web server:

$ apache2 -v
Server version: Apache/2.4.38 (Raspbian)
Server built:   2019-10-15T19:53:42

Database:

$ mariadb --version
mariadb  Ver 15.1 Distrib 10.3.22-MariaDB, for debian-linux-gnueabihf (armv8l) using readline 5.2

PHP version:

$ php --version
PHP 7.3.14-1~deb10u1 (cli) (built: Feb 16 2020 15:07:23) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.14, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.3.14-1~deb10u1, Copyright (c) 1999-2018, by Zend Technologies

ownCloud version: (see ownCloud admin page)

system state
installed 1
maintenance
needsDbUpgrade
version 10.4.0.4
versionstring 10.4.0
edition Community
productname ownCloud

Updated from an older ownCloud or fresh install:
Updated from 10.0.8 to 10.4.0 (see above)

Where did you install ownCloud from:
Tarball: https://download.owncloud.org/community/owncloud-10.4.0.tar.bz2

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

No errors have been found.

The content of config/config.php:

{
    "system": {
        "updatechecker": false,
        "instanceid": "oc3t9h3pysz4",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "10.4.0.4",
        "dbname": "owncloud",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "logtimezone": "UTC",
        "installed": true,
        "maintenance": false,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "loglevel": 3,
        "mail_smtpsecure": "tls"
    }
}

List of activated apps:

Enabled:
  - calendar: 1.6.4
  - comments: 0.3.0
  - configreport: 0.2.0
  - contacts: 1.5.5
  - dav: 0.5.0
  - encryption: 1.4.0
  - federatedfilesharing: 0.5.0
  - federation: 0.1.0
  - files: 1.5.2
  - files_external: 0.7.1
  - files_mediaviewer: 1.0.2
  - files_sharing: 0.12.0
  - files_trashbin: 0.9.1
  - files_versions: 1.3.0
  - files_videoplayer: 0.9.9
  - firstrunwizard: 1.2.0
  - gallery: 16.1.1
  - market: 0.5.0
  - notifications: 0.5.0
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - updatenotification: 0.2.1
Disabled:
  - external
  - user_external

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

Are you using encryption: yes

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

Client configuration

Browser:
All of them

Operating system:
Ubuntu 19.10

Logs

Web server error log

[Mon Apr 13 00:00:04.154190 2020] [ssl:warn] [pid 31332] AH01906: 127.0.0.1:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Apr 13 00:00:04.154584 2020] [ssl:warn] [pid 31332] AH01909: 127.0.0.1:443:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 13 00:00:04.155731 2020] [mpm_prefork:notice] [pid 31332] AH00163: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Mon Apr 13 00:00:04.155830 2020] [core:notice] [pid 31332] AH00094: Command line: '/usr/sbin/apache2'
[Mon Apr 13 09:37:37.750630 2020] [php7:error] [pid 24624] [client 192.168.0.1:58996] PHP Fatal error:  Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117\nStack trace:\n#0 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)\n#1 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1056): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/owncloud-10.0.8/lib/private/DB/Connection.php(207): Doctrine\\DBAL\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#3 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(203): OC\\DB\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#4 /var/www/owncloud-10.0.8/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/owncloud-10.0.8/lib/private/Lock/DBLockingProvider.php(281) in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 34
[Mon Apr 13 09:38:01.084344 2020] [php7:error] [pid 26584] [client 192.168.0.1:59004] PHP Fatal error:  Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117\nStack trace:\n#0 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)\n#1 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1056): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/owncloud-10.0.8/lib/private/DB/Connection.php(207): Doctrine\\DBAL\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#3 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(203): OC\\DB\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#4 /var/www/owncloud-10.0.8/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/owncloud-10.0.8/lib/private/Lock/DBLockingProvider.php(281) in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 34
[Mon Apr 13 09:38:01.090853 2020] [php7:error] [pid 25198] [client 192.168.0.1:59006] PHP Fatal error:  Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117\nStack trace:\n#0 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)\n#1 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1056): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/owncloud-10.0.8/lib/private/DB/Connection.php(207): Doctrine\\DBAL\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#3 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(203): OC\\DB\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#4 /var/www/owncloud-10.0.8/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/owncloud-10.0.8/lib/private/Lock/DBLockingProvider.php(281) in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 34
[Mon Apr 13 09:38:01.094126 2020] [php7:error] [pid 24354] [client 192.168.0.1:59010] PHP Fatal error:  Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117\nStack trace:\n#0 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)\n#1 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1056): Doctrine\\DBAL\\Driver\\PDOStatement->execute()\n#2 /var/www/owncloud-10.0.8/lib/private/DB/Connection.php(207): Doctrine\\DBAL\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#3 /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(203): OC\\DB\\Connection->executeUpdate('UPDATE `oc_file...', Array, Array)\n#4 /var/www/owncloud-10.0.8/lib/private/DB/QueryBuilder/QueryBuilder.php(141): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/owncloud-10.0.8/lib/private/Lock/DBLockingProvider.php(281) in /var/www/owncloud-10.0.8/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 34

ownCloud log (data/owncloud.log)

Excerpt with PROPFIND error:


    "app": "webdav",
    "level": 3,
    "message": "Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'etag' at row 1\",\"Code\":\"22001\",\"Trace\":\"#0 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/PDOStatement.php(117): PDOStatement->execute(NULL)\\n#1 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(1056): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Connection.php(207): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(203): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#4 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/QueryBuilder\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Adapter.php(198): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Connection.php(260): OC\\\\DB\\\\Adapter->upsert('*PREFIX*filecac...', Array, Array)\\n#7 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Cache.php(296): OC\\\\DB\\\\Connection->upsert('*PREFIX*filecac...', Array, Array)\\n#8 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(124): OC\\\\Files\\\\Cache\\\\Cache->insert('Documents\\/setti...', Array)\\n#9 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(110): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->insert('Documents\\/setti...', Array)\\n#10 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(281): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->put('Documents\\/setti...', Array)\\n#11 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(218): OC\\\\Files\\\\Cache\\\\Scanner->addToCache('Documents\\/setti...', Array, -1)\\n#12 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(326): OC\\\\Files\\\\Cache\\\\Scanner->scanFile('Documents\\/setti...', 3, '62701', false, true)\\n#13 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1405): OC\\\\Files\\\\Cache\\\\Scanner->scan('Documents\\/setti...', false)\\n#14 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1446): OC\\\\Files\\\\View->getCacheEntry(Object(OCA\\\\Files_Trashbin\\\\Storage), 'Documents\\/setti...', 'GMX_Mediacenter...')\\n#15 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Connector\\/Sabre\\/ObjectTree.php(179): OC\\\\Files\\\\View->getFileInfo('\\/PiJ\\/files\\/GMX_...')\\n#16 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Tree.php(70): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\ObjectTree->getNodeForPath('GMX_Mediacenter...')\\n#17 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(976): OCA\\\\DAV\\\\Tree->getNodeForPath('files\\/PiJ\\/GMX_M...')\\n#18 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(1678): Sabre\\\\DAV\\\\Server->getPropertiesIteratorForPath('files\\/PiJ\\/GMX_M...', Array, 0)\\n#19 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(1661): Sabre\\\\DAV\\\\Server->writeMultiStatus(Object(Sabre\\\\Xml\\\\Writer), Object(Generator), false)\\n#20 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/CorePlugin.php(363): Sabre\\\\DAV\\\\Server->generateMultiStatus(Object(Generator), false)\\n#21 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/event\\/lib\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpPropFind(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#22 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(474): Sabre\\\\DAV\\\\Server->emit('method:PROPFIND', Array)\\n#23 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(251): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#24 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Server.php(329): Sabre\\\\DAV\\\\Server->start()\\n#25 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/appinfo\\/v2\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#26 \\/var\\/www\\/owncloud-10.0.8\\/remote.php(165): require_once('\\/var\\/www\\/ownclo...')\\n#27 {main}\",\"File\":\"\\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/PDOStatement.php\",\"Line\":117}",
    "method": "PROPFIND",
    "remoteAddr": "192.168.0.1",
    "reqId": "44b349f6-352a-494f-b4f8-f81b5f2f41b3",
    "time": "2020-04-13T05:27:07+00:00",
    "url": "/remote.php/dav/files/PiJ/GMX_Mediacenter/Documents/settings.xml",
    "user": "PiJ"
}

Excerpt with PUT error:

{
    "app": "webdav",
    "level": 3,
    "message": "Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDOException\",\"Message\":\"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'etag' at row 1\",\"Code\":\"22001\",\"Trace\":\"#0 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(1056): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#1 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Connection.php(207): Doctrine\\\\DBAL\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#2 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Query\\/QueryBuilder.php(203): OC\\\\DB\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\n#3 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/QueryBuilder\\/QueryBuilder.php(141): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#4 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Adapter.php(198): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#5 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Connection.php(260): OC\\\\DB\\\\Adapter->upsert('*PREFIX*filecac...', Array, Array)\\n#6 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Cache.php(296): OC\\\\DB\\\\Connection->upsert('*PREFIX*filecac...', Array, Array)\\n#7 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(124): OC\\\\Files\\\\Cache\\\\Cache->insert('Documents\\/setti...', Array)\\n#8 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(110): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->insert('Documents\\/setti...', Array)\\n#9 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(281): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->put('Documents\\/setti...', Array)\\n#10 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(218): OC\\\\Files\\\\Cache\\\\Scanner->addToCache('Documents\\/setti...', Array, -1)\\n#11 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(326): OC\\\\Files\\\\Cache\\\\Scanner->scanFile('Documents\\/setti...', 3, '62701', false, true)\\n#12 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1405): OC\\\\Files\\\\Cache\\\\Scanner->scan('Documents\\/setti...', false)\\n#13 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1446): OC\\\\Files\\\\View->getCacheEntry(Object(OCA\\\\Files_Trashbin\\\\Storage), 'Documents\\/setti...', 'GMX_Mediacenter...')\\n#14 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Connector\\/Sabre\\/ObjectTree.php(179): OC\\\\Files\\\\View->getFileInfo('\\/PiJ\\/files\\/GMX_...')\\n#15 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Tree.php(70): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\ObjectTree->getNodeForPath('GMX_Mediacenter...')\\n#16 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Connector\\/Sabre\\/LockPlugin.php(63): OCA\\\\DAV\\\\Tree->getNodeForPath('files\\/PiJ\\/GMX_M...')\\n#17 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/event\\/lib\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\LockPlugin->getLock(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#18 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(458): Sabre\\\\DAV\\\\Server->emit('beforeMethod:PU...', Array)\\n#19 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(251): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#20 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Server.php(329): Sabre\\\\DAV\\\\Server->start()\\n#21 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/appinfo\\/v2\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#22 \\/var\\/www\\/owncloud-10.0.8\\/remote.php(165): require_once('\\/var\\/www\\/ownclo...')\\n#23 {main}\",\"File\":\"\\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/PDOStatement.php\",\"Line\":119}",
    "method": "PUT",
    "remoteAddr": "192.168.0.1",
    "reqId": "4b01e10d-4f50-46e2-8ad6-5505d0d987ce",
    "time": "2020-04-13T07:38:11+00:00",
    "url": "/remote.php/dav/files/PiJ/GMX_Mediacenter/Documents/settings.xml",
    "user": "PiJ"
}

Excerpt with GET error:

{
    "app": "webdav",
    "level": 3,
    "message": "Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'etag' at row 1\",\"Code\":\"22001\",\"Trace\":\"#0 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/PDOStatement.php(117): PDOStatement->execute(Array)\\n#1 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(907): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute(Array)\\n#2 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/DB\\/Connection.php(187): Doctrine\\\\DBAL\\\\Connection->executeQuery('UPDATE `oc_file...', Array, Array, NULL)\\n#3 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Cache.php(345): OC\\\\DB\\\\Connection->executeQuery('UPDATE `oc_file...', Array)\\n#4 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(134): OC\\\\Files\\\\Cache\\\\Cache->update('57670', Array)\\n#5 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Wrapper\\/CacheWrapper.php(107): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->update('57670', Array)\\n#6 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(281): OC\\\\Files\\\\Cache\\\\Wrapper\\\\CacheWrapper->put('Documents\\/examp...', Array)\\n#7 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Scanner.php(218): OC\\\\Files\\\\Cache\\\\Scanner->addToCache('Documents\\/examp...', Array, -1)\\n#8 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/Cache\\/Watcher.php(105): OC\\\\Files\\\\Cache\\\\Scanner->scanFile('Documents\\/examp...')\\n#9 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1410): OC\\\\Files\\\\Cache\\\\Watcher->update('Documents\\/examp...', Object(OC\\\\Files\\\\Cache\\\\CacheEntry))\\n#10 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/private\\/Files\\/View.php(1446): OC\\\\Files\\\\View->getCacheEntry(Object(OCA\\\\Files_Trashbin\\\\Storage), 'Documents\\/examp...', 'GMX_Mediacenter...')\\n#11 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Connector\\/Sabre\\/ObjectTree.php(179): OC\\\\Files\\\\View->getFileInfo('\\/PiJ\\/files\\/GMX_...')\\n#12 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Tree.php(70): OCA\\\\DAV\\\\Connector\\\\Sabre\\\\ObjectTree->getNodeForPath('GMX_Mediacenter...')\\n#13 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/DAV\\/ViewOnlyPlugin.php(86): OCA\\\\DAV\\\\Tree->getNodeForPath('files\\/PiJ\\/GMX_M...')\\n#14 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/event\\/lib\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\DAV\\\\ViewOnlyPlugin->checkViewOnly(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#15 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(474): Sabre\\\\DAV\\\\Server->emit('method:GET', Array)\\n#16 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(251): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#17 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Server.php(329): Sabre\\\\DAV\\\\Server->start()\\n#18 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/appinfo\\/v2\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#19 \\/var\\/www\\/owncloud-10.0.8\\/remote.php(165): require_once('\\/var\\/www\\/ownclo...')\\n#20 {main}\",\"File\":\"\\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/PDOStatement.php\",\"Line\":117}",
    "method": "GET",
    "remoteAddr": "192.168.0.1",
    "reqId": "f06df57b-62a1-437c-894f-6a8082446dbe",
    "time": "2020-04-09T14:00:23+00:00",
    "url": "/remote.php/dav/files/PiJ/GMX_Mediacenter/Documents/examplefile.xml",
    "user": "PiJ"
}

Excerpt with MKCOL error:

{
    "app": "webdav",
    "level": 4,
    "message": "Exception: HTTP/1.1 405 The resource you tried to create already exists: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\MethodNotAllowed\",\"Message\":\"The resource you tried to create already exists\",\"Code\":0,\"Trace\":\"#0 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/CorePlugin.php(586): Sabre\\\\DAV\\\\Server->createCollection('files\\/PiJ\\/GMX_M...', Object(Sabre\\\\DAV\\\\MkCol))\\n#1 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/event\\/lib\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\CorePlugin->httpMkcol(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#2 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(474): Sabre\\\\DAV\\\\Server->emit('method:MKCOL', Array)\\n#3 \\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php(251): Sabre\\\\DAV\\\\Server->invokeMethod(Object(Sabre\\\\HTTP\\\\Request), Object(Sabre\\\\HTTP\\\\Response))\\n#4 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/lib\\/Server.php(329): Sabre\\\\DAV\\\\Server->start()\\n#5 \\/var\\/www\\/owncloud-10.0.8\\/apps\\/dav\\/appinfo\\/v2\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#6 \\/var\\/www\\/owncloud-10.0.8\\/remote.php(165): require_once('\\/var\\/www\\/ownclo...')\\n#7 {main}\",\"File\":\"\\/var\\/www\\/owncloud-10.0.8\\/lib\\/composer\\/sabre\\/dav\\/lib\\/DAV\\/Server.php\",\"Line\":1191}",
    "method": "MKCOL",
    "remoteAddr": "192.168.0.1",
    "reqId": "3e30f4da-d0a2-48b3-b95d-e7196c36fb70",
    "time": "2020-04-09T15:03:30+00:00",
    "url": "/remote.php/dav/files/PiJ/GMX_Mediacenter/.documents/anotherexamplefile.xml",
    "user": "PiJ"
}

Browser log

DELETED

2

Any help is much appreciated.
I’d also happily give further information, if necessary.

3

I would recommend to try running Redis, and configure it for file locking. You’ll need the package for the server, which I think is called redis and the php module which should be called php-redis.
Once it is up and running you can add the following to your config.php, by running the following occ commands:

occ config:system:set \
   memcache.locking \
   --value '\OC\Memcache\Redis'

occ config:system:set \
   redis \
   --value '{"host": "127.0.0.1", "port": "6379"}' \
   --type json

For unrelated performance reasons you should also make sure you have the APCu PHP module installed and enabled, before adding the following additional config:

occ config:system:set \
   memcache.local \
   --value '\OC\Memcache\APCu'
1 Like
4

@eneubauer Thank you for your help!
I enabled Redis as you suggested and tried it again, still getting the same errors.
Next step I’m trying is to fully revert my changes, trying to find out what the problem might be.

1 Like