I first thought this was another iteration of MDEV-30176. However, this new testcase reproduces the issue only in bb-11.4-MDEV-7850 and not in the latest 11.3 (at 9e76d94ef0f3f1a8d222a23c7922f806d00777b5) nor in the latest 11.4 (at 9bd95e914f3f12d0d9d93e7a1f2c49e6e8841f17).
SET SESSION collation_connection=utf32_sinhala_ci;
#7 0x000055cddf5dcfab in my_b_append_tell (info=0x14ea2c0399d8) at /test/bb-11.4-MDEV-7850_dbg/mysys/mf_iocache2.c:150
#8 0x000055cddf5dd051 in my_b_safe_tell (info=<optimized out>) at /test/bb-11.4-MDEV-7850_dbg/mysys/mf_iocache2.c:163
#9 0x000055cddf03d6a7 in Log_event_writer::pos (this=0x7ffe386ebcd0) at /test/bb-11.4-MDEV-7850_dbg/sql/log_event.h:1007
#10 Log_event::write_header (this=this@entry=0x7ffe386ebd60, writer=writer@entry=0x7ffe386ebcd0, event_data_length=<optimized out>) at /test/bb-11.4-MDEV-7850_dbg/sql/log_event_server.cc:863
#11 0x000055cddf033467 in Log_event::write (this=0x7ffe386ebd60, writer=0x7ffe386ebcd0) at /test/bb-11.4-MDEV-7850_dbg/sql/log_event.h:1481
#12 0x000055cddf00cd7e in Log_event_writer::write (ev=0x7ffe386ebd60, this=0x7ffe386ebcd0) at /test/bb-11.4-MDEV-7850_dbg/sql/log_event.h:5431
#13 Event_log::write_event (this=this@entry=0x14ea2c039640, ev=ev@entry=0x7ffe386ebd60, checksum_alg=checksum_alg@entry=BINLOG_CHECKSUM_ALG_CRC32, cache_data=cache_data@entry=0x0, file=file@entry=0x14ea2c0399d8) at /test/bb-11.4-MDEV-7850_dbg/sql/log.cc:5840
#14 0x000055cddf0168b2 in MYSQL_BIN_LOG::write_event (checksum_alg=BINLOG_CHECKSUM_ALG_CRC32, ev=0x7ffe386ebd60, this=0x14ea2c039638) at /test/bb-11.4-MDEV-7850_dbg/sql/log.h:1000
#15 MYSQL_BIN_LOG::close (this=this@entry=0x14ea2c039638, exiting=exiting@entry=5) at /test/bb-11.4-MDEV-7850_dbg/sql/log.cc:9486
#16 0x000055cddeaf7601 in end_relay_log_info (rli=rli@entry=0x14ea2c039110) at /test/bb-11.4-MDEV-7850_dbg/sql/slave.cc:7028
#17 0x000055cdded21bcf in free_key_master_info (mi=0x14ea2c037050) at /test/bb-11.4-MDEV-7850_dbg/sql/rpl_mi.cc:894
#18 0x000055cddf5d77be in my_hash_free_elements (hash=0x55cde2e3b740) at /test/bb-11.4-MDEV-7850_dbg/mysys/hash.c:135
#19 my_hash_reset (hash=0x55cde2e3b740) at /test/bb-11.4-MDEV-7850_dbg/mysys/hash.c:178
#20 0x000055cdded2211e in Master_info_index::free_connections (this=0x55cde2e3b3d0) at /test/bb-11.4-MDEV-7850_dbg/sql/rpl_mi.cc:1068
#21 0x000055cddeaedcca in slave_prepare_for_shutdown () at /test/bb-11.4-MDEV-7850_dbg/sql/slave.cc:1298
#22 0x000055cddeaa365b in close_connections () at /test/bb-11.4-MDEV-7850_dbg/sql/mysqld.cc:1801
#23 mysqld_main (argc=<optimized out>, argv=<optimized out>) at /test/bb-11.4-MDEV-7850_dbg/sql/mysqld.cc:6068
#24 0x000055cddea94c76 in main (argc=<optimized out>, argv=<optimized out>) at /test/bb-11.4-MDEV-7850_dbg/sql/main.cc:34
No special mysqld options required, inc. binary logging. Apparently not sporadic. Debug builds only.
The testcase, as given, produces the same crash under MTR.
Also confirmed that trunk 11.3/11.4 (versions listed above) do not fail under MTR either.
Roel Van de Paar
added a comment - - edited The testcase, as given, produces the same crash under MTR.
Also confirmed that trunk 11.3/11.4 (versions listed above) do not fail under MTR either.
Issue seen regularly during testing of MDEV-7850.
It is possible that somehow MDEV-30176 is brought out in a new way due to the changes in bb-11.4-MDEV-7850.
Roel Van de Paar
added a comment - - edited Issue seen regularly during testing of MDEV-7850 .
It is possible that somehow MDEV-30176 is brought out in a new way due to the changes in bb-11.4-MDEV-7850.
Closing as this is a duplicate of MDEV-30176. To summarize the problem, the string value set for default_master_connection ends up being translated into an empty string at parse time for both master connections, which causes the two master connections to invalidly use the same relay log file on disk.
Brandon Nesterenko
added a comment - Closing as this is a duplicate of MDEV-30176 . To summarize the problem, the string value set for default_master_connection ends up being translated into an empty string at parse time for both master connections, which causes the two master connections to invalidly use the same relay log file on disk.
People
Brandon Nesterenko
Roel Van de Paar
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":676.1000001430511,"ttfb":194.20000004768372,"pageVisibility":"visible","entityId":126961,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3e31e289-2df9-4414-95fc-13a2595a16dd","navigationType":0,"readyForUser":793.6000001430511,"redirectCount":0,"resourceLoadedEnd":688.1000001430511,"resourceLoadedStart":199.70000004768372,"resourceTiming":[{"duration":15.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":199.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":199.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":215.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":15.5,"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":200.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":215.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":72.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":200.10000014305115,"connectEnd":200.10000014305115,"connectStart":200.10000014305115,"domainLookupEnd":200.10000014305115,"domainLookupStart":200.10000014305115,"fetchStart":200.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":200.10000014305115,"responseEnd":272.40000009536743,"responseStart":272.40000009536743,"secureConnectionStart":200.10000014305115},{"duration":154.10000014305115,"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":200.20000004768372,"connectEnd":200.20000004768372,"connectStart":200.20000004768372,"domainLookupEnd":200.20000004768372,"domainLookupStart":200.20000004768372,"fetchStart":200.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":200.20000004768372,"responseEnd":354.30000019073486,"responseStart":354.30000019073486,"secureConnectionStart":200.20000004768372},{"duration":157.59999990463257,"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":200.30000019073486,"connectEnd":200.30000019073486,"connectStart":200.30000019073486,"domainLookupEnd":200.30000019073486,"domainLookupStart":200.30000019073486,"fetchStart":200.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":200.30000019073486,"responseEnd":357.90000009536743,"responseStart":357.90000009536743,"secureConnectionStart":200.30000019073486},{"duration":158.09999990463257,"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":200.40000009536743,"connectEnd":200.40000009536743,"connectStart":200.40000009536743,"domainLookupEnd":200.40000009536743,"domainLookupStart":200.40000009536743,"fetchStart":200.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":200.40000009536743,"responseEnd":358.5,"responseStart":358.5,"secureConnectionStart":200.40000009536743},{"duration":158.70000004768372,"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":200.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":359.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":158.29999995231628,"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":200.60000014305115,"connectEnd":200.60000014305115,"connectStart":200.60000014305115,"domainLookupEnd":200.60000014305115,"domainLookupStart":200.60000014305115,"fetchStart":200.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":200.60000014305115,"responseEnd":358.90000009536743,"responseStart":358.80000019073486,"secureConnectionStart":200.60000014305115},{"duration":158.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":200.70000004768372,"connectEnd":200.70000004768372,"connectStart":200.70000004768372,"domainLookupEnd":200.70000004768372,"domainLookupStart":200.70000004768372,"fetchStart":200.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":200.70000004768372,"responseEnd":359.40000009536743,"responseStart":359.40000009536743,"secureConnectionStart":200.70000004768372},{"duration":158.90000009536743,"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":200.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":359.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":158.90000009536743,"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":201,"connectEnd":201,"connectStart":201,"domainLookupEnd":201,"domainLookupStart":201,"fetchStart":201,"redirectEnd":0,"redirectStart":0,"requestStart":201,"responseEnd":359.90000009536743,"responseStart":359.90000009536743,"secureConnectionStart":201},{"duration":219.79999995231628,"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":201.80000019073486,"connectEnd":201.80000019073486,"connectStart":201.80000019073486,"domainLookupEnd":201.80000019073486,"domainLookupStart":201.80000019073486,"fetchStart":201.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":201.80000019073486,"responseEnd":421.60000014305115,"responseStart":421.60000014305115,"secureConnectionStart":201.80000019073486},{"duration":221.60000014305115,"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":202,"connectEnd":202,"connectStart":202,"domainLookupEnd":202,"domainLookupStart":202,"fetchStart":202,"redirectEnd":0,"redirectStart":0,"requestStart":202,"responseEnd":423.60000014305115,"responseStart":423.60000014305115,"secureConnectionStart":202},{"duration":17,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":439.5,"connectEnd":439.5,"connectStart":439.5,"domainLookupEnd":439.5,"domainLookupStart":439.5,"fetchStart":439.5,"redirectEnd":0,"redirectStart":0,"requestStart":439.5,"responseEnd":456.5,"responseStart":456.5,"secureConnectionStart":439.5},{"duration":2.200000047683716,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":669.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":669.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":671.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":3.3999998569488525,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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","startTime":676.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":676.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":679.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":4.400000095367432,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":677,"connectEnd":677,"connectStart":677,"domainLookupEnd":677,"domainLookupStart":677,"fetchStart":677,"redirectEnd":0,"redirectStart":0,"requestStart":677,"responseEnd":681.4000000953674,"responseStart":681.4000000953674,"secureConnectionStart":677},{"duration":10.600000143051147,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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","startTime":677.5,"connectEnd":677.5,"connectStart":677.5,"domainLookupEnd":677.5,"domainLookupStart":677.5,"fetchStart":677.5,"redirectEnd":0,"redirectStart":0,"requestStart":677.5,"responseEnd":688.1000001430511,"responseStart":688.1000001430511,"secureConnectionStart":677.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":53,"responseStart":194,"responseEnd":197,"domLoading":197,"domInteractive":863,"domContentLoadedEventStart":863,"domContentLoadedEventEnd":909,"domComplete":965,"loadEventStart":965,"loadEventEnd":966,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":833.9000000953674},{"name":"bigPipe.sidebar-id.end","time":834.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":834.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":836},{"name":"activityTabFullyLoaded","time":927.9000000953674}],"measures":[],"correlationId":"fcfeaa82b7d39","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The testcase, as given, produces the same crash under MTR.
Also confirmed that trunk 11.3/11.4 (versions listed above) do not fail under MTR either.