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. #98
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
Please fill out the detail below, it helps me investigate the bug:
Driver (Ex: PostgreSQL 10.0): Mysql 8.0.27
DBngin build number: 6.2 (62)
macOS version: 12.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:
Then start. It will look started but cannot connect. Looking in mysqld.local.err shows:
Showing the innodb files have been made with a 16k page size instead of 64k