Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.5(EOL)
Description
Seems similar to MDEV-22705 but following test case crashes only 11.5 debug build.
CREATE SEQUENCE s AS BIGINT UNSIGNED START WITH 9223372036854775800 INCREMENT 0; |
SET GLOBAL AUTO_INCREMENT_INCREMENT=10; |
SELECT NEXTVAL (s); |
FLUSH TABLES WITH READ LOCK; |
UPDATE s SET a=1; |
Leads to:
|
11.5.0 8f0c9340537b84fcd7012d4a31e6f858e7eb919c (Debug) |
mariadbd: /test/server_dbg/sql/sql_sequence.cc:766: void sequence_definition::adjust_values(longlong): Assertion `(ulonglong) next_free_value % real_increment == (ulonglong) offset' failed.
|
|
11.5.0 8f0c9340537b84fcd7012d4a31e6f858e7eb919c (Debug) |
Core was generated by `/test/MD200324-mariadb-11.5.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14af7815f700 (LWP 535573))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014af8f4f1859 in __GI_abort () at abort.c:79
|
#2 0x000014af8f4f1729 in __assert_fail_base (fmt=0x14af8f687588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5574bc2068b0 "(ulonglong) next_free_value % real_increment == (ulonglong) offset", file=0x5574bc206860 "/test/server_dbg/sql/sql_sequence.cc", line=766, function=<optimized out>) at assert.c:92
|
#3 0x000014af8f502fd6 in __GI___assert_fail (assertion=assertion@entry=0x5574bc2068b0 "(ulonglong) next_free_value % real_increment == (ulonglong) offset", file=file@entry=0x5574bc206860 "/test/server_dbg/sql/sql_sequence.cc", line=line@entry=766, function=function@entry=0x5574bc2068f8 "void sequence_definition::adjust_values(longlong)") at assert.c:101
|
#4 0x00005574bb747673 in sequence_definition::adjust_values (this=this@entry=0x14af3c059680, next_value=<optimized out>) at /test/server_dbg/sql/sql_sequence.cc:766
|
#5 0x00005574bb747b0c in SEQUENCE::read_stored_values (this=this@entry=0x14af3c059680, table=0x5574bed78ad8) at /test/server_dbg/sql/sql_sequence.cc:713
|
#6 0x00005574bb747c6f in SEQUENCE::read_initial_values (this=0x14af3c059680, table=<optimized out>) at /test/server_dbg/sql/sql_sequence.cc:666
|
#7 0x00005574bbb2fb13 in ha_sequence::open (this=0x14af3c05a070, name=<optimized out>, mode=<optimized out>, flags=18) at /test/server_dbg/sql/ha_sequence.cc:122
|
#8 0x00005574bb802111 in handler::ha_open (this=0x14af3c05a070, table_arg=table_arg@entry=0x5574bed78ad8, name=0x14af3c059498 "./test/s", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/server_dbg/sql/handler.cc:3517
|
#9 0x00005574bb604284 in open_table_from_share (thd=thd@entry=0x14af3c000d48, share=share@entry=0x14af3c058e10, alias=alias@entry=0x14af3c01af60, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=0x5574bed78ad8, is_create_table=false, partitions_to_open=0x0) at /test/server_dbg/sql/table.cc:4597
|
#10 0x00005574bb42c907 in open_table (thd=thd@entry=0x14af3c000d48, table_list=table_list@entry=0x14af3c01af18, ot_ctx=ot_ctx@entry=0x14af7815da70) at /test/server_dbg/sql/sql_base.cc:2233
|
#11 0x00005574bb430854 in open_and_process_table (ot_ctx=0x14af7815da70, has_prelocking_list=false, prelocking_strategy=0x14af3c01b848, flags=0, counter=0x14af3c01b828, tables=0x14af3c01af18, thd=0x14af3c000d48) at /test/server_dbg/sql/sql_base.cc:4166
|
#12 open_tables (thd=thd@entry=0x14af3c000d48, options=@0x14af3c0067b0: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x14af7815daf8, counter=counter@entry=0x14af3c01b828, flags=0, prelocking_strategy=prelocking_strategy@entry=0x14af3c01b848) at /test/server_dbg/sql/sql_base.cc:4652
|
#13 0x00005574bb431bd9 in open_tables (prelocking_strategy=0x14af3c01b848, flags=<optimized out>, counter=0x14af3c01b828, tables=0x14af7815daf8, thd=0x14af3c000d48) at /test/server_dbg/sql/sql_base.h:271
|
#14 open_tables_for_query (thd=thd@entry=0x14af3c000d48, tables=<optimized out>, table_count=table_count@entry=0x14af3c01b828, flags=flags@entry=0, prelocking_strategy=0x14af3c01b848) at /test/server_dbg/sql/sql_base.cc:5766
|
#15 0x00005574bb502272 in Sql_cmd_dml::prepare (this=0x14af3c01b810, thd=0x14af3c000d48) at /test/server_dbg/sql/sql_select.cc:33490
|
#16 0x00005574bb5046cf in Sql_cmd_dml::execute (this=0x14af3c01b810, thd=0x14af3c000d48) at /test/server_dbg/sql/sql_select.cc:33552
|
#17 0x00005574bb4bde6f in mysql_execute_command (thd=thd@entry=0x14af3c000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/server_dbg/sql/sql_parse.cc:4396
|
#18 0x00005574bb4ad8a6 in mysql_parse (thd=thd@entry=0x14af3c000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14af7815e270) at /test/server_dbg/sql/sql_parse.cc:7821
|
#19 0x00005574bb4c4b61 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14af3c000d48, packet=packet@entry=0x14af3c00b229 "UPDATE s SET a=1", packet_length=packet_length@entry=16, blocking=blocking@entry=true) at /test/server_dbg/sql/sql_class.h:1636
|
#20 0x00005574bb4c75d9 in do_command (thd=0x14af3c000d48, blocking=blocking@entry=true) at /test/server_dbg/sql/sql_parse.cc:1405
|
#21 0x00005574bb64c545 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5574bedbbb68, put_in_cache=put_in_cache@entry=true) at /test/server_dbg/sql/sql_connect.cc:1447
|
#22 0x00005574bb64cafa in handle_one_connection (arg=arg@entry=0x5574bedbbb68) at /test/server_dbg/sql/sql_connect.cc:1349
|
#23 0x00005574bbacdc58 in pfs_spawn_thread (arg=0x5574bed2c868) at /test/server_dbg/storage/perfschema/pfs.cc:2201
|
#24 0x000014af8fa02609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#25 0x000014af8f5ee133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 11.5.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.33 (opt), 10.4.34 (opt), 10.5.25 (dbg), 10.5.25 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt), 11.1.4 (dbg), 11.1.4 (opt), 11.2.4 (dbg), 11.2.4 (opt), 11.3.2 (dbg), 11.3.2 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.0 (opt)
Attachments
Issue Links
- is caused by
-
MDEV-28152 Features for sequence
-
- Closed
-
Activity
As expected, it is caused by MDEV-28152 as it introduced unsigned bigint as a sequence value data type.
Hi sanja, ptal thanks:
0db973b5a7e bb-11.5-mdev-33836 MDEV-33836 Compute modulus correctly in sequence
|
a5ad69c915c MDEV-33836 Fix version markers in tests relating to MDEV-28152
|
thanks for the review - pushed the following to 11.5
8b8c8fcb864 upstream/bb-11.5-mdev-33836 upstream/11.5 MDEV-33836 Compute modulus correctly in sequence
|
26034534365 MDEV-33836 Fix version markers in tests relating to MDEV-28152
|
Reduced test case with slightly different stack
Leads to:
11.6.0 25b5c63905682a0e38d8ed86170d98be6ddb8cf8 (Debug)
mariadbd: /test/11.6_dbg/sql/sql_sequence.cc:781: void sequence_definition::adjust_values(longlong): Assertion `(ulonglong) next_free_value % real_increment == (ulonglong) offset' failed.11.6.0 25b5c63905682a0e38d8ed86170d98be6ddb8cf8 (Debug)
Core was generated by `/test/MD290724-mariadb-11.6.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.Program terminated with signal SIGABRT, Aborted.#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50[Current thread is 1 (Thread 0x14aef8142700 (LWP 1970859))](gdb) bt#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50#1 0x000014af0dce9859 in __GI_abort () at abort.c:79#2 0x000014af0dce9729 in __assert_fail_base (fmt=0x14af0de7f588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bffc637d40 "(ulonglong) next_free_value % real_increment == (ulonglong) offset", file=0x55bffc637cf0 "/test/11.6_dbg/sql/sql_sequence.cc", line=781, function=<optimized out>) at assert.c:92#3 0x000014af0dcfafd6 in __GI___assert_fail (assertion=assertion@entry=0x55bffc637d40 "(ulonglong) next_free_value % real_increment == (ulonglong) offset", file=file@entry=0x55bffc637cf0 "/test/11.6_dbg/sql/sql_sequence.cc", line=line@entry=781, function=function@entry=0x55bffc637d88 "void sequence_definition::adjust_values(longlong)") at assert.c:101#4 0x000055bffbb17544 in sequence_definition::adjust_values (this=this@entry=0x14aebc015250, next_value=next_value@entry=-6101065172474983725) at /test/11.6_dbg/sql/sql_sequence.cc:781#5 0x000055bffbb19dbf in SEQUENCE::set_value (this=0x14aebc015250, table=0x14aebc02db28, next_val=-6101065172474983725, next_val@entry=-6101065172474983726, next_round=0, is_used=<optimized out>) at /test/11.6_dbg/sql/sql_sequence.cc:1045#6 0x000055bffbc6196a in Item_func_setval::val_int (this=0x14aebc01b588) at /test/11.6_dbg/sql/item_func.cc:7212#7 0x000055bffbaf6825 in Type_handler::Item_send_longlong (this=<optimized out>, item=0x14aebc01b588, protocol=0x14aebc001360, buf=<optimized out>) at /test/11.6_dbg/sql/sql_type.cc:7711#8 0x000055bffbafeb25 in Type_handler_longlong::Item_send (this=<optimized out>, item=<optimized out>, protocol=<optimized out>, buf=<optimized out>) at /test/11.6_dbg/sql/sql_type.h:6059#9 0x000055bffb74b268 in Item::send (this=0x14aebc01b588, protocol=0x14aebc001360, buffer=0x14aef813fe40) at /test/11.6_dbg/sql/item.h:1254#10 0x000055bffb784467 in Protocol::send_result_set_row (this=this@entry=0x14aebc001360, row_items=row_items@entry=0x14aebc01ac10) at /test/11.6_dbg/sql/protocol.cc:1359#11 0x000055bffb80925d in select_send::send_data (this=0x14aebc01bff0, items=@0x14aebc01ac10: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aebc01b668, last = 0x14aebc01b668, elements = 1}, <No data fields>}) at /test/11.6_dbg/sql/sql_class.cc:3216#12 0x000055bffb9222eb in select_result_sink::send_data_with_check (sent=0, u=<optimized out>, items=<optimized out>, this=<optimized out>) at /test/11.6_dbg/sql/sql_class.h:6154#13 JOIN::exec_inner (this=this@entry=0x14aebc01c018) at /test/11.6_dbg/sql/sql_select.cc:4892#14 0x000055bffb923246 in JOIN::exec (this=this@entry=0x14aebc01c018) at /test/11.6_dbg/sql/sql_select.cc:4804#15 0x000055bffb921070 in mysql_select (thd=thd@entry=0x14aebc000d48, tables=0x0, fields=@0x14aebc01ac10: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aebc01b668, last = 0x14aebc01b668, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x14aebc01bff0, unit=0x14aebc005238, select_lex=0x14aebc01a958) at /test/11.6_dbg/sql/sql_select.cc:5337#16 0x000055bffb921899 in handle_select (thd=thd@entry=0x14aebc000d48, lex=lex@entry=0x14aebc005158, result=result@entry=0x14aebc01bff0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/11.6_dbg/sql/sql_select.cc:628#17 0x000055bffb87d152 in execute_sqlcom_select (thd=thd@entry=0x14aebc000d48, all_tables=0x14aebc01ae78) at /test/11.6_dbg/sql/sql_parse.cc:6147#18 0x000055bffb88584a in mysql_execute_command (thd=thd@entry=0x14aebc000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.6_dbg/sql/sql_parse.cc:3954#19 0x000055bffb8762dc in mysql_parse (thd=thd@entry=0x14aebc000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14aef8141270) at /test/11.6_dbg/sql/sql_parse.cc:7867#20 0x000055bffb88d753 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14aebc000d48, packet=packet@entry=0x14aebc00b239 "", packet_length=packet_length@entry=38, blocking=blocking@entry=true) at /test/11.6_dbg/sql/sql_class.h:1638#21 0x000055bffb890256 in do_command (thd=0x14aebc000d48, blocking=blocking@entry=true) at /test/11.6_dbg/sql/sql_parse.cc:1405#22 0x000055bffba19741 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55bfff25c2b8, put_in_cache=put_in_cache@entry=true) at /test/11.6_dbg/sql/sql_connect.cc:1448#23 0x000055bffba19d02 in handle_one_connection (arg=arg@entry=0x55bfff25c2b8) at /test/11.6_dbg/sql/sql_connect.cc:1350#24 0x000055bffbea2970 in pfs_spawn_thread (arg=0x55bfff1aed28) at /test/11.6_dbg/storage/perfschema/pfs.cc:2198#25 0x000014af0e1fa609 in start_thread (arg=<optimized out>) at pthread_create.c:477#26 0x000014af0dde6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95Bug confirmed present in:
MariaDB: 11.5.2 (dbg), 11.6.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.5.26 (dbg), 10.5.26 (opt), 10.6.19 (dbg), 10.6.19 (opt), 10.11.9 (dbg), 10.11.9 (opt), 11.1.6 (dbg), 11.1.6 (opt), 11.2.5 (dbg), 11.2.5 (opt), 11.4.3 (dbg), 11.4.3 (opt), 11.5.2 (opt), 11.6.0 (opt)