Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.6
On merge to 10.6, the test case of MDEV-25197
10.6 a1e70388c45a0908c35443ba1df93ea8502b727a with the merge of 6c3e860cbf36831c118f6ea183acbbeb3c889bed
main.ps [ fail ]
Test ended at 2021-04-14 12:13:47
CURRENT_TEST: main.ps
/dev/shm/10.6a/client/mysqltest: Error on delete of '/dev/shm/10.6a/mysql-test/var/tmp/f1.txt' (Errcode: 2 "No such file or directory")
mysqltest: At line 5029: query 'EXECUTE stmt' failed: 2013: Lost connection to MySQL server during query
...
2021-04-14 12:13:45 5 [Note] Deleted Master_info file '/dev/shm/10.6a/mysql-test/var/mysqld.1/data/relay-log.info'.
mariadbd: /mariadb/10.6/sql/protocol.cc:1138: bool should_send_column_info(THD*, List<Item>*, uint): Assertion `cmd == COM_STMT_EXECUTE || cmd == COM_STMT_PREPARE' failed.
...
#8 0x000055a0b8cce61a in should_send_column_info (thd=0x62b0002ca218, list=list@entry=0x62b00007ffe0, flags=flags@entry=3) at /mariadb/10.6/sql/protocol.cc:1138
#9 0x000055a0b8cd5d9e in Protocol::send_result_set_metadata (this=0x62b0002ca800, list=<optimized out>, flags=<optimized out>) at /mariadb/10.6/sql/protocol.cc:1176
#10 0x000055a0b8e590eb in select_send::send_result_set_metadata (this=0x62b000080c30, list=<optimized out>, flags=<optimized out>) at /mariadb/10.6/sql/sql_class.cc:2975
#11 0x000055a0b9131bc6 in JOIN::exec_inner (this=this@entry=0x62b0002d1418) at /mariadb/10.6/sql/sql_select.cc:4336
#12 0x000055a0b913309f in JOIN::exec (this=this@entry=0x62b0002d1418) at /mariadb/10.6/sql/sql_select.cc:4273
#13 0x000055a0b912e08a in mysql_select (thd=thd@entry=0x62b0002ca218, tables=0x0, fields=@0x62b00007ffe0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x62b0000803e0, last = 0x62b0000803e0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x62b000080c30, unit=0x62b00007e310, select_lex=0x62b00007fe90) at /mariadb/10.6/sql/sql_select.cc:4749
#14 0x000055a0b912ee11 in handle_select (thd=thd@entry=0x62b0002ca218, lex=lex@entry=0x62b00007e248, result=result@entry=0x62b000080c30, setup_tables_done_option=setup_tables_done_option@entry=0) at /mariadb/10.6/sql/sql_select.cc:419
#15 0x000055a0b8f9c9a3 in execute_sqlcom_select (thd=thd@entry=0x62b0002ca218, all_tables=<optimized out>) at /mariadb/10.6/sql/sql_parse.cc:6244
#16 0x000055a0b8fc2ab9 in mysql_execute_command (thd=0x62b0002ca218) at /mariadb/10.6/sql/sql_parse.cc:3940
#17 0x000055a0b9012e2f in Prepared_statement::execute (this=this@entry=0x619000155998, expanded_query=expanded_query@entry=0x7fd8e4496d30, open_cursor=open_cursor@entry=false) at /mariadb/10.6/sql/sql_prepare.cc:5049
#18 0x000055a0b901398c in Prepared_statement::execute_loop (this=this@entry=0x619000155998, expanded_query=expanded_query@entry=0x7fd8e4496d30, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /mariadb/10.6/sql/sql_prepare.cc:4511
#19 0x000055a0b90148fb in mysql_sql_stmt_execute (thd=thd@entry=0x62b0002ca218) at /mariadb/10.6/sql/sql_prepare.cc:3579
#20 0x000055a0b8fc2b23 in mysql_execute_command (thd=thd@entry=0x62b0002ca218) at /mariadb/10.6/sql/sql_parse.cc:3956
#21 0x000055a0b8fd2a32 in mysql_parse (thd=thd@entry=0x62b0002ca218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fd8e4497b30) at /mariadb/10.6/sql/sql_parse.cc:8017
#22 0x000055a0b8fd9d3c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b0002ca218, packet=packet@entry=0x629000285219 "EXECUTE stmt", packet_length=packet_length@entry=12, blocking=blocking@entry=true) at /mariadb/10.6/sql/sql_parse.cc:1897
I will temporarily disable this part of the test in 10.6 so that the merge can proceed.
relates to
MDEV-25197
The statement set password=password('') executed in PS mode fails in case it is run by a user with expired password
Closed
{"report":{"fcp":938.9000000953674,"ttfb":132.90000009536743,"pageVisibility":"visible","entityId":98798,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d7d826dc-57cb-4e89-a401-0d66d7d7411e","navigationType":0,"readyForUser":995.8000001907349,"redirectCount":0,"resourceLoadedEnd":1155.6000001430511,"resourceLoadedStart":138.5,"resourceTiming":[{"duration":366,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":138.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":504.5,"responseStart":0,"secureConnectionStart":0},{"duration":365.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":138.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":504.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":374.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":139,"connectEnd":139,"connectStart":139,"domainLookupEnd":139,"domainLookupStart":139,"fetchStart":139,"redirectEnd":0,"redirectStart":0,"requestStart":139,"responseEnd":513.4000000953674,"responseStart":513.4000000953674,"secureConnectionStart":139},{"duration":402.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":139.10000014305115,"connectEnd":139.10000014305115,"connectStart":139.10000014305115,"domainLookupEnd":139.10000014305115,"domainLookupStart":139.10000014305115,"fetchStart":139.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":139.10000014305115,"responseEnd":541.2000000476837,"responseStart":541.2000000476837,"secureConnectionStart":139.10000014305115},{"duration":398.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":139.10000014305115,"connectEnd":139.10000014305115,"connectStart":139.10000014305115,"domainLookupEnd":139.10000014305115,"domainLookupStart":139.10000014305115,"fetchStart":139.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":139.10000014305115,"responseEnd":537.6000001430511,"responseStart":537.6000001430511,"secureConnectionStart":139.10000014305115},{"duration":402.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":139.30000019073486,"connectEnd":139.30000019073486,"connectStart":139.30000019073486,"domainLookupEnd":139.30000019073486,"domainLookupStart":139.30000019073486,"fetchStart":139.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":139.30000019073486,"responseEnd":542.1000001430511,"responseStart":542.1000001430511,"secureConnectionStart":139.30000019073486},{"duration":403.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":139.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":139.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":543.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":403.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":139.40000009536743,"connectEnd":139.40000009536743,"connectStart":139.40000009536743,"domainLookupEnd":139.40000009536743,"domainLookupStart":139.40000009536743,"fetchStart":139.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":139.40000009536743,"responseEnd":542.8000001907349,"responseStart":542.8000001907349,"secureConnectionStart":139.40000009536743},{"duration":403.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":139.5,"connectEnd":139.5,"connectStart":139.5,"domainLookupEnd":139.5,"domainLookupStart":139.5,"fetchStart":139.5,"redirectEnd":0,"redirectStart":0,"requestStart":139.5,"responseEnd":543.3000001907349,"responseStart":543.3000001907349,"secureConnectionStart":139.5},{"duration":403.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":139.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":139.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":543.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":404,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":139.80000019073486,"connectEnd":139.80000019073486,"connectStart":139.80000019073486,"domainLookupEnd":139.80000019073486,"domainLookupStart":139.80000019073486,"fetchStart":139.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":139.80000019073486,"responseEnd":543.8000001907349,"responseStart":543.8000001907349,"secureConnectionStart":139.80000019073486},{"duration":795.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":140.5,"connectEnd":140.5,"connectStart":140.5,"domainLookupEnd":140.5,"domainLookupStart":140.5,"fetchStart":140.5,"redirectEnd":0,"redirectStart":0,"requestStart":140.5,"responseEnd":936.3000001907349,"responseStart":936.3000001907349,"secureConnectionStart":140.5},{"duration":1010.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":144.80000019073486,"connectEnd":144.80000019073486,"connectStart":144.80000019073486,"domainLookupEnd":144.80000019073486,"domainLookupStart":144.80000019073486,"fetchStart":144.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":144.80000019073486,"responseEnd":1155.6000001430511,"responseStart":1155.5,"secureConnectionStart":144.80000019073486},{"duration":300.60000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":744.5,"connectEnd":744.5,"connectStart":744.5,"domainLookupEnd":744.5,"domainLookupStart":744.5,"fetchStart":744.5,"redirectEnd":0,"redirectStart":0,"requestStart":744.5,"responseEnd":1045.1000001430511,"responseStart":1045.1000001430511,"secureConnectionStart":744.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":2,"responseStart":133,"responseEnd":137,"domLoading":136,"domInteractive":1171,"domContentLoadedEventStart":1171,"domContentLoadedEventEnd":1204,"domComplete":1995,"loadEventStart":1995,"loadEventEnd":1997,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1160},{"name":"bigPipe.sidebar-id.end","time":1160.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1160.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1163.2000000476837},{"name":"activityTabFullyLoaded","time":1211.2000000476837}],"measures":[],"correlationId":"4ae8db0154c383","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":78,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Blocker
