Data Definition Language (DDL) is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. When an admin performs a DDL operation on a table, such as adding a field, modifying a linked field, or enabling history, a DDL table lock prevents other users from making changes until the current change is complete. This lock maintains the integrity of the table's structure and data.
Most DDL table locks will clear without intervention, so using the admin console to clear it with the steps below should be a last resort. There are cases, however, where table remains locked for longer than expected, such as more than a couple of hours.
Consider these best practices to avoid DDL table locks that remain longer than expected:
|
For a lock that does require intervention to clear, complete the following steps:
Take a thread dump and contact Support so a developer can evaluate the log and validate that no DDL operation is in progress. To take a thread dump, run the following command on the server as root or an administrator, substituting the directory where is installed for [AGILOFT_HOME]: [AGILOFT_HOME]/bin/ew-control -d tr
Log into the Admin Console for the server and the run the following script through the bean shell, replacing Table with the knowledgebase table name:
import com.supportwizard.db.ddll.*; |
---|
The Table Name is different from the Table Label—it is the internal knowledgebase name of the table. Navigate to Setup > Table to determine the Table Name. |