Bug 775035 – mariadb service not runnable after upgrade 10.4 -> 10.5, but after downgrading then: everthing fine

• Status: RESOLVED INVALID
• Product: Gentoo Linux

[Description Alexander Kern 2021-03-09 13:18:28 UTC]

I upgraded from mariadb 10.4.18 to 10.5.9 and mariadb service can not be run, logfile:
tail -100 mysqld.err

2021-03-09 11:22:59 0 [ERROR] Aborting                                                                                                                                                                                                        
2021-03-09 12:25:20 0 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use
 '--log-basename=d2b' or '--log-bin=mysqld-bin' to avoid this problem.                                                                                                                                                                        
2021-03-09 12:25:20 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/                                       
2021-03-09 12:25:20 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect.                                                                                                                                      
2021-03-09 12:25:20 0 [Note] InnoDB: Uses event mutexes                                                                                                                                                                                       
2021-03-09 12:25:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11                                                                                                                                                                        
2021-03-09 12:25:20 0 [Note] InnoDB: Number of pools: 1                                                                                                                                                                                       
2021-03-09 12:25:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions                                                                                                                                                                     
2021-03-09 12:25:20 0 [Note] mysqld: O_TMPFILE is not supported on /tmp/ (disabling future attempts)                                                                                                                                          
2021-03-09 12:25:20 0 [Note] InnoDB: Using Linux native AIO                                                                                                                                                                                   
2021-03-09 12:25:20 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728                                                                                                                                 
2021-03-09 12:25:20 0 [Note] InnoDB: Completed initialization of buffer pool                                                                                                                                                                  
2021-03-09 12:25:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().                                                                              
2021-03-09 12:25:20 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.17.                                                                                                                  
2021-03-09 12:25:20 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error                                                                                                                                                  
2021-03-09 12:25:20 0 [Note] InnoDB: Starting shutdown...                                                                                                                                                                                     
2021-03-09 12:25:21 0 [ERROR] Plugin 'InnoDB' init function returned error.                                                                                                                                                                   
2021-03-09 12:25:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.                                                                                                                                                        
2021-03-09 12:25:21 0 [Note] Plugin 'FEEDBACK' is disabled.                                                                                                                                                                                   
2021-03-09 12:25:21 0 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated'                                                                                                                                                          
2021-03-09 12:25:21 0 [ERROR] Unknown/unsupported storage engine: InnoDB                                                                                                                                                                      
2021-03-09 12:25:21 0 [ERROR] Aborting



So I downgraded to the version before and everything works like a charm again.

[Comment 1 Thomas Deutschmann (RETIRED) 2021-03-10 21:06:02 UTC]

Please complete log.

[Comment 2 Thomas Deutschmann (RETIRED) 2021-03-10 21:06:46 UTC]

I meant "Please attach complete log".

[Comment 3 Alexander Kern 2021-03-11 11:04:49 UTC]

complete log is 2,7 GB.
I showed the log that appears when starting the service.
I could upload the full log to any cloud service like dropbox or else.

[Comment 4 Alexander Kern 2021-03-11 11:09:05 UTC]

no it is 34 MB ? Is this a sparse file?
When I want to upload it is 2,7 GB.
I am confused.

[Comment 5 Thomas Deutschmann (RETIRED) 2021-09-03 10:31:37 UTC]

Your error is:

> 2021-03-09 12:25:20 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.17.

So please ensure that your MariaDB 10.4 installation is properly running and stopped without an error (innodb_fast_shutdown=1 is sufficient before an upgrade). Maybe you should check databases/tables as well, given your installation is still marked as crashed, before trying to upgrade.

But this isn't a problem in dev-db/mariadb package itself. It's a problem with your local instance. Therefore closing as INVALID.