Command "db:add-missing-primary-keys" is not defined after upgrade to 20.0.2 RC1

eehmke · November 13, 2020, 10:26am

I upgraded my beta testinstance to 20.0.2 RC1. The upgrade itself went fine. Thereafter, in the Overview page, it displayed the message

The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running “occ db:add-missing-primary-keys” those missing primary keys could be added manually while the instance keeps running.

When I run the suggested command, I get:

Command "db:add-missing-primary-keys" is not defined.                                                                                                                                                        
                                                                                                                                                                                                               
  Did you mean one of these?                                                                                                                                                                                   
      db:add-missing-columns                                                                                                                                                                                   
      db:add-missing-indices                                                                                                                                                                                   
      db:convert-filecache-bigint                                                                                                                                                                              
      db:convert-mysql-charset                                                                                                                                                                                 
      db:convert-type

Is there something wrong with the occ command?

j-ed · November 13, 2020, 10:56am

It seems that they’ve just forgotten to register the new command correctly. Check-out the following issue report which refers to a pull request which fixes the problem:

github.com/nextcloud/server

[20.0.2RC1] db:add-missing-primary-keys is not defined

opened 10:43PM - 12 Nov 20 UTC

closed 02:39PM - 13 Nov 20 UTC

MichaIng

bug 3. to review

### How to use GitHub * Please use the 👍 [reaction](https://blog.github.com/2016-03-10-add-reactions-to-pull-requests-issues-and-comments/) to show that you are affected by the same issue. * Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue. * Subscribe to receive notifications on status change and new comments. ### Steps to reproduce 1. Upgrade NC from 20.0.1 to 20.0.2RC1 2. Run `occ db:add-missing-primary-keys` 3. Watch admin panel telling you: > The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running "occ db:add-missing-primary-keys" those missing primary keys could be added manually while the instance keeps running. ### Expected behaviour The suggested command can be executed. ### Actual behaviour The suggested command cannot be executed: ``` Command "db:add-missing-primary-keys" is not defined. Did you mean one of these? db:add-missing-columns db:add-missing-indices db:convert-filecache-bigint db:convert-mysql-charset db:convert-type ``` ### Server configuration **Operating system:** Debian Bullseye **Web server:** `2.4.46` **Database:** `10.3.24` **PHP version:** `7.4.11` **Nextcloud version:** `20.0.2RC1` **Updated from an older Nextcloud/ownCloud or fresh install:** Upgrade from 20.0.1 **Where did you install Nextcloud from:** https://download.nextcloud.com/server/releases/ **Signing status:** <details> <summary>Signing status</summary> ``` No errors have been found. ``` </details> **List of activated apps:** <details> <summary>App list</summary> ``` Enabled: - accessibility: 1.6.0 - activity: 2.13.3 - apporder: 0.11.0 - calendar: 2.1.2 - cloud_federation_api: 1.3.0 - contacts: 3.4.1 - dashboard: 7.0.0 - dav: 1.16.1 - federatedfilesharing: 1.10.1 - files: 1.15.0 - files_rightclick: 0.17.0 - files_trashbin: 1.10.1 - files_versions: 1.13.0 - impersonate: 1.7.0 - logreader: 2.5.0 - lookup_server_connector: 1.8.0 - nextcloud_announcements: 1.9.0 - notes: 4.0.0 - notifications: 2.8.0 - oauth2: 1.8.0 - photos: 1.2.0 - previewgenerator: 3.0.1 - provisioning_api: 1.10.0 - ransomware_protection: 1.8.0 - settings: 1.2.0 - spreed: 10.0.1 - survey_client: 1.8.0 - tasks: 0.13.6 - twofactor_backupcodes: 1.9.0 - updatenotification: 1.10.0 - viewer: 1.4.0 - workflowengine: 2.2.0 Disabled: - admin_audit - comments - contactsinteraction - encryption - federation - files_external - files_pdfviewer - files_sharing - files_videoplayer - firstrunwizard - password_policy - privacy - recommendations - serverinfo - sharebymail - support - systemtags - text - theming - user_ldap - user_status - weather_status ``` </details> **Nextcloud configuration:** <details> <summary>Config report</summary> ``` { "system": { "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost", "micha.gnoedi.org" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "20.0.2.0", "memcache.local": "\\OC\\Memcache\\APCu", "filelocking.enabled": true, "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "loglevel": 2, "logtimezone": "Europe\/Berlin", "filesystem_check_changes": 0, "hashingThreads": 4, "hashingMemoryCost": 16384, "hashingTimeCost": 3, "trashbin_retention_obligation": "disabled", "versions_retention_obligation": "disabled", "skeletondirectory": "", "maintenance": false, "overwrite.cli.url": "https:\/\/micha.gnoedi.org\/nextcloud", "htaccess.RewriteBase": "\/nextcloud", "mail_smtpmode": "smtp", "mail_smtpauthtype": "LOGIN", "mail_smtpsecure": "ssl", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauth": 1, "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "theme": "", "knowledgebaseenabled": false, "mysql.utf8mb4": true, "updater.release.channel": "beta", "tempdirectory": "\/mnt\/sda\/ncdata\/tmp", "preview_max_x": 2048, "preview_max_y": 2048, "jpeg_quality": 60, "app_install_overwrite": [ "apporder", "calendar", "impersonate", "ransomware_protection", "contacts", "spreed" ], "updater.secret": "***REMOVED SENSITIVE VALUE***" } } ``` </details> **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:** none ### Logs None

eehmke · November 13, 2020, 11:08am

That worked, thank you!

sbh · November 19, 2020, 6:41pm

How does this work on a hosted site (ionos): I only have access to phpmyadmin. What are the commands to change it there?

rakekniven · November 19, 2020, 6:51pm

That depends on your hoster: Please file a ticket and ask for a solution.

Some offer to execute commands via WebGUI, some offer shell access with limited functions.

sbh · November 19, 2020, 7:03pm

Thanks. I just solved it with this command in PHPMyadmin:

alter table TABLE_NAME add column `id` int(10) unsigned primary AUTO_INCREMENT;

rakekniven · November 19, 2020, 7:05pm

Haven’t mentioned that, sorry.
Sometimes it has bad results to recommend people executing SQL statements

Well done!