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

Assertion `max_autoinc <= max' failed in uint64_t btr_read_autoinc_with_fallback(const dict_table_t *, unsigned int, ulong, uint64_t)

    XMLWordPrintable

Details

    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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              ramesh Ramesh Sivaraman
              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.