Details
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 ()
|