9000 to 9499

These error codes indicate backup, recovery, and STORAGE 3.0 errors.

ERROR 9001 (HY000): URI error

• Error code in OceanBase Database: 9001

• Cause: The destination URL specified for backup and recovery is invalid.

• Solution: Check and modify the backup and recovery configurations.

ERROR 9002 (HY000): OSS file MD5 error

• Error code in OceanBase Database: 9002

• Cause: Data verification of Object Storage Service (OSS) objects failed due to a data error in OSS.

• Solution: Contact OSS Technical Support for troubleshooting.

ERROR 9003 (HY000): OSS error

• Error code in OceanBase Database: 9003

• Cause: An unknown OSS error occurred.

• Solution: Contact OSS Technical Support for troubleshooting.

ERROR 9004 (HY000): Init MD5 fail

• Error code in OceanBase Database: 9004

• Cause: OpenSSL encountered an error when initializing MD5.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9005 (HY000): Out of element

• Error code in OceanBase Database: 9005

• Cause: The number of shards exceeds the upper limit.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9006 (HY000): Update MD5 fail

• Error code in OceanBase Database: 9006

• Cause: The MD5 update failed.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9007 (HY000): Invalid OSS file length

• Error code in OceanBase Database: 9007

• Cause: The length of the OSS object is not supported because the OSS object is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9010 (HY000): OSS file MD5 not match

• Error code in OceanBase Database: 9010

• Cause: An OSS object checksum mismatch occurred due to an OSS data error or a backup and recovery program bug.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9011 (HY000): cannot find backup file

• Error code in OceanBase Database: 9011

• Cause: The backup file is not found because the specified backup and recovery configurations are invalid.

• Solution: Check and modify the backup and recovery configurations.

ERROR 9012 (HY000): Can not get data version from timestamp

• Error code in OceanBase Database: 9012

• Cause: No data version is passed by the logically recovered parameter.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9013 (HY000): Write OSS file error

• Error code in OceanBase Database: 9013

• Cause: The system encountered an error when writing data to the OSS object due to an unknown failure of OSS.

• Solution: Contact OSS Technical Support for troubleshooting.

ERROR 9014 (HY000): Another restore is in progress

• Error code in OceanBase Database: 9014

• Cause: A tenant with the same name as that of the tenant to be recovered exists.

• Solution: Check whether the name of the tenant to be recovered is already used. If yes, specify another name.

ERROR 9016 (HY000): ob cluster name not equal

• Error code in OceanBase Database: 9016

• Cause: The cluster name and URL for the logical backup are inconsistent.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9017 (HY000): rs list invalid

• Error code in OceanBase Database: 9017

• Cause: The specified RootServer list is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9018 (HY000): agent has failed task

• Error code in OceanBase Database: 9018

• Cause: A logical backup task failed.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9019 (HY000): restore partition is compelete

• Error code in OceanBase Database: 9019

• Cause: A recovery task is scheduled for a partition that has been recovered.

• Solution: Troubleshooting is not required.

ERROR 9020 (HY000): restore partition twice

• Error code in OceanBase Database: 9020

• Cause: A recovery task is scheduled for a partition that has been recovered.

• Solution: Troubleshooting is not required.

ERROR 9022 (HY000): physical backup switch is on

• Error code in OceanBase Database: 9022

• Cause: Table deletion is delayed during physical backup.

• Solution: Troubleshooting is not required. The table will be automatically deleted after a physical backup task is completed.

ERROR 9023 (HY000): cannot start log archive backup

• Error code in OceanBase Database: 9023

• Cause: Log backup is in progress.

• Solution: Do not repeatedly initiate log backup.

ERROR 9024 (HY000): log archive backup is already disabled

• Error code in OceanBase Database: 9024

• Cause: A log backup task in the Stopped state cannot be stopped again.

• Solution: Do not attempt to stop a log backup task in the Stopped state.

ERROR 9025 (HY000): log archive backup info not exists

• Error code in OceanBase Database: 9025

• Cause: The log backup file does not exist.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9026 (HY000): backup destination is not valid

• Error code in OceanBase Database: 9026

• Cause: The specified backup destination is invalid.

• Solution: Check the backup_dest parameter and make sure that the path specified for backup_dest is valid.

ERROR 9027 (HY000): ob log archive interrupted

• Error code in OceanBase Database: 9027

• Cause: Log backup is interrupted.

• Solution: Check whether a large number of logs are being written. If not, contact OceanBase Technical Support for troubleshooting.

ERROR 9028 (HY000): ob log archive stat not match

• Error code in OceanBase Database: 9028

• Cause: The log backup status is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9029 (HY000): log archive is not running

• Error code in OceanBase Database: 9029

• Cause: Log backup is not in progress. The OBServer node returns this code when log backup is being stopped.

• Solution: This code does not indicate an error. No manual intervention is required.

ERROR 9030 (HY000): log archive invalid round

• Error code in OceanBase Database: 9030

• Cause: The round information of the log backup task is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9031 (HY000): Cannot backup ob replica

• Error code in OceanBase Database: 9031

• Cause: The replica is being migrated or replicated or is a log-only replica, and therefore cannot be used for data backup.

• Solution: OceanBase Database will automatically retry the operation, and no manual intervention is required.

ERROR 9032 (HY000): backup info not exists

• Error code in OceanBase Database: 9032

• Cause: The backup information does not exist.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9033 (HY000): Backup meta info stored in system dictionary does not match with current system status

• Error code in OceanBase Database: 9033

• Cause: A backup status inconsistency error occurred.

• Solution:

  • If an OBServer log backup error occurs while log backup is being started or stopped, no manual intervention is required.

  • If a RootService log backup error occurs, contact OceanBase Technical Support for troubleshooting.

ERROR 9035 (HY000): restore index failed

• Error code in OceanBase Database: 9035

• Cause: The index rebuild operation failed after the recovery was completed.

• Solution: Find the table index in the error state under the recovered tenant and rebuild the index.

ERROR 9036 (HY000): Backup is in progress

• Error code in OceanBase Database: 9036

• Cause: An operation mutually exclusive with backup was performed.

• Solution: Stop data backup and log backup and perform the operation again.

ERROR 9037 (HY000): log archive status is not valid

• Error code in OceanBase Database: 9037

• Cause: The log backup status is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9038 (HY000): Cannot add replica during set member list in restore

• Error code in OceanBase Database: 9038

• Cause: Replication is not supported in the set member list phase.

• Solution: Replicas cannot be replicated in the set member list phase during recovery. If the majority of replicas exist, the recovery task can continue. If the majority of replicas no longer exist, cancel the current recovery task and schedule a new recovery task.

ERROR 9039 (HY000): pg log archive leader changed

• Error code in OceanBase Database: 9039

• Cause: The leader for log backup has been switched.

• Solution: This is an internal error code. A leader switchover interrupts the log backup process of the current partition group. The new leader will automatically proceed with the backup without the need for manual intervention.

ERROR 9040 (HY000): backup can not start

• Error code in OceanBase Database: 9040

• Cause: The log backup task is not in the DOING state, and data backup cannot be initiated.

• Solution: Wait until the log backup task enters the DOING state. If the log backup task remains in the BEGINNING state, contact OceanBase Technical Support for troubleshooting.

ERROR 9041 (HY000): cancel backup do not allow

• Error code in OceanBase Database: 9041

• Cause: The backup task cannot be repeatedly canceled.

• Solution: Do not repeatedly cancel a task that is being canceled.

ERROR 9042 (HY000): backup data version gap over limit

• Error code in OceanBase Database: 9042

• Cause: Data backup is not completed within 16 rounds of major compactions.

• Solution: Analyze the cause of slow data backup or check whether major compactions are performed too frequently.

ERROR 9044 (HY000): delete backup data is in progress

• Error code in OceanBase Database: 9044

• Cause: The backup cleanup task cannot be repeatedly scheduled.

• Solution: Do not repeatedly schedule the backup cleanup task.

ERROR 9045 (HY000): delete backup set do not allow

• Error code in OceanBase Database: 9045

• Cause: The backup set cannot be deleted.

• Solution: Do not enter the command to delete the backup set.

ERROR 9046 (HY000): backup set id is not valid

• Error code in OceanBase Database: 9046

• Cause: The specified backup set ID is invalid.

• Solution: Specify a valid backup_set_id value and try again.

ERROR 9047 (HY000): invalid password for backup

• Error code in OceanBase Database: 9047

• Cause: The entered password is invalid.

• Solution: Enter the valid password and try again.

ERROR 9048 (HY000): backup set is isolated by two log archive round

• Error code in OceanBase Database: 9048

• Cause: Data backup and log backup are discontinuous.

• Solution: Check whether log backup is interrupted.

ERROR 9049 (HY000): backup status is stopped, can not cancel

• Error code in OceanBase Database: 9049

• Cause: The backup task has been stopped and cannot be canceled again.

• Solution: Troubleshooting is not required.

ERROR 9050 (HY000): no backup data to be backuped up

• Error code in OceanBase Database: 9050

• Cause: No data needs to be backed up by the scheduled backup task.

• Solution: This error usually occurs during backup. Troubleshooting is not required.

ERROR 9051 (HY000): backup mount file is not valid

• Error code in OceanBase Database: 9051

• Cause: The network file system (NFS) is not mounted to some OBServer nodes.

• Solution: Make sure that the NFS is mounted to all OBServer nodes.

ERROR 9052 (HY000): backup clean info not match

• Error code in OceanBase Database: 9052

• Cause: The backup cleanup task encountered a metadata inconsistency error.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9053 (HY000): cancel delete backup do not allow

• Error code in OceanBase Database: 9053

• Cause: The cancel operation is initiated when no cleanup task is available.

• Solution: Do not initiate the cancel operation when no cleanup task is available.

ERROR 9054 (HY000): backup clean info not exists

• Error code in OceanBase Database: 9054

• Cause: The metadata of the backup cleanup task does not exist.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9057 (HY000): can not set backup region, because %s

• Error code in OceanBase Database: 9057

• Cause: The backup region cannot be modified.

• Solution: Record the error message and contact OceanBase Technical Support for troubleshooting.

ERROR 9058 (HY000): can not set backup zone, because %s

• Error code in OceanBase Database: 9058

• Cause: The backup zone cannot be modified.

• Solution: Record the error message and contact OceanBase Technical Support for troubleshooting.

ERROR 9059 (HY000): backup backup has reached max backup times

• Error code in OceanBase Database: 9059

• Cause: An internal error occurred. This code is returned if all the existing backup sets or backup pieces have reached the threshold of backup times during secondary backup scheduling.

• Solution: Troubleshooting is not required.

ERROR 9060 (HY000): COS error

• Error code in OceanBase Database: 9060

• Cause: The module to adapt to Cloud Object Storage (COS) of Tencent Cloud encountered an error.

• Solution: This code is returned if a logic error occurs in the adaptation between OceanBase Database and COS. Contact OceanBase Technical Support for troubleshooting.

ERROR 9061 (HY000): IO limit

• Error code in OceanBase Database: 9061

• Cause: Throttling is triggered on I/O operations. Currently, this code is returned only for the List operation of COS.

• Solution: Contact COS Technical Support to increase or remove the throttling threshold for the List operation.

ERROR 9062 (HY000): reach backup backup copy limit

• Error code in OceanBase Database: 9062

• Cause: When the system schedules secondary backup tasks based on the specified backup times, all backup sets and backup pieces have reached the threshold of backup times, and no backup set or backup piece requires secondary backup.

• Solution: Troubleshooting is not required.

ERROR 9063 (HY000): backup io is prohibited

• Error code in OceanBase Database: 9063

• Cause: Throttling is triggered on the List operation performed during backup and recovery in the COS-based environment.

• Solution:

  • If this error occurs occasionally, troubleshooting is not required.

  • If this error occurs frequently, contact COS Technical Support to increase or remove the throttling threshold for the List operation.

ERROR 9064 (HY000): the archive log and backup data are not continuous

• Error code in OceanBase Database: 9064

• Cause: The archived log data and original backup data are discontinuous.

• Solution:

  • For OceanBase Database V2.2.X, initiate a new major compaction and then a new data backup task.

  • For OceanBase Database V3.1.X and later versions, initiate a new data backup task.

ERROR 9069 (HY000): deleting backup piece is not allowed

• Error code in OceanBase Database: 9069

• Cause: The backup piece cannot be deleted.

• Solution: Do not enter the command to delete the backup set.

ERROR 9072 (HY000): obesi process session conflicts

• Error code in OceanBase Database: 9072

• Cause: The session in the obesi process causes a lock conflict.

• Solution: This is an internal error code for OBServer nodes. Troubleshooting is not required.

ERROR 9073 (HY000): external storage OBS error

• Error code in OceanBase Database: 9073

• Cause: An I/O error occurs when the backup media is Object Storage Service (OBS) of HUAWEI CLOUD.

• Solution: Check the connectivity and privilege settings of OBS.

ERROR 9075 (HY000): obesi process io error

• Error code in OceanBase Database: 9075

• Cause: The status of the independent I/O sub-process of the backup and restoration service is abnormal.

• Solution: This is an internal error code for OBServer nodes. Troubleshooting is not required.

ERROR 9074 (HY000): backup validation task skipped

• Error code in OceanBase Database: 9074

• Cause: The backup set or backup piece is cleared during backup verification.

• Solution: The system automatically skips the verification of this backup set or backup piece. No manual intervention is required.

ERROR 9100 (HY000): no such file or directory

• Error code in OceanBase Database: 9100

• Cause: The specified directory or file is not found in the storage layer. This may be because the configuration is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 9101 (HY000): file or directory already exist

• Error code in OceanBase Database: 9101

• Cause: The specified file or directory already exists.

• Solution: This is an internal error code. It may be returned due to an internal bug. Provide the name of the relevant file to OceanBase Technical Support for troubleshooting.

ERROR 9103 (HY000): too many open files

• Error code in OceanBase Database: 9103

• Cause: The number of open file descriptors (FD) of the file system has reached the upper limit.

• Solution: The system automatically retries the internal logic. No manual intervention is required.