Queries the flashback tasks that are performed on a PolarDB-X 1.0 instance.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | DescribeSqlFlashbakTask |
The operation that you want to perform. Set the value to DescribeSqlFlashbakTask. |
DrdsInstanceId | String | Yes | drds****c6vxxyzd |
The ID of the PolarDB-X 1.0 instance. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | 5D64DE59-44A1-E541-E0CB-B7E5C4305162 |
Indicates the ID of the request. |
SqlFlashbackTasks | Array of SqlFlashbackTask |
Indicates the information about flashback tasks. |
|
SqlFlashbackTask | |||
DbName | String | drds_flashback |
Indicates the name of the database on which a flashback task is performed. |
DownloadUrl | String | http://... |
Indicates the download URL. |
ExpireTime | Long | 1569216270000 |
Indicates the time when the download URL expires. |
GmtCreate | Long | 1568611408000 |
Indicates the point in time when the instance was created. |
GmtModified | Long | 1568611469000 |
Indicates the point in time when the flashback task is performed. |
Id | Long | 238 |
Indicates the ID of the primary key that corresponds to a table used in the flashback task. |
InstId | String | drdshbga76p6**** |
Indicates the ID of the instance. |
RecallProgress | Integer | 10 |
Indicates the progress of the reverse call. |
RecallRestoreType | Integer | 1 |
Indicates the type of the flashback task. Valid values:
|
RecallStatus | Integer | 1 |
Indicates the status of the data recall task. |
RecallType | Integer | 1 |
Indicates the type of the reverse call. Valid values:
|
SearchEndTime | Long | 1568509597000 |
Indicates the start time of the reverse call. |
SearchStartTime | Long | 1568609597000 |
Indicates the end time of the reverse call. |
SqlCounter | Long | 0 |
Indicates the number of data rows that are flashed back. |
SqlPk | String | id |
Indicates the primary key specified in the SQL statements. |
SqlType | String | Insert,Update,Delete |
Indicates the types of the SQL statements. |
TableName | String | drds_params |
Indicates the name of the table that contains the data that are flashed back. |
TraceId | String | trace |
Indicates the ID of the trace of the SQL query. |
Success | Boolean | true |
Indicates whether the request is successful. |
Examples
Sample requests
http(s)://[Endpoint]/?Action=DescribeSqlFlashbakTask
&DrdsInstanceId=drds****c6vxxyzd
&<Common request parameters>
Sample success responses
XML
format
<SqlFlashbackTasks>
<SqlFlashbackTask>
<GmtModified>1568611469000</GmtModified>
<SearchEndTime>1568509597000</SearchEndTime>
<RecallStatus>1</RecallStatus>
<SqlPk>id</SqlPk>
<RecallRestoreType>1</RecallRestoreType>
<TableName>drds_params</TableName>
<GmtCreate>1568611408000</GmtCreate>
<SearchStartTime>1568609597000</SearchStartTime>
<InstId>drdshbga76p6****</InstId>
<RecallType>1</RecallType>
<TraceId>trace</TraceId>
<SqlType>Insert,Update,Delete</SqlType>
<DbName>drds_flashback</DbName>
<Id>238</Id>
<ExpireTime>1569216270000</ExpireTime>
<SqlCounter>0</SqlCounter>
<RecallProgress>10</RecallProgress>
<DownloadUrl>http://...</DownloadUrl>
</SqlFlashbackTask>
</SqlFlashbackTasks>
<RequestId>5D64DE59-44A1-E541-E0CB-B7E5C4305162</RequestId>
<Success>true</Success>
JSON
format
{"SqlFlashbackTasks":{"SqlFlashbackTask":[{"GmtModified":"1568611469000","SearchEndTime":"1568509597000","RecallStatus":"1","SqlPk":"id","RecallRestoreType":"1","TableName":"drds_params","GmtCreate":"1568611408000","SearchStartTime":"1568609597000","InstId":"drdshbga76p6****","RecallType":"1","TraceId":"trace","SqlType":"Insert,Update,Delete","DbName":"drds_flashback","Id":"238","ExpireTime":"1569216270000","SqlCounter":"0","RecallProgress":"10","DownloadUrl":"http://..."}]},"RequestId":"5D64DE59-44A1-E541-E0CB-B7E5C4305162","Success":"true"}
Error codes
HttpCode | Error code | Error message | Description |
---|---|---|---|
500 | InternalError | The request processing has failed due to some unknown error. | The error message returned because an internal error has occurred. |
For a list of error codes, visit the API Error Center.