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

crash when using SEQUENCE as column default

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.1
    • 10.3.3
    • Sequences
    • None

    Description

      The following simple test case crashes the MariaDB server for the INSERT statement.

      create sequence s1;
      create table t1 (c1 bigint primary key default next value for s1, c2 int);
      insert into t1 (c2) values (42);
      

      MariaDB built from source (released 10.3.1 tarball). Same behaviour in release and debug build. Here is the stack trace from the debug build:

      #0  0x00007fbaaeaad0c1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x000055646e7c4285 in my_write_core (sig=11) at /mnt/local/temp/mariadb-10.3.1/mysys/stacktrace.c:481
      #2  0x000055646e045203 in handle_fatal_signal (sig=11) at /mnt/local/temp/mariadb-10.3.1/sql/signal_handler.cc:299
      #3  <signal handler called>
      #4  0x000055646e0d09c1 in Item_func_nextval::val_int (this=0x7fb9ec02e0d0) at /mnt/local/temp/mariadb-10.3.1/sql/item_func.cc:6780
      #5  0x000055646e06ac48 in Item::save_int_in_field (this=0x7fb9ec02e0d0, field=0x7fb9ec02c230, no_conversions=false) at /mnt/local/temp/mariadb-10.3.1/sql/item.cc:6460
      #6  0x000055646df5d6c4 in Type_handler_int_result::Item_save_in_field (this=0x55646f412130 <type_handler_longlong>, item=0x7fb9ec02e0d0, field=0x7fb9ec02c230, no_conversions=false) at /mnt/local/temp/mariadb-10.3.1/sql/sql_type.cc:2457
      #7  0x000055646e06acf3 in Item::save_in_field (this=0x7fb9ec02e0d0, field=0x7fb9ec02c230, no_conversions=false) at /mnt/local/temp/mariadb-10.3.1/sql/item.cc:6470
      #8  0x000055646dea4fd5 in TABLE::update_default_fields (this=0x7fb9ec027ba0, update_command=false, ignore_errors=false) at /mnt/local/temp/mariadb-10.3.1/sql/table.cc:7521
      #9  0x000055646dd25355 in fill_record (thd=0x7fb9ec000b00, table_arg=0x7fb9ec027ba0, fields=..., values=..., ignore_errors=false, update=false) at /mnt/local/temp/mariadb-10.3.1/sql/sql_base.cc:7965
      #10 0x000055646dd25813 in fill_record_n_invoke_before_triggers (thd=0x7fb9ec000b00, table=0x7fb9ec027ba0, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /mnt/local/temp/mariadb-10.3.1/sql/sql_base.cc:8098
      #11 0x000055646dd65e4c in mysql_insert (thd=0x7fb9ec000b00, table_list=0x7fb9ec0135f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /mnt/local/temp/mariadb-10.3.1/sql/sql_insert.cc:958
      #12 0x000055646dd98c74 in mysql_execute_command (thd=0x7fb9ec000b00) at /mnt/local/temp/mariadb-10.3.1/sql/sql_parse.cc:4688
      #13 0x000055646dda2fda in mysql_parse (thd=0x7fb9ec000b00, rawbuf=0x7fb9ec013508 "insert into t1 (c2) values (42)", length=31, parser_state=0x7fba94c46660, is_com_multi=false, is_next_command=false) at /mnt/local/temp/mariadb-10.3.1/sql/sql_parse.cc:7930
      #14 0x000055646dd9119b in dispatch_command (command=COM_QUERY, thd=0x7fb9ec000b00, packet=0x7fb9ec00add1 "insert into t1 (c2) values (42)", packet_length=31, is_com_multi=false, is_next_command=false) at /mnt/local/temp/mariadb-10.3.1/sql/sql_parse.cc:1819
      ...
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              axel Axel Schwenke
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.