23.04.2014 00:26, Vladislav V. Prodan пишет:
Вылетел один винт в массиве.
После рестарта сервера Mysql не поднимается
140423 0:15:46 [Note] Plugin 'FEDERATED' is disabled.
140423 0:15:46 InnoDB: Initializing buffer pool, size = 6.6G
140423 0:15:47 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140423 0:15:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Transaction 0 2326200221 was in the XA prepared state.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 0 2326201600
InnoDB: Last MySQL binlog file position 0 7520, file name ./mysql-bin.029690
InnoDB: Starting in background the rollback of uncommitted transactions
140423 0:17:49 InnoDB: Rollback of non-prepared transactions completed
140423 0:17:50 InnoDB: Started; log sequence number 19 3123592930
/usr/local/libexec/mysqld: File 'Data locked: NO' not found (Errcode: 2)
140423 0:17:50 [ERROR] Failed to open log (file 'Data locked: NO', errno 2)
140423 0:17:50 [ERROR] Could not open log file
140423 0:17:50 [ERROR] Can't init tc log
140423 0:17:50 [ERROR] Aborting
140423 0:17:50 InnoDB: Starting shutdown...
В итоге два мускульных процесса подвисли.
mysql 6650 0,0 0,0 14528 2200 ?? Is 0:15
0:00,02 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/beastie.XXX.com.pid
mysql 6909 0,0 3,9 8384780 966764 ?? I 0:15
0:01,68 /usr/local/libexec/mysqld
--defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local
--datadir=/var/db/mysql --log-error=/var/db/mysql/beastie.XXX.com.err
--open-files-limit=200000 --pid-file=/var/db/mysql/beastie.XXX.com.pid
--socket=/tmp/mysql.sock --port=3306
Как чинить - не понятно....
apr-ipv6-devrandom-gdbm-db42-mysql51-1.4.2.1.3.10 Apache Portability Library
mysql-client-5.1.54_1 Multithreaded SQL database (client)
mysql-scripts-5.1.54_1 Multithreaded SQL database (scripts)
mysql-server-5.1.54_1 Multithreaded SQL database (server)
Попробовать удалить (лучше переименовать, мало ли чего) файлы журналов и
пускай пересоздадутся заново. Можно ещё попробовать поиграться с
выставлением разных значений в innodb_force_recovery
