Вылетел один винт в массиве. После рестарта сервера 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) -- Vladislav V. Prodan System & Network Administrator support.od.ua
