Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5
Description
Note: It might be related to, or a duplicate of, MDEV-15800 or/and MDEV-17333, and might even have nothing to do with versioning, I can't tell for sure. The stack trace is different from both bugs, so I'm filing it separately.
CREATE OR REPLACE TABLE t1 (f TINYINT AUTO_INCREMENT NULL, s TIMESTAMP, e TIMESTAMP, PERIOD FOR app(s,e), KEY (f,s)); |
INSERT INTO t1 (s,e) VALUES |
('2021-08-22 10:28:43','2023-09-17 00:00:00'), |
('2019-05-09 21:45:24','2020-04-22 14:38:49'); |
INSERT INTO t1 (s,e) SELECT s,e FROM t1; |
INSERT INTO t1 (s,e) SELECT s,e FROM t1; |
INSERT INTO t1 (s,e) SELECT s,e FROM t1; |
INSERT INTO t1 (s,e) VALUES ('2015-07-07 00:00:00','2020-03-11 08:48:52'); |
INSERT INTO t1 (s,e) SELECT s,e FROM t1; |
INSERT INTO t1 (s,e) SELECT s,e FROM t1; |
--error 167
|
INSERT INTO t1 SELECT * FROM t1; |
DELETE IGNORE FROM t1 FOR PORTION OF app FROM '2015-07-07 00:00:00' TO '2020-03-11 08:48:52'; |
 |
# Cleanup
|
DROP TABLE t1; |
10.4 17cbae65 |
mysqld: /data/src/10.4/sql/handler.cc:3438: int handler::update_auto_increment(): Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed.
|
190402 0:32:05 [ERROR] mysqld got signal 6 ;
|
 |
#7 0x00007f1a8fa08ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055bf78eecfa0 in handler::update_auto_increment (this=0x7f1a78129508) at /data/src/10.4/sql/handler.cc:3438
|
#9 0x000055bf78cce058 in TABLE::update_generated_fields (this=0x7f1a781286a0) at /data/src/10.4/sql/table.cc:8307
|
#10 0x000055bf78cce1ad in TABLE::period_make_insert (this=0x7f1a781286a0, src=0x7f1a78015ef0, dst=0x7f1a78126950) at /data/src/10.4/sql/table.cc:8327
|
#11 0x000055bf78cce463 in TABLE::insert_portion_of_time (this=0x7f1a781286a0, thd=0x7f1a78000b00, period_conds=..., rows_inserted=0x7f1a89b80d90) at /data/src/10.4/sql/table.cc:8364
|
#12 0x000055bf7909dbed in mysql_delete (thd=0x7f1a78000b00, table_list=0x7f1a78015740, conds=0x7f1a78016b98, order_list=0x7f1a78005490, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:849
|
#13 0x000055bf78ba36f4 in mysql_execute_command (thd=0x7f1a78000b00) at /data/src/10.4/sql/sql_parse.cc:4985
|
#14 0x000055bf78bae642 in mysql_parse (thd=0x7f1a78000b00, rawbuf=0x7f1a780155d8 "DELETE IGNORE FROM t1 FOR PORTION OF app FROM '2015-07-07 00:00:00' TO '2020-03-11 08:48:52'", length=92, parser_state=0x7f1a89b82180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8154
|
#15 0x000055bf78b99dd2 in dispatch_command (command=COM_QUERY, thd=0x7f1a78000b00, packet=0x7f1a78139251 "DELETE IGNORE FROM t1 FOR PORTION OF app FROM '2015-07-07 00:00:00' TO '2020-03-11 08:48:52'", packet_length=92, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1832
|
#16 0x000055bf78b985b8 in do_command (thd=0x7f1a78000b00) at /data/src/10.4/sql/sql_parse.cc:1365
|
#17 0x000055bf78d123d5 in do_handle_one_connection (connect=0x55bf7c4294e0) at /data/src/10.4/sql/sql_connect.cc:1398
|
#18 0x000055bf78d12146 in handle_one_connection (arg=0x55bf7c4294e0) at /data/src/10.4/sql/sql_connect.cc:1301
|
#19 0x000055bf79207e6f in pfs_spawn_thread (arg=0x55bf7c51b8b0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#20 0x00007f1a918f7494 in start_thread (arg=0x7f1a89b83700) at pthread_create.c:333
|
#21 0x00007f1a8fac593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible with at least MyISAM and InnoDB.
No obvious problem on a non-debug build.
The test case is not applicable to previous versions.
Attachments
Issue Links
- relates to
-
MDEV-21986 Unexpected error 3 "No such process" from storage engine upon DELETE ... FOR PORTION
- Open
-
MDEV-22414 UPDATE or DELETE FOR PORTION OF increments the value of auto-increment column instead of copying the old one
- Closed
-
MDEV-15800 Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed in update_auto_increment() or unexpected ER_LOCK_DEADLOCK upon LOAD or INSERT
- Closed
-
MDEV-17333 Assertion in update_auto_increment() upon exotic LOAD
- Closed