mysql container fails after update

mefix

After trying to update my mailcow installation today, the mysql-mailcow container started to fail.

mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] Starting MariaDB 10.11.11-MariaDB-ubu2204 source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid iiNu7zan4/+DIPOHXa9/vn1UxFY= as process 1
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Number of transaction pools: 1
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Initializing buffer pool, total size = 24.000MiB, chunk size = 1.000MiB
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Completed initialization of buffer pool
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.11. You must start up and shut down MariaDB 10.7 or earlier.
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [Note] InnoDB: Starting shutdown...
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [ERROR] Unknown/unsupported storage engine: InnoDB
mysql-mailcow-1    | 2025-05-19 15:55:38 0 [ERROR] Aborting

mysql-mailcow-1 | 2025-05-19 15:55:38 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.11. You must start up and shut down MariaDB 10.7 or earlier.

I’m pretty sure, there was no crash.
However, I temporarily changed docker-compose.yml to use image: mariadb:10.5.11
And then started the older server with
docker compose up mysql-mailcow
and it works absolutely fine:

mysql-mailcow-1  | 2025-05-19 16:00:53+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.11+maria~focal started.
<SNIP>
mysql-mailcow-1  | 2025-05-19 16:00:53 0 [Note] mysqld: ready for connections.

But when I stop that older server, change the version back to the newer one and try to start the newer 10.11 version, it fails again.

How can I upgrade my database???

DerLinkman

Try downgrading to latest mariadb:10.5 and then running the mysql upgrade command manually by doing this inside them mailcow folder:

source mailcow.conf
docker compose exec mysql-mailcow mariadb_upgrade -u root -p${DBROOT}

If mariadb moans about: “Already updated” rerun the command with --force

Once finished, restore mariadb:10.11 inside docker-compose.yml and wait what is happening once it came back up.

mefix

mariadb latest 10.5 I found seems to be 10.5.28

docker compose exec mysql-mailcow mariadb-upgrade -u root -p${DBROOT}
This installation of MariaDB is already upgraded to 10.5.11-MariaDB.
There is no need to run mysql_upgrade again for 10.5.28-MariaDB.
You can use --force if you still want to run mysql_upgrade

docker compose exec mysql-mailcow mariadb-upgrade -u root -p${DBROOT} --force
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mailcow.grouped_domain_alias_address               OK
mailcow.grouped_mail_aliases                       OK
mailcow.grouped_sender_acl                         OK
mailcow.grouped_sender_acl_external                OK
mailcow.sieve_after                                OK
mailcow.sieve_before                               OK
mailcow.sogo_view                                  OK
mysql.user                                         OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
mailcow
mailcow._sogo_static_view                          OK
mailcow.admin                                      OK
mailcow.alias                                      OK
mailcow.alias_domain                               OK
mailcow.api                                        OK
mailcow.app_passwd                                 OK
mailcow.bcc_maps                                   OK
mailcow.da_acl                                     OK
mailcow.da_sso                                     OK
mailcow.domain                                     OK
mailcow.domain_admins                              OK
mailcow.domain_wide_footer                         OK
mailcow.fido2                                      OK
mailcow.filterconf                                 OK
mailcow.forwarding_hosts                           OK
mailcow.identity_provider                          OK
mailcow.imapsync                                   OK
mailcow.logs                                       OK
mailcow.mailbox                                    OK
mailcow.oauth_access_tokens                        OK
mailcow.oauth_authorization_codes                  OK
mailcow.oauth_clients                              OK
mailcow.oauth_refresh_tokens                       OK
mailcow.pushover                                   OK
mailcow.quarantine                                 OK
mailcow.quota2                                     OK
mailcow.quota2replica                              OK
mailcow.recipient_maps                             OK
mailcow.relayhosts                                 OK
mailcow.reset_password                             OK
mailcow.sasl_log                                   OK
mailcow.sender_acl                                 OK
mailcow.settingsmap                                OK
mailcow.sieve_filters                              OK
mailcow.sogo_acl                                   OK
mailcow.sogo_admin                                 OK
mailcow.sogo_alarms_folder                         OK
mailcow.sogo_cache_folder                          OK
mailcow.sogo_folder_info                           OK
mailcow.sogo_quick_appointment                     OK
mailcow.sogo_quick_contact                         OK
mailcow.sogo_sessions_folder                       OK
mailcow.sogo_store                                 OK
mailcow.sogo_user_profile                          OK
mailcow.spamalias                                  OK
mailcow.tags_domain                                OK
mailcow.tags_mailbox                               OK
mailcow.templates                                  OK
mailcow.tfa                                        OK
mailcow.tls_policy_override                        OK
mailcow.transports                                 OK
mailcow.user_acl                                   OK
mailcow.versions                                   OK
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

But then with 10.11 I get the same error:

mysql-mailcow-1    | 2025-05-19 17:22:24 0 [Note] Starting MariaDB 10.11.11-MariaDB-ubu2204 source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid wbPrloSeOHdXmT0RpV93nyCof2c= as process 1
mysql-mailcow-1    | 2025-05-19 17:22:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: Number of transaction pools: 1
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 1
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: Initializing buffer pool, total size = 24.000MiB, chunk size = 1.000MiB
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: Completed initialization of buffer pool
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.11. You must start up and shut down MariaDB 10.7 or earlier.
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [Note] InnoDB: Starting shutdown...
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [ERROR] Unknown/unsupported storage engine: InnoDB
mysql-mailcow-1    | 2025-05-19 17:22:25 0 [ERROR] Aborting

Oh, I missed this one:
When I startup 10.5.28, I get this in the log:

mysql-mailcow-1    | 2025-05-19 17:25:26 0 [ERROR] mysqld: Table './mysql/global_priv' is marked as crashed and should be repaired
<SNIP>
mysql-mailcow-1    | 2025-05-19 17:25:26 0 [ERROR] mysqld: Table './mysql/tables_priv' is marked as crashed and should be repaired

Can tables actually and successfully be repaired? Never done this before.

Oh, I missed this one:
When I startup 10.5.28, I get this in the log:

mysql-mailcow-1    | 2025-05-19 17:25:26 0 [ERROR] mysqld: Table './mysql/global_priv' is marked as crashed and should be repaired
<SNIP>
mysql-mailcow-1    | 2025-05-19 17:25:26 0 [ERROR] mysqld: Table './mysql/tables_priv' is marked as crashed and should be repaired

Can tables actually and successfully be repaired? Never done this before.

Now I can see mariadb doing crash recovery when it starts up:

mysql-mailcow-1  | 2025-05-19 17:34:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=9184217,9184217
<snip>
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] InnoDB: Starting final batch to recover 338 pages from redo log.
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] InnoDB: 128 rollback segments are active.
<snip>
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] mysqld: ready for connections.
mysql-mailcow-1  | Version: '10.5.28-MariaDB-ubu2004'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Now I can see mariadb doing crash recovery when it starts up:

mysql-mailcow-1  | 2025-05-19 17:34:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=9184217,9184217
<snip>
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] InnoDB: Starting final batch to recover 338 pages from redo log.
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] InnoDB: 128 rollback segments are active.
<snip>
mysql-mailcow-1  | 2025-05-19 17:34:41 0 [Note] mysqld: ready for connections.
mysql-mailcow-1  | Version: '10.5.28-MariaDB-ubu2004'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

But then, when I stop and restart mariadb 10.5.28, it’s doing crash recovery again

ETNyx

Hello,
as you have mariadb-upgrade command, there is mariadb-check that can check tables -c analyze tables -a, repair tables -r please refer to docs and consider using using verbose option -v to get more information.

mefix

using mariadb 10.5.28
check (-c)


docker compose exec mysql-mailcow mariadb-check -Ac -uroot -p${DBROOT} --force
mailcow._sogo_static_view                          OK
mailcow.admin                                      OK
mailcow.alias                                      OK
mailcow.alias_domain                               OK
mailcow.api                                        OK
mailcow.app_passwd                                 OK
mailcow.bcc_maps                                   OK
mailcow.da_acl                                     OK
mailcow.da_sso                                     OK
mailcow.domain                                     OK
mailcow.domain_admins                              OK
mailcow.domain_wide_footer                         OK
mailcow.fido2                                      OK
mailcow.filterconf                                 OK
mailcow.forwarding_hosts                           OK
mailcow.identity_provider                          OK
mailcow.imapsync                                   OK
mailcow.logs                                       OK
mailcow.mailbox                                    OK
mailcow.oauth_access_tokens                        OK
mailcow.oauth_authorization_codes                  OK
mailcow.oauth_clients                              OK
mailcow.oauth_refresh_tokens                       OK
mailcow.pushover                                   OK
mailcow.quarantine                                 OK
mailcow.quota2                                     OK
mailcow.quota2replica                              OK
mailcow.recipient_maps                             OK
mailcow.relayhosts                                 OK
mailcow.reset_password                             OK
mailcow.sasl_log                                   OK
mailcow.sender_acl                                 OK
mailcow.settingsmap                                OK
mailcow.sieve_filters                              OK
mailcow.sogo_acl                                   OK
mailcow.sogo_admin                                 OK
mailcow.sogo_alarms_folder                         OK
mailcow.sogo_cache_folder                          OK
mailcow.sogo_folder_info                           OK
mailcow.sogo_quick_appointment                     OK
mailcow.sogo_quick_contact                         OK
mailcow.sogo_sessions_folder                       OK
mailcow.sogo_store                                 OK
mailcow.sogo_user_profile                          OK
mailcow.spamalias                                  OK
mailcow.tags_domain                                OK
mailcow.tags_mailbox                               OK
mailcow.templates                                  OK
mailcow.tfa                                        OK
mailcow.tls_policy_override                        OK
mailcow.transports                                 OK
mailcow.user_acl                                   OK
mailcow.versions                                   OK
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK

analyze (-a)


docker compose exec mysql-mailcow mariadb-check -Aa -uroot -p${DBROOT} --force
mailcow._sogo_static_view                          OK
mailcow.admin                                      OK
mailcow.alias                                      OK
mailcow.alias_domain                               OK
mailcow.api                                        OK
mailcow.app_passwd                                 OK
mailcow.bcc_maps                                   OK
mailcow.da_acl                                     OK
mailcow.da_sso                                     OK
mailcow.domain                                     OK
mailcow.domain_admins                              OK
mailcow.domain_wide_footer                         OK
mailcow.fido2                                      OK
mailcow.filterconf                                 OK
mailcow.forwarding_hosts                           OK
mailcow.identity_provider                          OK
mailcow.imapsync                                   OK
mailcow.logs                                       OK
mailcow.mailbox                                    OK
mailcow.oauth_access_tokens                        OK
mailcow.oauth_authorization_codes                  OK
mailcow.oauth_clients                              OK
mailcow.oauth_refresh_tokens                       OK
mailcow.pushover                                   OK
mailcow.quarantine                                 OK
mailcow.quota2                                     OK
mailcow.quota2replica                              OK
mailcow.recipient_maps                             OK
mailcow.relayhosts                                 OK
mailcow.reset_password                             OK
mailcow.sasl_log                                   OK
mailcow.sender_acl                                 OK
mailcow.settingsmap                                OK
mailcow.sieve_filters                              OK
mailcow.sogo_acl                                   OK
mailcow.sogo_admin                                 OK
mailcow.sogo_alarms_folder                         OK
mailcow.sogo_cache_folder                          OK
mailcow.sogo_folder_info                           OK
mailcow.sogo_quick_appointment                     OK
mailcow.sogo_quick_contact                         OK
mailcow.sogo_sessions_folder                       OK
mailcow.sogo_store                                 OK
mailcow.sogo_user_profile                          OK
mailcow.spamalias                                  OK
mailcow.tags_domain                                OK
mailcow.tags_mailbox                               OK
mailcow.templates                                  OK
mailcow.tfa                                        OK
mailcow.tls_policy_override                        OK
mailcow.transports                                 OK
mailcow.user_acl                                   OK
mailcow.versions                                   OK
mysql.column_stats                                 Table is already up to date
mysql.columns_priv                                 Table is already up to date
mysql.db                                           Table is already up to date
mysql.event                                        Table is already up to date
mysql.func                                         Table is already up to date
mysql.global_priv                                  Table is already up to date
mysql.gtid_slave_pos                               OK
mysql.help_category                                Table is already up to date
mysql.help_keyword                                 Table is already up to date
mysql.help_relation                                Table is already up to date
mysql.help_topic                                   Table is already up to date
mysql.index_stats                                  Table is already up to date
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       Table is already up to date
mysql.proc                                         Table is already up to date
mysql.procs_priv                                   Table is already up to date
mysql.proxies_priv                                 Table is already up to date
mysql.roles_mapping                                Table is already up to date
mysql.servers                                      Table is already up to date
mysql.table_stats                                  Table is already up to date
mysql.tables_priv                                  Table is already up to date
mysql.time_zone                                    Table is already up to date
mysql.time_zone_leap_second                        Table is already up to date
mysql.time_zone_name                               Table is already up to date
mysql.time_zone_transition                         Table is already up to date
mysql.time_zone_transition_type                    Table is already up to date
mysql.transaction_registry                         OK

repair (-r)


docker compose exec mysql-mailcow mariadb-check -Ar -uroot -p${DBROOT} --force
mailcow._sogo_static_view
note     : The storage engine for the table doesn't support repair
mailcow.admin
note     : The storage engine for the table doesn't support repair
mailcow.alias
note     : The storage engine for the table doesn't support repair
mailcow.alias_domain
note     : The storage engine for the table doesn't support repair
mailcow.api
note     : The storage engine for the table doesn't support repair
mailcow.app_passwd
note     : The storage engine for the table doesn't support repair
mailcow.bcc_maps
note     : The storage engine for the table doesn't support repair
mailcow.da_acl
note     : The storage engine for the table doesn't support repair
mailcow.da_sso
note     : The storage engine for the table doesn't support repair
mailcow.domain
note     : The storage engine for the table doesn't support repair
mailcow.domain_admins
note     : The storage engine for the table doesn't support repair
mailcow.domain_wide_footer
note     : The storage engine for the table doesn't support repair
mailcow.fido2
note     : The storage engine for the table doesn't support repair
mailcow.filterconf
note     : The storage engine for the table doesn't support repair
mailcow.forwarding_hosts
note     : The storage engine for the table doesn't support repair
mailcow.identity_provider
note     : The storage engine for the table doesn't support repair
mailcow.imapsync
note     : The storage engine for the table doesn't support repair
mailcow.logs
note     : The storage engine for the table doesn't support repair
mailcow.mailbox
note     : The storage engine for the table doesn't support repair
mailcow.oauth_access_tokens
note     : The storage engine for the table doesn't support repair
mailcow.oauth_authorization_codes
note     : The storage engine for the table doesn't support repair
mailcow.oauth_clients
note     : The storage engine for the table doesn't support repair
mailcow.oauth_refresh_tokens
note     : The storage engine for the table doesn't support repair
mailcow.pushover
note     : The storage engine for the table doesn't support repair
mailcow.quarantine
note     : The storage engine for the table doesn't support repair
mailcow.quota2
note     : The storage engine for the table doesn't support repair
mailcow.quota2replica
note     : The storage engine for the table doesn't support repair
mailcow.recipient_maps
note     : The storage engine for the table doesn't support repair
mailcow.relayhosts
note     : The storage engine for the table doesn't support repair
mailcow.reset_password
note     : The storage engine for the table doesn't support repair
mailcow.sasl_log
note     : The storage engine for the table doesn't support repair
mailcow.sender_acl
note     : The storage engine for the table doesn't support repair
mailcow.settingsmap
note     : The storage engine for the table doesn't support repair
mailcow.sieve_filters
note     : The storage engine for the table doesn't support repair
mailcow.sogo_acl
note     : The storage engine for the table doesn't support repair
mailcow.sogo_admin
note     : The storage engine for the table doesn't support repair
mailcow.sogo_alarms_folder
note     : The storage engine for the table doesn't support repair
mailcow.sogo_cache_folder
note     : The storage engine for the table doesn't support repair
mailcow.sogo_folder_info
note     : The storage engine for the table doesn't support repair
mailcow.sogo_quick_appointment
note     : The storage engine for the table doesn't support repair
mailcow.sogo_quick_contact
note     : The storage engine for the table doesn't support repair
mailcow.sogo_sessions_folder
note     : The storage engine for the table doesn't support repair
mailcow.sogo_store
note     : The storage engine for the table doesn't support repair
mailcow.sogo_user_profile
note     : The storage engine for the table doesn't support repair
mailcow.spamalias
note     : The storage engine for the table doesn't support repair
mailcow.tags_domain
note     : The storage engine for the table doesn't support repair
mailcow.tags_mailbox
note     : The storage engine for the table doesn't support repair
mailcow.templates
note     : The storage engine for the table doesn't support repair
mailcow.tfa
note     : The storage engine for the table doesn't support repair
mailcow.tls_policy_override
note     : The storage engine for the table doesn't support repair
mailcow.transports
note     : The storage engine for the table doesn't support repair
mailcow.user_acl
note     : The storage engine for the table doesn't support repair
mailcow.versions
note     : The storage engine for the table doesn't support repair
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos
note     : The storage engine for the table doesn't support repair
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats
note     : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note     : The storage engine for the table doesn't support repair
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry
note     : The storage engine for the table doesn't support repair

What really bothers me are these weird #sql-alter-1-b.ibd entries in the log, no matter how often I massage mariadb with all the tools:


mysql-mailcow-1  | 2025-05-26 13:45:33 0 [Note] InnoDB: Ignoring data file './mailcow/#sql-alter-1-b.ibd' with space ID 650. Another data file called ./mailcow/sogo_user_profile.ibd exists with the same space ID.

I can’t even find this file inside any of the involved docker volumes in /var/lib/docker/volumes on the host system.

And the result is the same, after applying all the tools with the old version 10.5.28, shutting down mariadb using docker compose stop mysql-mailcow, changing the version in the compose file to 10.11 and starting with docker compose up mysql-mailcow -d I get

mysql-mailcow-1  | 2025-05-26 13:57:08+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.13+maria~ubu2204 started.
mysql-mailcow-1  | 2025-05-26 13:57:09+02:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
mysql-mailcow-1  | 2025-05-26 13:57:09+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-mailcow-1  | 2025-05-26 13:57:09+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.13+maria~ubu2204 started.
mysql-mailcow-1  | 2025-05-26 13:57:09+02:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] Starting MariaDB 10.11.13-MariaDB-ubu2204 source revision 8fb09426b98583916ccfd4f8c49741adc115bac3 server_uid HN1dq8bwcPcNSZHQLAxVv+C477Y= as process 1
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: Number of transaction pools: 1
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: innodb_buffer_pool_size_max=24m, innodb_buffer_pool_size=24m
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: Completed initialization of buffer pool
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.11. You must start up and shut down MariaDB 10.7 or earlier.
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [Note] InnoDB: Starting shutdown...
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
mysql-mailcow-1  | 2025-05-26 13:57:09 0 [ERROR] Aborting
mysql-mailcow-1  | 2025-05-26 13:57:10+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.13+maria~ubu2204 started.
mysql-mailcow-1  | 2025-05-26 13:57:10+02:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
mysql-mailcow-1  | 2025-05-26 13:57:10+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-mailcow-1  | 2025-05-26 13:57:10+02:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.13+maria~ubu2204 started.
mysql-mailcow-1  | 2025-05-26 13:57:10+02:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] Starting MariaDB 10.11.13-MariaDB-ubu2204 source revision 8fb09426b98583916ccfd4f8c49741adc115bac3 server_uid RHUUljtfFYACsZXkj/Nd7O9OIeU= as process 1
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: Number of transaction pools: 1
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: innodb_buffer_pool_size_max=24m, innodb_buffer_pool_size=24m
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: Completed initialization of buffer pool
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.5.11. You must start up and shut down MariaDB 10.7 or earlier.
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [Note] InnoDB: Starting shutdown...
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [ERROR] Unknown/unsupported storage engine: InnoDB
mysql-mailcow-1  | 2025-05-26 13:57:10 0 [ERROR] Aborting

mefix

Problem became deprecated, I started from scratch with a new installation.