Skip to content

restoring a lot of files with phoenix fails with "file is locked errors" #38039

@individual-it

Description

@individual-it

Steps to reproduce

  1. delete a lot of files
  2. in the phoenix trashbin select all files and restore them

This is not reproducible with the oc10 webUI, I think its because the old UI does not use WebDAV for trashbin operations

Expected behaviour

files and folders should be restored without problems

Actual behaviour

random files/folders will be locked and not restored

Server configuration

Operating system:
Ubuntu 20.04
Web server:
Apache
Database:
MySQL
PHP version:
7.4
ownCloud version: (see ownCloud admin page)
10.6.0beta1
Updated from an older ownCloud or fresh install:
fresh
Where did you install ownCloud from:
git

The content of config/config.php:

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "172.17.0.1"
        ],
        "datadirectory": "\/home\/artur\/www\/owncloud-core\/data",
        "overwrite.cli.url": "http:\/\/localhost\/owncloud-core",
        "version": "10.6.0.1",
        "logtimezone": "UTC",
        "htaccess.RewriteBase": "\/owncloud-core\/",
        "loglevel": "1",
        "log_type": "owncloud",
        "theme": "",
        "sharing.federation.allowHttpFallback": true,
        "files_external_allow_create_new_local": "true",
        "license-key": "***REMOVED SENSITIVE VALUE***",
        "instanceid": "oc4kyqahfanl",
        "enable_previews": true,
        "apps_paths": [
            {
                "path": "\/home\/artur\/www\/owncloud-core\/apps",
                "url": "apps",
                "writable": true
            },
            {
                "path": "\/home\/artur\/www\/owncloud-core\/apps2",
                "url": "apps2",
                "writable": true
            }
        ],
        "csrf.disabled": true,
        "maintenance": false,
        "cors.allowed-domains": [
            "http:\/\/172.17.0.1\/owncloud-phoenix\/dist",
            "http:\/\/localhost:9876"
        ],
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "php",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "1025",
        "default_language": "en",
        "dav.enable.tech_preview": true,
        "dbtype": "mysql",
        "dbname": "owncloud_10_6_0",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "grace_period.demo_key.show_popup": false,
        "share_folder": "Shares",
        "skeletondirectory": "\/home\/artur\/www\/owncloud-core\/apps\/testing\/data\/webUISkeleton"
    }
}

List of activated apps:

Enabled:
  - activity: 2.5.2
  - admin_audit: 1.0.3
  - comments: 0.3.0
  - dav: 0.6.0
  - diagnostics: 0.1.4
  - enterprise_key: 0.3.0
  - federatedfilesharing: 0.5.0
  - federation: 0.1.0
  - files: 1.5.2
  - files_external: 0.7.1
  - files_sharing: 0.14.0
  - files_texteditor: 2.3.0
  - files_trashbin: 0.9.1
  - files_versions: 1.3.0
  - firewall: 2.8.0
  - notifications: 0.5.0
  - oauth2: 0.4.3
  - provisioning_api: 0.5.0
  - systemtags: 0.3.0
  - systemtags_management: 0.4.1
  - testing: 0.1.0
  - updatenotification: 0.2.1
  - windows_network_drive: 0.7.2
  - workflow: 0.3.0
Disabled:
  - brute_force_protection
  - customgroups
  - data_exporter
  - files_antivirus
  - files_classifier
  - files_lifecycle
  - files_primary_s3
  - firstrunwizard
  - guests
  - openidconnect
  - password_policy
  - ransomware_protection
  - richdocuments
  - sharepoint
  - twofactor_totp
  - user_ldap
  - wopi

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

Client configuration

Browser:
FF
Operating system:
Ubuntu 20.04

Logs

ownCloud log (data/owncloud.log)

{"reqId":"FMUoeXM1SpWLegl7pCd3","level":3,"time":"2020-10-27T11:08:40+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"OC\\User\\Session::createSessionToken","method":"GET","url":"\/owncloud-core\/\/remote.php\/dav\/avatars\/uu2\/128.png","message":"There are code paths that trigger the generation of an auth token for the same session twice. We log this to trace the code paths. Please send all log lines belonging to this request id."}
{"reqId":"FMUoeXM1SpWLegl7pCd3","level":3,"time":"2020-10-27T11:08:40+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"OC\\User\\Session::createSessionToken","method":"GET","url":"\/owncloud-core\/\/remote.php\/dav\/avatars\/uu2\/128.png","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\UniqueConstraintViolationException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_authtoken`(`uid`,`login_name`,`name`,`token`,`type`,`last_activity`,`last_check`) VALUES(?,?,?,?,?,?,?)' with params [\\\"uu2\\\", \\\"uu2\\\", \\\"Mozilla\\\\\\\/5.0 (X11; Ubuntu; Linux x86_64; rv:82.0) Gecko\\\\\\\/20100101 Firefox\\\\\\\/82.0\\\", \\\"bf2c08e072e9de09a7357019eecb57f7587b1bfd55d04e58e8e9481c82054d359dfbb307b3cb03d171553472dfbe9663131f0827746da88d8be77b7adcbe7f16\\\", 0, 1603796920, 1603796920]:\\n\\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bf2c08e072e9de09a7357019eecb57f7587b1bfd55d04e58e8e9481c82054d35' for key 'oc_authtoken.authtoken_token_index'\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(172): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException()\\n#1 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(151): Doctrine\\\\DBAL\\\\DBALException::wrapException()\\n#2 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(165): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery()\\n#3 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(241): Doctrine\\\\DBAL\\\\Statement->execute()\\n#4 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(119): OCP\\\\AppFramework\\\\Db\\\\Mapper->execute()\\n#5 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/Authentication\\\/Token\\\/DefaultTokenProvider.php(101): OCP\\\\AppFramework\\\\Db\\\\Mapper->insert()\\n#6 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(732): OC\\\\Authentication\\\\Token\\\\DefaultTokenProvider->generateToken(*** sensitive parameters replaced ***)\\n#7 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(981): OC\\\\User\\\\Session->createSessionToken()\\n#8 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/OAuth2.php(121): OC\\\\User\\\\Session->tryAuthModuleLogin()\\n#9 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/AbstractBearer.php(99): OCA\\\\OAuth2\\\\Sabre\\\\OAuth2->validateBearerToken()\\n#10 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(182): OCA\\\\OAuth2\\\\Sabre\\\\AbstractBearer->check()\\n#11 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(137): Sabre\\\\DAV\\\\Auth\\\\Plugin->check()\\n#12 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\Auth\\\\Plugin->beforeMethod()\\n#13 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(456): Sabre\\\\DAV\\\\Server->emit()\\n#14 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#15 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/lib\\\/Server.php(330): Sabre\\\\DAV\\\\Server->start()\\n#16 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#17 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/remote.php(165): require_once('\\\/home\\\/artur\\\/www...')\\n#18 {main}\",\"File\":\"\\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":59}"}
{"reqId":"FMUoeXM1SpWLegl7pCd3","level":3,"time":"2020-10-27T11:08:40+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"OC\\User\\Session::createSessionToken","method":"GET","url":"\/owncloud-core\/\/remote.php\/dav\/avatars\/uu2\/128.png","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDOException\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bf2c08e072e9de09a7357019eecb57f7587b1bfd55d04e58e8e9481c82054d35' for key 'oc_authtoken.authtoken_token_index'\",\"Code\":\"23000\",\"Trace\":\"#0 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(155): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#1 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(241): Doctrine\\\\DBAL\\\\Statement->execute()\\n#2 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(119): OCP\\\\AppFramework\\\\Db\\\\Mapper->execute()\\n#3 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/Authentication\\\/Token\\\/DefaultTokenProvider.php(101): OCP\\\\AppFramework\\\\Db\\\\Mapper->insert()\\n#4 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(732): OC\\\\Authentication\\\\Token\\\\DefaultTokenProvider->generateToken(*** sensitive parameters replaced ***)\\n#5 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(981): OC\\\\User\\\\Session->createSessionToken()\\n#6 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/OAuth2.php(121): OC\\\\User\\\\Session->tryAuthModuleLogin()\\n#7 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/AbstractBearer.php(99): OCA\\\\OAuth2\\\\Sabre\\\\OAuth2->validateBearerToken()\\n#8 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(182): OCA\\\\OAuth2\\\\Sabre\\\\AbstractBearer->check()\\n#9 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(137): Sabre\\\\DAV\\\\Auth\\\\Plugin->check()\\n#10 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\Auth\\\\Plugin->beforeMethod()\\n#11 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(456): Sabre\\\\DAV\\\\Server->emit()\\n#12 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#13 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/lib\\\/Server.php(330): Sabre\\\\DAV\\\\Server->start()\\n#14 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#15 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/remote.php(165): require_once('\\\/home\\\/artur\\\/www...')\\n#16 {main}\",\"File\":\"\\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":131}"}
{"reqId":"FMUoeXM1SpWLegl7pCd3","level":3,"time":"2020-10-27T11:08:40+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"OC\\User\\Session::createSessionToken","method":"GET","url":"\/owncloud-core\/\/remote.php\/dav\/avatars\/uu2\/128.png","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bf2c08e072e9de09a7357019eecb57f7587b1bfd55d04e58e8e9481c82054d35' for key 'oc_authtoken.authtoken_token_index'\",\"Code\":\"23000\",\"Trace\":\"#0 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(129): PDOStatement->execute()\\n#1 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Statement.php(155): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(241): Doctrine\\\\DBAL\\\\Statement->execute()\\n#3 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(119): OCP\\\\AppFramework\\\\Db\\\\Mapper->execute()\\n#4 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/Authentication\\\/Token\\\/DefaultTokenProvider.php(101): OCP\\\\AppFramework\\\\Db\\\\Mapper->insert()\\n#5 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(732): OC\\\\Authentication\\\\Token\\\\DefaultTokenProvider->generateToken(*** sensitive parameters replaced ***)\\n#6 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/private\\\/User\\\/Session.php(981): OC\\\\User\\\\Session->createSessionToken()\\n#7 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/OAuth2.php(121): OC\\\\User\\\\Session->tryAuthModuleLogin()\\n#8 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/oauth2\\\/lib\\\/Sabre\\\/AbstractBearer.php(99): OCA\\\\OAuth2\\\\Sabre\\\\OAuth2->validateBearerToken()\\n#9 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(182): OCA\\\\OAuth2\\\\Sabre\\\\AbstractBearer->check()\\n#10 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Auth\\\/Plugin.php(137): Sabre\\\\DAV\\\\Auth\\\\Plugin->check()\\n#11 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): Sabre\\\\DAV\\\\Auth\\\\Plugin->beforeMethod()\\n#12 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(456): Sabre\\\\DAV\\\\Server->emit()\\n#13 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#14 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/lib\\\/Server.php(330): Sabre\\\\DAV\\\\Server->start()\\n#15 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#16 \\\/home\\\/artur\\\/www\\\/owncloud-core\\\/remote.php(165): require_once('\\\/home\\\/artur\\\/www...')\\n#17 {main}\",\"File\":\"\\\/home\\\/artur\\\/www\\\/owncloud-core\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":129}"}
{"reqId":"FMUoeXM1SpWLegl7pCd3","level":1,"time":"2020-10-27T11:08:40+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"admin_audit","method":"GET","url":"\/owncloud-core\/\/remote.php\/dav\/avatars\/uu2\/128.png","message":"User uu2 logged into ownCloud from IP address: 127.0.0.1","action":"user_login","success":true,"CLI":false,"userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:82.0) Gecko\/20100101 Firefox\/82.0","auditGroups":[],"auditUsers":["uu2"],"actor":"user <uu2>, displayName <uu2>"}
{"reqId":"fXeZqbrs4VkV32JzwGXq","level":1,"time":"2020-10-27T11:08:41+00:00","remoteAddr":"127.0.0.1","user":"uu2","app":"admin_audit","method":"GET","url":"\/owncloud-core\/remote.php\/dav\/files\/uu2\/block-aligned-plus-one.txt?a=1&c=126d15927398b591319dc65d625e08e5&preview=1&scalingup=0","message":"Read \"\/uu2\/files\/block-aligned-plus-one.txt\" by user <uu2>, displayName <uu2>, owner: uu2","action":"file_read","path":"\/uu2\/files\/block-aligned-plus-one.txt","fileId":"2147502267","owner":"uu2","CLI":false,"userAgent":"Mozilla\/5.0 (X11; Ubuntu; Linux x86_64; rv:82.0) Gecko\/20100101 Firefox\/82.0","auditGroups":[],"auditUsers":["uu2"],"actor":"user <uu2>, displayName <uu2>"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions