This range indicates backup and restore error codes and STORAGE 3.0 error codes.
ERROR 9001 (HY000): URI error
OceanBase error code: 9001
Cause: The destination link specified in the backup and restore settings may be incorrect.
Solution: Check the backup and restore configurations and modify them as needed.
ERROR 9002 (HY000): OSS file MD5 error
OceanBase error code: 9002
Cause: Data verification for the OSS file failed. This may indicate an abnormality with the data on OSS.
Solution: Contact OSS technical support to investigate the specific cause.
ERROR 9003 (HY000): OSS error
OceanBase error code: 9003
Cause: An unknown error occurred in OSS.
Solution: Contact OSS technical support to investigate the specific cause.
ERROR 9004 (HY000): Init MD5 fail
OceanBase error code: 9004
Cause: OpenSSL initialization MD5 error.
Solution: Contact OceanBase technical support for assistance in troubleshooting.
ERROR 9005 (HY000): Out of element
OceanBase error code: 9005
Cause: Exceeded the shard limit.
Solution: Contact OceanBase technical support for assistance in troubleshooting.
ERROR 9006 (HY000): Update MD5 fail
OceanBase error code: 9006
Cause: MD5 update failed.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9007 (HY000): Invalid OSS file length
OceanBase error code: 9007
Cause: The OSS file length is invalid, possibly due to an incorrect OSS file.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9010 (HY000): OSS file MD5 not match
OceanBase error code: 9010
Cause: The OSS file checksum does not match, possibly due to abnormal OSS data or a bug in the backup and recovery program.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9011 (HY000): cannot find backup file
OceanBase error code: 9011
Cause: The backup file cannot be found, possibly due to incorrect backup and recovery configuration.
Solution: Check the backup and recovery configurations and modify them as needed.
ERROR 9012 (HY000): Can not get data version from timestamp
OceanBase error code: 9012
Cause: The
data versionparameter is not passed in logical restore.Solution: Contact OceanBase Technical Support for assistance.
ERROR 9013 (HY000): Write OSS file error
OceanBase error code: 9013
Cause: An exception occurred while writing to the OSS file, possibly due to an unknown issue with OSS.
Solution: Contact OSS Technical Support to investigate the specific cause.
ERROR 9014 (HY000): Another restore is in progress
OceanBase error code: 9014
Cause: A tenant with the same name already exists for the tenant to be restored.
Solution: Check whether the username of the tenant to be restored is duplicated. If so, use a non-duplicated tenant name.
ERROR 9016 (HY000): ob cluster name not equal
OceanBase error code: 9016
Cause: The cluster name and URL do not match for the logical backup.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9017 (HY000): rs list invalid
OceanBase error code: 9017
Cause: The RS list is invalid, possibly due to an incorrect specified RS list.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9018 (HY000): agent has failed task
OceanBase error code: 9018
Cause: There are failed tasks in the logical backup.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9019 (HY000): restore partition is complete
OceanBase error code: 9019
Cause: A restore task has been repeatedly scheduled for a partition that has already been restored.
Solution: No action required.
ERROR 9020 (HY000 ): restore partition twice
OceanBase error code: 9020
Cause: A restore task has been repeatedly scheduled for a partition that has already been restored.
Solution: No action required.
ERROR 9022 (HY000): physical backup switch is on
OceanBase error code: 9022
Cause: Tables are delayed for deletion during physical backup.
Solution: No action is required. The files will be automatically deleted after physical backup is completed.
ERROR 9023 (HY000): cannot start log archive backup
OceanBase error code: 9023
Cause: Log archiving cannot be re-enabled during log archiving.
Solution: Avoid repeatedly scheduling commands to enable log archiving.
ERROR 9024 (HY000): log archive backup is already disabled
OceanBase error code: 9024
Cause: Log archiving cannot be re-disabled during the Stop phase.
Solution: Avoid repeatedly disabling log archiving if it is already disabled.
ERROR 9025 (HY000): log archive backup info not exists
OceanBase error code: 9025
Cause: The file containing log archive information does not exist.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9026 (HY000): %s is not a valid uri
OceanBase error code: 9026
Cause: The backup destination is invalid.
Solution: Check whether the backup
backup_destis reasonable and provide a validbackup_destpath.
ERROR 9027 (HY000): ob log archive interrupted
OceanBase error code: 9027
Cause: Log archiving was interrupted.
Solution: Check whether a large volume of writes caused log archiving to be overwhelmed. If not, contact OceanBase Technical Support for assistance.
ERROR 9028 (HY000): ob log archive stat not match
OceanBase error code: 9028
Error cause: The status of log archiving does not match.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9029 (HY000): log archive is not running
OceanBase error code: 9029
Error cause: Log archiving is not running. This error is typically printed by the OBServer node when stopping backup.
Solution: No manual intervention is required. Just exit the log archiving error log normally.
ERROR 9030 (HY000): log archive invalid round
OceanBase error code: 9030
Error cause: The round information for log archiving is incorrect.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9031 (HY000): Cannot backup ob replica
OceanBase error code: 9031
Error cause: The replica is currently migrating or has a log replica, and cannot provide data backup capability.
Solution: OceanBase Database will retry internally; no manual intervention is needed.
ERROR 9032 (HY000): backup info not exists
OceanBase error code: 9032
Error cause: Backup information does not exist.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9033 (HY000): Backup meta info stored in system dictionary does not match with current system status
OceanBase error code: 9033
Error cause: Backup status is inconsistent.
Solution:
If an error occurs during log archiving on an OBServer node, it usually happens when starting or stopping log archiving and does not require manual intervention.
For logs of the root service, contact OceanBase Technical Support to investigate the specific cause.
ERROR 9035 (HY000): restore index failed
OceanBase error code: 9035
Error cause: Index rebuilding failed after restore completion.
Solution: Check for indexes with a lock status of
erroron internal tables within the restored tenant and recreate those indexes.
ERROR 9036 (HY000): Backup is in progress
OceanBase error code: 9036
Error cause: Generally, an operation that is mutually exclusive with backup is being performed.
Solution: Stop data backup and log archiving before executing this command.
ERROR 9037 (HY000): log archive status is not valid
OceanBase error code: 9037
Error cause: The log archive status is invalid.
Solution: Contact OceanBase Technical Support for assistance in troubleshooting.
ERROR 9038 (HY000): Cannot add replica during set member list in restore
OceanBase error code: 9038
Cause: Replication is not supported during the
set member listphase.Solution: The
set member liststep of restore does not support replica replication. If a majority of replicas still exist, the restore can continue. If no majority replicas remain, you must cancel the restore and reschedule the restore task.
ERROR 9039 (HY000): pg log archive leader changed
OceanBase error code: 9039
Cause: The log archive leader has switched.
Solution: This is an internal error code. Detection of a leader switch interrupts the current PostgreSQL log archiving process. The new leader will automatically resume the backup work without requiring operational intervention.
ERROR 9040 (HY000): backup can not start
OceanBase error code: 9040
Cause: Data backup cannot be started if log archiving is not in the
DOINGstate.Solution: Wait for log archiving to enter the
DOINGstate. If it remains in theBEGINNINGstate for a long time, contact OceanBase Technical Support to investigate the specific cause.
ERROR 9041 (HY000): cancel backup do not allow
OceanBase error code: 9041
Cause: Canceling a backup task repeatedly is not allowed.
Solution: Avoid repeatedly canceling a task that is already being canceled.
ERROR 9042 (HY000): backup data version gap over limit
OceanBase error code: 9042
Cause: If data backup is not completed within 16 consecutive
Major Merges, it will fail automatically.Solution: Investigate the cause of the slow data backup or confirm whether the
Major Mergesare occurring too frequently.
ERROR 9044 (HY000): delete backup data is in progress
OceanBase error code: 9044
Cause: Re-scheduling a backup cleanup task is not allowed.
Solution: Avoid re-scheduling a backup cleanup task.
ERROR 9045 (HY000): delete backup set do not allow
OceanBase error code: 9045
Error cause: Deletion of the backup set is not allowed.
Solution: Check whether an incorrect deletion command was entered.
ERROR 9046 (HY000): backup set id is not valid
OceanBase error code: 9046
Error cause: The backup set ID is invalid. This may be because an invalid
backup_set_idwas specified.Solution: Check whether the entered
backup_set_idis correct and try again.
ERROR 9047 (HY000): invalid password for backup
OceanBase error code: 9047
Error cause: The password is invalid.
Solution: Check whether the password is correct and try again.
ERROR 9048 (HY000): backup set is isolated by two log archive round
OceanBase error code: 9048
Error cause: Data backup and log archiving are discontinuous.
Solution: Check whether the log archiving has been interrupted.
ERROR 9049 (HY000): backup status is stopped, can not cancel
OceanBase error code: 9049
Error cause: The backup has already stopped and cannot be canceled again.
Solution: No further action is required because the backup has already stopped.
ERROR 9050 (HY000): no backup data to be backuped up
OceanBase error code: 9050
Error cause: The scheduled backup task has no data to back up.
Solution: This typically occurs during a backup scenario and does not require any handling.
ERROR 9051 (HY000): backup mount file is not valid
OceanBase error code: 9051
Cause: There are OBServer nodes that have not mounted NFS.
Solution: Ensure all nodes have mounted NFS.
ERROR 9052 (HY000): backup clean info not match
OceanBase error code: 9052
Cause: The metadata from the backup cleanup is inconsistent.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9053 (HY000): cancel delete backup do not allow
OceanBase error code: 9053
Cause: A
Canceloperation was initiated when no cleanup tasks were present.Solution: Avoid initiating a
Canceloperation when no cleanup tasks are present.
ERROR 9054 (HY000): backup clean info not exists
OceanBase error code: 9054
Cause: The cleanup metadata does not exist.
Solution: Contact OceanBase Technical Support for assistance.
ERROR 9057 (HY000): can not set backup region, because %s
OceanBase error code: 9057
Cause: The backup region cannot be modified.
Solution: Record the error message and contact OceanBase Technical Support for assistance.
ERROR 9058 (HY000): can not set backup zone, because %s
OceanBase error code: 9058
Cause: The backup zone cannot be modified.
Solution: Record the error message and contact OceanBase Technical Support for assistance.
ERROR 9059 (HY000): backup backup has reached max backup times
OceanBase error code: 9059
Cause: Internal error code. This code is primarily used internally during backup scheduling when it is found that neither the backup set nor any backup piece meets the maximum backup times requirement.
Solution: No action required.
ERROR 9060 (HY000): COS error
OceanBase error code: 9060
Cause: An error occurred in the module responsible for Tencent Cloud COS adaptation.
Solution: This is typically a logical error in OceanBase Database's adaptation to COS. You need to contact OceanBase Technical Support.
ERROR 9061 (HY000): IO limit
OceanBase error code: 9061
Cause: This error is caused by I/O limitations. Currently, only the List operation of the Tencent Cloud COS module returns this error code.
Solution: You need to contact COS customer support to increase or remove the rate limiting for List operations.
ERROR 9062 (HY000): reach backup backup copy limit
OceanBase error code: 9062
Cause: When scheduling backups for specified backup times, it is found that all backup_sets and backup_pieces already meet the backup times requirements, and no backup_set or backup_piece to back up is found.
Solution: No action required.
ERROR 9063 (HY000): backup io is prohibited
OceanBase error code: 9063
Cause: The execution of List operations for backup and restore is rate-limited in a COS environment.
Solution:
If this issue occurs occasionally, no action is required.
If this issue occurs frequently, you need to contact the backup COS customer support to increase or remove the frequency limit for List operations.
ERROR 9064 (HY000): the archive log and backup data are not continuous
OceanBase error code: 9064
Cause: The archived log data is discontinuous from the original backup data.
Solution:
For V2.2.X: You need to perform a major compaction again, then initiate a data backup anew.
For V3.1.X and later: Initiate a data backup anew.
ERROR 9065 (HY000): agent has suspended
OceanBase error code: 9065
Cause: This error code is returned for tasks being performed when you suspend the backup feature during logical backup recovery.
Solution: This error code does not affect the functionality. Logical backup will be suspended and can be resumed later.
Note
This error code is introduced in V4.0.0.
ERROR 9066 (HY000): %.*s is conflict with %.*s
OceanBase error code: 9066
Cause: Conflicting values exist.
Solution: Check the conflicting values and ensure they do not conflict with other values.
Note
This error code is introduced in V4.2.1.
ERROR 9069 (HY000): deleting backup piece is not allowed
OceanBase error code: 9069
Cause: Deleting a backup log shard is not allowed.
Solution: Check if an incorrect delete command was entered.
ERROR 9070 (HY000): can not connect to backup destination
OceanBase error code: 9070
Cause: There are OBServer nodes that are not connected to the backup medium, such as NFS not being mounted, or no access permissions for object storage.
Solution: Mount NFS correctly, or set the correct authorization information for object storage or grant the necessary operational permissions.
Note
This error code is introduced in V4.0.0.
ERROR 9071 (HY000): no I/O operation permission at the backup destination
OceanBase error code: 9071
Cause: The OBServer node has no permission to operate on the backup medium.
Solution: Grant the required permissions for the operation.
Note
This error code is introduced in V4.0.0.
ERROR 9072 (HY000): obesi process session conflicts
OceanBase error code: 9072
Cause: Session conflict in the independent sub-process of backup I/O.
Solution: No action is required.
ERROR 9073 (HY000): external storage OBS error
OceanBase error code: 9073
Cause: An error may have occurred at the storage medium level when the backup medium is Huawei Cloud OBS.
Solution: You need to check whether the connection and writing to Huawei Cloud OBS are normal.
ERROR 9074 (HY000): backup validation task skipped
OceanBase error code: 9074
Cause: The backup verification for a tenant is skipped after the tenant is deleted.
Solution: No action is required.
ERROR 9075 (HY000): obesi process io error
OceanBase error code: 9075
Cause: I/O failure during backup or restore due to an abnormal state of the obesi process.
Solution: No action is required.
Note
This error code is introduced in V3.2.4.
ERROR 9076 (HY000): backup meta index does not exist
OceanBase error code: 9076
Cause: The metadata index for the backup data does not exist.
Solution: Contact technical support for assistance.
Note
This error code is introduced in V4.0.0.
ERROR 9077 (HY000): log discontinuous between two archive rounds
OceanBase error code: 9077
Cause: When continuously reading archived logs, the logs from two consecutive archive rounds are discontinuous, making it impossible to read them continuously.
Solution: Contact technical support for assistance.
Note
This error code is introduced in V4.0.0.
ERROR 9078 (HY000): archive log is to end
OceanBase error code: 9078
Cause: The last archive log has been read.
Solution: No action is required.
Note
This error code is introduced in V4.0.0.
ERROR 9079 (HY000): archive log had been recycled
OceanBase error code: 9079
Cause: The archive log has been recycled during continuous reading.
Solution: Contact technical support for assistance.
Note
This error code is introduced in V4.0.0.
ERROR 9080 (HY000): format file does not exist%s
OceanBase error code: 9080
Cause: The format file does not exist.
Solution: Check whether the format file exists at the target location. If not, create it.
Note
The error message is modified from the format file does not exist under the destination to format file does not exist%s in V4.3.0.
ERROR 9081 (HY000): format file does not match%s
OceanBase error code: 9081
Cause: The format file at the target location does not match the expected one.
Solution: Ensure that the format file at the target location matches the expected content.
Note
Starting from V4.3.0, the error message for this code has been adjusted from the content of the format file at the destination does not match to format file does not match%s.
ERROR 9082 (HY000): backup device out of space
OceanBase error code: 9082
Cause: The backup disk has insufficient storage space.
Solution: Expand the backup storage space.
Note
This error code is introduced in V4.0.0.
ERROR 9083 (HY000): the pwrite offset of the object storage is inconsistent
OceanBase error code: 9083
Cause: The offset for appending a write to a file during backup or restore does not match the file length.
Solution: No action required.
Note
This error code is introduced in V4.0.0.
ERROR 9084 (HY000): the contents of pwrite are inconsistent
OceanBase error code: 9084
Cause: The content of a file after an incremental write during backup or restore does not match its existing content.
Solution: No action required.
Note
This error code is introduced in V4.0.0.
ERROR 9085 (HY000): backup major SSTable range not cover minor SSTable
OceanBase error code: 9085
Cause: The range of the backed-up major SSTable does not cover the minor SSTable.
Solution: No action required. The backup will retry internally.
Note
This error code is introduced in V4.0.0.
ERROR 9086 (HY000): backup advance checkpoint by flush timeout
OceanBase error code: 9086
Cause: The backup log stream advancement checkpoint timed out.
Solution: Contact technical support for assistance.
Note
This error code is introduced in V4.0.0.
ERROR 9087(HY000): observer clog is recycled before archive
- OceanBase error code: 9087
- Cause: The archive file has been recycled during consumption and archiving.
Note
This error code is introduced in V4.1.0.
ERROR 9088 (HY000): log restore source tenant state not match, switchover to primary not allowed
- OceanBase error code: 9088
- Cause: The source tenant/log stream status does not match the restored status, preventing the current tenant from switching to primary.
- Solution:
- Check whether the source tenant status and target tenant status match after backup recovery.
- Check whether the primary-standby replication configuration is correct.
- Check whether the source tenant backup is complete and the target tenant recovery is correct.
Note
This error code is introduced in V4.2.0.
ERROR 9089 (HY000): log restore source LS state not match, switchover to primary not allowed
- OceanBase error code: 9089
- Error cause: The source tenant and log stream status do not match for log restore, preventing the current tenant from switching to primary.
- Solution:
- Check whether the source log status and target log status for backup and restore match.
- Check whether the primary-standby replication configuration is correct.
- Check whether the source log backup is complete and the target log restore is correct.
Note
This error code is introduced in V4.2.0.
ERROR 9090 (HY000): obesi process session not exist
OceanBase error code: 9090
Error cause: The OBESI process session does not exist.
Solution: The OBESI process restarts automatically and does not require manual intervention.
Note
This error code is introduced in V4.0.0.
ERROR 9091 (HY000): Already in ARCHIVELOG mode
OceanBase error code: 9091
Error cause: The database is already in ARCHIVELOG mode.
Solution: This status message indicates no action is required.
Note
This error code is introduced in V4.1.0.
ERROR 9092 (HY000): Already in NOARCHIVELOG mode
OceanBase error code: 9092
Error cause: The database is already in NOARCHIVELOG mode.
Solution: This status message indicates no action is required.
Note
This error code is introduced in V4.1.0.
ERROR 9096 (HY000): standby binary version is lower than primary data version, standby need upgrade
- OceanBase error code: 9096
- Cause: The version of the standby database lags behind that of the primary database.
- Solution: Check the versions of the standby and primary databases. You must wait for the standby database to complete the version upgrade.
Note
This error code is introduced in V4.2.0.
ERROR 9097 (HY000): primary tenant has been dropped
- OceanBase error code: 9097
- Error cause: The primary tenant was dropped during primary-standby synchronization.
- Solution: Check the tenant information in the primary database to confirm whether a primary tenant exists.
Note
This error code is introduced in V4.2.0.
ERROR 9098 (HY000): normal object in object_storage(oss,cos,etc.) can't be appended content
- OceanBase error code: 9098
- Error cause: An error occurred when attempting to append content to a regular object in object storage (such as OSS or COS).
- Solution: Check the object storage type and ensure that it supports appending content to regular objects.
Note
This error code is introduced in V4.2.0.
ERROR 9099 (HY000): %s restore failed, %s
OceanBase error code: 9099
Error cause: The restore operation failed.
Solution: Check the restore configuration and parameter settings to ensure they meet the requirements and expectations of the restore target.
Note
This error code is introduced in V4.2.2.
ERROR 9100 (HY000): no such file or directory
OceanBase error code: 9100
Error cause: The storage layer cannot find the corresponding directory or file, possibly due to an issue with the configured storage directory.
Solution: Contact technical support for assistance.
ERROR 9101 (HY000): file or directory already exist
OceanBase error code: 9101
Error cause: The corresponding file or directory already exists.
Solution: This is an internal error code. Contact technical support for assistance.
ERROR 9105 (HY000): S3 error
OceanBase error code: 9105
Cause:
- The input bucket is incorrect.
- The object storage endpoint is invalid.
- An unknown error occurred in S3.
Solution:
- Check whether the input bucket exists.
- Check whether the object storage endpoint configuration is correct. Ensure that the endpoint is correctly configured and the object storage service is accessible.
- If the possibility of a bucket error is ruled out, contact OceanBase Database Technical Support for assistance.
Note
This error code is introduced in V4.3.0.
ERROR 9106 (HY000): Tenant snapshot '%.*s' does not exist
OceanBase error code: 9106
Cause: The specified tenant snapshot does not exist.
Solution: Confirm whether the specified tenant snapshot is correct. If the snapshot does not exist, you may need to create a new snapshot or perform subsequent processing based on the actual situation.
Note
This error code is introduced in V4.3.0.
ERROR 9107 (HY000): Tenant snapshot '%.*s' already exist
OceanBase error code: 9107
Cause: The specified tenant snapshot already exists.
Solution: Confirm whether the specified tenant snapshot already exists. If the snapshot already exists, you may need to perform other operations or proceed with subsequent handling based on the actual circumstances.
Note
This error code is introduced in V4.3.0.
ERROR 9108 (HY000): Tenant snapshot task timeout. %.*s
OceanBase error code: 9108
Cause: The tenant snapshot task timed out.
Solution: Check whether the execution time of the snapshot task is excessively long. You may need to increase the timeout period or optimize the task execution process.
Note
This error code is introduced in V4.3.0.
ERROR 9111 (HY000): Tenant snapshot task failed", "%.*s
OceanBase error code: 9111
Error cause: The tenant snapshot task failed.
Solution: Check the cause of the snapshot task failure and handle it accordingly.
Note
This error code is introduced in V4.3.0.
ERROR 9112 (HY000): Tenant snapshot lock conflict", "%s
OceanBase error code: 9112
Error cause: A lock conflict occurred during the tenant snapshot operation.
Solution: Check the details of the snapshot lock conflict. You may need to release the conflicting snapshot lock or adjust the lock usage.
Note
This error code is introduced in V4.3.0.
ERROR 9113 (HY000): checksum type %s is not supported for the input destination
OceanBase error code: 9113
Error cause: The input destination does not support the %s checksum type.
Solution: Check the checksum type of the input destination and ensure it is a supported type.
Note
This error code is introduced in V4.3.0.
ERROR 9114 (HY000): storage destination is not valid
OceanBase error code: 9114
Error cause: The object storage destination is invalid.
Solution: Check whether the object storage destination is correct and ensure it is a valid destination. You may need to correct the configuration or settings of the object storage destination.
Note
This error code is introduced in V4.3.0.
ERROR 9115 (HY000): can not connect to storage destination
OceanBase error code: 9115
Cause: Unable to connect to the object storage destination.
Solution: Check the connection configuration to the object storage destination and ensure the network connection is normal. You may need to correct the connection configuration, access the object storage key, or resolve network connectivity issues.
Note
This error code is introduced in V4.3.0.
ERROR 9116 (HY000): no I/O operation permission of the object storage
OceanBase error code: 9116
Cause: No I/O operation permission for the object storage.
Solution: Check the permissions for the object storage and ensure you have the correct I/O operation permissions. You may need to adjust the object storage permission settings or contact the administrator to obtain the appropriate permissions.
Note
This error code is introduced in V4.3.0.
ERROR 9117 (HY000): the specified s3_region does not match the endpoint
OceanBase error code: 9117
Cause: The
s3_regionis not specified, or the specifieds3_regiondoes not match the endpoint.Solution: Check whether the specified
s3_regionmatches the endpoint correctly. Ensure the corrects3_regionand corresponding endpoint are used for configuration.
Note
This error code is introduced in V4.3.0.
ERROR 9118 (HY000): object storage endpoint is invalid
OceanBase error code: 9118
Cause: The object storage endpoint is invalid.
Solution: Check whether the object storage endpoint configuration is correct. Ensure the endpoint configuration is correct and the object storage service is accessible.
Note
This error code is introduced in V4.3.0.
ERROR 9129 (HY000): object storage io error
- OceanBase error code: 9129
- Cause: An object storage error code. Common causes include object storage connectivity and compatibility issues.
- Solution: Check the connectivity of object storage. If no connectivity issues are found, contact technical support for assistance.
ERROR 9133 (HY000): Backup zone or backup idc or backup region invalid
OceanBase error code: 9133
Cause: The source Zone/IDC/Region specified for the backup or archive path does not exist (for example, if a cluster has only zones1 and zone2, but you set backup zone to zone=zone3,zone4, this error will be reported when zone3 and zone4 are checked and found to be non-existent).
Solution: Query the
DBA_OB_ZONESview to confirm whether the entered locality exists. Correct it and reset the setting.
Note
This error code is introduced in V4.3.5.
ERROR 9135 (HY000):tmp file exceeds disk quota
OceanBase error code: 9135
Cause: The amount of data from temporary files persisted on disk exceeds the set limit.
Solution: Check whether the SQL statement causing the error generates an unexpected amount of data (for example, if the expected maximum data size for persistent temporary files is 500 GB). If so, adjust the parameter
temporary_file_max_disk_sizeto an appropriate value.
Note
For V4.3.5, this error code is introduced in V4.3.5 BP1.
ERROR 9136 (HY000): Backup missing mview dependent tablet sstable, sstable maybe recycled
OceanBase error code: 9136
Cause: During backup, multi-version major SSTables were recycled.
Solution: Re-initiate the data backup.
Note
This error code is introduced in V4.3.5.
ERROR 9139 (HY000): kms destination is not valid
OceanBase error code: 9139
Cause: When transparent encryption is enabled for the backup tenant, the key address is not specified or is specified incorrectly during tenant restore.
Solution: Specify the correct key address in the restore command, or specify the correct key address by setting the
SET @kms_encrypt_infosession variable before restore.
Note
For V4.3.5, this error code is introduced in V4.3.5 BP2.
ERROR 9140 (HY000): the object is locked by worm
OceanBase error code: 9140
Cause: Attempt to delete or modify an object in the object store that is in the retention period.
Solution: Check whether a retention policy is configured for the backup or archive path, and whether the
enable_wormparameter is correctly configured when setting the backup or archive path. If theenable_wormparameter is correctly configured, contact OceanBase Technical Support for assistance.
Note
For V4.3.5, this error code is introduced in V4.3.5 BP2.
ERROR 9141 (HY000): the resource has been released
OceanBase error code: 9141
Cause: A temporary file macroblock was unexpectedly released during use.
Solution: Contact OceanBase Technical Support for assistance.
Note
For V4.3.5, this error code was introduced in V4.3.5 BP2.
ERROR 9142 (HY000): the object can not be overwritten with different content
OceanBase error code: 9142
Cause: Writing a non-idempotent file with the same name to an object store configured with a retention policy.
Solution: Contact OceanBase Technical Support for assistance.
Note
For V4.3.5, this error code was introduced in V4.3.5 BP2.
ERROR 9144 (HY000): Unexpected macro cache file
OceanBase error code: 9144
Cause: An unexpected file appears in the macroblock cache directory, possibly one created by the user.
Solution: Contact OceanBase Technical Support for assistance.
Note
This error code was introduced in V4.4.0.
ERROR 9147 (HY000): can not access backup set file
OceanBase error code: 9147
Cause: During physical restore execution, the OBServer node cannot access the backup set file in the specified backup medium.
Solution: Check the connectivity of the object store. If no connectivity issues are found, contact Technical Support for assistance.
Note
For V4.4.x, this error code was introduced in V4.4.1.
ERROR 9148 (HY000): disk quota is exceeded
OceanBase error code: 9148
Cause: The disk quota has been exceeded.
Solution: Clean up the files or adjust the disk quota.
Note
For V4.4.x versions, this error code was introduced in V4.4.1.
ERROR 9149 (HY000): backup dest is not allowed to set when log_only policy exists
OceanBase error code: 9149
Cause: The
log_onlycleanup policy applies only to scenarios where only log archiving is enabled and no data backup is performed. When thelog_onlycleanup policy is in effect, configuring a data backup path is not allowed.Solution: First, remove the
log_onlycleanup policy, then configure the data backup path.
Note
For V4.4.x versions, this error code was introduced in V4.4.1.
ERROR 9150 (HY000): log_only policy is not allowed to set when backup dest exists
OceanBase error code: 9150
Cause: The
log_onlycleanup policy applies only to scenarios where only log archiving is enabled and no data backup is performed. When a data backup path is already configured, the cleanup policy cannot be set tolog_only.Solution: To use the
log_onlycleanup policy, you must first delete the configured data backup path.
Note
For V4.4.x versions, this error code was introduced in V4.4.1.
ERROR 9151 (HY000): backup clean can not start, because %s
OceanBase error code: 9151
Cause: Data backup and log archiving cleanup cannot proceed. Possible reasons include the tenant status being non-
NORMAL(e.g.,CREATING,RESTORE) or the tenant not having a cleanup policy configured (for expiration cleanup scenarios).Solution: Check the tenant status. For expiration cleanup scenarios, confirm whether the relevant tenant has a properly configured cleanup policy.
Note
For V4.4.x versions, this error code was introduced in V4.4.1.
ERROR 9152 (HY000): backup device may be not mounted, %s did not read any data written by %s
OceanBase error code: 9152
Error cause: The backup medium is not properly mounted.
Solution: Properly mount the backup medium to ensure all OBServer nodes of the tenant initiating the archiving, backup, or restore operation can access the same backup medium. For detailed operations on mounting NFS, refer to Deploy NFS.
Note
For V4.4.x versions, this error code is introduced in V4.4.1.
ERROR 9153 (HY000): backup device is not read and write strongly consistent. %s did not read the latest data written by %s.
OceanBase error code: 9153
Error cause: The read and write operations on the backup medium are not strongly consistent.
Solution: If the backup medium is NFS, refer to Deploy NFS and mount it as specified. If the backup medium is object storage, contact the corresponding service provider.
Note
For V4.4.x versions, this error code is introduced in V4.4.1.
ERROR 9159 (HY000): available data backup set is not found
OceanBase error code: 9159
Error cause: No backup set is available to restore to the specified time.
Solution: Select a different restore point or specify another backup set path.
Note
For V4.4.2, this error code is introduced in V4.4.2 BP1.
ERROR 9162 (HY000): can not find any backup set or archive piece
OceanBase error code: 9162
Error cause: The specified backup set ID/archive log piece does not exist in the backup path/archive path.
Solution: Check whether the provided path is correct.
Note
For V4.4.2, this error code is introduced in V4.4.2 BP2.
ERROR 9200 (HY000): Extend ssblock file to smaller is not allowed
OceanBase error code: 9200
Cause: The SSBlock file cannot be reduced.
Solution: Check whether the size specified by
ALTER SYSTEM SET datafile_sizeis larger than the current SSBlock file. If so, contact technical support for assistance.
ERROR 9201 (HY000): Mark blocks timeout(5s) in auto extend process when alloc block fail
OceanBase error code: 9201
Cause: Macroblock marking failed after the SSBlock file was automatically extended.
Solution: Contact technical support for assistance.
ERROR 9202 (HY000): Auto extend param is not ready to start extending file
OceanBase error code: 9202
Cause: Automatic expansion may not be enabled due to configuration issues, or the preset disk usage of
datafilehas reached its limit.Solution: Check if the
free_sizefield in the__all_virtual_disk_stattable is 0. If so, disk space is exhausted. You need to increase thedatafilethreshold or perform disk expansion.
