Queries the flashback tasks that are performed on a PolarDB-X instance.
Debugging
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.
|
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:
|
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:
|
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.