Trash bin database inconsistent!

Aurnytoraink · June 27, 2020, 8:45am

Nextcloud version : 19.0.0.12
Operating system and version: Ubuntu Server 18.04
Apache or nginx version : 2.4.38
PHP version : 7.4.6

The issue you are facing:

My trashbin says I have files in it but when I look in the data folder, it’s empty.
It looks like my trash database is corrupted.

ScreenshotFichiers supprimés

Is this the first time you’ve seen this error? : Y

Steps to replicate it:

Go to the trashbin
Select all files
Try to restore them but they don’t exist

The output of your Nextcloud log in Admin > Logging:

{"reqId":"jfavQopAlNiWmkwdTDjG","level":3,"time":"2020-06-27T08:01:16+00:00","remoteAddr":"172.20.0.3","user":"Aurnytoraink","app":"files_trashbin","method":"MOVE","url":"/remote.php/dav/trashbin/Aurnytoraink/trash/Cahier%20des%20charges%20Mobile%20RO.pdf.d1576188465","message":"trash bin database inconsistent! ($user: Aurnytoraink $filename: Cahier des charges Mobile RO.pdf, $timestamp: 1576188465)","userAgent":"Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:77.0) Gecko/20100101 Firefox/77.0","version":"19.0.0.12","id":"5ef6fccd843b6"}

AndyXheli · April 19, 2021, 2:19pm

Same issue after upgrading to Nextcloud 21.0.1 from Nextcloud 20 i opned a issue on github

github.com/nextcloud/server

Nextcloud 21.0.1 Encryption Errors

opened 02:46AM - 10 Apr 21 UTC

andyxheli

0. Needs triage bug

When you delete a file and restore it it will not go back into the original loca…tion shows up in the main location and erros in the log file I never had this issue before after updating to 21.0.1 from 20.0.8 it came up <details> <summary> trash bin database inconsistent! ($user: axheli $filename: officialgooglecloudcertifiedassociatecloudengineerstudyguide.pdf, $timestamp: 1618022190) </summary> ``` {"reqId":6tqvLQotjcAg0MghPBeJ","level":3,"time":"2021-04-10T02:36:36+00:00","remoteAddr":"","user":"","app":"files_trashbin","method":"MOVE","url":"/remote.php/dav/trashbin/axheli/trash/officialgooglecloudcertifiedassociatecloudengineerstudyguide.pdf.d1618022190","message":"trash bin database inconsistent! ($user: axheli $filename: officialgooglecloudcertifiedassociatecloudengineerstudyguide.pdf, $timestamp: 1618022190)","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36","version":"21.0.1.1","id":"60710f70c9977"} ``` </details>

AndyXheli · April 22, 2021, 12:21am

I also found the same issue back in 2016 with owncloud

github.com/owncloud/core

Owncloud deleted all files - cannot restore from trash

opened 03:45PM - 03 Mar 16 UTC

closed 06:33PM - 04 Mar 16 UTC

erlendd

Type:Bug app:files_trashbin needs info sev1-critical

### Steps to reproduce 1. I left a MacOSX with updated owncloud client to upload files 2. Next day all files were in trash 3. From trash, try to restore but cannot due to error (from owncloud.log: "trash bin database inconsistent!" ### Expected behaviour Files shouldn't have been deleted in the first place. Should be possible to restore files from trash. ### Actual behaviour Cannot restore the files from trash due to the error message "trash bin database inconsistent!". The files are in the trash in a hidden holder as such: ./files_trashbin/files/.d1456875723/ ### Server configuration **Operating system**: Raspbian based on debian wheezy **Web server:** Nginx 1.2.1 **Database:** Mysql 5.5.47 **PHP version:** PHP 5.4.45 **ownCloud version:** (see ownCloud admin page) 8.2.2 **Updated from an older ownCloud or fresh install:** Updated from older version. **Where did you install ownCloud from:** Via owncloud downloads. **Signing status (ownCloud 9.0 and above):** N/A **List of activated apps:** Enabled: - activity: 2.1.3 - files: 1.2.0 - files_external: 0.3.0 - files_locking: - files_pdfviewer: 0.7 - files_sharing: 0.7.0 - files_texteditor: 2.0 - files_trashbin: 0.7.0 - files_versions: 1.1.0 - files_videoviewer: 0.1.3 - firstrunwizard: 1.1 - gallery: 14.2.0 - provisioning_api: 0.3.0 - templateeditor: 0.1 - updater: 0.6 Disabled: - encryption - external - files_encryption - notifications - user_external - user_ldap - user_webdavauth **The content of config/config.php:** **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:** Linux ### Logs #### Web server error log #### ownCloud log (data/owncloud.log) ``` {"reqId":"2TtxGdHCFYsEv+YGYGfI","remoteAddr":"155.198.39.88","app":"files_trashbin","message":"trash bin database inconsistent!","level":3,"time":"2016-03-03T14:48:59+00:00","method":"POST","url":"\/index.php\/apps\/files_trashbin\/ajax\/undelete.php"} {"reqId":"2TtxGdHCFYsEv+YGYGfI","remoteAddr":"155.198.39.88","app":"trashbin","message":"can't restore files","level":3,"time":"2016-03-03T14:48:59+00:00","method":"POST","url":"\/index.php\/apps\/files_trashbin\/ajax\/undelete.php"} {"reqId":"7iscSzujOZZ1fIzPgW\/1","remoteAddr":"155.198.39.88","app":"PHP","message":"Array to string conversion at \/usr\/share\/nginx\/www\/owncloud\/lib\/private\/template\/functions.php#36","level":3,"time":"2016-03-03T14:49:17+00:00","method":"GET","url":"\/index.php\/settings\/admin"} {"reqId":"7iscSzujOZZ1fIzPgW\/1","remoteAddr":"155.198.39.88","app":"PHP","message":"Undefined index: Please double check the <a target=\"_blank\" href=\"%s\">installation guides \u2197<\/a>, and check for any errors or warnings in the <a href=\"#log-section\">log<\/a>. at \/usr\/share\/nginx\/www\/owncloud\/lib\/private\/l10n\/string.php#64","level":3,"time":"2016-03-03T14:49:17+00:00","method":"GET","url":"\/index.php\/settings\/admin"} {"reqId":"7iscSzujOZZ1fIzPgW\/1","remoteAddr":"155.198.39.88","app":"PHP","message":"Undefined index: Please double check the <a target=\"_blank\" href=\"%s\">installation guides \u2197<\/a>, and check for any errors or warnings in the <a href=\"#log-section\">log<\/a>. at \/usr\/share\/nginx\/www\/owncloud\/lib\/private\/l10n\/string.php#70","level":3,"time":"2016-03-03T14:49:17+00:00","method":"GET","url":"\/index.php\/settings\/admin"} ```