在AlmaLinux 9.1上执行从AlmaLinux 10.11升级到11.0.1之后,当我将datadir设置为旧的MariaDB 10.11数据库的位置时,MariaDB无法启动:
2023-04-13 12:37:55 0 [Note] Starting MariaDB 11.0.1-MariaDB source revision 158a58245813b1959d6ee912d77734620c7cf3ba as process 14188
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Number of transaction pools: 1
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Using Linux native AIO
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Completed initialization of buffer pool
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [Note] InnoDB: Upgrading the change buffer
Apr 13 12:37:55 mariadb2pre mariadbd[14188]:
2023-04-13 12:37:55 0 [ERROR] [FATAL] InnoDB: Unable to find charset-collation for 15
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: 230413 12:37:55 [ERROR] mysqld got signal 6 ;
Apr 13
12:37:55 mariadb2pre mariadbd[14188]: This could be because you hit a
> bug. It is also possible that this binary
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: or one of the libraries it was linked against is corrupt, improperly built,
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: or misconfigured. This error can also be caused by malfunctioning hardware.
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: We will try our best to scrape up some info that will hopefully help
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: diagnose the problem, but since we have already crashed,
Apr 13 12:37:55 mariadb2pre mariadbd[14188]: something is definitely wrong and this may fail.如果不设置数据,MariaDB 11将启动。我试图设置不同的InnoDB恢复模式,但是它没有工作。如果这是问题所在,我如何找到并修复错误的字符集-校对?
发布于 2023-04-13 20:34:06
在MariaDB和MySQL中,对于GA前的发布要小心。它们不是给胆小的人准备的。10.11.1就是这种情况。建议10.11.2或10.10.3或最新的10.6.xx,这将是"LTS“,意味着它将被支持6年(直到2026年)。
同时,您可以通过提交有关排序规则问题的错误报告来帮助他们。当然,如果它也发生在GA版本中。
https://en.wikipedia.org/wiki/MariaDB
https://endoflife.date/mariadb
https://dba.stackexchange.com/questions/325968
复制相似问题