OBE-00000 ~ OBE-00999

OBE-00000: PX DOP downgrade from %ld to %ld

• OceanBase error code: 5780

• SQLSTATE: HY000

• Cause: Normal exit.

OBE-00000: parallel_max_servers downgrade due to insufficient cpu resource from %ld to %ld. deprecated

• OceanBase error code: 5781

• SQLSTATE: HY000

• Cause: Normal exit.

  Note

  This error code is no longer used in the current version.

OBE-00001: unique constraint '%s' for key '%.*s' violated

• OceanBase error code: 5024

• SQLSTATE: 23000

• Cause: The UPDATE or INSERT statement attempts to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert the key.

OBE-00001: unique constraint (%.*s) violated

• OceanBase error code: 5595

• SQLSTATE: 23000

• Cause: The UPDATE or INSERT statement attempts to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert the key.

OBE-00001: unique constraint violated, column '%.*s' with value '%.*s' in %s

• OceanBase error code: 5334

• SQLSTATE: HY000

• Cause: The UPDATE or INSERT statement attempts to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert the key.

OBE-00001: unique constraint (%.*s) violated

• OceanBase error code: 5562

• SQLSTATE: HY000

• Cause: The UPDATE or INSERT statement attempts to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert the key.

OBE-00036: maximum number of recursive SQL levels (%ld) exceeded

• OceanBase error code: 9697

• SQLSTATE: HY000

• Cause: The maximum number of recursive SQL levels is exceeded.

• Solution: Drop the recursive SQL or recursive trigger.

OBE-00051: timeout occurred while waiting for a resource

• OceanBase error code: 5848

• SQLSTATE: HY000

• Cause: Usually caused by a dead instance.

• Solution: Check if there are any dead or unrecovered instances. If so, recover them.

OBE-00054: resource busy and acquire with NOWAIT specified or timeout expired

• OceanBase error code: 6006

• SQLSTATE: HY000

• Cause: The resource is busy.

• Solution: Retry or increase the timeout period.

OBE-00185: invalid argument for %s call

• OceanBase error code: 5488
• SQLSTATE: HY000
• Cause: The parameter for the %s call is invalid.

OBE-00060: deadlock detected while waiting for resource

• OceanBase error code: 4101

• SQLSTATE: HY000

• Cause: A deadlock was detected while waiting for a resource.

• Solution: Check the trace file and the involved transactions and resources. If necessary, retry the operation.

OBE-00060: internal error code, arguments: -6005, Try lock row conflict

• OceanBase error code: 6005
• SQLSTATE: HY000
• Cause: The lock failed during the update operation. Return this error code and retry.
• Solution: An internal error code. Contact technical support.

OBE-00060: internal error code, arguments: -4012, Timeout, query has reached the maximum query timeout: %ld(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again

• OceanBase error code: 4012
• SQLSTATE: HY000
• Cause: The query execution has exceeded the maximum allowed timeout period.
• Solution:
  • Optimize performance to reduce execution time.
  • Increase the timeout period.
  • Contact technical support for further assistance.

OBE-00060: internal error code, arguments: -4013, No memory or reach tenant memory limit

• OceanBase error code: 4013
• SQLSTATE: HY000
• Cause: Memory allocation failed.
  • Physical memory is exhausted.
  • A single allocation request exceeds 4 GB.
  • The memory usage of the CTX, tenant, or server reaches the upper limit.
• Solution: Contact technical support for further assistance.

OBE-00060: internal error code, arguments: -4016, Internal error

• OceanBase error code: 4016
• SQLSTATE: HY000
• Cause: An internal error occurred.
• Solution: An internal error code. Contact technical support.

OBE-00060: internal error code, arguments: -4377, fatal internal error

• OceanBase error code: 4377
• SQLSTATE: HY000
• Cause: OceanBase Database encountered an unexpected internal error, which may be due to abnormal program execution.
• Solution: Contact technical support for further assistance.

OBE-00060: Migrate tx data not continues

• OceanBase error code: 4408

• SQLSTATE: HY000

• Cause: The transaction data table of the source to be migrated was recycled, and the destination copy found that the transaction data table was not continuous, failed to report an error, and then retried.

• Solution: Generally, it can be successful after retrying. If it continues to fail, contact OceanBase Technical Support for further assistance.

OBE-00060: internal error code, arguments: -5065, Query execution was interrupted

• OceanBase error code: 5065
• SQLSTATE: HY000
• Cause: The query was terminated.
• Solution: Contact the system administrator or database administrator.

OBE-00060: internal error code, arguments: -6220, SQL sequence illegal

• OceanBase error code: 6220
• SQLSTATE: HY000
• Cause: The SQL statement sequence is invalid.
• Solution: This is an internal error code. Contact technical support for troubleshooting.

OBE-00224: object '%.*s' must be of type function or array to be used this way

• OceanBase error code: 9765

• SQLSTATE: HY000

• Cause: The object '%.*s' must be of the function or array type to be used this way.

• Solution: Check the type of the object and adjust it as needed.

OBE-00600: arbitration service does not exist

• OceanBase error code: 4747

• SQLSTATE: HY000

• Cause: The address of the arbitration service has not been configured for the cluster.

• Solution: Arbitration-related operations cannot be performed without the arbitration service address configured. You can use OCP or execute the SQL statement alter system add arbitration service‘$svr_ip:$svr_port’; to add an arbitration service address for the cluster.

OBE-00600: arbitration service already exist

• OceanBase error code: 4748

• SQLSTATE: HY000

• Cause: The cluster already has a valid arbitration service address.

• Solution: A cluster supports only one arbitration service.

EOBE-00600: wait degration finished timeout

• OceanBase error code: 4751

• SQLSTATE: HY000

• Cause: The timeout occurs when the server is being stopped and the tenant is being downgraded.

• Solution: Reissue the Stop Server command until it succeeds.

OBE-00600: unknown SET option '%s'

• OceanBase error code: 4764
• SQLSTATE: HY000
• Cause: An unknown SET option is specified when the parameter is set.
• Solution: Check whether the option specified in the SET command is correct, and ensure that no spelling or syntax errors exist.

OBE-00600: Cannot create a JSON value from a string

• OceanBase error code: 5415

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact a technical support engineer for troubleshooting.

OBE-00600: Invalid JSON character data provided to function

• OceanBase error code: 5416

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact a technical support engineer for troubleshooting.

OBE-00600: Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required

• OceanBase error code: 5417

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: Cannot CAST value to JSON

• OceanBase error code: 5418

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: A path expression must be encoded in the utf8 character set

• OceanBase error code: 5419

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: In this situation, path expressions may not contain the * and ** tokens

• OceanBase error code: 5420

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: The JSON value is too big to be stored in a JSON column

• OceanBase error code: 5421

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: JSON column '%.*s' cannot be used in key specification

• OceanBase error code: 5423

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: The path expression is not allowed in this context

• OceanBase error code: 5424

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: The oneOrAll argument may take these values: \'one\' or \'all\'

• OceanBase error code: 5425

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: Out of range JSON value for CAST

• OceanBase error code: 5426

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: Invalid JSON value for CAST

• OceanBase error code: 5427

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: The JSON document exceeds the maximum depth

• OceanBase error code: 5428

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: Invalid default value for \'%.*s\'

• OceanBase error code: 5430

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-00600: A path expression is not a path to a cell in an array

• OceanBase error code: 5431

• SQLSTATE: 22032

• Cause: Internal error code.

• Solution: Internal error code. Contact the technical support for troubleshooting.

OBE-40600: JSON_EQUAL used outside predicate

• OceanBase error code: 5448
• SQLSTATE: 42000
• Cause: JSON_EQUAL was used outside a predicate.
• Solution: Use JSON_EQUAL within a predicate, such as embedding it in a CASE expression.

OBE-00600: auto increment service busy

• OceanBase error code: 5794

• SQLSTATE: HY000

• Cause: An internal error code.

• Solution: Contact the technical support for troubleshooting.

OBE-00600: rowid type mismatch, expect %.*s, got %.*s"

• OceanBase error code: 5870

• SQLSTATE: HY000

• Cause: An internal error code.

• Solution: Contact the technical support for troubleshooting.

OBE-00600: rowid num mismatch, expect %ld, actual %ld

• OceanBase error code: 5871

• SQLSTATE: HY000

• Cause: An internal error code.

• Solution: Contact the technical support for troubleshooting.

OBE-00600: internal error code, arguments: -7124, partitions are already balanced, %s

• OceanBase error code: 7124

• SQLSTATE: HY000

• Cause: The partitions are already balanced when an attempt is made to perform a partition balancing operation.

OBE-00600: Binary geometry function given two geometries of different srids.Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical

• OceanBase error code: 7201
• SQLSTATE: HY000
• Cause: The binary geometry function was given two geometries with different SRIDs: %u and %u, which should have been identical. The geometry values passed to the spatial function must have the same SRID.

OBE-00600: Calling geometry function with unsupported types of arguments.Calling geometry function %s with unsupported types of arguments

• OceanBase error code: 7202
• SQLSTATE: HY000
• Cause: The geometry function %s was called with unsupported argument types.

OBE-00600: Unknown GIS error occurred in function.Unknown GIS error occurred in function %s

• OceanBase error code: 7203
• SQLSTATE: HY000
• Cause: An unknown GIS error occurred in the function %s.

OBE-00600: An unknown exception was caught in the GIS function. An unknown exception was caught in the GIS function %s

• OceanBase error code: 7204
• SQLSTATE: HY000
• Cause: An unknown exception was caught in the GIS function %s.

OBE-00600: Invalid GIS data was provided to the function. Invalid GIS data was provided to the function %s

• OceanBase error code: 7205
• SQLSTATE: 22023
• Cause: Invalid GIS data was provided to the function %s. A spatial function was called with a parameter that is not recognized as a valid geometry value.

OBE-00600: The geometry has no data in the function. The geometry has no data in the function %s

• OceanBase error code: 7206
• SQLSTATE: HY000
• Cause: The geometry has no data in the function %s.

OBE-00600: Unable to calculate the centroid because the geometry is empty in the function. Unable to calculate the centroid because the geometry is empty in the function %s

• OceanBase error code: 7207
• SQLSTATE: HY000
• Cause: Unable to calculate the centroid because the geometry is empty in the function %s.

OBE-00600: Geometry overlay calculation error: the geometry data is invalid in the function. Geometry overlay calculation error: the geometry data is invalid in the function %s

• OceanBase error code: 7208
• SQLSTATE: HY000
• Cause: The geometry overlay calculation failed because the geometry data is invalid in the function %s.

OBE-00600: Geometry turn info calculation error: the geometry data is invalid in the function. Geometry turn info calculation error: the geometry data is invalid in the function %s

• OceanBase error code: 7209
• SQLSTATE: HY000
• Cause: The geometry turn information calculation failed because the geometry data is invalid in the function %s.

OBE-00600: Analysis procedures of intersection points interrupted unexpectedly in function.Analysis procedures of intersection points interrupted unexpectedly in function %s

• OceanBase error code: 7210
• SQLSTATE: HY000
• Cause: The analysis of intersection points was unexpectedly interrupted in the %s function.

OBE-00600: Unknown exception thrown in function.Unknown exception thrown in function %s

• OceanBase error code: 7211
• SQLSTATE: HY000
• Cause: An unknown exception was thrown in the %s function.

OBE-00600: Geometry byte string must be little endian

• OceanBase error code: 7212
• SQLSTATE: HY000
• Cause: The geometry byte string must be in little-endian format.

OBE-00600: Do not support online operation on table with GIS index

• OceanBase error code: 7213
• SQLSTATE: HY000
• Cause: Online operations are not supported on a table with a GIS index.

OBE-00600: Inconsistent intersection points.Inconsistent intersection points

• OceanBase error code: 7214
• SQLSTATE: HY000
• Cause: The intersection points are inconsistent.

OBE-00600: Parameter exceeds the maximum number of points in a geometryin function.Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s

• OceanBase error code: 7215
• SQLSTATE: HY000
• Cause: The %s parameter exceeds the maximum number of points in a geometry (%lu) in the %s function.

OBE-00600: value is a geometry of unexpected type.%.64s value is a geometry of unexpected type %.64s in %.64s

• OceanBase error code: 7216
• SQLSTATE: 22S01
• Cause: The %s value is a geometry of an unexpected type %s in %s.

OBE-00600: Cannot parse the spatial reference system definition of SRID %u.

• OceanBase error code: 7217
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u cannot be parsed.

OBE-00600: The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.

• OceanBase error code: 7218
• SQLSTATE: SR003
• Cause: The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.

OBE-00600: No spatial reference system exists with SRID %u.

• OceanBase error code: 7219
• SQLSTATE: 01000
• Cause: No spatial reference system exists with SRID %u.

OBE-00600: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.

• OceanBase error code: 7220
• SQLSTATE: 22S00
• Cause: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.

OBE-00600: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.

• OceanBase error code: 7221
• SQLSTATE: SR001
• Cause: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.

OBE-00600: No spatial reference system with SRID %u exists.

• OceanBase error code: 7222
• SQLSTATE: SR001
• Cause: No spatial reference system exists with SRID %u.

OBE-00600: No spatial reference system with SRID %u exists. The axis order is unknown.

• OceanBase error code: 7223
• SQLSTATE: 01000
• Cause: No spatial reference system exists with SRID %u. The axis order is unknown.

OBE-00600: The implementation of %.192s(%.80s) is not supported for geographic spatial reference systems.

• OceanBase error code: 7224
• SQLSTATE: 22S00
• Cause: The implementation of %s(%s) is not supported for geographic spatial reference systems.

OBE-00600: The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.

• OceanBase error code: 7225
• SQLSTATE: HY000
• Cause: The SRID of the geometry does not match the SRID of the column '%s'. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.

OBE-00600: The SRID specification on the column cannot be changed because there is a spatial index on the column. The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.

• OceanBase error code: 7226
• SQLSTATE: HY000
• Cause: The SRID specification on the column '%s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.

OBE-00600: The spatial index on column will not be used by the query optimizer since the column does not have an SRID attribute.The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column

• OceanBase error code: 7227
• SQLSTATE: HY000
• Cause: The query optimizer will not use the spatial index on column "%s" because the column does not have an SRID attribute. Consider adding an SRID attribute to the column.

OBE-00600: Function is only defined for SRID 0 and SRID 4326.Function %.192s is only defined for SRID 0 and SRID 4326

• OceanBase error code: 7228
• SQLSTATE: 22S00
• Cause: The function %s is defined only for SRID 0 and SRID 4326.

OBE-00600: It has not been implemented for Cartesian spatial reference systems.%.192s(%.80s) has not been implemented for Cartesian spatial reference systems

• OceanBase error code: 7229
• SQLSTATE: 22S00
• Cause: %s(%s) has not been implemented for Cartesian spatial reference systems.

OBE-00600: It has not been implemented for projected spatial reference systems.%.192s(%.80s) has not been implemented for projected spatial reference systems

• OceanBase error code: 7230
• SQLSTATE: 22S00
• Cause: %s(%s) has not been implemented for projected spatial reference systems.

OBE-00600: Missing mandatory attribute.Missing mandatory attribute %s

• OceanBase error code: 7231
• SQLSTATE: SR006
• Cause: The mandatory attribute %s is missing.

OBE-00600: Multiple definitions of attribute.Multiple definitions of attribute %s

• OceanBase error code: 7232
• SQLSTATE: SR006
• Cause: The attribute %s is defined multiple times.

OBE-00600: The spatial reference system name cannot be an empty string or start or end with whitespace

• OceanBase error code: 7233
• SQLSTATE: SR006
• Cause: The spatial reference system name cannot be an empty string or start or end with whitespace.

OBE-00600: The organization name cannot be an empty string or start or end with whitespace

• OceanBase error code: 7234
• SQLSTATE: SR006
• Cause: The organization name cannot be an empty string or start or end with whitespace.

OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u

• OceanBase error code: 7235
• SQLSTATE: SR004
• Cause: There is already a spatial reference system with SRID %u.

OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u

• OceanBase error code: 7236
• SQLSTATE: 01S00
• Cause: There is already a spatial reference system with SRID %u.

OBE-00600: SRID 0 is not modifiable

• OceanBase error code: 7237
• SQLSTATE: SR000
• Cause: SRID 0 cannot be modified.

OBE-00600: The SRID range has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade. The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade

• OceanBase error code: 7238
• SQLSTATE: 01S01
• Cause: The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified, or removed without warning during upgrade.

OBE-00600: Cannot modify SRID. At least one column depends on it. Cannot modify SRID %u. At least one column depends on it.

• OceanBase error code: 7239
• SQLSTATE: SR005
• Cause: Cannot modify SRID %u. At least one column depends on it.

OBE-00600: Invalid character in attribute. Invalid character in attribute %s

• OceanBase error code: 7240
• SQLSTATE: SR006
• Cause: The character in attribute %s is invalid.

OBE-00600: Attribute is too long. Attribute %s is too long. The maximum length is %u characters.

• OceanBase error code: 7241
• SQLSTATE: SR006
• Cause: Attribute %s is too long. The maximum length is %u characters.

OBE-00600: Function is only defined for geographic spatial reference systems, but one of its arguments is in SRID, which is not geographic. Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.

• OceanBase error code: 7242
• SQLSTATE: 22S00
• Cause: The function %s is defined only for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.

OBE-00600: Function encountered a polygon that was too large. Polygons must cover less than half the planet. Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.

• OceanBase error code: 7243
• SQLSTATE: 22023
• Cause: The function %s encountered a polygon that was too large.

OBE-00600: Spatial indexes can't be primary or unique indexes

• OceanBase error code: 7244
• SQLSTATE: HY000
• Cause: Spatial indexes cannot be primary or unique indexes.

OBE-00600: The index type is not supported for spatial indexes.The index type %.20s is not supported for spatial indexes

• OceanBase error code: 7245
• SQLSTATE: HY000
• Cause: Spatial indexes do not support the index type %s.

OBE-00600: A parameter of function contains a geometry with longitude, which is out of range.A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f]

• OceanBase error code: 7246
• SQLSTATE: 22S02
• Cause: The parameter of function %s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].

OBE-00600: A parameter of function contains a geometry with latitude, which is out of range.A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f]

• OceanBase error code: 7247
• SQLSTATE: 22S03
• Cause: The parameter of function %s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].

OBE-00600: The spatial reference system definition for SRID specifies invalid geographic axes. One axis must be NORTH or SOUTH and the other must be EAST or WEST.he spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST

• OceanBase error code: 7248
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u specifies invalid geographic axes '%s' and '%s'. One axis must be NORTH or SOUTH, and the other must be EAST or WEST.

OBE-00600: The spatial reference system definition for SRID %u specifies invalid geographic axes. One axis must be NORTH or SOUTH and the other must be EAST or WEST.

• OceanBase error code: 7249
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.

OBE-00600: The inverse flattening must be greater than 1.0, or 0.0 if the ellipsoid is a sphere.

• OceanBase error code: 7250
• SQLSTATE: SR002
• Cause: The inverse flattening must be greater than 1.0, or 0.0 if the ellipsoid is a sphere.

OBE-00600: The angular unit conversion factor must be a positive number.

• OceanBase error code: 7251
• SQLSTATE: SR002
• Cause: The angular unit conversion factor must be a positive number.

OBE-00600: The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.

• OceanBase error code: 7252
• SQLSTATE: SR002
• Cause: The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.

OBE-00600: Transformation from SRID %u is not supported.

• OceanBase error code: 7253
• SQLSTATE: 22S00
• Cause: Transformation from SRID %u is not supported.

OBE-00600: Transformation to SRID %u is not supported.

• OceanBase error code: 7254
• SQLSTATE: 22S00
• Cause: Transformation to SRID %u is not supported.

OBE-00600: Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause

• OceanBase error code: 7255
• SQLSTATE: 22S00
• Cause: Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

OBE-00600: Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause

• OceanBase error code: 7256
• SQLSTATE: 22S00
• Cause: Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.

OBE-00600: Cannot create a functional index on a function that returns a JSON or GEOMETRY value

• OceanBase error code: 7257
• SQLSTATE: 42000
• Cause: Cannot create a functional index on a function that returns a JSON or GEOMETRY value.

OBE-00600: Spatial functional index is not supported

• OceanBase error code: 7258
• SQLSTATE: HY000
• Cause: Spatial functional index is not supported.

OBE-00600: The geometry passed to function is in SRID 0, which doesn't specify a length unit. Can't convert.The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'

• OceanBase error code: 7259
• SQLSTATE: SU001
• Cause: The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'.

OBE-00600: Invalid cast.Invalid cast from %s to %s

• OceanBase error code: 7260
• SQLSTATE: 22S01
• Cause: Invalid cast from %s to %s.

OBE-00600: Invalid cast. A polygon ring is in the wrong direction.Invalid cast from %s to %s. A polygon ring is in the wrong direction

• OceanBase error code: 7261
• SQLSTATE: 22S04
• Cause: Invalid cast from %s to %s. A polygon ring is in the wrong direction.

OBE-00600: The arguments to the function contain geometries with different SRIDs. All geometries must have the same SRID. The arguments to the function %s contain geometries with different SRIDs: %u and %u. All geometries must have the same SRID.

• OceanBase error code: 7262
• SQLSTATE: 22S05
• Cause: The arguments to the function %s contain geometries with different SRIDs: %u and %u. All geometries must have the same SRID.

OBE-00600: The longitude is out of range in the function. The longitude %f is out of range in the function %.192s. It must be within (%f, %f].

• OceanBase error code: 7263
• SQLSTATE: 22S02
• Cause: The longitude %f is out of range in the function %s. It must be within (%f, %f].

OBE-00600: The latitude is out of range in the function. The latitude %f is out of range in the function %.192s. It must be within [%f, %f].

• OceanBase error code: 7264
• SQLSTATE: 22S03
• Cause: The latitude %f is out of range in the function %s. It must be within [%f, %f].

OBE-00600: Memory allocation error. Memory allocation error: %*.256s in function %s

• OceanBase error code: 7265
• SQLSTATE: HY000
• Cause: Memory allocation error: %s in function %s.

OBE-00600: Domain error. Domain error: %*.256s in function %s

• OceanBase error code: 7266
• SQLSTATE: HY000
• Cause: Domain error: %s in function %s.

OBE-00600: Length error. Length error: %*.256s in function %s

• OceanBase error code: 7267
• SQLSTATE: HY000
• Cause: Length error: %s in function %s.

OBE-00600: Invalid argument error. Invalid argument error: %*.256s in function %s

• OceanBase error code: 7268
• SQLSTATE: HY000
• Cause: Invalid argument error: %s in function %s.

OBE-00600: Out of range error. Out of range error: %*.256s in function %s

• OceanBase error code: 7269
• SQLSTATE: HY000
• Cause: Out of range error, %s in function %s.

OBE-00600: Overflow error. Overflow error: %*.256s in function %s

• OceanBase error code: 7270
• SQLSTATE: HY000
• Cause: Overflow error, %s in function %s.

OBE-00600: Range error. Range error: %*.256s in function %s

• OceanBase error code: 7271
• SQLSTATE: HY000
• Cause: Range error, %s in function %s.

OBE-00600: Underflow error. Underflow error: %*.256s in function %s

• OceanBase error code: 7272
• SQLSTATE: HY000
• Cause: Underflow error, %s in function %s.

OBE-00600: Logic error. Logic error: %*.256s in function %s

• OceanBase error code: 7273
• SQLSTATE: HY000
• Cause: Logic error, %s in function %s.

OBE-00600: Runtime error. Runtime error: %*.256s in function %s

• OceanBase error code: 7274
• SQLSTATE: HY000
• Cause: Runtime error, %s in function %s.

OBE-00600: Unknown exception: %*.384s in function %s

• OceanBase error code: 7275
• SQLSTATE: HY000
• Cause: Unknown exception, %s in function %s.

OBE-00600: Cannot get geometry object from data you send to the GEOMETRY field

• OceanBase error code: 7276
• SQLSTATE: 22003
• Cause: Cannot get a geometry object from the data you sent to the GEOMETRY field.

OBE-00600: Incorrect usage of srid, srid column attribute only support in geometry

• OceanBase error code: 7277
• SQLSTATE: HY000
• Cause: Incorrect usage of srid. The srid column attribute is supported only for geometry.

OBE-00600: Incorrect usage of spatial/fulltext/hash index and explicit index order

• OceanBase error code: 7278
• SQLSTATE: HY000
• Cause: Incorrect usage of spatial, fulltext, or hash index and explicit index order.

OBE-00600: All parts of a SPATIAL index must be NOT NULL

• OceanBase error code: 7280
• SQLSTATE: 42000
• Cause: All parts of a SPATIAL index must be NOT NULL.

OBE-00600: The index type is not supported for spatial indexes. The index type %s is not supported for spatial indexes.

• OceanBase error code: 7281
• SQLSTATE: HY000
• Cause: The index type %s is not supported for spatial indexes.

OBE-00600: There's no unit of measure. There's no unit of measure named '%s'.

• OceanBase error code: 7282
• SQLSTATE: SU001
• Cause: There is no unit of measure named '%s'.

OBE-00600: The string is not a valid key value pair in function. The string '%.192s' is not a valid key %c value pair in function %.192s

• OceanBase error code: 7283
• SQLSTATE: 22023
• Cause: The string '%s' is not a valid key %c value pair in function %s.

OBE-00600: Invalid radius provided to function: Radius must be greater than zero. Invalid radius provided to function %s: Radius(%lf) must be greater than zero

• OceanBase error code: 7284
• SQLSTATE: 22023
• Cause: The radius provided to function %s is invalid. The radius must be greater than zero.

OBE-00600: Spatial reference system is empty

• OceanBase error code: 7285
• SQLSTATE: SR001
• Cause: No spatial reference system with SRID %u exists.

OBE-00600: Invalid option key in function. Invalid option key '%.192s' in function '%.192s'

• OceanBase error code: 7286
• SQLSTATE: 22023
• Cause: The option key '%s' in the function '%s' is invalid.

OBE-00600: Invalid value for option in function. Invalid value '%.192s' for option '%.192s' in function '%.192s'

• OceanBase error code: 7287
• SQLSTATE: 22023
• Cause: The value '%s' of the option '%s' in the function '%s' is invalid.

OBE-00600: Unknown WKB type. Unknown WKB type (%d)! Full WKB type number was (%d)

• OceanBase error code: 7288
• SQLSTATE: 22S01
• Cause: The geometry has an unexpected type of %s for the %s value.

OBE-00600: A FTS index may only contain a text type column.

• OceanBase error code: 7289

• SQLSTATE: 42000

• Cause: A full-text search (FTS) index can contain only text columns.

• Solution: Make sure that the column you are trying to create an FTS index on has a text data type, such as VARCHAR, TEXT, or CHAR.

OBE-00600: internal error code, arguments: -9129, object storage io error

• OceanBase error code: 9129
• SQLSTATE: HY000
• Cause: An object storage error occurred. Common causes include connectivity and compatibility issues with the object storage.
• Solution: Check the connectivity of the object storage. If there are no connectivity issues, contact technical support for further troubleshooting.

OBE-00600: tmp file exceeds disk quota

• OceanBase error code: 9135

• SQLSTATE: HY000

• Cause: The amount of data written to the temporary file exceeds the specified limit.

• Solution: Check whether the SQL statement that caused the error generated an unexpectedly large amount of data (for example, more than 500 GB of data for the temporary file). If the amount of data is within the expected range, set the temporary_file_max_disk_size parameter to an appropriate value.

OBE-00600: kms destination is not valid

• OceanBase error code: 9139

• SQLSTATE: HY000

• Cause: When transparent encryption is enabled for the backup tenant, a key address was not specified or the specified key address was invalid during tenant restore.

• Solution: Specify the correct key address in the restore command. Or, set the @kms_encrypt_info session variable to the correct key address before restore.

OBE-00600: the object is locked by worm

• OceanBase error code: 9140

• SQLSTATE: HY000

• Cause: Tried to delete or modify an object during its retention period on the storage.

• Solution: Check whether a retention policy is configured for the backup or archive path and whether the enable_worm parameter was properly set during configuration. If the enable_worm parameter was properly set, contact OceanBase Technical Support for troubleshooting.

OBE-00600: the resource has been released

• OceanBase error code: 9141

• SQLSTATE: HY000

• Cause: The temporary file macro block was unexpectedly released.

• Solution: Contact OceanBase Technical Support for troubleshooting.

OBE-00600: the object can not be overwritten with different content

• OceanBase error code: 9142

• SQLSTATE: HY000

• Cause: A non-idempotent file with the same name was written to an object storage configured with a retention policy.

• Solution: Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Incorrect usage of %s

• OceanBase error code: 9751
• SQLSTATE: HY000
• Cause: The statement was incorrectly used.
• Solution: Check if the statement was used correctly and use it properly.

OBE-00600: internal error code, arguments: -11093,OBLogService rpc execute failed

• OceanBase error code: 11093

• SQLSTATE: HY000

• Cause: The log service RPC call failed due to insufficient target node resources or a network issue.

• Solution: Prioritize using the trace_id to locate the target node's log, and resolve it with resource monitoring and parameter adjustments.

OBE-00603: Prepare statement checksum error

• OceanBase error code: 5777

• SQLSTATE: HY000

• Cause: The server session is in an unrecoverable state.

• Solution: Log in to OceanBase Database again to automatically create a new server session. For more information, check the session tracking file.

OBE-00739: FORALL INSERT/UPDATE/DELETE not support on remote tables

• OceanBase error code: 9752
• SQLSTATE: HY000
• Cause: FORALL INSERT/UPDATE/DELETE is not supported on remote tables.
• Solution: Do not use FORALL INSERT/UPDATE/DELETE on remote tables.

OBE-00900: invalid SQL statement

• OceanBase error code: 5001

• SQLSTATE: 42000

• Cause: The SQL statement contains errors.

• Solution: For more information, see the "SQL Reference (Oracle-compatible mode)" documentation for your OceanBase Database version.

• OceanBase error code: 5006

• SQLSTATE: 42000

• Cause: The SQL statement contains errors.

• Solution: For more information, see the "SQL Reference (Oracle-compatible mode)" documentation for the version of OceanBase Database that you are using.

OBE-00902: invalid data type

• OceanBase error code: 5874

• SQLSTATE: HY000

• Cause: The data type is invalid.

OBE-00903: invalid table name

• OceanBase error code: 5163

• SQLSTATE: 42000

• Cause: The table name is invalid.

OBE-00904: invalid identifier '%.*s'

• OceanBase error code: 5164

• SQLSTATE: 42000

• Cause: The string contains an invalid identifier.

OBE-00904: invalid identifier '%.*s' in '%.*s'

• OceanBase error code: 5217

• SQLSTATE: 42S22

• Cause: The string contains an invalid identifier.

OBE-00904: '%.*s': invalid identifier

• OceanBase error code: 5211

• SQLSTATE: 42000

• Cause: The string contains an invalid identifier.

OBE-00905: missing keyword

• OceanBase error code: 5096

• SQLSTATE: HY000

• Cause: The keyword is missing in the SQL statement.

OBE-00909: invalid number of arguments in the call to native function '%.*s'

• OceanBase error code: 5054

• SQLSTATE: 42000

• Cause: The number of arguments is invalid.

OBE-00910: specified length too long for column '%s' (max = %d byte)

• OceanBase error code: 5198

• SQLSTATE: 42000

• Cause: The specified string length exceeds the maximum supported by the data type. For CHAR and RAW data types, the specified string length exceeds 2000 bytes. For other data types, the specified string length exceeds 4000 bytes.

• Solution: Reduce the string length or switch to a data type that supports a longer string length, such as VARCHAR2, LONG CHAR, or LONG RAW.

OBE-00913: too many values

• OceanBase error code: 5613

• SQLSTATE: HY000

• Cause: Too many values.

OBE-00917: missing comma

• OceanBase error code: 7403
• SQLSTATE: 42000
• Cause: The required comma is missing in the INSERT statement or in the list of columns or values in the form of ((C,D),(E,F), ...).
• Solution: Correct the syntax, check the SQL statement carefully, and locate the missing comma or incorrect use of the comma.

OBE-00918: column '%.*s' in %.*%s ambiguously defined

• OceanBase error code: 5207

• SQLSTATE: 23000

• Cause: The column definition is ambiguous.

OBE-00925: missing INTO keyword

• OceanBase error code: 9712

• SQLSTATE: HY000

• Cause: The INTO keyword is missing when you execute an INSERT statement.

• Solution: Add the missing INTO keyword and execute the statement again.

OBE-00926: missing VALUES keyword

• OceanBase error code: 5574

• SQLSTATE: HY000

• Cause: The VALUES keyword is missing.

OBE-00931: missing identifier

• OceanBase error code: 5963

• SQLSTATE: HY000

• Cause: The identifier is missing.

OBE-00932: inconsistent datatypes: left_type=%s right_type=%s

• OceanBase error code: 5083

• SQLSTATE: 22000

• Cause: The data types are inconsistent.

OBE-00932: inconsistent datatypes,inconsistent datatypes: expected %s got %s

• OceanBase error code: 7402
• SQLSTATE: 22000
• Cause: Incompatible data types are used in the SQL query.
• Solution: Check the SQL query statement, identify the inconsistent data types, and use the CAST or CONVERT function to convert the data types to the same type.

OBE-00933: SQL command not properly ended

• OceanBase error code: 5607

• SQLSTATE: HY000

• Cause: The SQL command is not properly ended.

OBE-00934: group function is not allowed here

• OceanBase error code: 5694

• SQLSTATE: HY000

• Cause: The GROUP function is not allowed here.

OBE-00937: not a single-group group function

• OceanBase error code: 5853

• SQLSTATE: HY000

• Cause: It is not a single-group GROUP function.

OBE-00938: not enough arguments for function

• OceanBase error code: 5774

• SQLSTATE: HY000

• Cause: The function has insufficient arguments.

OBE-00939: too many arguments for function

• OceanBase error code: 5683

• SQLSTATE: HY000

• Cause: The function has too many arguments.

OBE-00942: table or view \'%s.%s\'does not exist

• OceanBase error code: 5019

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later, if the current role does not have the SELECT privilege on some tables or views, this error will also be returned.

• Solution: Check the spelling of your SQL statement. Specifically, for OceanBase Database V2.2.70 and later, check the privileges of the current role.

OBE-00942: table or view '%.*s' does not exist

• OceanBase error code: 5201

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later, if the current role does not have the SELECT privilege on certain tables or views, this error is also returned.

• Solution: Check the spelling of your SQL statement. In OceanBase Database V2.2.70 and later, check the privileges of the current role.

OBE-00947: not enough values

• OceanBase error code: 5614

• SQLSTATE: HY000

• Cause: The number of values is less than the number of columns.

OBE-00955: name is already used by an existing object

• OceanBase error code: 5331, 5834

• SQLSTATE: HY000

• Cause: The name is already used by an existing object.

OBE-00957: duplicate column name

• OceanBase error code: 4228

• SQLSTATE: 42000

• Cause: The column name is duplicated.

OBE-00959: tablespace '%.*s' does not exist

• OceanBase error code: 4354

• SQLSTATE: HY000

• Cause: The tablespace does not exist.

OBE-00964: table name not in FROM list

• OceanBase error code: 5490
• SQLSTATE: 42000
• Cause: The table name is not in the FROM list.
• Solution: Make sure that the name is a correct table name and exists in the FROM list.

OBE-00969: missing ON keyword

• OceanBase error code: 5370

• SQLSTATE: HY000

• Cause: The ON keyword is missing.

OBE-00972: identifier \'%.*s\' is too

• OceanBase error code: 5179

• SQLSTATE: 42000

• Cause: The specified identifier exceeds the limit.

• Solution: Set the number of bytes of the specified identifier within the limit.

OBE-00976: Specified pseudo column or operator not allowed here

• OceanBase error code: 5763

• SQLSTATE: HY000

• Cause: The LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, or CONNECT_BY_ISCYCLE keyword is not allowed at this location.

• Solution: Remove the LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, or CONNECT_BY_ISCYCLE keyword.

OBE-00979: not a GROUP BY expression

• OceanBase error code: 5218

• SQLSTATE: 42000

• Cause: The expression is not a GROUP BY expression.

OBE-00980: synonym translation is no longer valid

• OceanBase error code: 5330

• SQLSTATE: HY000

• Cause: The synonym has not been resolved to a valid target object. This may be due to the following reasons:

  • The target mode does not exist.

  • The target object does not exist.

  • The synonym specifies an invalid database link.

  • The synonym does not specify version control, but the target object does.

• Solution: Change the synonym definition so that the synonym points to a valid target object.

OBE-00984: column not allowed here

• OceanBase error code: 5942

• SQLSTATE: HY000

• Cause: The column cannot be inserted here.

OBE-00988: missing or invalid password(s)

• OceanBase error code: 5887

• SQLSTATE: HY000

• Cause: The password is invalid.

OBE-00989: Cursor Variable in record, object, or collection is not supported by this release

• OceanBase error code: 9811
• SQLSTATE: HY000
• Cause: The current version does not support nested cursor variables in records, objects, or collections.
• Solution: Avoid nested cursor structures.

OBE-00998: must name this expression with a column alias

• OceanBase error code: 5872

• SQLSTATE: HY000

• Cause: This expression must be named with a column alias.