Note: There are two test cases in this item, please make sure both are fixed.
--source include/have_log_bin.inc
|
|
CREATE OR REPLACE TABLE t1 (f INT, s DATE, e DATE, PERIOD FOR app(s,e));
|
INSERT INTO t1 VALUES (1,'2016-09-21','2019-06-14');
|
UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1;
|
|
# Cleanup
|
DROP TABLE t1;
|
10.4 3568427d
|
#3 <signal handler called>
|
#4 0x000055da10f85838 in bitmap_bits_set (map=0x0) at /data/src/10.4/mysys/my_bitmap.c:603
|
#5 0x000055da10926570 in pack_row (table=0x7ff9a4135980, cols=0x0, row_data=0x7ff9a412e559 '\245' <repeats 17 times>, '\217' <repeats 183 times>..., record=0x7ff9a412cf90 "\375\001") at /data/src/10.4/sql/rpl_record.cc:65
|
#6 0x000055da1041e961 in THD::binlog_update_row (this=0x7ff9a4000b00, table=0x7ff9a4135980, is_trans=false, before_record=0x7ff9a412cfa0 "\375\001", after_record=0x7ff9a412cf90 "\375\001") at /data/src/10.4/sql/sql_class.cc:6777
|
#7 0x000055da107e0ea4 in Update_rows_log_event::binlog_row_logging_function (thd=0x7ff9a4000b00, table=0x7ff9a4135980, is_transactional=false, before_record=0x7ff9a412cfa0 "\375\001", after_record=0x7ff9a412cf90 "\375\001") at /data/src/10.4/sql/log_event.h:4879
|
#8 0x000055da107da3e1 in binlog_log_row_internal (table=0x7ff9a4135980, before_record=0x7ff9a412cfa0 "\375\001", after_record=0x7ff9a412cf90 "\375\001", log_func=0x55da107e0e1a <Update_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.4/sql/handler.cc:6375
|
#9 0x000055da107da513 in binlog_log_row (table=0x7ff9a4135980, before_record=0x7ff9a412cfa0 "\375\001", after_record=0x7ff9a412cf90 "\375\001", log_func=0x55da107e0e1a <Update_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.4/sql/handler.cc:6395
|
#10 0x000055da107dbda7 in handler::ha_update_row (this=0x7ff9a412d3e8, old_data=0x7ff9a412cfa0 "\375\001", new_data=0x7ff9a412cf90 "\375\001") at /data/src/10.4/sql/handler.cc:6754
|
#11 0x000055da1058c723 in mysql_update (thd=0x7ff9a4000b00, table_list=0x7ff9a4015898, fields=..., values=..., conds=0x7ff9a4016cf8, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ff9c27b0840, updated_return=0x7ff9c27b0900) at /data/src/10.4/sql/sql_update.cc:1017
|
#12 0x000055da10487fd1 in mysql_execute_command (thd=0x7ff9a4000b00) at /data/src/10.4/sql/sql_parse.cc:4695
|
#13 0x000055da1049448b in mysql_parse (thd=0x7ff9a4000b00, rawbuf=0x7ff9a40155d8 "UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1", length=79, parser_state=0x7ff9c27b1180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8205
|
#14 0x000055da1047fabb in dispatch_command (command=COM_QUERY, thd=0x7ff9a4000b00, packet=0x7ff9a4139261 "UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1", packet_length=79, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#15 0x000055da1047e2a1 in do_command (thd=0x7ff9a4000b00) at /data/src/10.4/sql/sql_parse.cc:1358
|
#16 0x000055da105f8109 in do_handle_one_connection (connect=0x55da143be430) at /data/src/10.4/sql/sql_connect.cc:1399
|
#17 0x000055da105f7e7a in handle_one_connection (arg=0x55da143be430) at /data/src/10.4/sql/sql_connect.cc:1302
|
#18 0x000055da10aeda89 in pfs_spawn_thread (arg=0x55da143c4a10) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#19 0x00007ff9ca358494 in start_thread (arg=0x7ff9c27b2700) at pthread_create.c:333
|
#20 0x00007ff9c873e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
--source include/have_log_bin.inc
|
|
CREATE OR REPLACE TABLE t1 (b LONGTEXT, f INT, s DATE, e DATE, PERIOD FOR app(s,e));
|
INSERT INTO t1 VALUES ('',1,'2016-09-21','2019-06-14');
|
UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1;
|
|
# Cleanup
|
DROP TABLE t1;
|
#3 <signal handler called>
|
#4 0x0000556cb2760d52 in bitmap_is_set (map=0x0, bit=0) at /data/src/10.4/include/my_bitmap.h:133
|
#5 0x0000556cb2779081 in max_row_length (table=0x7f7904135980, cols=0x0, data=0x7f790412cf90 "\374") at /data/src/10.4/sql/table.cc:7974
|
#6 0x0000556cb25e48a7 in THD::binlog_update_row (this=0x7f7904000b00, table=0x7f7904135980, is_trans=false, before_record=0x7f790412cfa8 "\374", after_record=0x7f790412cf90 "\374") at /data/src/10.4/sql/sql_class.cc:6765
|
#7 0x0000556cb29a6ea4 in Update_rows_log_event::binlog_row_logging_function (thd=0x7f7904000b00, table=0x7f7904135980, is_transactional=false, before_record=0x7f790412cfa8 "\374", after_record=0x7f790412cf90 "\374") at /data/src/10.4/sql/log_event.h:4879
|
#8 0x0000556cb29a03e1 in binlog_log_row_internal (table=0x7f7904135980, before_record=0x7f790412cfa8 "\374", after_record=0x7f790412cf90 "\374", log_func=0x556cb29a6e1a <Update_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.4/sql/handler.cc:6375
|
#9 0x0000556cb29a0513 in binlog_log_row (table=0x7f7904135980, before_record=0x7f790412cfa8 "\374", after_record=0x7f790412cf90 "\374", log_func=0x556cb29a6e1a <Update_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.4/sql/handler.cc:6395
|
#10 0x0000556cb29a1da7 in handler::ha_update_row (this=0x7f790412d3e8, old_data=0x7f790412cfa8 "\374", new_data=0x7f790412cf90 "\374") at /data/src/10.4/sql/handler.cc:6754
|
#11 0x0000556cb2752723 in mysql_update (thd=0x7f7904000b00, table_list=0x7f7904015898, fields=..., values=..., conds=0x7f7904016cf8, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7f7920d7b840, updated_return=0x7f7920d7b900) at /data/src/10.4/sql/sql_update.cc:1017
|
#12 0x0000556cb264dfd1 in mysql_execute_command (thd=0x7f7904000b00) at /data/src/10.4/sql/sql_parse.cc:4695
|
#13 0x0000556cb265a48b in mysql_parse (thd=0x7f7904000b00, rawbuf=0x7f79040155d8 "UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1", length=79, parser_state=0x7f7920d7c180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8205
|
#14 0x0000556cb2645abb in dispatch_command (command=COM_QUERY, thd=0x7f7904000b00, packet=0x7f7904139261 "UPDATE IGNORE t1 FOR PORTION OF app FROM '2019-03-13' TO '2019-03-14' SET f = 1", packet_length=79, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#15 0x0000556cb26442a1 in do_command (thd=0x7f7904000b00) at /data/src/10.4/sql/sql_parse.cc:1358
|
#16 0x0000556cb27be109 in do_handle_one_connection (connect=0x556cb5c02430) at /data/src/10.4/sql/sql_connect.cc:1399
|
#17 0x0000556cb27bde7a in handle_one_connection (arg=0x556cb5c02430) at /data/src/10.4/sql/sql_connect.cc:1302
|
#18 0x0000556cb2cb3a89 in pfs_spawn_thread (arg=0x556cb5c08a10) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#19 0x00007f7928923494 in start_thread (arg=0x7f7920d7d700) at pthread_create.c:333
|
#20 0x00007f7926d0993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Also reproducible with patches fbaa2e8f and 2e1e3bdb from the pull request 1225 applied.
- relates to
-
MDEV-18859
Server crashes in bitmap_bits_set / pack_row / THD::binlog_write_row upon DELETE .. FOR PORTION with binary logging
-
-
Closed
{"report":{"fcp":824,"ttfb":176,"pageVisibility":"visible","entityId":73260,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"159d9d46-9c0c-43ed-baf0-1a645b8278f3","navigationType":0,"readyForUser":900.5,"redirectCount":0,"resourceLoadedEnd":902.9000005722046,"resourceLoadedStart":180.69999980926514,"resourceTiming":[{"duration":206.20000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":180.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":386.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":205.9000005722046,"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":181,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":386.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":215.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":181.10000038146973,"connectEnd":181.10000038146973,"connectStart":181.10000038146973,"domainLookupEnd":181.10000038146973,"domainLookupStart":181.10000038146973,"fetchStart":181.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":181.10000038146973,"responseEnd":396.9000005722046,"responseStart":396.9000005722046,"secureConnectionStart":181.10000038146973},{"duration":261.80000019073486,"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":181.19999980926514,"connectEnd":181.19999980926514,"connectStart":181.19999980926514,"domainLookupEnd":181.19999980926514,"domainLookupStart":181.19999980926514,"fetchStart":181.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":181.19999980926514,"responseEnd":443,"responseStart":443,"secureConnectionStart":181.19999980926514},{"duration":265.3999996185303,"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":181.30000019073486,"connectEnd":181.30000019073486,"connectStart":181.30000019073486,"domainLookupEnd":181.30000019073486,"domainLookupStart":181.30000019073486,"fetchStart":181.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":181.30000019073486,"responseEnd":446.69999980926514,"responseStart":446.69999980926514,"secureConnectionStart":181.30000019073486},{"duration":265.79999923706055,"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":181.4000005722046,"connectEnd":181.4000005722046,"connectStart":181.4000005722046,"domainLookupEnd":181.4000005722046,"domainLookupStart":181.4000005722046,"fetchStart":181.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":181.4000005722046,"responseEnd":447.19999980926514,"responseStart":447.19999980926514,"secureConnectionStart":181.4000005722046},{"duration":266,"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":181.5,"connectEnd":181.5,"connectStart":181.5,"domainLookupEnd":181.5,"domainLookupStart":181.5,"fetchStart":181.5,"redirectEnd":0,"redirectStart":0,"requestStart":181.5,"responseEnd":447.5,"responseStart":447.5,"secureConnectionStart":181.5},{"duration":266.3999996185303,"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":181.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":448,"responseStart":0,"secureConnectionStart":0},{"duration":266.6000003814697,"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":181.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":448.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":266.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":181.69999980926514,"connectEnd":181.69999980926514,"connectStart":181.69999980926514,"domainLookupEnd":181.69999980926514,"domainLookupStart":181.69999980926514,"fetchStart":181.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":181.69999980926514,"responseEnd":448,"responseStart":448,"secureConnectionStart":181.69999980926514},{"duration":266.80000019073486,"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":181.80000019073486,"connectEnd":181.80000019073486,"connectStart":181.80000019073486,"domainLookupEnd":181.80000019073486,"domainLookupStart":181.80000019073486,"fetchStart":181.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":181.80000019073486,"responseEnd":448.6000003814697,"responseStart":448.6000003814697,"secureConnectionStart":181.80000019073486},{"duration":577.5,"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":189.80000019073486,"connectEnd":189.80000019073486,"connectStart":189.80000019073486,"domainLookupEnd":189.80000019073486,"domainLookupStart":189.80000019073486,"fetchStart":189.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":189.80000019073486,"responseEnd":767.3000001907349,"responseStart":767.3000001907349,"secureConnectionStart":189.80000019073486},{"duration":711.7000007629395,"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":191.19999980926514,"connectEnd":191.19999980926514,"connectStart":191.19999980926514,"domainLookupEnd":191.19999980926514,"domainLookupStart":191.19999980926514,"fetchStart":191.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":191.19999980926514,"responseEnd":902.9000005722046,"responseStart":902.9000005722046,"secureConnectionStart":191.19999980926514},{"duration":289.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":612.8000001907349,"connectEnd":612.8000001907349,"connectStart":612.8000001907349,"domainLookupEnd":612.8000001907349,"domainLookupStart":612.8000001907349,"fetchStart":612.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":612.8000001907349,"responseEnd":902,"responseStart":902,"secureConnectionStart":612.8000001907349},{"duration":207.30000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":799.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":799.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1007.1000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":50,"responseStart":176,"responseEnd":191,"domLoading":179,"domInteractive":1000,"domContentLoadedEventStart":1000,"domContentLoadedEventEnd":1041,"domComplete":1866,"loadEventStart":1866,"loadEventEnd":1868,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":980},{"name":"bigPipe.sidebar-id.end","time":980.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":981},{"name":"bigPipe.activity-panel-pipe-id.end","time":983.6000003814697},{"name":"activityTabFullyLoaded","time":1052.3000001907349}],"measures":[],"correlationId":"b225b70273b5df","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":65,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}