Since 34.0.2 i have a problem that the update process gets stuck and i have to use "occ maintenance:mode --off" and "occ upgrade" to get the job finished. (compare Problem nach Update )
After Upgrade 34.0.4 -> 35.0.0 "occ upgrade" reports:
unexpected table 'oc_mail_tags'
unexpected table 'oc_ex_translation_q'
unexpected table 'oc_maps_device_points'
unexpected table 'oc_ex_speech_to_text'
unexpected table 'oc_mail_accounts'
unexpected table 'oc_mail_blocks_shares'
unexpected table 'oc_mail_recipients'
unexpected table 'oc_mail_internal_address'
unexpected table 'oc_mail_actions'
unexpected table 'oc_onlyoffice_filekey'
unexpected table 'oc_maps_tracks'
unexpected table 'oc_bookmarks_shared_folders'
unexpected table 'oc_mail_action_step'
unexpected table 'oc_onlyoffice_instance'
unexpected table 'oc_bookmarks_shares'
unexpected table 'oc_mail_messages_retention'
unexpected table 'oc_gpxpod_tracks'
unexpected table 'oc_mail_text_blocks'
unexpected table 'oc_mail_provisionings'
unexpected table 'oc_mail_aliases'
unexpected table 'oc_mail_coll_addresses'
unexpected table 'oc_maps_favorite_shares'
unexpected table 'oc_mail_smime_certificates'
unexpected table 'oc_maps_devices'
unexpected table 'oc_mail_cc_tasks'
unexpected table 'oc_login_ips_aggregated'
unexpected table 'oc_mail_attachments'
unexpected table 'oc_bookmarks_folders_public'
unexpected table 'oc_mail_mailboxes'
unexpected table 'oc_file_metadata'
unexpected table 'oc_gpxpod_pictures'
unexpected table 'oc_ex_translation'
unexpected table 'oc_maps_apikeys'
unexpected table 'oc_bookmarks'
unexpected table 'oc_onlyoffice_permissions'
unexpected table 'oc_bookmarks_tags'
unexpected table 'oc_gpxpod_directories'
unexpected table 'oc_ex_text_processing'
unexpected table 'oc_maps_address_geo'
unexpected table 'oc_mail_messages'
unexpected table 'oc_preferences_ex'
unexpected table 'oc_mail_messages_snoozed'
unexpected table 'oc_gpxpod_tileservers'
unexpected table 'oc_bookmarks_tree'
unexpected table 'oc_weather_config'
unexpected table 'oc_maps_photos'
unexpected table 'oc_maps_favorites'
unexpected table 'oc_bookmarks_shared_to_shares'
unexpected table 'oc_bookmarks_root_folders'
unexpected table 'oc_mail_message_tags'
unexpected table 'oc_weather_city'
unexpected table 'oc_mail_trusted_senders'
unexpected table 'oc_preview_generation'
unexpected table 'oc_bookmarks_folders'
unexpected table 'oc_mail_local_messages'
unexpected table 'oc_ex_text_processing_q'
unexpected table 'oc_appconfig_ex'
unexpected table 'oc_gpxpod_tile_servers'
unexpected table 'oc_ex_event_handlers'
unexpected table 'oc_ex_speech_to_text_q'
oc_groups: column 'displayname' differs in: default
oc_authtoken: column 'name' differs in: default
oc_accounts: column 'data' differs in: default
oc_activity: missing index 'activity_object'
oc_federated_reshares: column 'remote_id' differs in: comment
oc_trusted_servers: column 'url' differs in: comment
oc_trusted_servers: column 'url_hash' differs in: comment
oc_trusted_servers: column 'token' differs in: comment
oc_trusted_servers: column 'shared_secret' differs in: comment
oc_trusted_servers: column 'status' differs in: comment
oc_trusted_servers: column 'sync_token' differs in: comment
oc_share_external: column 'id' differs in: autoincrement
oc_share_external: column 'remote' differs in: comment
oc_share_external: column 'password' differs in: comment
oc_share_external: column 'name' differs in: comment
oc_share_external: column 'owner' differs in: comment
oc_share_external: column 'user' differs in: comment
oc_share_external: column 'mountpoint' differs in: comment
oc_share_external: column 'mountpoint_hash' differs in: comment
oc_text_sessions: column 'last_awareness_message' differs in: default
oc_flow_checks: column 'class' differs in: default
oc_flow_checks: column 'operator' differs in: default
oc_flow_checks: column 'hash' differs in: default
oc_flow_operations: column 'class' differs in: default
oc_flow_operations: column 'name' differs in: default
oc_flow_operations: column 'entity' differs in: default
oc_flow_operations: column 'events' differs in: default
oc_suspicious_login_model: unexpected column 'address_type'
oc_suspicious_login: unexpected column 'notification_state'
Disabled apps (not affecting exit code):
If the schema for a disabled app differs from what is expected, this might indicate the app was updated since it was disabled. Missing migrations will be applied once the app is enabled again.
app_api:
- missing table 'oc_ex_apps_talk_bots'
- oc_ex_ui_files_actions: missing column 'default_action'
circles:
- missing table 'oc_circles_invitations'
- oc_circles_mount: missing column 'remote'
- oc_circles_mount: missing column 'remote_id'
- oc_circles_mount: missing index 'm_sid_rmt_rid'
- oc_circles_mountpoint: missing index 'mp_sid_hash'
twofactor_totp:
- oc_twofactor_totp_secrets: missing column 'algorithm'
Starting ...
0/0 [>---------------------------] 0% Starting ...
Clean up old calendar subscriptions from deleted users that were not cleaned-up
0/1 [>---------------------------] 0%
Starting ...
Updated <dav> to 2.0.0-dev.1
Updating <files> ...
Updated <files> to 3.0.0-dev.0
Updating <files_lock> ...
Updated <files_lock> to 35.0.0
Updating <files_sharing> ...
Updated <files_sharing> to 2.0.0-dev.1
Updating <files_trashbin> ...
Updated <files_trashbin> to 2.0.0-dev.0
Updating <files_versions> ...
Updated <files_versions> to 2.0.0-dev.0
Updating <sharebymail> ...
Updated <sharebymail> to 2.0.0-dev.0
Updating <webhook_listeners> ...
Updated <webhook_listeners> to 2.0.0-dev.0
Updating <workflowengine> ...
Updated <workflowengine> to 3.0.0-dev.0
Updating <admin_audit> ...
Updated <admin_audit> to 2.0.0-dev.0
Updating <comments> ...
Updated <comments> to 2.0.0-dev.0
Updating <logreader> ...
Updated <logreader> to 8.0.0
Updating <nextcloud_announcements> ...
Updated <nextcloud_announcements> to 7.0.0
Updating <notifications> ...
Updated <notifications> to 8.0.0
Updating <systemtags> ...
Updated <systemtags> to 2.0.0-dev.0
Updating <theming> ...
Updated <theming> to 3.0.0-dev.0
Updating <appstore> ...
Updated <appstore> to 2.0.0-dev.0
Updating <bruteforcesettings> ...
Updated <bruteforcesettings> to 8.0.0
Updating <contactsinteraction> ...
Updated <contactsinteraction> to 2.0.0-dev.0
Updating <dashboard> ...
Updated <dashboard> to 8.0.0-dev.0
Updating <federatedfilesharing> ...
Updated <federatedfilesharing> to 2.0.0-dev.1
Updating <files_downloadlimit> ...
Updated <files_downloadlimit> to 5.3.0
Updating <files_pdfviewer> ...
Updated <files_pdfviewer> to 8.0.0
Updating <files_reminders> ...
Updated <files_reminders> to 2.0.0-dev.0
Updating <firstrunwizard> ...
Updated <firstrunwizard> to 8.0.0
Updating <office> ...
Updated <office> to 1.1.0
Updating <privacy> ...
Updated <privacy> to 7.0.0
Updating <profile> ...
Updated <profile> to 2.0.0-dev.0
Updating <provisioning_api> ...
Updated <provisioning_api> to 2.0.0-dev.0
Updating <recommendations> ...
Updated <recommendations> to 8.0.0
Updating <related_resources> ...
Updated <related_resources> to 6.0.0
Updating <serverinfo> ...
Updated <serverinfo> to 7.0.0
Updating <settings> ...
Updated <settings> to 2.0.0-dev.0
Updating <support> ...
Updated <support> to 7.0.0
Updating <survey_client> ...
Updated <survey_client> to 7.0.0
Updating <text> ...
Updated <text> to 9.0.0
Updating <twofactor_backupcodes> ...
Updated <twofactor_backupcodes> to 2.0.0-dev.0
Updating <twofactor_nextcloud_notification> ...
Updated <twofactor_nextcloud_notification> to 9.0.0
Updating <updatenotification> ...
Updated <updatenotification> to 2.0.0-dev.0
Updating <user_status> ...
Updated <user_status> to 2.0.0-dev.0
Updating <viewer> ...
Updated <viewer> to 8.0.0
Updating <weather_status> ...
Updated <weather_status> to 2.0.0-dev.0
Update app contacts from App Store
Update app notes from App Store
Starting code integrity check...
1/1 [============================] 100%�&=> Configuring PHP session handler...
==> Using Redis as PHP session handler...
Warning: /var/www/html/config/s3.config.php differs from the latest version of this image at /usr/src/nextcloud/config/s3.config.php
=> Searching for hook scripts (*.sh) to run, located in the folder "/docker-entrypoint-hooks.d/before-starting"
==> Skipped: the "before-starting" folder is empty (or does not exist)
The Nextcloud GUI is usable und looks well sofar.
Upgraded to a MAJOR version (ex. 31 to 32)
# php occ config:list system
{
"system": {
"memcache.local": "\\OC\\Memcache\\APCu",
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"filelocking.enabled": true,
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 6379,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"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": [
"***",
"***"
],
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"forwarded_for_headers": [
"HTTP_X_FORWARDED",
"HTTP_FORWARDED_FOR"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "35.0.0.10",
"overwrite.cli.url": "https:\/\/sbwt.ddns.net",
"overwriteprotocol": "https",
"app_api": {
"harp_proxy_host": "http:\/\/appapi-harp:8780",
"harp_proxy_path": "\/exapps"
},
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"default_phone_region": "DE",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_smtpsecure": "ssl",
"loglevel": 0,
"maintenance": false,
"maintenance_window_start": 1,
"versions_retention_obligation": "auto",
"htaccess.RewriteBase": "\/",
"upgrade.disable-web": true,
"enable_previews": true,
"serverid": 1
}
}
# php occ config:list system
{
"system": {
"memcache.local": "\\OC\\Memcache\\APCu",
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"filelocking.enabled": true,
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 6379,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"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": [
"***",
"***"
],
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"forwarded_for_headers": [
"HTTP_X_FORWARDED",
"HTTP_FORWARDED_FOR"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "35.0.0.10",
"overwrite.cli.url": "https:\/\/sbwt.ddns.net",
"overwriteprotocol": "https",
"app_api": {
"harp_proxy_host": "http:\/\/appapi-harp:8780",
"harp_proxy_path": "\/exapps"
},
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"default_phone_region": "DE",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_smtpsecure": "ssl",
"loglevel": 0,
"maintenance": false,
"maintenance_window_start": 1,
"versions_retention_obligation": "auto",
"htaccess.RewriteBase": "\/",
"upgrade.disable-web": true,
"enable_previews": true,
"serverid": 1
}
}
# ./occ config:list system
{
"system": {
"memcache.local": "\\OC\\Memcache\\APCu",
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"filelocking.enabled": true,
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 6379,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"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": [
"***",
"***"
],
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"forwarded_for_headers": [
"HTTP_X_FORWARDED",
"HTTP_FORWARDED_FOR"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "35.0.0.10",
"overwrite.cli.url": "https:\/\/***",
"overwriteprotocol": "https",
"app_api": {
"harp_proxy_host": "http:\/\/appapi-harp:8780",
"harp_proxy_path": "\/exapps"
},
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"default_phone_region": "DE",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_smtpsecure": "ssl",
"loglevel": 0,
"maintenance": false,
"maintenance_window_start": 1,
"versions_retention_obligation": "auto",
"htaccess.RewriteBase": "\/",
"upgrade.disable-web": true,
"enable_previews": true,
"serverid": 1
}
}
Bug description
Since 34.0.2 i have a problem that the update process gets stuck and i have to use "occ maintenance:mode --off" and "occ upgrade" to get the job finished. (compare Problem nach Update )
After Upgrade 34.0.4 -> 35.0.0 "occ upgrade" reports:
These are the messages written during upgrade:
The Nextcloud GUI is usable und looks well sofar.
But I'm wondering is my installation broken now?
Is there a way to fix it?
Steps to reproduce
Expected behavior
"occ db:schema:check -v" should report no issues
Nextcloud Server version
35
Operating system
Other
PHP engine version
PHP 8.5
Web server
Apache (supported)
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?
None
What user-backends are you using?
Configuration report
List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
No response