mysqld: storage/innobase/trx/trx0sys.cc:62: static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&): Assertion `0' failed.
The problem does not show up on actual
|
10.4 commit 2465d3e00b2f18c7d4967f9bb10438883682787d 2019-01-01
|
|
The problem was found during RQG testing on binaries compiled with ASAN
|
based on bb-10.4-MDEV-15563
|
last commit d96b94d1ab6878bea98f0f6dc005cfd1e2d1f8e5 2019-01-02
|
Disable a badly written test 2019-01-02
|
previous commit b91879bd8fc10344f10dd3e648338c5535de02f4 2018-12-11
|
MDEV-15563 Case 4 prototype: UNSIGNED -> bigger signed
|
|
ts_5.test
|
-------------
|
--source include/have_innodb.inc
|
CREATE TABLE t1 (col1 INT, col_int INTEGER) ENGINE = InnoDB ROW_FORMAT = Redundant ;
|
INSERT INTO t1 (col1, col_int) VALUES ( 0, 0 ) ;
|
ALTER TABLE t1 MODIFY col_int BIGINT ;
|
ALTER TABLE t1 ADD PRIMARY KEY IF NOT EXISTS ( col_int ) , LOCK = EXCLUSIVE, ALGORITHM = INPLACE ;
|
INSERT INTO t1 (col1, col_int) VALUES ( 1, 1 ) ;
|
CHECK TABLE t1;
|
|
SHOW PROCESSLIST;
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
CREATE TABLE t1 (col1 INT, col_int INTEGER) ENGINE = InnoDB ROW_FORMAT = Redundant ;
|
INSERT INTO t1 (col1, col_int) VALUES ( 0, 0 ) ;
|
ALTER TABLE t1 MODIFY col_int BIGINT ;
|
ALTER TABLE t1 ADD PRIMARY KEY IF NOT EXISTS ( col_int ) , LOCK = EXCLUSIVE, ALGORITHM = INPLACE ;
|
INSERT INTO t1 (col1, col_int) VALUES ( 1, 1 ) ;
|
CHECK TABLE t1;
|
main.ts_5 'innodb' [ fail ]
|
Test ended at 2019-01-03 11:44:05
|
|
CURRENT_TEST: main.ts_5
|
mysqltest: At line 8: query 'CHECK TABLE t1' failed: 2013: Lost connection to MySQL server during query
|
...
|
Version: '10.4.2-MariaDB-debug-log' socket: 'bld_asan/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
2019-01-03 11:44:04 9 [Warning] InnoDB: A transaction id in a record of table `test`.`t1` is newer than the system-wide maximum.
|
mysqld: storage/innobase/trx/trx0sys.cc:62: static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&): Assertion `0' failed.
|
190103 11:44:04 [ERROR] mysqld got signal 6 ;
|
...
|
Query (0x62b000000220): CHECK TABLE t1
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
...
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x00007ff83416cf5d in __GI_abort () at abort.c:90
|
#6 0x00007ff834162f17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5653ba59e040 "0", file=file@entry=0x5653ba59dfc0 "storage/innobase/trx/trx0sys.cc", line=line@entry=62, function=function@entry=0x5653ba59f1e0 <ReadView::check_trx_id_sanity(unsigned long, table_name_t const&)::__PRETTY_FUNCTION__> "static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&)") at assert.c:92
|
#7 0x00007ff834162fc2 in __GI___assert_fail (assertion=0x5653ba59e040 "0", file=0x5653ba59dfc0 "storage/innobase/trx/trx0sys.cc", line=62, function=0x5653ba59f1e0 <ReadView::check_trx_id_sanity(unsigned long, table_name_t const&)::__PRETTY_FUNCTION__> "static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&)") at assert.c:101
|
#8 0x00005653b94a4595 in ReadView::check_trx_id_sanity (id=2147483648, name=...) at storage/innobase/trx/trx0sys.cc:62
|
#9 0x00005653b91aa00e in ReadView::changes_visible (this=0x7ff82af0f998, id=2147483648, name=...) at storage/innobase/include/read0types.h:220
|
#10 0x00005653b9180b84 in lock_clust_rec_cons_read_sees (rec=0x7ff82ab9c087 "\200", index=0x61700004a008, offsets=0x7ff81e38dd20, view=0x7ff82af0f998) at storage/innobase/lock/lock0lock.cc:403
|
#11 0x00005653b93c3357 in row_search_mvcc (buf=0x6290002e4200 '\276' <repeats 200 times>..., mode=PAGE_CUR_G, prebuilt=0x620000014108, match_mode=0, direction=0) at storage/innobase/row/row0sel.cc:5111
|
#12 0x00005653b93344b0 in row_search_for_mysql (buf=0x6290002e4200 '\276' <repeats 200 times>..., mode=PAGE_CUR_G, prebuilt=0x620000014108, match_mode=0, direction=0) at storage/innobase/include/row0sel.ic:137
|
#13 0x00005653b934ff42 in row_scan_index_for_mysql (prebuilt=0x620000014108, index=0x61700004a008, n_rows=0x7ff81e38f5d0) at storage/innobase/row/row0mysql.cc:4721
|
#14 0x00005653b9063b36 in ha_innobase::check (this=0x61c0000660a0, thd=0x62a0000de208, check_opt=0x62a0000e3260) at storage/innobase/handler/ha_innodb.cc:14549
|
#15 0x00005653b8b01cc4 in handler::ha_check (this=0x61c0000660a0, thd=0x62a0000de208, check_opt=0x62a0000e3260) at sql/handler.cc:4235
|
#16 0x00005653b875ab2a in mysql_admin_table (thd=0x62a0000de208, tables=0x62b0000002d8, check_opt=0x62a0000e3260, operator_name=0x5653ba0d0a40 "check", lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5653b8b0187a <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x5653b864c7de <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>) at sql/sql_admin.cc:803
|
#17 0x00005653b875fc2c in Sql_cmd_check_table::execute (this=0x62b000000918, thd=0x62a0000de208) at sql/sql_admin.cc:1347
|
#18 0x00005653b83aed62 in mysql_execute_command (thd=0x62a0000de208) at sql/sql_parse.cc:6302
|
#19 0x00005653b83ba63f in mysql_parse (thd=0x62a0000de208, rawbuf=0x62b000000220 "CHECK TABLE t1", length=14, parser_state=0x7ff81e392dd0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8104
|
#20 0x00005653b8391a50 in dispatch_command (command=COM_QUERY, thd=0x62a0000de208, packet=0x629000271209 "", packet_length=14, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1850
|
#21 0x00005653b838e67c in do_command (thd=0x62a0000de208) at sql/sql_parse.cc:1395
|
#22 0x00005653b87313d9 in do_handle_one_connection (connect=0x6080000010a8) at sql/sql_connect.cc:1402
|
#23 0x00005653b8730ccb in handle_one_connection (arg=0x6080000010a8) at sql/sql_connect.cc:1308
|
#24 0x00005653b9c18aa4 in pfs_spawn_thread (arg=0x615000004908) at storage/perfschema/pfs.cc:1862
|
#25 0x00007ff834e0e7fc in start_thread (arg=0x7ff81e394700) at pthread_create.c:465
|
|
{"report":{"fcp":1503.6999998092651,"ttfb":319.6000003814697,"pageVisibility":"visible","entityId":71646,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b341e4a3-ed6e-4e2c-a7ea-06ac278523ee","navigationType":0,"readyForUser":1676.5,"redirectCount":0,"resourceLoadedEnd":2020.3000001907349,"resourceLoadedStart":327.19999980926514,"resourceTiming":[{"duration":648.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":327.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":327.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":975.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":648.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":327.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":327.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":975.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":656,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":327.69999980926514,"connectEnd":327.69999980926514,"connectStart":327.69999980926514,"domainLookupEnd":327.69999980926514,"domainLookupStart":327.69999980926514,"fetchStart":327.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":327.69999980926514,"responseEnd":983.6999998092651,"responseStart":983.6999998092651,"secureConnectionStart":327.69999980926514},{"duration":731.2000007629395,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":327.8999996185303,"connectEnd":327.8999996185303,"connectStart":327.8999996185303,"domainLookupEnd":327.8999996185303,"domainLookupStart":327.8999996185303,"fetchStart":327.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":327.8999996185303,"responseEnd":1059.1000003814697,"responseStart":1059.1000003814697,"secureConnectionStart":327.8999996185303},{"duration":734.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":328.19999980926514,"connectEnd":328.19999980926514,"connectStart":328.19999980926514,"domainLookupEnd":328.19999980926514,"domainLookupStart":328.19999980926514,"fetchStart":328.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":328.19999980926514,"responseEnd":1063,"responseStart":1063,"secureConnectionStart":328.19999980926514},{"duration":735.2000007629395,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":328.3999996185303,"connectEnd":328.3999996185303,"connectStart":328.3999996185303,"domainLookupEnd":328.3999996185303,"domainLookupStart":328.3999996185303,"fetchStart":328.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":328.3999996185303,"responseEnd":1063.6000003814697,"responseStart":1063.6000003814697,"secureConnectionStart":328.3999996185303},{"duration":735.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":328.6000003814697,"connectEnd":328.6000003814697,"connectStart":328.6000003814697,"domainLookupEnd":328.6000003814697,"domainLookupStart":328.6000003814697,"fetchStart":328.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":328.6000003814697,"responseEnd":1064,"responseStart":1064,"secureConnectionStart":328.6000003814697},{"duration":815.5999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":328.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":328.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1144.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":735.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":328.8999996185303,"connectEnd":328.8999996185303,"connectStart":328.8999996185303,"domainLookupEnd":328.8999996185303,"domainLookupStart":328.8999996185303,"fetchStart":328.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":328.8999996185303,"responseEnd":1064.3999996185303,"responseStart":1064.3999996185303,"secureConnectionStart":328.8999996185303},{"duration":815.3999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":329.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":329.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1144.5,"responseStart":0,"secureConnectionStart":0},{"duration":735.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":329.19999980926514,"connectEnd":329.19999980926514,"connectStart":329.19999980926514,"domainLookupEnd":329.19999980926514,"domainLookupStart":329.19999980926514,"fetchStart":329.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":329.19999980926514,"responseEnd":1065,"responseStart":1065,"secureConnectionStart":329.19999980926514},{"duration":1115.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":330.30000019073486,"connectEnd":330.30000019073486,"connectStart":330.30000019073486,"domainLookupEnd":330.30000019073486,"domainLookupStart":330.30000019073486,"fetchStart":330.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":330.30000019073486,"responseEnd":1446,"responseStart":1446,"secureConnectionStart":330.30000019073486},{"duration":1685.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":334.8999996185303,"connectEnd":334.8999996185303,"connectStart":334.8999996185303,"domainLookupEnd":334.8999996185303,"domainLookupStart":334.8999996185303,"fetchStart":334.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":334.8999996185303,"responseEnd":2020.3000001907349,"responseStart":2020.3000001907349,"secureConnectionStart":334.8999996185303},{"duration":319.8999996185303,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1168.5,"connectEnd":1168.5,"connectStart":1168.5,"domainLookupEnd":1168.5,"domainLookupStart":1168.5,"fetchStart":1168.5,"redirectEnd":0,"redirectStart":0,"requestStart":1168.5,"responseEnd":1488.3999996185303,"responseStart":1488.3999996185303,"secureConnectionStart":1168.5},{"duration":630.8999996185303,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1495.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1495.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2126.199999809265,"responseStart":0,"secureConnectionStart":0},{"duration":574.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1546.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1546.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2121,"responseStart":0,"secureConnectionStart":0},{"duration":548.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1547.6999998092651,"connectEnd":1547.6999998092651,"connectStart":1547.6999998092651,"domainLookupEnd":1547.6999998092651,"domainLookupStart":1547.6999998092651,"fetchStart":1547.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1547.6999998092651,"responseEnd":2096.199999809265,"responseStart":2096.199999809265,"secureConnectionStart":1547.6999998092651},{"duration":583.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1550.3999996185303,"connectEnd":1550.3999996185303,"connectStart":1550.3999996185303,"domainLookupEnd":1550.3999996185303,"domainLookupStart":1550.3999996185303,"fetchStart":1550.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1550.3999996185303,"responseEnd":2133.5,"responseStart":2133.5,"secureConnectionStart":1550.3999996185303}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":145,"responseStart":319,"responseEnd":327,"domLoading":324,"domInteractive":2058,"domContentLoadedEventStart":2058,"domContentLoadedEventEnd":2120,"domComplete":2954,"loadEventStart":2955,"loadEventEnd":2955,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2022.5},{"name":"bigPipe.sidebar-id.end","time":2023.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2023.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":2026.3999996185303},{"name":"activityTabFullyLoaded","time":2183.8999996185303}],"measures":[],"correlationId":"c56c65939e2b30","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":103,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Another test with different assert but most probably based on the same mistake in coding.
ts_6.test
--------------
--source include/have_innodb.inc
CREATE TABLE t1 (col1 INT, col_int INTEGER) ENGINE = InnoDB ROW_FORMAT = Redundant ;
ALTER TABLE t1 ADD PRIMARY KEY ( col_int ), LOCK = SHARED, ALGORITHM = DEFAULT ;
INSERT INTO t1 (col1, col_int) VALUES ( 1, 1) ;
UPDATE t1 SET col1 = NULL;
ALTER TABLE t1 MODIFY col_int BIGINT ;
DELETE FROM t1 WHERE col1 IS NULL ;
SHOW PROCESSLIST;
Version: '10.4.2-MariaDB-debug-log' socket: 'bld_asan/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2019-01-03 12:44:52 9 [ERROR] InnoDB: Transaction id 2147483648 associated with recordRECORD(info_bits=32, 4 fields): {[4] (0x80000001),[6] (0x000000000000),[7] (0x80000000000000),NULL} in index `PRIMARY` of table `test`.`t1` is greater than the global counter 65! The table is corrupted.
2019-01-03 12:44:52 9 [ERROR] InnoDB: Transaction id 2147483648 associated with recordRECORD(info_bits=32, 4 fields): {[4] (0x80000001),[6] (0x000000000000),[7] (0x80000000000000),NULL} in index `PRIMARY` of table `test`.`t1` is greater than the global counter 65! The table is corrupted.
mysqld: storage/innobase/include/row0upd.ic:189: void row_upd_rec_sys_fields(rec_t*, page_zip_des_t*, dict_index_t*, const ulint*, const trx_t*, roll_ptr_t): Assertion `roll_ptr == 0 || lock_check_trx_id_sanity( trx_read_trx_id(rec + offset), rec, index, offsets)' failed.
190103 12:44:52 [ERROR] mysqld got signal 6 ;
...
Query (0x62b000000220): DELETE FROM t1 WHERE col1 IS NULL
Connection ID (thread ID): 9
Status: NOT_KILLED
...
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007ffba1d9ff5d in __GI_abort () at abort.c:90
#6 0x00007ffba1d95f17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5628093aa880 "roll_ptr == 0 || lock_check_trx_id_sanity( trx_read_trx_id(rec + offset), rec, index, offsets)", file=file@entry=0x5628093aa740 "storage/innobase/include/row0upd.ic", line=line@entry=189, function=function@entry=0x5628093b77e0 <row_upd_rec_sys_fields(unsigned char*, page_zip_des_t*, dict_index_t*, unsigned long const*, trx_t const*, unsigned long)::__PRETTY_FUNCTION__> "void row_upd_rec_sys_fields(rec_t*, page_zip_des_t*, dict_index_t*, const ulint*, const trx_t*, roll_ptr_t)") at assert.c:92
#7 0x00007ffba1d95fc2 in __GI___assert_fail (assertion=0x5628093aa880 "roll_ptr == 0 || lock_check_trx_id_sanity( trx_read_trx_id(rec + offset), rec, index, offsets)", file=0x5628093aa740 "storage/innobase/include/row0upd.ic", line=189, function=0x5628093b77e0 <row_upd_rec_sys_fields(unsigned char*, page_zip_des_t*, dict_index_t*, unsigned long const*, trx_t const*, unsigned long)::__PRETTY_FUNCTION__> "void row_upd_rec_sys_fields(rec_t*, page_zip_des_t*, dict_index_t*, const ulint*, const trx_t*, roll_ptr_t)") at assert.c:101
#8 0x00005628082f2970 in row_upd_rec_sys_fields (rec=0x7ffb987e4087 "\200", page_zip=0x0, index=0x617000040608, offsets=0x7ffb8bfc63c0, trx=0x7ffb98b5a908, roll_ptr=6473924485710096) at storage/innobase/include/row0upd.ic:189
#9 0x0000562808310fe1 in btr_cur_del_mark_set_clust_rec (block=0x7ffb982c1058, rec=0x7ffb987e4087 "\200", index=0x617000040608, offsets=0x7ffb8bfc63c0, thr=0x620000015bd0, entry=0x617000046108, mtr=0x7ffb8bfc6700) at storage/innobase/btr/btr0cur.cc:5436
#10 0x00005628081b7ce5 in row_upd_del_mark_clust_rec (node=0x6200000158c8, index=0x617000040608, offsets=0x7ffb8bfc63c0, thr=0x620000015bd0, referenced=0, foreign=false, mtr=0x7ffb8bfc6700) at storage/innobase/row/row0upd.cc:2984
#11 0x00005628081b8f12 in row_upd_clust_step (node=0x6200000158c8, thr=0x620000015bd0) at storage/innobase/row/row0upd.cc:3162
#12 0x00005628081b9a79 in row_upd (node=0x6200000158c8, thr=0x620000015bd0) at storage/innobase/row/row0upd.cc:3288
#13 0x00005628081ba902 in row_upd_step (thr=0x620000015bd0) at storage/innobase/row/row0upd.cc:3432
#14 0x000056280810eb78 in row_update_for_mysql (prebuilt=0x620000015108) at storage/innobase/row/row0mysql.cc:1889
#15 0x0000562807e16718 in ha_innobase::delete_row (this=0x61c0000560a0, record=0x6190000e0ba8 "\377") at storage/innobase/handler/ha_innodb.cc:8958
#16 0x00005628078e0ddc in handler::ha_delete_row (this=0x61c0000560a0, buf=0x6190000e0ba8 "\377") at sql/handler.cc:6361
#17 0x0000562807ce6fea in TABLE::delete_row (this=0x61f000046e88) at sql/sql_delete.cc:253
#18 0x0000562807cdeac4 in mysql_delete (thd=0x62a0000de208, table_list=0x62b000000310, conds=0x62b000000a68, order_list=0x62a0000e2ab0, limit=18446744073709551615, options=0, result=0x0) at sql/sql_delete.cc:753
#19 0x0000562807173e32 in mysql_execute_command (thd=0x62a0000de208) at sql/sql_parse.cc:4925
#20 0x000056280718963f in mysql_parse (thd=0x62a0000de208, rawbuf=0x62b000000220 "DELETE FROM t1 WHERE col1 IS NULL", length=33, parser_state=0x7ffb8bfc9dd0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8104
#21 0x0000562807160a50 in dispatch_command (command=COM_QUERY, thd=0x62a0000de208, packet=0x629000271209 "DELETE FROM t1 WHERE col1 IS NULL ", packet_length=35, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1850
#22 0x000056280715d67c in do_command (thd=0x62a0000de208) at sql/sql_parse.cc:1395
#23 0x00005628075003d9 in do_handle_one_connection (connect=0x6080000010a8) at sql/sql_connect.cc:1402
#24 0x00005628074ffccb in handle_one_connection (arg=0x6080000010a8) at sql/sql_connect.cc:1308
#25 0x00005628089e7aa4 in pfs_spawn_thread (arg=0x615000004908) at storage/perfschema/pfs.cc:1862
#26 0x00007ffba2a417fc in start_thread (arg=0x7ffb8bfcb700) at pthread_create.c:465