Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20799

DROP Virtual Column crashes MariaDB

    XMLWordPrintable

Details

    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

          Activity

            People

              serg Sergei Golubchik
              claudio.nanni Claudio Nanni
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.