ช่วยดู error log ของ MySQL ผมด้วย มันหมายความว่าไงครับ

[taewan]

ที่ Server มี error log เป็น
Version: '5.1.39-percona-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL), XtraDB 8, Revision 46
101226  5:08:32 [ERROR] Index ix_export_month of hos/provis_diag_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:37 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:37 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:37 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:37 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:37 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:38 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:38 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:08:38 [ERROR] Index ix_export_month of hos/provis_proced_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:09:41 [ERROR] Index ix_export_month of hos/provis_diag_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:10:07 [ERROR] Index ix_export_month of hos/provis_diag_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

101226  5:11:51 [ERROR] Index ix_export_month of hos/provis_diag_op has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

มันหมายถึงอะไรครับ แล้วแก้ไขอย่างไง
ขอบคุณครับ

[manoi]

ลอง Drop ตาราง provis_diag_op และ provis_proced_op แล้วทำการ upgrade structure ใหม่ครับ

[taewan]

ขอบคุณมากครับ เดี๋ยวผมทำดูครับ