[Bug]: missing column `scheduled_at` after upgrade from 29.0.16 to 30.0.14

[leManu]

⚠️ 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

hi,

after upgrading Nextcloud Server from v29.0.16 to v30.0.14, occ setupchecks complains about missing column scheduled_at :

	ai:
		✗ Task Processing pickup speed: An exception occured while running the setup check:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'scheduled_at' in 'SELECT' in /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130
Stack trace:
#0 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(130): PDOStatement->execute(NULL)
#1 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\DBAL\Driver\PDO\Statement->execute()
#2 /home/nextcloud/nextcloud/lib/private/DB/Connection.php(415): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL)
#3 /home/nextcloud/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array)
#4 /home/nextcloud/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(289): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array)
#5 /home/nextcloud/nextcloud/lib/public/AppFramework/Db/QBMapper.php(313): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#6 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder))
#7 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Manager.php(1084): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1756730740, NULL)
#8 /home/nextcloud/nextcloud/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(38): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1756730740)
#9 /home/nextcloud/nextcloud/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run()
#10 /home/nextcloud/nextcloud/core/Command/SetupChecks.php(56): OC\SetupCheck\SetupCheckManager->runAll()
#11 /home/nextcloud/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\SetupChecks->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/nextcloud/nextcloud/core/Command/Base.php(213): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(1078): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\SetupChecks), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /home/nextcloud/nextcloud/lib/private/Console/Application.php(183): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /home/nextcloud/nextcloud/console.php(87): OC\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
#18 /home/nextcloud/nextcloud/occ(33): require_once('/home/nextcloud...')
#19 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'scheduled_at' in 'SELECT' in /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:24
Stack trace:
#0 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(132): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\DBAL\Driver\PDO\Statement->execute()
#2 /home/nextcloud/nextcloud/lib/private/DB/Connection.php(415): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL)
#3 /home/nextcloud/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array)
#4 /home/nextcloud/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(289): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array)
#5 /home/nextcloud/nextcloud/lib/public/AppFramework/Db/QBMapper.php(313): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#6 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder))
#7 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Manager.php(1084): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1756730740, NULL)
#8 /home/nextcloud/nextcloud/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(38): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1756730740)
#9 /home/nextcloud/nextcloud/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run()
#10 /home/nextcloud/nextcloud/core/Command/SetupChecks.php(56): OC\SetupCheck\SetupCheckManager->runAll()
#11 /home/nextcloud/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\SetupChecks->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/nextcloud/nextcloud/core/Command/Base.php(213): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(1078): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\SetupChecks), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /home/nextcloud/nextcloud/lib/private/Console/Application.php(183): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /home/nextcloud/nextcloud/console.php(87): OC\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
#18 /home/nextcloud/nextcloud/occ(33): require_once('/home/nextcloud...')
#19 {main}

Next Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'scheduled_at' in 'SELECT' in /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67
Stack trace:
#0 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1976): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#1 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1918): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#2 /home/nextcloud/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1111): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT `id`, `l...', Array, Array)
#3 /home/nextcloud/nextcloud/lib/private/DB/Connection.php(415): Doctrine\DBAL\Connection->executeQuery('SELECT `id`, `l...', Array, Array, NULL)
#4 /home/nextcloud/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\DB\Connection->executeQuery('SELECT `id`, `l...', Array, Array)
#5 /home/nextcloud/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(289): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array)
#6 /home/nextcloud/nextcloud/lib/public/AppFramework/Db/QBMapper.php(313): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#7 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder))
#8 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Manager.php(1084): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1756730740, NULL)
#9 /home/nextcloud/nextcloud/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(38): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1756730740)
#10 /home/nextcloud/nextcloud/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run()
#11 /home/nextcloud/nextcloud/core/Command/SetupChecks.php(56): OC\SetupCheck\SetupCheckManager->runAll()
#12 /home/nextcloud/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\SetupChecks->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/nextcloud/nextcloud/core/Command/Base.php(213): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(1078): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\SetupChecks), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /home/nextcloud/nextcloud/lib/private/Console/Application.php(183): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /home/nextcloud/nextcloud/console.php(87): OC\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
#19 /home/nextcloud/nextcloud/occ(33): require_once('/home/nextcloud...')
#20 {main}

Next OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'scheduled_at' in 'SELECT' in /home/nextcloud/nextcloud/lib/private/DB/Exceptions/DbalException.php:56
Stack trace:
#0 /home/nextcloud/nextcloud/lib/private/DB/ConnectionAdapter.php(53): OC\DB\Exceptions\DbalException::wrap(Object(Doctrine\DBAL\Exception\InvalidFieldNameException), '', 'SELECT `id`, `l...')
#1 /home/nextcloud/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(289): OC\DB\ConnectionAdapter->executeQuery('SELECT `id`, `l...', Array, Array)
#2 /home/nextcloud/nextcloud/lib/public/AppFramework/Db/QBMapper.php(313): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#3 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Db/TaskMapper.php(181): OCP\AppFramework\Db\QBMapper->findEntities(Object(OC\DB\QueryBuilder\QueryBuilder))
#4 /home/nextcloud/nextcloud/lib/private/TaskProcessing/Manager.php(1084): OC\TaskProcessing\Db\TaskMapper->findTasks('', NULL, NULL, NULL, NULL, 1756730740, NULL)
#5 /home/nextcloud/nextcloud/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(38): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1756730740)
#6 /home/nextcloud/nextcloud/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run()
#7 /home/nextcloud/nextcloud/core/Command/SetupChecks.php(56): OC\SetupCheck\SetupCheckManager->runAll()
#8 /home/nextcloud/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\SetupChecks->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /home/nextcloud/nextcloud/core/Command/Base.php(213): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(1078): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\SetupChecks), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/nextcloud/nextcloud/lib/private/Console/Application.php(183): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 /home/nextcloud/nextcloud/console.php(87): OC\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
#15 /home/nextcloud/nextcloud/occ(33): require_once('/home/nextcloud...')
#16 {main}

Next OCP\TaskProcessing\Exception\Exception: There was a problem finding the tasks in /home/nextcloud/nextcloud/lib/private/TaskProcessing/Manager.php:1087
Stack trace:
#0 /home/nextcloud/nextcloud/apps/settings/lib/SetupChecks/TaskProcessingPickupSpeed.php(38): OC\TaskProcessing\Manager->getTasks('', NULL, NULL, NULL, NULL, 1756730740)
#1 /home/nextcloud/nextcloud/lib/private/SetupCheck/SetupCheckManager.php(34): OCA\Settings\SetupChecks\TaskProcessingPickupSpeed->run()
#2 /home/nextcloud/nextcloud/core/Command/SetupChecks.php(56): OC\SetupCheck\SetupCheckManager->runAll()
#3 /home/nextcloud/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\SetupChecks->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#4 /home/nextcloud/nextcloud/core/Command/Base.php(213): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#5 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(1078): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#6 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\SetupChecks), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#7 /home/nextcloud/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 /home/nextcloud/nextcloud/lib/private/Console/Application.php(183): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /home/nextcloud/nextcloud/console.php(87): OC\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput))
#10 /home/nextcloud/nextcloud/occ(33): require_once('/home/nextcloud...')
#11 {main}
	ldap:

For an unknown reason the corresponding migration core/Migrations/Version30000Date20240708160048.php seems to not have been run.

Is there a way to force a specific migration to be run ?

Steps to reproduce

1. install Nextcloud Server v29.0.16
2. upgrade Nextcloud Server to v30.0.14
3. run occ setupchecks

Expected behavior

occ setupchecks should not complain about missing column scheduled_at

Nextcloud Server version

30

Operating system

Other

PHP engine version

PHP 8.3

Web server

Nginx

Database engine version

MariaDB

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

Upgraded to a MAJOR version (ex. 31 to 32)

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": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "overwriteprotocol": "https",
        "overwrite.cli.url": "https:\/\/***REMOVED SENSITIVE VALUE***",
        "htaccess.RewriteBase": "\/",
        "htaccess.IgnoreFrontController": true,
        "version": "30.0.14.1",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "tempdirectory": "\/home\/nextcloud\/tmp\/tmp",
        "installed": true,
        "maintenance": false,
        "maintenance_window_start": 1,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "mail_smtpauthtype": "LOGIN",
        "loglevel": 2,
        "theme": "",
        "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory",
        "skeletondirectory": "\/home\/nextcloud\/nextcloud\/core\/skeleton",
        "token_auth_enforced": true,
        "appstoreenabled": false,
        "forcessl": true,
        "debug": false,
        "config_is_read_only": false,
        "syslog_tag": "Claude",
        "apps_paths": [
            {
                "path": "\/home\/nextcloud\/nextcloud\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/home\/nextcloud\/nextcloud\/apps-local",
                "url": "\/apps-local",
                "writable": false
            }
        ],
        "memcache.local": "\\OC\\Memcache\\APCu",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "sharing.maxAutocompleteResults": 25,
        "sharing.minSearchStringLength": 2,
        "updater.release.channel": "stable",
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "log_rotate_size": 0,
        "versions_retention_obligation": "auto,365",
        "trashbin_retention_obligation": "auto,90",
        "default_phone_region": "FR",
        "user_oidc": {
            "auto_provision": false
        }
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - app_api: 4.0.6
  - bruteforcesettings: 3.0.0
  - circles: 30.0.0
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 7.2.6
  - contactsinteraction: 1.11.0
  - dav: 1.31.1
  - deck: 1.14.6
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_accesscontrol: 1.20.1
  - 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
  - groupfolders: 18.1.4
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - nextcloud_announcements: 2.0.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - onlyoffice: 9.10.0
  - password_policy: 2.0.0
  - photos: 3.0.2
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - recommendations: 3.0.0
  - related_resources: 1.5.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - sharelisting: 1.2.0
  - support: 2.0.0
  - survey_client: 2.0.0
  - systemtags: 1.20.0
  - text: 4.1.0
  - theming: 2.6.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - user_ldap: 1.21.0
  - user_oidc: 7.4.0
  - user_status: 1.10.0
  - user_usage_report: 1.14.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
  - dashboard: 7.10.0 (installed 7.8.0)
  - encryption: 2.18.0
  - files_external: 1.22.0
  - quota_warning: 1.21.0
  - suspicious_login: 8.0.0
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev

Nextcloud Signing status

Nextcloud Logs

Additional info

No response

[joshtrichards]

For an unknown reason the corresponding migration core/Migrations/Version30000Date20240708160048.php seems to not have been run.

Do you have your logs from the upgrade? And how did you upgrade?

Any idea if you have the overarching table (taskprocessing_tasks)?

Is there a way to force a specific migration to be run ?

You can access the db migration sub-commands in debug mode - something like:

NC_debug=true ./occ migrations

Please always have backups of the db of course

[leManu]

Do you have your logs from the upgrade? And how did you upgrade?

I upgraded from command line, replacing Nextcloud files with the new version from tarball and running occ upgrade. I updated apps the same way at the same time. There was no error messages during occ upgrade.

I have the logs during the upgrade, I do not see any error.

Here are the lines concerning migrations during upgrade, none contains reference to 30000Date20240708160048 :

{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1000Date202305221555","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1004Date202311061844","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1005Date202312271744","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1006Date202401011308","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1007Date202401111030","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 1008Date202401121205","userAgent":"--","version":"29.0.16.1","data
":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2000Date20240120094952","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2005Date20240209094951","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2200Date20240216164351","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2201Date20240221124152","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2203Date20240325124149","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2204Date20240401104001","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2204Date20240403125002","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2205Date20240411124836","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2206Date20240502145029","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2207Date20240502145029","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2700Date20240515092246","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2800Date20240710220000","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 2800Date20240711080316","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 3000Date20240715170800","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 3000Date20240807085759","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 3100Date20240822080316","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 3200Date20240905080316","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 4000Date20250109163840","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:40+00:00","remoteAddr":"","user":"--","app":"app_api","method":"","url":"--","message":"- Reading 5000Date20241120135411","userAgent":"--","version":"29.0.16.1","da
ta":{"app":"app_api"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:41+00:00","remoteAddr":"","user":"--","app":"webhook_listeners","method":"","url":"--","message":"- Reading 1000Date20240527153425","userAgent":"--","version":"29.0.16.1","data":{"app":"webhook_listeners"}}
{"reqId":"UofdDJp3klmR4jM67TGX","level":0,"time":"2025-09-02T12:17:41+00:00","remoteAddr":"","user":"--","app":"webhook_listeners","method":"","url":"--","message":"- Reading 1001Date20240716184935","userAgent":"--","version":"29.0.16.1","data":{"app":"webhook_listeners"}}

Any idea if you have the overarching table (taskprocessing_tasks)?

The table exists, but it seems there are 3 missing columns :

root@localhost [nextcloud]> describe oc_taskprocessing_tasks;
+------------------------+------------------+------+-----+---------+----------------+
| Field                  | Type             | Null | Key | Default | Extra          |
+------------------------+------------------+------+-----+---------+----------------+
| id                     | bigint(20)       | NO   | PRI | NULL    | auto_increment |
| type                   | varchar(255)     | NO   |     | NULL    |                |
| input                  | longtext         | NO   |     | NULL    |                |
| output                 | longtext         | YES  |     | NULL    |                |
| status                 | int(11)          | YES  | MUL | 0       |                |
| user_id                | varchar(64)      | YES  | MUL | NULL    |                |
| app_id                 | varchar(32)      | NO   |     |         |                |
| custom_id              | varchar(255)     | YES  |     |         |                |
| last_updated           | int(10) unsigned | YES  | MUL | 0       |                |
| completion_expected_at | datetime         | YES  |     | NULL    |                |
| progress               | double           | YES  |     | 0       |                |
| error_message          | varchar(4000)    | YES  |     | NULL    |                |
| webhook_uri            | varchar(4000)    | YES  |     | NULL    |                |
| webhook_method         | varchar(64)      | YES  |     | NULL    |                |
+------------------------+------------------+------+-----+---------+----------------+
14 rows in set (0.001 sec)

Is there a way to force a specific migration to be run ?

You can access the db migration sub-commands in debug mode - something like:

NC_debug=true ./occ migrations

Please always have backups of the db of course

Thanks, I will try it soon

[joshtrichards]

There were some migration sorting bugs that were addressed a bit back, but fixes for both were backported to 29.0.16. Though I haven't looked closely enough to see how they might behave with previously skipped / applied in the wrong order migrations.

#47515
#51866