Updated on 2024-01-12 GMT+08:00

Querying Database Error Logs

Function

This API is used to query the latest 2,000 database error logs.

  • Before calling an API, you need to understand the API in Authentication.

URI

  • URI format

    GET /v3/{project_id}/instances/{instance_id}/errorlog?start_date={start_date}&end_date={end_date}

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the ID of the queried DB instance.

    start_date

    Yes

    Specifies the start time in the "yyyy-mm-ddThh:mm:ssZ" format.

    T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset.

    end_date

    Yes

    Specifies the end time in the "yyyy-mm-ddThh:mm:ssZ" format.

    T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset.

    You can only query error logs generated within a month.

    offset

    No

    Specifies the page offset, such as 1, 2, 3, or 4. The parameter value is 1 by default if it is not specified.

    limit

    No

    Specifies the number of records on each page. Its value range is from 1 to 100. The parameter value is 10 by default if it is not specified.

    level

    No

    Specifies the log level. The default value is ALL. Valid value:

    • ALL
    • INFO
    • LOG
    • WARNING
    • ERROR
    • FATAL
    • PANIC
    • NOTE

Request

  • Request parameters

    None

Response

  • Normal response
    Table 2 Parameter description

    Name

    Type

    Description

    error_log_list

    Array of objects

    Indicates detailed information.

    For details, see Table 3.

    total_record

    Integer

    Indicates the total number of records.

    Table 3 error_log_list field data structure description

    Name

    Type

    Description

    time

    String

    Indicates the time in the UTC format.

    level

    String

    Indicates the log level.

    content

    String

    Indicates the log content.

  • Example normal response
    {
    	"error_log_list": [{
    		"time": "2018-12-04T14:24:42",
    		"level": "WARNING",
    		"content": "Occur error when reading bytes from a network handler. Client actively closes the connection."
    	}, {
    		"time": "2018-12-04T14:24:42",
    		"level": "WARNING",
    		"content": "Occur error when reading bytes from a network handler. Client actively closes the connection."
    	}],
    	"total_record": 2
    }
  • Abnormal Response

    For details, see Abnormal Request Results.

Status Code

Error Code

For details, see Error Codes.