安装MGR启动GreatSQL报错[InnoDB] Unable to lock ./ibdata1 error：11
环境为Centos8，按照文档做了准备配置，在启动Greatsql的步骤时，出现了意外，请教该如何处理# /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64/bin/mysqld --defaults-file=/etc/my.cnf &
13630
# 2024-02-18T07:34:45.787706Z 0 The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2024-02-18T07:34:45.787792Z 0 Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-02-18T07:34:45.787798Z 0 Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2024-02-18T07:34:45.787912Z 0 /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64/bin/mysqld (mysqld 8.0.32-25) starting as process 13630
2024-02-18T07:34:45.803193Z 1 InnoDB initialization has started.
2024-02-18T07:34:45.834457Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:46.834616Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:47.834812Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:48.835114Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:49.835370Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:50.835620Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:51.835875Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:52.836133Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:53.836405Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:54.836627Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:55.836805Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:56.837013Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:57.837268Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:58.837527Z 1 Unable to lock ./ibdata1 error: 11
2024-02-18T07:36:25.858374Z 1 Operating system error number 11 in a file operation.
2024-02-18T07:36:25.858457Z 1 Error number 11 means 'Resource temporarily unavailable'
2024-02-18T07:36:25.858498Z 1 Cannot open datafile './ibdata1'
2024-02-18T07:36:25.858526Z 1 Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
2024-02-18T07:36:26.748165Z 1 Failed to initialize DD Storage Engine
2024-02-18T07:36:26.748483Z 0 Data Dictionary initialization failed.
2024-02-18T07:36:26.748551Z 0 Aborting
2024-02-18T07:36:26.749282Z 0 /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.32-25)GreatSQL, Release 25, Revision 79f57097e3f.
执行 ps -ef | grep -i mysqld 确认是否启动了多个进程。
这种应该是你多次启动mysqld进程，ibdata1系统表空间文件只能被一个mysqld进程加锁，其他进程再想尝试加锁就会报这个错误。
页:
[1]