问题故障:
MySQL数据库意外崩溃,一直无法启动数据库。
报错日志:
启动报错:service mysqld restart
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/www/wdlinux/mysql/var/iZ2358oz5deZ.pid).
数据库error日志:
200719 22:07:43 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 840 of name "./ob_wp/ob_termmeta.ibd"
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 840 of name "./dev_nss/dg_queue.ibd" already exists in the tablespace
InnoDB: memory cache!
200719 22:07:43 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/iZ2358oz5deZ.pid ended