KB-1530 How to kill queries initiated from phpMyAdmin

Purpose

Long-running queries initiated from the phpMyAdmin interface and the Appian application may cause database performance issues. This article outlines how to kill such offending queries.

Instructions

  1. Open the phpMyAdmin interface. If the interface is unresponsive, try opening it in a new browser type (e.g. Edge, Firefox, etc) or Chrome Incognito. If the interface is still unresponsive, create a case with Appian Technical Support.
  2. Execute the following command from the SQL tab of phpMyAdmin.
    1. Appian 21.4 and later: CALL AppianProcess.getFullProcessList();
    2. Appian 21.3 and earlier: CALL AppianProcess.getMyProcessList();
  3. A list of processes initiated by the Appian application, phpMyAdmin interface and Stored Procedures will be displayed. The 'Time' column will display how long (in seconds) a particular query has been running in the system. Copy the ID of the offending process.
  4. Kill the offending process using the process ID and the following command.
    1. Appian 21.4 and later: CALL AppianProcess.killProcess(<ID>);
    2. Appian 21.3 and earlier: kill "<ID>";

Note: In Appian 21.3 and earlier, these instructions will only show the database processes that were started from within phpMyAdmin by the same user for that session. It will not show any hung processes started from within Appian, such as those initiated via a!query() or the Query Database smart service, as well as processes that were started during a previous session.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: June 2022

Related
Recommended