Monitoring WarehousePG Log Files v6.27.4

Suggest edits

Know the location and content of system log files and monitor them on a regular basis and not just when problems arise.

The following table shows the locations of the various WarehousePG log files. In file paths:

  • $GPADMIN_HOME refers to the home directory of the gpadmin operating system user.
  • $MASTER_DATA_DIRECTORY refers to the coordinator data directory on the WarehousePG coordinator host.
  • $GPDATA_DIR refers to a data directory on the WarehousePG segment host.
  • host identifies the WarehousePG segment host name.
  • segprefix identifies the segment prefix.
  • N identifies the segment instance number.
  • date is a date in the format YYYYMMDD.
PathDescription
$GPADMIN_HOME/gpAdminLogs/*Many different types of log files, directory on each server. $GPADMIN_HOME is the default location for the gpAdminLogs/ directory. You can specify a different location when you run an administrative utility command.
$GPADMIN_HOME/gpAdminLogs/gpinitsystem_date.logsystem initialization log
$GPADMIN_HOME/gpAdminLogs/gpstart_date.logstart log
$GPADMIN_HOME/gpAdminLogs/gpstop_date.logstop log
$GPADMIN_HOME/gpAdminLogs/gpsegstart.py_host:gpadmin_date.logsegment host start log
$GPADMIN_HOME/gpAdminLogs/gpsegstop.py_host:gpadmin_date.logsegment host stop log
$MASTER_DATA_DIRECTORY/log/startup.log, $GPDATA_DIR/segprefixN/log/startup.logsegment instance start log
$MASTER_DATA_DIRECTORY/log/*.csv, $GPDATA_DIR/segprefixN/log/*.csvcoordinator and segment database logs
$GPDATA_DIR/mirror/segprefixN/log/*.csvmirror segment database logs
$GPDATA_DIR/primary/segprefixN/log/*.csvprimary segment database logs
/var/log/messagesGlobal Linux system messages

Use gplogfilter -t (--trouble) first to search the coordinator log for messages beginning with ERROR:, FATAL:, or PANIC:. Messages beginning with WARNING may also provide useful information.

To search log files on the segment hosts, use the WarehousePG gplogfilter utility with gpssh to connect to segment hosts from the coordinator host. You can identify corresponding log entries in segment logs by the statement_id.

WarehousePG can be configured to rotate database logs based on the size and/or age of the current log file. The log_rotation_size configuration parameter sets the size of an individual log file that triggers rotation. When the current log file size is equal to or greater than this size, the file is closed and a new log file is created. The log_rotation_age configuration parameter specifies the age of the current log file that triggers rotation. When the specified time has elapsed since the current log file was created, a new log file is created. The default log_rotation_age, 1d, creates a new log file 24 hours after the current log file was created.

Parent topic: System Monitoring and Maintenance

← Prev

Managing Bloat in a Database

↑ Up

System Monitoring and Maintenance

Next →

Loading Data