Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4(EOL)
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 ( |
pk INT AUTO_INCREMENT, |
a INT, |
b BINARY(100), |
c INT AS (a) VIRTUAL, |
d BINARY(100) AS (b) VIRTUAL, |
e INT, |
f INT, |
row_start BIGINT UNSIGNED AS ROW START, |
row_end BIGINT UNSIGNED AS ROW END, |
PRIMARY KEY(pk), |
KEY(b(64)), |
PERIOD FOR SYSTEM_TIME(row_start,row_end) |
) ENGINE=InnoDB WITH SYSTEM VERSIONING; |
|
INSERT INTO t1 () VALUES (),(); |
|
SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t1 DROP f; |
INSERT INTO t1 () VALUES (); |
|
# Cleanup
|
DROP TABLE t1; |
10.4 8a931e4d |
mysqld: /data/src/10.4/storage/innobase/row/row0mysql.cc:1423: dberr_t row_insert_for_mysql(const byte*, row_prebuilt_t*, ins_mode_t): Assertion `table->vers_start != table->vers_end' failed.
|
200127 14:06:44 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f8d3ec9bf12 in __GI___assert_fail (assertion=0x559e904d0ae0 "table->vers_start != table->vers_end", file=0x559e904cfef8 "/data/src/10.4/storage/innobase/row/row0mysql.cc", line=1423, function=0x559e904d4120 <row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t)::__PRETTY_FUNCTION__> "dberr_t row_insert_for_mysql(const byte*, row_prebuilt_t*, ins_mode_t)") at assert.c:101
|
#8 0x0000559e8fc9301f in row_insert_for_mysql (mysql_rec=0x7f8cf01a15b0 "\377\003", prebuilt=0x7f8cf0189e18, ins_mode=ROW_INS_VERSIONED) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1423
|
#9 0x0000559e8faed768 in ha_innobase::write_row (this=0x7f8cf019dfd8, record=0x7f8cf01a15b0 "\377\003") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8035
|
#10 0x0000559e8f8b0fc4 in handler::ha_write_row (this=0x7f8cf019dfd8, buf=0x7f8cf01a15b0 "\377\003") at /data/src/10.4/sql/handler.cc:6675
|
#11 0x0000559e8f4f6c3c in write_record (thd=0x7f8cf0000af0, table=0x7f8cf01a7110, info=0x7f8d3806b490) at /data/src/10.4/sql/sql_insert.cc:2056
|
#12 0x0000559e8f4f3ba7 in mysql_insert (thd=0x7f8cf0000af0, table_list=0x7f8cf0013280, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1078
|
#13 0x0000559e8f5420d3 in mysql_execute_command (thd=0x7f8cf0000af0) at /data/src/10.4/sql/sql_parse.cc:4529
|
#14 0x0000559e8f54e85d in mysql_parse (thd=0x7f8cf0000af0, rawbuf=0x7f8cf0013198 "INSERT INTO t1 () VALUES ()", length=27, parser_state=0x7f8d3806c160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
|
#15 0x0000559e8f539a2a in dispatch_command (command=COM_QUERY, thd=0x7f8cf0000af0, packet=0x7f8cf01376f1 "INSERT INTO t1 () VALUES ()", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
|
#16 0x0000559e8f5380b7 in do_command (thd=0x7f8cf0000af0) at /data/src/10.4/sql/sql_parse.cc:1360
|
#17 0x0000559e8f6c10df in do_handle_one_connection (connect=0x559e9239bf60) at /data/src/10.4/sql/sql_connect.cc:1412
|
#18 0x0000559e8f6c0e2e in handle_one_connection (arg=0x559e9239bf60) at /data/src/10.4/sql/sql_connect.cc:1316
|
#19 0x0000559e900c93cd in pfs_spawn_thread (arg=0x559e923a4070) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#20 0x00007f8d40c244a4 in start_thread (arg=0x7f8d3806d700) at pthread_create.c:456
|
#21 0x00007f8d3ed58d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Reproducible on 10.4-10.5.
Not reproducible on 10.3.
No obvious effect on a non-debug build.
Attachments
Issue Links
- relates to
-
MDEV-16226 TRX_ID-based System Versioning refactoring
- Stalled