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)
-
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
- duplicates
-
MDEV-21007 Assertion `auto_increment_value' failed in ha_partition::info upon UPDATE with partition pruning
- Closed
- relates to
-
MDEV-21007 Assertion `auto_increment_value' failed in ha_partition::info upon UPDATE with partition pruning
- Closed
-
MDEV-22262 Server crashes in ha_partition::open or handler::ha_table_flags upon UPDATE with partition pruning
- Confirmed