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

Assertion `auto_increment_value' failed in ha_partition::info during UPDATE with partition

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
    • N/A
    • Partitioning
    • None

    Description

      Repeatable with Myisam/InnoDB, on 10.4-11.0:

      --source include/have_partition.inc
       
      CREATE TABLE t1 ( a int auto_increment, KEY (a)) partition BY hash (a) partitions 4 ;
      INSERT INTO t1 VALUES (1),(6),(3);
       
      ALTER TABLE t1 ORDER BY a;
      UPDATE  t1 PARTITION (p2) SET a = 2 WHERE a = 6;
      

      mysqld: /10.4/src/sql/ha_partition.cc:8416: virtual int ha_partition::info(uint): Assertion `auto_increment_value' failed.
      230508 14:05:58 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.4.29-MariaDB-debug-log source revision: 84b9fc25a29b94a37eb9d5ac2e2c0f75c0efafda
       
      sql/signal_handler.cc:238(handle_fatal_signal)[0x5642e2b7ba9b]
      sql/ha_partition.cc:8417(ha_partition::info(unsigned int))[0x5642e33c0461]
      sql/ha_partition.cc:10637(ha_partition::update_next_auto_inc_val())[0x5642e33d005f]
      sql/ha_partition.cc:4561(ha_partition::update_row(unsigned char const*, unsigned char const*))[0x5642e339e3f4]
      sql/handler.cc:6891(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x5642e2bb65ff]
      sql/sql_update.cc:1082(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x5642e269f390]
      sql/sql_parse.cc:4439(mysql_execute_command(THD*))[0x5642e23c7d59]
      sql/sql_parse.cc:7998(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5642e23e0d6d]
      sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5642e23b73ac]
      sql/sql_parse.cc:1378(do_command(THD*))[0x5642e23b3ee1]
      sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x5642e27c0439]
      sql/sql_connect.cc:1325(handle_one_connection)[0x5642e27bfcdd]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5642e346373c]
      nptl/pthread_create.c:478(start_thread)[0x7f1cf4df3609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f1cf49c4133]
       
      Query (0x62b0000b6290): UPDATE  t1 PARTITION (p2) SET a = 2 WHERE a = 6
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.