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

The following error occurs when using RDS MySQL when you attempt to kill a user session.

MySQL> KILL 46552;
> ERROR 1095 (HY000): You are not owner of thread

In such cases, you can kill the session by calling the rds_kill procedure.

MySQL> CALL mysql.rds_kill(46552);

A separate thread is used for each connection to the MySQL server. Use the mysql.rds_kill procedure to close a connection by providing the connection’s thread ID. Use the MySQL SHOW PROCESSLIST command to find the thread ID.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s