GreatSQL社区

搜索

[已解决] GreatSQL安装后启动时报错

703 10 2025-6-24 20:24
按照文档中安装指南-二进制包安装-ubuntu环境安装greatSQL8.0.32-27,systemctl启动时报如下错误:


× greatsql.service - GreatSQL Server
     Loaded: loaded (/etc/systemd/system/greatsql.service; disabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Wed 2025-06-18 19:34:31 CST; 1min 46s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 2609 ExecStartPre=/usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Process: 2636 ExecStart=/usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
   Main PID: 2636 (code=exited, status=1/FAILURE)
     Status: "Server shutdown complete"
      Error: 13 (Permission denied)
        CPU: 241ms

6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.737950Z 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.
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.737953Z 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.
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.737994Z 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld (mysqld 8.0.32-27) starting as process 2636
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.740091Z 0 [Warning] [MY-010091] [Server] Can't create test file /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/data/mysqld_tmp_file_case_insensitive_test.lower-test
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.740523Z 0 [ERROR] [MY-010119] [Server] Aborting
6月 18 19:34:31 yui-virtual-machine mysqld[2636]: 2025-06-18T11:34:31.740606Z 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.0.32-27-Linux-glibc2.28-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.32-27)  GreatSQL, Release 27, Revision aa66a385910.
6月 18 19:34:31 yui-virtual-machine systemd[1]: greatsql.service: Main process exited, code=exited, status=1/FAILURE
6月 18 19:34:31 yui-virtual-machine systemd[1]: greatsql.service: Failed with result 'exit-code'.
6月 18 19:34:31 yui-virtual-machine systemd[1]: Failed to start GreatSQL Server.



应该如何解决?


全部回复(10)
yejr 2025-6-25 11:04:44
看起来是datadir目录的权限没设置正确,详见日志内容

  1. 6月 18 19:34:31 yui-virtual-machine mysqld[2636]: mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
复制代码


还请严格按照我们手册内容操作,参考 https://greatsql.cn/docs/8.0.32- ... ubuntu-install.html
sdcx 2025-6-25 19:16:55
yejr 发表于 2025-6-25 11:04
看起来是datadir目录的权限没设置正确,详见日志内容

按照手册使用root执行了下列相应的指令,不解决此问题

mkdir -p /data/GreatSQL
chown -R mysql:mysql /data/GreatSQL
chmod -R 700 /data/GreatSQL

yejr 2025-6-26 08:10:33
sdcx 发表于 2025-6-25 19:16
按照手册使用root执行了下列相应的指令,不解决此问题

mkdir -p /data/GreatSQL

不解决此问题?
sdcx 2025-6-26 22:32:00
yejr 发表于 2025-6-26 08:10
不解决此问题?

是的,解决不了
reddey 2025-6-27 09:00:29
从报错看,和你的目录权限及属主设置有关。你的GLIBC版本是匹配的吧
yejr 2025-6-27 09:21:01
sdcx 发表于 2025-6-26 22:32
是的,解决不了

那就继续贴相应的错误日志和操作过程
sdcx 2025-6-27 20:05:47
reddey 发表于 2025-6-27 09:00
从报错看,和你的目录权限及属主设置有关。你的GLIBC版本是匹配的吧

glibc 2.35,和文档是一样的
sdcx 2025-6-27 23:35:46
yejr 发表于 2025-6-27 09:21
那就继续贴相应的错误日志和操作过程

破案了,my.cnf有点问题,修正之后就正常了
reddey 2025-6-28 08:39:32
sdcx 发表于 2025-6-27 23:35
破案了,my.cnf有点问题,修正之后就正常了

厉害,加油。
12下一页
sdcx

1

主题

0

博客

6

贡献

新手上路

Rank: 1

积分
11

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2025-7-19 12:42 , Processed in 0.023548 second(s), 22 queries , Redis On.
快速回复 返回顶部 返回列表