banner

[Rule] Rules  [Home] Main Forum  [Portal] Portal  
[Members] Member Listing  [Statistics] Statistics  [Search] Search  [Reading Room] Reading Room 
[Register] Register  
[Login] Loginhttp  | https  ]
 
Forum Index Thảo luận hệ điều hành *nix Service mysqld bị lỗi, không thể khởi động  XML
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 09:26:38 (+0700) | #1 | 270165
anhtuanvo
Member

[Minus]    0    [Plus]
Joined: 07/06/2009 03:12:32
Messages: 12
Offline
[Profile] [PM]
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

[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 11:04:47 (+0700) | #2 | 270166
shuichi_akai
Elite Member

[Minus]    0    [Plus]
Joined: 12/10/2003 10:40:06
Messages: 161
Location: /home
Offline
[Profile] [PM]
Thử clear /tmp chưa?

Code:
/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
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 12:56:15 (+0700) | #3 | 270171
anhtuanvo
Member

[Minus]    0    [Plus]
Joined: 07/06/2009 03:12:32
Messages: 12
Offline
[Profile] [PM]
tmp hiện đang trống trơn
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 14:38:13 (+0700) | #4 | 270173
Linkerpt
Member

[Minus]    0    [Plus]
Joined: 13/10/2012 09:02:19
Messages: 1
Offline
[Profile] [PM]
Cai lai xem the nao?
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 17:22:21 (+0700) | #5 | 270174
shuichi_akai
Elite Member

[Minus]    0    [Plus]
Joined: 12/10/2003 10:40:06
Messages: 161
Location: /home
Offline
[Profile] [PM]

anhtuanvo wrote:
tmp hiện đang trống trơn  


Xem lại permission của mysql hoặc là kiểm tra selinux.
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 14/10/2012 21:23:28 (+0700) | #6 | 270177
anhtuanvo
Member

[Minus]    0    [Plus]
Joined: 07/06/2009 03:12:32
Messages: 12
Offline
[Profile] [PM]
thư mục tmp đã chmod 777, owner by root.
Selinux mình không dùng đến nên đã tắt từ lâu rồi smilie
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 15/10/2012 06:40:49 (+0700) | #7 | 270181
[Avatar]
vitcon01
Member

[Minus]    0    [Plus]
Joined: 29/04/2009 11:28:21
Messages: 306
Offline
[Profile] [PM]
FIx luôn này xem sao:

Code:
/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
JK - JH
()()()
LTKT - LTT
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 15/10/2012 13:00:23 (+0700) | #8 | 270195
anhtuanvo
Member

[Minus]    0    [Plus]
Joined: 07/06/2009 03:12:32
Messages: 12
Offline
[Profile] [PM]
Cảm ơn mọi người, mình đã fix được lỗi rồi. Là do mấy ngày hôm nay mình đặt backup liên tục, nên dung lượng HDD tăng cao quá, available 0% smilie
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 19/10/2012 18:09:46 (+0700) | #9 | 270299
stonewall
Member

[Minus]    0    [Plus]
Joined: 22/04/2010 02:44:05
Messages: 18
Offline
[Profile] [PM]
Ngay dòng thứ 2
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)
 


đã cho bạn biết điều đó rồi.
[Up] [Print Copy]
  [Question]   Service mysqld bị lỗi, không thể khởi động 22/10/2012 13:24:13 (+0700) | #10 | 270359
traunui
Member

[Minus]    0    [Plus]
Joined: 28/02/2012 20:23:08
Messages: 62
Offline
[Profile] [PM]
Mấy tuần trước cũng gặp lỗi tương tự chủ thớt. Để backup theo ngày + tmp bị full.
Nên giờ phải thêm đoạn script cảnh báo DiskUsage khi nó lên 90% là có email report ngay smilie
[Up] [Print Copy]
[digg] [delicious] [google] [yahoo] [technorati] [reddit] [stumbleupon]
Go to: 
 Users currently in here 
1 Anonymous

Powered by JForum - Extended by HVAOnline
 hvaonline.net  |  hvaforum.net  |  hvazone.net  |  hvanews.net  |  vnhacker.org
1999 - 2013 © v2012|0504|218|