• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. API Reference
  4. API v1
  5. Log Information Queries
  6. Querying Database Error Logs

Querying Database Error Logs

Function

This API is used to query database error logs.

URI

  • URI format

    PATH: /rds/{versionId}/{project_id}/instances/{instanceId}/errorlog

    Method: GET

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    versionId

    Yes

    Specifies the API version. It is case-sensitive and the value is v1.

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    instanceId

    Yes

    Specifies the ID of the queried DB instance.

Request

  • Parameter description
    Table 2 Parameter description

    Name

    Mandatory

    Description

    startDate

    Yes

    Specifies the start time following a specified time translation rule. For example, time "2016-08-29+06:35" is translated into "2016-08-29+06%3A35", where "%3A" is translated from ":" and other digits and characters remain unchanged.

    endDate

    Yes

    Specifies the end time following a specified time translation rule. For example, time "2016-08-29+06:35" is translated into "2016-08-29+06%3A35", where "%3A" is translated from ":" and other digits and characters remain unchanged.

    You can only query error logs generated within a month.

    curPage

    No

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

    perPage

    No

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

  • Request example
    /rds/v1/68e3010955d748099f62a0df726fe09b/instances/02cf1fd7-24ae-4fec-a621-329ec732e4f6/errorlog?startDate=2016-08-29+06%3A35&endDate=2016-09-05+06%3A35&curPage=1&perPage=10

Normal Response

  • Parameter description
    Table 3 Parameter description

    Name

    Type

    Description

    errorLogList

    List data structure. For details, see Table 4.

    Indicates detailed information.

    totalRecord

    Int

    Indicates the total number of records.

    Table 4 errorLogList field data structure description

    Name

    Type

    Description

    datetime

    String

    Indicates the date and time.

    content

    String

    Indicates the log content.

  • Response example
    {
        "errorLogList": [
            {
                "datetime": "2016-08-30 09:55:39",
                "content": "[Warning] 'proxies_priv' entry '@ root@rds-bf83' ignored in --skip-name-resolve mode."
            }
        ],
        "totalRecord":1
    }

Abnormal Response

For details, see Abnormal Request Results.