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

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.

Comments are closed.

Subscribe to Our Newsletter

Join our community of DevOps enthusiast - Get free tips, advice, and insights from our industry leading team of AWS experts.