ผู้เขียน หัวข้อ: ไฟดับ mysql ไม่run ส่ง err มาให้ดู  (อ่าน 4309 ครั้ง)

0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้

ออฟไลน์ test_i

  • Jr. Member
  • **
  • กระทู้: 99
  • Respect: 0
    • ดูรายละเอียด
ไฟดับ mysql ไม่run ส่ง err มาให้ดู
« เมื่อ: มีนาคม 21, 2014, 12:11:24 PM »
0

Last login: Fri Mar 21 12:02:39 2014 from 30.1.54.15
[root@BMS-Restore ~]# nano /var/lib/mysql/BMS-Restore.err
  GNU nano 2.0.9                File: /var/lib/mysql/BMS-Restore.err                                       

130730 13:07:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130730 13:07:25 [Note] Plugin 'FEDERATED' is disabled.
130730 13:07:25 InnoDB: The InnoDB memory heap is disabled
130730 13:07:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130730 13:07:25 InnoDB: Compressed tables use zlib 1.2.3
130730 13:07:25 InnoDB: Using Linux native AIO
130730 13:07:25 InnoDB: Initializing buffer pool, size = 1.9G
130730 13:07:25 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
130730 13:07:25  InnoDB: Setting file /var/lib/mysql/ibdata1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
130730 13:07:26  InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
130730 13:07:28  InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
                                            [ Read 2774 lines ]
^G Get Help      ^O WriteOut      ^R Read File     ^Y Prev Page     ^K Cut Text      ^C Cur Pos
^X Exit          ^J Justify       ^W Where Is      ^V Next Page     ^U UnCut Text    ^T To Spell
  GNU nano 2.0.9                File: /var/lib/mysql/BMS-Restore.err                                       

130730 13:07:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130730 13:07:25 [Note] Plugin 'FEDERATED' is disabled.
130730 13:07:25 InnoDB: The InnoDB memory heap is disabled
130730 13:07:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130730 13:07:25 InnoDB: Compressed tables use zlib 1.2.3
130730 13:07:25 InnoDB: Using Linux native AIO
130730 13:07:25 InnoDB: Initializing buffer pool, size = 1.9G
130730 13:07:25 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
130730 13:07:25  InnoDB: Setting file /var/lib/mysql/ibdata1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
130730 13:07:26  InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
130730 13:07:28  InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
                                            [ Read 2774 lines ]
^G Get Help      ^O WriteOut      ^R Read File     ^Y Prev Page     ^K Cut Text      ^C Cur Pos
^X Exit          ^J Justify       ^W Where Is      ^V Next Page     ^U UnCut Text    ^T To Spell
  GNU nano 2.0.9                                                       File: /var/lib/mysql/BMS-Restore.err                                                                                                                     

130730 13:07:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130730 13:07:25 [Note] Plugin 'FEDERATED' is disabled.
130730 13:07:25 InnoDB: The InnoDB memory heap is disabled
130730 13:07:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130730 13:07:25 InnoDB: Compressed tables use zlib 1.2.3
130730 13:07:25 InnoDB: Using Linux native AIO
130730 13:07:25 InnoDB: Initializing buffer pool, size = 1.9G
130730 13:07:25 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /var/lib/mysql/ibdata1 did not exist:
InnoDB: a new database to be created!
130730 13:07:25  InnoDB: Setting file /var/lib/mysql/ibdata1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
130730 13:07:26  InnoDB: Log file /var/lib/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
130730 13:07:28  InnoDB: Log file /var/lib/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/lib/mysql/ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...     
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130730 13:07:31  InnoDB: Waiting for the background threads to start
130730 13:07:32 Percona XtraDB (http://www.percona.com) 5.5.31-rel30.3 started; log sequence number 0
130730 13:07:33 [Warning] 'user' entry 'root@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:07:33 [Warning] 'user' entry '@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:07:33 [Warning] 'proxies_priv' entry '@ root@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:07:33 [Note] Event Scheduler: Loaded 0 events
130730 13:07:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31-30.3'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release rel30.3, Revision 520
130730 13:07:33 [Warning] 'user' entry 'root@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:07:33 [Warning] 'user' entry '@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:07:33 [Warning] 'proxies_priv' entry '@ root@BMS-Restore' ignored in --skip-name-resolve mode.
130730 13:08:58 [Note] /usr/sbin/mysqld: Normal shutdown

130730 13:08:58 [Note] Event Scheduler: Purging the queue. 0 events
130730 13:08:58  InnoDB: Starting shutdown...
130730 13:09:01  InnoDB: Shutdown completed; log sequence number 1597914
130730 13:09:01 [Note] /usr/sbin/mysqld: Shutdown complete

^G Get Help                          ^O WriteOut                          ^R Read File                         ^Y Prev Page                         ^K Cut Text                          ^C Cur Pos
^X Exit                              ^J Justify                           ^W Where Is                          ^V Next Page                         ^U UnCut Text                        ^T To Spell
รพ.ขามทะเลสอ  นครราชสีมา  HOSXP  3.53.7.1 เริ่ม 1 ก.พ.53  Mysql percona 5.0.41 CentOS 5.4 64 bit และ สอ.ทุกแห่งเริ่ม 1ตค.52
Email : test_i@hotmail.com,Phipop01@gmail.com  Tel.0898465260

ออฟไลน์ test_i

  • Jr. Member
  • **
  • กระทู้: 99
  • Respect: 0
    • ดูรายละเอียด
Re: ไฟดับ mysql ไม่run ส่ง err มาให้ดู
« ตอบกลับ #1 เมื่อ: มีนาคม 21, 2014, 12:12:20 PM »
0
พอจะมีวิธีแก้ ม่ะ
รพ.ขามทะเลสอ  นครราชสีมา  HOSXP  3.53.7.1 เริ่ม 1 ก.พ.53  Mysql percona 5.0.41 CentOS 5.4 64 bit และ สอ.ทุกแห่งเริ่ม 1ตค.52
Email : test_i@hotmail.com,Phipop01@gmail.com  Tel.0898465260

ออฟไลน์ test_i

  • Jr. Member
  • **
  • กระทู้: 99
  • Respect: 0
    • ดูรายละเอียด
Re: ไฟดับ mysql ไม่run ส่ง err มาให้ดู
« ตอบกลับ #2 เมื่อ: มีนาคม 21, 2014, 13:17:40 PM »
0
ขอโทษที ลืมดู  start มันขึ้น

Starting MySQL (Percona Server)...The server quit without updating PID file (/var/lib/mysql/BMS-Restore.pid).                              [FAILED]


« แก้ไขครั้งสุดท้าย: มีนาคม 21, 2014, 13:21:00 PM โดย test_i »
รพ.ขามทะเลสอ  นครราชสีมา  HOSXP  3.53.7.1 เริ่ม 1 ก.พ.53  Mysql percona 5.0.41 CentOS 5.4 64 bit และ สอ.ทุกแห่งเริ่ม 1ตค.52
Email : test_i@hotmail.com,Phipop01@gmail.com  Tel.0898465260