Logs for SQL and Server Processes

This article explains how to generate logs for SQL and server processes.

If you open a support case because you are experiencing transaction conflicts, you need to provide logs for the SQL and server process in the database for the time period when the problem occurred.

In on-premises deployments of Exasol 2025.1 and later you can use Exasol Admin to create an archive with logs and other information to include with your support case. For other versions of Exasol you must use EXAsupport.

Prerequisites

You must have enough free disk space for the logs. For more information, see EXAsupport.

Procedure

This procedure uses the c4 and confd_client command-line tools in a Linux terminal. To learn more about these tools, see Exasol Deployment Tool (c4) and ConfD.

  1. Connect to the cluster operating system (COS) using c4 connect -i PLAY_ID -s cos.

    Example:
    Copy 
    ./c4 connect -i c3275f84 -s cos

    For more information about how to use c4 commands, see How to use c4.

  2. To find the database name when you are connected to COS, use the ConfD job db_list.

    Example:
    Copy 
    confd_client db_list
    - MY_DATABASE

  3. To create a SQL server process log, use exasupport -x 1.

    Specify a start date (-s) and end date (-t) using the format YYYY-MM-DD.

    Specify the database name with the option -e. If the database name is omitted, logs are collected from all databases.

    Example:
    Copy 
    exasupport -x 1 -s 2022-08-11 -t 2022-08-11 -e MY_DATABASE

    If a file was successfully created, EXAsupport returns a success message with the file name.

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

  4. Use Control+D or type exit to disconnect from COS.

  5. Copy the file to your local computer by connecting to COS and using the cat command:

    Copy 
    ./c4 connect -t <DEPLOYMENT>.<NODE>/cos -- "cat /exa/tmp/support/$FILENAME" > $FILENAME
    Example:
    Copy 
    ./c4 connect -t 1.11/cos -- "cat /exa/tmp/support/my_log" > my_log

To learn more about how to use EXAsupport, see EXAsupport.

Verification

To verify that the file was successfully copied, use the ls command in the target folder on your local machine.

Example:
Copy 
ls -lahtr ~/mylogs | grep exacluster_debuginfo
-rwxr-xr-x  1 user group 9.8K Sep 20 17:38 exacluster_debuginfo_2022_08_11-23_27_20.tar.gz