Updated on 2024-10-24 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.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target instance name.
  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.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target instance name.
  5. In the navigation pane on the left, choose Logs. On the Error Logs page, click Downloads. 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
    • It is recommended that a single log file to be downloaded contain a maximum of 10,000 lines and the file size be no more than 10 MB. Otherwise, the log information will be truncated.
    • 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 40 MB to 100 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

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target 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