[MDEV-31217] Assertion `auto_increment_value' failed in ha_partition::info during UPDATE with partition Created: 2023-05-08  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Partitioning
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.4, 10.5, 10.6, 10.11

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21007 Assertion `auto_increment_value' fail... Stalled
relates to MDEV-22262 Server crashes in ha_partition::open ... Confirmed

 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



 Comments   
Comment by Yuchen Pei [ 2023-05-08 ]

Possibly a duplication of MDEV-21007

Generated at Thu Feb 08 10:22:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.