Log Files for SQL Processes

If you are experiencing problems with a specific SQL statement, you need to provide the log files for SQL processes.

Make sure you have enough free disk space for the log. For more information, see EXAsupport.


There are no prerequisites for this procedure.


The ConfD examples are written in Bash on a Linux terminal running the Exasol tool confd_client, which is accessed by connecting to EXAClusterOS on the database nodes using Exasol Deployment Tool (c4). You can also interact with ConfD from an external tool using Python and XML-RPC. For more information, see ConfD.

Placeholder values are indicated with UPPERCASE characters. Replace the placeholders with your own values.

  1. Use the c4 connect command to connect to EXAClusterOS on the database access node. For example:

    c4 connect -t1/cos

    For more information about c4 commands, see Exasol Deployment Tool (c4).

  2. To find the name of the database, use the ConfD job db_list:

    confd_client -c db_list
  3. Do one of the following:

    • To collect information about all SQL processes, use the following command. Make sure to specify the start date (-s) and end date (-t). Dates are in the format YYYY-MM-DD.. For example:
      exasupport -s 2022-08-11 -t 2022-08-11 -e DB_NAME -x2
    • To collect information about a specific SQL process, use the following command. Make sure to specify the start date (-s) and end date (-t). Dates are in the format YYYY-MM-DD. .

      You can only collect SQL logs for a specific session on the same day the session occurred. .

      exasupport -s 2022-08-11 -t 2022-08-11 -e DB_NAME -i SESSION_ID

    If the log file was created successfully, you will see the following message containing the file name:

    Successfully stored debug information into file /exa/tmp/support/exacluster_debuginfo_2022_08_11-23_27_20.tar.gz

  4. To disconnect from EXAClusterOS, type exit or CTRL+D.
  5. The database access node is typically n10. The COS port is typically 20002. To find the database access node's IP address and COS port, use the c4 Show Current Deployments (ps) command. For example:

    c4 ps
  6. Copy the logs to your local computer using a Secure File Copy (scp) command. Use the exact file name and path previously displayed. For example:
    scp -P $COS_PORT -i ~/.ssh/$PEM_FILE.xml root@$DB_ACCESS_NODE_IP:/exa/tmp/support/$EXACLUSTER_FILENAME.tar.gz /path/to/folder/

    If you don't remember your PEM file name, search for the CCC_AWS_KEY_PAIR_FILE value in your config file using the following command: c4 config | grep CCC_AWS_KEY_PAIR_FILE.


To verify the log was successfully copied, use the List Directory Contents (ls) command on your local machine. For example:

ls -lahtr | grep exacluster_debuginfo


-rwxrwxrwx 1 nc nc  2.3G Apr 13 16:59 exacluster_debuginfo_2022_08_11-23_27_20.tar.gz