Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.5
repeatable on 10.5, with InnoDB/MyIsam, row/stmt
--source include/master-slave.inc
--connection master
CREATE TABLE t1 ( id int );
INSERT INTO t1 VALUES (1),(2),(3); # not important
CREATE VIEW v1 AS SELECT * FROM t1;
RENAME TABLE v1 TO tmp, tmp TO v1;
--sync_slave_with_master
select * from v1;
--connection master
DROP VIEW v1;
DROP TABLE t1;
--source include/rpl_end.inc
10.5 ccbe6bb6fc3cbe31e74404
#3 <signal handler called>
#4 0x000055bf675d4ec1 in ha_storage_engine_is_enabled (db_type=0x1) at /10.5/sql/handler.h:5096
#5 0x000055bf675d6ef0 in ha_checktype (thd=0x7fb550001bb8, hton=0x1, no_substitute=true) at /10.5/sql/handler.cc:353
#6 0x000055bf675e8545 in ha_check_if_updates_are_ignored (thd=0x7fb550001bb8, hton=0x1, op=0x55bf6801013b "RENAME") at /10.5/sql/handler.cc:5932
#7 0x000055bf672b3627 in do_rename (thd=0x7fb550001bb8, ren_table=0x7fb55000db00, new_db=0x7fb55000e1f8, new_table_name=0x7fb55000e208, new_table_alias=0x7fb55000e228, skip_error=false, if_exists=false, force_if_exists=0x7fb5942d9c6d) at /10.5/sql/sql_rename.cc:306
#8 0x000055bf672b3ad9 in rename_tables (thd=0x7fb550001bb8, table_list=0x7fb55000db00, skip_error=false, if_exists=false, force_if_exists=0x7fb5942d9c6d) at /10.5/sql/sql_rename.cc:423
#9 0x000055bf672b3093 in mysql_rename_tables (thd=0x7fb550001bb8, table_list=0x7fb55000db00, silent=false, if_exists=false) at /10.5/sql/sql_rename.cc:158
#10 0x000055bf67282de5 in mysql_execute_command (thd=0x7fb550001bb8) at /10.5/sql/sql_parse.cc:4314
#11 0x000055bf6728f6db in mysql_parse (thd=0x7fb550001bb8, rawbuf=0x7fb55002e283 "RENAME TABLE v1 TO tmp, tmp TO v1", length=34, parser_state=0x7fb5942da3f0, is_com_multi=false, is_next_command=false) at /10.5/sql/sql_parse.cc:7994
#12 0x000055bf6773ce7f in Query_log_event::do_apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0, query_arg=0x7fb55002e283 "RENAME TABLE v1 TO tmp, tmp TO v1", q_len_arg=34) at /10.5/sql/log_event_server.cc:1906
#13 0x000055bf6773bd2f in Query_log_event::do_apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0) at /10.5/sql/log_event_server.cc:1581
#14 0x000055bf6717f93b in Log_event::apply_event (this=0x7fb55002e0b8, rgi=0x7fb550000cf0) at /10.5/sql/log_event.h:1498
#15 0x000055bf671723d8 in apply_event_and_update_pos_apply (ev=0x7fb55002e0b8, thd=0x7fb550001bb8, rgi=0x7fb550000cf0, reason=0) at /10.5/sql/slave.cc:4004
#16 0x000055bf671729ad in apply_event_and_update_pos (ev=0x7fb55002e0b8, thd=0x7fb550001bb8, rgi=0x7fb550000cf0) at /10.5/sql/slave.cc:4166
#17 0x000055bf671732e6 in exec_relay_log_event (thd=0x7fb550001bb8, rli=0x55bf6a387ed8, serial_rgi=0x7fb550000cf0) at /10.5/sql/slave.cc:4483
#18 0x000055bf67176c5b in handle_slave_sql (arg=0x55bf6a386210) at /10.5/sql/slave.cc:5660
#19 0x000055bf6795b8cd in pfs_spawn_thread (arg=0x7fb5541ac118) at /10.5/storage/perfschema/pfs.cc:2201
#20 0x00007fb59bd70fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
#21 0x00007fb59b3794cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Query (0x7f20e802e283): RENAME TABLE v1 TO tmp, tmp TO v1
relates to
MDEV-33804
SIGSEGV in ha_storage_engine_is_enabled on slave on CREATE TABLE after dropping view
Open
{"report":{"fcp":802.8999996185303,"ttfb":218.5999994277954,"pageVisibility":"visible","entityId":91876,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"10aacd66-119e-4b1a-b4b3-e53ba7666e2c","navigationType":0,"readyForUser":924,"redirectCount":0,"resourceLoadedEnd":1217.2999992370605,"resourceLoadedStart":224.19999980926514,"resourceTiming":[{"duration":21.800000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":224.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":246,"responseStart":0,"secureConnectionStart":0},{"duration":22.699999809265137,"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":224.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":247.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":77.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":224.69999980926514,"connectEnd":224.69999980926514,"connectStart":224.69999980926514,"domainLookupEnd":224.69999980926514,"domainLookupStart":224.69999980926514,"fetchStart":224.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":224.69999980926514,"responseEnd":302.0999994277954,"responseStart":302.0999994277954,"secureConnectionStart":224.69999980926514},{"duration":171.80000019073486,"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":224.79999923706055,"connectEnd":224.79999923706055,"connectStart":224.79999923706055,"domainLookupEnd":224.79999923706055,"domainLookupStart":224.79999923706055,"fetchStart":224.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":224.79999923706055,"responseEnd":396.5999994277954,"responseStart":396.5999994277954,"secureConnectionStart":224.79999923706055},{"duration":175.29999923706055,"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":225,"connectEnd":225,"connectStart":225,"domainLookupEnd":225,"domainLookupStart":225,"fetchStart":225,"redirectEnd":0,"redirectStart":0,"requestStart":225,"responseEnd":400.29999923706055,"responseStart":400.29999923706055,"secureConnectionStart":225},{"duration":175.5999994277954,"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":225.19999980926514,"connectEnd":225.19999980926514,"connectStart":225.19999980926514,"domainLookupEnd":225.19999980926514,"domainLookupStart":225.19999980926514,"fetchStart":225.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":225.19999980926514,"responseEnd":400.79999923706055,"responseStart":400.79999923706055,"secureConnectionStart":225.19999980926514},{"duration":175.89999961853027,"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":225.39999961853027,"connectEnd":225.39999961853027,"connectStart":225.39999961853027,"domainLookupEnd":225.39999961853027,"domainLookupStart":225.39999961853027,"fetchStart":225.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":225.39999961853027,"responseEnd":401.29999923706055,"responseStart":401.29999923706055,"secureConnectionStart":225.39999961853027},{"duration":222.4000005722046,"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":225.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":448,"responseStart":0,"secureConnectionStart":0},{"duration":175.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":225.79999923706055,"connectEnd":225.79999923706055,"connectStart":225.79999923706055,"domainLookupEnd":225.79999923706055,"domainLookupStart":225.79999923706055,"fetchStart":225.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":225.79999923706055,"responseEnd":401.69999980926514,"responseStart":401.69999980926514,"secureConnectionStart":225.79999923706055},{"duration":222.19999980926514,"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":226,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":448.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":176.5,"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":226.0999994277954,"connectEnd":226.0999994277954,"connectStart":226.0999994277954,"domainLookupEnd":226.0999994277954,"domainLookupStart":226.0999994277954,"fetchStart":226.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":226.0999994277954,"responseEnd":402.5999994277954,"responseStart":402.5999994277954,"secureConnectionStart":226.0999994277954},{"duration":307.4000005722046,"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":231.5999994277954,"connectEnd":231.5999994277954,"connectStart":231.5999994277954,"domainLookupEnd":231.5999994277954,"domainLookupStart":231.5999994277954,"fetchStart":231.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":231.5999994277954,"responseEnd":539,"responseStart":539,"secureConnectionStart":231.5999994277954},{"duration":985.6999998092651,"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":231.5999994277954,"connectEnd":231.5999994277954,"connectStart":231.5999994277954,"domainLookupEnd":231.5999994277954,"domainLookupStart":231.5999994277954,"fetchStart":231.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":231.5999994277954,"responseEnd":1217.2999992370605,"responseStart":1217.2999992370605,"secureConnectionStart":231.5999994277954},{"duration":76.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":462.8999996185303,"connectEnd":462.8999996185303,"connectStart":462.8999996185303,"domainLookupEnd":462.8999996185303,"domainLookupStart":462.8999996185303,"fetchStart":462.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":462.8999996185303,"responseEnd":539.5999994277954,"responseStart":539.5999994277954,"secureConnectionStart":462.8999996185303},{"duration":525.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":755.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":755.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1281.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":512.9000005722046,"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":756.7999992370605,"connectEnd":756.7999992370605,"connectStart":756.7999992370605,"domainLookupEnd":756.7999992370605,"domainLookupStart":756.7999992370605,"fetchStart":756.7999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":756.7999992370605,"responseEnd":1269.6999998092651,"responseStart":1269.6999998092651,"secureConnectionStart":756.7999992370605},{"duration":519.3000001907349,"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":757.2999992370605,"connectEnd":757.2999992370605,"connectStart":757.2999992370605,"domainLookupEnd":757.2999992370605,"domainLookupStart":757.2999992370605,"fetchStart":757.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":757.2999992370605,"responseEnd":1276.5999994277954,"responseStart":1276.5999994277954,"secureConnectionStart":757.2999992370605}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":61,"responseStart":219,"responseEnd":226,"domLoading":222,"domInteractive":1236,"domContentLoadedEventStart":1236,"domContentLoadedEventEnd":1281,"domComplete":1600,"loadEventStart":1600,"loadEventEnd":1601,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1219.0999994277954},{"name":"bigPipe.sidebar-id.end","time":1220},{"name":"bigPipe.activity-panel-pipe-id.start","time":1220.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1221.2999992370605},{"name":"activityTabFullyLoaded","time":1295.8999996185303}],"measures":[],"correlationId":"25786e42fae2f3","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}