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

  • 1: image restoration
  • 2: reverse restoration
RecallStatus Integer 1

Indicates the status of the data recall task.

RecallType Integer 1

Indicates the type of the reverse call. Valid values:

  • 0: exact search
  • 1: fuzzy search
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.