2

I did an ALTER TABLE on a huge table on a MariaDB Galera Cluster 10.2, but after a while of waiting I changed my mind and tried to kill the connection. However, MariaDB said ERROR 1095 (HY000): You are not owner of thread 123 even though I most definitely am the owner. So what is going on?

5

The error message is misleading. Galera can mark user threads as high priority which means they can't be killed. Currently, this gives the ERROR 1095 (HY000): You are not owner of thread... See MDEV-12008 for details.

This will probably affect other distributions of Galera as well, such as Percona XtraDB Cluster.

|improve this answer|||||
  • How did you end killing the query? – nbari Apr 24 '19 at 14:13
  • @nbari I couldn't, I waited until it finished. – dbdemon Apr 24 '19 at 15:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.