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
User Deletion Case
If the query is still present, and it is blocking user deletion:
IMPORTANT: Before proceeding with these actions, please back up your database to ensure no data loss or unintended changes.
- Run the following query to confirm all background queries linked to the user:
select * from lgpBackgroundQueryTable where lgpBackgroundQueryUserId = <user id>;
- If the output matches the rows provided earlier, you can either delete these rows or update their statuses to prevent them from blocking the deletion:
-
Option 1: Delete Linked Queries:
DELETE FROM lgpBackgroundQueryTable WHERE lgpBackgroundQueryUserId = <user id>;
-
Option 2: Update Query Status: If deletion is not preferred, update their statuses instead:
UPDATE lgpBackgroundQueryTable SET lgpBackgroundQueryStatus = 1 WHERE lgpBackgroundQueryUserId = <user id>;
This will set the status to a value that does not affect the deletion process.
-
Option 1: Delete Linked Queries:
- After performing the above steps, please attempt to delete the user again via the MGR GUI.
If the MySQL query does not resolve after the above steps, or user deletion is still failing, please 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