Blog

ERROR 1095 (HY000): You are not owner of thread

Jun 11, 2013 | Announcements, Migration, MSP

I tried to kill query on AWS RDS today and I got an error saying “ERROR 1095 (HY000): You are not owner of thread” , even though I was using the admin account for RDS. As the error suggests, in order to kill it, you need to be the process owner. You can get the info from show processlist;

show processlist;
+------+--------------+-------------------------------------------------+--------------+-------------+------+-----------------------------------------------------------------------+------------------+
| Id   | User         | Host                                            | db           | Command     | Time | State                                                                 | Info             |
+------+--------------+-------------------------------------------------+--------------+-------------+------+-----------------------------------------------------------------------+------------------+
|    4 | test     | localhost:28368                                 | NULL         | Sleep       |   13 |                                                                       | NULL             |

In this example this query is running under user test. So you can login using user test and then you should be able to kill it.  There might be a way to update the permissions for the admin user, but  RDS  is pretty locked down so I am not sure if AWS allows you to do that.

GET SUBSCRIBED

nClouds
nClouds is a cloud-native services company that helps organizations maximize site uptime, performance, stability, and support, bringing out the best of their people and technology using AWS