I am getting various stack traces with the same concurrent test, here are examples:
#2 0x000000000084487d in handle_fatal_signal (sig=11) at 10.0/sql/signal_handler.cc:262
|
#3 <signal handler called>
|
#4 0x0000000000f0d3a1 in my_strcasecmp_utf8 (cs=0x1947a20, s=0x5a5a5a5a5a5a5a5a <Address 0x5a5a5a5a5a5a5a5a out of bounds>, t=0xfab50c "mysql_native_password") at 10.0/strings/ctype-utf8.c:5320
|
#5 0x00000000005fa434 in parse_client_handshake_packet (mpvio=0x7fa9ce9d93b0, buff=0x7fa9ce9d8fc0, pkt_len=65) at 10.0/sql/sql_acl.cc:11539
|
#6 0x00000000005fa9ad in server_mpvio_read_packet (param=0x7fa9ce9d93b0, buf=0x7fa9ce9d8fc0) at 10.0/sql/sql_acl.cc:11701
|
#7 0x00000000005fbf1e in native_password_authenticate (vio=0x7fa9ce9d93b0, info=0x7fa9ce9d93c8) at 10.0/sql/sql_acl.cc:12272
|
#8 0x00000000005fafee in do_auth_once (thd=0x7fa9afbf8070, auth_plugin_name=0x1769000, mpvio=0x7fa9ce9d93b0) at 10.0/sql/sql_acl.cc:11869
|
#9 0x00000000005fb325 in acl_authenticate (thd=0x7fa9afbf8070, connect_errors=0, com_change_user_pkt_len=0) at 10.0/sql/sql_acl.cc:11971
|
#10 0x000000000077660b in check_connection (thd=0x7fa9afbf8070) at 10.0/sql/sql_connect.cc:1070
|
#11 0x000000000077677e in login_connection (thd=0x7fa9afbf8070) at 10.0/sql/sql_connect.cc:1138
|
#12 0x0000000000776cfb in thd_prepare_connection (thd=0x7fa9afbf8070) at 10.0/sql/sql_connect.cc:1301
|
#13 0x0000000000776f5b in do_handle_one_connection (thd_arg=0x7fa9afbf8070) at 10.0/sql/sql_connect.cc:1370
|
#14 0x0000000000776cd0 in handle_one_connection (arg=0x7fa9afbf8070) at 10.0/sql/sql_connect.cc:1293
|
#15 0x0000000000a859e1 in pfs_spawn_thread (arg=0x7fa9af739670) at 10.0/storage/perfschema/pfs.cc:1853
|
#16 0x00007fa9ce6b7b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#17 0x00007fa9cd206a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
#3 <signal handler called>
|
#4 strmake (dst=0x7f5f49bfd3e8 "", src=0x5a5a5a5a5a5a5a5a <Address 0x5a5a5a5a5a5a5a5a out of bounds>, length=511) at 10.0/strings/strmake.c:36
|
#5 0x00000000005f91d6 in find_mpvio_user (mpvio=0x7f5f49bfd3b0) at 10.0/sql/sql_acl.cc:11100
|
#6 0x00000000005fa26e in parse_client_handshake_packet (mpvio=0x7f5f49bfd3b0, buff=0x7f5f49bfcfc0, pkt_len=65) at 10.0/sql/sql_acl.cc:11495
|
#7 0x00000000005fa9ad in server_mpvio_read_packet (param=0x7f5f49bfd3b0, buf=0x7f5f49bfcfc0) at 10.0/sql/sql_acl.cc:11701
|
#8 0x00000000005fbf1e in native_password_authenticate (vio=0x7f5f49bfd3b0, info=0x7f5f49bfd3c8) at 10.0/sql/sql_acl.cc:12272
|
#9 0x00000000005fafee in do_auth_once (thd=0x7f5f51fbf070, auth_plugin_name=0x1769000, mpvio=0x7f5f49bfd3b0) at 10.0/sql/sql_acl.cc:11869
|
#10 0x00000000005fb325 in acl_authenticate (thd=0x7f5f51fbf070, connect_errors=0, com_change_user_pkt_len=0) at 10.0/sql/sql_acl.cc:11971
|
#11 0x000000000077660b in check_connection (thd=0x7f5f51fbf070) at 10.0/sql/sql_connect.cc:1070
|
#12 0x000000000077677e in login_connection (thd=0x7f5f51fbf070) at 10.0/sql/sql_connect.cc:1138
|
#13 0x0000000000776cfb in thd_prepare_connection (thd=0x7f5f51fbf070) at 10.0/sql/sql_connect.cc:1301
|
#14 0x0000000000776f5b in do_handle_one_connection (thd_arg=0x7f5f51fbf070) at 10.0/sql/sql_connect.cc:1370
|
#15 0x0000000000776cd0 in handle_one_connection (arg=0x7f5f51fbf070) at 10.0/sql/sql_connect.cc:1293
|
#16 0x0000000000a859e1 in pfs_spawn_thread (arg=0x7f5f58afd3f0) at 10.0/storage/perfschema/pfs.cc:1853
|
#17 0x00007f5f77a0bb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#18 0x00007f5f7655aa7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
#3 <signal handler called>
|
#4 __strcmp_ssse3 () at ../sysdeps/x86_64/multiarch/../strcmp.S:214
|
#5 0x00000000005f5a6e in acl_find_proxy_user (user=0x5a5a5a5a5a5a5a5a <Address 0x5a5a5a5a5a5a5a5a out of bounds>, host=0xf96e3b "localhost", ip=0x7f3c94c5c3b0 "127.0.0.1", authenticated_as=0x7f3cbbde83e8 "root", proxy_used=0x7f3cbbde886e) at 10.0/sql/sql_acl.cc:9875
|
#6 0x00000000005fb66d in acl_authenticate (thd=0x7f3c95fa0070, connect_errors=0, com_change_user_pkt_len=0) at 10.0/sql/sql_acl.cc:12052
|
#7 0x000000000077660b in check_connection (thd=0x7f3c95fa0070) at 10.0/sql/sql_connect.cc:1070
|
#8 0x000000000077677e in login_connection (thd=0x7f3c95fa0070) at 10.0/sql/sql_connect.cc:1138
|
#9 0x0000000000776cfb in thd_prepare_connection (thd=0x7f3c95fa0070) at 10.0/sql/sql_connect.cc:1301
|
#10 0x0000000000776f5b in do_handle_one_connection (thd_arg=0x7f3c95fa0070) at 10.0/sql/sql_connect.cc:1370
|
#11 0x0000000000776cd0 in handle_one_connection (arg=0x7f3c95fa0070) at 10.0/sql/sql_connect.cc:1293
|
#12 0x0000000000a859e1 in pfs_spawn_thread (arg=0x7f3c96369d50) at 10.0/storage/perfschema/pfs.cc:1853
|
#13 0x00007f3cbba7cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#14 0x00007f3cba5cba7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
revision-id: bar@mnogosearch.org-20131126065321-vcuhvtfjs7d09xpl
|
revno: 3911
|
branch-nick: 10.0
|
RQG grammar (test.yy):
|
query:
|
FLUSH PRIVILEGES | SELECT MIN(ID) INTO @kill_id FROM INFORMATION_SCHEMA.PROCESSLIST ; KILL @kill_id ;
|
|
RQG command line (assuming the server is already running on port 3306):
|
perl ./gentest.pl --threads=4 --duration=400 --queries=100M --grammar=test.yy --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test
|
|
It fails for me within seconds or tens of seconds after a start.
Please note that the test can return a false positive, saying that the server crashes when it actually didn't. That's what happens on 5.5 – I never got a real crash there, but after some time the test commits suicide. On 10.0, in all test runs the server crashed for real.
There are no comments yet on this issue.
{"report":{"fcp":4523.299999713898,"ttfb":616.1999998092651,"pageVisibility":"visible","entityId":27217,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0,"journeyId":"fb6d63a5-82bb-4548-bab3-96b1b5e34c76","navigationType":0,"readyForUser":4630.699999809265,"redirectCount":0,"resourceLoadedEnd":5119.299999713898,"resourceLoadedStart":746.2999997138977,"resourceTiming":[{"duration":2755.5999999046326,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":746.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":746.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3501.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":3097.699999809265,"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":746.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":746.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":3844.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":3103.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":746.7999997138977,"connectEnd":746.7999997138977,"connectStart":746.7999997138977,"domainLookupEnd":746.7999997138977,"domainLookupStart":746.7999997138977,"fetchStart":746.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":746.7999997138977,"responseEnd":3850.5,"responseStart":3850.5,"secureConnectionStart":746.7999997138977},{"duration":3213.5,"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":746.8999996185303,"connectEnd":746.8999996185303,"connectStart":746.8999996185303,"domainLookupEnd":746.8999996185303,"domainLookupStart":746.8999996185303,"fetchStart":746.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":746.8999996185303,"responseEnd":3960.3999996185303,"responseStart":3960.3999996185303,"secureConnectionStart":746.8999996185303},{"duration":3218.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":747.0999999046326,"connectEnd":747.0999999046326,"connectStart":747.0999999046326,"domainLookupEnd":747.0999999046326,"domainLookupStart":747.0999999046326,"fetchStart":747.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":747.0999999046326,"responseEnd":3965.8999996185303,"responseStart":3965.8999996185303,"secureConnectionStart":747.0999999046326},{"duration":3284.4000000953674,"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":747.3999996185303,"connectEnd":747.3999996185303,"connectStart":747.3999996185303,"domainLookupEnd":747.3999996185303,"domainLookupStart":747.3999996185303,"fetchStart":747.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":747.3999996185303,"responseEnd":4031.7999997138977,"responseStart":4031.7999997138977,"secureConnectionStart":747.3999996185303},{"duration":3284.5999999046326,"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":747.5,"connectEnd":747.5,"connectStart":747.5,"domainLookupEnd":747.5,"domainLookupStart":747.5,"fetchStart":747.5,"redirectEnd":0,"redirectStart":0,"requestStart":747.5,"responseEnd":4032.0999999046326,"responseStart":4032.0999999046326,"secureConnectionStart":747.5},{"duration":3330.9000000953674,"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":747.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":747.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":4078.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":3284.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":747.7999997138977,"connectEnd":747.7999997138977,"connectStart":747.7999997138977,"domainLookupEnd":747.7999997138977,"domainLookupStart":747.7999997138977,"fetchStart":747.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":747.7999997138977,"responseEnd":4032.5,"responseStart":4032.5,"secureConnectionStart":747.7999997138977},{"duration":3330.8999996185303,"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":748,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":748,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":4078.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":3285,"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":748.0999999046326,"connectEnd":748.0999999046326,"connectStart":748.0999999046326,"domainLookupEnd":748.0999999046326,"domainLookupStart":748.0999999046326,"fetchStart":748.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":748.0999999046326,"responseEnd":4033.0999999046326,"responseStart":4033.0999999046326,"secureConnectionStart":748.0999999046326},{"duration":3787.2000002861023,"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":748.7999997138977,"connectEnd":748.7999997138977,"connectStart":748.7999997138977,"domainLookupEnd":748.7999997138977,"domainLookupStart":748.7999997138977,"fetchStart":748.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":748.7999997138977,"responseEnd":4536,"responseStart":4536,"secureConnectionStart":748.7999997138977},{"duration":4370.400000095367,"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":748.8999996185303,"connectEnd":748.8999996185303,"connectStart":748.8999996185303,"domainLookupEnd":748.8999996185303,"domainLookupStart":748.8999996185303,"fetchStart":748.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":748.8999996185303,"responseEnd":5119.299999713898,"responseStart":5119.299999713898,"secureConnectionStart":748.8999996185303},{"duration":434.7999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":4101.599999904633,"connectEnd":4101.599999904633,"connectStart":4101.599999904633,"domainLookupEnd":4101.599999904633,"domainLookupStart":4101.599999904633,"fetchStart":4101.599999904633,"redirectEnd":0,"redirectStart":0,"requestStart":4101.599999904633,"responseEnd":4536.39999961853,"responseStart":4536.39999961853,"secureConnectionStart":4101.599999904633},{"duration":764.3000001907349,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":4514.299999713898,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":4514.299999713898,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":5278.599999904633,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":437,"responseStart":616,"responseEnd":618,"domLoading":740,"domInteractive":5325,"domContentLoadedEventStart":5325,"domContentLoadedEventEnd":5367,"domComplete":6150,"loadEventStart":6151,"loadEventEnd":6151,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":5280},{"name":"bigPipe.sidebar-id.end","time":5303.799999713898},{"name":"bigPipe.activity-panel-pipe-id.start","time":5304.299999713898},{"name":"bigPipe.activity-panel-pipe-id.end","time":5304.799999713898},{"name":"activityTabFullyLoaded","time":5371.799999713898}],"measures":[],"correlationId":"da0afb6a44722e","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}