Mengkueri log biner instans ApsaraDB RDS for MySQL atau ApsaraDB RDS for MariaDB, atau log WAL instans ApsaraDB RDS for PostgreSQL.
Deskripsi operasi
Mesin yang didukung
RDS MySQL
RDS PostgreSQL
RDS MariaDB.
Sebelum memulai
Jika DownloadLink bernilai NULL, ApsaraDB RDS tidak menyediakan URL unduhan.
Jika DownloadLink tidak bernilai NULL, Anda dapat menggunakan URL ini untuk mengunduh file cadangan. URL ini memiliki waktu kedaluwarsa yang ditentukan oleh LinkExpiredTime. Unduh file sebelum waktu kedaluwarsa.
Untuk mengunduh file cadangan menggunakan akun pengguna Resource Access Management (RAM), berikan otorisasi kepada pengguna RAM. Untuk detailnya, lihat Memberikan izin kepada pengguna RAM hanya baca untuk mengunduh file cadangan.
Daftar log yang dikembalikan mencakup semua catatan log yang waktu akhir catatan lognya lebih lambat dari waktu mulai kueri dan waktu awal catatan lognya lebih awal dari waktu akhir kueri.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
rds:DescribeBinlogFiles |
get |
*DBInstance
|
|
None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| DBInstanceId |
string |
Yes |
ID instans. Anda dapat memanggil DescribeDBInstances untuk mengkueri ID instans. |
rm-uf6wjk5**** |
| StartTime |
string |
Yes |
Awal rentang waktu untuk dikueri. Format: yyyy-MM-ddTHH:mm:ssZ (UTC). |
2011-06-01T15:00:00Z |
| EndTime |
string |
Yes |
Akhir rentang waktu untuk dikueri. Waktu akhir harus lebih lambat daripada waktu mulai. Format: yyyy-MM-ddTHH:mm:ssZ (UTC). |
2011-06-20T15:00:00Z |
| PageSize |
integer |
No |
Jumlah entri per halaman. Nilai valid: 30 hingga 100. Nilai default: 30. |
30 |
| PageNumber |
integer |
No |
Nomor halaman. Nilai valid: bilangan bulat positif bukan nol yang tidak melebihi nilai maksimum tipe data Integer. Nilai default: 1. |
1 |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Parameter tanggapan. |
||
| Items |
object |
||
| BinLogFile |
array<object> |
Daftar detail file log. |
|
|
object |
Detail file log. |
||
| Checksum |
string |
The checksum. The value of this parameter is calculated by using the CRC64 algorithm. |
18358304393468701857 |
| DownloadLink |
string |
The HTTP-based download URL of the log file. If the return value of this parameter is NULL, ApsaraDB RDS does not provide a download URL for the log file. |
http://****.oss.aliyuncs.com/**** |
| FileSize |
integer |
The size of the log file. Unit: bytes. |
2269410 |
| HostInstanceID |
string |
The ID of the instance to which the log file belongs. This parameter helps determine whether the log file is generated on the primary instance or the secondary instance. Catatan
You can log on to the ApsaraDB RDS console and go to the instance details page. In the left-side navigation pane, click Service Availability to view the values of Primary Instance No. and Secondary Instance No.. |
584**** |
| IntranetDownloadLink |
string |
The URL that is used to download files over an internal network. |
http://****.oss-cn-hangzhou-internal.aliyuncs.com/**** |
| LinkExpiredTime |
string |
The expiration time of the URL. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2013-06-09T18:00:00Z |
| LogBeginTime |
string |
The beginning of the time range to query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2019-02-09T17:45:21Z |
| LogEndTime |
string |
The end of the time range to query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2019-02-15T13:10:28Z |
| LogFileName |
string |
The log file name. |
000000040000000000000019 |
| RemoteStatus |
string |
The status of the log file that is stored in the Object Storage Service (OSS) bucket. Valid values:
Valid values:
|
Completed |
| PageNumber |
integer |
Nomor halaman. |
1 |
| PageRecordCount |
integer |
Jumlah file log pada halaman saat ini. |
30 |
| RequestId |
string |
ID permintaan. |
ED169A3E-1657-4104-82AB-24EA8CD0DB75 |
| TotalFileSize |
integer |
Ukuran total file log. |
2269410 |
| TotalRecordCount |
integer |
Jumlah total file log. |
100 |
Contoh
Respons sukses
JSONformat
{
"Items": {
"BinLogFile": [
{
"Checksum": "18358304393468701857",
"DownloadLink": "http://****.oss.aliyuncs.com/****",
"FileSize": 2269410,
"HostInstanceID": "584****",
"IntranetDownloadLink": "http://****.oss-cn-hangzhou-internal.aliyuncs.com/****",
"LinkExpiredTime": "2013-06-09T18:00:00Z",
"LogBeginTime": "2019-02-09T17:45:21Z",
"LogEndTime": "2019-02-15T13:10:28Z",
"LogFileName": "000000040000000000000019",
"RemoteStatus": "Completed"
}
]
},
"PageNumber": 1,
"PageRecordCount": 30,
"RequestId": "ED169A3E-1657-4104-82AB-24EA8CD0DB75",
"TotalFileSize": 2269410,
"TotalRecordCount": 100
}
Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | ParameterLeastAssociate | Must input at least one optional parameter. | |
| 400 | InvalidParameters.Format | Specified parameter is not valid | |
| 400 | ParameterAbsence | Necessary parameter is absence. | |
| 400 | ServiceTemporarilyClosed | Service temporarily closed. | |
| 400 | ReadDBInstanceNotSupport | The operation is not permitted due to type of the instance. | |
| 400 | InvalidStartTime.Format | Specified start time is not valid. | |
| 400 | InvalidEndTime.Format | Specified end time is not valid. | |
| 400 | InvalidParameterCombination | The end time must be greater than the start time | |
| 400 | Order.ComboInstanceNotAllowOperate | A package instance is not allowed to operate independently. | |
| 400 | Price.PricingPlanResultNotFound | Pricing plan price result not found. | |
| 400 | Order.NoRealNameAuthentication | You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication. | |
| 400 | InsufficientAvailableQuota | Your account quota limit is less than 0, please recharge before trying to purchase. | |
| 400 | CommodityServiceCalling.Exception | Failed to call commodity service. | |
| 400 | RegionDissolvedEOM | Dear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support. | |
| 400 | Commodity.InvalidComponent | The module you purchased is not legal, please buy it again. | |
| 400 | RegionEndTimeDissolvedAustralia | Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024. | |
| 400 | Price.CommoditySys | Commodity system call exception. | |
| 400 | Pay.InsufficientBalance | Insufficient available balance. | |
| 400 | Order.PeriodInvalid | There is a problem with the period you selected, please choose again. | |
| 400 | pay.noCreditCard | Account not bound to credit card. | |
| 400 | Order.InstHasUnpaidOrder | There is an unpaid order for the service you have purchased. Please pay or void it before placing the order. | |
| 400 | noAvailablePaymentMethod | No payment method is specified for your account. We recommend that you add a payment method. | |
| 400 | BasicInfoUncompleted | Your information is incomplete. Complete your information before the operation. | |
| 400 | Risk.RiskControlRejection | Your account is abnormal, please contact customer service for details. | |
| 400 | Api.NotSupport | Specified api is not supported. | |
| 400 | ContainForbiddenLabelError | There is a label that prohibits placing orders. Please contact your distributor for assistance. | |
| 400 | InvalidDBInstanceId.NotFound | The DBInstanceId provided does not exist in records. | |
| 400 | InvalidInstanceLevel.DiskType | Specified instance level not support request disk type | |
| 400 | InvalidParam | Sepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica. | |
| 400 | KmsApiError | User secret key invalid. | |
| 400 | System.SaleValidateFailed | Sales expression validation system error. | |
| 400 | Abs.InvalidAccount.NotFound | account is not found. | |
| 400 | SqlExecuteFailedOrTimeout | sql command execution failed or timed out:%s. | |
| 400 | ColdData.EngineVersionNotSupport | The current instance engine version not support coldDataEnabled. | |
| 400 | ColdData.MinorVersionNotSupport | The current instance minor version not support coldDataEnabled. | |
| 400 | IncorrectTargetClasscode | The current instance type does not support this operation. | |
| 400 | InvalidConnectionString.Duplicate | Specified connection string already exists in the RDS. | |
| 400 | RequiredParam.NotFound | Required input param is not found. | |
| 400 | Parameters.Invalid | Parameter error, please check the parameters. | |
| 400 | BackupPolicyNotSupport | Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy. | |
| 400 | InvalideStatus.Format | The instance status does not support this operation. | |
| 400 | InvalidReleasedKeepPolicy.Format | Specified Released Keep Policy is not valid. | |
| 400 | InvalidDBInstanceEngineType.Format | the DB instance engine type does not support this operation. | |
| 400 | Pay.NoCreditCard | No credit cards. | |
| 400 | VpcNetworkTypeNotSupport | The vpc network type instance does not support this operation. | |
| 400 | MirrorInsExists | Specified DB instance mirror ins already existed. | |
| 400 | UnsupportedClassCode | The specified DB instance class stops selling. | |
| 400 | InvalidBackupSet | The specified database does not exist in the backup set. | |
| 400 | OrdTCommodityQueryError | Failed to query for product. | |
| 400 | ProductInstanceReleased | The instance has been released. Please check before placing the order. | |
| 400 | RegionEndTimeDissolvedIndia | The region is no longer supported. | |
| 500 | ExternalFailure | The request processing has failed due to external service failure. | |
| 500 | RequestMetaDataFailed | The service request failed. Please try again later or contact service personnel. | |
| 500 | InvokeProxyFailure | The request processing has failed due to service failure of rds api. | |
| 403 | IncorrectDBInstanceEngine | Current DB Instance engine does not support this operation. | |
| 403 | IncorrectDBInstanceCharacterType | Current DB Instance character_type does not support this operation. | |
| 403 | IncorrectDBInstanceState | Current DB instance state does not support this operation. | |
| 403 | IncorrectDBInstanceLockMode | Current DB instance lock mode does not support this operation. | |
| 403 | OrderStatus.UnPaid | The specified db instance has unpaid order. | |
| 403 | InvalidReduceDiskSize | The storage capacity after the scale-down must be larger than the used amount. | |
| 403 | CloudSSDNotSupport | Cloud ssd does not support this operation, please upgrade to essd. | |
| 403 | InvalidUserOperatorPermission | The user permission does not support this operation. | |
| 403 | InvalidVswitchId | Specified conn vswitch id is not valid. | |
| 403 | IncorrectMinorVersion | Current engine minor version does not support operations. | |
| 403 | OperationDenied.ZoneResource | There is no available zone for inventory. | |
| 403 | NotInFlowController | Sorry,no permission. | |
| 403 | InvalidKmsKey | Kms key is disabled. | |
| 403 | InvalidInstanceLevel.Malformed | Current DB instance level does not support this operation. | |
| 404 | InvalidDBInstance.NotFound | Specified instance does not exist or not support. | |
| 404 | InvalidClusterKms | The current instance does not authorized to access the Key Management Service. | |
| 404 | Request.NotFound | The requested resource is not available. | |
| 404 | HostInfo.NotFound | The specified host info is not found. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.