Description:
1.executing the TRUNCATE SQL statement:TRUNCATE admin.open_api_url ;
The following is the MySQL error log:(/var/log/mysql/error.log)
07:07:17 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f50b809d200
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f510047bd50 thread_stack 0x80000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x557ac4c2ead1]
/usr/sbin/mysqld(print_fatal_signal(int)+0x2fb) [0x557ac3acf7db]
/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0x557ac3acf895]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x14420) [0x7f5243c78420]
/usr/sbin/mysqld(ha_innobase::truncate_impl(char const*, TABLE*, dd::Table*)+0x1e5) [0x557ac4c80ea5]
/usr/sbin/mysqld(ha_create_table(THD*, char const*, char const*, char const*, HA_CREATE_INFO*, bool, bool, dd::Table*)+0xb59) [0x557ac3be5009]
/usr/sbin/mysqld(Sql_cmd_truncate_table::truncate_base(THD*, TABLE_LIST*)+0x6be) [0x557ac3e8b5be]
/usr/sbin/mysqld(Sql_cmd_truncate_table::execute(THD*)+0x55) [0x557ac3e8c285]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xa00) [0x557ac3979960]
/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x434) [0x557ac397e574]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1d68) [0x557ac3980808]
/usr/sbin/mysqld(do_command(THD*)+0x116) [0x557ac39819d6]
/usr/sbin/mysqld(+0x1122698) [0x557ac3ac0698]
/usr/sbin/mysqld(+0x27e1bcd) [0x557ac517fbcd]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7f5243c6c609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f5242ebc133]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f50b8018400): is an invalid pointer
Connection ID (thread ID): 167
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2.Other relevant information:
Tablespace is missing for table admin/open_api_url.
Tablespace is missing for table admin/open_api_url.
Got error 168 - 'Unknown (generic) error from engine' from storage engine
Storage engine can't drop table 'admin.open_api_url'
实际上open_api_url.ibd 文件存在的
Actually, open_api_url.ibd file exists
root@lot-server:/var/lib/mysql/admin# ll open_api_url.ibd
-rw-r----- 1 mysql mysql 114688 Apr 6 14:31 open_api_url.ibd
3.
Except for desc open_api_url statement, execute open_api_url All SQL statements related : Tablespace is missing for table admin/open_api_url.
How to repeat:
1.executing the TRUNCATE SQL statement
Suggested fix:
I guess it should be related to tablespaces, so I suggest improving tablespace design