Update from 13.05 to 14 Beta 1 failed: InvalidArgumentException: Index name "oc_dashboard_announcements"."oc_dashboard_announcements_pkey" is too long.

[morph027]

Steps to reproduce

1. Update from NC 13.05 to 14 Beta 1 using internal updater

Expected behaviour

Update should process

Actual behaviour

occ upgrade fails

root@nextcloud:~# sudo -u www-data -H php /var/www/nextcloud/occ upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Turned on maintenance mode
Updating database schema
InvalidArgumentException: Index name "oc_dashboard_announcements"."oc_dashboard_announcements_pkey" is too long.
Update failed
Maintenance mode is kept active
Reset log level

Server configuration

Operating system: Ubuntu Linux 16.04.5

Web server: Apache2 2.4

Database: Postgres 10.4

PHP version: 7.2

Nextcloud version: 13.05

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

Where did you install Nextcloud from: Manually

Signing status:

Signing status

Login as admin user into your Nextcloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

App list

Enabled:
  - activity: 2.6.1
  - admin_audit: 1.3.0
  - bruteforcesettings: 1.1.0
  - calendar: 1.6.1
  - caniupdate: 0.1.3
  - cloud_federation_api: true
  - comments: 1.3.0
  - contacts: 2.1.5
  - dav: 1.4.7
  - deck: 0.4.1
  - drawio: 0.9.0
  - federatedfilesharing: 1.3.1
  - federation: 1.3.0
  - files: 1.8.0
  - files_external: 1.4.1
  - files_fulltextsearch: 0.8.2
  - files_markdown: 2.0.4
  - files_pdfviewer: 1.2.1
  - files_reader: 1.2.3
  - files_rightclick: 0.8.4
  - files_sharing: 1.5.0
  - files_texteditor: 2.5.1
  - files_trashbin: 1.3.0
  - files_versions: 1.6.0
  - files_videoplayer: 1.2.0
  - firstrunwizard: 2.2.1
  - fulltextsearch: 0.8.1
  - fulltextsearch_elasticsearch: 0.8.0
  - gallery: 18.0.0
  - gpxpod: 2.2.2
  - impersonate: 1.0.4
  - logreader: 2.0.0
  - lookup_server_connector: 1.1.0
  - mail: 0.8.3
  - news: 12.0.4
  - nextcloud_announcements: 1.2.0
  - notes: 2.4.0
  - notifications: 2.1.2
  - oauth2: 1.1.1
  - ocr: 3.1.0-beta.1
  - passman: 2.1.4
  - password_policy: 1.3.0
  - provisioning_api: 1.3.0
  - richdocuments: 2.0.10
  - serverinfo: 1.3.0
  - sharebymail: 1.3.0
  - spreed: 3.2.5
  - survey_client: 1.1.0
  - systemtags: 1.3.0
  - theming: 1.4.5
  - twofactor_backupcodes: 1.2.3
  - twofactor_totp: 1.4.1
  - updatenotification: 1.3.0
  - workflowengine: 1.3.0
Disabled:
  - accessibility
  - encryption
  - end_to_end_encryption
  - support
  - user_external
  - user_ldap

Nextcloud configuration:

Config report

{
    "system": {
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "mail_smtpauth": 0,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "13.0.5.2",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "maintenance": true,
        "theme": "",
        "logtimezone": "Europe\/Berlin",
        "loglevel": 2,
        "overwritehost": "nextcloud.morph027.de",
        "overwrite.cli.url": "https:\/\/nextcloud.morph027.de",
        "overwriteprotocol": "https",
        "overwritewebroot": "\/",
        "trusted_domains": [
            "nextcloud.morph027.de",
            "nextcloud.lan"
        ],
        "forcessl": true,
        "secret": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": "true",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0,
            "dbindex": 0
        },
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "activity_expire_days": 90,
        "trashbin_retention_obligation": "auto",
        "app.mail.server-side-cache.enabled": true,
        "updatechecker": false,
        "htaccess.RewriteBase": "\/",
        "updater.release.channel": "beta",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED_FOR"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

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

[nextcloud-bot]

GitMate.io thinks possibly related issues are #10542 (InvalidArgumentException: Primary index name on "oc_conplus_cards_properties" is too long.), #3636 (Update fails), #10524 (InvalidArgumentException: Table name "oc_sensorlogger_device_data_types" is too long.), #4934 (beta 4 update failed), and #10095 (Update 13.0.4 Failed).

[morph027]

Okay, looks like #10518

[jospoortvliet]

@morph027 correct, that's the problem... I'll close this.