9000 to 9499

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 is 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 be due to 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.

ERROR 9005 (HY000): Out of element

• OceanBase error code: 9005

• Cause: Exceeded the shard limit.

• Solution: Contact OceanBase Technical Support for assistance.

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 restore 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 restore configuration.

• Solution: Check the backup and restore configurations and modify them as needed.

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

• OceanBase error code: 9012

• Cause: The data version parameter 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 unique 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 during physical backup.

• Solution: No action is required. The files will be automatically deleted after the 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 disabled twice during the Stop phase.

• Solution: Avoid 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_dest is valid and provide an available backup_dest path.

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

• 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

• Cause: Log archiving is not running. This error is typically printed by the OBServer node when you stop backup.

• Solution: No manual intervention is required. The error log of log archiving will exit normally.

ERROR 9030 (HY000): log archive invalid round

• OceanBase error code: 9030

• Cause: The round information of log archiving is incorrect.

• Solution: Contact OceanBase Technical Support for assistance.

ERROR 9031 (HY000): Cannot backup ob replica

• OceanBase error code: 9031

• Cause: The replica is migrating replication or log replicas and cannot provide data backup capability.

• Solution: OceanBase Database will retry internally. No manual intervention is required.

ERROR 9032 (HY000): backup info not exists

• OceanBase error code: 9032

• 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

• Cause: The backup status is inconsistent.

• Solution:

  • If an error occurs during log archiving on an OBServer node, which generally happens when starting or stopping log archiving, no manual intervention is required.

  • 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

• Cause: Index rebuilding failed after restore completion.

• Solution: Check for indexes with a lock status of error on internal tables within the restored tenant and recreate those indexes.

ERROR 9036 (HY000): Backup is in progress

• OceanBase error code: 9036

• 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

• 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 list phase.

• Solution: The set member list step 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 initiated if log archiving is not in the DOING state.

• Solution: Wait for log archiving to enter the DOING state. If it remains in the BEGINNING state 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 multiple times 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: Data backup will actively fail if it is not completed within 16 occurrences of a Major Merge.

• Solution: Investigate the reason for the slow data backup or confirm whether Major Merges are 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 repeatedly scheduling a backup cleanup task.

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

• OceanBase error code: 9045

• Cause: Deletion of the backup set is not allowed.

• Solution: Check whether an incorrect delete command was entered.

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

• OceanBase error code: 9046

• Cause: The backup set ID is invalid. This may be because an invalid backup_set_id was specified.

• Solution: Check whether the entered backup_set_id is correct and try again.

ERROR 9047 (HY000): invalid password for backup

• OceanBase error code: 9047

• 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

• 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

• 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 backed up

• OceanBase error code: 9050

• Cause: The scheduled backup task has no data to back up.

• Solution: This usually 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 backup cleanup metadata is inconsistent.

• Solution: Contact OceanBase Technical Support for assistance.

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

• OceanBase error code: 9053

• Cause: A Cancel operation was initiated when no cleanup task existed.

• Solution: Avoid initiating a Cancel operation when no cleanup task exists.

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 usually 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 List throttling.

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 throttled 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 with the original backup data.

• Solution:

  • For V2.2.X: You need to perform a major compaction again and then initiate a data backup anew.

  • For V3.1.X and later versions: 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 pause the backup feature during logical backup and restore.

• Solution: This error code does not affect the functionality. The logical backup will be paused and can be resumed later.

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.

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 media, for example, NFS is not mounted, or object storage access permissions are missing.

• Solution: Mount NFS correctly, or set the correct authorization information for object storage or grant the necessary operational permissions.

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.

ERROR 9072 (HY000): obesi process session conflicts

• OceanBase error code: 9072

• Cause: Session conflict for 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 must check whether the connection to Huawei Cloud OBS is normal and whether writing is 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.

ERROR 9076 (HY000): backup meta index does not exist

• OceanBase error code: 9076

• Cause: The backup data's meta-information index does not exist.

• Solution: Contact technical support for assistance.

ERROR 9077 (HY000): log discontinuous between two archive rounds

• OceanBase error code: 9077

• Cause: When continuously reading archived logs, the logs of two consecutive rounds are discontinuous, making it impossible to read the logs continuously.

• Solution: Contact technical support for assistance.

ERROR 9078 (HY000): archive log is to end

• OceanBase error code: 9078

• Cause: The last archive log has been read consecutively.

• Solution: No action is required.

ERROR 9079 (HY000): archive log had been recycled

• OceanBase error code: 9079

• Cause: The archive log has been recycled during consecutive reading.

• Solution: Contact technical support for assistance.

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.

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 the format file at the target location matches the expected content.

ERROR 9082 (HY000): backup device out of space

• OceanBase error code: 9082

• Cause: Insufficient storage space on the backup disk.

• Solution: Expand the backup storage space.

ERROR 9083 (HY000): the pwrite offset of the object storage is inconsistent

• OceanBase error code: 9083

• Cause: The offset for appending data to the backup or restore file does not match the file length.

• Solution: No action required.

ERROR 9084 (HY000): the contents of pwrite are inconsistent

• OceanBase error code: 9084

• Cause: The content of the appended file during backup or restore does not match the existing file content.

• Solution: No action required.

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.

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.

ERROR 9087(HY000): observer clog is recycled before archive

• OceanBase error code: 9087
• Cause: The archived file has been recycled during consumption and archiving.

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:
  1. Check whether the source tenant status and target tenant status are consistent after backup restoration.
  2. Verify that the primary-standby replication configuration is correct.
  3. Ensure the source tenant's backup is complete and the target tenant's restoration is accurate.

ERROR 9089 (HY000): log restore source LS state not match, switchover to primary not allowed

• OceanBase error code: 9089
• Cause: The source tenant/log stream status does not match the restored status, preventing the current tenant from switching to primary.
• Solution:
  1. Check whether the source log stream status and target log stream status are consistent after backup restoration.
  2. Check whether the primary/secondary replication configuration is correct.
  3. Check whether the source log backup is complete and the target log restore is correct.

ERROR 9090 (HY000): obesi process session not exist

• OceanBase error code: 9090

• Cause: The session of the obesi process does not exist.

• Solution: The obesi process restarts automatically and does not require manual intervention.

ERROR 9091 (HY000): Already in ARCHIVELOG mode

• OceanBase error code: 9091

• Cause: The database is already in ARCHIVELOG mode.

• Solution: This status message indicates no action is required.

ERROR 9092 (HY000): Already in NOARCHIVELOG mode

• OceanBase error code: 9092

• Cause: The database is already in NOARCHIVELOG mode.

• Solution: This status message indicates no action is required.

ERROR 9094 (HY000): Restore log stream failed

• OceanBase error code: 9094

• Cause: Log stream restore failed. The data of the log stream to be restored may be corrupted.

• Solution: Contact technical support for assistance.

ERROR 9095 (HY000): No tablet need backup

• OceanBase error code: 9095

• Cause: No tablets require backup.

• Solution: Contact technical support for assistance.

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.

ERROR 9097 (HY000): primary tenant has been dropped

• OceanBase error code: 9097
• Cause: The primary tenant was dropped during the primary-standby synchronization process.
• Solution: Check the tenant information in the primary database to confirm whether a primary tenant exists.

ERROR 9098 (HY000): normal object in object_storage(oss,cos,etc.) can't be appended content

• OceanBase error code: 9098
• 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 to ensure it supports appending content to regular objects.

ERROR 9099 (HY000): %s restore failed, %s

• OceanBase error code: 9099

• 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.

ERROR 9100 (HY000): no such file or directory

• OceanBase error code: 9100

• 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 in troubleshooting.

ERROR 9101 (HY000): file or directory already exist

• OceanBase error code: 9101

• Cause: The corresponding file or directory already exists.

• Solution: This is an internal error code. Please contact technical support for assistance in troubleshooting.

ERROR 9102 (HY000): file or directory permission denied

• OceanBase error code: 9102

• Cause: No permission to access the file or directory.

• Solution: Contact technical support of OceanBase for assistance in troubleshooting.

ERROR 9103 (HY000): too many open files

• OceanBase error code: 9103

• Cause: The number of File Descriptors (FDs) opened by the file system has reached the upper limit.

• Solution: The internal logic will retry; no manual intervention is required.

ERROR 9104 (HY000): fail to commit direct load

• OceanBase error code: 9104

• Cause: The COMMIT operation failed during direct load, possibly due to a leader switchover.

• Solution: If direct load fails, you can try importing again.

ERROR 9105 (HY000): S3 error

• OceanBase error code: 9105

• Cause:

  1. The input bucket is incorrect.
  2. The object storage endpoint is invalid.
  3. An unknown error occurred in S3.

• Solution:

  1. Check whether the input bucket exists.
  2. Check whether the object storage endpoint is correctly configured. Ensure the endpoint is correctly configured and the object storage service is accessible.
  3. If the possibility of a bucket error is ruled out, contact technical support of OceanBase Database for assistance in troubleshooting.

ERROR 9106 (HY000): Tenant snapshot '%.*s' does not exist

• OceanBase error code: 9106

• Cause: The specified tenant snapshot does not exist.

• Solution: Verify 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.

ERROR 9107 (HY000): Tenant snapshot '%.*s' already exist

• OceanBase error code: 9107

• Cause: The specified tenant snapshot already exists.

• Solution: Verify whether the specified tenant snapshot already exists. If the snapshot already exists, you may need to perform other operations or process it further based on the actual situation.

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 too long. You may need to increase the timeout period or optimize the task execution process.

ERROR 9109 (HY000): Clone tenant timeout. %.*s

• OceanBase error code: 9109

• Cause: The tenant cloning timed out.

• Solution: Check whether the execution time of the tenant cloning is too long. You may need to increase the timeout period or optimize the cloning process.

ERROR 9110 (HY000): Tenant clone job failed", "%.*s

• OceanBase error code: 9110

• Cause: The tenant cloning job failed.

• Solution: Check the cause of the cloning job failure and handle it accordingly.

ERROR 9111 (HY000): Tenant snapshot task failed", "%.*s

• OceanBase error code: 9111

• Cause: The tenant snapshot task failed.

• Solution: Check the cause of the snapshot task failure and handle it accordingly.

ERROR 9112 (HY000): Tenant snapshot lock conflict", "%s

• OceanBase error code: 9112

• Cause: A tenant snapshot lock conflict occurred.

• Solution: Check the details of the snapshot lock conflict. You may need to release the conflicting snapshot lock or adjust the lock usage.

ERROR 9113 (HY000): checksum type %s is not supported for the input destination

• OceanBase error code: 9113

• Cause: The input destination does not support the checksum type %s.

• Solution: Check the checksum type of the input destination and ensure a supported type is used.

ERROR 9114 (HY000): storage destination is not valid

• OceanBase error code: 9114

• 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.

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.

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.

ERROR 9117 (HY000): the specified s3_region does not match the endpoint

• OceanBase error code: 9117

• Cause: The s3_region is not specified, or the specified s3_region does not match the endpoint.

• Solution: Check whether the specified s3_region matches the endpoint correctly. Ensure the correct s3_region and corresponding endpoint are used for configuration.

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 is configured correctly. Ensure that the endpoint is correctly configured and the object storage service is accessible.

ERROR 9119 (HY000): %s

• OceanBase error code: 9119

• Cause: Insufficient data (log archive or data backup) is available to restore to the specified point during data recovery. Possible causes:

  • The data backup set is incomplete, with missing or corrupted backup files.
  • Archive logs are missing, causing the required logs for restoring to the specified point to be discontinuous.
  • The restore point exceeds the range recoverable from the backup set and log archive, attempting to restore to a point without backup or logs.

• Solution:

  • Confirm the restore point.
  • Check the integrity and time range of the backup set.
  • Confirm the continuity of the archive logs.

ERROR 9120 (HY000): cannot find object on object storage

• OceanBase error code: 9120

• Cause: The specified object (file) cannot be found in object storage. Possible causes:

  • The accessed object does not exist.
  • The specified path is incorrect.
  • Insufficient permissions to access object storage.

• Solution:

  • Check whether the accessed object or file exists.
  • Confirm whether the object storage path is configured correctly.
  • Confirm whether the current user has access permissions for object storage.

ERROR 9125 (HY000): ss_micro_cache is disabled

• OceanBase error code: 9125

• Cause: The microblock cache is set to the disable state, and this error code is returned when an upper-layer module accesses the microblock cache.

• Solution: Contact technical support for assistance.

ERROR 9126 (HY000): ss_micro_cache has reached memory limit

• OceanBase error code: 9126

• Cause: The memory used by the microblock cache has reached the threshold, preventing the allocation of metadata for newly cached microblocks.

• Solution: Normally, this does not affect system operation and can be ignored.

ERROR 9129 (HY000): object storage io error

• OceanBase error code: 9129
• Cause: An object storage error code. Common causes include connectivity and compatibility issues with object storage.
• Solution: Check the connectivity of object storage. If no connectivity issues are found, contact technical support for assistance.

ERROR 9130 (HY000): the pwrite offset of the object storage is inconsistent

• OceanBase error code: 9130

• Cause: When performing an Append operation in object storage, the provided offset is inconsistent with the current length of the object.

• Solution: Contact technical support for assistance.

ERROR 9131 (HY000): the contents of pwrite are inconsistent

• OceanBase error code: 9131

• Cause: When performing an Append operation in object storage, if the provided offset is smaller than the current object length for some reason, a Get request is initiated to read the overlapping content. An error is reported if the content is inconsistent.

• Solution: Contact technical support for assistance.

ERROR 9132 (HY000): object storage data checksum error

• OceanBase error code: 9132

• Cause: An object storage data checksum error.

• Solution: An internal error code. 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 for the specified backup or archive path does not exist (for example, if the cluster only has zones1 and zone2, but the user sets the backup zone as zone=zone3,zone4, and then checks shows that zone3 and zone4 do not exist, this error will be reported).

• Solution: Query the DBA_OB_ZONES view to confirm whether the entered locality exists. Correct it and set it again.

ERROR 9134 (HY000): tmp file has already sealed

• OceanBase error code: 9134

• Cause: The temporary file has been sealed.

• Solution: Retry the SQL statement. If the issue persists, contact technical support for assistance.

ERROR 9135 (HY000): tmp file exceeds disk quota

• OceanBase error code: 9135

• Cause: The amount of data stored on disk by temporary files exceeds the specified limit.

• Solution: Check whether the current erroneous SQL statement generates an unexpected amount of data (for example, the expected maximum amount of data stored on disk by temporary files is 500 GB). If it is as expected, you can adjust the temporary_file_max_disk_size parameter to an appropriate value.

ERROR 9136 (HY000): Backup missing mview dependent tablet sstable, sstable maybe recycled

• OceanBase error code: 9136

• Cause: During backup, a multi-version major SSTable was recycled.

• Solution: Re-initiate the data backup.

ERROR 9138 (HY000): No suitable replica found to perform backup

• OceanBase error code: 9138

• Cause: No suitable replica was found to perform the backup operation.

• Solution: Check the replica status. After confirming that the status is normal, re-initiate the backup.

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 was not specified or was specified incorrectly during tenant restore.

• Solution: Specify the correct key address in the restore command, or set the correct key address using the SET @kms_encrypt_info session variable before restoration.

ERROR 9140 (HY000): the object is locked by worm

• OceanBase error code: 9140

• Cause: Attempt to delete or modify an object stored in object storage that is in the retention period.

• Solution: Check whether a retention policy is configured for the backup or archive path, and whether the enable_worm parameter was correctly configured when setting the backup or archive path. If the enable_worm parameter is correctly configured, contact OceanBase Technical Support for assistance.

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.

ERROR 9142 (HY000): the object can not be overwritten with different content

• OceanBase error code: 9142

• Cause: Write a non-idempotent file with the same name to object storage configured with a retention policy.

• Solution: Contact OceanBase Technical Support for assistance.

ERROR 9144 (HY000): Unexpected macro cache file

• OceanBase error code: 9144

• Cause: An unexpected file was found in the macroblock cache directory, possibly a file created by the user.

• Solution: Contact OceanBase Technical Support for assistance.

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 storage. After confirming no connectivity issues, contact Technical Support for assistance.

ERROR 9148 (HY000): disk quota is exceeded

• OceanBase error code: 9148

• Cause: The disk quota has been exceeded.

• Solution: Clean up files or adjust the disk quota.

ERROR 9149 (HY000): backup dest is not allowed to set when log_only policy exists

• OceanBase error code: 9149

• Cause: The log_only cleanup policy applies only when log archiving is enabled and no data backup is configured. When the log_only cleanup policy is in effect, you cannot configure a data backup path.

• Solution: First, delete the log_only cleanup policy, then configure the data backup path.

ERROR 9150 (HY000): log_only policy is not allowed to set when backup dest exists

• OceanBase error code: 9150

• Cause: The log_only cleanup policy applies only when log archiving is enabled and no data backup is configured. When a data backup path is already configured, you cannot set the cleanup policy to log_only.

• Solution: To use the log_only cleanup policy, you must first delete the configured data backup path.

ERROR 9151 (HY000): backup clean can not start, because %s

• OceanBase error code: 9151

• Cause: Data backup and archiving cleanup cannot proceed. Possible reasons include the tenant's 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.

ERROR 9152 (HY000): backup device may be not mounted, %s did not read any data written by %s

• OceanBase error code: 9152

• Cause: The backup medium is not correctly mounted.

• Solution: Mount the backup medium correctly to ensure all OBServer nodes of the tenant initiating the archiving/backup/restoration operation can access the same backup medium. For detailed operations on mounting NFS, refer to Deploy NFS.

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

• 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 according to the specified method. If the backup medium is object storage, contact the corresponding service provider.

ERROR 9155 (HY000): micro block is too large and rejected from micro cache

• OceanBase error code: 9155

• Cause: In shared storage mode, the size of the microblock to be cached exceeds the upper limit allowed by the microcache (default 128 KB), and the system refuses to write the microblock to the microcache.

• Solution: This error is a normal internal flow control behavior of the system and does not affect data correctness or business availability. Generally, no action is required. If it occurs frequently and significantly impacts read performance, contact technical support for assistance.

ERROR 9156 (HY000): ss ls is in gc status

• OceanBase error code: 9156

• Cause: The log stream is in GC status and no longer accepts new write or operation requests.

• Solution: Retry may succeed. If failures persist, contact OceanBase Technical Support for assistance.

ERROR 9158 (HY000): the object type is invalid

• OceanBase error code: 9158

• Cause: When writing data to object storage, an unexpected object type is encountered. For example, a Put operation is performed on an Append-type object, or an Append operation is performed on a regular-type object.

• Solution: Contact technical support for assistance.

ERROR 9159 (HY000): available data backup set is not found

• OceanBase error code: 9159

• Cause: Unable to restore to the specified time using any backup set.

• Solution: Select a different restore point or specify another backup set path.

ERROR 9200 (HY000): Extend ssblock file to smaller is not allowed

• OceanBase error code: 9200

• Cause: SSBlock files cannot be reduced in size.

• Solution: Check whether the size specified by ALTER SYSTEM SET datafile_size is greater 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 an automatic SSBlock file extension.

• 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 extension may not have started due to configuration issues, or the preset disk usage for datafile has reached its limit.

• Solution: Check if the free_size field in the __all_virtual_disk_stat table is 0. If it is, disk space is exhausted. You need to increase the datafile threshold or perform disk expansion.