Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.10.1 , 10.6.10 , 10.7.6 , 10.8.5 , 10.9.3 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL)
Using slave_run_triggers_for_rbr=ON and row based replication a slave side trigger on a table that itself calls a function from a different database than the one the table with the trigger is in makes the slave server crash.
How to reproduce:
on the master have binlog-format=ROW
on the slave have slave_run_triggers_for_rbr=1
set up replication between master and slave
on the master create a table without trigger, e.g.
USE db1;
CREATE TABLE IF NOT EXISTS `t1` (
`i` int(11) NOT NULL,
PRIMARY KEY (`i`)
);
on the slave create a function in a different database, e.g db2 instead of db1
USE db2;
DELIMITER //
CREATE FUNCTION `get_value`(`id` INT) RETURNS int(2)
BEGIN
RETURN 0;
END//
DELIMITER ;
on the slave create a trigger on the table originally created on the master, calling the function in the other database:
USE db1;
DELIMITER //
CREATE TRIGGER `tr_s1` BEFORE INSERT ON `t1` FOR EACH ROW BEGIN
DECLARE id INT;
SET id = `db2`.get_value(1);
END//
DELIMITER ;
now back on the master insert a row into the test table:
USE db1;
INSERT INTO `t1` (`i`) VALUES (4);
This did not cause problems up to MariaDB 10.4, but starting with 10.5 up to 10.10 it crashes the server, and as it tries to replicate the same event again and again after crash recovery as first thing when replication restarts it puts the slave into a crashing loop.
Error log output from syslog:
Oct 27 08:25:54 slave-1 mariadbd[1765]: free(): invalid pointer
Oct 27 08:25:54 slave-1 mariadbd[1765]: 221027 8:25:54 [ERROR] mysqld got signal 6 ;
Oct 27 08:25:54 slave-1 mariadbd[1765]: This could be because you hit a bug. It is also possible that this binary
Oct 27 08:25:54 slave-1 mariadbd[1765]: or one of the libraries it was linked against is corrupt, improperly built,
Oct 27 08:25:54 slave-1 mariadbd[1765]: or misconfigured. This error can also be caused by malfunctioning hardware.
Oct 27 08:25:54 slave-1 mariadbd[1765]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Oct 27 08:25:54 slave-1 mariadbd[1765]: We will try our best to scrape up some info that will hopefully help
Oct 27 08:25:54 slave-1 mariadbd[1765]: diagnose the problem, but since we have already crashed,
Oct 27 08:25:54 slave-1 mariadbd[1765]: something is definitely wrong and this may fail.
Oct 27 08:25:54 slave-1 mariadbd[1765]: Server version: 10.10.1-MariaDB-1:10.10.1+maria~ubu2204
Oct 27 08:25:54 slave-1 mariadbd[1765]: key_buffer_size=134217728
Oct 27 08:25:54 slave-1 mariadbd[1765]: read_buffer_size=131072
Oct 27 08:25:54 slave-1 mariadbd[1765]: max_used_connections=2
Oct 27 08:25:54 slave-1 mariadbd[1765]: max_threads=153
Oct 27 08:25:54 slave-1 mariadbd[1765]: thread_count=4
Oct 27 08:25:54 slave-1 mariadbd[1765]: It is possible that mysqld could use up to
Oct 27 08:25:54 slave-1 mariadbd[1765]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468010 K bytes of memory
Oct 27 08:25:54 slave-1 mariadbd[1765]: Hope that's ok; if not, decrease some variables in the equation.
Oct 27 08:25:54 slave-1 mariadbd[1765]: Thread pointer: 0x7f89b80015a8
Oct 27 08:25:54 slave-1 mariadbd[1765]: Attempting backtrace. You can use the following information to find out
Oct 27 08:25:54 slave-1 mariadbd[1765]: where mysqld died. If you see no messages after this, something went
Oct 27 08:25:54 slave-1 mariadbd[1765]: terribly wrong...
Oct 27 08:25:54 slave-1 mariadbd[1765]: stack_bottom = 0x7f8a000924e0 thread_stack 0x49000
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(my_print_stacktrace)[0x563bad89a3a2]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(handle_fatal_signal)[0x563bad36d1e8]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(__sigaction)[0x7f8a19377520]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(pthread_kill)[0x7f8a193cba7c]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(raise)[0x7f8a19377476]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(abort)[0x7f8a1935d7f3]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(__fsetlocking)[0x7f8a193be6f6]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(timer_settime)[0x7f8a193d5d7c]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(__default_morecore)[0x7f8a193d7ac4]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(free)[0x7f8a193da4d3]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(THD::set_db(st_mysql_const_lex_string const*))[0x563bad0b89fe]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(mysql_change_db(THD*, st_mysql_const_lex_string const*, bool))[0x563bad0c86e8]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(mysql_opt_change_db(THD*, st_mysql_const_lex_string const*, st_mysql_lex_string*, bool, bool*))[0x563bad0c8a10]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_head::execute(THD*, bool))[0x563bad0644c6]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_head::execute_function(THD*, Item**, unsigned int, Field*, sp_rcontext**, Query_arena*))[0x563bad067153]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Item_sp::execute_impl(THD*, Item**, unsigned int))[0x563bad38f74f]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Item_sp::execute(THD*, bool*, Item**, unsigned int))[0x563bad38f8e3]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Item_func_sp::val_int())[0x563bad3fa4d5]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Item::save_int_in_field(Field*, bool))[0x563bad3950e3]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Item::save_in_field(Field*, bool))[0x563bad384987]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Field::sp_prepare_and_store_item(THD*, Item**))[0x563bad34a4f3]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(THD::sp_eval_expr(Field*, Item**))[0x563bad062fbc]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_rcontext::set_variable(THD*, unsigned int, Item**))[0x563bad071948]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_instr_set::exec_core(THD*, unsigned int*))[0x563bad06b65f]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x563bad06a8a4]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_head::execute(THD*, bool))[0x563bad064c1a]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x563bad065ccd]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x563bad1dce74]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Rows_log_event::write_row(rpl_group_info*, bool))[0x563bad4b1e01]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Write_rows_log_event::do_exec_row(rpl_group_info*))[0x563bad4b23c4]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Rows_log_event::do_apply_event(rpl_group_info*))[0x563bad4a585c]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(Log_event::apply_event(rpl_group_info*))[0x563bad49db01]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x563bad057bfb]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(handle_slave_sql)[0x563bad0592b2]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x563bad599026]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(pthread_condattr_setpshared)[0x7f8a193c9b43]
Oct 27 08:25:54 slave-1 mariadbd[1765]: ??:0(__xmknodat)[0x7f8a1945ba00]
Oct 27 08:25:54 slave-1 mariadbd[1765]: Trying to get some variables.
Oct 27 08:25:54 slave-1 mariadbd[1765]: Some pointers may be invalid and cause the dump to abort.
Oct 27 08:25:54 slave-1 mariadbd[1765]: Query (0x0): (null)
Oct 27 08:25:54 slave-1 mariadbd[1765]: Connection ID (thread ID): 5
Oct 27 08:25:54 slave-1 mariadbd[1765]: Status: NOT_KILLED
Oct 27 08:25:54 slave-1 mariadbd[1765]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
Oct 27 08:25:54 slave-1 mariadbd[1765]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Oct 27 08:25:54 slave-1 mariadbd[1765]: information that should help you find out what is causing the crash.
Oct 27 08:25:54 slave-1 mariadbd[1765]: We think the query pointer is invalid, but we will try to print it anyway.
Oct 27 08:25:54 slave-1 mariadbd[1765]: Query:
Oct 27 08:25:54 slave-1 mariadbd[1765]: Writing a core file...
is duplicated by
MDEV-29939
free(): invalid pointer st_mysql_lex_stringbPb
Closed
made changes -
2022-10-27 14:58
Affects Version/s
10.6
[ 24028
]
Affects Version/s
10.7
[ 24805
]
Affects Version/s
10.8
[ 26121
]
Affects Version/s
10.9
[ 26905
]
made changes -
2022-10-27 14:58
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.7
[ 24805
]
Fix Version/s
10.8
[ 26121
]
Fix Version/s
10.9
[ 26905
]
made changes -
2022-10-27 15:11
Assignee
Andrei Elkin
[ elkin
]
made changes -
2022-10-27 15:11
Status
Open
[ 1
]
Confirmed
[ 10101
]
made changes -
2022-11-01 09:13
Assignee
Andrei Elkin
[ elkin
]
Brandon Nesterenko
[ JIRAUSER48702
]
made changes -
2023-02-14 10:11
Priority
Major
[ 3
]
Critical
[ 2
]
made changes -
2023-03-03 17:31
Fix Version/s
10.7
[ 24805
]
made changes -
2023-04-27 14:56
Fix Version/s
10.8
[ 26121
]
made changes -
2023-05-26 13:48
Link
This issue relates to MENT-1828
[ MENT-1828
]
made changes -
2023-05-26 13:55
Link
This issue relates to MENT-1828
[ MENT-1828
]
made changes -
2023-05-26 13:55
Link
This issue relates to MENT-1828
[ MENT-1828
]
made changes -
2023-05-30 16:17
Status
Confirmed
[ 10101
]
In Progress
[ 3
]
made changes -
2023-05-31 20:23
Assignee
Brandon Nesterenko
[ JIRAUSER48702
]
Andrei Elkin
[ elkin
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2023-06-19 09:39
Assignee
Andrei Elkin
[ elkin
]
Brandon Nesterenko
[ JIRAUSER48702
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2023-06-19 15:52
Assignee
Brandon Nesterenko
[ JIRAUSER48702
]
Andrei Elkin
[ elkin
]
Status
Stalled
[ 10000
]
In Review
[ 10002
]
made changes -
2023-06-21 08:38
Assignee
Andrei Elkin
[ elkin
]
Brandon Nesterenko
[ JIRAUSER48702
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2023-06-21 19:45
Fix Version/s
10.6.15
[ 29013
]
Fix Version/s
10.9.8
[ 29015
]
Fix Version/s
10.10.6
[ 29017
]
Fix Version/s
10.11.5
[ 29019
]
Fix Version/s
11.0.3
[ 28920
]
Fix Version/s
11.1.2
[ 28921
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.9
[ 26905
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
{"report":{"fcp":1882.2999997138977,"ttfb":638,"pageVisibility":"visible","entityId":116081,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"4d57b17a-9dbb-4979-a5b8-ff9e8a59507c","navigationType":0,"readyForUser":1999,"redirectCount":0,"resourceLoadedEnd":1694.5,"resourceLoadedStart":643.7999997138977,"resourceTiming":[{"duration":403.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":643.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":643.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1046.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":403.09999990463257,"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":644.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":644.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1047.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":603.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":644.1999998092651,"connectEnd":644.1999998092651,"connectStart":644.1999998092651,"domainLookupEnd":644.1999998092651,"domainLookupStart":644.1999998092651,"fetchStart":644.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1049.4000000953674,"responseEnd":1247.4000000953674,"responseStart":1072.2999997138977,"secureConnectionStart":644.1999998092651},{"duration":803.6999998092651,"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":644.4000000953674,"connectEnd":644.4000000953674,"connectStart":644.4000000953674,"domainLookupEnd":644.4000000953674,"domainLookupStart":644.4000000953674,"fetchStart":644.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1049.1999998092651,"responseEnd":1448.0999999046326,"responseStart":1071.6999998092651,"secureConnectionStart":644.4000000953674},{"duration":430.7999997138977,"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":644.5,"connectEnd":644.5,"connectStart":644.5,"domainLookupEnd":644.5,"domainLookupStart":644.5,"fetchStart":644.5,"redirectEnd":0,"redirectStart":0,"requestStart":1049.5,"responseEnd":1075.2999997138977,"responseStart":1074.0999999046326,"secureConnectionStart":644.5},{"duration":433.40000009536743,"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":644.6999998092651,"connectEnd":644.6999998092651,"connectStart":644.6999998092651,"domainLookupEnd":644.6999998092651,"domainLookupStart":644.6999998092651,"fetchStart":644.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1051.7999997138977,"responseEnd":1078.0999999046326,"responseStart":1076.1999998092651,"secureConnectionStart":644.6999998092651},{"duration":433.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":644.9000000953674,"connectEnd":644.9000000953674,"connectStart":644.9000000953674,"domainLookupEnd":644.9000000953674,"domainLookupStart":644.9000000953674,"fetchStart":644.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1052.2999997138977,"responseEnd":1078.2999997138977,"responseStart":1077,"secureConnectionStart":644.9000000953674},{"duration":404,"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":645.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":645.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1049.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":434.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":645.2999997138977,"connectEnd":645.2999997138977,"connectStart":645.2999997138977,"domainLookupEnd":645.2999997138977,"domainLookupStart":645.2999997138977,"fetchStart":645.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1054.5999999046326,"responseEnd":1079.7999997138977,"responseStart":1078.5,"secureConnectionStart":645.2999997138977},{"duration":408.09999990463257,"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":645.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":645.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1053.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":434.80000019073486,"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":645.5999999046326,"connectEnd":645.5999999046326,"connectStart":645.5999999046326,"domainLookupEnd":645.5999999046326,"domainLookupStart":645.5999999046326,"fetchStart":645.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1056.9000000953674,"responseEnd":1080.4000000953674,"responseStart":1079.0999999046326,"secureConnectionStart":645.5999999046326},{"duration":1042,"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":651.5,"connectEnd":651.5,"connectStart":651.5,"domainLookupEnd":651.5,"domainLookupStart":651.5,"fetchStart":651.5,"redirectEnd":0,"redirectStart":0,"requestStart":1680.5,"responseEnd":1693.5,"responseStart":1690.6999998092651,"secureConnectionStart":651.5},{"duration":1041.7000002861023,"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":652.7999997138977,"connectEnd":652.7999997138977,"connectStart":652.7999997138977,"domainLookupEnd":652.7999997138977,"domainLookupStart":652.7999997138977,"fetchStart":652.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1682.4000000953674,"responseEnd":1694.5,"responseStart":1693.7999997138977,"secureConnectionStart":652.7999997138977},{"duration":332.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1391,"connectEnd":1391,"connectStart":1391,"domainLookupEnd":1391,"domainLookupStart":1391,"fetchStart":1391,"redirectEnd":0,"redirectStart":0,"requestStart":1685.9000000953674,"responseEnd":1723.4000000953674,"responseStart":1722.7999997138977,"secureConnectionStart":1391},{"duration":295.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1806.5,"connectEnd":1806.5,"connectStart":1806.5,"domainLookupEnd":1806.5,"domainLookupStart":1806.5,"fetchStart":1806.5,"redirectEnd":0,"redirectStart":0,"requestStart":2064.9000000953674,"responseEnd":2101.699999809265,"responseStart":2099.9000000953674,"secureConnectionStart":1806.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":365,"responseStart":638,"responseEnd":650,"domLoading":642,"domInteractive":2213,"domContentLoadedEventStart":2213,"domContentLoadedEventEnd":2295,"domComplete":2925,"loadEventStart":2925,"loadEventEnd":2925,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2113.5},{"name":"bigPipe.sidebar-id.end","time":2114.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.start","time":2114.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":2123.5999999046326},{"name":"activityTabFullyLoaded","time":2320.199999809265}],"measures":[],"correlationId":"72a17329361f9b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":190,"dbReadsTimeInMs":34,"dbConnsTimeInMs":46,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
Thanks! I repeated as described on 10.6-10.10, 10.5 seems to be ok
--source include/have_binlog_format_row.inc--source include/master-slave.inc--connection slave--connection master--sync_slave_with_master--connection slaveDELIMITER //;DELIMITER ;//--connection master10.6 18a0f0c17839e3662ac8 - debug+asan
Error: Freeing unallocated data or underrun buffer 0x61b000050ea8 at mysys/safemalloc.c:341, mysys/safemalloc.c:200, mysys/my_malloc.c:212, sql/sql_class.cc:1497, sql/sql_db.cc:1587, sql/sql_db.cc:1854, sql/sql_db.cc:1893, sql/sp_head.cc:1271non-debug 10.6 18a0f0c17839e3662ac8:
free(): invalid pointer221027 17:35:58 [ERROR] mysqld got signal 6 ;Server version: 10.6.11-MariaDB-log??:0(abort)[0x7f116ab2f859]??:0(__fsetlocking)[0x7f116ab9a26e]??:0(pthread_attr_setschedparam)[0x7f116aba3b2c]sql/sql_class.cc:1497(THD::set_db(st_mysql_const_lex_string const*))[0x557e906ef99e]sql/sql_db.cc:1587(mysql_change_db(THD*, st_mysql_const_lex_string const*, bool))[0x557e906ffbf7]sql/sql_db.cc:1893(mysql_opt_change_db(THD*, st_mysql_const_lex_string const*, st_mysql_lex_string*, bool, bool*))[0x557e906fff40]sql/sp_head.cc:1270(sp_head::execute(THD*, bool))[0x557e9069991e]sql/sp_head.cc:2169(sp_head::execute_function(THD*, Item**, unsigned int, Field*, sp_rcontext**, Query_arena*))[0x557e9069c2da]sql/item.cc:2922(Item_sp::execute_impl(THD*, Item**, unsigned int))[0x557e909a027f]sql/item.cc:2836(Item_sp::execute(THD*, bool*, Item**, unsigned int))[0x557e909a0413]sql/item_func.h:3874(Item_func_sp::val_int())[0x557e90a0b095]sql/item.cc:6810(Item::save_int_in_field(Field*, bool))[0x557e909a5c13]sql/item.cc:6820(Item::save_in_field(Field*, bool))[0x557e90995a07]sql/sql_class.h:4381(THD::is_error() const)[0x557e9095b268]sql/sql_class.h:7797(Sp_eval_expr_state::stop())[0x557e9069842c]sql/sp_rcontext.cc:640(sp_rcontext::set_variable(THD*, unsigned int, Item**))[0x557e906a6738]sql/sp_head.cc:3813(sp_instr_set::exec_core(THD*, unsigned int*))[0x557e906a075f]sql/sp_head.cc:3512(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x557e9069f9ca]sql/sp_head.cc:1438(sp_head::execute(THD*, bool))[0x557e9069a099]psi/mysql_sp.h:79(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x557e9069b026]sql/sql_trigger.cc:2491(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x557e907fd954]sql/log_event_server.cc:7316(Rows_log_event::write_row(rpl_group_info*, bool))[0x557e90aa7921]sql/log_event_server.cc:7572(Write_rows_log_event::do_exec_row(rpl_group_info*))[0x557e90aa7ef1]sql/log_event_server.cc:5739(Rows_log_event::do_apply_event(rpl_group_info*))[0x557e90a9bc7f]sql/log_event.h:1500(Log_event::apply_event(rpl_group_info*))[0x557e9068572a]sql/slave.cc:4366(handle_slave_sql)[0x557e9068eae2]perfschema/pfs.cc:2204(pfs_spawn_thread)[0x557e90bf00f6]nptl/pthread_create.c:478(start_thread)[0x7f116b040609]??:0(clone)[0x7f116ac2c133]Query (0x7f112001b31b): INSERT INTO t1 (i) VALUES (4)