[Bug]: Upgrade from 30.0.0 to 30.0.1 failed: There is no table with name "nextcloud.oc_taskprocessing_tasks" in the schema.

[jzisser9]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

I am attempting to upgrade from NextCloud 30.0.0.14 to 31.0.1.2. The server enters maintenance mode on startup to perform the update, but fails stating that the table "nextcloud.oc_taskprocessing_tasks" does not exist in the schema. I am using MariaDB as my database for Nextcloud ("nextcloud" is the name of the database I created).

I've tried creating the table manually but the error persists on startup. And I ran the following commands to try to prepare the app to upgrade:

occ app:update --all
occ db:add-missing-columns          
occ db:add-missing-indices          
occ db:add-missing-primary-keys

I've seen similar issues submitted here and on the forums, but none that address this specific error message for this specific table. Nevertheless, the solutions I tried above were pulled from those threads. They all ran successfully, but did not fix the issue.

My server is now stuck in maintenance mode and I'm not sure what else to try. I am using MariaDB version 11.5.2. Please see the full logs below.

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

using keys found in /config/keys
Initializing nextcloud 30.0.1.2 (this can take a while) ...
Upgrading nextcloud from 30.0.0.14 ...
Setting permissions
Setting log level to debug
Updating database schema
**Exception: Database error when running migration 30000Date20240906095113 for app core
There is no table with name "nextcloud.oc_taskprocessing_tasks" in the schema.**
Update failed
Maintenance mode is kept active
Resetting log level
Initializing finished
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2024-06-24 │ 2024-07-16 │ /config/nginx/site-confs/default.conf                                  │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.

Steps to reproduce

1. Spin up the server app
2. Attempt to visit server web site, land at "maintenance mode" page with no ability to continue
3. Check the logs to see the update failed

Expected behavior

Update succeeds, and the server spins up and is accessible.

Nextcloud Server version

30

Operating system

Other

PHP engine version

None

Web server

Nginx

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Updated from a MINOR version (ex. 28.0.1 to 28.0.2)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "192.168.68.4",
            "nc.jzisser.com"
        ],
        "dbtype": "mysql",
        "version": "30.0.0.14",
        "overwrite.cli.url": "https:\/\/192.168.68.4",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "filelocking.enabled": true,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0
        },
        "upgrade.disable-web": true,
        "maintenance": true,
        "maintenance_window_start": 2,
        "memories.db.triggers.fcu": true,
        "memories.exiftool": "\/config\/www\/nextcloud\/apps\/memories\/bin-ext\/exiftool-amd64-musl",
        "memories.vod.path": "\/config\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
        "memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
        "memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
        "enabledPreviewProviders": [
            "OC\\Preview\\Image",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\Movie"
        ],
        "memories.vod.disable": false,
        "loglevel": 2,
        "default_phone_region": "US",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.1
  - circles: 30.0.0-dev
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 6.1.0
  - contactsinteraction: 1.11.0
  - dashboard: 7.10.0
  - dav: 1.31.1
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.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
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - mail: 4.0.2
  - nextcloud_announcements: 2.0.0
  - notes: 4.11.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - onlyoffice: 9.5.0
  - password_policy: 2.0.0
  - photos: 3.0.2
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recognize: 8.1.1
  - recommendations: 3.0.0
  - registration: 2.5.0
  - related_resources: 1.5.0
  - richdocuments: 8.5.2
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - spreed: 20.0.1
  - support: 2.0.0
  - survey_client: 2.0.0
  - systemtags: 1.20.0
  - text: 4.1.0
  - theming: 2.5.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - user_status: 1.10.0
  - viewer: 3.0.0
  - weather_status: 1.10.0
  - webhook_listeners: 1.1.0-dev
  - workflowengine: 2.12.0
Disabled:
  - admin_audit: 1.20.0
  - app_api: 4.0.0
  - cospend: 2.0.0
  - encryption: 2.18.0
  - files_external: 1.22.0
  - memories: 7.4.1 (installed 7.4.1)
  - previewgenerator: 5.6.0 (installed 5.6.0)
  - suspicious_login: 8.0.0
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - user_ldap: 1.21.0

Nextcloud Signing status

Unable to access due to maintenance mode

Nextcloud Logs

{"reqId":"eRGLccpQqr8BPMgO6xEv","level":2,"time":"2024-10-23T12:19:25+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.52 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"uHTkdgA9UQkqNQK9Jao6","level":2,"time":"2024-10-23T12:22:31+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.52 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"qafv04bc2fURAo2SVWqD","level":2,"time":"2024-10-23T12:23:33+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.48 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"3MWZajeTCL1sg9MhW8lW","level":2,"time":"2024-10-23T12:25:37+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.47 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"JpcGAgpQDm9tOTDgoYSH","level":2,"time":"2024-10-23T12:26:39+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.44 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"Nlys28976B3ZlGnpyaMi","level":2,"time":"2024-10-23T12:27:41+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"soQS8hgf2pqpq8vQe17w","level":2,"time":"2024-10-23T12:28:43+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.49 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"gydXDx2pJO3uPUUWNWtF","level":2,"time":"2024-10-23T12:29:45+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"t1fKWjk1SBX0yPYuqm9Z","level":2,"time":"2024-10-23T12:59:43+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.4 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"hytDMcvbk31lt83KZxi4","level":2,"time":"2024-10-23T13:01:47+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"fwJEBio36IW66hCBJvQQ","level":2,"time":"2024-10-23T13:02:49+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.52 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"rSp4BmUuCMHcWpLoRZqZ","level":2,"time":"2024-10-23T13:03:51+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.44 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"mG2pNXroQVaFhZbgOYj4","level":2,"time":"2024-10-23T13:05:55+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.49 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"RAzQ8Hk4feSgo5e32aCP","level":2,"time":"2024-10-23T13:06:57+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.49 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"Q7xVK7AOdQhefz4pGjaP","level":2,"time":"2024-10-23T13:09:01+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.48 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"CbWFcLWFLeWKm7lFOHFd","level":2,"time":"2024-10-23T13:10:03+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"gy6mH9RTnLxbEGzSa8BU","level":2,"time":"2024-10-23T13:11:05+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.53 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"s9znZRBiv69HVCB7ddmD","level":2,"time":"2024-10-23T13:12:07+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.46 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"8hjf517QWNOF2MOu5Qbr","level":2,"time":"2024-10-23T13:13:10+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.52 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"13MbWwNoSCkp5UlDqUe1","level":2,"time":"2024-10-23T13:14:11+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.55 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"Rpi555X9LN2czAyPvwVu","level":2,"time":"2024-10-23T13:15:13+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.48 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"mPS1EyhyEI53frlkd3my","level":2,"time":"2024-10-23T13:17:17+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.45 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"v8mDoW1eYBHGCLuF6HCJ","level":2,"time":"2024-10-23T13:18:19+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"pMygiOwj2ir4HUnGFer1","level":2,"time":"2024-10-23T13:19:21+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.49 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"Bi0IsmrDspuohyZmr7Sr","level":2,"time":"2024-10-23T13:20:23+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.48 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"QGg2n9LehQEDy1qvZpZ8","level":2,"time":"2024-10-23T13:22:27+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"Irm9BMJKOn0wIcnUtpXE","level":2,"time":"2024-10-23T13:23:29+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.57 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"jsCpe1TX4wTkAPzGQd6s","level":2,"time":"2024-10-23T13:24:31+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.52 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"2yvmkXHPVn3dyr8xLl0D","level":2,"time":"2024-10-23T13:26:35+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.48 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"St9FhF8OEAagM4quvNqO","level":2,"time":"2024-10-23T13:27:37+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.49 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"oq5kcDVEFVXDu7WmFVYT","level":2,"time":"2024-10-23T13:28:39+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.42 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"VmXUp4KNPBbFzUupWgbu","level":2,"time":"2024-10-23T13:29:41+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"JFDu4XaaEaOobHalsrL1","level":2,"time":"2024-10-23T13:56:33+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.4 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"ay9KZnt2oRCohtn6pJUY","level":2,"time":"2024-10-23T14:00:41+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"M86z2UXllrjZX3Xu2X6D","level":2,"time":"2024-10-23T14:01:43+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.46 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"2A53AN2eIK28M77B5IjA","level":2,"time":"2024-10-23T14:02:45+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.46 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"9jOHnRhV9Nxze7ow27IY","level":2,"time":"2024-10-23T14:03:47+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.44 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"3mLe1c2iiYOzKPVip2zS","level":2,"time":"2024-10-23T14:05:51+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.45 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"dEAWz3K7GOUzT4CTAknO","level":2,"time":"2024-10-23T14:08:57+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"3aUyH1dtBRBqJuEyyMoi","level":2,"time":"2024-10-23T14:13:05+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.42 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"mhO48OwZWHcvqJZM4aUl","level":2,"time":"2024-10-23T14:16:12+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"gD6pxUcyVUah66rQQssq","level":2,"time":"2024-10-23T14:17:15+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.42 seconds to generate.","userAgent":"Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.0.0 ClientArchitecture: arm64 OsArchitecture: arm64)","version":"30.0.0.14","data":[]}
{"reqId":"kBftiVlJ67O9RkFBh0jt","level":2,"time":"2024-10-23T14:23:41+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.4 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"trxc7NfHDiBXmjNOT1p2","level":2,"time":"2024-10-23T14:27:49+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.4 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"CLD4LdvDkcXngRiIpfBJ","level":2,"time":"2024-10-23T14:28:51+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.4 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"FL6T5n4iMhDjZMZGsbiW","level":2,"time":"2024-10-23T14:29:53+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"zovIvBvxWcpYWAJJvFu3","level":2,"time":"2024-10-23T14:31:57+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.43 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"HwdmD3oXsb9dYsypY8n4","level":2,"time":"2024-10-23T14:35:03+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"3HIcgrXQ99oplWOqNErt","level":2,"time":"2024-10-23T14:36:05+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.44 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
{"reqId":"IxoN7ftCf1GsVXIe5U93","level":2,"time":"2024-10-23T14:39:11+00:00","remoteAddr":"70.19.109.45","user":"--","app":"no app in context","method":"GET","url":"/index.php/204","message":"Capabilities of OCA\\CloudFederationAPI\\Capabilities took 0.41 seconds to generate.","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.0.14","data":[]}
root@e69c28505e58:/# 

Additional info

No response

[joshtrichards]

**Exception: Database error when running migration 30000Date20240906095113 for app core
There is no table with name "nextcloud.oc_" in the schema.**

The taskprocessing_tasks table was in v30.0.0. I have no idea how you can possibly not have it in 30.0.1.

What's the output of NC_debug=1 ./occ migrations:status core?

Was your v30.0.0 a new installation or an upgrade too?

[jzisser9]

It has to have been an upgrade. To be honest with you, I only noticed that my NC client wasn't connecting to the server in the last couple of days, but it was working around a week ago. The only thing I can possibly think of is that my system auto-updated from v29 to v30 (I use an auto-update plugin on my unraid server, not some mechanism built into NC if it exists). I'll be turning that off for sure...

Unfortunately it doesn't seem like occ recognizes the migrations:status command. The only option I see in that category is migrations:preview. But I can access the MariaDB database if that's helpful.

[solracsf]

Edit the file /core/Migrations/Version30000Date20240906095113.php as:

<?php

declare(strict_types=1);

/**
 * SPDX-FileCopyrightText: 2024 Nextcloud GmbH and Nextcloud contributors
 * SPDX-License-Identifier: AGPL-3.0-or-later
 */

namespace OC\Core\Migrations;

use Closure;
use OCP\DB\ISchemaWrapper;
use OCP\Migration\Attributes\ModifyColumn;
use OCP\Migration\IOutput;
use OCP\Migration\SimpleMigrationStep;

#[ModifyColumn(table: 'taskprocessing_tasks', name: 'error_message', description: 'Increase column length to 4000 bytes to support longer error messages')]
class Version30000Date20240906095113 extends SimpleMigrationStep {

	/**
	 * @param IOutput $output
	 * @param Closure(): ISchemaWrapper $schemaClosure
	 * @param array $options
	 * @return null|ISchemaWrapper
	 */
	public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper {
		/** @var ISchemaWrapper $schema */
		$schema = $schemaClosure();

		if ($schema->hasTable('taskprocessing_tasks')) {
			$table = $schema->getTable('taskprocessing_tasks');
			$column = $table->getColumn('error_message');
	
			if ($column->getLength() < 4000) {
				$column->setLength(4000);
			}
		}
	
		return $schema;
	}
}

Run occ upgrade
Cc @kyteinsky

[kyteinsky]

Hi @jzisser9, would you mind posting the output to ./occ migrations:status core as Josh said? If you're using sudo, use -E option to pass the environment variable like so: NC_debug=1 sudo -E -u\#33 ./occ migrations:status core.
If it still doesn't work, set the debug param in config/config.php to true before running occ migrations:status core

[jzisser9]

Hi @kyteinsky , sorry if I wasn't clear: I tried running that command, but migrations:status core is not a command that my version of occ recognizes:

root@e69c28505e58:/# NC_debug=1 occ migrations:status core
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

                                               
  Command "migrations:status" is not defined.  
                                               
  Did you mean one of these?                   
      encryption:status                        
      migrations:preview                       
      twofactorauth:state                      

I'll try editing the config file...sorry, haven't had my caffeine yet this morning and missed that tip. :)

[joshtrichards]

It's available, but only when debug mode is specified. :)

[jzisser9]

Wow, yeah, didn't see that coming! I now have the output you asked for. Thanks @kyteinsky @joshtrichards ! Editing the config file did it.

Here's the output you asked for:

NC_debug=1 occ migrations:status core
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
    >> App:                                                core
    >> Version Table Name:                                 oc_migrations
    >> Migrations Namespace:                               OC\Core\Migrations
    >> Migrations Directory:                               /app/www/public/core/Migrations
    >> Previous Version:                                   30000Date20240814180800
    >> Current Version:                                    30000Date20240815080800
    >> Next Version:                                       30000Date20240906095113
    >> Latest Version:                                     30000Date20240906095113
    >> Executed Migrations:                                74
    >> Executed Unavailable Migrations:                    74
    >> Available Migrations:                               75
    >> New Migrations:                                     75
    >> Pending Migrations:                                 None

[jzisser9]

#48865 (comment)

@kyteinsky @joshtrichards do you recommend trying this? This was posted before I gave the output of the occ migrations:status core command.