#4 0x0000000000786511 in Field::make_field (this=0x7efd41cdfb98, field=0x7efd6cbcbe40) at /data/src/5.5/sql/field.cc:1581
#5 0x0000000000786aa9 in Field_num::make_field (this=0x7efd41cdfb98, field=0x7efd6cbcbe40) at /data/src/5.5/sql/field.cc:1713
#6 0x00000000007cc346 in Item_field::make_field (this=0x7efd41ce0078, tmp_field=0x7efd6cbcbe40) at /data/src/5.5/sql/item.cc:6039
#7 0x0000000000565da1 in Protocol::send_result_set_metadata (this=0x7efd48e87660, list=0x7efd41cf8368, flags=4) at /data/src/5.5/sql/protocol.cc:755
#8 0x00000000005c885b in select_send::send_result_set_metadata (this=0x7efd41cf6b00, list=..., flags=4) at /data/src/5.5/sql/sql_class.cc:2326
#9 0x000000000061d453 in mysql_test_handler_read (stmt=0x7efd41d2f460, tables=0x7efd41cf6530) at /data/src/5.5/sql/sql_prepare.cc:2014
#10 0x000000000061d84c in check_prepared_statement (stmt=0x7efd41d2f460) at /data/src/5.5/sql/sql_prepare.cc:2142
#11 0x0000000000620486 in Prepared_statement::prepare (this=0x7efd41d2f460, packet=0x7efd4f372061 "", packet_len=20) at /data/src/5.5/sql/sql_prepare.cc:3390
#12 0x000000000061dbae in mysqld_stmt_prepare (thd=0x7efd48e87060, packet=0x7efd4f372061 "", packet_length=20) at /data/src/5.5/sql/sql_prepare.cc:2292
#13 0x00000000005fde52 in dispatch_command (command=COM_STMT_PREPARE, thd=0x7efd48e87060, packet=0x7efd4f372061 "", packet_length=20) at /data/src/5.5/sql/sql_parse.cc:1035
#14 0x00000000005fd217 in do_command (thd=0x7efd48e87060) at /data/src/5.5/sql/sql_parse.cc:793
#15 0x0000000000700373 in do_handle_one_connection (thd_arg=0x7efd48e87060) at /data/src/5.5/sql/sql_connect.cc:1268
#16 0x0000000000700100 in handle_one_connection (arg=0x7efd48e87060) at /data/src/5.5/sql/sql_connect.cc:1184
#17 0x00007efd6c81d494 in start_thread (arg=0x7efd6cbcd700) at pthread_create.c:333
#18 0x00007efd6b23393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Note: the test cannot be run in MTR without modifying the code, because mysqltest.cc artificially restricts the set of statements which can be run via PS protocol. With the following addition it can be possible:
if (mysql_stmt_prepare(stmt, "HANDLER h READ FIRST",20))
goto err;
if (mysql_stmt_execute(stmt))
goto err;
mysql_close(con);
exit(0);
err:
fprintf(stderr, "%s\n", mysql_error(con));
if (con)
mysql_close(con);
}
Same result can be achieved with perl's DBD::mysql by using mysql_server_prepare=1.
Not reproducible with PREPARE / EXECUTE.
Not reproducible with MySQL 5.5-5.7, they return "This command is not supported in the prepared statement protocol yet" instead.
Attachments
Issue Links
relates to
MDEV-15489[Draft] Server crashes in Field::make_field
Variation which probably doesn't deserve a separate JIRA entry:
10.3 1730ac5c4ae1dc62f6fca5e751a8b08e9119be6a
#3 <signal handler called>
#4 0x000055d0084dea2f in Field::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:1952
#5 0x000055d0084df95b in Field_num::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:2178
#6 0x000055d008540899 in Item_field::make_send_field (this=0x7fb004090d68, thd=0x7fb00400c520, tmp_field=0x7fb068509bd0) at /home/travis/src/sql/item.cc:6779
#7 0x000055d00812350e in Protocol::send_result_set_metadata (this=0x7fb00400cb40, list=0x7fb004054cc8, flags=4) at /home/travis/src/sql/protocol.cc:824
#8 0x000055d0081c9a7e in select_send::send_result_set_metadata (this=0x7fb0040dfe98, list=..., flags=4) at /home/travis/src/sql/sql_class.cc:2943
#9 0x000055d00824dc05 in mysql_test_handler_read (stmt=0x7fb004145c20, tables=0x7fb0040df848) at /home/travis/src/sql/sql_prepare.cc:2214
#10 0x000055d00824e288 in check_prepared_statement (stmt=0x7fb004145c20) at /home/travis/src/sql/sql_prepare.cc:2434
#11 0x000055d008251bd6 in Prepared_statement::prepare (this=0x7fb004145c20, packet=0x7fb004016b31 "", packet_len=54) at /home/travis/src/sql/sql_prepare.cc:3963
#12 0x000055d00824e600 in mysqld_stmt_prepare (thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54) at /home/travis/src/sql/sql_prepare.cc:2596
#13 0x000055d00822364f in dispatch_command (command=COM_STMT_PREPARE, thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1799
#14 0x000055d0082223ca in do_command (thd=0x7fb00400c520) at /home/travis/src/sql/sql_parse.cc:1387
#15 0x000055d008387b71 in do_handle_one_connection (connect=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1402
#16 0x000055d0083878fe in handle_one_connection (arg=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1308
#17 0x00007fb06c819184 in start_thread (arg=0x7fb06850b700) at pthread_create.c:312
#18 0x00007fb06bd2603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Elena Stepanova
added a comment - Variation which probably doesn't deserve a separate JIRA entry:
10.3 1730ac5c4ae1dc62f6fca5e751a8b08e9119be6a
#3 <signal handler called>
#4 0x000055d0084dea2f in Field::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:1952
#5 0x000055d0084df95b in Field_num::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:2178
#6 0x000055d008540899 in Item_field::make_send_field (this=0x7fb004090d68, thd=0x7fb00400c520, tmp_field=0x7fb068509bd0) at /home/travis/src/sql/item.cc:6779
#7 0x000055d00812350e in Protocol::send_result_set_metadata (this=0x7fb00400cb40, list=0x7fb004054cc8, flags=4) at /home/travis/src/sql/protocol.cc:824
#8 0x000055d0081c9a7e in select_send::send_result_set_metadata (this=0x7fb0040dfe98, list=..., flags=4) at /home/travis/src/sql/sql_class.cc:2943
#9 0x000055d00824dc05 in mysql_test_handler_read (stmt=0x7fb004145c20, tables=0x7fb0040df848) at /home/travis/src/sql/sql_prepare.cc:2214
#10 0x000055d00824e288 in check_prepared_statement (stmt=0x7fb004145c20) at /home/travis/src/sql/sql_prepare.cc:2434
#11 0x000055d008251bd6 in Prepared_statement::prepare (this=0x7fb004145c20, packet=0x7fb004016b31 "", packet_len=54) at /home/travis/src/sql/sql_prepare.cc:3963
#12 0x000055d00824e600 in mysqld_stmt_prepare (thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54) at /home/travis/src/sql/sql_prepare.cc:2596
#13 0x000055d00822364f in dispatch_command (command=COM_STMT_PREPARE, thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1799
#14 0x000055d0082223ca in do_command (thd=0x7fb00400c520) at /home/travis/src/sql/sql_parse.cc:1387
#15 0x000055d008387b71 in do_handle_one_connection (connect=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1402
#16 0x000055d0083878fe in handle_one_connection (arg=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1308
#17 0x00007fb06c819184 in start_thread (arg=0x7fb06850b700) at pthread_create.c:312
#18 0x00007fb06bd2603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
People
Sergei Golubchik
Elena Stepanova
Votes:
0Vote for this issue
Watchers:
3Start 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":1203,"ttfb":317.30000019073486,"pageVisibility":"visible","entityId":66598,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a986cd26-65b1-4a80-86c2-edd1d438a774","navigationType":0,"readyForUser":1321.8000001907349,"redirectCount":0,"resourceLoadedEnd":827.7000000476837,"resourceLoadedStart":327.80000019073486,"resourceTiming":[{"duration":188.39999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":327.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":327.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":516.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":188.70000004768372,"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":328.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":328.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":516.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":384.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":328.30000019073486,"connectEnd":328.30000019073486,"connectStart":328.30000019073486,"domainLookupEnd":328.30000019073486,"domainLookupStart":328.30000019073486,"fetchStart":328.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":518.6000001430511,"responseEnd":712.5,"responseStart":568.9000000953674,"secureConnectionStart":328.30000019073486},{"duration":499.2000000476837,"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":328.5,"connectEnd":328.5,"connectStart":328.5,"domainLookupEnd":328.5,"domainLookupStart":328.5,"fetchStart":328.5,"redirectEnd":0,"redirectStart":0,"requestStart":518.7000000476837,"responseEnd":827.7000000476837,"responseStart":570.4000000953674,"secureConnectionStart":328.5},{"duration":244.29999995231628,"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":328.7000000476837,"connectEnd":328.7000000476837,"connectStart":328.7000000476837,"domainLookupEnd":328.7000000476837,"domainLookupStart":328.7000000476837,"fetchStart":328.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":518.9000000953674,"responseEnd":573,"responseStart":571.6000001430511,"secureConnectionStart":328.7000000476837},{"duration":248.59999990463257,"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":328.80000019073486,"connectEnd":328.80000019073486,"connectStart":328.80000019073486,"domainLookupEnd":328.80000019073486,"domainLookupStart":328.80000019073486,"fetchStart":328.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":519.3000001907349,"responseEnd":577.4000000953674,"responseStart":574,"secureConnectionStart":328.80000019073486},{"duration":248.10000014305115,"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":329,"connectEnd":329,"connectStart":329,"domainLookupEnd":329,"domainLookupStart":329,"fetchStart":329,"redirectEnd":0,"redirectStart":0,"requestStart":520.2000000476837,"responseEnd":577.1000001430511,"responseStart":573.4000000953674,"secureConnectionStart":329},{"duration":189.29999995231628,"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":329.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":329.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":518.5,"responseStart":0,"secureConnectionStart":0},{"duration":248.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":329.5,"connectEnd":329.5,"connectStart":329.5,"domainLookupEnd":329.5,"domainLookupStart":329.5,"fetchStart":329.5,"redirectEnd":0,"redirectStart":0,"requestStart":521.9000000953674,"responseEnd":577.6000001430511,"responseStart":574.3000001907349,"secureConnectionStart":329.5},{"duration":190.59999990463257,"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":329.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":329.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":252.79999995231628,"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":329.80000019073486,"connectEnd":329.80000019073486,"connectStart":329.80000019073486,"domainLookupEnd":329.80000019073486,"domainLookupStart":329.80000019073486,"fetchStart":329.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":522.9000000953674,"responseEnd":582.6000001430511,"responseStart":575.4000000953674,"secureConnectionStart":329.80000019073486},{"duration":425.09999990463257,"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":335.60000014305115,"connectEnd":335.60000014305115,"connectStart":335.60000014305115,"domainLookupEnd":335.60000014305115,"domainLookupStart":335.60000014305115,"fetchStart":335.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":598,"responseEnd":760.7000000476837,"responseStart":756.5,"secureConnectionStart":335.60000014305115},{"duration":426.7000000476837,"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":335.60000014305115,"connectEnd":335.60000014305115,"connectStart":335.60000014305115,"domainLookupEnd":335.60000014305115,"domainLookupStart":335.60000014305115,"fetchStart":335.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":693.8000001907349,"responseEnd":762.3000001907349,"responseStart":760.8000001907349,"secureConnectionStart":335.60000014305115},{"duration":303.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":847.1000001430511,"connectEnd":847.1000001430511,"connectStart":847.1000001430511,"domainLookupEnd":847.1000001430511,"domainLookupStart":847.1000001430511,"fetchStart":847.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1108.4000000953674,"responseEnd":1150.9000000953674,"responseStart":1142.9000000953674,"secureConnectionStart":847.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":115,"responseStart":317,"responseEnd":329,"domLoading":325,"domInteractive":1396,"domContentLoadedEventStart":1398,"domContentLoadedEventEnd":1470,"domComplete":2854,"loadEventStart":2854,"loadEventEnd":2854,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1369.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1370.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1370.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1374.6000001430511},{"name":"activityTabFullyLoaded","time":1495.9000000953674}],"measures":[],"correlationId":"eb4b19f5c48982","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":112,"dbReadsTimeInMs":11,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Variation which probably doesn't deserve a separate JIRA entry:
10.3 1730ac5c4ae1dc62f6fca5e751a8b08e9119be6a
#3 <signal handler called>
#4 0x000055d0084dea2f in Field::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:1952
#5 0x000055d0084df95b in Field_num::make_send_field (this=0x7fb0041442d0, field=0x7fb068509bd0) at /home/travis/src/sql/field.cc:2178
#6 0x000055d008540899 in Item_field::make_send_field (this=0x7fb004090d68, thd=0x7fb00400c520, tmp_field=0x7fb068509bd0) at /home/travis/src/sql/item.cc:6779
#7 0x000055d00812350e in Protocol::send_result_set_metadata (this=0x7fb00400cb40, list=0x7fb004054cc8, flags=4) at /home/travis/src/sql/protocol.cc:824
#8 0x000055d0081c9a7e in select_send::send_result_set_metadata (this=0x7fb0040dfe98, list=..., flags=4) at /home/travis/src/sql/sql_class.cc:2943
#9 0x000055d00824dc05 in mysql_test_handler_read (stmt=0x7fb004145c20, tables=0x7fb0040df848) at /home/travis/src/sql/sql_prepare.cc:2214
#10 0x000055d00824e288 in check_prepared_statement (stmt=0x7fb004145c20) at /home/travis/src/sql/sql_prepare.cc:2434
#11 0x000055d008251bd6 in Prepared_statement::prepare (this=0x7fb004145c20, packet=0x7fb004016b31 "", packet_len=54) at /home/travis/src/sql/sql_prepare.cc:3963
#12 0x000055d00824e600 in mysqld_stmt_prepare (thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54) at /home/travis/src/sql/sql_prepare.cc:2596
#13 0x000055d00822364f in dispatch_command (command=COM_STMT_PREPARE, thd=0x7fb00400c520, packet=0x7fb004016b31 "", packet_length=54, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1799
#14 0x000055d0082223ca in do_command (thd=0x7fb00400c520) at /home/travis/src/sql/sql_parse.cc:1387
#15 0x000055d008387b71 in do_handle_one_connection (connect=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1402
#16 0x000055d0083878fe in handle_one_connection (arg=0x55d00ca5e1a0) at /home/travis/src/sql/sql_connect.cc:1308
#17 0x00007fb06c819184 in start_thread (arg=0x7fb06850b700) at pthread_create.c:312
#18 0x00007fb06bd2603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111