When enabling session_track_state_change, mysql cli crashes:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12471378
Server version: 10.3 . 13 -MariaDB MariaDB Server
Copyright (c) 2000 , 2018 , Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> set session_track_state_change = on;
*** buffer overflow detected ***: mysql terminated
======= Backtrace: =========
/lib64/libc.so. 6 (__fortify_fail+ 0x37 )[ 0x7fed0b71a9e7 ]
/lib64/libc.so. 6 (+ 0x115b62 )[ 0x7fed0b718b62 ]
mysql(ma_read_ok_packet+ 0x6d6 )[ 0x55c790d75376 ]
mysql(mthd_my_read_query_result+ 0x115 )[ 0x55c790d75515 ]
mysql(_Z25mysql_real_query_for_lazyPKcm+ 0x44 )[ 0x55c790d64d84 ]
mysql(+ 0x64b78 )[ 0x55c790d67b78 ]
mysql(+ 0x668ae )[ 0x55c790d698ae ]
mysql(main+ 0x63f )[ 0x55c790d5eaff ]
/lib64/libc.so. 6 (__libc_start_main+ 0xf5 )[ 0x7fed0b6253d5 ]
mysql(+ 0x5c07e )[ 0x55c790d5f07e ]
This seems related to CONC-392 , however that should be fixed in 3.0.9 which is included in 10.3.13
relates to
CONC-392
signal 6 after enabling `session_track_state_change
Closed
Tim Westervoorde
made changes -
2019-03-22 13:15
Field
Original Value
New Value
Description
When enabling session_track_state_change, mysql cli crashes:
{code:java}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12471378
Server version: 10.3.13-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> set session_track_state_change = on;
*** buffer overflow detected ***: mysql terminated
======= Backtrace: =========
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fed0b71a9e7]
/lib64/libc.so.6(+0x115b62)[0x7fed0b718b62]
mysql(ma_read_ok_packet+0x6d6)[0x55c790d75376]
mysql(mthd_my_read_query_result+0x115)[0x55c790d75515]
mysql(_Z25mysql_real_query_for_lazyPKcm+0x44)[0x55c790d64d84]
mysql(+0x64b78)[0x55c790d67b78]
mysql(+0x668ae)[0x55c790d698ae]
mysql(main+0x63f)[0x55c790d5eaff]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fed0b6253d5]
mysql(+0x5c07e)[0x55c790d5f07e]
{code}
Tim Westervoorde
made changes -
2019-03-22 13:15
Affects Version/s
10.3.13
[ 23215
]
Tim Westervoorde
made changes -
2019-03-22 13:20
Description
When enabling session_track_state_change, mysql cli crashes:
{code:java}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12471378
Server version: 10.3.13-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> set session_track_state_change = on;
*** buffer overflow detected ***: mysql terminated
======= Backtrace: =========
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fed0b71a9e7]
/lib64/libc.so.6(+0x115b62)[0x7fed0b718b62]
mysql(ma_read_ok_packet+0x6d6)[0x55c790d75376]
mysql(mthd_my_read_query_result+0x115)[0x55c790d75515]
mysql(_Z25mysql_real_query_for_lazyPKcm+0x44)[0x55c790d64d84]
mysql(+0x64b78)[0x55c790d67b78]
mysql(+0x668ae)[0x55c790d698ae]
mysql(main+0x63f)[0x55c790d5eaff]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fed0b6253d5]
mysql(+0x5c07e)[0x55c790d5f07e]
{code}
When enabling session_track_state_change, mysql cli crashes:
{code:java}
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12471378
Server version: 10.3.13-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> set session_track_state_change = on;
*** buffer overflow detected ***: mysql terminated
======= Backtrace: =========
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fed0b71a9e7]
/lib64/libc.so.6(+0x115b62)[0x7fed0b718b62]
mysql(ma_read_ok_packet+0x6d6)[0x55c790d75376]
mysql(mthd_my_read_query_result+0x115)[0x55c790d75515]
mysql(_Z25mysql_real_query_for_lazyPKcm+0x44)[0x55c790d64d84]
mysql(+0x64b78)[0x55c790d67b78]
mysql(+0x668ae)[0x55c790d698ae]
mysql(main+0x63f)[0x55c790d5eaff]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7fed0b6253d5]
mysql(+0x5c07e)[0x55c790d5f07e]
{code}
This seems related to CONC-392 , however that should be fixed in 3.0.9 which is included in 10.3.13
Elena Stepanova
made changes -
2019-03-23 00:07
Status
Open
[ 1
]
Confirmed
[ 10101
]
Elena Stepanova
made changes -
2019-03-23 00:11
Component/s
libmariadb
[ 14006
]
Component/s
Scripts & Clients
[ 11002
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Affects Version/s
10.2
[ 14601
]
Affects Version/s
10.3
[ 22126
]
Affects Version/s
10.4
[ 22408
]
Assignee
Oleksandr Byelkin
[ sanja
]
Sergei Golubchik
made changes -
2021-12-06 21:36
Workflow
MariaDB v3
[ 93466
]
MariaDB v4
[ 144124
]
Ralf Gebhardt
made changes -
2022-08-04 08:41
Fix Version/s
10.2
[ 14601
]
Julien Fritsch
made changes -
2023-04-27 14:22
Fix Version/s
10.3
[ 22126
]
{"report":{"fcp":943.5,"ttfb":338.5999994277954,"pageVisibility":"visible","entityId":73461,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"a9dad74e-4fc2-4d79-a28e-715710200f68","navigationType":0,"readyForUser":1057.8999996185303,"redirectCount":0,"resourceLoadedEnd":1147.3999996185303,"resourceLoadedStart":343.19999980926514,"resourceTiming":[{"duration":8.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":343.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":343.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":8.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":343.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":343.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":80.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":343.69999980926514,"connectEnd":343.69999980926514,"connectStart":343.69999980926514,"domainLookupEnd":343.69999980926514,"domainLookupStart":343.69999980926514,"fetchStart":343.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":343.69999980926514,"responseEnd":423.8999996185303,"responseStart":423.8999996185303,"secureConnectionStart":343.69999980926514},{"duration":204.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":343.8999996185303,"connectEnd":343.8999996185303,"connectStart":343.8999996185303,"domainLookupEnd":343.8999996185303,"domainLookupStart":343.8999996185303,"fetchStart":343.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":343.8999996185303,"responseEnd":548.2999992370605,"responseStart":548.2999992370605,"secureConnectionStart":343.8999996185303},{"duration":207.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":344.0999994277954,"connectEnd":344.0999994277954,"connectStart":344.0999994277954,"domainLookupEnd":344.0999994277954,"domainLookupStart":344.0999994277954,"fetchStart":344.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":344.0999994277954,"responseEnd":552,"responseStart":552,"secureConnectionStart":344.0999994277954},{"duration":208.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":344.19999980926514,"connectEnd":344.19999980926514,"connectStart":344.19999980926514,"domainLookupEnd":344.19999980926514,"domainLookupStart":344.19999980926514,"fetchStart":344.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":344.19999980926514,"responseEnd":552.6999998092651,"responseStart":552.6999998092651,"secureConnectionStart":344.19999980926514},{"duration":208.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":344.3999996185303,"connectEnd":344.3999996185303,"connectStart":344.3999996185303,"domainLookupEnd":344.3999996185303,"domainLookupStart":344.3999996185303,"fetchStart":344.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":344.3999996185303,"responseEnd":553.0999994277954,"responseStart":553.0999994277954,"secureConnectionStart":344.3999996185303},{"duration":254.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":344.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":344.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":599,"responseStart":0,"secureConnectionStart":0},{"duration":208.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":344.79999923706055,"connectEnd":344.79999923706055,"connectStart":344.79999923706055,"domainLookupEnd":344.79999923706055,"domainLookupStart":344.79999923706055,"fetchStart":344.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":344.79999923706055,"responseEnd":553.5,"responseStart":553.5,"secureConnectionStart":344.79999923706055},{"duration":254.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":345,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":345,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":599.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":209.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":345.0999994277954,"connectEnd":345.0999994277954,"connectStart":345.0999994277954,"domainLookupEnd":345.0999994277954,"domainLookupStart":345.0999994277954,"fetchStart":345.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":345.0999994277954,"responseEnd":554.1999998092651,"responseStart":554.1999998092651,"secureConnectionStart":345.0999994277954},{"duration":609.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":351,"connectEnd":351,"connectStart":351,"domainLookupEnd":351,"domainLookupStart":351,"fetchStart":351,"redirectEnd":0,"redirectStart":0,"requestStart":351,"responseEnd":960.8999996185303,"responseStart":960.8999996185303,"secureConnectionStart":351},{"duration":795,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":352.3999996185303,"connectEnd":352.3999996185303,"connectStart":352.3999996185303,"domainLookupEnd":352.3999996185303,"domainLookupStart":352.3999996185303,"fetchStart":352.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":352.3999996185303,"responseEnd":1147.3999996185303,"responseStart":1147.3999996185303,"secureConnectionStart":352.3999996185303},{"duration":350,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":611.2999992370605,"connectEnd":611.2999992370605,"connectStart":611.2999992370605,"domainLookupEnd":611.2999992370605,"domainLookupStart":611.2999992370605,"fetchStart":611.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":611.2999992370605,"responseEnd":961.2999992370605,"responseStart":961.2999992370605,"secureConnectionStart":611.2999992370605},{"duration":237.69999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":935.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":935.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1173.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":181.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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":1116.1999998092651,"connectEnd":1116.1999998092651,"connectStart":1116.1999998092651,"domainLookupEnd":1116.1999998092651,"domainLookupStart":1116.1999998092651,"fetchStart":1116.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1116.1999998092651,"responseEnd":1297.5,"responseStart":1297.3999996185303,"secureConnectionStart":1116.1999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":339,"responseEnd":352,"domLoading":342,"domInteractive":1246,"domContentLoadedEventStart":1246,"domContentLoadedEventEnd":1293,"domComplete":1615,"loadEventStart":1615,"loadEventEnd":1616,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1213.5},{"name":"bigPipe.sidebar-id.end","time":1214.2999992370605},{"name":"bigPipe.activity-panel-pipe-id.start","time":1214.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":1218.1999998092651},{"name":"activityTabFullyLoaded","time":1311.3999996185303}],"measures":[],"correlationId":"53d6426eb09021","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":241,"dbReadsTimeInMs":21,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Thanks for the report. Reproducible on 10.2, 10.3, 10.4
10.3 f4484dfd
Thread 1 (Thread 0x7f81b1359740 (LWP 5106)):
#0 0x00007f81af560e44 in __memmove_avx_unaligned_erms () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x00005578da35093a in ma_read_ok_packet (mysql=0x5578da937080 <mysql>, pos=0x5578dac8fe29 "", length=12) at /data/src/10.3/libmariadb/libmariadb/mariadb_lib.c:2050
#2 0x00005578da350ec9 in mthd_my_read_query_result (mysql=0x5578da937080 <mysql>) at /data/src/10.3/libmariadb/libmariadb/mariadb_lib.c:2139
#3 0x00005578da351242 in mysql_real_query (mysql=0x5578da937080 <mysql>, query=0x5578dac848d0 "set session_track_state_change = on\n", length=35) at /data/src/10.3/libmariadb/libmariadb/mariadb_lib.c:2205
#4 0x00005578da340a39 in mysql_real_query_for_lazy (buf=0x5578dac848d0 "set session_track_state_change = on\n", length=35) at /data/src/10.3/client/mysql.cc:2993
#5 0x00005578da3417b5 in com_go (buffer=0x5578da937620 <glob_buffer>, line=0x0) at /data/src/10.3/client/mysql.cc:3256
#6 0x00005578da33e695 in read_and_execute (interactive=false) at /data/src/10.3/client/mysql.cc:2138
#7 0x00005578da33d142 in main (argc=5, argv=0x5578dac652d8) at /data/src/10.3/client/mysql.cc:1290