Overview

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"

Solution

SSH the MGR node as root user and run the following commands to identify and kill the MySQL query that is hanging -

mysql --login-path=mysql_root
show processlist;
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 -

/usr/TextPass/bin/tp_mgr_stop
/usr/TextPass/bin/tp_mgr_start

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