tested, but not reproduced on 10.2, 10.3 server
There is an issue when reusing multiple time COM_STMT_EXECUTE.
Join to this issue are 2 files (sql + java test) to reproduced the issue.
Executing multiple time the same query on different connection with same parameters sometimes return a strange first resultset binary row.
First row content is normally :
+--------------------------------------------------+
|
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
|
+--------------------------------------------------+------------------+
|
| 91 00 00 11 00 00 F8 00 13 31 31 38 32 39 36 31 | .........1182961 |
|
| 30 39 38 34 35 31 39 38 38 34 38 32 13 31 31 36 | 098451988482.116 |
|
| 32 35 33 33 33 37 30 36 38 37 30 30 34 36 37 33 | 2533370687004673 |
|
| 01 01 01 24 33 65 30 30 39 31 65 65 2D 39 31 30 | ...$3e0091ee-910 |
|
| 35 2D 31 31 65 61 2D 38 32 66 30 2D 30 30 35 30 | 5-11ea-82f0-0050 |
|
| 35 36 38 64 36 62 62 61 0A 00 00 00 00 00 00 00 | 568d6bba........ |
|
| 3C 00 00 00 00 00 00 00 24 33 65 30 30 39 32 30 | <.......$3e00920 |
|
| 37 2D 39 31 30 35 2D 31 31 65 61 2D 38 32 66 30 | 7-9105-11ea-82f0 |
|
| 2D 30 30 35 30 35 36 38 64 36 62 62 61 01 00 00 | -0050568d6bba... |
|
| 00 00 00 00 00 | ..... |
|
+--------------------------------------------------+------------------+
|
but sometime is :
+--------------------------------------------------+
|
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
|
+--------------------------------------------------+------------------+
|
| 4C 00 00 11 00 00 00 00 00 00 00 00 00 00 00 00 | L............... |
|
| 00 00 00 00 00 01 3C 00 00 00 00 00 00 00 24 33 | ......<.......$3 |
|
| 65 30 31 31 38 62 64 2D 39 31 30 35 2D 31 31 65 | e0118bd-9105-11e |
|
| 61 2D 38 32 66 30 2D 30 30 35 30 35 36 38 64 36 | a-82f0-0050568d6 |
|
| 62 62 61 00 00 00 00 00 04 00 00 00 00 00 00 00 | bba............. |
|
+--------------------------------------------------+------------------+
|
{"report":{"fcp":1173.699999999255,"ttfb":251.19999999925494,"pageVisibility":"visible","entityId":86944,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"7d4a7841-8f89-4381-a3cc-8b218ed43b50","navigationType":0,"readyForUser":1275.5,"redirectCount":0,"resourceLoadedEnd":1469.699999999255,"resourceLoadedStart":265.80000000074506,"resourceTiming":[{"duration":222.39999999850988,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":265.80000000074506,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":265.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":488.19999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":224,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":266.0999999977648,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":266.0999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":490.0999999977648,"responseStart":0,"secureConnectionStart":0},{"duration":332.19999999925494,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":266.19999999925494,"connectEnd":266.19999999925494,"connectStart":266.19999999925494,"domainLookupEnd":266.19999999925494,"domainLookupStart":266.19999999925494,"fetchStart":266.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":266.19999999925494,"responseEnd":598.3999999985099,"responseStart":598.3999999985099,"secureConnectionStart":266.19999999925494},{"duration":528.4000000022352,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":266.3999999985099,"connectEnd":266.3999999985099,"connectStart":266.3999999985099,"domainLookupEnd":266.3999999985099,"domainLookupStart":266.3999999985099,"fetchStart":266.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":266.3999999985099,"responseEnd":794.8000000007451,"responseStart":794.8000000007451,"secureConnectionStart":266.3999999985099},{"duration":333.70000000298023,"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":266.5999999977648,"connectEnd":266.5999999977648,"connectStart":266.5999999977648,"domainLookupEnd":266.5999999977648,"domainLookupStart":266.5999999977648,"fetchStart":266.5999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":266.5999999977648,"responseEnd":600.3000000007451,"responseStart":600.3000000007451,"secureConnectionStart":266.5999999977648},{"duration":229.10000000149012,"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":266.69999999925494,"connectEnd":266.69999999925494,"connectStart":266.69999999925494,"domainLookupEnd":266.69999999925494,"domainLookupStart":266.69999999925494,"fetchStart":266.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":266.69999999925494,"responseEnd":495.80000000074506,"responseStart":495.80000000074506,"secureConnectionStart":266.69999999925494},{"duration":235.19999999925494,"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":267,"connectEnd":267,"connectStart":267,"domainLookupEnd":267,"domainLookupStart":267,"fetchStart":267,"redirectEnd":0,"redirectStart":0,"requestStart":267,"responseEnd":502.19999999925494,"responseStart":502.19999999925494,"secureConnectionStart":267},{"duration":242.40000000223517,"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":267.0999999977648,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.0999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":509.5,"responseStart":0,"secureConnectionStart":0},{"duration":533.0999999977648,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":267.30000000074506,"connectEnd":267.30000000074506,"connectStart":267.30000000074506,"domainLookupEnd":267.30000000074506,"domainLookupStart":267.30000000074506,"fetchStart":267.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":267.30000000074506,"responseEnd":800.3999999985099,"responseStart":800.3999999985099,"secureConnectionStart":267.30000000074506},{"duration":534.5999999977648,"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":267.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":802.0999999977648,"responseStart":0,"secureConnectionStart":0},{"duration":538.9000000022352,"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":267.5999999977648,"connectEnd":267.5999999977648,"connectStart":267.5999999977648,"domainLookupEnd":267.5999999977648,"domainLookupStart":267.5999999977648,"fetchStart":267.5999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":267.5999999977648,"responseEnd":806.5,"responseStart":806.5,"secureConnectionStart":267.5999999977648},{"duration":652.9000000022352,"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":273.8999999985099,"connectEnd":273.8999999985099,"connectStart":273.8999999985099,"domainLookupEnd":273.8999999985099,"domainLookupStart":273.8999999985099,"fetchStart":273.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":273.8999999985099,"responseEnd":926.8000000007451,"responseStart":926.8000000007451,"secureConnectionStart":273.8999999985099},{"duration":1145.199999999255,"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":274.19999999925494,"connectEnd":274.19999999925494,"connectStart":274.19999999925494,"domainLookupEnd":274.19999999925494,"domainLookupStart":274.19999999925494,"fetchStart":274.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":274.19999999925494,"responseEnd":1419.3999999985099,"responseStart":1419.3999999985099,"secureConnectionStart":274.19999999925494},{"duration":128.59999999776483,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":746.8000000007451,"connectEnd":746.8000000007451,"connectStart":746.8000000007451,"domainLookupEnd":746.8000000007451,"domainLookupStart":746.8000000007451,"fetchStart":746.8000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":746.8000000007451,"responseEnd":875.3999999985099,"responseStart":875.3999999985099,"secureConnectionStart":746.8000000007451},{"duration":303.8999999985099,"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","startTime":1114.800000000745,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1114.800000000745,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1418.699999999255,"responseStart":0,"secureConnectionStart":0},{"duration":309.80000000074506,"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","startTime":1116.199999999255,"connectEnd":1116.199999999255,"connectStart":1116.199999999255,"domainLookupEnd":1116.199999999255,"domainLookupStart":1116.199999999255,"fetchStart":1116.199999999255,"redirectEnd":0,"redirectStart":0,"requestStart":1116.199999999255,"responseEnd":1426,"responseStart":1426,"secureConnectionStart":1116.199999999255},{"duration":353.1000000014901,"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","startTime":1116.5999999977648,"connectEnd":1116.5999999977648,"connectStart":1116.5999999977648,"domainLookupEnd":1116.5999999977648,"domainLookupStart":1116.5999999977648,"fetchStart":1116.5999999977648,"redirectEnd":0,"redirectStart":0,"requestStart":1426.3999999985099,"responseEnd":1469.699999999255,"responseStart":1443.199999999255,"secureConnectionStart":1116.5999999977648},{"duration":311.80000000074506,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1164.199999999255,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1164.199999999255,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1476,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":15,"domainLookupEnd":62,"connectStart":62,"connectEnd":90,"secureConnectionStart":71,"requestStart":91,"responseStart":251,"responseEnd":270,"domLoading":256,"domInteractive":1477,"domContentLoadedEventStart":1477,"domContentLoadedEventEnd":1524,"domComplete":1761,"loadEventStart":1761,"loadEventEnd":1761,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1424.5},{"name":"bigPipe.sidebar-id.end","time":1425.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1425.5999999977648},{"name":"bigPipe.activity-panel-pipe-id.end","time":1426.3999999985099},{"name":"activityTabFullyLoaded","time":1539.300000000745}],"measures":[],"correlationId":"d420332d3d64c9","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Closing, since not reproduced on any version 10.5 -> 11.4, unix/windows with test case