This range indicates SQL layer error codes. It includes SQL error codes, WITH clause error codes, and Factoring error codes.
ERROR 5002 (HY000) : Resolve error
OceanBase error code: 5002
Cause: Parsing error.
Solution: Contact technical support for assistance.
ERROR 5010 (21000) : Unknown operator
OceanBase error code: 5010
Cause: Internal defense check error code during parsing.
Solution: Contact technical support for assistance.
ERROR 5011 (42000) : Duplicated star
OceanBase error code: 5011
Cause: Incorrect usage of
*. An SQL statement supports only one*.Solution: Remove the extra
*from the SQL statement.
ERROR 5012 (HY000) : Illegal ID
OceanBase error code: 5012
Cause: Internal parameter defense error.
Solution: Contact technical support for assistance.
ERROR 5014 (HY000) : Illegal value
OceanBase error code: 5014
Cause: Numeric type conversion error.
Solution: Check whether the CAST statements in the SQL statement are correct, such as whether implicit conversion exists.
ERROR 5016 (HY000) : Generate logical plan error
OceanBase error code: 5016
Cause: Error occurred while generating the plan.
Solution: Contact technical support for assistance.
ERROR 5017 (HY000) : Schema not set
OceanBase error code: 5017
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date
OceanBase error code: 5023
Cause: Unsupported type.
Solution: Contact technical support for assistance.
ERROR 5031 (HY000) : Column not found
OceanBase error code: 5031
Cause: The column does not exist.
Solution: Check whether the column involved in the operation exists, or contact technical support for assistance.
ERROR 5034 (01007) : No user
OceanBase error code: 5034
Cause: The username is empty.
Solution: Provide a username.
ERROR 5050 (42710) : User exists
OceanBase error code: 5050
Cause: The user or role already exists.
Solution: Check whether the user or role involved in the operation already exists, or contact technical support for assistance.
ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld
OceanBase error code: 5053
Cause: The number of variables bound during EXECUTE does not match the number of parameters in the PREPARE statement.
Solution: Ensure that the number of variables bound during EXECUTE matches the number of parameters required by the PREPARE statement.
ERROR 5058 (42000) : Duplicated parameters
OceanBase error code: 5058
Cause: Duplicate parameter.
Solution: Contact technical support for assistance.
ERROR 5063 (42000) : Unknown hint
OceanBase error code: 5063
Cause: Parsing error.
Solution: Contact technical support for assistance.
ERROR 5066 (HY000) : Session interrupted
OceanBase error code: 5066
Cause: The session was terminated.
Solution: Contact the system administrator or database administrator.
ERROR 5071 (42000) : Cannot alter index column
OceanBase error code: 5071
Cause: Deleted an index reference column.
Solution: Deleting an index reference column is not allowed.
ERROR 5074 (23000) : NOP cannot be used here
OceanBase error code: 5074
Cause: Kernel bug.
Solution: Contact technical support for assistance.
ERROR 5081 (25000) : The server is read only now
OceanBase error code: 5081
Cause: The data being operated on is read-only.
Solution: Check whether the data being operated on is read-only, or contact technical support for assistance.
ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s
OceanBase error code: 5083
Cause: Type conversion error.
Solution: Contact technical support for assistance.
ERROR 5084 (22000) : Can not cast varchar value to bool type
OceanBase error code: 5084
Cause: Type conversion error.
Solution: Contact technical support for assistance.
ERROR 5085 (22000) : Not a number Can not cast varchar value to number type
OceanBase error code: 5085
Cause: Type conversion error.
Solution: Contact technical support for assistance.
ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type
OceanBase error code: 5086
Cause: Type conversion error.
Solution: Contact technical support for assistance.
ERROR 5087 (22000) : Result value was out of range when cast to number
OceanBase error code: 5087
Cause: Value out of range.
Solution: Contact technical support for assistance.
ERROR 5090 (22000) : Precision was out of range
OceanBase error code: 5090
Cause: Precision out of range.
Solution: Contact technical support for assistance.
ERROR 5091 (22000) : Scale value was out of range
OceanBase error code: 5091
Cause: Precision out of range.
Solution: Contact technical support for assistance.
ERROR 5092 (42000) : Unknown index
OceanBase error code: 5092
Cause: The index is unknown.
Solution: Check whether the index is used incorrectly in the API.
ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'
OceanBase error code: 5098
Cause: The numeric input exceeds the limit.
Solution: Reduce the length of the number.
ERROR 5099 (42000) : System config unknown
OceanBase error code: 5099
Cause: The parameter is invalid.
Solution: Check whether the parameter name is correct.
ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument
OceanBase error code: 5106
Cause: The data type is incorrect.
Solution: Contact technical support for assistance.
ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s
OceanBase error code: 5107
Cause: The parameter of the
ISexpression is incorrect.Solution: Contact technical support for assistance.
ERROR 5108 (42000) : function LENGTH() expected a varchar argument
OceanBase error code: 5108
Cause: The parameter of the
LENGTHexpression is incorrect.Solution: Contact technical support for assistance.
ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument
OceanBase error code: 5110
Cause: The parameter of the
TIME_TO_USECfunction can only be of theVARCHAR,TIME,DATATIME, orTIMESTAMPtype.Solution: Modify the parameter type.
ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument
OceanBase error code: 5111
Cause: The parameter of the
USEC_TO_TIMEfunction can only be of theTINYINT,MEDIUMINT,INT, orBIGINTtype.Solution: Modify the parameter type.
ERROR 5112 (42P01) : Variable %.*s does not exists
OceanBase error code: 5112
Cause: The variable does not exist.
Solution: Check if the variable spelling is incorrect.
ERROR 5114 (42000) : Invalid numeric char '%c'
OceanBase error code: 5114
Cause: Invalid digit.
Solution: Contact technical support for assistance.
ERROR 5116 (HY000) : Logical operator child index overflow
OceanBase error code: 5116
Cause: Kernel error.
Solution: Contact technical support for assistance.
ERROR 5117 (HY000) : fail to explain plan
OceanBase error code: 5117
Cause: Error occurred during plan generation.
Solution: Contact technical support for assistance.
ERROR 5118 (HY000) : fail to copy logical operator
OceanBase error code: 5118
Cause: An error occurred while generating the execution plan.
Solution: Contact technical support for assistance.
ERROR 5119 (HY000) : fail to generate plan
OceanBase error code: 5119
Cause: An error occurred while generating the execution plan.
Solution: Contact technical support for assistance.
ERROR 5120 (HY000) : fail to create raw expr
OceanBase error code: 5120
Cause: An error occurred during plan generation.
Solution: Contact technical support for assistance.
ERROR 5121 (HY000) : fail to generate join order
OceanBase error code: 5121
Cause: An error occurred during plan generation.
Solution: Contact technical support for assistance.
ERROR 5122 (HY000) : optimizer general error
OceanBase error code: 5122
Cause: An error occurred during plan generation.
Solution: Contact technical support for assistance.
ERROR 5130 (HY000) : sql resolver no memory
OceanBase error code: 5130
Cause: Insufficient memory.
Solution: Increase the SQL memory or contact technical support for assistance.
ERROR 5131 (HY000) : plan cache support dml only
OceanBase error code: 5131
Cause:
OUTLINEbinding was performed on a non-DML statement.Solution: Do not perform
OUTLINEbinding on non-DML statements.
ERROR 5133 (42000) : No such grant defined
OceanBase error code: 5133
Cause: The specified privilege was not granted when revoking it.
ERROR 5136 (HY000) : plan exists in plan cache already
OceanBase error code: 5136
Cause: The execution plan already exists in the plan cache when it was added.
Solution: This is an internal error code. Please contact technical support for assistance.
ERROR 5137 (HY000) : plan is expired
OceanBase error code: 5137
Cause: The plan has expired.
Solution: This is an internal error code. Please contact technical support for assistance.
ERROR 5138 (HY000) : no plan exist
OceanBase error code: 5138
Cause: The plan does not exist when getting the plan.
Solution: This is an internal error code. Please contact technical support for assistance.
ERROR 5144 (HY000) : COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'
OceanBase error code: 5144
Cause: One of the following situations may have occurred:
The string operands of operators or built-in functions (except for
nlsparamsparameters) use different character sets.The
nlsparamsoperand is not in the database character set.The string data passed to a built-in function uses a character set other than the database character set, but the built-in function does not accept that character set.
The second parameter of
CHR()orCSCONVERT()is notCHAR_CSorNCHAR_CS.The character set of a string expression in the
VALUESclause of anINSERTstatement or in theSETclause of anUPDATEstatement is inconsistent with the character set used by the column to be inserted.The character set of the value provided in the
DEFAULTclause when creating a table is inconsistent with the character set declared for the column.The parameter of a
PL/SQLfunction does not meet the character set requirements of the corresponding parameter.
ERROR 5150 (HY000) : Tenant not in this server
OceanBase error code: 5150
Cause: The server does not have resources for the corresponding tenant.
Solution: Retry. If this issue persists, please contact technical support for assistance.
ERROR 5151 (42P01) : tablegroup not exist
OceanBase error code: 5151
Cause: The table group does not exist. An invalid table group name was specified.
Solution: Check whether the table group name is correct.
ERROR 5156 (HY000) : tenant \'%s\' already exist
OceanBase error code: 5156
Cause: The created tenant has a duplicate name or an internal error occurred.
Solution: If the tenant name is duplicated, modify the tenant name and create it again. For other scenarios, contact technical support for assistance.
ERROR 5157 (HY000) : Unknown tenant '%.*s'
OceanBase error code: 5157
Cause: Schema refresh is lagging, or the tenant has been deleted.
Solution: Retry. If this issue persists, contact technical support for assistance.
ERROR 5159 (HY000) : tablegroup already exist
OceanBase error code: 5159
Cause: The table group already exists.
Solution: Check whether the table group name is correct.
ERROR 5160 (HY000) : invalid tenant name specified in connection string
OceanBase error code: 5160
Cause: The specified tenant name does not exist.
Solution: Confirm whether the specified tenant exists. If it exists, contact technical support for assistance.
ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key
OceanBase error code: 5212
Cause: An auto-increment column cannot be part of the partitioning key.
Solution: Remove the auto-increment column from the partitioning key.
ERROR 5223 (42000) : wrong ident name
OceanBase error code: 5223
Cause: The variable name is incorrect.
Solution: Use a valid variable name.
ERROR 5226 (42000) : plan cache memory used reach the high water mark
OceanBase error code: 5226
Cause: The memory used by the plan cache has reached its upper limit, and eviction is automatically triggered.
Solution: Increase the upper limit for plan cache memory.
ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement
OceanBase error code: 5234
Cause: An operation was performed on a read-only database.
Solution: Do not operate on a read-only database.
ERROR 5235 (HY000) : The table \'%.*s.%.*s\' is read only so it cannot execute this statement
OceanBase error code: 5235
Cause: An operation was performed on a read-only table.
Solution: Do not operate on a read-only table.
ERROR 5243 (HY000) : system variables' version maybe different
OceanBase error code: 5243
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d
OceanBase error code: 5245
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'
OceanBase error code: 5248
Cause: Adding an auto-increment column while modifying a table is not recommended.
Solution: We recommend that you perform this operation only when the table contains no data.
ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes
OceanBase error code: 5252
Cause: A column is defined as both
NULLandNOT NULL.Solution: Specify only one attribute.
ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576
OceanBase error code: 5258
Cause: The specified block size is invalid.
Solution: Modify the block size.
ERROR 5260 (HY000) : Tenant \'%.*s\' is locked
OceanBase error code: 5260
Cause: The tenant is locked.
Solution: Unlock the tenant.
ERROR 5264 (HY000) : Outline '%.*s' already exists
OceanBase error code: 5264
Cause: The
OUTLINEalready exists.Solution: Check whether it is bound to the same
OUTLINEby other SQL statements.
ERROR 5265 (HY000) : Outline \'%.*s.%.*s\' doesn\'t exist
OceanBase error code: 5265
Cause: The specified
OUTLINEdoes not exist.Solution: Check whether the corresponding
OUTLINEhas been created.
ERROR 5267 (HY000) : invalid outline ,error info:%s
OceanBase error code: 5267
Cause: The specified
OUTLINEis invalid.Solution: Contact technical support for assistance.
ERROR 5268 (HY000) : SQL reach max concurrent num %ld
OceanBase error code: 5268
Cause: The SQL throttling upper limit is reached.
Solution: Reduce the concurrency.
ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin
OceanBase error code: 5269
Cause: You cannot operate on objects in the recycle bin.
Solution: Restore the object from the recycle bin and then perform the operation.
ERROR 5270 (HY000) : object not in RECYCLE BIN
OceanBase error code: 5270
Cause: The object is not in the recycle bin.
Solution: Contact technical support for assistance.
ERROR 5272 (HY000) : Outline content '%.*s' of outline '%.*s' already exists when added
OceanBase error code: 5272
Cause: The
OUTLINEhas already been created.Solution: Check whether the previously created
OUTLINEmeets your expectations. If it does, you do not need to create anotherOUTLINE. If it does not, you can executeDROP OUTLINEand then recreate it.
ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added
OceanBase error code: 5273
Cause: The throttling rule to be created already exists.
Solution: Check whether the throttling statement contains an existing throttling rule.
ERROR 5278 (HY000) : This partition value with incorrect charset type
OceanBase error code: 5278
Cause: The meta information of the partition value is inconsistent.
Solution: Modify the partition value to make its meta information consistent.
ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list
OceanBase error code: 5291
Cause: The
CTXCATfields must be contiguous.Solution: Adjust the
CTXCATfields or contact technical support for assistance.
ERROR 5296 (42000) : there has no readable replica
OceanBase error code: 5296
Cause: No available replica was selected during plan generation.
Solution: Contact technical support for troubleshooting.
ERROR 5297 (HY000) : unexpected time zone info transition
OceanBase error code: 5297
Cause: Gap or overlap time is used.
Solution: Use non-gap time or set the
error_on_overlap_timevariable tofalse.
ERROR 5298 (HY000) : synonym '%.*s' already exists
OceanBase error code: 5298
Cause: The synonym already exists.
Solution: Check for conflicting synonym names and create a synonym with a different name.
ERROR 5299 (HY000) : synonym \'%.*s.%.*s\' doesn\'t exist
OceanBase error code: 5299
Cause: The synonym does not exist.
Solution: Check whether an non-existent synonym is used.
ERROR 5300 (HY000) : missing ORDER BY expression in the window specification
OceanBase error code: 5300
Cause: The
ORDER BYexpression is missing in the window function.Solution: Add the relevant
ORDER BYexpression to the window function.
ERROR 5301 (HY000) : The argument of the window function should be a constant for a partition
OceanBase error code: 5301
Cause: The parameter in the window function must be a constant.
Solution: Modify the relevant parameter in the window function to a constant value.
ERROR 5307 (HY000) : Not enough thread resource to execute the query. Require setting parallel_servers_target to a value no less than %ld for this query
OceanBase error code: 5307
Cause: Insufficient execution threads.
Solution: Increase the value of the
parallel_servers_targetsystem variable.
ERROR 5309 (HY000) : Ignore sql in restore process
OceanBase error code: 5309
Cause: Specific SQL statements need to be skipped during logical restore.
Solution: No action required.
ERROR 5311 (HY000) : Invalid column id for %.*s
OceanBase error code: 5311
Cause: Invalid column
ID.Solution: Contact technical support for assistance.
ERROR 5312 (HY000) : Duplicated ddl id '%.*s'
OceanBase error code: 5312
Cause: Duplicate DDL
ID.Solution: Contact technical support for assistance.
ERROR 5319 (HY000) : Child column \'%.*s\' data length cannot be less than parent column \'%.*s\' data length
OceanBase error code: 5319
Cause: The length of a foreign key field cannot be less than the length of the referenced field.
Solution: Adjust the lengths of the related fields.
ERROR 5320 (HY000) : \'%.*s\': used in a foreign key constraint
OceanBase error code: 5320
Cause: The field is used in a foreign key constraint.
Solution: The field cannot be operated on.
ERROR 5325 (HY000) : ORDER SIBLINGS BY clause not allowed here
OceanBase error code: 5325
Cause: The
ORDER SIBLINGS BYclause is used in an incorrect location.Solution: The
ORDER SIBLINGS BYclause can only be used in hierarchical query statements.
ERROR 5326 (HY000) : when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value
OceanBase error code: 5326
Cause: The column value contains a string that the
SYS_CONNECT_BY_PATHfunction uses to separate the values.Solution: Specify another separator for the
SYS_CONNECT_BY_PATHfunction. Ensure this separator is not contained in any column value, and then try the operation again.
ERROR 5327 (HY000) : Database can not be specified in public synonym
OceanBase error code: 5327
Cause: A database was specified when using the public synonym.
Solution: For the use of public synonyms, there is no need to execute DATABASE.
ERROR 5328 (HY000) : Looping chain of synonyms
OceanBase error code: 5328
Cause: A circularly dependent synonym was created.
Solution: Check for circularly dependent synonyms and create synonyms with different names to break the cycle.
ERROR 5329 (HY000) : Cannot create a synonym with same name as object
OceanBase error code: 5329
Cause: The synonym name is the same as the object name.
Solution: Create a synonym with a name different from the object name.
ERROR 5330 (HY000) : Synonym %s translation is no longer valid
OceanBase error code: 5330
Cause: The object corresponding to the synonym does not exist.
Solution: Create the object that the synonym depends on.
ERROR 5331 (HY000) : name is already used by an existing object
OceanBase error code: 5331
Cause: The object already exists.
Solution: The object involved in PL already exists and cannot be created repeatedly.
ERROR 5337 (HY000) : rowid is wrong
OceanBase error code: 5337
Cause: The content parsed from
ROWIDdoes not meet expectations.Solution: Pass a valid
ROWID.
ERROR 5338 (HY000) : Window Function not allowed here
OceanBase error code: 5338
Cause: A window function appears in an expression within the SQL statement.
Solution: Remove the window function from the corresponding expression in the SQL statement.
ERROR 5339 (HY000) : Fail to parse list partition
OceanBase error code: 5339
Cause: The number of partitions defined does not match the partition specification clause in the LIST partition definition.
Solution: Modify the partition count definition.
ERROR 5341 (HY000) : timezone region ID is invalid
OceanBase error code: 5341
Cause: The
Region IDrecorded in theTIMESTAMPdata cannot be parsed.Solution: Contact technical support for assistance.
ERROR 5342 (HY000) : invalid hex number
OceanBase error code: 5342
Cause: Invalid hexadecimal.
Solution: Contact technical support for assistance.
ERROR 5343 (42000) : wrong number or types of arguments in call to '%.*s'
OceanBase error code: 5343
Cause: Incorrect parameter list.
Solution: Check the parameter list.
ERROR 5345 (HY000) : insufficient parallel query worker available
OceanBase error code: 5345
Cause: Insufficient PX threads.
Solution: Increase the number of PX threads.
ERROR 5346 (HY000) : FOR UPDATE of this query expression is not allowed
OceanBase error code: 5346
Cause: An invalid expression is specified in the
FOR UPDATEclause.Solution: Modify the
FOR UPDATEsyntax.
ERROR 5347 (HY000) : argument should be a function of expressions in PARTITION BY
OceanBase error code: 5347
Cause: Parsing error.
Solution: Modify the SQL statement.
ERROR 5348 (HY000) : result of string concatenation is too long
OceanBase error code: 5348
Cause: The concatenated characters by using the
WM_CONCATfunction are too long.Solution: Check whether the length after concatenation exceeds the value of
group_concat_max_len. If so, increase the value ofgroup_concat_max_len.
ERROR 5350 (HY000) : updating partition key column would cause a partition change
OceanBase error code: 5350
Cause: An
UPDATEoperation causes the partition of the row to change.Solution: Use the
ALTER TABLEstatement to enable theENABLE ROW MOVEMENTclause for the table.
ERROR 5351 (HY000) : invalid type given for an argument
OceanBase error code: 5351
Cause: The parameter type is incorrect.
Solution: Check the parameter type.
ERROR 5352 (HY000) : specified field not found in datetime or interval
OceanBase error code: 5352
Cause: Invalid data is detected during time zone conversion.
Solution: Contact technical support for assistance.
ERROR 5360 (HY000) : insufficient privileges
OceanBase error code: 5360
Cause: Insufficient privileges.
Solution: Grant the corresponding privileges.
ERROR 5361 (HY000) : user %.*s lacks CREATE SESSION privilege; logon denied
OceanBase error code: 5361
Cause: The user does not have the login privilege.
Solution: Grant the user the login privilege.
ERROR 5363 (HY000) : system privileges not granted to '%.*s'
OceanBase error code: 5363
Cause: The user has not been granted system privileges.
Solution: Grant the user the corresponding system privileges.
ERROR 5364 (HY000) : only SELECT and ALTER privileges are valid for sequences
OceanBase error code: 5364
Cause: Privileges other than
SELECTandALTERhave been granted to the SEQUENCE object.Solution: Do not grant privileges other than
SELECTandALTERto a SEQUENCE object.
ERROR 5365 (HY000) : EXECUTE privilege not allowed for tables
OceanBase error code: 5365
Cause: The
EXECUTEprivilege has been granted to a table.Solution: Do not grant the
EXECUTEprivilege to a table.
ERROR 5366 (HY000) : only EXECUTE and DEBUG privileges are valid for procedures
OceanBase error code: 5366
Cause: Privileges other than
EXECUTEandDEBUGhave been granted to the PROCEDURE object.Solution: Do not grant privileges other than
EXECUTEandDEBUGto a PROCEDURE object.
ERROR 5367 (HY000) : only EXECUTE, DEBUG, and UNDER privileges are valid for types
OceanBase error code: 5367
Cause: Privileges other than
EXECUTE,DEBUG, andUNDERhave been granted to a TYPE object.Solution: Do not grant privileges other than
EXECUTE,DEBUG, andUNDERto a TYPE object.
ERROR 5368 (HY000) : ADMIN option not granted for role '%.*s'
OceanBase error code: 5368
Cause: The role does not have the corresponding ADMIN option.
Solution: Grant the ADMIN option to the user's role.
ERROR 5369 (HY000) : user or role '%.*s' does not exist
OceanBase error code: 5369
Cause: The user does not exist.
Solution: Check whether the username is misspelled. If so, correct it to the correct one. If not, create the required username.
ERROR 5370 (HY000) : missing ON keyword
OceanBase error code: 5370
Cause: The
ONkeyword is missing.Solution: Add the
ONkeyword.
ERROR 5371 (HY000) : grant option does not exist for '%.*s.%.*s'
OceanBase error code: 5371
Cause: The user does not have the corresponding sub-authorization permission.
Solution: Add the corresponding sub-authorization permission.
ERROR 5372 (HY000) : ALTER, INDEX and EXECUTE not allowed for views
OceanBase error code: 5372
Cause: Granting the
ALTER,INDEX, orEXECUTEprivilege to a VIEW object.Solution: Do not grant the
ALTER,INDEX, orEXECUTEprivilege to a VIEW object.
ERROR 5373 (HY000) : circular role grant detected
OceanBase error code: 5373
Cause: Circular authorization has occurred for roles.
Solution: Avoid circular authorization for roles.
ERROR 5374 (HY000) : invalid privilege on directories
OceanBase error code: 5374
Cause: An invalid privilege was granted on a directory object.
Solution: Grant the correct privilege for operating on the directory object.
ERROR 5375 (HY000) : directory access denied
OceanBase error code: 5375
Cause: The user does not have the permission to operate on this directory.
Solution: If you need access to this directory, contact the system administrator to grant the user permission to operate on this directory.
ERROR 5376 (HY000) : missing or invalid role name
OceanBase error code: 5376
Cause: The role name is incorrect.
Solution: Correct the role name.
ERROR 5377 (HY000) : role '%.*s' not granted or does not exist
OceanBase error code: 5377
Cause: The role has not been granted, or it does not exist.
ERROR 5378 (HY000) : DEFAULT ROLE '%.*s' not granted to user
OceanBase error code: 5378
Cause: The default role has not been granted to the user.
Solution: Grant the default role to the user.
ERROR 5379 (HY000) : ROLE '%.*s' not granted to '%.*s'
OceanBase error code: 5379
Cause: When revoking a role from a user, it was found that the role had not been granted to the user.
ERROR 5380 (HY000) : cannot GRANT to a role WITH GRANT OPTION
OceanBase error code: 5380
Cause: When a user tries to grant a role with the
WITH GRANT OPTIONclause, it is found that they do not have the required grant option.Solution: Add the grant option to the user's privileges.
ERROR 5381 (HY000) : duplicate username in list
OceanBase error code: 5381
Cause: The
GRANTstatement contains duplicate users.Solution: Remove the duplicate users.
ERROR 5382 (HY000) : cannot grant %.*s to a role
OceanBase error code: 5382
Cause: You cannot grant the
REFERENCEorINDEXprivilege to a role.Solution: Remove the
REFERENCEorINDEXprivilege granted to the role.
ERROR 5383 (HY000) : CASCADE CONSTRAINTS must be specified to perform this revoke
OceanBase error code: 5383
Cause: The
CASCADE CONSTRAINTSclause must be specified in theREVOKEstatement.Solution: Specify
CASCADE CONSTRAINTS.
ERROR 5384 (HY000) : you may not GRANT/REVOKE privileges to/from yourself
OceanBase error code: 5384
Cause: Granting or revoking privileges on oneself.
Solution: OceanBase AI Database does not support users granting or revoking their own privileges. If you need to modify your own privileges, contact the system administrator to perform the relevant operations.
ERROR 5386 (HY000) : Unable to read data -* Table definition has changed
- OceanBase error code: 5386
- Compatible MySQL error code: 1412
- Cause: The table definition has changed, and the snapshot point read is too old, making it impossible to read or parse correctly.
- Solution: Check if the table definition has changed, confirming whether there have been additions or deletions of columns, modifications to data types or lengths, etc.
ERROR 5401 (HY000) : resultant data type of virtual column is not supported
OceanBase error code: 5401
Cause: A generated column cannot reference a large object type.
Solution: Remove the large object type.
ERROR 5403 (HY000) : ddl schema version not match
OceanBase error code: 5403
Cause: Concurrent DDL conflict.
Solution: Rerun the DDL.
ERROR 5409 (HY000) : Duplicate object name exists, schema refreshing may be hung
OceanBase error code: 5409
Cause: A duplicate object name was encountered during DDL thread execution.
Solution: Contact technical support for assistance.
ERROR 5410 (HY000) : Refresh schema failed continuously, ddl may be hung
- OceanBase error code: 5410
- Cause: The DDL thread is hung and cannot receive new DDL requests.
- Solution: Contact technical support for assistance.
ERROR 5434 (HY000) : retry sql due to spm
OceanBase error code: 5434
Cause: The SQL statement needs to be automatically retried because of the SPM feature.
Solution: Contact technical support for assistance.
ERROR 5435 (HY000) : outline not reproducible
OceanBase error code: 5435
Cause: The plan specified by the outline cannot be reproduced.
Solution: Contact technical support for assistance.
ERROR 5436 (42000) : TIMESTAMP_TO_SCN expected timestamp argument
OceanBase error code: 5436
Cause: The parameter type does not meet expectations. The TIMESTAMP_TO_SCN function expects a TIMESTAMP type parameter.
Solution: Modify the function's parameters.
ERROR 5437 (42000) : SCN_TO_TIMESTAMP expected a integer number as nsec argument
OceanBase error code: 5437
Cause: The parameter type does not meet expectations. The SCN_TO_TIMESTAMP function expects an integer type parameter.
Solution: Modify the function's parameters.
ERROR 5500 (HY000) : Legitimacy check failed for generated columns
- OceanBase error code: 5500
- Cause: During the legitimacy check for the values in generated columns or functional indexes, it was found that the stored values differ from the recalculated values based on the column/index definitions in the current environment. This may be due to using built-in functions whose computation results are affected by system variables or whose behavior is inherently uncertain to define the generated columns/indexes. If the
_enable_defensive_checkparameter is enabled, a defensive error is reported. - Solution: Check the definitions of the generated columns and functional indexes. If it is confirmed that the change in computation result is caused by a change in system variables, drop the generated column/index and recreate it. For other situations or if the issue persists, contact technical support for assistance.
ERROR 5540 (HY000) : System variable '%.*s' is different from the old value solidified for '%.*s'(old value:%.*s)
OceanBase error code: 5540
Cause: The system variable value set in the current session differs from the value that was solidified when creating the functional index or generated column. During calculations, the functional index or generated column uses the value that was solidified when they were created, not the current variable value in the session.
Solution: If you need to calculate based on the current session's system variable values, drop and recreate the generated column or functional index.
ERROR 5558 (42000) : %s \'%.*s.%.*s\' already exists
OceanBase error code: 5558
Cause: The package to be created already exists.
Solution: You can use the
CREATE [OR REPLACE]statement to create it. After creation, any previously existing package with the same name will be overwritten.
ERROR 5559 (42000) : %s \'%.*s.%.*s\' does not exist
OceanBase error code: 5559
Cause: The accessed package does not exist.
Solution: Check whether the logic is correct.
ERROR 5561 (HY000) : Invalid use of window function
OceanBase error code: 5561
Cause: An invalid window function is used, such as unreasonable parameter settings.
Solution: Modify the window to use a valid window function.
ERROR 5562 (HY000) : Duplicate constraint name '%.*s'
OceanBase error code: 5562
Cause: The constraint name already exists.
Solution: Change the constraint name.
ERROR 5563 (HY000) : Constraint not found
OceanBase error code: 5563
Cause: The constraint to be operated on does not exist.
Solution: Check whether the constraint name is correct.
ERROR 5564 (HY000) : Duplicate alter index operations on column \'%.*s\'
OceanBase error code: 5564
Cause: In the same SQL statement, the
ALTER INDEXoperation is repeatedly performed on the same column.Solution: Modify the SQL statement.
ERROR 5572 (HY000) : a partition may be split into exactly two new partitions
OceanBase error code: 5572
Cause: The number of partitions specified for the
SPLIToperation is not 2.Solution: Specify to split the partition into two.
ERROR 5573 (HY000) : this physical attribute may not be specified for a table partition
OceanBase error code: 5573
Cause: The maximum value is not supported at the split point during partition splitting.
Solution: Fix the split point.
ERROR 5574 (HY000) : missing VALUES keyword
OceanBase error code: 5574
Cause: Syntax error.
Solution: Add the
VALUESkeyword.
ERROR 5575 (HY000) : missing AT or VALUES keyword
OceanBase error code: 5575
Cause: Syntax error.
Solution: Add the
ATorVALUESkeyword.
ERROR 5578 (HY000) : Plan cache lock conflict
OceanBase error code: 5578
Cause: Locking failed in the plan cache.
Solution: Please try again.
ERROR 5597 (HY000) : last resulting partition cannot contain bounds
OceanBase error code: 5597
Cause: The partition range is inconsistent before and after splitting.
Solution: Modify the SQL statement.
ERROR 5598 (HY000) : cannot add partition when DEFAULT partition exists
OceanBase error code: 5598
Cause: A default partition already exists in the LIST partition, so no new partition can be added.
Solution: Do not add a new partition. Instead, use the method of splitting a partition to add a new one.
ERROR 5599 (HY000) : cannot split partition into one partition, use rename instead
OceanBase error code: 5599
Cause: Partition splitting is not allowed when the destination has only one partition.
ERROR 5600 (HY000) : can not create user %s in sys tenant, name %.*s
OceanBase error code: 5600
Cause: Users cannot be created in the sys tenant.
ERROR 5601 (HY000) : Percentage should between 1 and 99
OceanBase error code: 5601
Cause: Parsing error.
Solution: Modify the SQL statement.
ERROR 5603 (0A000) : Attempt to create, alter or drop an index on temporary table already in use
OceanBase error code: 5603
Cause: An attempt was made to create, alter, or drop an index on a temporary table that is already in use.
Solution: Disconnect all sessions that are using the temporary table, then perform the operation.
ERROR 5604 (HY000) : invalid NLS parameter string used in SQL function
OceanBase error code: 5604
Cause: An invalid time type parameter was used.
Solution: Contact technical support for assistance.
ERROR 5605 (HY000) : datetime/interval precision is out of range
OceanBase error code: 5605
Cause: The precision of a time type exceeds the limit.
Solution: Contact technical support for assistance.
ERROR 5606 (42000) : Invalid number format model
OceanBase error code: 5606
Cause: An invalid number format.
Solution: Contact technical support for assistance.
ERROR 5607 (HY000) : SQL command not properly ended
OceanBase error code: 5607
Cause: The command was not terminated correctly.
Solution: Check the command syntax.
ERROR 5608 (42000) : invalid number format model
OceanBase error code: 5608
Cause: The number format is invalid.
Solution: Contact technical support for assistance.
ERROR 5613 (HY000) : too many values
OceanBase error code: 5613
Cause: Too many values were specified in the statement, commonly seen in
INSERTstatements.Solution: Adjust the number of values or contact technical support for assistance.
ERROR 5614 (HY000) : not enough values
OceanBase error code: 5614
Cause: Insufficient values were specified in the statement, commonly seen in
INSERTstatements.Solution: Adjust the number of values or contact technical support for assistance.
ERROR 5615 (HY000) : single-row subquery returns more than one row
OceanBase error code: 5615
Cause: The scalar subquery expression is incorrect. It is expected to return one row but actually returns multiple rows.
Solution: Check the scalar subquery expression to ensure it returns only one row of results each time.
ERROR 5616 (HY000) : UPDATE ... SET expression must be a subquery
OceanBase error code: 5616
Cause: In a rowset assignment scenario, the
SETclause of anUPDATEstatement must be asubquery.Solution: Adjust the syntax of the
UPDATESETclause or contact technical support for assistance.
ERROR 5617 (HY000) : inappropriate INTO
OceanBase error code: 5617
Cause: The
INTOclause is used incorrectly.Solution: Contact technical support for assistance.
ERROR 5619 (HY000) : Column part of using clause can not have qualifier
OceanBase error code: 5619
Cause: Column names in the
USINGclause cannot containdatabase nameortable name.Solution: Remove
database nameortable namefrom the column names in theUSINGclause.
ERROR 5623 (HY000) : outer join operator (+) not allowed in operand of OR or IN
OceanBase error code: 5623
Cause: An outer join appears in an
ORclause.Solution: Modify the SQL statement.
ERROR 5624 (HY000) : a column may not be outer-joined to a subquery
OceanBase error code: 5624
Cause: A column in an
+outer join cannot be externally joined to a subquery.Solution: Modify the SQL statement.
ERROR 5625 (HY000) : old style outer join (+) cannot be used with ANSI joins
OceanBase error code: 5625
Cause: When a query block uses ANSI-style joins, the old notation for specifying outer joins (+) cannot be used.
Solution: Modify the SQL statement.
ERROR 5626 (HY000) : outer join operator (+) is not allowed here
OceanBase error code: 5626
Cause: You tried to reference the (+) operator in the
SELECT list,CONNECT BYclause,START WITHclause, orORDER BYclause.Solution: Modify the SQL statement.
ERROR 5627 (HY000) : Schema try again
OceanBase error code: 5627
Cause: The local schema version is outdated.
Solution: Retry or contact support personnel for assistance.
ERROR 5628 (HY000) : zero-length columns are not allowed
OceanBase error code: 5628
Cause: The column data length is 0.
Solution: Contact technical support for assistance.
ERROR 5629 (HY000) : year conflicts with Julian date
OceanBase error code: 5629
Cause: The year conflicts with the Julian date. For example,
SELECT TO_DATE('2021-03-23 2459063', 'YYYY MM DD J') FROM DUAL;.
ERROR 5630 (HY000) : day of year conflicts with Julian date
OceanBase error code: 5630
Cause: The day of the year (1 - 366) conflicts with the Julian date.
ERROR 5631 (HY000) : month conflicts with Julian date
OceanBase error code: 5631
Cause: The month conflicts with the Julian date. For example,
SELECT TO_DATE('11 2459063','MM J') FROM DUAL;.
ERROR 5632 (HY000) : day of month conflicts with Julian date
OceanBase error code: 5632
Cause: The day of the month (1 - 31) conflicts with the Julian date. For example,
SELECT TO_DATE('11 2459063','DD J') FROM DUAL;.
ERROR 5633 (HY000) : day of week conflicts with Julian date
OceanBase error code: 5633
Cause: The day of the week (1 - 7) conflicts with the Julian date. For example,
SELECT TO_DATE('3 2459063','D J') FROM DUAL;.
ERROR 5634 (HY000) : hour conflicts with seconds in day
OceanBase error code: 5634
Cause: The hour conflicts with the seconds in a day.
ERROR 5635 (HY000) : minutes of hour conflicts with seconds in day
OceanBase error code: 5635
Cause: The minutes in an hour conflict with the seconds in a day.
ERROR 5636 (HY000) : seconds of minute conflicts with seconds in day
OceanBase error code: 5636
Cause: Seconds in a minute conflict with seconds in a day.
ERROR 5637 (HY000) : date not valid for month specified
OceanBase error code: 5637
Cause: The date is invalid for the specified month.
ERROR 5638 (HY000) : input value not long enough for date format
OceanBase error code: 5638
Cause: The input value is not long enough to be used as a date format.
ERROR 5639 (HY000) : (full) year must be between -4713 and +9999, and not be 0
OceanBase error code: 5639
Cause: The year of a valid date must be between 1 and 9999.
ERROR 5640 (HY000) : quarter must be between 1 and 4
OceanBase error code: 5640
Cause: The value of quarter must be between 1 and 4.
ERROR 5641 (HY000) : not a valid month
OceanBase error code: 5641
Cause: Not a valid month.
ERROR 5642 (HY000) : not a valid day of the week
OceanBase error code: 5642
Cause: Not a valid day of the week.
ERROR 5643 (HY000) : day of year must be between 1 and 365 (366 for leap year)
OceanBase error code: 5643
Cause: The value of day in a year must be between 1 and 365 (366 in a leap year).
ERROR 5644 (HY000) : hour must be between 1 and 12
OceanBase error code: 5644
Cause: The hour must be between 1 and 12.
ERROR 5645 (HY000) : hour must be between 0 and 23
OceanBase error code: 5645
Cause: The hour must be between 0 and 23.
ERROR 5646 (HY000) : minutes must be between 0 and 59
OceanBase error code: 5646
Cause: The minutes must be between 0 and 59.
ERROR 5647 (HY000) : seconds must be between 0 and 59
OceanBase error code: 5647
Cause: The seconds must be between 0 and 59.
ERROR 5648 (HY000) : seconds in day must be between 0 and 86399
OceanBase error code: 5648
Cause: The number of seconds in a day must be between 0 and 86399.
ERROR 5649 (HY000) : julian date must be between 1 and 5373484
OceanBase error code: 5649
Cause: An invalid Julian date was entered.
Solution: The entered Julian date must be between 1 and 5373484.
ERROR 5650 (HY000) : AM/A.M. or PM/P.M. required
OceanBase error code: 5650
Cause: You must specify the date and time format as
AM,A.M.,PM, orP.M..
ERROR 5651 (HY000) : BC/B.C. or AD/A.D. required
OceanBase error code: 5651
Cause: You must specify the date and time format as
BC,B.C.,AD, orA.D..
ERROR 5652 (HY000) : format code appears twice
OceanBase error code: 5652
Cause: The input format model is incorrect.
Solution: Contact technical support for assistance.
ERROR 5653 (HY000) : day of week may only be specified once
OceanBase error code: 5653
Cause: The day of the week can only be specified once.
ERROR 5654 (HY000) : signed year precludes use of BC/AD
OceanBase error code: 5654
Cause: A signed date cannot contain both
BCandAD.
ERROR 5655 (HY000) : Julian date precludes use of day of year
OceanBase error code: 5655
Cause: The Julian date and the day of the year cannot be used together.
ERROR 5656 (HY000) : year may only be specified once
OceanBase error code: 5656
Cause: The year can only be specified once.
ERROR 5657 (HY000) : hour may only be specified once
OceanBase error code: 5657
Cause: The hour can only be specified once.
ERROR 5658 (HY000) : AM/PM conflicts with use of A.M./P.M
OceanBase error code: 5658
Cause:
AMorPMconflicts with the correspondingA.M.orP.M ..
ERROR 5659 (HY000) : BC/AD conflicts with use of B.C./A.D
OceanBase error code: 5659
Cause:
BCorADconflicts with the correspondingB.C.orA.D..
ERROR 5660 (HY000) : month may only be specified once
OceanBase error code: 5660
Cause: The month can only be specified once.
ERROR 5661 (HY000) : day of week may only be specified once
OceanBase error code: 5661
Cause: The day of the week can be specified only once.
ERROR 5662 (HY000) : format code cannot appear in date input format
OceanBase error code: 5662
Cause: The format model is incorrect.
Solution: Check whether the number format model complies with syntax requirements.
ERROR 5663 (HY000) : a non-numeric character was found where a numeric was expected
OceanBase error code: 5663
Cause: An invalid numeric character was found.
Solution: Check whether there are invalid characters in the numbers of the SQL statement.
ERROR 5664 (HY000) : 'HH24' precludes use of meridian indicator
OceanBase error code: 5664
Cause: The
AMorPMcharacter appears in the H24 format model.Solution: Contact technical support for assistance.
ERROR 5665 (HY000) : missing or illegal character following the escape character
OceanBase error code: 5665
Cause: The character following the
ESCAPEfield in theLIKEquery statement is invalid.Solution: Check whether the character following the
ESCAPEfield in theLIKEstatement in the SQL statement complies with requirements.
ERROR 5666 (HY000) : escape character must be character string of length 1
OceanBase error code: 5666
Cause: The character following the
ESCAPEfield is not a single character duringLIKEcalculation.Solution: Specify a single character following the
ESCAPEfield.
ERROR 5667 (HY000) : day of month must be between 1 and last day of month
OceanBase error code: 5667
Cause: The value for the day of the month must be between 1 and the last day of the month.
ERROR 5668 (HY000) : not a SELECTed expression
OceanBase error code: 5668
Cause: An expression was specified in the
GROUP BYclause, but this expression does not appear in theSELECTclause.Solution: Modify the SQL syntax.
ERROR 5670 (HY000) : (full) year must be between -4713 and +9999, and not be 0
OceanBase error code: 5670
Cause: The year of a valid date must be between 1 and 9999.
ERROR 5671 (HY000) : such unique or primary key already exists in the table
OceanBase error code: 5671
Cause: A unique index already exists.
Solution: Unique indexes cannot be created repeatedly.
ERROR 5672 (HY000) : such column list already indexed
OceanBase error code: 5672
Cause: An index was created repeatedly.
Solution: Indexes cannot be created repeatedly.
ERROR 5674 (HY000) : argument '%ld' is out of range
OceanBase error code: 5674
Cause: The specified parameter is out of range.
Solution: Adjust the parameter value .
ERROR 5675 (HY000) : ORDER BY item must be the number of a SELECT-list expression
OceanBase error code: 5675
Cause: The
ORDER BYitem is not the correct number of aSELECTitem.Solution: Adjust the
ORDER BYclause in the SQL statement.
ERROR 5676 (HY000) : the interval is invalid
OceanBase error code: 5676
Cause: The parameter is invalid.
Solution: Contact technical support for assistance.
ERROR 5677 (HY000) : PL/SQL: numeric or value error: %.*s
OceanBase error code: 5677
Cause: Illegal numeric or other data types were encountered during PL execution.
Solution: Check the logic for correctness.
ERROR 5678 (HY000) : name already used by an existing constraint
OceanBase error code: 5678
Cause: The constraint name already exists.
Solution: Change the constraint name.
ERROR 5679 (HY000) : table must have at least one column that is not invisible
- OceanBase error code: 5679
- Compatible MySQL error code: 4028
- Cause: Function-based indexes add hidden columns to a table. This error is returned when all visible columns in the table are deleted while hidden columns exist.
- Solution: Check the column definitions and metadata of the table to ensure at least one column remains visible after the deletion operation.
ERROR 5681 (HY000) : Column visibility modifications cannot be combined with any other modified column DDL option
OceanBase error code: 5681
Cause: DDL statements do not support adjusting column visibility and other column attributes simultaneously.
Solution: Split the DDL statement to adjust column visibility separately.
ERROR 5682 (HY000) : The visibility of a column from a table owned by a SYS user cannot be changed
OceanBase error code: 5682
Cause: Column visibility cannot be adjusted for tables owned by the SYS user.
ERROR 5683 (HY000) : too many arguments for function
OceanBase error code: 5683
Cause: Too many function parameters.
Solution: Adjust the number of parameters.
ERROR 5684 (HY000) : PX sql need retry
OceanBase error code: 5684
Cause: Internal error code. Indicates that PX should retry the SQL.
Solution: This error generally does not occur. If encountered, check whether the system switchover and network status are normal.
ERROR 5685 (HY000) : Tenant '(string)' has been dropped
OceanBase error code: 5685
Cause: The tenant has been dropped.
Solution: This is an internal error code. Contact technical support for assistance.
ERROR 5686 (HY000) : invalid extract field for extract source
OceanBase error code: 5686
Cause: The
EXTRACTfunction cannot parse the specified domain.Solution: Check whether the specified domain is valid.
ERROR 5687 (42000) : %s \'%.*s.%.*s\' compile error
OceanBase error code: 5687
Cause: Package or UDT compilation failed.
Solution: Modify the error according to the error message prompt.
ERROR 5690 (HY000) : subquery not allowed here
OceanBase error code: 5690
Cause: Subqueries are not allowed at this position.
Solution: Contact technical support for assistance.
ERROR 5691 (HY000) : date or system variable wrongly specified in CHECK constraint
OceanBase error code: 5691
Cause: The
CHECKconstraint does not allow the use of theDATEfunction or system variables.
ERROR 5692 (HY000) : Cannot drop constraint - nonexistent constraint
OceanBase error code: 5692
Cause: The constraint does not exist.
ERROR 5693 (HY000) : check constraint violated
OceanBase error code: 5693
Cause: The
CHECKconstraint is not satisfied.Solution: Check whether the data of the columns involved in the DML operation satisfies the existing
CHECKconstraints.
ERROR 5694 (HY000) : group function is not allowed here
OceanBase error code: 5694
Cause: An aggregate function is used in an invalid location.
Solution: Adjust the aggregate functions in the SQL statement.
ERROR 5695 (HY000) : policy string not found
OceanBase error code: 5695
Cause: The security policy was not found.
Solution: Create a security policy.
ERROR 5696 (HY000) : invalid label string
OceanBase error code: 5696
Cause: The label string is invalid.
Solution: Specify a valid label string.
ERROR 5697 (HY000) : undefined compartment string for policy string
OceanBase error code: 5697
Cause: The compartment string is invalid.
Solution: Specify a valid compartment string.
ERROR 5698 (HY000) : undefined level string for policy string
OceanBase error code: 5698
Cause: The level string is invalid.
Solution: Specify a valid level string.
ERROR 5699 (HY000) : undefined group string for policy string
OceanBase error code: 5699
Cause: The group string is invalid.
Solution: Specify a valid group string.
ERROR 5700 (HY000) : LBAC error: %s
OceanBase error code: 5700
Cause: A general tag security error. For details, see the specific error message.
Solution: Modify the corresponding operation based on the error message.
ERROR 5701 (HY000) : policy role already exists for policy string
OceanBase error code: 5701
Cause: The policy name already exists.
Solution: Check and correct the policy name or delete the existing policy.
ERROR 5702 (HY000) : NULL or invalid user label: %s
OceanBase error code: 5702
Cause: The user label is invalid.
Solution: Specify a valid user label.
ERROR 5703 (HY000) : Add index failed
OceanBase error code: 5703
Cause: An error occurred while adding an index.
Solution: Check whether the index is valid. You can try to drop and recreate it.
ERROR 5704 (HY000) : profile %.*s does not exist
OceanBase error code: 5704
Cause: The profile name is incorrect.
Solution: Check the profile name.
ERROR 5705 (HY000) : invalid resource limit %s
OceanBase error code: 5705
Cause: In the profile-related DDL, the specified
FAILED_LOGIN_ATTEMPTSorPASSWORD_LOCK_TIMEis not a valid integer type, or its value is0.Solution: Adjust the parameter values in the related DDL of the profile.
ERROR 5706 (HY000) : profile %.*s already exists
OceanBase error code: 5706
Cause: The profile already exists.
Solution: Change the profile name .
ERROR 5707 (HY000) : profile %.*s has users assigned, cannot drop without CASCADE
OceanBase error code: 5707
Cause: The profile is in use by a user. It can only be deleted cascadingly.
Solution: Add
CASCADE.
ERROR 5708 (HY000) : the leading precision of the interval is too small
OceanBase error code: 5708
Cause: The precision is invalid.
Solution: Contact technical support for assistance.
ERROR 5709 (HY000) : time zone hour must be between -12 and 14
OceanBase error code: 5709
Cause: The hour value is out of the valid range when setting the
time_zonesystem variable.Solution: The valid range is [-12, 14].
ERROR 5710 (HY000) : time zone minute must be between -59 and 59
OceanBase error code: 5710
Cause: The minute value is out of the valid range when setting the
time_zonesystem variable.Solution: The valid range is [-59, 59].
ERROR 5711 (HY000) : not a valid time zone
OceanBase error code: 5711
Cause:
TZD,TZH,TZM, andTZRcannot be used in theDATEformat.
ERROR 5712 (HY000) : date format is too long for internal buffer
OceanBase error code: 5712
Cause: The length of the
DATEformat is too large.Solution: Reduce the length of the
DATEformat.
ERROR 5713 (HY000) : cannot validate (%.*s.%.*s) - check constraint violated
OceanBase error code: 5713
Cause: The input violates the constraint.
Solution: Contact technical support for assistance.
ERROR 5714 (HY000) : data manipulation operation not legal on this view
OceanBase error code: 5714
Cause: You attempted to modify an immutable view using
INSERT,UPDATE, orDELETEstatements, such as a view with generated columns, an expression-based column, or a view whose data comes from multiple tables.Solution: Modify the base table directly, or redefine the view.
ERROR 5715 (HY000) : virtual column not allowed here
OceanBase error code: 5715
Cause: You attempted to modify an expression in a view using
INSERT,DELETE, orUPDATEstatements.Solution: Modify the base table directly.
ERROR 5716 (HY000) : cannot modify more than one base table through a join view
OceanBase error code: 5716
Cause: A column belongs to multiple tables and cannot be inserted into or updated.
Solution: Split the statement into multiple statements.
ERROR 5721 (HY000) : cannot delete from view without exactly one key-preserved table
OceanBase error code: 5721
Cause: The table to be deleted has no key-preserved table, or has multiple key-preserved tables, or the key-preserved table is from a read-only view.
Solution: Redefine the view, or perform the deletion on the base table.
ERROR 5722 (HY000) : cannot modify a column which maps to a non key-preserved table
OceanBase error code: 5722
Cause: You attempted to insert or update a non-key-preserved table in a JOIN view.
Solution: Modify the base table directly.
ERROR 5723 (HY000) : cannot perform a DML operation on a read-only view
OceanBase error code: 5723
Cause: You attempted to modify a view defined as read-only using
INSERT,DELETE, orUPDATEstatements.Solution: Modify the base table directly, or modify the view to make it updatable.
ERROR 5724 (HY000) : invalid INITRANS option value
OceanBase error code: 5724
Cause: The value of the
INITRANSparameter is invalid.Solution: Adjust the parameter value.
ERROR 5725 (HY000) : invalid MAXTRANS option value
OceanBase error code: 5725
Cause: The value of the
MAXTRANSparameter is invalid.Solution: Adjust the parameter value.
ERROR 5726 (HY000) : invalid value for PCTFREE or PCTUSED
OceanBase error code: 5726
Cause: The value of the
PCTFREEorPCTUSEDparameter is invalid.Solution: Adjust the parameter value.
ERROR 5727 (HY000) : SQL request should be rerouted
OceanBase error code: 5727
Cause: The current SQL request needs to be redirected to another OBServer node for execution.
Solution:
- The normal workflow of OBProxy.
- If this error frequently appears in application logs, it may indicate improper OBProxy routing configuration, frequent cluster topology changes, or network or node stability issues.
ERROR 5728 (HY000) : illegal argument for function
OceanBase error code: 5728
Cause: The parameter is invalid.
Solution: Adjust the parameter value.
ERROR 5729 (HY000) : this operator cannot be used with lists
OceanBase error code: 5729
Cause: Vector comparison operations are not supported.
Solution: Remove the vector comparison operation.
ERROR 5730 (HY000) : SAMPLE percentage must be in the range [0.000001,100)
OceanBase error code: 5730
Cause: Parsing error.
Solution: Modify the SQL statement.
ERROR 5731 (HY000) : specifying owner's name of the table is not allowed
OceanBase error code: 5731
Cause: The table object involved in renaming cannot contain a username.
ERROR 5732 (HY000) : stmt trigger with when clause
OceanBase error code: 5732
Cause: A statement-level trigger cannot specify a
WHENcondition.Solution: Remove the
WHENcondition from the statement-level trigger.
ERROR 5732 (HY000) : not enough arguments for function
OceanBase error code: 5732
Cause: Insufficient number of function parameters.
Solution: Provide all required parameters.
ERROR 5733 (HY000) : trigger '%.*s' does not exist
OceanBase error code: 5733
Cause: The specified trigger does not exist.
Solution: Verify the existence of the specified trigger.
ERROR 5734 (HY000) : trigger '%.*s' already exist
OceanBase error code: 5734
Cause: The specified trigger already exists.
Solution: Verify the existence of the specified trigger.
ERROR 5735 (HY000) : trigger '%.*s' already exists on another table, cannot replace it
OceanBase error code: 5735
Cause: A trigger with the same name already exists on another table, preventing the creation of the current trigger.
Solution: Rename the current trigger and then create it again.
ERROR 5736 (HY000) : error signaled in parallel query server
OceanBase error code: 5736
Cause: An internal error code. When PX needs to terminate execution, it broadcasts this error code to all execution nodes to stop the current execution.
Solution: This is an internal error code. Please contact technical support for assistance in troubleshooting.
ERROR 5763 (HY000) : Specified pseudo column or operator not allowed here
OceanBase error code: 5763
Cause: The
LEVEL,PRIOR,ROWNUM,CONNECT_BY_ROOT,CONNECT_BY_ISLEAF, orCONNECT_BY_ISCYCLEkeywords are not allowed at this position.Solution: Remove the
LEVEL,PRIOR,ROWNUM,CONNECT_BY_ROOT,CONNECT_BY_ISLEAF, orCONNECT_BY_ISCYCLEkeyword.
ERROR 5764 (HY000) : CONNECT BY loop in user data
OceanBase error code: 5764
Cause: A
CONNECT BYloop exists in the user data.
ERROR 5765 (HY000) : cannot have join with CONNECT BY
OceanBase error code: 5765
Cause: Joins are not allowed with
CONNECT BY.
ERROR 5766 (HY000) : CONNECT BY clause required in this query block
OceanBase error code: 5766
Cause: A
CONNECT BYclause is required in this query block.
ERROR 5768 (HY000) : SYS_CONNECT_BY_PATH function is not allowed here
OceanBase error code: 5768
Cause: The
SYS_CONNECT_BY_PATHfunction is called outside theSELECTlist andORDER BYclause.Solution: Remove calls to the
SYS_CONNECT_BY_PATHfunction outside theSELECTlist andORDER BYclause.
ERROR 5769 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
OceanBase error code: 5769
Cause: The
SYS_CONNECT_BY_PATHfunction contains invalid parameters.
ERROR 5770 (HY000) : A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values
OceanBase error code: 5770
Cause: A column value contains the string that the
SYS_CONNECT_BY_PATHfunction uses to separate column values.Solution: Specify another separator for the
SYS_CONNECT_BY_PATHfunction, ensuring this separator is not present in any column value.
ERROR 5771 (HY000) : CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition
OceanBase error code: 5771
Cause: Attempted to use the
CONNECT BY ROOToperator in aSTART WITHorCONNECT BYcondition.Solution: Remove the
CONNECT BY ROOToperator from theSTART WITHorCONNECT BYcondition.
ERROR 5772 (HY000) : ORDER SIBLINGS BY clause not allowed here
OceanBase error code: 5772
Cause: The query with the specified
ORDER SIBLINGS BYclause does not contain aCONNECT BYclause.Solution: Remove the
ORDER SIBLINGS BYclause or add aCONNECT BYclause to the query.
ERROR 5773 (HY000) : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column
OceanBase error code: 5773
Cause: Specified
CONNECT_BY_ISCYCLEin the query, but the query does not contain theNOCYCLEkeyword.Solution: Remove
CONNECT_BY_ISCYCLEor add theNOCYCLEkeyword.
ERROR 5774 (HY000) : not enough arguments for function
OceanBase error code: 5774
Cause: Insufficient parameters for the function.
ERROR 5777 (HY000) : Prepare statement checksum error
OceanBase error code: 5777
Cause: The server session is in a non-recoverable state.
Solution: Log in to OceanBase AI Database again to automatically create a new server session. For details, check the session trace file.
ERROR 5778 (HY000) : cannot enable constraint (%.*s) - no such constraint
OceanBase error code: 5778
Cause: The specified constraint does not exist in this table.
ERROR 5779 (HY000) : cannot disable constraint (%.*s) - no such constraint
OceanBase error code: 5779
Cause: The specified constraint does not exist in this table.
ERROR 5780 (HY000) : PX DOP downgrade from %ld to %ld
OceanBase error code: 5780
Cause: Normal exit.
ERROR 5785 (HY000) : cannot validate (%.*s.%.*s) - parent keys not found
OceanBase error code: 5785
Cause: The operation to modify the table failed validation constraints because the table contains orphan subrecords.
ERROR 5786 (HY000) : Column check constraint cannot reference other columns
OceanBase error code: 5786
Cause: Attempt to define a column check constraint that references another column.
Solution: Define it as a table check constraint.
ERROR 5787 (HY000) : batched multi statement execution needs rollback
OceanBase error code: 5787
Cause: Does not meet the execution requirements for batched multi-stmt.
Solution: No action required. The server will automatically roll back to single-statement execution.
ERROR 5788 (HY000) : cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc
OceanBase error code: 5788
Cause: Attempt to select
FOR UPDATEfrom an unmerged view. The view is unmerged because it uses syntax that prevents merging (such asDISTINCTorGROUP BY) or due to parameter settings in the initialization file.Solution: Determine the reason why the view is unmerged and modify it so that the view can be merged.
ERROR 5789 (HY000) : policy with check option violation
OceanBase error code: 5789
Cause: Incorrect write of the data security marker.
ERROR 5790 (HY000) : policy already applied to table
OceanBase error code: 5790
Cause: Attempt to apply a policy to a table that is already protected by that policy.
Solution: To change policy options, predicates, or label values, remove the policy from the table and then reapply it.
ERROR 5791 (HY000) : table '%.*s'.'%.*s' is mutating, trigger/function may not see it
OceanBase error code: 5791
Cause: A trigger (or a user-defined
plsqlfunction referenced in this statement) attempts to view (or modify) a table, but statements that trigger this table are also modifying it.Solution: Rewrite the trigger (or function) so that it does not read from this table.
Related issue case:
ERROR 5792 (HY000) : column is referenced in a multi-column constraint
OceanBase error code: 5792
Cause: You try to drop a column that is referenced by a constraint.
Solution: Drop all constraints that reference this column or specify
CASCADE CONSTRAINTSin the statement.
ERROR 5793 (HY000) : cannot drop parent key column
OceanBase error code: 5793
Cause: You try to drop a parent key column that is referenced by a constraint.
Solution: Drop all constraints that reference the parent key column or specify
CASCADE CONSTRAINTSin the statement.
ERROR 5794 (HY000) : auto increment service busy
OceanBase error code: 5794
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5795 (HY000) : No insert/update/delete on table with constraint (%.*s.%.*s) disabled and validated
OceanBase error code: 5795
Cause: You try to perform an INSERT, UPDATE, or DELETE operation on a table with the
DISABLE VALIDATEconstraint enabled.Solution: Change the state of the constraint.
ERROR 5796 (HY000) : active autonomous transaction detected and rolled back
OceanBase error code: 5796
Cause: All autonomous transactions started within an autonomous PL block must be completed (committed or rolled back) before returning from the block. If not, the running autonomous transaction is implicitly rolled back, and this error code is returned.
Solution: Ensure that any ongoing autonomous transactions are explicitly specified or rolled back before returning from the autonomous PL block.
ERROR 5797 (HY000) : ORDER BY not allowed here
OceanBase error code: 5797
Cause: The
ORDER BYclause is not allowed for theDISTINCTfunction and theRATIO_TO_REPORTfunction.
ERROR 5798 (HY000) : DISTINCT not allowed here
OceanBase error code: 5798
Cause: The
DISTINCToption is not allowed for this function.
ERROR 5799 (HY000) : assign user variable with := only allowed in select filed list and as root expression
OceanBase error code: 5799
Cause: When using
:=to assign a value to a user variable, it is only allowed inside aSELECTstatement and must be the root node of an expression.Solution: It is recommended not to use
:=to assign values to user variables.
ERROR 5800 (HY000) : cannot modify constraint (%.*s) - no such constraint
OceanBase error code: 5800
Cause: The specified constraint does not exist on this table.
ERROR 5801 (HY000) : implementation restriction: exception handler in nested transaction is illegal
OceanBase error code: 5801
Cause: Catching exceptions is not allowed within nested transactions.
Solution: Remove exception catching from nested transactions.
ERROR 5802 (HY000) : invalid ROWID
OceanBase error code: 5802
Cause: The
ROWIDis invalid.
ERROR 5803 (HY000) : Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'
OceanBase error code: 5803
Cause: The
INSERT VALUESclause references an invalid table column.
ERROR 5804 (HY000) : incorrect use of the ['%.*s'] operator
OceanBase error code: 5804
Cause: An error occurred during the execution of an arithmetic operation.
Solution: Check the operator's parameters and return type.
ERROR 5805 (HY000) : non-constant expression is not allowed for pivot|unpivot values
OceanBase error code: 5805
Cause: A non-constant expression was used for a
pivot|unpivotvalue.Solution: Use a constant expression for the
pivot|unpivotvalue.
ERROR 5806 (HY000) : expect aggregate function inside pivot operation
OceanBase error code: 5806
Cause: An attempt was made to use a non-aggregate function inside a
pivotoperation.Solution: Use an aggregate function.
ERROR 5807 (HY000) : expression must have same datatype as corresponding expression
OceanBase error code: 5807
Cause: An expression must have the same data type as its corresponding expression.
ERROR 5808 (HY000) : character set mismatch
OceanBase error code: 5808
Cause: One of the following situations may have occurred:
The string operands of operators or built-in functions (except for the
nlsparamsparameter) use different character sets.The
nlsparamsoperand is not in the database character set.The string data passed to a built-in function uses a character set other than the database character set, and the built-in function does not accept that character set.
The second parameter of
CHR()orCSCONVERT()is notCHAR_CSorNCHAR_CS.The character set of a string expression in the
VALUESclause of anINSERTstatement or in theSETclause of anUPDATEstatement is inconsistent with the character set used by the column to be inserted.The character set of the value provided in the
DEFAULTclause when creating a table is inconsistent with the character set declared for the column.The parameter of a
PL/SQLfunction does not meet the character set requirements of the corresponding parameter.
ERROR 5809 (HY000) : regular expression failed to match
OceanBase error code: 5809
Cause: The regular expression matching failed, and no matching string was found.
Solution: This is an internal error code. Contact technical support for assistance.
ERROR 5810 (HY000) : invalid regular expression (reg version 0.8)
OceanBase error code: 5810
Cause: The given regular expression
patternis invalid.Solution: Adjust the given regular expression
pattern.
ERROR 5811 (HY000) : invalid escape \\ sequence in regular expression
OceanBase error code: 5811
Cause: An invalid
ESCAPEis found in the regular expression.Solution: Remove the invalid
ESCAPE.
ERROR 5812 (HY000) : unmatched bracket in regular expression
OceanBase error code: 5812
Cause: The regular expression has an unmatched square bracket.
Solution: Ensure that the square brackets are matched.
ERROR 5813 (HY000) : unmatched parentheses in regular expression
OceanBase error code: 5813
Cause: The regular expression has an unmatched round bracket.
Solution: Ensure that the round brackets are matched.
ERROR 5814 (HY000) : invalid back reference in regular expression
OceanBase error code: 5814
Cause: A back reference is used in a subexpression.
Solution: Ensure that the referenced subexpression is valid.
ERROR 5815 (HY000) : invalid range in regular expression
OceanBase error code: 5815
Cause: An invalid range is found in the regular expression.
Solution: Ensure that a valid range is used.
ERROR 5816 (HY000) : invalid character class in regular expression
OceanBase error code: 5816
Cause: An unknown character class is found in the regular expression.
Solution: Ensure that a valid character class is used.
ERROR 5817 (HY000) : invalid collation class in regular expression
OceanBase error code: 5817
Cause: The regular expression contains an unknown collation class.
Solution: Ensure that a valid collation class is used.
ERROR 5818 (HY000) : braces {} not balanced in in regular expression
OceanBase error code: 5818
Cause: The
{}in the regular expression is not fully enclosed.Solution: Correct the
{}in the regular expression.
ERROR 5819 (HY000) : invalid repetition count(s) in regular expression
OceanBase error code: 5819
Cause: The regular expression engine encountered invalid repetition counts.
Solution: Contact technical support for assistance.
ERROR 5820 (HY000) : The regular expression was too complex and current library can't be parsed
OceanBase error code: 5820
Cause: The regular expression is too complex for the current regular expression engine to parse.
Solution: Contact technical support for assistance.
ERROR 5821 (HY000) : regular expression internal error
OceanBase error code: 5821
Cause: The regular expression is too complex for the current regular expression engine to parse.
Solution: Contact technical support for assistance.
ERROR 5822 (HY000) : invalid argument in regular expression
OceanBase error code: 5822
Cause: The regular expression contains invalid arguments.
Solution: Check the validity of the arguments in the regular expression.
ERROR 5823 (HY000) : character widths of regex and string differ in regular expression
OceanBase error code: 5823
Cause: The regular expression engine encountered a mix of different character sets.
Solution: Contact technical support for assistance.
ERROR 5824 (HY000) : invalid embedded option in regular expression
OceanBase error code: 5824
Cause: The
patternin the regular expression specifies an invalid matching parameter.Solution: Correct the
patternmatching parameter in the regular expression.
ERROR 5825 (HY000) : nfa has too many states in regular expression, may be the regular expression too long
OceanBase error code: 5825
Cause: An exception occurred in the transition-state machine of the regular expression engine.
Solution: Contact technical support for assistance.
ERROR 5827 (HY000) : the definition of relative objects have been modified, please check and retry
OceanBase error code: 5827
Cause: A concurrency DDL operation encountered a conflict.
Solution: This is an internal error code. Contact technical support for assistance.
ERROR 5828 (HY000) : Subscript beyond count
OceanBase error code: 5828
Cause: The subscript is greater than the maximum length of the VARRAY array or is too large for a nested table.
Solution: Check the program logic and explicitly extend it if necessary.
ERROR 5829 (HY000) : PARTITION () clause on non partitioned table
OceanBase error code: 5829
Cause: The table or index is not partitioned. Syntax error.
Solution: Retry the command using the correct syntax.
ERROR 5830 (HY000) : Unknown subpartition
OceanBase error code: 5830
Cause: The secondary partition of the object was not found.
Solution: Use the correct subpartition name and try again.
ERROR 5831 (HY000) : Invalid SQL ROW LIMITING expression was specified
OceanBase error code: 5831
Cause: The
ROW LIMITINGexpression in the SQL statement contains components other than text, bound variables, related variables, or subqueries.Solution: Modify the
ROW LIMITINGexpression in the SQL statement and try again.
ERROR 5833 (HY000) : not implemented in SQL static typing engine
OceanBase error code: 5833
Cause: This feature is not implemented in the new engine.
Solution: No action is required. The SQL engine will automatically retry.
ERROR 5834 (HY000) : name is already used by an existing object
OceanBase error code: 5834
Cause: The object already exists.
Solution: The object involved in the PL statement already exists and cannot be created repeatedly.
ERROR 5835 (HY000) : connection description for remote database not found
OceanBase error code: 5835
Cause: The connection description for the remote database could not be found.
ERROR 5836 (HY000) : database link not found
OceanBase error code: 5836
Cause: The database link to be dropped could not be found in the dictionary.
Solution: Correct the database link name.
ERROR 5837 (HY000) : Reference to uninitialized composite
OceanBase error code: 5837
Cause: A composite,
LOB, or other multi-part partition is referenced on the left side, but the object,LOB, or other multi-part partition is not initialized.Solution: Initialize the multi-part partition using the appropriate constructor or a full-object assignment.
ERROR 5838 (HY000) : Reference to uninitialized collection
OceanBase error code: 5838
Cause: An element of a nested table or
Varray, or aMemberfunction, was referenced when the collection was not initialized.Solution: Initialize the collection using an appropriate constructor or a full-object assignment.
ERROR 5839 (HY000) : no more rows needed
OceanBase error code: 5839
Cause: The caller of the pipeline function does not need the pipeline function to generate more rows.
Solution: Do not catch the
NO_DATA_NEEDEDexception in the exception handling block.
ERROR 5840 (HY000) : PL/SQL: program error
OceanBase error code: 5840
Cause: This is an internal error message. An error was detected in the PL program.
Solution: This is an internal error code. Contact technical support engineers for assistance in troubleshooting.
ERROR 5841 (HY000) : PL/SQL: Return types of Result Set variables or query do not match
OceanBase error code: 5841
Cause: The number or type of columns in the query does not match the return type declared for the result set variables, or the types declared for two result set variables do not match.
Solution: Modify the program statements or declarations.
ERROR 5842 (HY000) : PL/SQL: storage error
OceanBase error code: 5842
Cause: PL cannot allocate additional storage. Sometimes this error may be caused by an out-of-control program.
Solution:
Ensure there are no issues or errors using additional memory in the PL program.
Programmatically release unused objects (for example, set them to
NULL).Increase the amount of shared or process memory available (if applicable).
ERROR 5843 (HY000) : Subscript outside of limit
OceanBase error code: 5843
Cause: The subscript is greater than the limit value of the
VARRAY, or the subscript is a non-positive value for theVARRAYor nested table.Solution: Check the program logic and, if necessary, increase the limit value of the
VARRAY.
ERROR 5844 (HY000) : invalid cursor
OceanBase error code: 5844
Cause: The cursor is invalid.
ERROR 5845 (HY000) : invalid username/password; logon denied
OceanBase error code: 5845
Cause: The username or password is invalid. Logon is denied.
ERROR 5846 (HY000) : not logged on
OceanBase error code: 5846
Cause: Not logged on.
ERROR 5847 (HY000) : method dispatch on NULL SELF argument is disallowed
OceanBase error code: 5847
Cause: A
Membermethod of some type is called with aNULL SELFparameter.Solution: Change the method call type to pass a valid
SELFparameter.
ERROR 5848 (HY000) : timeout occurred while waiting for a resource
OceanBase error code: 5848
Cause: Usually due to a dead instance.
Solution: Check if there are any dead or unrecovered instances. If so, recover them.
ERROR 5849 (HY000) : column to be modified to NOT NULL is already NOT NULL
OceanBase error code: 5849
Cause: The column to be changed to
NOT NULLis alreadyNOT NULL.
ERROR 5850 (HY000) : column to be modified to NULL cannot be modified to NULL
OceanBase error code: 5850
Cause: The column may already allow
NULLvalues, and theNOT NULLconstraint is part of a primary key or aCHECKconstraint.Solution: If a primary key or
CHECKconstraint enforces theNOT NULLconstraint, remove that constraint.
ERROR 5851 (HY000) : cannot enable (%.*s.%.*s) - null values found
OceanBase error code: 5851
Cause: The operation to enable constraints on the table failed because some values in the table do not meet the constraints.
ERROR 5852 (HY000) : Argument should be a constant
OceanBase error code: 5852
Cause: The parameter must be a constant.
ERROR 5853 (HY000) : not a single-group group function
OceanBase error code: 5853
Cause: It is not a single-group
Groupfunction.
ERROR 5854 (HY000) : illegal zero-length identifier
OceanBase error code: 5854
Cause: Illegal zero-length identifier.
ERROR 5855 (HY000) : parameter cannot be modified because specified value is invalid
OceanBase error code: 5855
Cause: Initialization parameters can be modified, but the specified value is invalid.
Solution: Refer to the "Reference guide" for the corresponding version of OceanBase AI Database to view the valid range of this parameter.
ERROR 5856 (HY000) : DBMS_SQL access denied
OceanBase error code: 5856
Cause: Access to
DBMS_SQLhas been denied for security reasons.Solution: Try to obtain more information from the Alert logs and trace files.
ERROR 5857 (HY000) : not all variables bound
OceanBase error code: 5857
Cause: Some variables are not configured.
ERROR 5859 (HY000) : column is referenced in a multi-column constraint
OceanBase error code: 5859
Cause: You tried to drop a column that is referenced by a multi-column constraint.
Solution: Drop all constraints that reference this column or specify
CASCADE CONSTRAINTSin the statement.
ERROR 5860 (HY000) : cannot modify column datatype with current constraint(s)
OceanBase error code: 5860
SQLSTATE: HY000
Cause: You are trying to modify the data type of a column with a
CHECKconstraint. However, for a column with aCHECKconstraint, you can only change the data type fromCHARtoVARCHAR.Solution: Drop the constraint or do not perform the invalid operation.
ERROR 5861 (HY000) : The percentile value should be a number between 0 and 1
OceanBase error code: 5861
Cause: The percentile value specified for the
PERCENTILE_CONTorPERCENTILE_DISCfunction is not within the valid range.Solution: Specify a value within the [0,1] range.
ERROR 5862 (HY000) : The argument should be of numeric or date/datetime type
OceanBase error code: 5862
Cause: The parameter must be of numeric or date/time type.
ERROR 5863 (HY000) : ALTER TABLE|INDEX RENAME may not be combined with other operations
OceanBase error code: 5863
Cause: The
ALTER TABLEorALTER INDEXstatement attempts to combine aRENAMEoperation with other operations, which is illegal.Solution: Ensure the
ALTER TABLEorALTER INDEXstatement contains only theRENAMEoperation.
ERROR 5864 (HY000) : only simple column names allowed here
OceanBase error code: 5864
Cause: Only simple column names are allowed here.
ERROR 5866 (HY000) : cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)
OceanBase error code: 5866
Cause: The request attempts to generate a default partition description (possibly via
PARTITIONS number-of-partitions) while specifying the<(sub)partition-description>clause, which is illegal.Solution: Remove one of the offending clauses.
ERROR 5867 (HY000) : Duplicate partition name %.*s
OceanBase error code: 5867
Cause: The name of a subpartition created for a table or index is not unique.
Solution: Rename the subpartition to ensure its name is unique among all subpartitions created for the table or index.
ERROR 5868 (HY000) : Incorrect usage of UPDATE and ORDER BY
OceanBase error code: 5868
Cause: The
ORDER BYclause cannot be used when performing a multi-tableUPDATE.Solution: Remove the
ORDER BYclause.
ERROR 5869 (HY000) : Incorrect usage of UPDATE and LIMIT
OceanBase error code: 5869
Cause: The
LIMITclause cannot be used when performing a multi-tableUPDATE.Solution: Remove the
LIMITclause.
ERROR 5870 (HY000) : rowid type mismatch, expect %.*s, got %.*s
OceanBase error code: 5870
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5871 (HY000) : rowid num mismatch, expect %ld, actual %ld
OceanBase error code: 5871
Cause: Internal error code.
Solution: Contact technical support for assistance.
ERROR 5872 (HY000) : must name %.*s with a column alias
OceanBase error code: 5872
SQLSTATE: HY000
Cause: The expression must be named with a column alias.
ERROR 5873 (HY000) : the numeric value does not match the length of the format item
OceanBase error code: 5873
Cause: When specifying the FX or FM format codes for an input date, the number of digits must exactly match the number of digits specified by the format code. For example,
9does not match the format specifier DD, but09does.Solution: Correct the input date or remove the FX or FM format specifiers from the format string.
ERROR 5874 (HY000) : invalid datatype
OceanBase error code: 5874
Cause: Invalid data type.
ERROR 5875 (HY000) : table is not partitioned by composite partition method
OceanBase error code: 5875
Cause: Performing a subpartition maintenance operation on a non-subpartitioned table.
Solution: Ensure the table is a subpartitioned table.
ERROR 5876 (HY000) : VALUES IN (<value list>) cannot be used for Range subpartitioned tables
OceanBase error code: 5876
Cause: The
VALUES (value list)clause is used for RANGE subpartitioned tables.Solution: Use the
VALUES LESS THANorATclause with RANGE subpartitioned tables.
ERROR 5877 (HY000) : VALUES IN (<value list>) clause expected
OceanBase error code: 5877
Cause: The
VALUES (value list)clause was not specified for the LIST subpartition.Solution: Specify the
VALUES (value list)clause.
ERROR 5879 (HY000) : Expecting VALUES LESS THAN or AT clause
OceanBase error code: 5879
Cause: The
VALUES (value list)clause can only be used with LIST partitioned tables.Solution: Use the
VALUES LESS THANclause with a RANGE-partitioned table.
ERROR 5880 (HY000) : procedure, function, package, or package body does not exist
OceanBase error code: 5880
Cause: You are trying to access a non-existent procedure, function, package, or package body.
Solution: Ensure that the name of the object you want to access is correct.
ERROR 5882 (HY000) : invalid time limit specified
OceanBase error code: 5882
Cause: The input parameter
timeof thedbms_lock.sleep(time)package specifies a non-positive value.Solution: Specify a positive value.
ERROR 5883 (HY000) : ## ERROR(s) in array DML
OceanBase error code: 5883
Cause: One or more rows in the DML statement failed.
Solution: Check the error stack during exception capture to obtain the specific exception.
ERROR 5884 (42000) : %s \'%.*s.%.*s\' compile error
OceanBase error code: 5884
Cause: An error occurred in the DDL statement that creates the trigger.
Solution: Modify the DDL statement as prompted and re-execute it.
ERROR 5887 (HY000) : missing or invalid password(s)
OceanBase error code: 5887
Cause: The password is incorrect.
Solution: Ensure that you are using the correct password and try again.
ERROR 5889 (HY000) : no matching unique or primary key for this column-list
OceanBase error code: 5889
Cause: The
REFERENCESclause in aCREATE TABLEorALTER TABLEstatement provides a list of columns, but there is no matching unique or primary key constraint in the referenced table.Solution: Use the
ALL_CONS_COLUMNSdirectory view to find the correct column name.
ERROR 5890 (HY000) : duplicate referential constraint specifications
OceanBase error code: 5890
Cause: When creating a table, there are multiple foreign key constraints on the same table that have the same referencing and referenced columns.
Solution: Modify the
CREATE TABLEstatement to ensure that a table cannot have multiple foreign key constraints with the same referencing and referenced columns.
ERROR 5891 (HY000) : such a referential constraint already exists in the table
OceanBase error code: 5891
Cause: When modifying a table, there are multiple foreign key constraints on the same table that have the same referencing and referenced columns.
Solution: Modify the
ALTER TABLEstatement to ensure that a table cannot have multiple foreign key constraints with the same referencing and referenced columns.
ERROR 5893 (HY000) : specified data type is not supported for a virtual column
OceanBase error code: 5893
Cause: The data type of the generated column is the currently unsupported
LOBtype.Solution: Adjust the data type of the generated column.
ERROR 5894 (HY000) : referenced table does not have a primary key
OceanBase error code: 5894
Cause: When specifying the referenced column of a foreign key, the parent table lacks a primary key.
Solution: Before creating a foreign key, you must create a primary key or a unique index on the referenced column.
ERROR 5895 (HY000) : data type or length of a table partitioning column may not be changed
OceanBase error code: 5895
Cause: The data type and length of a partitioning column cannot be changed.
ERROR 5896 (HY000) : data type or length of a table partitioning column may not be changed
OceanBase error code: 5896
Cause: The data type and length of a subpartitioning column cannot be changed.
ERROR 5897 (HY000) : cannot decrease column length because some value is too big
OceanBase error code: 5897
Cause: The maximum column length cannot be reduced.
ERROR 5898 (HY000) : Datetime/Interval internal error
OceanBase error code: 5898
Cause: Internal error.
Solution: Contact technical support for assistance.
ERROR 5899 (HY000) : partition extended table name cannot refer to a remote object
OceanBase error code: 5899
Cause: Attempted to name a remote object using extended partition table syntax.
Solution: Correct the expression and try again.
ERROR 5901 (HY000) : a view is not appropriate here
OceanBase error code: 5901
Cause: Attempted to define
EDITIONING_VIEWon a view.Solution:
EDITIONING_VIEWcan only be created on base tables.
ERROR 5902 (HY000) : cannot select ROWID from,or sample, a join view without a key-preserved table
OceanBase error code: 5902
Cause: Cannot query
ROWIDfrom a joined view or sample without a key-preserved table.
ERROR 5903 (HY000) : cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc
OceanBase error code: 5903
Cause: Cannot query
ROWIDfrom a view withDISTINCTorGROUP BY.
ERROR 5904 (HY000) : table must have at least 1 column that is not virtual
OceanBase error code: 5904
Cause: You attempted to create a table that contains only virtual columns.
Solution: Ensure the table to be created contains at least one non-virtual column.
ERROR 5905 (HY000) : only pure functions can be indexed
OceanBase error code: 5905
Cause: The index function uses
SYSDATEor the user environment.Solution: The PL function must be a pure function (
RNDS,RNPS,WNDS,WNPS).
ERROR 5906 (HY000) : only pure functions can be specified in a virtual column expression
OceanBase error code: 5906
Cause: The virtual column expression contains a function whose value is uncertain.
Solution: Rewrite the expression to reference only pure functions.
ERROR 5907 (HY000) : UPDATE operation disallowed on virtual columns
OceanBase error code: 5907
Cause: You attempted to update the value of a virtual column.
Solution: Rerun the statement without setting the value for the virtual column.
ERROR 5908 (HY000) : Invalid column expression was specified
OceanBase error code: 5908
Cause: The virtual column expression is not a valid arithmetic expression. It may reference another column in the table.
Solution: Modify the virtual column expression.
ERROR 5909 (HY000) : table can have only one identity column
OceanBase error code: 5909
Cause: You attempted to specify multiple identity columns for a table.
Solution: Specify only one identity column per table.
ERROR 5910 (HY000) : invalid NOT NULL constraint specified on an identity column
OceanBase error code: 5910
Cause: The
NOT NULLconstraint was not correctly specified on the identity column.Solution: If the
NOT NULLconstraint is specified on the identity column, it must be enabled and cannot be deferred.
ERROR 5911 (HY000) : cannot modify NOT NULL constraint on an identity column
OceanBase error code: 5911
Cause: The
NOT NULLconstraint on the identity column cannot be modified.Solution: Do not modify the
NOT NULLconstraint on the identity column.
ERROR 5912 (HY000) : cannot drop NOT NULL constraint on an identity column
OceanBase error code: 5912
Cause: The
NOT NULLconstraint on the identity column cannot be dropped.Solution: Do not drop the
NOT NULLconstraint on the identity column. The only way to remove a constraint is to use theDROP IDENTITYclause ofALTER TABLE MODIFYto drop the column'sidentityattribute.
ERROR 5913 (HY000) : column to be modified is not an identity column
OceanBase error code: 5913
Cause: You are trying to modify the identity attribute of a column that is not an identity column.
Solution: Modify the identity attribute of the identity column.
ERROR 5914 (HY000) : identity column cannot have a default value
OceanBase error code: 5914
Cause: You are trying to add a default value to the identity column.
Solution: You cannot specify a default value for the identity column.
ERROR 5915 (HY000) : identity column must be a numeric type
OceanBase error code: 5915
Cause: You are trying to create or change the value of an identity column to a non-numeric data type.
Solution: Do not assign non-numeric data types to the identity column.
ERROR 5916 (HY000) : prebuilt table managed column cannot be an identity column
OceanBase error code: 5916
Cause: An attempt was made to create an instance view on a prebuilt table with an identity column.
Solution: Either remove the
IDENTITYattribute or remove the identity column from the instance view definition.
ERROR 5917 (HY000) : cannot alter a system-generated sequence
OceanBase error code: 5917
Cause: An attempt was made to modify a system-generated sequence.
Solution: System-generated sequences, such as those created for identity columns, cannot be modified.
ERROR 5918 (HY000) : cannot drop a system-generated sequence
OceanBase error code: 5918
Cause: An attempt was made to drop a system-generated sequence.
Solution: System-generated sequences, such as those created for identity columns, cannot be dropped.
ERROR 5919 (HY000) : cannot insert into a generated always identity column
OceanBase error code: 5919
Cause: An attempt was made to insert a value into an identity column created using the
GENERATED ALWAYSkeyword.Solution: Identity columns generated using the
GENERATED ALWAYSkeyword cannot be directly inserted. Instead, the value is provided by the associated sequence generator.
ERROR 5920 (HY000) : cannot update a generated always identity column
OceanBase error code: 5920
Cause: An attempt was made to update an identity column created using the
GENERATED ALWAYSkeyword.Solution: Identity columns generated using the
GENERATED ALWAYSkeyword cannot be directly updated.
ERROR 5921 (HY000) : identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION
OceanBase error code: 5921
Cause: The sequences of the identity columns for the two tables specified in the
EXCHANGEclause do not increase or decrease by the same amount.Solution: Ensure that the identity columns with
INCREMENT BYhave sequences with the same sign.
ERROR 5922 (HY000) : cannot rename a system-generated sequence
OceanBase error code: 5922
Cause: An attempt was made to rename a system-generated sequence.
Solution: System-generated sequences (such as those created for identity columns) cannot be renamed.
ERROR 5923 (HY000) : UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
OceanBase error code: 5923
Cause:
UPDATEorREFERENCEScan only be revoked from the entire table, not by column.
ERROR 5924 (HY000) : not executed, type body '%.*s' does not exist
OceanBase error code: 5924
Cause: An attempt was made to execute a non-existent stored program.
Solution: Ensure the correct name is provided.
ERROR 5925 (HY000) : The argument [%s] of WIDTH_BUCKET function is NULL or invalid
OceanBase error code: 5925
Cause: The parameter
[%s]for theWIDTH_BUCKETfunction isNULLor invalid.
ERROR 5926 (HY000) : Not enough memory for CONNECT BY operation
OceanBase error code: 5926
Cause: On the new engine, an error is reported when the recursion depth is too deep, with a limit of 2 to the power of 30. On the old engine, an error is reported if the number of all nodes and their descendants on the path from the root node to the current node exceeds a fixed value (2 to the power of 30). This value is currently set fixed and generally should not be exceeded.
Solution: No temporary solution is available. Increasing memory size does not resolve this issue. The only solution is to reduce the recursion depth or decrease the data volume.
ERROR 5927 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
OceanBase error code: 5927
Cause: There is an illegal parameter in the
SYS_CONNECT_BY_PATHfunction.
ERROR 5928 (HY000) : host %.*s unknown
OceanBase error code: 5928
Cause: The specified host is unknown.
Solution: Check the spelling of the hostname or IP address to ensure it is valid.
ERROR 5929 (HY000) : Window name '%.*s' is not defined
OceanBase error code: 5929
Cause: The specified window function does not exist.
Solution: Ensure the relevant window function has been created and that the correct window function name is used.
ERROR 5930 (HY000) : maximum open %s exceeded
OceanBase error code: 5930
Cause: The number of cursors open simultaneously in the system exceeds the limit.
Solution: Close cursors or adjust the
open_cursorsparameter.
ERROR 5931 (HY000) : argument is null, invalid, or out of range
OceanBase error code: 5931
Cause: The passed parameter value is
NULL, invalid, or out of range. For example, the position or size parameter forLOB / FILEexceeds the range of 1 to (4GB-1), or a file is opened in an invalid open mode.Solution: Check and correct the program so that it does not pass
NULL, invalid, or out-of-range parameter values.
ERROR 5932 (HY000) : unexpected name string
OceanBase error code: 5932
Cause: Incorrect name character.
ERROR 5933 (HY000) : PL/SQL: could not find program unit being called: '%.*s'
OceanBase error code: 5933
Cause: The program unit cannot be found.
ERROR 5934 (HY000) : fetch out of sequence
OceanBase error code: 5934
SQLSTATE: HY000
Cause: Attempts to access data from an invalid cursor. This error can occur for the following reasons:
Accessing data from the cursor after retrieving the last row and returning the
OBE-1403error.Accessing data after issuing a
COMMITstatement following the use of theFOR UPDATEclause to open the cursor.Rebinding all placeholders in an SQL statement and then accessing data before re-executing the statement.
Note
Implicit fetches during a PL cursor loop can also cause this error.
Solution:
Do not issue a
FETCHstatement after retrieving the last row.Do not access data after issuing a
COMMITfollowing the use of theFOR UPDATEclause to open the cursor.Rebind and execute the SQL statement, then access data.
ERROR 5959 (HY000) : invalid SIZE specified
OceanBase error code: 5959
Cause: The specified
SIZEvalue for the histogram is out of range.Solution: Specify a
SIZEvalue within the range [1, 2048].
ERROR 5975 (HY000) : \ndblink remote error code: %d,\nremote error msg: %.*s"
OceanBase error code: 5975
Cause: An error occurred while connecting to the remote database, and the error code cannot be mapped to an OceanBase error code.
Solution: Investigate the cause based on the error code provided in the error message.
ERROR 5976 (HY000) : can not find the expected version of OCI LIB: %.*s
OceanBase error code: 5976
Cause: The expected version of the OCI library was not found.