Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can. 
The Basics
- Nextcloud Server version (e.g., 29.x.x):
30.0.2
- Operating system and version (e.g., Ubuntu 24.04):
official docker image
- Web server and version (e.g, Apache 2.4.25):
apache
- Is this the first time you’ve seen this error? (Yes / No):
YES
- When did this problem seem to first start?
after issues with migration to newer version
- Installation method (e.g. AIO, NCP, Bare Metal/Archive, etc.)
docker nextcloud:stable
- Are you using Cloudflare, mod_security, or similar? (Yes / No)
no
Summary of the issue you are facing:
`
- Upgraded image to latest stable tag. As I was upgrading from v. 28 and latest was 30 it failed.
- So I set v 29.0.9 in compose file and upgraded
- After it finished I changed to :stable in compose file and upgraded.
The issue was I did not run occ upgrade between docker image upgrade.
To full scripts I changed version in config file to 29.0.9(it was still 28.0.6.1 there) and run “occ upgrade”
Database was updated and then came the exception:
InvalidArgumentException: Index name “nid” for table “social_3_cache_actor” collides with the constraint on table “social_3_stream”
`
Log entries
Updating <user_status> ... Updated <user_status> to 1.10.0 Updating <viewer> ... Updated <viewer> to 3.0.0 Update app recognize from App Store Update app calendar from App Store Update app contacts from App Store Update app external from App Store Update app gpxpod from App Store Update app groupfolders from App Store Update app maps from App Store Update app side_menu from App Store Update app spreed from App Store InvalidArgumentException: Index name "nid" for table "social_3_cache_actor" collides with the constraint on table "social_3_stream". Update failed Maintenance mode is kept active Resetting log level
Configuration
{ "system": { "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "192.168.84.101:8880", "stratus.othar.pl" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "29.0.9", "overwriteprotocol": "https", "overwrite.cli.url": "http:\/\/192.168.84.101:8880", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "maintenance": false, "loglevel": 0, "app_install_overwrite": [ "calendar", "social", "joplin", "spreed" ], "theme": "", "mail_smtpmode": "smtp", "mail_smtpauthtype": "LOGIN", "mail_sendmailmode": "smtp", "mail_smtpauth": 1, "mail_smtpsecure": "ssl", "default_phone_region": "PL", "memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/exiftool-amd64-glibc", "memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/go-vod-amd64", "preview_max_x": 1024, "preview_max_y": 1024, "memories.db.triggers.fcu": true } }
Apps
`
Enabled:
- activity: 3.0.0
- calendar: 5.0.1
- camerarawpreviews: 0.8.6
- circles: 30.0.0
- cloud_federation_api: 1.13.0
- comments: 1.20.1
- contacts: 6.1.1
- contactsinteraction: 1.11.0
- dashboard: 7.10.0
- dav: 1.31.1
- external: 5.5.2
- federatedfilesharing: 1.20.0
- federation: 1.20.0
- files: 2.2.0
- files_external: 1.22.0
- files_pdfviewer: 3.0.0
- files_reminders: 1.3.0
- files_sharing: 1.22.0
- files_trashbin: 1.20.1
- files_versions: 1.23.0
- firstrunwizard: 3.0.0
- gpxpod: 7.0.4
- groupfolders: 18.0.5
- integration_homeassistant: 0.0.5
- logreader: 3.0.0
- lookup_server_connector: 1.18.0
- maps: 1.5.0
- memories: 7.4.1
- nextcloud_announcements: 2.0.0
- notes: 4.11.0
- notifications: 3.0.0
- oauth2: 1.18.1
- password_policy: 2.0.0
- passwords: 2024.11.20
- phonetrack: 0.8.1
- photos: 3.0.2
- previewgenerator: 5.7.0
- privacy: 2.0.0
- provisioning_api: 1.20.0
- qownnotesapi: 24.11.0
- recognize: 8.1.1
- recommendations: 3.0.0
- related_resources: 1.5.0
- serverinfo: 2.0.0
- settings: 1.13.0
- sharebymail: 1.20.0
- side_menu: 4.0.1
- spreed: 20.0.2
- survey_client: 2.0.0
- systemtags: 1.20.0
- tasks: 0.16.1
- text: 4.1.0
- theming: 2.5.0
- twofactor_backupcodes: 1.19.0
- twofactor_totp: 12.0.0-dev
- unsplash: 3.0.3
- updatenotification: 1.20.0
- user_status: 1.10.0
- viewer: 3.0.0
- workflowengine: 2.12.0
Disabled: - admin_audit: 1.20.0
- app_api: 4.0.0
- bruteforcesettings: 3.0.0
- encryption: 2.18.0
- files_downloadlimit: 3.0.0
- files_rightclick: 0.15.1 (installed 1.6.0)
- impersonate: 1.15.0 (installed 1.15.0)
- news: 24.0.0 (installed 24.0.0)
- support: 2.0.0 (installed 1.0.1)
- suspicious_login: 8.0.0
- twofactor_nextcloud_notification: 4.0.0
- user_ldap: 1.21.0
- weather_status: 1.10.0 (installed 1.7.0)
- webhook_listeners: 1.1.0-dev
`