BMS-HOSxP Community
HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: taewan ที่ ธันวาคม 26, 2010, 05:21:24 AM
-
ที่ 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
มันหมายถึงอะไรครับ แล้วแก้ไขอย่างไง
ขอบคุณครับ
-
ลอง Drop ตาราง provis_diag_op และ provis_proced_op แล้วทำการ upgrade structure ใหม่ครับ
-
ขอบคุณมากครับ เดี๋ยวผมทำดูครับ