Bug #99892 initialize with innodb_page_size=4096 gets "Specified key was too long" errors
| Submitted: | 15 Jun 2020 15:32 | Modified: | 21 Jan 2021 20:32 |
|---|---|---|---|
| Reporter: | Mark Callaghan | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Data Dictionary | Severity: | S3 (Non-critical) |
| Version: | 8.0.18, 8.0.20 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[15 Jun 2020 15:32]
Mark Callaghan
[16 Jun 2020 9:33]
MySQL Verification Team
Hello Mark, Thank you for the report and feedback! Thanks, Umesh
[16 Jun 2020 9:35]
MySQL Verification Team
- 8.0.20 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/99892 --log-error-verbosity=3 --innodb_page_size=4096 2020-06-16T05:26:15.973733Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. . 2020-06-16T05:26:16.359018Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-06-16T05:26:16.361857Z 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80017'. mysqld: Specified key was too long; max key length is 768 bytes mysqld: Specified key was too long; max key length is 768 bytes mysqld: Specified key was too long; max key length is 768 bytes mysqld: Specified key was too long; max key length is 768 bytes mysqld: Specified key was too long; max key length is 768 bytes mysqld: Specified key was too long; max key length is 768 bytes 2020-06-16T05:26:16.635195Z 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80017
[21 Jan 2021 20:32]
Daniel Price
Posted by developer: Fixed as of the upcoming 8.0.24 release, and here's the proposed changelog entry from the documentation team: Initializing the server with an with a 4K InnoDB page size caused key too long errors to be written to the error log. Thank you for the bug report.
[22 Jan 2021 13:07]
MySQL Verification Team
Thank you, Daniel .....
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.