|
本帖最后由 cse_engineer 于 2024-2-25 10:50 编辑 目的：想要测试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 [Note] [MY-010308] [Server] 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 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306 2024-02-25T10:07:25.960073+08:00 0 [Note] [MY-010253] [Server] IPv6 is available. 2024-02-25T10:07:25.960083+08:00 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2024-02-25T10:07:25.960098+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2024-02-25T10:07:25.960353+08:00 0 [ERROR] [MY-010273] [Server] 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 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file. 2024-02-25T10:07:25.960389+08:00 0 [ERROR] [MY-010119] [Server] Aborting 2024-02-25T10:07:25.961541+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2024-02-25T10:07:26.906032+08:00 0 [Note] [MY-010120] [Server] Binlog end 2024-02-25T10:07:26.907026+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx' 2024-02-25T10:07:26.907812+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2024-02-25T10:07:26.907832+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2024-02-25T10:07:26.907841+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2024-02-25T10:07:26.907852+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2024-02-25T10:07:26.907859+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2024-02-25T10:07:26.907866+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2024-02-25T10:07:26.907875+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2024-02-25T10:07:26.907892+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_ASYNC_PURGE_FILES' 2024-02-25T10:07:26.907902+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2024-02-25T10:07:26.907909+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2024-02-25T10:07:26.907925+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2024-02-25T10:07:26.907931+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2024-02-25T10:07:26.907937+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2024-02-25T10:07:26.907944+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2024-02-25T10:07:26.907950+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2024-02-25T10:07:26.907957+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2024-02-25T10:07:26.907963+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-02-25T10:07:26.907968+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-02-25T10:07:26.907975+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2024-02-25T10:07:26.907981+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-02-25T10:07:26.907987+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2024-02-25T10:07:26.907993+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-02-25T10:07:26.907999+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2024-02-25T10:07:26.908005+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-02-25T10:07:26.908011+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-02-25T10:07:26.908017+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-02-25T10:07:26.908023+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-02-25T10:07:26.908029+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-02-25T10:07:26.908036+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-02-25T10:07:26.908045+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-02-25T10:07:26.908052+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2024-02-25T10:07:26.908058+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2024-02-25T10:07:26.908064+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2024-02-25T10:07:26.908071+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2024-02-25T10:07:26.908077+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2024-02-25T10:07:26.908112+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2024-02-25T10:07:26.908511+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /home/data_redo/yxz/data/GreatSQL/ib_buffer_pool 2024-02-25T10:07:26.909115+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 240225 10:07:26 2024-02-25T10:07:26.927863+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2024-02-25T10:07:27.842358+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 1458176 2024-02-25T10:07:27.847345+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20079802 2024-02-25T10:07:27.847554+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2024-02-25T10:07:27.847597+08:00 0 [Note] [MY-010733] [Server] 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.1 systemctl 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[1]: 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[1]: greatsql.service: main process exited, code=exited, status=1/FAILURE 2月 25 10:07:28 localhost.localdomain systemd[1]: 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[1]: Unit greatsql.service entered failed state. 2月 25 10:07:28 localhost.localdomain systemd[1]: greatsql.service failed. 2月 25 10:07:28 localhost.localdomain polkitd[2593]: 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) |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
