GreatSQL社区

搜索

[已解决] 安装MGR启动GreatSQL报错[InnoDB] Unable to lock ./ibdata1 error:11

236 1 2024-2-18 15:39
环境为Centos8,按照文档做了准备配置,在启动Greatsql的步骤时,出现了意外,请教该如何处理
[root@sql03 local]# /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64/bin/mysqld --defaults-file=/etc/my.cnf &
[2] 13630
[root@sql03 local]# 2024-02-18T07:34:45.787706Z 0 [Warning] [MY-011068] [Server] 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 [Warning] [MY-010097] [Server] 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 [Warning] [MY-010097] [Server] 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 [System] [MY-010116] [Server] /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 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-18T07:34:45.834457Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:46.834616Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:47.834812Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:48.835114Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:49.835370Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:50.835620Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:51.835875Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:52.836133Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:53.836405Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:54.836627Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:55.836805Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:56.837013Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:57.837268Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:34:58.837527Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2024-02-18T07:36:25.858374Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 11 in a file operation.
2024-02-18T07:36:25.858457Z 1 [ERROR] [MY-012596] [InnoDB] Error number 11 means 'Resource temporarily unavailable'
2024-02-18T07:36:25.858498Z 1 [ERROR] [MY-012215] [InnoDB] Cannot open datafile './ibdata1'
2024-02-18T07:36:25.858526Z 1 [ERROR] [MY-012960] [InnoDB] 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 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-02-18T07:36:26.748483Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-02-18T07:36:26.748551Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-02-18T07:36:26.749282Z 0 [System] [MY-010910] [Server] /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.



全部回复(1)
yejr 2024-2-19 12:03:39
执行 ps -ef | grep -i mysqld 确认是否启动了多个进程。

这种应该是你多次启动mysqld进程,ibdata1系统表空间文件只能被一个mysqld进程加锁,其他进程再想尝试加锁就会报这个错误。
lb8125

5

主题

0

博客

13

贡献

新手上路

Rank: 1

积分
20

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-5-17 11:58 , Processed in 0.014907 second(s), 10 queries , Redis On.
快速回复 返回顶部 返回列表