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

Server crashes upon replacing a sequence used as default by a table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 12.2, 11.8
    • 10.11, 11.4, 12.2, 11.8
    • Sequences
    • None

    Description

      CREATE SEQUENCE s;
      CREATE TABLE t (f INT DEFAULT(NEXTVAL(s)));
      CREATE OR REPLACE TABLE s (a INT);
      INSERT INTO t VALUES ();
       
      DROP TABLE t, s;
      

      10.11 536cd151f0370216d9ba4c15f40c7037060972a5 debug

      mariadbd: /data/bld/10.11-asan-ubsan/sql/item_func.cc:7146: virtual longlong Item_func_nextval::val_int(): Assertion `table->s->sequence' failed.
      251110 19:11:20 [ERROR] /share8t/bld/10.11-asan-ubsan/sql/mariadbd got signal 6 ;
       
      #10 0x00007f25dcc53eb2 in __GI___assert_fail (assertion=0x5588752bf2c0 "table->s->sequence", file=0x5588752b8660 "/data/bld/10.11-asan-ubsan/sql/item_func.cc", line=7146, function=0x5588752bf260 "virtual longlong Item_func_nextval::val_int()") at ./assert/assert.c:101
      #11 0x0000558872bc02d7 in Item_func_nextval::val_int (this=0x625000252228) at /data/bld/10.11-asan-ubsan/sql/item_func.cc:7146
      #12 0x0000558872938041 in Item::save_int_in_field (this=this@entry=0x625000252228, field=field@entry=0x625000251188, no_conversions=no_conversions@entry=false) at /data/bld/10.11-asan-ubsan/sql/item.cc:7084
      #13 0x000055887211b1f8 in Type_handler_int_result::Item_save_in_field (this=<optimized out>, item=0x625000252228, field=0x625000251188, no_conversions=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/sql_type.cc:4433
      #14 0x00005588728c12f0 in Item::save_in_field (this=0x625000252228, field=0x625000251188, no_conversions=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/item.cc:7104
      #15 0x0000558871c0e791 in TABLE::update_default_fields (this=this@entry=0x61900005cd98, ignore_errors=ignore_errors@entry=false) at /data/bld/10.11-asan-ubsan/sql/table.cc:9257
      #16 0x000055887121ab49 in fill_record (thd=thd@entry=0x62c0000b0218, table_arg=table_arg@entry=0x61900005cd98, fields=..., values=..., ignore_errors=ignore_errors@entry=false, update=update@entry=false) at /data/bld/10.11-asan-ubsan/sql/sql_base.cc:9167
      #17 0x000055887121b3d7 in fill_record_n_invoke_before_triggers (thd=thd@entry=0x62c0000b0218, table=table@entry=0x61900005cd98, fields=..., values=..., ignore_errors=ignore_errors@entry=false, event=event@entry=TRG_EVENT_INSERT) at /data/bld/10.11-asan-ubsan/sql/sql_base.cc:9311
      #18 0x00005588713e0e63 in mysql_insert (thd=thd@entry=0x62c0000b0218, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/sql_insert.cc:1130
      #19 0x000055887157361f in mysql_execute_command (thd=thd@entry=0x62c0000b0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:4643
      #20 0x000055887158f217 in mysql_parse (thd=thd@entry=0x62c0000b0218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f25d2146ab0) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:8219
      #21 0x0000558871598597 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0000b0218, packet=packet@entry=0x62900024e219 "INSERT INTO t VALUES ()", packet_length=packet_length@entry=23, blocking=blocking@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:1921
      #22 0x00005588715a51d3 in do_command (thd=thd@entry=0x62c0000b0218, blocking=blocking@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:1434
      #23 0x0000558871d9e51c in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6080000039b8, put_in_cache=put_in_cache@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_connect.cc:1475
      #24 0x0000558871d9f679 in handle_one_connection (arg=0x6080000039b8) at /data/bld/10.11-asan-ubsan/sql/sql_connect.cc:1387
      #25 0x000055887371e295 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.11-asan-ubsan/storage/perfschema/pfs.cc:2201
      #26 0x00007f25dcca81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #27 0x00007f25dcd2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
       
      Status: NOT_KILLED
      Query (0x62d00005a438): INSERT INTO t VALUES ()
      

      10.11 536cd151f0370216d9ba4c15f40c7037060972a5 non-debug

      #2  <signal handler called>
      #3  0x0000564ba9901a10 in inline_mysql_rwlock_wrlock (src_file=0x564baa13f7b0 "/data/bld/10.11-rel/sql/sql_sequence.cc", src_line=426, that=0x60) at /data/bld/10.11-rel/include/mysql/psi/mysql_thread.h:931
      #4  SEQUENCE::write_lock (this=0x0, table=0x7fd360144c88) at /data/bld/10.11-rel/sql/sql_sequence.cc:426
      #5  0x0000564ba9903049 in SEQUENCE::next_value (this=0x0, table=0x7fd360144c88, second_round=<optimized out>, error=0x7fd3720c8704) at /data/bld/10.11-rel/sql/sql_sequence.cc:748
      #6  0x0000564ba99fb974 in Item_func_nextval::val_int (this=0x7fd360037be8) at /data/bld/10.11-rel/sql/item_func.cc:7189
      #7  0x0000564ba99af68f in Item::save_int_in_field (this=0x7fd360037be8, field=0x7fd360036bd8, no_conversions=<optimized out>) at /data/bld/10.11-rel/sql/item.cc:7084
      #8  0x0000564ba99a0fc5 in Item::save_in_field (this=0x7fd360037be8, field=0x7fd360036bd8, no_conversions=<optimized out>) at /data/bld/10.11-rel/sql/item.cc:7104
      #9  0x0000564ba982e6b9 in TABLE::update_default_fields (this=this@entry=0x7fd36022fed8, ignore_errors=<optimized out>) at /data/bld/10.11-rel/sql/table.cc:9257
      #10 0x0000564ba96c0b99 in fill_record (thd=thd@entry=0x7fd360000c68, table_arg=table_arg@entry=0x7fd36022fed8, fields=..., values=..., ignore_errors=ignore_errors@entry=false, update=update@entry=false) at /data/bld/10.11-rel/sql/sql_base.cc:9167
      #11 0x0000564ba96c0e8a in fill_record_n_invoke_before_triggers (thd=thd@entry=0x7fd360000c68, table=table@entry=0x7fd36022fed8, fields=..., values=..., ignore_errors=ignore_errors@entry=false, event=event@entry=TRG_EVENT_INSERT) at /data/bld/10.11-rel/sql/sql_base.cc:9311
      #12 0x0000564ba96fac72 in mysql_insert (thd=thd@entry=0x7fd360000c68, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /data/bld/10.11-rel/sql/sql_insert.cc:1130
      #13 0x0000564ba972e0bb in mysql_execute_command (thd=thd@entry=0x7fd360000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.11-rel/sql/sql_parse.cc:4643
      #14 0x0000564ba9732786 in mysql_parse (thd=0x7fd360000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/bld/10.11-rel/sql/sql_parse.cc:8219
      #15 0x0000564ba9734c45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd360000c68, packet=packet@entry=0x7fd3600086f9 "INSERT INTO t VALUES ()", packet_length=packet_length@entry=23, blocking=blocking@entry=true) at /data/bld/10.11-rel/sql/sql_parse.cc:2020
      #16 0x0000564ba973683f in do_command (thd=thd@entry=0x7fd360000c68, blocking=blocking@entry=true) at /data/bld/10.11-rel/sql/sql_parse.cc:1434
      #17 0x0000564ba985c505 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564bb11fc578, put_in_cache=put_in_cache@entry=true) at /data/bld/10.11-rel/sql/sql_connect.cc:1475
      #18 0x0000564ba985c855 in handle_one_connection (arg=arg@entry=0x564bb11fc578) at /data/bld/10.11-rel/sql/sql_connect.cc:1387
      #19 0x0000564ba9beb0e7 in pfs_spawn_thread (arg=0x564bb11afd78) at /data/bld/10.11-rel/storage/perfschema/pfs.cc:2201
      #20 0x00007fd377fc91c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #21 0x00007fd37804985c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
       
      Status: NOT_KILLED
      Query (0x7fd360010d60): INSERT INTO t VALUES ()
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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