Upgrade to Nextcloud Hub 10 (31.0.6) - Incorrect row format found in your database

Nextcloud Hub 10 (31.0.6)

Hello @support_team,

Over the past weekend, I upgraded my Nextcloud on my Nethserver 8 to Hub 10 (31.0.6). I now see in my Administration Overview many errors related to: “Incorrect row format found in your database. ROW_FORMAT=Dynamic offers the best database performances for Nextcloud”.

I did a search and found the following link, but I’m unsure if this is related to my issue:

Specifically, my Nextcloud is suggesting the following:

Please update row format on the following list: oc_passwords_share, oc_mail_messages, oc_profile_config, oc_activity, oc_collres_resources, oc_calendarobjects_props, oc_migrations, oc_circle_shares, oc_dav_shares, oc_forms_v2_options, oc_flow_operations, oc_text_steps, oc_deck_labels, oc_group_user, oc_passwords_folder_rv, oc_forms_v2_forms, oc_onlyoffice_filekey, oc_file_locks, oc_flowupload_directories, oc_group_folders, oc_addressbooks, oc_circle_circles, oc_calendar_rooms_md, oc_calendar_rooms, oc_analytics_facts, oc_circle_gsevents, oc_mail_coll_addresses, oc_collres_accesscache, oc_circle_links, oc_files_avir_status, oc_authtoken, oc_talk_invitations, oc_privacy_admins, oc_passwords_password_rv, oc_storages, oc_deck_assigned_labels, oc_circle_gsshares, oc_analytics_dataset, oc_systemtag, oc_group_admin, oc_announcements, oc_calendarchanges, oc_calendar_resources, oc_deck_boards, oc_ojsxc_stanzas, oc_known_users, oc_group_folders_manage, oc_external_applicable, oc_passwords_session, oc_twofactor_backupcodes, oc_ldap_group_mapping, oc_share_external, oc_activity_mq, oc_forms_v2_questions, oc_circle_groups, oc_deck_attachment, oc_talk_internalsignaling, oc_directlink, oc_calendarsubscriptions, oc_user_status, oc_cards, oc_accounts_data, oc_mail_tags, oc_analytics_whats_new, oc_analytics_share, oc_richdocuments_assets, oc_text_documents, oc_comments_read_markers, oc_notifications_pushhash, oc_dav_cal_proxy, oc_login_flow_v2, oc_notifications_settings, oc_mail_attachments, oc_whats_new, oc_group_folders_trash, oc_talk_bridges, oc_external_mounts, oc_mail_classifiers, oc_deck_assigned_users, oc_bruteforce_attempts, oc_passwords_registration, oc_recent_contact, oc_vcategory, oc_authorized_groups, oc_passwords_challenge, oc_oauth2_clients, oc_group_folders_groups, oc_federated_reshares, oc_files_trash, oc_vcategory_to_object, oc_talk_rooms, oc_systemtag_group, oc_external_options, oc_addressbookchanges, oc_talk_commands, oc_ldap_user_mapping, oc_ratelimit_entries, oc_flow_operations_scope, oc_forms_v2_submissions, oc_collres_collections, oc_richdocuments_wopi, oc_passwords_pw_tag_rel, oc_calendar_invitations, oc_circle_gsshares_mp, oc_calendars, oc_mail_aliases, oc_deck_board_acl, oc_storages_credentials, oc_analytics_threshold, oc_forms_v2_answers, oc_text_sessions, oc_oauth2_access_tokens, oc_appconfig, oc_share, oc_user_saml_users, oc_analytics_report, oc_comments, oc_files_antivirus, oc_announcements_map, oc_passwords_keychain, oc_mail_local_messages, oc_analytics_dataload, oc_preferences, oc_user_transfer_owner, oc_calendarobjects, oc_talk_sessions, oc_schedulingobjects, oc_mail_accounts, oc_talk_attendees, oc_documentserver_changes, oc_systemtag_object_mapping, oc_circle_tokens, oc_documentserver_ipc, oc_deck_stacks, oc_passwords_tag, oc_groups, oc_trusted_servers, oc_jobs, oc_notifications, oc_circle_clouds, oc_passwords_folder, oc_group_folders_acl, oc_richdocuments_direct, oc_mail_recipients, oc_flow_checks, oc_properties, oc_onlyoffice_permissions, oc_mail_message_tags, oc_passwords_password, oc_user_saml_auth_token, oc_circle_members, oc_accounts, oc_passwords_tag_rv, oc_documentserver_locks, oc_webauthn, oc_ojsxc_presence, oc_mail_mailboxes, oc_documentserver_sess, oc_mail_trusted_senders, oc_filecache, oc_external_config, oc_direct_edit, oc_mounts, oc_cards_properties, oc_deck_cards, oc_mimetypes, oc_users, oc_calendar_resources_md, oc_mail_provisionings, oc_twofactor_providers, oc_filecache_extended, oc_calendar_reminders.

I’ve reviewed the documentation link, but I’m unsure what I need to do. And since my Nextcloud is running as a container on Nethserver I don’t want to make any mistakes.

Please advise what exactly I do to correct this problem.

Thank you.

It’s explained here:

2 Likes

Thank you for pointing out the warning message. We are planning to provide a procedure that fixes NC upgrade warnings in future releases. For now we’ll just document the commands. See issue Nextcloud upgrade warning management · Issue #7522 · NethServer/dev · GitHub

1 Like