Disable Write-Ahead Logging

Required User Role: Root user

Note: This topic assumes a basic understanding of Linux.

If you experience issues with write-ahead logging (WAL), disable WAL by reverting your Tenable Security Center databases to DELETE journaling mode. For more information, see Tenable Security Center Database Journaling Modes.

Before you begin:

  • Perform a backup of Tenable Security Center, as described in Perform a Backup.

To disable WAL:

  1. Log in to Tenable Security Center via the command line interface (CLI).

  2. Stop Tenable Security Center, as described in Start, Stop, or Restart Tenable Security Center.

  3. In the CLI in Tenable Security Center, run the following command to start the converDatabaseMode.php script:

    /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m DELETE

    The script runs.

  4. If the script detects any running tns user processes, repeat the following steps for each tns user process detected:

    1. Follow the prompts in the error output to halt the tns user process.

      Example error output:

      Error! The Tenable Security Center process with PID '10135' is still running and needs to be halted before this script can be executed successfully.

         Command: /opt/sc/support/bin/php -f /opt/sc/daemons/Jobd.php

      Bailing with 146.

    2. Run the following command to restart the converDatabaseMode.php script:

      /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m DELETE

      The script restarts.

    Tenable Security Center converts supported databases to DELETE journaling mode. For more information, see Databases Affected.

  5. Start Tenable Security Center, as described in Start, Stop, or Restart Tenable Security Center.

What to do next:

  • Perform regular backups of Tenable Security Center, as described in Perform a Backup.