DBngin icon indicating copy to clipboard operation
DBngin copied to clipboard

InnoDB is not using the custom configuration file at initialisation, so initialises files with 16k page size instead of 64k page size configured then won't start.

Open aaronduce opened this issue 1 year ago • 2 comments

Please fill out the detail below, it helps me investigate the bug:

  1. Driver (Ex: PostgreSQL 10.0): Mysql 8.0.27

  2. DBngin build number: 6.2 (62)

  3. macOS version: 12.4

  4. The steps to reproduce this issue: Make a new MySQL DB.

Stop the DB -> then delete all in the databases folder (the one with the ID string as the name).

Set it to use the custom configuration file similar to:

[mysqld]
innodb_page_size=64k
innodb_log_file_size=512M
innodb_buffer_pool_size=1024M
innodb_strict_mode=0

Then start. It will look started but cannot connect. Looking in mysqld.local.err shows:

2023-02-09T16:01:38.603046Z 0 [System] [MY-010116] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld (mysqld 8.0.27) starting as process 47922
2023-02-09T16:01:38.604137Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/aaronduce/Library/Application Support/com.tinyapp.DBngin/Engines/mysql/BE88461B-B4BB-49CD-88A4-01156734AEE1/ is case insensitive
2023-02-09T16:01:38.604447Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2023-02-09T16:01:38.605996Z 0 [Warning] [MY-012363] [InnoDB] innodb-page-size has been changed from the default value 16384 to 65536.
2023-02-09T16:01:38.606740Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-09T16:01:38.622951Z 1 [ERROR] [MY-012222] [InnoDB] Data file './ibdata1' uses page size 16384, but the innodb_page_size start-up parameter is 65536
2023-02-09T16:01:38.623319Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
2023-02-09T16:01:38.623353Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2023-02-09T16:01:38.623792Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-02-09T16:01:38.623849Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-02-09T16:01:38.623906Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-09T16:01:38.624097Z 0 [System] [MY-010910] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld: Shutdown complete (mysqld 8.0.27)  MySQL Community Server - GPL.

Showing the innodb files have been made with a 16k page size instead of 64k

aaronduce avatar Feb 09 '23 16:02 aaronduce