Cannot stop MemSQL nodes while a cluster upgrade is in progress


#1

I tried to upgrade memsql to 6.8.3 using memsql ops but I believe it went through a bug what I want now is to stop the upgrade becasue I can’t start. stop or restart it without stopping the upgrade as it gave me the following error:
Cannot stop MemSQL nodes while a cluster upgrade is in progress


#2

Hi alashrafy,

You may have long running queries that are preventing your upgrade from proceeding. If your upgrade isn’t complete by now, you can run the SHOW PROCESSLIST command to see the threads containing the long running queries. Then run the KILL CONNECTION command to kill these threads. The links below provide more information on both commands.

https://docs.memsql.com/sql-reference/v6.8/show-processlist/
https://docs.memsql.com/sql-reference/v6.8/kill-connection/

Scott