ERROR 1168 (HY000): Unable to open underlying table which is
mysql> show create table logs_user_login;
ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
[root aaaaaa]# ll | grep logs_user
-rw-rw---- 1 mysql mysql 9073 Jul 21 13:00 logs_user_login.frm
-rw-rw---- 1 mysql mysql 71 Jul 21 13:00 logs_user_login.MRG
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:09 sk_logs_user_login_150826.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:09 sk_logs_user_login_150826.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:09 sk_logs_user_login_150826.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:04 sk_logs_user_login_150827.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:04 sk_logs_user_login_150827.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:04 sk_logs_user_login_150827.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:05 sk_logs_user_login_150828.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:05 sk_logs_user_login_150828.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:05 sk_logs_user_login_150828.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:06 sk_logs_user_login_150829.frm
-rw-rw---- 1 mysql mysql 351350108 Aug 31 13:06 sk_logs_user_login_150829.MYD
-rw-rw---- 1 mysql mysql 25923584 Aug 31 13:06 sk_logs_user_login_150829.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 30 00:00 sk_logs_user_login_150830.frm
-rw-rw---- 1 mysql mysql 0 Aug 30 00:00 sk_logs_user_login_150830.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 30 00:00 sk_logs_user_login_150830.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 31 13:06 sk_logs_user_login_150831.frm
-rw-rw---- 1 mysql mysql 59963352 Aug 31 19:50 sk_logs_user_login_150831.MYD
-rw-rw---- 1 mysql mysql 4435968 Aug 31 19:50 sk_logs_user_login_150831.MYI
-rw-rw---- 1 mysql mysql 13261 Jul 31 16:33 sk_logs_user_login_20150604.frm
-rw-rw---- 1 mysql mysql 6134043944 Jul 31 16:36 sk_logs_user_login_20150604.MYD
-rw-rw---- 1 mysql mysql 1103480832 Jul 31 16:37 sk_logs_user_login_20150604.MYI
-rw-rw---- 1 mysql mysql 13261 Jul 31 16:43 sk_logs_user_login_20150706.frm
-rw-rw---- 1 mysql mysql 61692059296 Aug 29 14:05 sk_logs_user_login_20150706.MYD
-rw-rw---- 1 mysql mysql 11770897408 Aug 30 04:00 sk_logs_user_login_20150706.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 31 13:06 sk_logs_user_login.frm
-rw-rw---- 1 mysql mysql 125 Aug 31 13:06 sk_logs_user_login.MRG
-rw-rw---- 1 mysql mysql 9165 Jul 31 19:09 sk_logs_user_wait.frm
-rw-rw---- 1 mysql mysql 248915712 Jul 31 19:09 sk_logs_user_wait.MYD
-rw-rw---- 1 mysql mysql 18044928 Aug 1 04:02 sk_logs_user_wait.MYI
[root aaaaaa]# strings logs_user_login.MRG
logs_user_login_20150722
logs_user_login_20150706
#INSERT_METHOD=FIRST
[root aaaaaa]# strings logs_user_login.frm
PRIMARY
time
user_id
MRG_MYISAM
)
login_type
login_status
user_id
username
login_time
login_ip
product_id
channel_id
device_id
reg_time
mark
login_type
login_status
user_id
username
login_time
login_ip
product_id
channel_id
device_id
reg_time
mark
1231
[root aaaaaa]#
[root aaaaaa]# ll | grep logs_user_login_20150722
這是一個marge引擎的表
看起來是基表沒有了, 所以才會有這種情況
轉載請註明源出處
QQ 273002188 歡迎一起學習
QQ 群 236941212
ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
[root aaaaaa]# ll | grep logs_user
-rw-rw---- 1 mysql mysql 9073 Jul 21 13:00 logs_user_login.frm
-rw-rw---- 1 mysql mysql 71 Jul 21 13:00 logs_user_login.MRG
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:09 sk_logs_user_login_150826.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:09 sk_logs_user_login_150826.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:09 sk_logs_user_login_150826.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:04 sk_logs_user_login_150827.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:04 sk_logs_user_login_150827.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:04 sk_logs_user_login_150827.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:05 sk_logs_user_login_150828.frm
-rw-rw---- 1 mysql mysql 0 Aug 29 14:05 sk_logs_user_login_150828.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 29 14:05 sk_logs_user_login_150828.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 29 14:06 sk_logs_user_login_150829.frm
-rw-rw---- 1 mysql mysql 351350108 Aug 31 13:06 sk_logs_user_login_150829.MYD
-rw-rw---- 1 mysql mysql 25923584 Aug 31 13:06 sk_logs_user_login_150829.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 30 00:00 sk_logs_user_login_150830.frm
-rw-rw---- 1 mysql mysql 0 Aug 30 00:00 sk_logs_user_login_150830.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 30 00:00 sk_logs_user_login_150830.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 31 13:06 sk_logs_user_login_150831.frm
-rw-rw---- 1 mysql mysql 59963352 Aug 31 19:50 sk_logs_user_login_150831.MYD
-rw-rw---- 1 mysql mysql 4435968 Aug 31 19:50 sk_logs_user_login_150831.MYI
-rw-rw---- 1 mysql mysql 13261 Jul 31 16:33 sk_logs_user_login_20150604.frm
-rw-rw---- 1 mysql mysql 6134043944 Jul 31 16:36 sk_logs_user_login_20150604.MYD
-rw-rw---- 1 mysql mysql 1103480832 Jul 31 16:37 sk_logs_user_login_20150604.MYI
-rw-rw---- 1 mysql mysql 13261 Jul 31 16:43 sk_logs_user_login_20150706.frm
-rw-rw---- 1 mysql mysql 61692059296 Aug 29 14:05 sk_logs_user_login_20150706.MYD
-rw-rw---- 1 mysql mysql 11770897408 Aug 30 04:00 sk_logs_user_login_20150706.MYI
-rw-rw---- 1 mysql mysql 9165 Aug 31 13:06 sk_logs_user_login.frm
-rw-rw---- 1 mysql mysql 125 Aug 31 13:06 sk_logs_user_login.MRG
-rw-rw---- 1 mysql mysql 9165 Jul 31 19:09 sk_logs_user_wait.frm
-rw-rw---- 1 mysql mysql 248915712 Jul 31 19:09 sk_logs_user_wait.MYD
-rw-rw---- 1 mysql mysql 18044928 Aug 1 04:02 sk_logs_user_wait.MYI
[root aaaaaa]# strings logs_user_login.MRG
logs_user_login_20150722
logs_user_login_20150706
#INSERT_METHOD=FIRST
[root aaaaaa]# strings logs_user_login.frm
PRIMARY
time
user_id
MRG_MYISAM
)
login_type
login_status
user_id
username
login_time
login_ip
product_id
channel_id
device_id
reg_time
mark
login_type
login_status
user_id
username
login_time
login_ip
product_id
channel_id
device_id
reg_time
mark
1231
[root aaaaaa]#
[root aaaaaa]# ll | grep logs_user_login_20150722
這是一個marge引擎的表
看起來是基表沒有了, 所以才會有這種情況
轉載請註明源出處
QQ 273002188 歡迎一起學習
QQ 群 236941212
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25099483/viewspace-1788871/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1114 (HY000) The table '' is fullError
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- MySQL:Table_open_cache_hits/Table_open_cache_misses/Table_open_cache_overflowsMySql
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- ERROR 1114 (HY000): The table 'test1' is full 的解決Error
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corruptedErrorMySql
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- wireshark error: There are no interfaces on which a capture can be done.ErrorAPT
- [ERROR] Failed to open logErrorAI
- linux解決xhost: unable to open displayLinux
- linux解決xhost unable to open display‘’Linux
- Linux錯誤:xhost unable to open displayLinux
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- mysqldump: Got error: 1168 differently defined non-MyISAM LOCK TABLESMySqlGoError
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- 完美解決xhost +報錯: unable to open display
- 轉貼:xhost unable to open display解決方法
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- ERROR FIX:- rpmdb: unable to join the environmentError
- SNMP TABLE ERROR : Requested table is empty or does not existError
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- Warning: unable to open an initial console.
- ORA-31617 unable to open dump file for write
- MYSQL ERROR 2003 (HY000) CanMySqlError
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11MySqlError
- pip install scrapy報錯:error: UnableError
- Fatal error in launcher: Unable to create process using '"'Error
- error:unable to get logical block size for spfileErrorBloC
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- by which, in which, from which 語法區別
- [Symfony Component Process Exception RuntimeException] The Process class relies on proc_open, whichException
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer