--source include/have_partition.inc
|
--source include/have_log_bin.inc
|
|
create or replace table t (x int) with system versioning
|
partition by system_time interval 1 minute auto partitions 3;
|
insert into t values (1);
|
|
--connect (con1,localhost,root,,)
|
set timestamp= @@timestamp+120;
|
update t set x= x + 1;
|
|
# Cleanup
|
drop table t;
|
11.2 985e3dfc05c697b8de1f083712275bdb48d42fc2 debug
|
mariadbd: /data/bld/11.2-asan/sql/log.cc:6175: Rows_log_event* binlog_get_pending_rows_event(binlog_cache_mngr*, bool): Assertion `cache_mngr' failed.
|
240130 15:28:21 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007f16cc253e32 in __GI___assert_fail (assertion=0x55749f6ce4e0 "cache_mngr", file=0x55749f6c62e0 "/data/bld/11.2-asan/sql/log.cc", line=6175, function=0x55749f6ce520 "Rows_log_event* binlog_get_pending_rows_event(binlog_cache_mngr*, bool)") at ./assert/assert.c:101
|
#10 0x000055749dca368e in binlog_get_pending_rows_event (cache_mngr=0x0, use_trans_cache=false) at /data/bld/11.2-asan/sql/log.cc:6175
|
#11 0x000055749cf1f54b in THD::binlog_need_stmt_format (this=0x62c000100218, is_transactional=false) at /data/bld/11.2-asan/sql/sql_class.h:3027
|
#12 0x000055749d398301 in Sql_cmd_update::update_single_table (this=0x62900028ae70, thd=0x62c000100218) at /data/bld/11.2-asan/sql/sql_update.cc:1214
|
#13 0x000055749d3aae8d in Sql_cmd_update::execute_inner (this=0x62900028ae70, thd=0x62c000100218) at /data/bld/11.2-asan/sql/sql_update.cc:3071
|
#14 0x000055749d1f06d4 in Sql_cmd_dml::execute (this=0x62900028ae70, thd=0x62c000100218) at /data/bld/11.2-asan/sql/sql_select.cc:33604
|
#15 0x000055749d00f96e in mysql_execute_command (thd=0x62c000100218, is_called_from_prepared_stmt=false) at /data/bld/11.2-asan/sql/sql_parse.cc:4408
|
#16 0x000055749d027255 in mysql_parse (thd=0x62c000100218, rawbuf=0x62900028a238 "update t set x= x + 1", length=21, parser_state=0x7f16c01d49f0) at /data/bld/11.2-asan/sql/sql_parse.cc:7857
|
#17 0x000055749cfff389 in dispatch_command (command=COM_QUERY, thd=0x62c000100218, packet=0x629000280219 "update t set x= x + 1", packet_length=21, blocking=true) at /data/bld/11.2-asan/sql/sql_parse.cc:1893
|
#18 0x000055749cffc0c6 in do_command (thd=0x62c000100218, blocking=true) at /data/bld/11.2-asan/sql/sql_parse.cc:1406
|
#19 0x000055749d4cbe7d in do_handle_one_connection (connect=0x608000002f38, put_in_cache=true) at /data/bld/11.2-asan/sql/sql_connect.cc:1437
|
#20 0x000055749d4cb83e in handle_one_connection (arg=0x608000002f38) at /data/bld/11.2-asan/sql/sql_connect.cc:1339
|
#21 0x000055749e0f10ac in pfs_spawn_thread (arg=0x617000006618) at /data/bld/11.2-asan/storage/perfschema/pfs.cc:2201
|
#22 0x00007f16cc2a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#23 0x00007f16cc32861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
11.2 985e3dfc05c697b8de1f083712275bdb48d42fc2 non-debug
|
#2 <signal handler called>
|
#3 binlog_get_pending_rows_event (cache_mngr=0x0, use_trans_cache=use_trans_cache@entry=false) at /data/bld/11.2-rel/sql/log_cache.h:60
|
#4 0x000055aea8d46a78 in THD::binlog_need_stmt_format (is_transactional=<optimized out>, this=0x7fb334000c68) at /data/bld/11.2-rel/sql/sql_class.h:3027
|
#5 Sql_cmd_update::update_single_table (this=0x7fb334011798, thd=0x7fb334000c68) at /data/bld/11.2-rel/sql/sql_update.cc:1214
|
#6 0x000055aea8d46ba5 in Sql_cmd_update::execute_inner (this=0x7fb334011798, thd=0x7fb334000c68) at /data/bld/11.2-rel/sql/sql_update.cc:3071
|
#7 0x000055aea8ca2dad in Sql_cmd_dml::execute (this=0x7fb334011798, thd=0x7fb334000c68) at /data/bld/11.2-rel/sql/sql_select.cc:33604
|
#8 0x000055aea8c6bf96 in mysql_execute_command (thd=thd@entry=0x7fb334000c68, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/11.2-rel/sql/sql_parse.cc:4408
|
#9 0x000055aea8c6fc45 in mysql_parse (thd=0x7fb334000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/bld/11.2-rel/sql/sql_parse.cc:7857
|
#10 0x000055aea8c71b85 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fb334000c68, packet=packet@entry=0x7fb3340088c9 "update t set x= x + 1", packet_length=packet_length@entry=21, blocking=blocking@entry=true) at /data/bld/11.2-rel/sql/sql_parse.cc:1992
|
#11 0x000055aea8c73197 in do_command (thd=0x7fb334000c68, blocking=blocking@entry=true) at /data/bld/11.2-rel/sql/sql_parse.cc:1406
|
#12 0x000055aea8d8a847 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55aeab908a78, put_in_cache=put_in_cache@entry=true) at /data/bld/11.2-rel/sql/sql_connect.cc:1437
|
#13 0x000055aea8d8abdd in handle_one_connection (arg=arg@entry=0x55aeab908a78) at /data/bld/11.2-rel/sql/sql_connect.cc:1339
|
#14 0x000055aea90af107 in pfs_spawn_thread (arg=0x55aeab8862b8) at /data/bld/11.2-rel/storage/perfschema/pfs.cc:2201
|
#15 0x00007fb3534a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#16 0x00007fb35352861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
It appears that the failure started happening after online ALTER push (MDEV-16329)
- is caused by
-
MDEV-16329
Engine-independent online ALTER TABLE
-
-
Closed
{"report":{"fcp":810.8000000715256,"ttfb":214.10000002384186,"pageVisibility":"visible","entityId":127450,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"f92fa04c-7b68-4a58-bde3-8f1d83cd69b1","navigationType":0,"readyForUser":879.7000000476837,"redirectCount":0,"resourceLoadedEnd":534,"resourceLoadedStart":220.20000004768372,"resourceTiming":[{"duration":69.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":220.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":289.5,"responseStart":0,"secureConnectionStart":0},{"duration":69.70000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":220.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":290.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":124.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":220.70000004768372,"connectEnd":220.70000004768372,"connectStart":220.70000004768372,"domainLookupEnd":220.70000004768372,"domainLookupStart":220.70000004768372,"fetchStart":220.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.70000004768372,"responseEnd":345.2000000476837,"responseStart":345.10000002384186,"secureConnectionStart":220.70000004768372},{"duration":169,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":220.70000004768372,"connectEnd":220.70000004768372,"connectStart":220.70000004768372,"domainLookupEnd":220.70000004768372,"domainLookupStart":220.70000004768372,"fetchStart":220.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":220.70000004768372,"responseEnd":389.7000000476837,"responseStart":389.7000000476837,"secureConnectionStart":220.70000004768372},{"duration":172.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":220.80000007152557,"connectEnd":220.80000007152557,"connectStart":220.80000007152557,"domainLookupEnd":220.80000007152557,"domainLookupStart":220.80000007152557,"fetchStart":220.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":220.80000007152557,"responseEnd":392.89999997615814,"responseStart":392.89999997615814,"secureConnectionStart":220.80000007152557},{"duration":172.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":221,"connectEnd":221,"connectStart":221,"domainLookupEnd":221,"domainLookupStart":221,"fetchStart":221,"redirectEnd":0,"redirectStart":0,"requestStart":221,"responseEnd":393.39999997615814,"responseStart":393.39999997615814,"secureConnectionStart":221},{"duration":173,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":221,"connectEnd":221,"connectStart":221,"domainLookupEnd":221,"domainLookupStart":221,"fetchStart":221,"redirectEnd":0,"redirectStart":0,"requestStart":221,"responseEnd":394,"responseStart":394,"secureConnectionStart":221},{"duration":173.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":221.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":221.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":394.5,"responseStart":0,"secureConnectionStart":0},{"duration":173.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":221.30000007152557,"connectEnd":221.30000007152557,"connectStart":221.30000007152557,"domainLookupEnd":221.30000007152557,"domainLookupStart":221.30000007152557,"fetchStart":221.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":221.30000007152557,"responseEnd":394.39999997615814,"responseStart":394.39999997615814,"secureConnectionStart":221.30000007152557},{"duration":173.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":221.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":221.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":395,"responseStart":0,"secureConnectionStart":0},{"duration":173.80000007152557,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":221.5,"connectEnd":221.5,"connectStart":221.5,"domainLookupEnd":221.5,"domainLookupStart":221.5,"fetchStart":221.5,"redirectEnd":0,"redirectStart":0,"requestStart":221.5,"responseEnd":395.3000000715256,"responseStart":395.3000000715256,"secureConnectionStart":221.5},{"duration":273.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":222.30000007152557,"connectEnd":222.30000007152557,"connectStart":222.30000007152557,"domainLookupEnd":222.30000007152557,"domainLookupStart":222.30000007152557,"fetchStart":222.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":222.30000007152557,"responseEnd":496.10000002384186,"responseStart":496.10000002384186,"secureConnectionStart":222.30000007152557},{"duration":311.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":222.39999997615814,"connectEnd":222.39999997615814,"connectStart":222.39999997615814,"domainLookupEnd":222.39999997615814,"domainLookupStart":222.39999997615814,"fetchStart":222.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":222.39999997615814,"responseEnd":534,"responseStart":534,"secureConnectionStart":222.39999997615814},{"duration":361.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":573.1000000238419,"connectEnd":573.1000000238419,"connectStart":573.1000000238419,"domainLookupEnd":573.1000000238419,"domainLookupStart":573.1000000238419,"fetchStart":573.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":573.1000000238419,"responseEnd":934.8999999761581,"responseStart":934.8999999761581,"secureConnectionStart":573.1000000238419},{"duration":148.89999997615814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":787.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":787.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":936.2000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":40,"responseStart":214,"responseEnd":216,"domLoading":218,"domInteractive":943,"domContentLoadedEventStart":943,"domContentLoadedEventEnd":988,"domComplete":1758,"loadEventStart":1758,"loadEventEnd":1760,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":920.6000000238419},{"name":"bigPipe.sidebar-id.end","time":921.3000000715256},{"name":"bigPipe.activity-panel-pipe-id.start","time":921.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":923.8000000715256},{"name":"activityTabFullyLoaded","time":995.3000000715256}],"measures":[],"correlationId":"98cb720d95c832","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}