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?

Improve this question

1 Answer 1

Reset to default
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
2
  • How did you end killing the query?
    – nbari
    Apr 24, 2019 at 14:13
  • @nbari I couldn't, I waited until it finished.
    – dbdemon
    Apr 24, 2019 at 15:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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