Updated on 2024-04-11 GMT+08:00

Viewing and Downloading Error Logs

Scenarios

Error logs contain logs generated while the database is running. These can help you analyze problems with the database. You can also download error logs for service analysis.

Viewing Log Details

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, click Log Details to view details about error logs.

    Figure 1 Error log details
    • You can select a log level in the upper right corner of the log list.

      For RDS for PostgreSQL DB instances, the following levels of logs are displayed:

      • All log levels
      • ERROR
      • FATAL
      • PANIC
    • You can click in the upper right corner to view error logs generated in different time segments.
    • If the description of a log is truncated, locate the log and move your pointer over the description in the Description column to view details.
    • Currently, a maximum of 2,000 error log records can be displayed.

Downloading a Log

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, click Download. In the log list, locate a log whose status is Preparation completed and click Download in the Operation column.

    Figure 2 Downloading an error log
    • The system automatically loads the downloading preparation tasks. The loading duration is determined by the log file size and network environment.
      • When the log is being prepared for download, the log status is Preparing.
      • When the log is ready for download, the log status is Preparation completed.
      • If the preparation for download fails, the log status is Abnormal.

      Logs in the Preparing or Abnormal status cannot be downloaded.

    • Only the latest log file of no more than 40 MB can be downloaded.
    • The download link is valid for 5 minutes. After the download link expires, a message is displayed indicating that the download link has expired. If you need to redownload the log, click OK.

Enabling Error Log Reporting to LTS

To use this function, contact customer service to apply for required permissions.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance name.
  5. In the navigation pane, click Logs. On the Error Logs page, click Log Details.
  6. Click next to Report Error Logs to LTS.
  7. Select an LTS log group and log stream and click OK.

    Figure 3 Enabling error log reporting to LTS