mysql错误集

恢复-误删除mysql.sock

[root@mha02 ~]# cd /tmp/
[root@mha02 tmp]# rm -rf * sql

解决方法：重启mysql会自动生成mysql.sock

[root@mha02 tmp]# /etc/init.d/mysqld restart

[root@mha02 tmp]# ps -ef | grep mysql
root     15867 15710  0 May07 pts/0    00:00:00 mysql -uroot -px x -S /tmp/mysql.sock
root     16808 16779  0 08:50 pts/2    00:00:00 mysql -uroot -px x -S /tmp/mysql.sock
root     20633 19626  0 11:34 pts/3    00:00:00 grep --color=auto mysql
[root@mha02 tmp]# kill -9 15867
[root@mha02 tmp]# kill -9 16779
[root@mha02 tmp]# ps -ef | grep mysql
root     20650 19626  0 11:34 pts/3    00:00:00 grep --color=auto mysql

重启报错-without updating PID

[root@mha02 tmp]# /etc/init.d/mysqld restart
Shutting down MySQL.... SUCCESS!
Starting MySQL... ERROR! The server quit without updating PID file (/data3/mysql/data/mha02.pid).

[root@mha02 tmp]# /etc/init.d/mysqld restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL.... ERROR! The server quit without updating PID file (/data3/mysql/data/mha02.pid).

解决方法：

[root@mha02 tmp]# ps -ef | grep mysql
root     15867 15710  0 May07 pts/0    00:00:00 mysql -uroot -px x -S /tmp/mysql.sock
root     16808 16779  0 08:50 pts/2    00:00:00 mysql -uroot -px x -S /tmp/mysql.sock
root     20633 19626  0 11:34 pts/3    00:00:00 grep --color=auto mysql
[root@mha02 tmp]# kill -9 15867
[root@mha02 tmp]# kill -9 16779
[root@mha02 tmp]# ps -ef | grep mysql
root     20650 19626  0 11:34 pts/3    00:00:00 grep --color=auto mysql

[root@mha02 tmp]# ls -l
total 4
-rw-r--r-- 1 root  root  0 May  8 11:30 mysql.sock
-rw------- 1 mysql mysql 6 May  8 11:36 mysql.sock.lock

更改权限用户
[root@mha02 tmp]# chown -R mysql.mysql mysql.sock
[root@mha02 tmp]# ls -l
total 4
-rw-r--r-- 1 mysql mysql 0 May  8 11:30 mysql.sock
-rw------- 1 mysql mysql 6 May  8 11:36 mysql.sock.lock

不要用restart
[root@mha02 tmp]# /etc/init.d/mysqld restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL.. SUCCESS!
用restart
[root@mha02 tmp]# /etc/init.d/mysqld start
Starting MySQL SUCCESS!
[root@mha02 tmp]# 2021-05-08T03:41:03.848641Z mysqld_safe A mysqld process already exists

报错1062

   Last_SQL_Errno: 1062
   Last_SQL_Error: Could not execute Write_rows event on table log.log20210507; Duplicate entry '60-f2-62-c1-84-32-2021-05-07 23:13:48' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000001, end_log_pos 3944831

解决方法：

# slave 上执行
stop slave;
reset slave all;
CHANGE MASTER TO 
MASTER_HOST='10.0.0.1',
MASTER_USER='repl',
MASTER_PASSWORD='123',
MASTER_PORT=3306,
MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=228190981,
MASTER_CONNECT_RETRY=10;
start slave;

---