Viewing Logs

Server Logs

By default, HEAVY.AI uses logs with a symbolic link referencing the current HEAVY.AI server instance. These logs are located in the /log directory, which is /var/lib/heavyai/storage in a standard installation. These logs are described below.

heavydb.INFO

This is the best source of information for troubleshooting, and the first place you should check for issues. This log will capture:

• Configuration settings in place when heavydb starts.
• Queries by user and session ID, with execution time (time for query to run) and total time (execution time plus time spent waiting to execute plus network wait time).

heavydb.WARNING

Reports nonfatal warning messages.

heavydb.ERROR

Logs non-fatal error messages, as well as errors related to data ingestion.

heavydb.FATAL

Reports 'check failed' messages and a line number to identify where the error occurred.

Browser-Based Logging

Using Chrome’s Developer Tools, you can interact with data in Immerse to see SQL and response times from heavyDB. The syntax is SQLlogging(true), entered under the console tab inline, as shown below.

Once SQL Logging is turned on, you can interact with the dashboard, see the SQL generated and monitor the response timing involved.

Note: When adding SQLlogging(true) or SQLlogging(false) you need to reload the page for the changes to take effect