Sáng sớm nay em vừa vào web thì thấy báo mysql has gone away. Không thể start được service lên
Code:
[root@localhost ~]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Kiểm tra trong log của mysql thì thấy đoạn này :
Code:
Version: '5.5.10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
121014 2:07:02 [ERROR] /usr/libexec/mysqld: Disk is full writing './hd_forum/hd_log_errors.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
121014 2:07:02 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
121014 2:07:57 [ERROR] Error writing file '/var/log/mysql/mysql-slow.log' (errno: 1)
121014 2:08:59 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYYRFHmA' (Errcode: 28)
121014 2:16:46 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYAoml59' (Errcode: 28)
121014 2:17:02 [ERROR] /usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
121014 2:20:01 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYQBmgl5' (Errcode: 28)
121014 2:20:48 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYmvmwNJ' (Errcode: 28)
InnoDB: Warning: a long semaphore wait:
--Thread 2435238800 has waited at /builddir/build/BUILD/mysql-5.5.10/storage/innobase/btr/btr0cur.c line 252 for 241.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x9d562198 created in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/buf/buf0buf.c line 898
a writer (thread id 2435238800) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffff
Last time read locked in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/btr/btr0sea.c line 903
Last time write locked in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/row/row0upd.c line 2096
InnoDB: Warning: a long semaphore wait:
--Thread 2532379536 has waited at /builddir/build/BUILD/mysql-5.5.10/storage/innobase/btr/btr0cur.c line 252 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0x9d562198 created in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/buf/buf0buf.c line 898
a writer (thread id 2435238800) has reserved it in mode wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffff
Last time read locked in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/btr/btr0sea.c line 903
Last time write locked in file /builddir/build/BUILD/mysql-5.5.10/storage/innobase/row/row0upd.c line 2096
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
=====================================
121014 2:26:21 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 35 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 33447 1_sec121014 09:55:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121014 9:55:31 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
121014 9:55:31 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
121014 9:55:31 [ERROR] Aborting
121014 9:55:31 [Note] /usr/libexec/mysqld: Shutdown complete
121014 09:55:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121014 10:02:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121014 10:02:17 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
121014 10:02:18 [Note] Plugin 'FEDERATED' is disabled.
121014 10:02:18 InnoDB: The InnoDB memory heap is disabled
121014 10:02:18 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121014 10:02:18 InnoDB: Compressed tables use zlib 1.2.3
121014 10:02:18 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibQutCaT' (Errcode: 28)
121014 10:02:18 InnoDB: Error: unable to create temporary file; errno: 28
121014 10:02:18 [ERROR] Plugin 'InnoDB' init function returned error.
121014 10:02:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/libexec/mysqld: File '/var/log/mysql/mysql-slow.log' not found (Errcode: 13)
121014 10:02:18 [ERROR] Could not use /var/log/mysql/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
121014 10:02:18 [ERROR] Unknown/unsupported storage engine: InnoDB
121014 10:02:18 [ERROR] Aborting
121014 10:02:18 [Note] /usr/libexec/mysqld: Shutdown complete
121014 10:02:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121014 10:06:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121014 10:06:59 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
121014 10:06:59 [Note] Plugin 'FEDERATED' is disabled.
121014 10:06:59 InnoDB: The InnoDB memory heap is disabled
121014 10:06:59 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121014 10:06:59 InnoDB: Compressed tables use zlib 1.2.3
121014 10:06:59 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibIssAup' (Errcode: 28)
121014 10:06:59 InnoDB: Error: unable to create temporary file; errno: 28
121014 10:06:59 [ERROR] Plugin 'InnoDB' init function returned error.
121014 10:06:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/libexec/mysqld: File '/var/log/mysql/mysql-slow.log' not found (Errcode: 13)
121014 10:06:59 [ERROR] Could not use /var/log/mysql/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
121014 10:06:59 [ERROR] Unknown/unsupported storage engine: InnoDB
121014 10:06:59 [ERROR] Aborting
Em search google thì thấy đây là thông báo disk full của Mysql, nhưng đã thử clear các log của mysqld, clear luôn bảng /hd_forum/hd_log_errors.MYD , sau đó start lại thì vẫn lỗi
Code:
121014 10:06:59 [Note] /usr/libexec/mysqld: Shutdown complete
121014 10:06:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121014 10:09:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121014 10:09:24 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
121014 10:09:24 [Note] Plugin 'FEDERATED' is disabled.
121014 10:09:24 InnoDB: The InnoDB memory heap is disabled
121014 10:09:24 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121014 10:09:24 InnoDB: Compressed tables use zlib 1.2.3
121014 10:09:24 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibR4sYqd' (Errcode: 28)
121014 10:09:24 InnoDB: Error: unable to121014 10:09:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
121014 10:14:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121014 10:14:38 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
121014 10:14:38 [Note] Plugin 'FEDERATED' is disabled.
121014 10:14:38 InnoDB: The InnoDB memory heap is disabled
121014 10:14:38 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
121014 10:14:38 InnoDB: Compressed tables use zlib 1.2.3
121014 10:14:38 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibQRidFL' (Errcode: 28)
121014 10:14:38 InnoDB: Error: unable to create temporary file; errno: 28
121014 10:14:38 [ERROR] Plugin 'InnoDB' init function returned error.
121014 10:14:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121014 10:14:38 [ERROR] Unknown/unsupported storage engine: InnoDB
121014 10:14:38 [ERROR] Aborting
121014 10:14:38 [Note] /usr/libexec/mysqld: Shutdown complete
121014 10:14:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended