You are unable to execute new queries on MGR because an old query has been stuck for a long time (i.e. 2 months in the example below). You are executing the query on MGR GUI and not on textpass.
The LGP background query was working well before.
When you try to delete the MGR GUI background query, you get "Item #: 28 - Error: Cannot delete the "In Progress' Query"
SSH the MGR node as root user and run the following commands to identify and kill the MySQL query that is hanging -
kill <process id #>
Go back to MGR GUI and refresh the LGP background query list. If the query is still there, restart the MGR.
As root user execute the following commands -
If the MySQL query does not resolve after the above steps, contact NewNet Support and include the following information:
- syslog (/var/log/messages) from MGR and LGP nodes
- MySQL error logs from both MGR (/data/mysqldata/.err) and LGP (/dblgp/mysqldata/.err)
- show full processlist; from MySQL on MGR and LGP nodes