Queries the flashback tasks that are performed on a PolarDB-X instance.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DescribeSqlFlashbackTaskList

The operation that you want to perform. Set the value to DescribeSqlFlashbackTaskList.

RegionId String Yes cn-hangzhou

The ID of the region where the instance is deployed.

PolardbxInstanceId String Yes pxc-**********

The ID of the PolarDB-X instance.

Response parameters

Parameter Type Example Description
RequestId String 9B2F3840-5C98-475C-B269-2D5C3A31797C

The ID of the request.

Message String OK

The result of the request.

Success Boolean true

Indicates whether the operation is successful.

Data Object

The data that is returned.

SqlFlashbackTasks Array of SqlFlashbackTasks

The information about flashback tasks.

GmtModified String 1568611469000

The most recent point in time when the flashback task flashed back data in the database. Unit: milliseconds.

SearchEndTime String 1568609597000

The end of the time range that you specified to search SQL queries when you created the flashback task. Unit: millisecond.

RecallStatus String 1

The status of the flashback task.

  • 1: in progress
  • 2: completed
SqlPk String id

The primary key field that is specified in the SQL statements whose operation results you want to flash back.

RecallRestoreType String 0

The type of the flashback task. Valid values:

  • 1: image restoration
  • 2: reverse restoration
TableName String test

The name of the table that contains the data that are flashed back.

GmtCreate String 1568611408000

The point in time when the flashback task was created. Unit: milliseconds.

InstId String pxc-********

The ID of the PolarDB-X instance.

SearchStartTime String 1568609597000

The beginning of the time range that you specified to search SQL queries when you created the flashback task. Unit: milliseconds.

RecallType String 0

The search method to query SQL queries. Valid values:

  • 0: term search
  • 1: fuzzy search
TraceId String 13ed05705f801000

The ID of the trace of the SQL query.

DbName String test

The name of the PolarDB-X database on which the flashback task is performed.

SqlType String INSERT,UPDATE

The types of SQL queries. Valid values: INSERT, UPDATE, and DELETE. Multiple types are separated with commas (,).

Id String 111

The ID of the primary key.

ExpireTime String 1569216270000

The point in time when the download URL of the file that contains the results of the flashback task expires. Unit: milliseconds.

SqlCounter String 100

The number of data rows that are flashed back.

RecallProgress String 10

The progress of the flashback task. Valid values: 1 to 100.

DownloadUrl String http://...

The download URL of the file that contains the results of the flashback task.

Examples

Sample requests

http(s)://[Endpoint]/?Action=DescribeSqlFlashbackTaskList
&RegionId=cn-hangzhou
&PolardbxInstanceId=pxc-**********
&<Common request parameters>

Sample success responses

XML format 

HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeSqlFlashbackTaskListResponse>
    <RequestId>9B2F3840-5C98-475C-B269-2D5C3A31797C</RequestId>
    <Message>OK</Message>
    <Success>true</Success>
    <Data>
        <SqlFlashbackTasks>
            <GmtModified>1568611469000</GmtModified>
            <SearchEndTime>1568609597000</SearchEndTime>
            <RecallStatus>1</RecallStatus>
            <SqlPk>id</SqlPk>
            <RecallRestoreType>0</RecallRestoreType>
            <TableName>test</TableName>
            <GmtCreate>1568611408000</GmtCreate>
            <InstId>pxc-********</InstId>
            <SearchStartTime>1568609597000</SearchStartTime>
            <RecallType>0</RecallType>
            <TraceId>13ed05705f801000</TraceId>
            <DbName>test</DbName>
            <SqlType>INSERT,UPDATE</SqlType>
            <Id>111</Id>
            <ExpireTime>1569216270000</ExpireTime>
            <SqlCounter>100</SqlCounter>
            <RecallProgress>10</RecallProgress>
            <DownloadUrl>http://...</DownloadUrl>
        </SqlFlashbackTasks>
    </Data>
</DescribeSqlFlashbackTaskListResponse>

JSON format 

HTTP/1.1 200 OK
Content-Type:application/json

{
  "RequestId" : "9B2F3840-5C98-475C-B269-2D5C3A31797C",
  "Message" : "OK",
  "Success" : true,
  "Data" : {
    "SqlFlashbackTasks" : [ {
      "GmtModified" : "1568611469000",
      "SearchEndTime" : "1568609597000",
      "RecallStatus" : "1",
      "SqlPk" : "id",
      "RecallRestoreType" : "0",
      "TableName" : "test",
      "GmtCreate" : "1568611408000",
      "InstId" : "pxc-********",
      "SearchStartTime" : "1568609597000",
      "RecallType" : "0",
      "TraceId" : "13ed05705f801000",
      "DbName" : "test",
      "SqlType" : "INSERT,UPDATE",
      "Id" : "111",
      "ExpireTime" : "1569216270000",
      "SqlCounter" : "100",
      "RecallProgress" : "10",
      "DownloadUrl" : "http://..."
    } ]
  }
}

Error codes

For a list of error codes, visit the API Error Center.