[Bug]: duplicate key value violates unique constraint "filecache_extended_pkey" #31997
Comments
urandom2
added
0. Needs triage
|
I reproduce that same issue with PostgreSQL 10.22 and Nextcloud 24.0.7. |
|
I guess I have the same Error and maybe bit more?! Nextcloud 25.0.1 |
|
Me too. AIO v3.0.0 (nc 24.0.7). I received a complaint that an "internal share link" (linking to a shared folder) could not be clicked from the email. i remember that share was renamed a while ago, and now the folder starts with a unicode/emoji character. could that 'renaming' be an issue? |
|
the same error. Nextcloud 25.0.2 Debian 5.10.149-2; |
|
same error nextcloud 25.0.3 PHP 8.1.2 PostgreSQL 14.6 |
|
Half a year later, this error still persists: This Nextcloud instance was Installed via the AIO Docker Image on Linux 4.4.302+ x86_64 (Synology stock kernel for DS 1019+). The failing SQL queries aren't logged in Nextcloud's log but only show up in the database container's logs. |
Yes, also still struggeling with this Error :/ |
|
Duplicate of #19494 Let's consolidate progress tracking there. Feel free to subscribe to that issue if it impacts you and/or give it a 👍 |
Bug description
When uploading files from the mobile app, most succeed, however some fail. If you try and upload again from the mobile app, desktop, or website, the failure is not present, thus it appears to be some type of race condition. There are failures in the postgres logs that imply it is a unique key constraint that is causing the issue.
Steps to reproduce
Connection errorfailure in the upload pagesExpected behavior
All the files should successfully upload.
Installation method
Other
Operating system
Other
PHP engine version
PHP 8.1
Web server
Nginx
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Updated from a minor version (ex. 22.2.3 to 22.2.4)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "nextcloud.example.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "23.0.3.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "", "dbuser": "***REMOVED SENSITIVE VALUE***", "installed": true, "theme": "", "maintenance": false, "apps_paths": [ { "path": "\/usr\/share\/webapps\/nextcloud\/apps", "url": "\/apps", "writable": true } ], "appstore.experimental.enabled": true, "loglevel": 0, "trashbin_retention_obligation": "auto", "htaccess.RewriteBase": "\/", "mail_smtpmode": "smtp", "overwrite.cli.url": "https:\/\/nextcloud.example.com", "memcache.local": "\\OC\\Memcache\\APCu", "filelocking.enabled": true, "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "app_install_overwrite": [ "calendar", "keeweb", "impersonate", "groupfolders", "files_accesscontrol", "tasks", "twofactor_nextcloud_notification", "unsplash", "contacts" ], "mysql.utf8mb4": true, "mail_sendmailmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "default_phone_region": "US" } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
The postgresql log shows the following three lines repeated:
This does not appear to be unique, see #19494 and #12729.
The text was updated successfully, but these errors were encountered: