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

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.