0

I was upgrading Ubunto from 18 to 20, and lost SSH during mysql upgrade.

Mysql won't start now. It has the error:

ib_logfile0 size 44895232 is not a multiple of innodb_page_size after Ubuntu upgrade

InnoDB: Error: log file ./ib_logfile0 is of different size I tried the suggestion here to no avail.

2022-07-25T17:25:13.890483Z 1 [ERROR] [MY-012962] [InnoDB] Log file ./ib_logfile0 size 44895232 is not a multiple of innodb_page_size
2022-07-25T17:25:13.890544Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2022-07-25T17:25:14.375381Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2022-07-25T17:25:14.375568Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-07-25T17:25:14.375652Z 0 [ERROR] [MY-010119] [Server] Aborting

Almost all posts I found have the same suggestion, so I am lost.

  1. deleted the 2 log files

  2. set my innodb settings as found in another post (see below)

     innodb_fast_shutdown =0
 innodb_buffer_pool_size = 2560M
 innodb_log_file_size    = 256M
 innodb_log_buffer_size  = 8M
 innodb_flush_log_at_trx_commit  = 2
 innodb_thread_concurrency   = 16
 innodb_flush_method = O_DIRECT
Rick James
  • 2,743
TDawg
  • 99
  • 4

1 Answers1

3

innodb_page_size is by default 16K which is 16384 and your innodb_log_file_size seems to be corrupted in half way during upgrade. When you say you lost ssh, does that mean server was rebooted? you might need to take a backup of ib_logfile0 and move out of data directory and try starting mysql with innodb_page_size as default. Your data dictionary is already created with 16k page size so it wont accept new value.

Remove innodb_page_size variable from conf and let it be default. Backup ib_logfile0 and move it out of data directory. When you will start mysql it will generate a new one. Post if any more errors.

yunus shaikh
  • 31