添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

mysql启动时Error: 22 (Invalid argument)

447浏览 · 2024-06-15 18:05:30
[mysql](https://wenku.csdn.net/doc/6401abb7cce7214c316e93d1?spm=1055.2569.3001.10083)启动时出现[error](https://wenku.csdn.net/doc/6401acf5cce7214c316edc34?spm=1055.2569.3001.10083): 22 ([in[valid](https://wenku.csdn.net/doc/6401abeecce7214c316ea05f?spm=1055.2569.3001.10083)](https://wenku.csdn.net/doc/6412b725be7fbd1778d4940c?spm=1055.2569.3001.10083) [argument](https://wenku.csdn.net/doc/6401ac33cce7214c316eafc4?spm=1055.2569.3001.10083))错误通是由于配置文件中的某些参数设置不正确或者文件权限问题引起的。以下是一些可能的原因和解决方法: 1. 配置文件错误:检查MySQL的配置文件(通常是my.cnf或my.ini)中是否存在错误的参数设置或语法错误。确保所有参数的值正确,并且没有多余的空格或注释。 2. 文件权限问题:检查MySQL数据目录和日志文件的权限是否正确设置。确保MySQL用户对这些文件具有读写权限。可以使用以下命令来更改文件权限: chmod -R 755 /var/lib/mysql chown -R mysql:mysql /var/lib/mysql 3. 磁盘空间不足:检查磁盘空间是否足够,如果磁盘空间不足,可能会导致MySQL无法启动。可以使用以下命令来检查磁盘空间: df -h 4. 端口冲突:检查是否有其他应用程序正在使用MySQL默认的端口(通常是3306)。如果有冲突,可以尝试更改MySQL的端口号。可以在配置文件中找到"port"参数进行修改。 5. 日志文件错误:检查MySQL的错误日志文件,通常位于MySQL数据目录下的"error.log"文件。查看日志文件中的详细错误信息,以便更好地定位问题。
相关问题
这个错误是由于在main.c文件的第一行中使用了无效的参数“-std=gnu 03”造成的。这个错误是由于您在使用C语言编译器时,使用了不允许在C语言中使用的参数造成的。在C语言中,不允许使用“-std=gnu 03”这个参数

2023-06-08T02:25:37.583259Z 1 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> c443b2d8-05a0-11ee-86b8-2e0fddf21737:0 2023-06-08T02:25:39.261528Z WSREP_SST: [INFO] Streaming with xbstream 2023-06-08T02:25:39.273174Z WSREP_SST: [INFO] WARNING: Stale temporary SST directory: /data/mysql//.sst from previous state transfer. Removing 2023-06-08T02:25:39.279749Z WSREP_SST: [INFO] Proceeding with SST......... 2023-06-08T02:25:39.519583Z 0 [Note] WSREP: (c05c7a4e, 'tcp://0.0.0.0:4567') turning message relay requesting off 2023-06-08T02:25:39.553817Z WSREP_SST: [INFO] ............Waiting for SST streaming to complete! 2023-06-08T02:25:49.257301Z WSREP_SST: [ERROR] ******************* FATAL ERROR ********************** 2023-06-08T02:25:49.260159Z WSREP_SST: [ERROR] xtrabackup_checkpoints missing. xtrabackup/SST failed on DONOR. Check DONOR log 2023-06-08T02:25:49.262811Z WSREP_SST: [ERROR] ****************************************************** 2023-06-08T02:25:49.266472Z WSREP_SST: [ERROR] Cleanup after exit with status:2 2023-06-08T02:25:49.289335Z 0 [Warning] WSREP: 1.0 (host78): State transfer to 0.0 (host79) failed: -22 (Invalid argument) 2023-06-08T02:25:49.289400Z 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():811: Will never receive state. Need to abort. 2023-06-08T02:25:49.289465Z 0 [Note] WSREP: gcomm: terminating thread 2023-06-08T02:25:49.289494Z 0 [Note] WSREP: gcomm: joining thread 2023-06-08T02:25:49.289662Z 0 [Note] WSREP: gcomm: closing backend 2023-06-08T02:25:49.593055Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.106.113.79' --datadir '/data/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '9996' --mysqld-version '5.7.41-44-57' '' : 2 (No such file or directory) 2023-06-08T02:25:49.593124Z 0 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. 2023-06-08T02:25:49.593137Z 0 [ERROR] WSREP: SST script aborted with error 2 (No such file or directory) 2023-06-08T02:25:49.593186Z 0 [ERROR] WSREP: SST failed: 2 (No such file or directory) 2023-06-08T02:25:49.593234Z 0 [ERROR] Aborting 2023-06-08T02:25:49.593269Z 0 [Note] WSREP: Signalling cancellation of the SST request. 2023-06-08T02:25:49.593306Z 0 [Note] WSREP: SST request was cancelled 2023-06-08T02:25:49.593337Z 0 [Note] Giving 2 client threads a chance to die gracefully 2023-06-08T02:25:49.593357Z 1 [Note] WSREP: Closing send monitor... 2023-06-08T02:25:49.593370Z 1 [Note] WSREP: Closed send monitor. 2023-06-08T02:25:50.292465Z 0 [Note] WSREP: Current view of cluster as seen by this node