BMS-HOSxP Community
HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: naydekdee ที่ ตุลาคม 17, 2011, 11:04:05 AM
-
พี่ครับ ใครที่ชำนาญ ช่วยที่ จู่ๆ ก็ mysql เน่า ไม่สามารถใช้งานได้ ของ สอ อ่ะครับ
[root@localhost ~]# service mysql restart
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................Manager of pid-file quit with[FAILED]ting file.
-
[root@localhost ~]# service mysql restart
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................Manager of pid-file quit with[FAILED]ting file.
เน้น
ลองอ่านดูครับ อาจจะคล้ายๆกัน
http://hosxp.net/index.php?option=com_smf&Itemid=28&topic=3170.0
-
เผลอ ลบ mysqld โดย Antivirus software เปล่าครับ..หรือเผลอถอน MySQL ทั้งยวง... ??? ???
-
ผมว่ามันหลายสาเหตุ ปัญหาที่ /var/lib มันเต็ม ก็เป็นได้
-
mysql ยังอยู่ พร้อมฐานข้อมูล แต่ว่า มันไม่สามารถ รัน ได้อ่ะครับ
และอีกอย่าง ตรวจสอบอย่างไร ว่าา /var/lib มันเต็ม อ่ะ ครับ ====> อธิบายหน่อย
-
091206 10:05:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091206 10:05:33 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091206 10:05:33 InnoDB: Started; log sequence number 0 366963309
091206 10:05:33 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:05:33 [Note] Event Scheduler: Loaded 0 events
091206 10:05:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:06:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:06:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:06:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:06:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:06:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:06:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:07:21 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:07:21 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:07:21 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:07:22 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:07:22 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:07:22 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:10:33 [Note] /usr/sbin/mysqld: Normal shutdown
091206 10:10:33 [Note] Event Scheduler: Purging the queue. 0 events
091206 10:10:33 InnoDB: Starting shutdown...
091206 10:10:34 InnoDB: Shutdown completed; log sequence number 0 372524893
091206 10:10:34 [Note] /usr/sbin/mysqld: Shutdown complete
091206 10:10:34 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091206 10:10:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
InnoDB: Error: auto-extending data file /var/lib/mysql/ibdata1 is of a different size
InnoDB: 18048 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 64000 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
091206 10:10:35 [ERROR] Plugin 'InnoDB' init function returned error.
091206 10:10:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091206 10:10:35 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:10:35 [Note] Event Scheduler: Loaded 0 events
091206 10:10:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:14:56 [Note] /usr/sbin/mysqld: Normal shutdown
091206 10:14:56 [Note] Event Scheduler: Purging the queue. 0 events
091206 10:14:56 [Note] /usr/sbin/mysqld: Shutdown complete
091206 10:14:56 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091206 10:14:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 18048 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 64000 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
091206 10:14:57 [ERROR] Plugin 'InnoDB' init function returned error.
091206 10:14:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091206 10:14:57 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:14:57 [Note] Event Scheduler: Loaded 0 events
091206 10:14:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:15:53 [Note] /usr/sbin/mysqld: Normal shutdown
091206 10:15:53 [Note] Event Scheduler: Purging the queue. 0 events
091206 10:15:53 [Note] /usr/sbin/mysqld: Shutdown complete
091206 10:15:53 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091206 10:15:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 18048 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 64000 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
091206 10:15:55 [ERROR] Plugin 'InnoDB' init function returned error.
091206 10:15:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091206 10:15:55 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:15:55 [Note] Event Scheduler: Loaded 0 events
091206 10:15:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:16:38 [Note] /usr/sbin/mysqld: Normal shutdown
091206 10:16:38 [Note] Event Scheduler: Purging the queue. 0 events
091206 10:16:38 [Note] /usr/sbin/mysqld: Shutdown complete
091206 10:16:38 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091206 10:16:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
091206 10:16:39 [ERROR] Plugin 'InnoDB' init function returned error.
091206 10:16:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091206 10:16:39 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:16:39 [Note] Event Scheduler: Loaded 0 events
091206 10:16:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:19:39 [Note] /usr/sbin/mysqld: Normal shutdown
091206 10:19:39 [Note] Event Scheduler: Purging the queue. 0 events
091206 10:19:39 [Note] /usr/sbin/mysqld: Shutdown complete
091206 10:19:39 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091206 10:19:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091206 10:19:40 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091206 10:19:41 InnoDB: Started; log sequence number 0 372524893
091206 10:19:41 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091206 10:19:41 [Note] Event Scheduler: Loaded 0 events
091206 10:19:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091206 10:20:24 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:20:24 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:20:24 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:20:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:20:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:20:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:21:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:21:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:21:33 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 10:21:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 10:21:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 10:21:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 15:56:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 15:56:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 15:56:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 15:56:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091206 15:56:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091206 15:56:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091206 16:51:25 [Note] /usr/sbin/mysqld: Normal shutdown
091206 16:51:25 [Note] Event Scheduler: Purging the queue. 0 events
091206 16:51:25 InnoDB: Starting shutdown...
091206 16:51:27 InnoDB: Shutdown completed; log sequence number 0 381908034
091206 16:51:27 [Note] /usr/sbin/mysqld: Shutdown complete
091206 16:51:27 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091207 09:08:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091207 9:08:24 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091207 9:08:25 InnoDB: Started; log sequence number 0 381908034
091207 9:08:25 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091207 9:08:25 [Note] Event Scheduler: Loaded 0 events
091207 9:08:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091207 9:10:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091207 9:10:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091207 9:10:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091207 9:10:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091207 9:10:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091207 9:10:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091207 17:20:53 [Note] /usr/sbin/mysqld: Normal shutdown
091207 17:20:53 [Note] Event Scheduler: Purging the queue. 0 events
091207 17:20:53 InnoDB: Starting shutdown...
091207 17:20:55 InnoDB: Shutdown completed; log sequence number 0 385129943
091207 17:20:55 [Note] /usr/sbin/mysqld: Shutdown complete
091207 17:20:55 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091208 08:51:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091208 8:51:54 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091208 8:51:55 InnoDB: Started; log sequence number 0 385129943
091208 8:51:55 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091208 8:51:55 [Note] Event Scheduler: Loaded 0 events
091208 8:51:55 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091208 12:43:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091208 12:43:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091208 12:43:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091208 12:43:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091208 12:43:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091208 12:43:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091208 16:42:52 [Note] /usr/sbin/mysqld: Normal shutdown
091208 16:42:52 [Note] Event Scheduler: Purging the queue. 0 events
091208 16:42:52 InnoDB: Starting shutdown...
091208 16:42:54 InnoDB: Shutdown completed; log sequence number 0 389495642
091208 16:42:54 [Note] /usr/sbin/mysqld: Shutdown complete
091208 16:42:54 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091209 08:25:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091209 8:25:21 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091209 8:25:22 InnoDB: Started; log sequence number 0 389495642
091209 8:25:22 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091209 8:25:22 [Note] Event Scheduler: Loaded 0 events
091209 8:25:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091209 8:39:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091209 8:39:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091209 8:39:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091209 8:39:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091209 8:39:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091209 8:39:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091209 16:44:25 [Note] /usr/sbin/mysqld: Normal shutdown
091209 16:44:25 [Note] Event Scheduler: Purging the queue. 0 events
091209 16:44:25 InnoDB: Starting shutdown...
091209 16:44:27 InnoDB: Shutdown completed; log sequence number 0 404150519
091209 16:44:27 [Note] /usr/sbin/mysqld: Shutdown complete
091209 16:44:27 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091210 12:42:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091210 12:42:52 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091210 12:42:53 InnoDB: Started; log sequence number 0 404150519
091210 12:42:53 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091210 12:42:54 [Note] Event Scheduler: Loaded 0 events
091210 12:42:54 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091210 12:43:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091210 12:43:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091210 12:43:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091210 12:43:56 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091210 12:43:56 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091210 12:43:56 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091210 16:46:14 [Note] /usr/sbin/mysqld: Normal shutdown
091210 16:46:14 [Note] Event Scheduler: Purging the queue. 0 events
091210 16:46:14 InnoDB: Starting shutdown...
091210 16:46:15 InnoDB: Shutdown completed; log sequence number 0 408215343
091210 16:46:15 [Note] /usr/sbin/mysqld: Shutdown complete
091210 16:46:15 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091211 14:42:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091211 14:42:01 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091211 14:42:03 InnoDB: Started; log sequence number 0 408215343
091211 14:42:03 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091211 14:42:03 [Note] Event Scheduler: Loaded 0 events
091211 14:42:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091211 14:48:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091211 14:48:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091211 14:48:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091211 14:48:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091211 14:48:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091211 14:48:29 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091211 16:41:09 [Note] /usr/sbin/mysqld: Normal shutdown
091211 16:41:09 [Note] Event Scheduler: Purging the queue. 0 events
091211 16:41:09 InnoDB: Starting shutdown...
091211 16:41:11 InnoDB: Shutdown completed; log sequence number 0 420140938
091211 16:41:11 [Note] /usr/sbin/mysqld: Shutdown complete
091211 16:41:11 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091212 09:23:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091212 9:23:49 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091212 9:23:50 InnoDB: Started; log sequence number 0 420140938
091212 9:23:50 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091212 9:23:50 [Note] Event Scheduler: Loaded 0 events
091212 9:23:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091212 9:23:58 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091212 9:23:58 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091212 9:23:58 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091212 9:24:05 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091212 9:24:05 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091212 9:24:05 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091212 15:32:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091212 15:32:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091212 15:32:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091212 15:32:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091212 15:32:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091212 15:32:54 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091212 15:38:05 [Note] /usr/sbin/mysqld: Normal shutdown
091212 15:38:05 [Note] Event Scheduler: Purging the queue. 0 events
091212 15:38:05 InnoDB: Starting shutdown...
091212 15:38:07 InnoDB: Shutdown completed; log sequence number 0 428740573
091212 15:38:07 [Note] /usr/sbin/mysqld: Shutdown complete
091212 15:38:07 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091213 10:47:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091213 10:47:33 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091213 10:47:34 InnoDB: Started; log sequence number 0 428740573
091213 10:47:34 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091213 10:47:34 [Note] Event Scheduler: Loaded 0 events
091213 10:47:34 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091213 11:14:50 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091213 11:14:50 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091213 11:14:50 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091213 11:14:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091213 11:14:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091213 11:14:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091213 16:12:41 [Note] /usr/sbin/mysqld: Normal shutdown
091213 16:12:41 [Note] Event Scheduler: Purging the queue. 0 events
091213 16:12:41 InnoDB: Starting shutdown...
091213 16:12:42 InnoDB: Shutdown completed; log sequence number 0 432048016
091213 16:12:42 [Note] /usr/sbin/mysqld: Shutdown complete
091213 16:12:42 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091214 08:32:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091214 8:32:14 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091214 8:32:15 InnoDB: Started; log sequence number 0 432048016
091214 8:32:15 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091214 8:32:15 [Note] Event Scheduler: Loaded 0 events
091214 8:32:15 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091214 14:43:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091214 14:43:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091214 14:43:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091214 14:43:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091214 14:43:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091214 14:43:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091214 17:08:16 [Note] /usr/sbin/mysqld: Normal shutdown
091214 17:08:16 [Note] Event Scheduler: Purging the queue. 0 events
091214 17:08:16 InnoDB: Starting shutdown...
091214 17:08:19 InnoDB: Shutdown completed; log sequence number 0 434878040
091214 17:08:19 [Note] /usr/sbin/mysqld: Shutdown complete
091214 17:08:19 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091215 14:53:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091215 14:53:45 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091215 14:53:46 InnoDB: Started; log sequence number 0 434878040
091215 14:53:46 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091215 14:53:46 [Note] Event Scheduler: Loaded 0 events
091215 14:53:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091215 15:00:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091215 15:00:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091215 15:00:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091215 15:00:11 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091215 15:00:11 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091215 15:00:11 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091215 17:17:36 [Note] /usr/sbin/mysqld: Normal shutdown
091215 17:17:36 [Note] Event Scheduler: Purging the queue. 0 events
091215 17:17:36 InnoDB: Starting shutdown...
091215 17:17:38 InnoDB: Shutdown completed; log sequence number 0 440681956
091215 17:17:38 [Note] /usr/sbin/mysqld: Shutdown complete
091215 17:17:38 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091216 08:31:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091216 8:31:37 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091216 8:31:38 InnoDB: Started; log sequence number 0 440681956
091216 8:31:38 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091216 8:31:38 [Note] Event Scheduler: Loaded 0 events
091216 8:31:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091216 8:57:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091216 8:57:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091216 8:57:16 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091216 8:57:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091216 8:57:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091216 8:57:18 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091216 16:26:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091216 16:26:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091216 16:26:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091216 16:26:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091216 16:26:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091216 16:26:31 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091216 16:38:29 [Note] /usr/sbin/mysqld: Normal shutdown
091216 16:38:29 [Note] Event Scheduler: Purging the queue. 0 events
091216 16:38:29 InnoDB: Starting shutdown...
091216 16:38:31 InnoDB: Shutdown completed; log sequence number 0 448316797
091216 16:38:31 [Note] /usr/sbin/mysqld: Shutdown complete
091216 16:38:31 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091217 09:36:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091217 9:36:37 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091217 9:36:38 InnoDB: Started; log sequence number 0 448316797
091217 9:36:38 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091217 9:36:38 [Note] Event Scheduler: Loaded 0 events
091217 9:36:38 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091217 12:53:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091217 12:53:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091217 12:53:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091217 12:53:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091217 12:53:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091217 12:53:30 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091217 19:19:30 [Note] /usr/sbin/mysqld: Normal shutdown
091217 19:19:30 [Note] Event Scheduler: Purging the queue. 0 events
091217 19:19:30 InnoDB: Starting shutdown...
091217 19:19:33 InnoDB: Shutdown completed; log sequence number 0 452751572
091217 19:19:33 [Note] /usr/sbin/mysqld: Shutdown complete
091217 19:19:33 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091218 11:06:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091218 11:06:07 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091218 11:06:08 InnoDB: Started; log sequence number 0 452751572
091218 11:06:08 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091218 11:06:09 [Note] Event Scheduler: Loaded 0 events
091218 11:06:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091218 11:10:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091218 11:10:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091218 11:10:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091218 11:10:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091218 11:10:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091218 11:10:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091218 15:57:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091218 15:57:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091218 15:57:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091218 15:57:04 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091218 15:57:04 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091218 15:57:04 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091219 9:29:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091219 9:29:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091219 9:29:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091219 9:29:13 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091219 9:29:13 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091219 9:29:13 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091219 16:43:02 [Note] /usr/sbin/mysqld: Normal shutdown
091219 16:43:02 [Note] Event Scheduler: Purging the queue. 0 events
091219 16:43:02 InnoDB: Starting shutdown...
091219 16:43:04 InnoDB: Shutdown completed; log sequence number 0 463965375
091219 16:43:04 [Note] /usr/sbin/mysqld: Shutdown complete
091219 16:43:04 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091220 11:25:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091220 11:25:21 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091220 11:25:22 InnoDB: Started; log sequence number 0 463965375
091220 11:25:22 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091220 11:25:22 [Note] Event Scheduler: Loaded 0 events
091220 11:25:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091220 11:25:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 11:25:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 11:25:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 11:25:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 11:25:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 11:25:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 16:36:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 16:36:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 16:36:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 16:36:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 16:36:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 16:36:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 16:41:44 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 16:41:44 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 16:41:44 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 16:41:46 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091220 16:41:46 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091220 16:41:46 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091220 16:48:23 [Note] /usr/sbin/mysqld: Normal shutdown
091220 16:48:23 [Note] Event Scheduler: Purging the queue. 0 events
091220 16:48:23 InnoDB: Starting shutdown...
091220 16:48:25 InnoDB: Shutdown completed; log sequence number 0 480812244
091220 16:48:25 [Note] /usr/sbin/mysqld: Shutdown complete
091220 16:48:25 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091221 08:43:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091221 8:43:16 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091221 8:43:17 InnoDB: Started; log sequence number 0 480812244
091221 8:43:17 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091221 8:43:17 [Note] Event Scheduler: Loaded 0 events
091221 8:43:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091221 9:07:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 9:07:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 9:07:41 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 9:07:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 9:07:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 9:07:43 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 11:42:57 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 11:42:57 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 11:42:57 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 11:42:59 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 11:42:59 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 11:42:59 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 14:43:40 [Note] /usr/sbin/mysqld: Normal shutdown
091221 14:43:40 [Note] Event Scheduler: Purging the queue. 0 events
091221 14:43:42 InnoDB: Starting shutdown...
091221 14:43:43 InnoDB: Shutdown completed; log sequence number 0 487104088
091221 14:43:43 [Note] /usr/sbin/mysqld: Shutdown complete
091221 14:43:43 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091221 14:47:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091221 14:47:16 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091221 14:47:17 InnoDB: Started; log sequence number 0 487104088
091221 14:47:17 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091221 14:47:17 [Note] Event Scheduler: Loaded 0 events
091221 14:47:17 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091221 14:55:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 14:55:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 14:55:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 14:55:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 14:55:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 14:55:28 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 16:28:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 16:28:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 16:28:39 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 16:28:40 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091221 16:28:40 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091221 16:28:40 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091221 16:36:52 [Note] /usr/sbin/mysqld: Normal shutdown
091221 16:36:52 [Note] Event Scheduler: Purging the queue. 0 events
091221 16:36:52 InnoDB: Starting shutdown...
091221 16:36:55 InnoDB: Shutdown completed; log sequence number 0 492968136
091221 16:36:55 [Note] /usr/sbin/mysqld: Shutdown complete
091221 16:36:55 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091222 08:17:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091222 8:17:49 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091222 8:17:50 InnoDB: Started; log sequence number 0 492968136
091222 8:17:50 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091222 8:17:50 [Note] Event Scheduler: Loaded 0 events
091222 8:17:50 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091222 8:18:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091222 8:18:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091222 8:18:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091222 8:18:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091222 8:18:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091222 8:18:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091222 13:44:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091222 13:44:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091222 13:44:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091222 13:44:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091222 13:44:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091222 13:44:26 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091222 16:52:16 [Note] /usr/sbin/mysqld: Normal shutdown
091222 16:52:16 [Note] Event Scheduler: Purging the queue. 0 events
091222 16:52:16 InnoDB: Starting shutdown...
091222 16:52:17 InnoDB: Shutdown completed; log sequence number 0 499998887
091222 16:52:17 [Note] /usr/sbin/mysqld: Shutdown complete
091222 16:52:17 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091223 08:22:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091223 8:22:30 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091223 8:22:31 InnoDB: Started; log sequence number 0 499998887
091223 8:22:31 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091223 8:22:31 [Note] Event Scheduler: Loaded 0 events
091223 8:22:31 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091223 8:26:36 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 8:26:36 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 8:26:36 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 8:26:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 8:26:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 8:26:38 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 9:52:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 9:52:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 9:52:25 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 9:52:27 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 9:52:27 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 9:52:27 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 14:52:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 14:52:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 14:52:34 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 14:52:35 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 14:52:35 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 14:52:35 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 16:30:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 16:30:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 16:30:07 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 16:30:08 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091223 16:30:08 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091223 16:30:08 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091223 16:46:22 [Note] /usr/sbin/mysqld: Normal shutdown
091223 16:46:22 [Note] Event Scheduler: Purging the queue. 0 events
091223 16:46:22 InnoDB: Starting shutdown...
091223 16:46:24 InnoDB: Shutdown completed; log sequence number 0 513613581
091223 16:46:24 [Note] /usr/sbin/mysqld: Shutdown complete
091223 16:46:24 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091224 08:50:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091224 8:50:55 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091224 8:50:56 InnoDB: Started; log sequence number 0 513613581
091224 8:50:56 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091224 8:50:56 [Note] Event Scheduler: Loaded 0 events
091224 8:50:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091224 8:51:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 8:51:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 8:51:03 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 8:51:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 8:51:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 8:51:09 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 9:05:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 9:05:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 9:05:45 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 9:05:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 9:05:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 9:05:47 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 16:18:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 16:18:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 16:18:52 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 16:18:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 16:18:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 16:18:53 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 16:21:14 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 16:21:14 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 16:21:14 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 16:21:15 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091224 16:21:15 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091224 16:21:15 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091224 16:27:37 [Note] /usr/sbin/mysqld: Normal shutdown
091224 16:27:37 [Note] Event Scheduler: Purging the queue. 0 events
091224 16:27:37 InnoDB: Starting shutdown...
091224 16:27:39 InnoDB: Shutdown completed; log sequence number 0 525893795
091224 16:27:39 [Note] /usr/sbin/mysqld: Shutdown complete
091224 16:27:39 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
091225 08:37:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
091225 8:37:51 [Warning] option 'thread_cache_size': unsigned value 33554432 adjusted to 16384
091225 8:37:52 InnoDB: Started; log sequence number 0 525893795
091225 8:37:52 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.
091225 8:37:52 [Note] Event Scheduler: Loaded 0 events
091225 8:37:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
091225 9:00:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091225 9:00:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.collation_connection.
091225 9:00:12 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.db_collation.
091225 9:00:14 [Warning] Stored routine 'hosxp_pcu'.'get_serialnumber': invalid value in column mysql.proc.character_set_client.
091225 9:00:14 [Warning] Stored
-
รบกวนหนอ่ยครับ
-
[client]
port =3306
socket =/var/lib/mysql/mysql.sock
default-character-set=tis620
[mysqld]
port =3306
datadir=/var/lib/mysql
socket =/var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet=128M
table_cache = 1000
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
max_heap_table_size = 128M
myisam_sort_buffer_size = 256M
thread_cache_size = 32M
query_cache_size = 64M
thread_concurrency = 8
default-character-set=tis620
skip-name-resolve
innodb_file_per_table
skip-character-set-client-handshake
init_connect = 'SET NAMES tis620'
max-connection = 1000
[mysqldump]
quick
max_allowed_packet = 16M
allow-keywords
[mysql]
no-auto-rehash
default-character-set=tis620
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
-
ใช้ cenos5.2 mysql 5.1.30 ครับ ของ สถานีอนามัย ครับ รบกวนด้วย ครับ
-
;D ถ้าจะแย่อยู่นะ เป็นเยอะอยู่ คาดว่าจะแก้ยากนะขอรับ ;D
8) วิธีที่ดีที่สุดน่าจะลบแล้วทำใหม่นะ นะขอรับ ;D
-
ถ้าทำไม่ได้ ก็ลองศึกษาจากที่นี้
http://danhos.thaiddns.com/smf/index.php?topic=12.0
และหาทางไม่ได้ก็ลอง โทรมาหาผม หลัง 3 ทุ่ม
http://danhos.thaiddns.com/index.php?option=com_content&view=article&id=4&Itemid=8
ปัญหา
091206 10:14:57 [ERROR] Plugin 'InnoDB' init function returned error.
091206 10:14:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
-
mysql ยังอยู่ พร้อมฐานข้อมูล แต่ว่า มันไม่สามารถ รัน ได้อ่ะครับ
และอีกอย่าง ตรวจสอบอย่างไร ว่าา /var/lib มันเต็ม อ่ะ ครับ ====> อธิบายหน่อย
ลอง พิมพ์คำสั่ง df -h แล้วสังเกตเนื้อที่ที่ใช้งานไปแล้ว สำหรับ mounted on ที่เป็น / นะคะ
งง รึเปล่า ???
ถ้างงโทรหาทีมเทรนเลยค่ะ 081-8995382 :P
-
mysql ยังอยู่ พร้อมฐานข้อมูล แต่ว่า มันไม่สามารถ รัน ได้อ่ะครับ
และอีกอย่าง ตรวจสอบอย่างไร ว่าา /var/lib มันเต็ม อ่ะ ครับ ====> อธิบายหน่อย
ลอง พิมพ์คำสั่ง df -h แล้วสังเกตเนื้อที่ที่ใช้งานไปแล้ว สำหรับ mounted on ที่เป็น / นะคะ
งง รึเปล่า ???
ถ้างงโทรหาทีมเทรนเลยค่ะ 081-8995382 :P
ครับ ผม ลองละครับ พท เหลือเยอะครับ ตอนนี้ลงใหม่ ยังแก้ไม่ได้ งง มั๊กๆๆ ติด get_serail อีก 5555 T T
-
ตอนที่ลง cenos ก็ปกติ grant สิทธิ์ อะไร ผ่านหมด มาติดตรง restore data เดิม เข้าไป ผมใช้ emergency ของโปรแกรม Hosxp restore ไปฐาน hosxp_pcu แต่ พอเปิดโปรแกรม ของ hosxp pcu
แต่มาติดตรงที่ error ===> Get_serail นี่แหละ ตอนนี้กำลัง ทดสอบโดยใช้ tooL โอนฐานของทีม Audit
ของที่นี่อ่ะครับ
เด๋วพรุ่งนี้รายงานอีกที ครับ กำลังคิดว่า น่าจะมีปัญหาตอนที่โอน อ่ะครับ ทำมา สองวันละ T^T..
-
ตอนที่ลง cenos ก็ปกติ grant สิทธิ์ อะไร ผ่านหมด มาติดตรง restore data เดิม เข้าไป ผมใช้ emergency ของโปรแกรม Hosxp restore ไปฐาน hosxp_pcu แต่ พอเปิดโปรแกรม ของ hosxp pcu
แต่มาติดตรงที่ error ===> Get_serail นี่แหละ ตอนนี้กำลัง ทดสอบโดยใช้ tooL โอนฐานของทีม Audit
ของที่นี่อ่ะครับ
เด๋วพรุ่งนี้รายงานอีกที ครับ กำลังคิดว่า น่าจะมีปัญหาตอนที่โอน อ่ะครับ ทำมา สองวันละ T^T..
ถ้ามี Backup สอ. ผม Remove Mysql ออก และลบ Folder ใน Linux ด้วยครับ
แล้วลงใหม่
1. Install Mysql
2. Tune my.cnf
3. Restart
4. Dump SQL ฐานข้อมูลเปล่า
5. Restore ข้อมูล
เพิ่งทำของ สอ.ในเขตรับผิดชอบเมื่อไม่กี่วันครับ
-
ตอน restore ฐานเปล่า restore แค่ 5-6 ตารางพอ เอาแค่พอ login ได้
restore ทุกตาราง เสียเวลา เพราะยังไงก็ต้องไป restore ไฟล์ backup อยู่ดี
-
ทำใหม่เลยครับ os+mysql+my.cnf
-
ครับผม ขอบคุณทุกท่าน นะครับ ตอนนี้ พอดีมีน้องมาช่วยทำ ขอบคุรมากครับ
-
ลงใหม่ หมด เลย 555
-
ทำใหม่เลยครับ os+mysql+my.cnf
แต่เก็บ database มา restore ใน server ตัวใหม่ดูครับ
-
;D ;D ;D error ต่างๆยังขึ้นเหมือนเดิมมั้ย วันนี้ใช้งานจริงได้แล้วยังครับพี่
ลงใหม่ หมด เลย 555
-
;D ;D ;D error ต่างๆยังขึ้นเหมือนเดิมมั้ย วันนี้ใช้งานจริงได้แล้วยังครับพี่
ลงใหม่ หมด เลย 555
ยกคืนเขาไม่แล้ว เงียบเลยอ่ะครับ แต่ว่าไม่แน่ใจอ่ะ รับรองว่าใช้ได้ใช้ดี 5555 ^ ^
แต้ง อีหลีเด้อ น้อง ขอบใจมั๊กๆๆๆ เองใจดีมว๊าาาาาก วะ ไว้วันหลัง จะรบกวนอีกอ่ะ
-
อยู่ๆ ไม่ MySQL ไม่ทำงาน ผมลอง Restart แล้วก็ไม่ทำงานครับ ขึ้นว่า MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL.................. Manager of pid-file quit without upda[FAILED]e. ต้องแก้ยังงั้ยครับ
-
อยู่ๆ ไม่ MySQL ไม่ทำงาน ผมลอง Restart แล้วก็ไม่ทำงานครับ ขึ้นว่า MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL.................. Manager of pid-file quit without upda[FAILED]e. ต้องแก้ยังงั้ยครับ
----------------------------------
Server เป็น Linux หรือ Windows ครับ มีคนไปลบไฟล์ใน Server ที่ชื่อไฟล์ XXX.pid ที่อยู่ใน /var/lib/mysql หรือเปล่าครับ ลองตรวจสอบดูว่าไฟล์นี้ยังอยู่หรือเปล่า
-
ดู hostname.err ใน /var/lib/mysql ครับ
hostname หมายถึงชื่อเครื่อง server นะครับ