Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.16, 10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
Drop virtual column crashed the instance, if you drop the index first then it's fine to drop the column.
Possibly related: MDEV-20015
[db01]> ALTER TABLE Table1 DROP COLUMN IndexedVirtualColumn;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query |
|
Error Log:
2019-10-01 12:21:43 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files |
2019-10-01 12:21:44 [Warning] Aborted connection 123 to db: 'unconnected' user: 'user01' host: 'test-host' (CLOSE_CONNECTION) |
191001 12:21:44 [ERROR] mysqld got signal 11 ; |
mysqld[12345]: segfault at c0 ip 0000457d242f4324 sp 00003488db8eb632 error 4 in mysqld[558d23c96000+12b6000]
|
Server version: 10.3.16-MariaDB-log
|
key_buffer_size=134217728
|
read_buffer_size=2097152
|
max_used_connections=104
|
max_threads=1002
|
thread_count=103
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4257786 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
 |
Thread pointer: 0x7ee0a00009a8
|
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 = 0x7ee1f80e4d00 thread_stack 0x49000
|
*** buffer overflow detected ***: /usr/sbin/mysqld terminated
|
======= Backtrace: =========
|
/lib64/libc.so.6(__fortify_fail+0x37)[0x7f03a174d9e7]
|
/lib64/libc.so.6(+0x115b62)[0x7f03a174bb62]
|
/lib64/libc.so.6(+0x117947)[0x7f03a174d947]
|
/usr/sbin/mysqld(my_addr_resolve+0xda)[0x55923769e1aa]
|
/usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x5592376877e2]
|
/usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x559237128dff]
|
/lib64/libpthread.so.0(+0xf5d0)[0x7f03a33995d0]
|
/usr/sbin/mysqld(_ZN5TABLE20update_virtual_fieldEP5Field+0x58)[0x559237005918]
|
/usr/sbin/mysqld(+0x9284d0)[0x5592372ca4d0]
|
/usr/sbin/mysqld(+0x9d735a)[0x55923737935a]
|
/usr/sbin/mysqld(+0x9df32c)[0x55923738132c]
|
/usr/sbin/mysqld(+0x9dfdcf)[0x559237381dcf]
|
/usr/sbin/mysqld(+0x937be6)[0x5592372d9be6]
|
/usr/sbin/mysqld(+0x4bf61f)[0x559236e6161f]
|
/usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x2b34)[0x559236fdebc4]
|
/usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x41b)[0x55923702f0cb]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3bf0)[0x559236f509a0]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x559236f5588b]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1d3e)[0x559236f5858e]
|
Attachments
Issue Links
- relates to
-
-
- Closed
-