Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.0
Description
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
SET SQL_MODE=''; |
CREATE TABLE t1 (a DOUBLE KEY AUTO_INCREMENT) ENGINE=INNODB ; |
INSERT INTO t1 VALUES (99999999999999999999); |
FLUSH TABLES;
|
CREATE TABLE t2 (id INT,KEY(id)) ENGINE=INNODB PARTITION BY HASH (id) PARTITIONS 600; |
SELECT * FROM information_schema.tables; |
Leads to:
CS 12.0.1 00a9afb5818433c26537ccaf6b2c59ad493dd473 (Debug) Build 13/05/2025 |
mariadbd: /test/12.0_dbg/storage/innobase/btr/btr0btr.cc:1239: uint64_t btr_read_autoinc_with_fallback(const dict_table_t *, unsigned int, ulong, uint64_t): Assertion `max_autoinc <= max' failed.
|
CS 12.0.1 00a9afb5818433c26537ccaf6b2c59ad493dd473 (Debug) Build 13/05/2025 |
Core was generated by `/test/MD130525-mariadb-12.0.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (LWP 40026)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
#3 0x00007db37be4527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
#4 0x00007db37be288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007db37be2881b in __assert_fail_base (fmt=0x7db37bfd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5edcbf3eec21 "max_autoinc <= max", file=file@entry=0x5edcbf3ee5ef "/test/12.0_dbg/storage/innobase/btr/btr0btr.cc", line=line@entry=1239, function=function@entry=0x5edcbf3eebc4 "uint64_t btr_read_autoinc_with_fallback(const dict_table_t *, unsigned int, ulong, uint64_t)") at ./assert/assert.c:96
|
#6 0x00007db37be3b517 in __assert_fail (assertion=0x5edcbf3eec21 "max_autoinc <= max", file=0x5edcbf3ee5ef "/test/12.0_dbg/storage/innobase/btr/btr0btr.cc", line=1239, function=0x5edcbf3eebc4 "uint64_t btr_read_autoinc_with_fallback(const dict_table_t *, unsigned int, ulong, uint64_t)") at ./assert/assert.c:105
|
#7 0x00005edcbed82785 in btr_read_autoinc_with_fallback (table=0x7da0288d2e68, col_no=0, mysql_version=120001, max=9007199254740992) at /test/12.0_dbg/storage/innobase/btr/btr0btr.cc:1239
|
#8 0x00005edcbea96978 in initialize_auto_increment (table=0x7da0288d2e68, field=..., s=...) at /test/12.0_dbg/storage/innobase/handler/ha_innodb.cc:5745
|
#9 0x00005edcbea951f6 in ha_innobase::open (this=0x7da0288d0e28, name=0x7da0288ce050 "./test/t1") at /test/12.0_dbg/storage/innobase/handler/ha_innodb.cc:6069
|
#10 0x00005edcbe6a6904 in handler::ha_open (this=0x7da0288d0e28, table_arg=0x7da0288d09d8, name=0x7da0288ce050 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0) at /test/12.0_dbg/sql/handler.cc:3633
|
#11 0x00005edcbe3ffd59 in open_table_from_share (thd=0x7da028000d58, share=0x7da0288cd9b0, alias=0x7da0280958f8, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7da0288d09d8, is_create_table=false, partitions_to_open=0x0) at /test/12.0_dbg/sql/table.cc:4669
|
#12 0x00005edcbe1a8d5c in open_table (thd=0x7da028000d58, table_list=0x7da0280958b0, ot_ctx=0x7db37421f8c8) at /test/12.0_dbg/sql/sql_base.cc:2262
|
#13 0x00005edcbe1ae72d in open_and_process_table (thd=0x7da028000d58, tables=0x7da0280958b0, counter=0x7db37421f9e4, flags=1090, prelocking_strategy=0x7db37421f9e8, has_prelocking_list=false, ot_ctx=0x7db37421f8c8) at /test/12.0_dbg/sql/sql_base.cc:4200
|
#14 0x00005edcbe1ad304 in open_tables (thd=0x7da028000d58, options=..., start=0x7db37421f9f8, counter=0x7db37421f9e4, flags=1090, prelocking_strategy=0x7db37421f9e8) at /test/12.0_dbg/sql/sql_base.cc:4686
|
#15 0x00005edcbe1b0a8a in open_tables (thd=0x7da028000d58, tables=0x7db37421f9f8, counter=0x7db37421f9e4, flags=1090, prelocking_strategy=0x7db37421f9e8) at /test/12.0_dbg/sql/sql_base.h:275
|
#16 0x00005edcbe1b0864 in open_normal_and_derived_tables (thd=0x7da028000d58, tables=0x7da0280958b0, flags=1090, dt_phases=3) at /test/12.0_dbg/sql/sql_base.cc:5723
|
#17 0x00005edcbe1b0b19 in open_tables_only_view_structure (thd=0x7da028000d58, table_list=0x7da0280958b0, can_deadlock=false) at /test/12.0_dbg/sql/sql_base.cc:5774
|
#18 0x00005edcbe35b0e4 in fill_schema_table_by_open (thd=0x7da028000d58, mem_root=0x7db374221bf0, is_show_fields_or_keys=false, table=0x7da028285aa0, schema_table=0x5edcbfc5c638 <schema_tables+2952>, orig_db_name=0x7da02801e368, orig_table_name=0x7da02801e398, open_tables_state_backup=0x7db374221c50, can_deadlock=false) at /test/12.0_dbg/sql/sql_show.cc:4886
|
#19 0x00005edcbe35ab02 in get_all_tables (thd=0x7da028000d58, tables=0x7da028017260, cond=0x0) at /test/12.0_dbg/sql/sql_show.cc:5681
|
#20 0x00005edcbe3678fa in get_schema_tables_result (join=0x7da028018e70, executed_place=PROCESSED_BY_JOIN_EXEC) at /test/12.0_dbg/sql/sql_show.cc:9738
|
#21 0x00005edcbe30123a in JOIN::exec_inner (this=0x7da028018e70) at /test/12.0_dbg/sql/sql_select.cc:5035
|
#22 0x00005edcbe30043e in JOIN::exec (this=0x7da028018e70) at /test/12.0_dbg/sql/sql_select.cc:4857
|
#23 0x00005edcbe2db2cd in mysql_select (thd=0x7da028000d58, tables=0x7da028017260, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x7da028018e48, unit=0x7da028005148, select_lex=0x7da028016c08) at /test/12.0_dbg/sql/sql_select.cc:5390
|
#24 0x00005edcbe2dad55 in handle_select (thd=0x7da028000d58, lex=0x7da028005068, result=0x7da028018e48, setup_tables_done_option=0) at /test/12.0_dbg/sql/sql_select.cc:634
|
#25 0x00005edcbe282a61 in execute_sqlcom_select (thd=0x7da028000d58, all_tables=0x7da028017260) at /test/12.0_dbg/sql/sql_parse.cc:6166
|
#26 0x00005edcbe2778ae in mysql_execute_command (thd=0x7da028000d58, is_called_from_prepared_stmt=false) at /test/12.0_dbg/sql/sql_parse.cc:3954
|
#27 0x00005edcbe26fb34 in mysql_parse (thd=0x7da028000d58, rawbuf=0x7da028016b60 "SELECT * FROM information_schema.tables", length=39, parser_state=0x7db374224a10) at /test/12.0_dbg/sql/sql_parse.cc:7891
|
#28 0x00005edcbe26cf08 in dispatch_command (command=COM_QUERY, thd=0x7da028000d58, packet=0x7da0281c9369 "SELECT * FROM information_schema.tables", packet_length=39, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1877
|
#29 0x00005edcbe2706e3 in do_command (thd=0x7da028000d58, blocking=true) at /test/12.0_dbg/sql/sql_parse.cc:1416
|
#30 0x00005edcbe45bbd9 in do_handle_one_connection (connect=0x5edcec119bb8, put_in_cache=true) at /test/12.0_dbg/sql/sql_connect.cc:1414
|
#31 0x00005edcbe45b97e in handle_one_connection (arg=0x5edcec10ed48) at /test/12.0_dbg/sql/sql_connect.cc:1326
|
#32 0x00007db37be9caa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
#33 0x00007db37bf29c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.5 dbg 280425 c461188ca6ad6ec3a54201eb87ebd75797d296df No bug found
|
CS 10.5 opt 280425 c461188ca6ad6ec3a54201eb87ebd75797d296df No bug found
|
CS 10.6 dbg 280425 19644f6821d59ecca0f9b1f44fadb3b887061965 max_autoinc <= max|SIGABRT|btr_read_autoinc_with_fallback|initialize_auto_increment|ha_innobase::open|handler::ha_open
|
CS 10.6 opt 280425 19644f6821d59ecca0f9b1f44fadb3b887061965 No bug found
|
CS 10.11 dbg 280425 4d41ec081e34671a1997ce797dcb9f7b7997437e max_autoinc <= max|SIGABRT|btr_read_autoinc_with_fallback|initialize_auto_increment|ha_innobase::open|handler::ha_open
|
CS 10.11 opt 280425 4d41ec081e34671a1997ce797dcb9f7b7997437e No bug found
|
CS 11.4 dbg 090525 da5a4d05b9da58705498a42b6ffa5d9211f446af max_autoinc <= max|SIGABRT|btr_read_autoinc_with_fallback|initialize_auto_increment|ha_innobase::open|handler::ha_open
|
CS 11.4 opt 090525 da5a4d05b9da58705498a42b6ffa5d9211f446af No bug found
|
CS 11.8 dbg 220425 805e7ca3adef50e17889ea17a1b86da6c3fb8580 max_autoinc <= max|SIGABRT|btr_read_autoinc_with_fallback|initialize_auto_increment|ha_innobase::open|handler::ha_open
|
CS 11.8 opt 220425 805e7ca3adef50e17889ea17a1b86da6c3fb8580 No bug found
|
CS 12.0 dbg 130525 00a9afb5818433c26537ccaf6b2c59ad493dd473 max_autoinc <= max|SIGABRT|btr_read_autoinc_with_fallback|initialize_auto_increment|ha_innobase::open|handler::ha_open
|
CS 12.0 opt 130525 00a9afb5818433c26537ccaf6b2c59ad493dd473 No bug found
|
ES 10.5 dbg 050525 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found
|
ES 10.5 opt 050525 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found
|
ES 10.6 dbg 050525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 10.6 opt 050525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 11.4 dbg 050525 9cd12544ebfd0d52d2158af66b5aced58121cf1f No bug found
|
ES 11.4 opt 050525 9cd12544ebfd0d52d2158af66b5aced58121cf1f No bug found
|
Attachments
Issue Links
- relates to
-
MDEV-36015 UBSAN: runtime error: -1 is outside the range of representable values of type 'unsigned long' on INSERT ... SELECT
-
- Closed
-