单机安装报错
目的：想要测试ap引擎性能过程：
按照手册完成配置
https://greatsql.cn/docs/8032-25/user-manual/4-install-guide/3-1-centos-install.html
报错：
0. error.log// 创建mysql.sock.lock文件失败
2024-02-25T10:07:25.959751+08:00 0 Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2024-02-25T10:07:25.959902+08:00 0 Server hostname (bind-address): '*'; port: 3306
2024-02-25T10:07:25.960073+08:00 0 IPv6 is available.
2024-02-25T10:07:25.960083+08:00 0 - '::' resolves to '::';
2024-02-25T10:07:25.960098+08:00 0 Server socket created on IP: '::'.
2024-02-25T10:07:25.960353+08:00 0 Could not create unix socket lock file /home/data_redo/yxz/data/GretSQL/mysql.sock.lock.
2024-02-25T10:07:25.960365+08:00 0 Unable to setup unix socket lock file.
2024-02-25T10:07:25.960389+08:00 0 Aborting
2024-02-25T10:07:25.961541+08:00 0 FTS optimize thread exiting.
2024-02-25T10:07:26.906032+08:00 0 Binlog end
2024-02-25T10:07:26.907026+08:00 0 Shutting down plugin 'mysqlx'
2024-02-25T10:07:26.907812+08:00 0 Shutting down plugin 'mysqlx_cache_cleaner'
2024-02-25T10:07:26.907832+08:00 0 Shutting down plugin 'ngram'
2024-02-25T10:07:26.907841+08:00 0 Shutting down plugin 'BLACKHOLE'
2024-02-25T10:07:26.907852+08:00 0 Shutting down plugin 'ARCHIVE'
2024-02-25T10:07:26.907859+08:00 0 Shutting down plugin 'TempTable'
2024-02-25T10:07:26.907866+08:00 0 Shutting down plugin 'MRG_MYISAM'
2024-02-25T10:07:26.907875+08:00 0 Shutting down plugin 'MyISAM'
2024-02-25T10:07:26.907892+08:00 0 Shutting down plugin 'INNODB_ASYNC_PURGE_FILES'
2024-02-25T10:07:26.907902+08:00 0 Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2024-02-25T10:07:26.907909+08:00 0 Shutting down plugin 'INNODB_CACHED_INDEXES'
2024-02-25T10:07:26.907925+08:00 0 Shutting down plugin 'INNODB_VIRTUAL'
2024-02-25T10:07:26.907931+08:00 0 Shutting down plugin 'INNODB_COLUMNS'
2024-02-25T10:07:26.907937+08:00 0 Shutting down plugin 'INNODB_TABLESPACES'
2024-02-25T10:07:26.907944+08:00 0 Shutting down plugin 'INNODB_INDEXES'
2024-02-25T10:07:26.907950+08:00 0 Shutting down plugin 'INNODB_TABLESTATS'
2024-02-25T10:07:26.907957+08:00 0 Shutting down plugin 'INNODB_TABLES'
2024-02-25T10:07:26.907963+08:00 0 Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2024-02-25T10:07:26.907968+08:00 0 Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2024-02-25T10:07:26.907975+08:00 0 Shutting down plugin 'INNODB_FT_CONFIG'
2024-02-25T10:07:26.907981+08:00 0 Shutting down plugin 'INNODB_FT_BEING_DELETED'
2024-02-25T10:07:26.907987+08:00 0 Shutting down plugin 'INNODB_FT_DELETED'
2024-02-25T10:07:26.907993+08:00 0 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2024-02-25T10:07:26.907999+08:00 0 Shutting down plugin 'INNODB_METRICS'
2024-02-25T10:07:26.908005+08:00 0 Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2024-02-25T10:07:26.908011+08:00 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2024-02-25T10:07:26.908017+08:00 0 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2024-02-25T10:07:26.908023+08:00 0 Shutting down plugin 'INNODB_BUFFER_PAGE'
2024-02-25T10:07:26.908029+08:00 0 Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2024-02-25T10:07:26.908036+08:00 0 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2024-02-25T10:07:26.908045+08:00 0 Shutting down plugin 'INNODB_CMPMEM_RESET'
2024-02-25T10:07:26.908052+08:00 0 Shutting down plugin 'INNODB_CMPMEM'
2024-02-25T10:07:26.908058+08:00 0 Shutting down plugin 'INNODB_CMP_RESET'
2024-02-25T10:07:26.908064+08:00 0 Shutting down plugin 'INNODB_CMP'
2024-02-25T10:07:26.908071+08:00 0 Shutting down plugin 'INNODB_TRX'
2024-02-25T10:07:26.908077+08:00 0 Shutting down plugin 'InnoDB'
2024-02-25T10:07:26.908112+08:00 0 Starting shutdown...
2024-02-25T10:07:26.908511+08:00 0 Dumping buffer pool(s) to /home/data_redo/yxz/data/GreatSQL/ib_buffer_pool
2024-02-25T10:07:26.909115+08:00 0 Buffer pool(s) dump completed at 240225 10:07:26
2024-02-25T10:07:26.927863+08:00 0 Log background threads are being closed...
2024-02-25T10:07:27.842358+08:00 0 Bytes written to disk by DBLWR (ON): 1458176
2024-02-25T10:07:27.847345+08:00 0 Shutdown completed; log sequence number 20079802
2024-02-25T10:07:27.847554+08:00 0 Removed temporary tablespace data file: "ibtmp1"
2024-02-25T10:07:27.847597+08:00 0 Shutting down plugin 'MEMORY'
1. systemctl start greatsql
Job for greatsql.service failed because the control process exited with error code.
See "systemctl status greatsql.service" and "journalctl -xe" for details.
1.1systemctl status greatsql.service -l
● greatsql.service - GreatSQL Server
Loaded: loaded (/usr/lib/systemd/system/greatsql.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since 日 2024-02-25 10:07:28 CST; 4s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 110171 ExecStart=/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 108433 ExecStartPre=/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.17-x86_64/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 110171 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
Error: 2 (没有那个文件或目录)
1.2 2月 25 10:07:14 localhost.localdomain systemd: Starting GreatSQL Server...
-- Subject: Unit greatsql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit greatsql.service has begun starting up.
2月 25 10:07:28 localhost.localdomain systemd: greatsql.service: main process exited, code=exited, status=1/FAILURE
2月 25 10:07:28 localhost.localdomain systemd: Failed to start GreatSQL Server.
-- Subject: Unit greatsql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit greatsql.service has failed.
--
-- The result is failed.
2月 25 10:07:28 localhost.localdomain systemd: Unit greatsql.service entered failed state.
2月 25 10:07:28 localhost.localdomain systemd: greatsql.service failed.
2月 25 10:07:28 localhost.localdomain polkitd: Unregistered Authentication Agent for unix-process:108419:354571655 (system bus name :1.52037, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale zh_CN.UTF-8) (disconnected from bus)
配置my.cnf 当中socket路径敲错，已解决。
页:
[1]