Server: Can't remove linked file shared by other Nextcloud from my Nextcloud

[juliusbr]

Steps to reproduce

File shared from another Nextcloud, add file to your Nextcloud via federated sharing, then the other Nextcloud got shut down.

Expected behaviour

File can be removed from my Nextcloud

Actual behaviour

I can't delete/move/copy the shared file in my Nextcloud. I can't remove the federated share from my Nextcloud

Server configuration detail

Operating system: Linux 4.15.0-99-generic #100-Ubuntu SMP Wed Apr 22 20:32:56 UTC 2020 x86_64

Webserver: Apache/2.4.29 (Ubuntu) (apache2handler)

Database: mysql 10.1.44

PHP version:

7.2.24-0ubuntu0.18.04.4
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, apache2handler, mysqlnd, PDO, xml, apcu, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, imap, intl, json, exif, msgpack, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, smbclient, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, memcached, libsmbclient, Zend OPcache

Nextcloud version: 18.0.4 - 18.0.4.2

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

Where did you install Nextcloud from: Manual

Signing status

List of activated apps

Enabled:
 - accessibility: 1.4.0
 - activity: 2.11.0
 - analytics: 2.2.3
 - apporder: 0.9.0
 - bookmarks: 2.3.4
 - bruteforcesettings: 1.6.0
 - calendar: 2.0.3
 - camerarawpreviews: 0.7.3
 - checksum: 0.4.4
 - cloud_federation_api: 1.1.0
 - comments: 1.8.0
 - contacts: 3.3.0
 - cookbook: 0.6.4
 - dav: 1.14.0
 - deck: 0.8.2
 - documentserver_community: 0.1.5
 - drawio: 0.9.5
 - extract: 1.2.4
 - federatedfilesharing: 1.8.0
 - federation: 1.8.0
 - files: 1.13.1
 - files_automatedtagging: 1.8.2
 - files_downloadactivity: 1.7.0
 - files_linkeditor: 1.0.13
 - files_mindmap: 0.0.21
 - files_pdfviewer: 1.7.0
 - files_photospheres: 1.0.8
 - files_rightclick: 0.15.2
 - files_sharing: 1.10.1
 - files_trashbin: 1.8.0
 - files_versions: 1.11.0
 - files_videoplayer: 1.7.0
 - firstrunwizard: 2.7.0
 - issuetemplate: 0.6.0
 - keeweb: 0.6.2
 - logreader: 2.3.0
 - lookup_server_connector: 1.6.0
 - mail: 1.3.4
 - maps: 0.1.6
 - metadata: 0.11.1
 - music: 0.14.0
 - news: 14.1.6
 - nextcloud_announcements: 1.7.0
 - notes: 3.2.0
 - notifications: 2.6.0
 - oauth2: 1.6.0
 - ocr: 6.0.33
 - ocsms: 2.1.7
 - onlyoffice: 4.1.4
 - password_policy: 1.8.0
 - phonetrack: 0.6.2
 - photos: 1.0.0
 - polls: 1.3.0
 - previewgenerator: 2.3.0
 - privacy: 1.2.0
 - provisioning_api: 1.8.0
 - radio: 0.6.6
 - recommendations: 0.6.0
 - sensorlogger: 0.1.2
 - serverinfo: 1.8.0
 - settings: 1.0.0
 - sharebymail: 1.8.0
 - social: 0.2.101
 - socialsharing_email: 2.0.0
 - spreed: 8.0.8
 - support: 1.1.0
 - survey_client: 1.6.0
 - suspicious_login: 3.1.0
 - systemtags: 1.8.0
 - tasks: 0.12.2
 - text: 2.0.0
 - theming: 1.9.0
 - twofactor_backupcodes: 1.7.0
 - twofactor_email: 1.0.1
 - twofactor_nextcloud_notification: 2.3.0
 - twofactor_totp: 4.1.3
 - twofactor_u2f: 5.1.0
 - unsplash: 1.1.5
 - updatenotification: 1.8.0
 - viewer: 1.2.0
 - weather: 1.7.2
 - workflow_pdf_converter: 1.3.1
 - workflow_script: 1.3.1
 - workflowengine: 2.0.0
Disabled:
 - admin_audit
 - emlviewer
 - encryption
 - files_external
 - ojsxc
 - qownnotesapi
 - ransomware_detection
 - user_ldap

Configuration (config/config.php)

{
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "***REMOVED SENSITIVE VALUE***"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "18.0.4.2",
    "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpmode": "smtp",
    "mail_sendmailmode": "smtp",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpsecure": "tls",
    "mail_smtpauth": 1,
    "mail_smtpport": "587",
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "maintenance": false,
    "default_language": "de",
    "memcache.local": "\\OC\\Memcache\\APCu",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "port": 6379
    },
    "memcache.distributed": "\\OC\\Memcache\\Memcached",
    "memcached_servers": [
        [
            "localhost",
            11211
        ]
    ],
    "app_install_overwrite": [
        "keeweb",
        "social",
        "ocsms",
        "weather"
    ],
    "enable_previews": true,
    "preview_max_x": 4096,
    "preview_max_y": 4096,
    "theme": "",
    "loglevel": 2,
    "htaccess.RewriteBase": "\/",
    "updater.release.channel": "stable",
    "has_rebuilt_cache": true,
    "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
    "enabledPreviewProviders": [
        "OC\\Preview\\PNG",
        "OC\\Preview\\JPEG",
        "OC\\Preview\\GIF",
        "OC\\Preview\\BMP",
        "OC\\Preview\\XBitmap",
        "OC\\Preview\\MP3",
        "OC\\Preview\\TXT",
        "OC\\Preview\\MarkDown",
        "OC\\Preview\\MSOfficeDoc",
        "OC\\Preview\\MSOffice2003",
        "OC\\Preview\\MSOffice2007",
        "OC\\Preview\\Movie",
        "OC\\Preview\\Font",
        "OC\\Preview\\SVG",
        "OC\\Preview\\MKV",
        "OC\\Preview\\MP4",
        "OC\\Preview\\AVI",
        "OC\\Preview\\Image",
        "OC\\Preview\\OpenDocument",
        "OC\\Preview\\PDF"
    ]
}

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

Are you using encryption: No

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

Client configuration

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.122 Safari/537.36 Edg/81.0.416.64

Operating system: Windows 10 1909

Logs

Web server error log

Nextcloud log

[no app in context] Error: OCP\Files\StorageNotAvailableException:  at <<closure>>

 0. /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Availability.php line 382
    OC\Files\Storage\Wrapper\Availability->checkAvailability()
 1. /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php line 379
    OC\Files\Storage\Wrapper\Availability->hasUpdated("", 1576655510)
 2. /var/www/nextcloud/lib/private/Files/Cache/Watcher.php line 127
    OC\Files\Storage\Wrapper\Wrapper->hasUpdated("", 1576655510)
 3. /var/www/nextcloud/lib/private/Files/View.php line 1342
    OC\Files\Cache\Watcher->needsUpdate("", OC\Files\Cache\CacheEntry {})
 4. /var/www/nextcloud/lib/private/Files/View.php line 1384
    OC\Files\View->getCacheEntry(OCA\Files_Trashb ... l}, "", "/Julius/files/Videos/Eye in the Sky.mp4")
 5. /var/www/nextcloud/lib/private/Files/Node/Root.php line 200
    OC\Files\View->getFileInfo("/Julius/files/Videos/Eye in the Sky.mp4")
 6. /var/www/nextcloud/lib/private/Files/Node/Folder.php line 137
    OC\Files\Node\Root->get("/Julius/files/Videos/Eye in the Sky.mp4")
 7. /var/www/nextcloud/apps/files_downloadactivity/lib/Activity/Listener.php line 148
    OC\Files\Node\Folder->get("/Videos/Eye in the Sky.mp4")
 8. /var/www/nextcloud/apps/files_downloadactivity/lib/Activity/Listener.php line 82
    OCA\FilesDownloadActivity\Activity\Listener->getSourcePathAndOwner("/Videos/Eye in the Sky.mp4")
 9. /var/www/nextcloud/apps/files_downloadactivity/lib/AppInfo/Application.php line 47
    OCA\FilesDownloadActivity\Activity\Listener->readFile("/Videos/Eye in the Sky.mp4")
10. /var/www/nextcloud/lib/private/legacy/hook.php line 111
    OCA\FilesDownloadActivity\AppInfo\Application->listenReadFile({path: "/Videos/Eye in the Sky.mp4"})
11. /var/www/nextcloud/lib/private/Files/View.php line 1283
    OC_Hook::emit("OC_Filesystem", "read", {path: "/Videos/Eye in the Sky.mp4"})
12. /var/www/nextcloud/lib/private/Files/View.php line 1145
    OC\Files\View->runHooks(["read"], "/Videos/Eye in the Sky.mp4")
13. /var/www/nextcloud/lib/private/Files/View.php line 996
    OC\Files\View->basicOperation("fopen", "/Julius/files/Videos/Eye in the Sky.mp4", ["read"], "r")
14. /var/www/nextcloud/lib/private/Files/Node/File.php line 114
    OC\Files\View->fopen("/Julius/files/Videos/Eye in the Sky.mp4", "r")
15. /var/www/nextcloud/lib/private/Preview/ProviderV2.php line 86
    OC\Files\Node\File->fopen("r")
16. /var/www/nextcloud/lib/private/Preview/Movie.php line 52
    OC\Preview\ProviderV2->getLocalFile(OC\Files\Node\File {}, 5242880)
17. /var/www/nextcloud/lib/private/Preview/GeneratorHelper.php line 62
    OC\Preview\Movie->getThumbnail(OC\Files\Node\File {}, 4096, 4096)
18. /var/www/nextcloud/lib/private/Preview/Generator.php line 205
    OC\Preview\GeneratorHelper->getThumbnail(OC\Preview\Movie {}, OC\Files\Node\File {}, 4096, 4096)
19. /var/www/nextcloud/lib/private/Preview/Generator.php line 127
    OC\Preview\Generator->getMaxPreview(OC\Files\SimpleFS\SimpleFolder {}, OC\Files\Node\File {}, "video/mp4", "")
20. /var/www/nextcloud/lib/private/PreviewManager.php line 185
    OC\Preview\Generator->getPreview(OC\Files\Node\File {}, 500, 500, true, "fill", "video/mp4")
21. /var/www/nextcloud/core/Controller/PreviewController.php line 172
    OC\PreviewManager->getPreview(OC\Files\Node\File {}, 500, 500, true, "fill")
22. /var/www/nextcloud/core/Controller/PreviewController.php line 144
    OC\Core\Controller\PreviewController->fetchPreview(OC\Files\Node\File {}, 500, 500, false, false, "fill")
23. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 170
    OC\Core\Controller\PreviewController->getPreviewByFileId(180022, 500, 500, false, false, "fill")
24. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OC\Core\Controller\PreviewController {}, "getPreviewByFileId")
25. /var/www/nextcloud/lib/private/AppFramework/App.php line 125
    OC\AppFramework\Http\Dispatcher->dispatch(OC\Core\Controller\PreviewController {}, "getPreviewByFileId")
26. /var/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("OC\\Core\\Controller\\PreviewController", "getPreviewByFileId", OC\AppFramework\ ... {}, {_route: "core.P ... "})
27. <<closure>>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "core.P ... "})
28. /var/www/nextcloud/lib/private/Route/Router.php line 299
    call_user_func(OC\AppFramework\ ... {}, {_route: "core.P ... "})
29. /var/www/nextcloud/lib/base.php line 1008
    OC\Route\Router->match("/core/preview")
30. /var/www/nextcloud/index.php line 38
    OC::handleRequest()

GET /core/preview?fileId=180022&c=18885fb17cef0b6fa641e4efe8f5924b&x=500&y=500&forceIcon=0
from 2003:e2:ef04:6d00:ed34:c686:a5f2:ad44 by Julius at 2020-04-29T22:07:07+00:00




[webdav] Fatal: Sabre\DAV\Exception\ServiceUnavailable:  at <<closure>>

0. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php line 76
   OCA\DAV\Connector\Sabre\Directory->getChild("Eye in the Sky.mp4")
1. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php line 178
   Sabre\DAV\Tree->getNodeForPath("files/Julius/Videos/Eye in the Sky.mp4")
2. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 287
   Sabre\DAV\Tree->delete("files/Julius/Videos/Eye in the Sky.mp4")
3. <<closure>>
   Sabre\DAV\CorePlugin->httpDelete(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
4. /var/www/nextcloud/3rdparty/sabre/event/lib/EventEmitterTrait.php line 105
   call_user_func_array([Sabre\DAV\CorePlugin {},"httpDelete"], [Sabre\HTTP\Requ ... }])
5. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 479
   Sabre\Event\EventEmitter->emit("method:DELETE", [Sabre\HTTP\Requ ... }])
6. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php line 254
   Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Reque ... "}, Sabre\HTTP\Response {})
7. /var/www/nextcloud/apps/dav/lib/Server.php line 319
   Sabre\DAV\Server->exec()
8. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php line 35
   OCA\DAV\Server->exec()
9. /var/www/nextcloud/remote.php line 165
   require_once("/var/www/nextcl ... p")

DELETE /remote.php/dav/files/Julius/Videos/Eye%20in%20the%20Sky.mp4
from 2003:e2:ef04:6d00:ed34:c686:a5f2:ad44 by Julius at 2020-04-29T22:05:01+00:00

Browser log

[alexbijma]

i'm facing the same problem on Nextcloud 17

[jospoortvliet]

Yeah, I've seen this too - I think it's kind of a known issue :cry:

[petre2dor]

Same here. I had to add the offending files to Ignore List in my Desktop Client in order to prevent constant errors.

[langfingaz]

This problem persists even in NC version 19 ...

[langfingaz]

I had one file (shared with me via federation) in the "/shared" folder (which contains many other available files) of my Nextcloud. As the federated instance is not accessible, I could not sync the whole folder with the Nextcloud desktop client for linux:

{
  "reqId": "XxNHbPEPuZ95H2XFFR-Y9gAAAFA",
  "level": 4,
  "time": "2020-07-18T19:03:08+00:00",
  "remoteAddr": "84.163.59.158",
  "user": "ncp",
  "app": "webdav",
  "method": "GET",
  "url": "/remote.php/dav/files/ncp/shared/IMG_5085.jpg",
  "message": {
    "Exception": "Sabre\\DAV\\Exception\\ServiceUnavailable",
    "Message": "",
    "Code": 0,
    ...
  }
}

---

A way to manually delete external external shares from the database is described here: https://blog.cubieserver.de/2018/remove-nextcloud-share-from-database/. This worked for me but should only be used with caution!

Steps:
1) DELETE FROM oc_share_external WHERE id = XXX LIMIT 1;
2) DELETE FROM oc_mounts WHERE id = XXX LIMIT 1;

[juliusbr]

I was able to "fix" the problem by removing the shared file via Files -> Shares (the one on the left side) and then select "delete file". I was still unable to remove the shared file by going to the Videos folder, so the problem still exists, but at least in my case there was a workaround.