А снести их через kill -9 и запустится с force_repair=4 (или как там его) не пробовал?
2014-04-23 0:26 GMT+03:00 Vladislav V. Prodan <[email protected]>: > Вылетел один винт в массиве. > После рестарта сервера 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 >
