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

Assertion `!auto_increment_field_not_null' failed in TABLE::init

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 AS SELECT 1 AS a;
      CREATE TEMPORARY TABLE tmp (b INT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MyISAM;
      INSERT INTO tmp VALUES (1);
      ALTER TABLE tmp FORCE;
      --error ER_WARN_DATA_OUT_OF_RANGE
      UPDATE tmp, t1 SET b = -1;
      INSERT INTO tmp () VALUES ();
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 900a1475

      mysqld: /data/src/10.2/sql/table.cc:4654: void TABLE::init(THD*, TABLE_LIST*): Assertion `!auto_increment_field_not_null' failed.
      210127 16:19:26 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f4566b4cf36 in __GI___assert_fail (assertion=0x56025af04b20 "!auto_increment_field_not_null", file=0x56025af035c6 "/data/src/10.2/sql/table.cc", line=4654, function=0x56025af04ac0 "void TABLE::init(THD*, TABLE_LIST*)") at assert.c:101
      #8  0x000056025a585dd8 in TABLE::init (this=0x7f455018e0d0, thd=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/table.cc:4654
      #9  0x000056025a673504 in THD::open_temporary_table (this=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/temporary_tables.cc:425
      #10 0x000056025a673608 in THD::open_temporary_tables (this=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/temporary_tables.cc:462
      #11 0x000056025a4778b9 in mysql_execute_command (thd=0x7f4550000d90) at /data/src/10.2/sql/sql_parse.cc:4185
      #12 0x000056025a48303f in mysql_parse (thd=0x7f4550000d90, rawbuf=0x7f45500126f8 "INSERT INTO tmp () VALUES ()", length=28, parser_state=0x7f4560ca65f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7763
      #13 0x000056025a471318 in dispatch_command (command=COM_QUERY, thd=0x7f4550000d90, packet=0x7f4550008b51 "INSERT INTO tmp () VALUES ()", packet_length=28, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
      #14 0x000056025a46fe13 in do_command (thd=0x7f4550000d90) at /data/src/10.2/sql/sql_parse.cc:1381
      #15 0x000056025a5ca72e in do_handle_one_connection (connect=0x56025cad39c0) at /data/src/10.2/sql/sql_connect.cc:1336
      #16 0x000056025a5ca493 in handle_one_connection (arg=0x56025cad39c0) at /data/src/10.2/sql/sql_connect.cc:1241
      #17 0x000056025adf29ec in pfs_spawn_thread (arg=0x56025cab6dd0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
      #18 0x00007f456705c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x00007f4566c38293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.2-10.6.
      No obvious immediate problem on a non-debug build.

      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.