How To: Resolve Crashed Table Messages for the Internal InterWorx Database

How the Issue May Manifest

  • NodeWorx and SiteWorx are inaccessible via the GUI, with either a generic error message, if debug is disabled, or showing a stacktrace that mentions a crashed table if debug is enabled

  • Logging stating that there is a crashed table for the iworxdb appears in ~iworx/var/log/iworx.log. Example:

    2025-06-10 09:10:25.35824 [nosess-55k6-44x1-WEB] [EMERG] : BEGIN STACKTRACE 1 - from logAnother in IWorx_Exception : /nodeworx/index
2025-06-10 09:10:25.35888 [nosess-55k6-44x1-WEB] [INFO] : EXCEPTION: IWorx_Exception_DbUtil : /nodeworx/index
2025-06-10 09:10:25.35909 [nosess-55k6-44x1-WEB] [INFO] : EXCEPTION: DB Error: unknown error SELECT config_value FROM config c : /nodeworx/index
2025-06-10 09:10:25.35921 [nosess-55k6-44x1-WEB] [INFO] : INNER JOIN config_types t ON t.id = c.type_id : /nodeworx/index
2025-06-10 09:10:25.35935 [nosess-55k6-44x1-WEB] [INFO] : WHERE t.type_name = 'server' : /nodeworx/index
2025-06-10 09:10:25.35949 [nosess-55k6-44x1-WEB] [INFO] : AND c.config_key = 'manager' : /nodeworx/index
2025-06-10 09:10:25.35963 [nosess-55k6-44x1-WEB] [INFO] : AND c.config_name = 'UI_IS_DARK_MODE' [nativecode=144 ** Table './iworx/config' is marked as crashed and last (automatic?) repair failed] in /usr/local/interworx/include/IWorxDbUtil.php line 414 : /nodeworx/index
2025-06-10 09:10:25.35983 [nosess-55k6-44x1-WEB] [EMERG] : DB Error: unknown error SELECT config_value FROM config c : /nodeworx/index
2025-06-10 09:10:25.35998 [nosess-55k6-44x1-WEB] [EMERG] : INNER JOIN config_types t ON t.id = c.type_id : /nodeworx/index
2025-06-10 09:10:25.36012 [nosess-55k6-44x1-WEB] [EMERG] : WHERE t.type_name = 'server' : /nodeworx/index
2025-06-10 09:10:25.36026 [nosess-55k6-44x1-WEB] [EMERG] : AND c.config_key = 'manager' : /nodeworx/index
2025-06-10 09:10:25.36041 [nosess-55k6-44x1-WEB] [EMERG] : AND c.config_name = 'UI_IS_DARK_MODE' [nativecode=144 ** Table './iworx/config' is marked as crashed and last (automatic?) repair failed] : /nodeworx/index

How to Resolve

  1. Log in to the server at the CLI as root, either via SSH or from the terminal

  2. At the CLI, run the following command–this will attempt to repair any crashed tables in the iworxdb:

    ~iworx/bin/iworxdb_tuneup.pex