[MDEV-30558]  ER_KILL_{,QUERY_}DENIED_ERROR - normalize id type Created: 2023-02-03  Updated: 2023-02-16  Resolved: 2023-02-07

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.23
Fix Version/s: 10.11.3, 11.0.1, 10.4.29, 10.5.20, 10.6.13, 10.8.8, 10.9.6, 10.10.4

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-5096 Wrong error message on attempt to kil... Closed

 Description   

https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=powerpc&ver=1%3A10.11.1-2&stamp=1675211870&raw=0

longlong id, printed as %ul

https://github.com/MariaDB/server/commit/35a019837e0290af45962484b4ddc1d6a92ac654

so probably an 32 BE overflow.

main.kill                                w6 [ fail ]
        Test ended at 2023-01-31 20:35:53

CURRENT_TEST: main.kill
— /<<PKGBUILDDIR>>/mysql-test/main/kill.result 2022-11-14 18:10:21.000000000 +0000
+++ /<<PKGBUILDDIR>>/mysql-test/main/kill.reject 2023-01-31 20:35:53.302123393 +0000
@@ -154,7 +154,7 @@
 connection con1;
 connect con5, localhost, u1,,;
 KILL QUERY ID ID;
-ERROR HY000: You are not owner of query ID
+ERROR HY000: You are not owner of query 0

 Comments   
Comment by Otto Kekäläinen [ 2023-02-05 ]

I saw this same issue on a powerpc build at https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=powerpc&ver=1%3A10.11.1-2&stamp=1675211870&raw=0 (tracked downstream in https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1029372).

Generated at Thu Feb 08 10:17:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.