5000 to 5999

Last Updated：2026-04-03 03:16:02 Updated

These error codes indicate SQL-related errors, including SQL, WITH clause, and Factoring errors.

ERROR 5002 (HY000): Resolve error

Error code in OceanBase Database: 5002
Cause: A parsing error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5010 (21000): Unknown operator

Error code in OceanBase Database: 5010
Cause: An internal defensive check error occurred in the parsing phase.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5011 (42000): Duplicated star

Error code in OceanBase Database: 5011
Cause: The usage of asterisks () is invalid. You can use only one asterisk () in an SQL statement.
Solution: Delete redundant asterisks (*) from the SQL statement.

ERROR 5012 (HY000): Illegal ID

Error code in OceanBase Database: 5012
Cause: An internal defensive parameter error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5014 (HY000): Illegal value

Error code in OceanBase Database: 5014
Cause: The system encountered an error when converting the value type.
Solution: Check whether the CAST function in the SQL statement is valid. For example, check whether implicit conversions are performed.

ERROR 5016 (HY000): Generate logical plan error

Error code in OceanBase Database: 5016
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5017 (HY000): Schema not set

Error code in OceanBase Database: 5017
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5023 (S1004): unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date

Error code in OceanBase Database: 5023
Cause: The type is not supported.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5031 (HY000): Column not found

Error code in OceanBase Database: 5031
Cause: The column does not exist.
Solution: Check whether the column specified for the operation exists, or contact OceanBase Technical Support for troubleshooting.

ERROR 5034 (01007): No user

Error code in OceanBase Database: 5034
Cause: No username is specified.
Solution: Specify a username.

ERROR 5050 (42710): User exists

Error code in OceanBase Database: 5050
Cause: The user or role already exists.
Solution: Check whether the user or role specified for the operation already exists, or contact OceanBase Technical Support for troubleshooting.

ERROR 5053 (HY093): Incorrect arguments number to EXECUTE, need %ld arguments but give %ld

Error code in OceanBase Database: 5053
Cause: The number of parameters bound to the EXECUTE statement is different from that in the PREPARE statement.
Solution: Make sure that the number of parameters bound to the EXECUTE statement is the same as that in the PREPARE statement.

ERROR 5058 (42000): Duplicated parameters

Error code in OceanBase Database: 5058
Cause: Duplicate parameters exist.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5063 (42000): Unknown hint

Error code in OceanBase Database: 5063
Cause: A parsing error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5066 (HY000): Session interrupted

Error code in OceanBase Database: 5066
Cause: The current session is terminated.
Solution: Contact the system administrator or database administrator for troubleshooting.

ERROR 5071 (42000): Cannot alter index column

Error code in OceanBase Database: 5071
Cause: You are attempting to delete an indexed column.
Solution: Do not delete indexed columns.

ERROR 5074 (23000): NOP cannot be used here

Error code in OceanBase Database: 5074
Cause: A kernel bug occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5081 (25000): The server is read only now

Error code in OceanBase Database: 5081
Cause: The data requested by the operation is read-only.
Solution: Check whether the requested data is read-only, or contact OceanBase Technical Support for troubleshooting.

ERROR 5083 (22000): invalid obj type for type promotion: left_type=%s right_type=%s

Error code in OceanBase Database: 5083
Cause: A type conversion error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5084 (22000): Can not cast varchar value to bool type

Error code in OceanBase Database: 5084
Cause: A type conversion error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5085 (22000): Not a number Can not cast varchar value to number type

Error code in OceanBase Database: 5085
Cause: A type conversion error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5086 (22000): Not timestamp Can not cast varchar value to timestamp type

Error code in OceanBase Database: 5086
Cause: A type conversion error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5087 (22000): Result value was out of range when cast to number

Error code in OceanBase Database: 5087
Cause: The value is out of range.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5090 (22000): Precision was out of range

Error code in OceanBase Database: 5090
Cause: The precision is out of range.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5091 (22000): Scale value was out of range

Error code in OceanBase Database: 5091
Cause: The precision is out of range.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5092 (42000): Unknown index

Error code in OceanBase Database: 5092
Cause: The index is unknown.
Solution: Specify indexes that exist in API calls.

ERROR 5098 (22001): Data too long(%d>%ld) for column '%s'

Error code in OceanBase Database: 5098
Cause: The length of the number exceeds the upper limit.
Solution: Shorten the number.

ERROR 5099 (42000): System config unknown

Error code in OceanBase Database: 5099
Cause: The parameter is invalid.
Solution: Check whether the parameter name is valid.

ERROR 5106 (42000): EXTRACT() expected timestamp or a string as date argument

Error code in OceanBase Database: 5106
Cause: The data type is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5107 (42000): Invalid operand type for IS operator, lval=%s

Error code in OceanBase Database: 5107
Cause: One or more operand types in the IS expression are invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5108 (42000): function LENGTH() expected a varchar argument

Error code in OceanBase Database: 5108
Cause: One or more operand types in the LENGTH expression are invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5110 (42000): TIME_TO_USEC() expected timestamp or a string as date argument

Error code in OceanBase Database: 5110
Cause: The TIME_TO_USEC function can contain only the following types of parameters: VARCHAR, TIME, DATATIME, and TIMESTAMP.
Solution: Modify the parameter types.

ERROR 5111 (42000): USEC_TO_TIME expected a interger number as usec argument

Error code in OceanBase Database: 5111
Cause: The USEC_TO_TIME function can contain only the following types of parameters: TINYINT, MEDIUMINT, INT, and BIGINT.
Solution: Modify the parameter types.

ERROR 5112 (42P01): Variable %.*s does not exists

Error code in OceanBase Database: 5112
Cause: The variable does not exist.
Solution: Check whether the specified variable name is valid.

ERROR 5114 (42000): Invalid numeric char '%c'

Error code in OceanBase Database: 5114
Cause: The number is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5116 (HY000): Logical operator child index overflow

Error code in OceanBase Database: 5116
Cause: A kernel error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5117 (HY000): fail to explain plan

Error code in OceanBase Database: 5117
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5118 (HY000): fail to copy logical operator

Error code in OceanBase Database: 5118
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5119 (HY000): fail to generate plan

Error code in OceanBase Database: 5119
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5120 (HY000): fail to create raw expr

Error code in OceanBase Database: 5120
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5121 (HY000): fail to generate join order

Error code in OceanBase Database: 5121
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5122 (HY000): optimizer general error

Error code in OceanBase Database: 5122
Cause: The system encountered an error when generating the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5130 (HY000): sql resolver no memory

Error code in OceanBase Database: 5130
Cause: The memory is insufficient.
Solution: Increase the SQL memory size, or contact OceanBase Technical Support for troubleshooting.

ERROR 5131 (HY000): plan cache support dml only

Error code in OceanBase Database: 5131
Cause: Outlines are bound to non-DML statements.
Solution: Do not bind outlines to non-DML statements.

ERROR 5133 (42000): No such grant defined

Error code in OceanBase Database: 5133
Cause: You are attempting to revoke a privilege that was not granted.

ERROR 5136 (HY000): plan exists in plan cache already

Error code in OceanBase Database: 5136
Cause: The plan to be added already exists in the plan cache.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5137 (HY000): plan is expired

Error code in OceanBase Database: 5137
Cause: The plan has expired.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5138 (HY000): no plan exist

Error code in OceanBase Database: 5138
Cause: The plan to be obtained does not exist.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5144 (HY000): COLLATION '%.s' is notvalid for CHARACTER SET '%.s'

Error code in OceanBase Database: 5144
Cause:
- Different character sets are used for the string operands (excluding nlsparams) of the operator or built-in function.
- The nlsparams operand is not contained in the character set of the database.
- A character set other than the character set of the database is used for the string data passed to the built-in function, but the built-in function does not support the character set in use.
- The second argument of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.
- The character set of the string expression in the VALUES clause of the INSERT statement or the SET clause of the UPDATE statement is different from the character set used by the column to be inserted.
- In the table creation statement, the character set used for the values in the DEFAULT clause is different from the character set declared for the column.
- Parameters of the PL/SQL function do not conform to the specified character set.

ERROR 5150 (HY000): Tenant not in this server

Error code in OceanBase Database: 5150
Cause: The requested tenant resources are not found on the server.
Solution: Retry the operation. If the error persists, contact OceanBase Technical Support for troubleshooting.

ERROR 5151 (42P01): tablegroup not exist

Error code in OceanBase Database: 5151
Cause: The table group does not exist. The specified table group name is invalid.
Solution: Specify a valid table group name.

ERROR 5156 (HY000): tenant \'%s\' already exist

Error code in OceanBase Database: 5156
Cause: A tenant with the specified name already exists, or an internal error occurred.
Solution: If a tenant with the specified name already exists, specify another name for the tenant to be created. In other cases, contact OceanBase Technical Support for troubleshooting.

ERROR 5157 (HY000): Unknown tenant '%.*s'

Error code in OceanBase Database: 5157
Cause: The schema is outdated, or the tenant has been deleted.
Solution: Retry the operation. If the error persists, contact OceanBase Technical Support for troubleshooting.

ERROR 5159 (HY000): tablegroup already exist

Error code in OceanBase Database: 5159
Cause: The table group already exists.
Solution: Specify a valid table group name.

ERROR 5160 (HY000): invalid tenant name specified in connection string

Error code in OceanBase Database: 5160
Cause: The specified tenant does not exist.
Solution: Check whether the specified tenant exists. If yes, contact OceanBase Technical Support for troubleshooting.

ERROR 5212 (42000): auto-increment column '%.*s' should not be part of partition key

Error code in OceanBase Database: 5212
Cause: The partitioning key cannot contain an auto-increment column.
Solution: Remove the auto-increment column from the partitioning key.

ERROR 5223 (42000): wrong ident name

Error code in OceanBase Database: 5223
Cause: The variable name is invalid.
Solution: Use a valid variable name.

ERROR 5226 (42000): plan cache memory used reach the high water mark

Error code in OceanBase Database: 5226
Cause: The memory usage of the plan cache has reached the upper limit, and plans are automatically evicted.
Solution: Increase the maximum memory size of the plan cache.

ERROR 5234 (HY000): The database \'%.*s\' is read only so it cannot execute this statement

Error code in OceanBase Database: 5234
Cause: The database is read-only and does not support the operation.
Solution: Do not perform the operation on the read-only database.

ERROR 5235 (HY000): The table \'%.s.%.s\' is read only so it cannot execute this statement

Error code in OceanBase Database: 5235
Cause: The table is read-only and does not support the operation.
Solution: Do not perform the operation on the read-only table.

ERROR 5243 (HY000): system variables' version maybe different

Error code in OceanBase Database: 5243
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5245 (HY000): some tasks are skipped, skipped server addr is '%s', the orginal error code is %d

Error code in OceanBase Database: 5245
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5248 (HY000): Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'

Error code in OceanBase Database: 5248
Cause: This error may be returned if you add an auto-increment column when you modify a table.
Solution: We recommend that you add an auto-increment column only when the table is empty.

ERROR 5252 (HY000): Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes

Error code in OceanBase Database: 5252
Cause: Both the NULL and NOT NULL attributes are specified for the field.
Solution: Retain only one of the attributes.

ERROR 5258 (HY000): Invalid block size, block size should between 1024 and 1048576

Error code in OceanBase Database: 5258
Cause: The block size is invalid.
Solution: Change the block size.

ERROR 5260 (HY000): Tenant \'%.*s\' is locked

Error code in OceanBase Database: 5260
Cause: The tenant is locked.
Solution: Unlock the tenant.

ERROR 5264 (HY000): Outline '%.*s' already exists

Error code in OceanBase Database: 5264
Cause: The outline already exists.
Solution: Check whether the outline has been bound to another SQL statement.

ERROR 5265 (HY000): Outline \'%.s.%.s\' doesn\'t exist

Error code in OceanBase Database: 5265
Cause: The outline does not exist.
Solution: Check whether the outline is created.

ERROR 5267 (HY000): invalid outline ,error info:%s

Error code in OceanBase Database: 5267
Cause: The outline is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5268 (HY000): SQL reach max concurrent num %ld

Error code in OceanBase Database: 5268
Cause: The number of concurrent SQL executions has reached the upper limit.
Solution: Reduce the concurrency.

ERROR 5269 (HY000): can not perform DDL/DML over objects in Recycle Bin

Error code in OceanBase Database: 5269
Cause: The object is in the recycle bin and does not support the operation.
Solution: Restore the object from the recycle bin and perform the operation again.

ERROR 5270 (HY000): object not in RECYCLE BIN

Error code in OceanBase Database: 5270
Cause: The object is not in the recycle bin.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5272 (HY000): Outline content '%.s' of outline '%.s' already exists when added

Error code in OceanBase Database: 5272
Cause: The outline has been created.
Solution: Check whether the existing outline meets the expectation. If yes, you do not need to create another outline. Otherwise, execute the DROP OUTLINE statement and then create an outline.

ERROR 5273 (HY000): Max concurrent in outline '%.*s' already exists when added

Error code in OceanBase Database: 5273
Cause: The throttling rule to be created already exists.
Solution: Check whether the statement for creating a throttling rule specifies an existing throttling rule.

ERROR 5278 (HY000): This partition value with incorrect charset type

Error code in OceanBase Database: 5278
Cause: The metadata of partitioning key values is inconsistent.
Solution: Modify partitioning key values to make their metadata consistent.

ERROR 5291 (HY000): The CTXCAT column must be contiguous in the index column list

Error code in OceanBase Database: 5291
Cause: The CTXCAT field must be contiguous in the field list.
Solution: Modify the CTXCAT field or contact OceanBase Technical Support for troubleshooting.

ERROR 5296 (42000): there has no readable replica

Error code in OceanBase Database: 5296
Cause: No available replica was selected to generate the plan.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5297 (HY000): unexpected time zone info transition

Error code in OceanBase Database: 5297
Cause: A gap or an overlap is used.
Solution: Do not use a gap, or set error_on_overlap_time to false.

ERROR 5298 (HY000): synonym '%.*s' already exists

Error code in OceanBase Database: 5298
Cause: The synonym already exists.
Solution: Check whether the specified synonym already exists. If yes, create a different synonym.

ERROR 5299 (HY000): synonym \'%.s.%.s\' doesn\'t exist

Error code in OceanBase Database: 5299
Cause: The synonym does not exist.
Solution: Check whether the specified synonym exists.

ERROR 5300 (HY000): missing ORDER BY expression in the window specification

Error code in OceanBase Database: 5300
Cause: The ORDER BY expression is missing in the analytic function.
Solution: Add the ORDER BY expression to the analytic function.

ERROR 5301 (HY000): The argument of the window function should be a constant for a partition

Error code in OceanBase Database: 5301
Cause: One or more parameter values in the analytic function are not constants.
Solution: Set all parameter values in the analytic function to constants.

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

Error code in OceanBase Database: 5307
Cause: Available execution threads are insufficient.
Solution: Increase the value of the parallel_servers_target system variable.

Note

The error message is changed from ERROR 5307 (HY000): Scheduler thread number is not enough to 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 since OceanBase Database V4.0.0.

ERROR 5309 (HY000): Ignore sql in restore process

Error code in OceanBase Database: 5309
Cause: Specific SQL statements must be skipped during logical restoration.
Solution: Troubleshooting is not required.

ERROR 5311 (HY000): Invalid column id for %.*s

Error code in OceanBase Database: 5311
Cause: The column ID is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5312 (HY000): Duplicated ddl id '%.*s'

Error code in OceanBase Database: 5312
Cause: Duplicate DDL IDs exist.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5319 (HY000): Child column \'%.s\' data length cannot be less than parent column \'%.s\' data length

Error code in OceanBase Database: 5319
Cause: The foreign key field cannot be shorter than the referenced field.
Solution: Adjust the length of the field.

ERROR 5320 (HY000): \'%.*s\': used in a foreign key constraint

Error code in OceanBase Database: 5320
Cause: The field is used in a foreign key constraint.
Solution: Do not perform this operation on the field.

ERROR 5325 (HY000): ORDER SIBLINGS BY clause not allowed here

Error code in OceanBase Database: 5325
Cause: The ORDER SIBLINGS BY clause is improperly placed.
Solution: Use the ORDER SIBLINGS BY clause only in a hierarchical query statement.

ERROR 5326 (HY000): when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

Error code in OceanBase Database: 5326
Cause: The string used by the SYS_CONNECT_BY_PATH function to separate column values is included in a column value.
Solution: Specify a delimiter that is not included in any column value for the SYS_CONNECT_BY_PATH function, and try again.

ERROR 5327 (HY000): Database can not be specified in public synonym

Error code in OceanBase Database: 5327
Cause: The database is specified for a public synonym.
Solution: Do not specify the database for public synonyms.

ERROR 5328 (HY000): Looping chain of synonyms

Error code in OceanBase Database: 5328
Cause: A circular dependency exists between synonyms.
Solution: Check for circular dependencies between synonyms and make sure that each synonym is unique to avoid circular dependencies.

ERROR 5329 (HY000): Cannot create a synonym with same name as object

Error code in OceanBase Database: 5329
Cause: The synonym is the same as the name of the corresponding object.
Solution: Create a synonym that is different from the object name.

ERROR 5330 (HY000): Synonym %s translation is no longer valid

Error code in OceanBase Database: 5330
Cause: The object corresponding to the synonym does not exist.
Solution: Create an object on which the synonym depends.

ERROR 5331 (HY000): name is already used by an existing object

Error code in OceanBase Database: 5331
Cause: The object already exists.
Solution: Do not use a PL statement to repeatedly create an object that already exists.

ERROR 5337 (HY000): rowid is wrong

Error code in OceanBase Database: 5337
Cause: The data parsed from the ROWID value does not meet the expectation.
Solution: Specify an appropriate ROWID value.

ERROR 5338 (HY000): Window Function not allowed here

Error code in OceanBase Database: 5338
Cause: An expression in an SQL statement contains an analytic function.
Solution: Remove the analytic function from the expression in the SQL statement.

ERROR 5339 (HY000): Fail to parse list partition

Error code in OceanBase Database: 5339
Cause: The number of partitions and the partition definition clause for list partitioning do not match.
Solution: Modify the number of partitions.

ERROR 5341 (HY000): timezone region ID is invalid

Error code in OceanBase Database: 5341
Cause: The region ID data recorded in the TIMESTAMP data cannot be parsed.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5342 (HY000): invalid hex number

Error code in OceanBase Database: 5342
Cause: The hexadecimal number is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5343 (42000): wrong number or types of arguments in call to '%.*s'

Error code in OceanBase Database: 5343
Cause: The parameter list is invalid.
Solution: Check the parameter list.

ERROR 5345 (HY000): insufficient parallel query worker available

Error code in OceanBase Database: 5345
Cause: Available Parallel Execution (PX) threads are insufficient.
Solution: Increase the number of PX threads.

ERROR 5346 (HY000): FOR UPDATE of this query expression is not allowed

Error code in OceanBase Database: 5346
Cause: An invalid expression is specified in the FOR UPDATE clause.
Solution: Modify the FOR UPDATE clause.

ERROR 5347 (HY000): argument should be a function of expressions in PARTITION BY

Error code in OceanBase Database: 5347
Cause: A parsing error occurred.
Solution: Modify the SQL statement.

ERROR 5348 (HY000): result of string concatenation is too long

Error code in OceanBase Database: 5348
Cause: The length of the concatenated string specified by WM_CONCAT exceeds the upper limit.
Solution: Check whether the length of the concatenated string exceeds the value of group_concat_max_len. If yes, increase the value of group_concat_max_len.

Note

For more information about the system variable, see "System variables" in Reference Guide (MySQL Mode) of OceanBase Database documentation.

ERROR 5350 (HY000): updating partition key column would cause a partition change

Error code in OceanBase Database: 5350
Cause: The UPDATE operation caused a change of the partition to which the row belongs.
Solution: Execute the ALTER TABLE statement to enable the ENABLE ROW MOVEMENT attribute of the table.

ERROR 5351 (HY000): invalid type given for an argument

Error code in OceanBase Database: 5351
Cause: One or more parameter types are invalid.
Solution: Check the parameter types.

ERROR 5352 (HY000): specified field not found in datetime or interval

Error code in OceanBase Database: 5352
Cause: A data error occurred during time zone conversion.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5360 (HY000): insufficient privileges

Error code in OceanBase Database: 5360
Cause: You do not have the required privilege.
Solution: Grant the required privileges to the user.

ERROR 5361 (HY000): user %.*s lacks CREATE SESSION privilege; logon denied

Error code in OceanBase Database: 5361
Cause: The user does not have the required privilege to log in.
Solution: Grant the required privilege to the user.

ERROR 5363 (HY000): system privileges not granted to '%.*s'

Error code in OceanBase Database: 5363
Cause: The user does not have system privileges.
Solution: Grant the required system privileges to the user.

ERROR 5364 (HY000): only SELECT and ALTER privileges are valid for sequences

Error code in OceanBase Database: 5364
Cause: Privileges other than SELECT and ALTER on sequences are granted to users.
Solution: Do not grant privileges other than SELECT and ALTER on sequences.

ERROR 5365 (HY000): EXECUTE privilege not allowed for tables

Error code in OceanBase Database: 5365
Cause: The EXECUTE privilege on tables is granted to users.
Solution: Do not grant the EXECUTE privilege on tables.

ERROR 5366 (HY000): only EXECUTE and DEBUG privileges are valid for procedures

Error code in OceanBase Database: 5366
Cause: Privileges other than EXECUTE and DEBUG on procedures are granted to users.
Solution: Do not grant privileges other than EXECUTE and DEBUG on procedures.

ERROR 5367 (HY000): only EXECUTE, DEBUG, and UNDER privileges are valid for types

Error code in OceanBase Database: 5367
Cause: Privileges other than EXECUTE, DEBUG, and UNDER on types are granted to users.
Solution: Do not grant privileges other than EXECUTE, DEBUG, and UNDER on types.

ERROR 5368 (HY000): ADMIN option not granted for role '%.*s'

Error code in OceanBase Database: 5368
Cause: The role does not have the ADMIN OPTION privilege.
Solution: Grant the ADMIN OPTION privilege to the role.

ERROR 5369 (HY000): user or role '%.*s' does not exist

Error code in OceanBase Database: 5369
Cause: The user does not exist.
Solution: Check whether the specified username is valid. If yes, create the required user. If no, correct the specified username.

ERROR 5370 (HY000): missing ON keyword

Error code in OceanBase Database: 5370
Cause: The ON keyword is missing.
Solution: Add the ON keyword.

ERROR 5371 (HY000): grant option does not exist for '%.s.%.s'

Error code in OceanBase Database: 5371
Cause: The user is not authorized to perform privilege delegation.
Solution: Authorize the user to perform privilege delegation.

ERROR 5372 (HY000): ALTER, INDEX and EXECUTE not allowed for views

Error code in OceanBase Database: 5372
Cause: Privileges other than ALTER, INDEX, and EXECUTE on views are granted to users.
Solution: Do not grant privileges other than ALTER, INDEX, and EXECUTE on views.

ERROR 5373 (HY000): circular role grant detected

Error code in OceanBase Database: 5373
Cause: Circular privilege granting is performed for the role.
Solution: Do not perform circular privilege granting for the role.

ERROR 5374 (HY000): invalid privilege on directories

Error code in OceanBase Database: 5374
Cause: Invalid privileges on directories are granted.
Solution: Grant valid privileges on directories.

ERROR 5375 (HY000): directory access denied

Error code in OceanBase Database: 5375
Cause: The user does not have the required privileges on the directory.
Solution: Contact the system administrator to grant the required privileges on the directory to the user.

ERROR 5376 (HY000): missing or invalid role name

Error code in OceanBase Database: 5376
Cause: The role name is invalid.
Solution: Specify a valid role name.

ERROR 5377 (HY000): role '%.*s' not granted or does not exist

Error code in OceanBase Database: 5377
Cause: The role is not assigned or does not exist.

ERROR 5378 (HY000): DEFAULT ROLE '%.*s' not granted to user

Error code in OceanBase Database: 5378
Cause: The default role is not assigned to the user.
Solution: Assign the default role to the user.

ERROR 5379 (HY000): ROLE '%.s' not granted to '%.s'

Error code in OceanBase Database: 5379
Cause: The role to be deallocated has not been assigned to the user.

ERROR 5380 (HY000): cannot GRANT to a role WITH GRANT OPTION

Error code in OceanBase Database: 5380
Cause: The user is not authorized to delegate the role.
Solution: Authorize the user to delegate roles.

ERROR 5381 (HY000): duplicate username in list

Error code in OceanBase Database: 5381
Cause: The GRANT statement contains duplicate usernames.
Solution: Delete redundant usernames.

ERROR 5382 (HY000): cannot grant %.*s to a role

Error code in OceanBase Database: 5382
Cause: The REFERENCE or INDEX privilege is granted to the role.
Solution: Revoke the REFERENCE or INDEX privilege from the role.

ERROR 5383 (HY000): CASCADE CONSTRAINTS must be specified to perform this revoke

Error code in OceanBase Database: 5383
Cause: CASCADE CONSTRAINTS is not specified in the REVOKE statement.
Solution: Specify CASCADE CONSTRAINTS.

ERROR 5384 (HY000): you may not GRANT/REVOKE privileges to/from yourself

Error code in OceanBase Database: 5384
Cause: The current user attempted to grant privileges to or revoke privileges from itself.
Solution: Do not perform such operations. To modify user privileges, contact the system administrator.

ERROR 5386 (HY000): Unable to read data -* Table definition has changed

Error code in OceanBase Database: 5386
Error code in MySQL: 1412
Cause: The snapshot is too old to be correctly read or parsed because the table definition has changed.
Solution: Check whether a column is added or deleted, or whether the data type or length is modified, and perform troubleshooting based on the actual situation.

Note

This error code is introduced since OceanBase Database V4.2.0.

ERROR 5401 (HY000): resultant data type of virtual column is not supported

Error code in OceanBase Database: 5401
Cause: Large objects are referenced in the generated column.
Solution: Remove the reference.

ERROR 5403 (HY000): ddl schema version not match

Error code in OceanBase Database: 5403
Cause: Concurrent DDL operations conflict.
Solution: Solution: Re-execute the DDL operation.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 5409 (HY000): Duplicate object name exists, schema refreshing may be hung

Error code in OceanBase Database: 5409
Cause: Objects with the same name exist when the DDL thread is running.
Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 5410 (HY000): Refresh schema failed continuously, ddl may be hung

Error code in OceanBase Database: 5410
Cause: The DDL thread is suspended and cannot receive new DDL requests.
Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 5434 (HY000): retry sql due to spm

Error code in OceanBase Database: 5434
Cause: The SQL plan management (SPM) feature automatically retried the SQL statement.
Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 5435 (HY000): outline not reproducible

Error code in OceanBase Database: 5435
Cause: The plan specified in the outline cannot be reproduced.
Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 5436 (42000): TIMESTAMP_TO_SCN expected timestamp argument

Error code in OceanBase Database: 5436
Cause: A parameter other than the TIMESTAMP type was passed to the TIMESTAMP_TO_SCN() function.
Solution: Modify the parameter type of the function.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 5437 (42000): SCN_TO_TIMESTAMP expected a integer number as nsec argument

Error code in OceanBase Database: 5437
Cause: A parameter other than the INTEGER type was passed to the SCN_TO_TIMESTAMP() function.
Solution: Modify the parameter type of the function.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 5500 (HY000): Legitimacy check failed for generated columns.

Error code in OceanBase Database: 5500
Cause: During the validation of the values of the generated column or function-based index, the stored values are different from the values recalculated based on the definitions of the generated column or index in the current environment. This may be because that the generated column or index is defined by using built-in functions whose calculation results are affected by system variables or whose behaviors are uncertain. If the _enable_defensive_check parameter is enabled, the error is reported for preventive purposes.
Solution: Check the definitions of the generated column and function-based index. If the calculation results vary with system variables, delete the generated column and index and rebuild them. If the issue persists or is caused by other reasons, contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.2.0.

ERROR 5540 (HY000): System variable '%.s' is different from the old value solidified for '%.s'(old value:%.*s).

Error code in OceanBase Database: 5540
Cause: The value of a system variable specified in the current session is different from that used to create a function index or generated column. The value specified during the creation of the function index or generated column, rather than the value specified in the current session, is used for evaluation.
Solution: To use the variable value specified in the current session for evaluation, drop the function index or generated column and then create one again.

Note

This error code is introduced since OceanBase Database V4.2.2.

ERROR 5558 (42000): %s \'%.s.%.s\' already exists

Error code in OceanBase Database: 5558
Cause: A package with the specified name already exists.
Solution: Execute the CREATE [OR REPLACE] statement to create the package. The package to be created will overwrite the existing package with the same name.

ERROR 5559 (42000): %s \'%.s.%.s\' does not exist

Error code in OceanBase Database: 5559
Cause: The package to be accessed does not exist.
Solution: Check whether the code logic is valid.

ERROR 5561 (HY000): Invalid use of window function

Error code in OceanBase Database: 5561
Cause: The use of the analytic function is improper. For example, parameter settings are invalid.
Solution: Modify the settings.

ERROR 5562 (HY000): Duplicate constraint name '%.*s'

Error code in OceanBase Database: 5562
Cause: A constraint with the specified name already exists.
Solution: Specify another constraint name.

ERROR 5563 (HY000): Constraint not found

Error code in OceanBase Database: 5563
Cause: The target constraint of the operation does not exist.
Solution: Check whether the specified constraint name is valid.

ERROR 5564 (HY000): Duplicate alter index operations on column \'%.*s\'

Error code in OceanBase Database: 5564
Cause: An SQL statement repeatedly triggers the ALTER INDEX operation on the same column.
Solution: Modify the SQL statement.

ERROR 5572 (HY000): a partition may be split into exactly two new partitions

Error code in OceanBase Database: 5572
Cause: The partition is not to be split into two subpartitions.
Solution: Set the partition to be split into two subpartitions.

ERROR 5573 (HY000): this physical attribute may not be specified for a table partition

Error code in OceanBase Database: 5573
Cause: The maximum partitioning key value is used to split the partition.
Solution: Use another partitioning key value for partition splitting.

ERROR 5574 (HY000): missing VALUES keyword

Error code in OceanBase Database: 5574
Cause: The syntax of the statement is invalid.
Solution: Add the VALUES keyword.

ERROR 5575 (HY000): missing AT or VALUES keyword

Error code in OceanBase Database: 5575
Cause: The syntax of the statement is invalid.
Solution: Add the AT or VALUES keyword.

ERROR 5578 (HY000): Plan cache lock conflict

Error code in OceanBase Database: 5578
Cause: The plan cache failed to be locked.
Solution: Try again.

ERROR 5597 (HY000): last resulting partition cannot contain bounds

Error code in OceanBase Database: 5597
Cause: The partition ranges after the splitting is different from those before the splitting.
Solution: Modify the SQL statement.

ERROR 5598 (HY000): cannot add partition when DEFAULT partition exists

Error code in OceanBase Database: 5598
Cause: During list partitioning, a default partition already exists, and no more partitions can be created.
Solution: Split partitions instead of creating partitions.

ERROR 5599 (HY000): cannot split partition into one partition, use rename instead

Error code in OceanBase Database: 5599
Cause: You cannot split a partition into only one subpartition.

ERROR 5600 (HY000): can not create user %s in sys tenant, name %.*s

Error code in OceanBase Database: 5600
Cause: No user can be created under the sys tenant.

ERROR 5601 (HY000): Percentage should between 1 and 99

Error code in OceanBase Database: 5601
Cause: A parsing error occurred.
Solution: Modify the SQL statement.

ERROR 5603 (0A000): Attempt to create, alter or drop an index on temporary table already in use

Error code in OceanBase Database: 5603
Cause: You are attempting to create, modify, or delete an index in a temporary table in use.
Solution: Close all sessions that are using the temporary table and retry the operation.

ERROR 5604 (HY000): invalid NLS parameter string used in SQL function

Error code in OceanBase Database: 5604
Cause: The time parameter is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5605 (HY000): datetime/interval precision is out of range

Error code in OceanBase Database: 5605
Cause: The precision of time data is out of range.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5606 (42000): Invalid number format model

Error code in OceanBase Database: 5606
Cause: The number format is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5607 (HY000): SQL command not properly ended

Error code in OceanBase Database: 5607
Cause: The command did not end properly.
Solution: Check whether the command is valid.

ERROR 5608 (42000): invalid number format model

Error code in OceanBase Database: 5608
Cause: The number format is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5613 (HY000): too many values

Error code in OceanBase Database: 5613
Cause: Too many values are specified in the statement. This error is common for the INSERT statement.
Solution: Adjust the number of values, or contact OceanBase Technical Support for troubleshooting.

ERROR 5614 (HY000): not enough values

Error code in OceanBase Database: 5614
Cause: Values specified in the statement are insufficient. This error is common for the INSERT statement.
Solution: Adjust the number of values, or contact OceanBase Technical Support for troubleshooting.

ERROR 5615 (HY000): single-row subquery returns more than one row

Error code in OceanBase Database: 5615
Cause: The system encountered an error when executing the Scalar subquery expression. Multiple rows were returned for a single execution.
Solution: Check the Scalar subquery expression to ensure that only one row of the result set is returned for each execution.

ERROR 5616 (HY000): UPDATE ... SET expression must be a subquery

Error code in OceanBase Database: 5616
Cause: During row set assignment, the SET clause in the UPDATE statement is not specified as a subquery.
Solution: Modify the SET clause in the UPDATE statement, or contact OceanBase Technical Support for troubleshooting.

ERROR 5617 (HY000): inappropriate INTO

Error code in OceanBase Database: 5617
Cause: The INTO clause is used improperly.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5619 (HY000): Column part of using clause can not have qualifier

Error code in OceanBase Database: 5619
Cause: The column name specified in the USING clause contains the database name or table name.
Solution: Remove the database name or table name from the column name in the USING clause.

ERROR 5623 (HY000): outer join operator (+) not allowed in operand of OR or IN

Error code in OceanBase Database: 5623
Cause: The OR clause contains an outer join operator (+).
Solution: Modify the SQL statement.

ERROR 5624 (HY000): a column may not be outer-joined to a subquery

Error code in OceanBase Database: 5624
Cause: A column cannot be joined to a subquery by an outer join operator (+).
Solution: Modify the SQL statement.

ERROR 5625 (HY000): old style outer join (+) cannot be used with ANSI joins

Error code in OceanBase Database: 5625
Cause: If a query block uses an ANSI style join, the old-style join + used to specify an outer join cannot be used.
Solution: Modify the SQL statement.

ERROR 5626 (HY000): outer join operator (+) is not allowed here

Error code in OceanBase Database: 5626
Cause: You are attempting to reference + in the SELECT_LIST function or the CONNECT BY, START WITH, or ORDER BY clause.
Solution: Modify the SQL statement.

ERROR 5627 (HY000): Schema try again

Error code in OceanBase Database: 5627
Cause: The local schema version is outdated.
Solution: Retry the operation or contact OceanBase Technical Support for troubleshooting.

ERROR 5628 (HY000): zero-length columns are not allowed

Error code in OceanBase Database: 5628
Cause: The length of column data is 0.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5629 (HY000): year conflicts with Julian date

Error code in OceanBase Database: 5629
Cause: The year conflicts with the Julian day, 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

Error code in OceanBase Database: 5630
Cause: The day of the year (1 to 366) conflicts with the Julian day.

ERROR 5631 (HY000): month conflicts with Julian date

Error code in OceanBase Database: 5631
Cause: The month conflicts with the Julian day, for example, SELECT TO_DATE('11 2459063','MM J') FROM DUAL;.

ERROR 5632 (HY000): day of month conflicts with Julian date

Error code in OceanBase Database: 5632
Cause: The day of the month (1 to 31) conflicts with the Julian day, for example, SELECT TO_DATE('11 2459063','DD J') FROM DUAL;.

ERROR 5633 (HY000): day of week conflicts with Julian date

Error code in OceanBase Database: 5633
Cause: The day of the week (1 to 7) conflicts with the Julian day, for example, SELECT TO_DATE('3 2459063','D J') FROM DUAL;.

ERROR 5634 (HY000): hour conflicts with seconds in day

Error code in OceanBase Database: 5634
Cause: The hour conflicts with the second in the day.

ERROR 5635 (HY000): minutes of hour conflicts with seconds in day

Error code in OceanBase Database: 5635
Cause: The minute of the hour conflicts with the second in the day.

ERROR 5636 (HY000): seconds of minute conflicts with seconds in day

Error code in OceanBase Database: 5636
Cause: The second of the minute conflicts with the second in the day.

ERROR 5637 (HY000): date not valid for month specified

Error code in OceanBase Database: 5637
Cause: The date is invalid for the specified month.

ERROR 5638 (HY000): input value not long enough for date format

Error code in OceanBase Database: 5638
Cause: The input value is too short to be used in the date format.

ERROR 5639 (HY000): (full) year must be between -4713 and +9999, and not be 0

Error code in OceanBase Database: 5639
Cause: The year of the date is not within the range of 1 to 9999.

ERROR 5640 (HY000): quarter must be between 1 and 4

Error code in OceanBase Database: 5640
Cause: The quarter is not within the range of 1 to 4.

ERROR 5641 (HY000): not a valid month

Error code in OceanBase Database: 5641
Cause: The month is invalid.

ERROR 5642 (HY000): not a valid day of the week

Error code in OceanBase Database: 5642
Cause: The day of the week is invalid.

ERROR 5643 (HY000): day of year must be between 1 and 365 (366 for leap year)

Error code in OceanBase Database: 5643
Cause: The day of the year is not within the range of 1 to 365 (366 if the year is a leap year) and is invalid.

ERROR 5644 (HY000): hour must be between 1 and 12

Error code in OceanBase Database: 5644
Cause: The hour is not within the range of 1 to 12.

ERROR 5645 (HY000): hour must be between 0 and 23

Error code in OceanBase Database: 5645
Cause: The hour is not within the range of 0 to 23.

ERROR 5646 (HY000): minutes must be between 0 and 59

Error code in OceanBase Database: 5646
Cause: The minute is not within the range of 0 to 59.

ERROR 5647 (HY000): seconds must be between 0 and 59

Error code in OceanBase Database: 5647
Cause: The second is not within the range of 0 to 59.

ERROR 5648 (HY000): seconds in day must be between 0 and 86399

Error code in OceanBase Database: 5648
Cause: The second in the day is not within the range of 0 to 86399.

ERROR 5649 (HY000): julian date must be between 1 and 5373484

Error code in OceanBase Database: 5649
Cause: The Julian day is invalid.
Solution: Make sure that the Julian day is within the range of 1 to 5373484.

ERROR 5650 (HY000): AM/A.M. or PM/P.M. required

Error code in OceanBase Database: 5650
Cause: The AM, A.M., PM, or P.M. datetime format is not specified.

ERROR 5651 (HY000): BC/B.C. or AD/A.D. required

Error code in OceanBase Database: 5651
Cause: The BC, B.C., AD,or A.D. datetime format is not specified.

ERROR 5652 (HY000): format code appears twice

Error code in OceanBase Database: 5652
Cause: The specified format model is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5653 (HY000): day of week may only be specified once

Error code in OceanBase Database: 5653
Cause: The day of the week can be specified only once.

ERROR 5654 (HY000): signed year precludes use of BC/AD

Error code in OceanBase Database: 5654
Cause: The signed date cannot contain BC or AD.

ERROR 5655 (HY000): Julian date precludes use of day of year

Error code in OceanBase Database: 5655
Cause: The Julian day and the day of the year cannot be used together.

ERROR 5656 (HY000): year may only be specified once

Error code in OceanBase Database: 5656
Cause: The year can be specified only once.

ERROR 5657 (HY000): hour may only be specified once

Error code in OceanBase Database: 5657
Cause: The hour can be specified only once.

ERROR 5658 (HY000): AM/PM conflicts with use of A.M./P.M

Error code in OceanBase Database: 5658
Cause: The AM or PM setting conflicts with the A.M. or P.M. setting.

ERROR 5659 (HY000): BC/AD conflicts with use of B.C./A.D

Error code in OceanBase Database: 5659
Cause: The BC or AD setting conflicts with the B.C. or A.D. setting.

ERROR 5660 (HY000): month may only be specified once

Error code in OceanBase Database: 5660
Cause: The month can be specified only once.

ERROR 5661 (HY000): day of week may only be specified once

Error code in OceanBase Database: 5661
Cause: The day of the week can be specified only once.

ERROR 5662 (HY000): format code cannot appear in date input format

Error code in OceanBase Database: 5662
Cause: The specified format model is invalid.
Solution: Check whether the number format model meets the syntax requirements.

ERROR 5663 (HY000): a non-numeric character was found where a numeric was expected

Error code in OceanBase Database: 5663
Cause: The numeric value is invalid.
Solution: Check whether the numeric value in the SQL statement contains invalid characters.

ERROR 5664 (HY000): 'HH24' precludes use of meridian indicator

Error code in OceanBase Database: 5664
Cause: The HH24 format model contains the AM or PM indicator.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5665 (HY000): missing or illegal character following the escape character

Error code in OceanBase Database: 5665
Cause: The character following the ESCAPE field in the LIKE clause is invalid.
Solution: Make sure that the character following the ESCAPE field in the LIKE clause is valid.

ERROR 5666 (HY000): escape character must be character string of length 1

Error code in OceanBase Database: 5666
Cause: In the LIKE clause, multiple characters follow the ESCAPE field.
Solution: Set the character following the ESCAPE field to be a single character.

ERROR 5667 (HY000): day of month must be between 1 and last day of month

Error code in OceanBase Database: 5667
Cause: The day of the month is not within the range of the first to the last day of the month.

ERROR 5668 (HY000): not a SELECTed expression

Error code in OceanBase Database: 5668
Cause: The expression specified in the GROUP BY clause is missing in the SELECT clause.
Solution: Modify the SQL statement.

ERROR 5670 (HY000): (full) year must be between -4713 and +9999, and not be 0

Error code in OceanBase Database: 5670
Cause: The year of the date is not within the range of 1 to 9999.

ERROR 5671 (HY000): such unique or primary key already exists in the table

Error code in OceanBase Database: 5671
Cause: The unique index already exists.
Solution: Do not create duplicate unique indexes.

ERROR 5672 (HY000): such column list already indexed

Error code in OceanBase Database: 5672
Cause: Do not create duplicate indexes.
Solution: Do not create duplicate indexes.

ERROR 5674 (HY000): argument '%ld' is out of range

Error code in OceanBase Database: 5674
Cause: The specified parameter value is out of range.
Solution: Modify the parameter value.

ERROR 5675 (HY000): ORDER BY item must be the number of a SELECT-list expression

Error code in OceanBase Database: 5675
Cause: The number specified for ORDER BY does not match the items specified for SELECT.
Solution: Modify the ORDER BY clause in the SQL statement.

ERROR 5676 (HY000): the interval is invalid

Error code in OceanBase Database: 5676
Cause: The parameter is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5677 (HY000): PL/SQL: numeric or value error: %.*s

Error code in OceanBase Database: 5677
Cause: Invalid data, such as an invalid number, is found during PL execution.
Solution: Check whether the code logic is valid.

ERROR 5678 (HY000): name already used by an existing constraint

Error code in OceanBase Database: 5678
Cause: A constraint with the specified name already exists.
Solution: Specify another constraint name.

ERROR 5679 (HY000): table must have at least one column that is not invisible

Error code in OceanBase Database: 5679
Error code in MySQL: 4028
Cause: A function-based index adds hidden columns to a table. If a table contains a hidden column, this error is returned when you delete all visible columns of the table.
Solution: Check the column definition and metadata of the data table and make sure that at least one visible column is not deleted.

Note

This error code is introduced since OceanBase Database V4.2.0.

ERROR 5680 (HY000): Invisible column is not supported on this type of table

Error code in OceanBase Database: 5680
Cause: Temporary tables in Oracle mode cannot contain invisible columns.

ERROR 5681 (HY000): Column visibility modifications cannot be combined with any other modified column DDL option

Error code in OceanBase Database: 5681
Cause: You cannot modify the column visibility together with other column attributes by using a DDL statement.
Solution: Split the DDL statement to modify column visibility separately.

ERROR 5682 (HY000): The visibility of a column from a table owned by a SYS user cannot be changed

Error code in OceanBase Database: 5682
Cause: The column visibility of tables owned by users under the sys tenant cannot be modified.

ERROR 5683 (HY000): too many arguments for function

Error code in OceanBase Database: 5683
Cause: The function contains excessive parameters.
Solution: Adjust the number of parameters.

ERROR 5684 (HY000): PX sql need retry

Error code in OceanBase Database: 5684
Cause: This is an internal error code. It instructs PX to retry the SQL statement.
Solution: This error rarely occurs. If this error occurs, check whether the leader is properly switched and whether the network status is normal.

ERROR 5685 (HY000): Tenant '(string)' has been dropped

Error code in OceanBase Database: 5685
Cause: The tenant has been deleted.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5686 (HY000): invalid extract field for extract source

Error code in OceanBase Database: 5686
Cause: The EXTRACT function cannot parse the specified value range.
Solution: Check whether the specified value range is valid.

ERROR 5687 (42000): %s \'%.s.%.s\' compile error

Error code in OceanBase Database: 5687
Cause: Package or user-defined type (UDT) compilation failed.
Solution: Fix the error based on the error message.

ERROR 5690 (HY000): subquery not allowed here

Error code in OceanBase Database: 5690
Cause: The subquery is not allowed at the current location.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5691 (HY000): date or system variable wrongly specified in CHECK constraint

Error code in OceanBase Database: 5691
Cause: No DATE function or system variable is allowed in the CHECK constraint.

ERROR 5692 (HY000): Cannot drop constraint - nonexistent constraint

Error code in OceanBase Database: 5692
Cause: The constraint does not exist.

ERROR 5693 (HY000): check constraint violated

Error code in OceanBase Database: 5693
Cause: The CHECK constraint is not met.
Solution: Check whether the column data involved in the DML operation meets the existing CHECK constraint.

ERROR 5694 (HY000): group function is not allowed here

Error code in OceanBase Database: 5694
Cause: The aggregate function is not allowed at the current location.
Solution: Modify the location of the aggregate function in the SQL statement.

ERROR 5695 (HY000): policy string not found

Error code in OceanBase Database: 5695
Cause: No security strategy is found.
Solution: Create a security strategy.

ERROR 5696 (HY000): invalid label string

Error code in OceanBase Database: 5696
Cause: The tag string is invalid.
Solution: Specify a valid tag string.

ERROR 5697 (HY000): undefined compartment string for policy string

Error code in OceanBase Database: 5697
Cause: The compartment string is invalid.
Solution: Specify a valid compartment string.

ERROR 5698 (HY000): undefined level string for policy string

Error code in OceanBase Database: 5698
Cause: The level string is invalid.
Solution: Specify a valid level string.

ERROR 5699 (HY000): undefined group string for policy string

Error code in OceanBase Database: 5699
Cause: The group string is invalid.
Solution: Specify a valid group string.

ERROR 5700 (HY000): LBAC error: %s

Error code in OceanBase Database: 5700
Cause: A common tag security error occurred. For more information, see the error message.
Solution: Adjust the operation based on the error message.

ERROR 5701 (HY000): policy role already exists for policy string

Error code in OceanBase Database: 5701
Cause: A strategy with the specified name already exists.
Solution: Specify another strategy name or delete the existing strategy.

ERROR 5702 (HY000): NULL or invalid user label: %s

Error code in OceanBase Database: 5702
Cause: The user tag is invalid.
Solution: Specify a valid user tag.

ERROR 5703 (HY000): Add index failed

Error code in OceanBase Database: 5703
Cause: The index failed to be added.
Solution: Check whether the index is valid. You can delete it and then create another index.

ERROR 5704 (HY000): profile %.*s does not exist

Error code in OceanBase Database: 5704
Cause: The profile name is invalid.
Solution: Check the profile name.

ERROR 5705 (HY000): invalid resource limit %s

Error code in OceanBase Database: 5705
Cause: Values of the FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME parameters in the DDL statements of a profile are not valid integers or are 0.
Solution: Modify the parameter values in the DDL statements of the profile.

ERROR 5706 (HY000): profile %.*s already exists

Error code in OceanBase Database: 5706
Cause: A profile with the specified name already exists.
Solution: Specify another profile name.

ERROR 5707 (HY000): profile %.*s has users assigned, cannot drop without CASCADE

Error code in OceanBase Database: 5707
Cause: The profile is being used by a user and supports only cascade deletion.
Solution: Add CASCADE.

ERROR 5708 (HY000): the leading precision of the interval is too small

Error code in OceanBase Database: 5708
Cause: The precision is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5709 (HY000): time zone hour must be between -12 and 14

Error code in OceanBase Database: 5709
Cause: The hour specified in the time_zone system variable is out of range.
Solution: Make sure that the value is within the range of [-12,14] in MySQL mode.

ERROR 5710 (HY000): time zone minute must be between -59 and 59

Error code in OceanBase Database: 5710
Cause: The minute specified in the time_zone system variable is out of range.
Solution: Make sure that the value is within the range of [-59,59].

ERROR 5711 (HY000): not a valid time zone

Error code in OceanBase Database: 5711
Cause: TZD, TZH, TZM, and TZR are not allowed in the DATE format.

ERROR 5712 (HY000): date format is too long for internal buffer

Error code in OceanBase Database: 5712
Cause: The data length specified for the DATE format is too long.
Solution: Shorten the data length of the DATE format.

ERROR 5713 (HY000): cannot validate (%.s.%.s) - check constraint violated

Error code in OceanBase Database: 5713
Cause: The input violates the constraint.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5714 (HY000): data manipulation operation not legal on this view

Error code in OceanBase Database: 5714
Cause: You are attempting to to execute the INSERT, UPDATE, or DELETE statement to modify a view that cannot be updated. For example, the operation attempted to generate columns, modify the expression list, or manage data from multiple tables.
Solution: Modify the base table or redefine the view.

ERROR 5715 (HY000): virtual column not allowed here

Error code in OceanBase Database: 5715
Cause: You are attempting to to execute the INSERT, DELETE, or UPDATE statement to modify an expression in the view.
Solution: Modify the base table.

ERROR 5716 (HY000): cannot modify more than one base table through a join view

Error code in OceanBase Database: 5716
Cause: The column belongs to multiple tables and cannot be inserted or updated.
Solution: Split the statement into multiple statements.

ERROR 5721 (HY000): cannot delete from view without exactly one key-preserved table

Error code in OceanBase Database: 5721
Cause: The table to be deleted does not have a key-preserved table or has multiple key-preserved tables, or the key-preserved table belongs to a read-only view.
Solution: Redefine the view or perform deletion on the base table.

ERROR 5722 (HY000): cannot modify a column which maps to a non key-preserved table

Error code in OceanBase Database: 5722
Cause: You are attempting to to insert or update a non-key-preserved table in the JOIN view.
Solution: Modify the base table.

ERROR 5723 (HY000): cannot perform a DML operation on a read-only view

Error code in OceanBase Database: 5723
Cause: You are attempting to to execute the INSERT, DELETE, or UPDATE statement to modify a read-only view.
Solution: Modify the base table or set the view to be updatable.

ERROR 5724 (HY000): invalid INITRANS option value

Error code in OceanBase Database: 5724
Cause: The value of the INITRANS parameter is invalid.
Solution: Modify the parameter value.

ERROR 5725 (HY000): invalid MAXTRANS option value

Error code in OceanBase Database: 5725
Cause: The value of the MAXTRANS parameter is invalid.
Solution: Modify the parameter value.

ERROR 5726 (HY000): invalid value for PCTFREE or PCTUSED

Error code in OceanBase Database: 5726
Cause: The value of the PCTFREE or PCTUSED parameter is invalid.
Solution: Modify the parameter value.

ERROR 5728 (HY000): illegal argument for function

Error code in OceanBase Database: 5728
Cause: The parameter value is invalid.
Solution: Modify the parameter value.

ERROR 5729 (HY000): this operator cannot be used with lists

Error code in OceanBase Database: 5729
Cause: The vector comparison operation is not supported.
Solution: Remove the vector comparison operation.

ERROR 5730 (HY000): SAMPLE percentage must be in the range [0.000001,100)

Error code in OceanBase Database: 5730
Cause: A parsing error occurred.
Solution: Modify the SQL statement.

ERROR 5731 (HY000): specifying owner's name of the table is not allowed

Error code in OceanBase Database: 5731
Cause: The table object to be renamed cannot carry the username.

ERROR 5732 (HY000): stmt trigger with when clause

Error code in OceanBase Database: 5732
Cause: The WHEN condition cannot be specified in the statement-level trigger.
Solution: Remove the WHEN condition from the statement-level trigger.

ERROR 5732 (HY000): not enough arguments for function

Error code in OceanBase Database: 5732
Cause: Parameters of the function are insufficient.
Solution: Supplement parameters.

ERROR 5733 (HY000): trigger '%.*s' does not exist

Error code in OceanBase Database: 5733
Cause: The specified trigger does not exist.
Solution: Check whether the specified trigger exists.

ERROR 5734 (HY000): trigger '%.*s' already exist

Error code in OceanBase Database: 5734
Cause: The specified trigger already exists.
Solution: Check whether the specified trigger exists.

ERROR 5735 (HY000): trigger '%.*s' already exists on another table, cannot replace it

Error code in OceanBase Database: 5735
Cause: A trigger with the specified name already exists in another table, and the current trigger cannot be created.
Solution: Specify another name for the trigger to be created.

ERROR 5736 (HY000): error signaled in parallel query server

Error code in OceanBase Database: 5736
Cause: This is an internal error code. When PX needs to terminate execution, it broadcasts this error code to all execution nodes to terminate the current execution.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5763 (HY000): Specified pseudo column or operator not allowed here

Error code in OceanBase Database: 5763
Cause: The LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE keyword are not allowed at the current location.
Solution: Delete the LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE keyword.

ERROR 5764 (HY000): CONNECT BY loop in user data

Error code in OceanBase Database: 5764
Cause: A CONNECT BY loop exists in the user data.

ERROR 5765 (HY000): cannot have join with CONNECT BY

Error code in OceanBase Database: 5765
Cause: A join with CONNECT BY is not allowed.

ERROR 5766 (HY000): CONNECT BY clause required in this query block

Error code in OceanBase Database: 5766
Cause: This query block requires the CONNECT BY clause.

ERROR 5768 (HY000): SYS_CONNECT_BY_PATH function is not allowed here

Error code in OceanBase Database: 5768
Cause: The SYS_CONNECT_BY_PATH function is called beyond the SELECT list and ORDER BY clause.
Solution: Delete the calls of the SYS_CONNECT_BY_PATH function except those in the SELECT list and ORDER BY clause.

ERROR 5769 (HY000): illegal parameter in SYS_CONNECT_BY_PATH function

Error code in OceanBase Database: 5769
Cause: The SYS_CONNECT_BY_PATH function contains invalid arguments.

ERROR 5770 (HY000): A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values

Error code in OceanBase Database: 5770
Cause: The string used by the SYS_CONNECT_BY_PATH function to separate column values is included in a column value.
Solution: Specify a delimiter that is not included in any column value for the SYS_CONNECT_BY_PATH function.

ERROR 5771 (HY000): CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition

Error code in OceanBase Database: 5771
Cause: The CONNECT BY ROOT operator is used in the START WITH or CONNECT BY condition.
Solution: Delete the CONNECT BY ROOT operator from the START WITH or CONNECT BY condition.

ERROR 5772 (HY000): ORDER SIBLINGS BY clause not allowed here

Error code in OceanBase Database: 5772
Cause: The query with the ORDER SIBLINGS BY clause does not contain the CONNECT BY clause.
Solution: Delete the ORDER SIBLINGS BY clause or add the CONNECT BY clause to the query.

ERROR 5773 (HY000): NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column

Error code in OceanBase Database: 5773
Cause: CONNECT_BY_ISCYCLE is specified in a query, but this query does not contain the NOCYCLE keyword.
Solution: Delete CONNECT_BY_ISCYCLE from the query or add the NOCYCLE keyword to the query.

ERROR 5774 (HY000): not enough arguments for function

Error code in OceanBase Database: 5774
Cause: Arguments of the function are insufficient.

ERROR 5777 (HY000): Prepare statement checksum error

Error code in OceanBase Database: 5777
Cause: The server session is unrecoverable.
Solution: Log in to OceanBase Database again so that the system automatically creates a server session. For more information, see the session trace file.

ERROR 5778 (HY000): cannot enable constraint (%.*s) - no such constraint

Error code in OceanBase Database: 5778
Cause: The specified constraint does not exist in the table.

ERROR 5779 (HY000): cannot disable constraint (%.*s) - no such constraint

Error code in OceanBase Database: 5779
Cause: The specified constraint does not exist in the table.

ERROR 5780 (HY000): PX DOP downgrade from %ld to %ld

Error code in OceanBase Database: 5780
Cause: The error code indicates a normal exit.

ERROR 5781 (HY000): parallel_max_servers downgrade due to insufficent cpu resource from %ld to %ld. deprecated

Error code in OceanBase Database: 5781
Cause: The error code indicates a normal exit.

Note

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

ERROR 5785 (HY000): cannot validate (%.s.%.s) - parent keys not found

Error code in OceanBase Database: 5785
Cause: The ALTER TABLE VALIDATE CONSTRAINT operation on the table failed because the table contains orphaned child records.

ERROR 5786 (HY000): Column check constraint cannot reference other columns

Error code in OceanBase Database: 5786
Cause: You are attempting to to define a column check constraint that references another column.
Solution: Define the constraint as a table check constraint.

ERROR 5787 (HY000): batched multi statement execution needs rollback

Error code in OceanBase Database: 5787
Cause: Batched statement executions are not supported.
Solution: Troubleshooting is not required. The OBServer node will automatically roll back the process to execute the statements separately.

ERROR 5788 (HY000): cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc

Error code in OceanBase Database: 5788
Cause: You are attempting to to select the FOR UPDATE statement from a view on which no major compaction is performed. No major compaction is performed because a statement that prevents major compactions (such as DISTINCT or GROUP BY) is used for the view, or the parameter settings in the initialization file are invalid.
Solution: Analyze the cause of the compaction failure and handle the failure so that a major compaction can be performed on the view.

ERROR 5789 (HY000): policy with check option violation

Error code in OceanBase Database: 5789
Cause: The security flag written into data is invalid.

ERROR 5790 (HY000): policy already applied to table

Error code in OceanBase Database: 5790
Cause: You are attempting to to apply the strategy to a table that is already protected by the strategy.
Solution: To modify the strategy option, predicate, or tag value, remove the strategy from the table, modify the settings, and then re-apply the strategy.

ERROR 5791 (HY000): table '%.s'.' %.s' is mutating, trigger/function may not see it

Error code in OceanBase Database: 5791
Cause: A trigger or a user-defined plsql function referenced in the statement attempted to view or modify a table, but the statement that triggered the table was modifying the table.
Solution: Rewrite the trigger or function so that it does not read the table.

ERROR 5792 (HY000): column is referenced in a multi-column constraint

Error code in OceanBase Database: 5792
Cause: A column to be deleted is referenced by some constraints.
Solution: Delete all constraints that reference the column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5793 (HY000): cannot drop parent key column

Error code in OceanBase Database: 5793
Cause: You are attempting to to delete a parent key column referenced by some constraints.
Solution: Delete all constraints that reference the parent key column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5794 (HY000): auto increment service busy

Error code in OceanBase Database: 5794
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5795 (HY000): No insert/update/delete on table with constraint (%.s.%.s) disabled and validated

Error code in OceanBase Database: 5795
Cause: You are attempting to to perform an insert, update, or delete operation on a table with the DISABLE VALIDATE constraint.
Solution: Change the status of the constraint.

ERROR 5796 (HY000): active autonomous transaction detected and rolled back

Error code in OceanBase Database: 5796
Cause: All active autonomous transactions in an autonomous PL block must be completed (committed or rolled back) before they return from the block. If these transactions are not completed, the active autonomous transactions are implicitly rolled back, thereby inducing this error.
Solution: Make sure that all active autonomous transactions are explicitly specified or rolled back before they return from the autonomous PL block.

ERROR 5797 (HY000): ORDER BY not allowed here

Error code in OceanBase Database: 5797
Cause: The ORDER BY clause is not allowed in DISTINCT or RATIO_TO_REPORT.

ERROR 5798 (HY000): DISTINCT not allowed here

Error code in OceanBase Database: 5798
Cause: The DISTINCT option is not allowed in the function.

ERROR 5799 (HY000): assign user variable with : = only allowed in select filed list and as root expression

Error code in OceanBase Database: 5799
Cause: When := is used to assign values to user variables, it can appear only in the SELECT expression as the root node.
Solution: We recommend that you do not use := to assign values to user variables.

ERROR 5800 (HY000): cannot modify constraint (%.*s) - no such constraint

Error code in OceanBase Database: 5800
Cause: The specified constraint does not exist in the table.

ERROR 5801 (HY000): implementation restriction: exception handler in nested transaction is illegal

Error code in OceanBase Database: 5801
Cause: Exceptions cannot be handled in nested transactions.
Solution: Remove the exception handler from nested transactions.

ERROR 5802 (HY000): invalid ROWID

Error code in OceanBase Database: 5802
Cause: The ROWID value is invalid.

ERROR 5803 (HY000): Invalid column in the INSERT VALUES Clause:' %.s'.' %.s'

Error code in OceanBase Database: 5803
Cause: Invalid columns are referenced in the INSERT VALUES clause.

ERROR 5804 (HY000): incorrect use of the ['%.*s'] operator

Error code in OceanBase Database: 5804
Cause: The system encountered an error when performing the operation.
Solution: Check the parameters and return type of the operator.

ERROR 5805 (HY000): non-constant expression is not allowed for pivot|unpivot values

Error code in OceanBase Database: 5805
Cause: You are attempting to use a non-constant expression for pivot or unpivot values.
Solution: Use a constant expression for pivot and unpivot values.

ERROR 5806 (HY000): expect aggregate function inside pivot operation

Error code in OceanBase Database: 5806
Cause: A non-aggregate function is used in the pivot operation.
Solution: Use an aggregate function.

ERROR 5807 (HY000): expression must have same datatype as corresponding expression

Error code in OceanBase Database: 5807
Cause: The data type of the expression must be the same as that of the corresponding expression.

ERROR 5808 (HY000): character set mismatch

Error code in OceanBase Database: 5808
Cause:
- Different character sets are used for the string operands (excluding nlsparams) of the operator or built-in function.
- The nlsparams operand is not contained in the character set of the database.
- A character set other than the character set of the database is used for the string data passed to the built-in function, but the built-in function does not support the character set in use.
- The second argument of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.
- The character set of the string expression in the VALUES clause of the INSERT statement or the SET clause of the UPDATE statement is different from the character set used by the column to be inserted.
- In the table creation statement, the character set used for the values in the DEFAULT clause is different from the character set declared for the column.
- Parameters of the PL/SQL function do not conform to the specified character set.

ERROR 5809 (HY000): regular expression failed to match

Error code in OceanBase Database: 5809
Cause: Regular expression matching failed, and no valid string was found.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5810 (HY000): invalid regular expression (reg version 0.8)

Error code in OceanBase Database: 5810
Cause: The specified regular expression pattern is invalid.
Solution: Modify the regular expression pattern.

ERROR 5811 (HY000): invalid escape \\ sequence in regular expression

Error code in OceanBase Database: 5811
Cause: The escape character in the regular expression is invalid.
Solution: Remove the invalid escape character.

ERROR 5812 (HY000): unmatched bracket in regular expression

Error code in OceanBase Database: 5812
Cause: Square brackets ([]) in the regular expression do not appear in pairs.
Solution: Make sure that square brackets ([]) appear in pairs.

ERROR 5813 (HY000): unmatched parentheses in regular expression

Error code in OceanBase Database: 5813
Cause: Parentheses (()) in the regular expression do not appear in pairs.
Solution: Make sure parentheses (()) appear in pairs.

ERROR 5814 (HY000): invalid back reference in regular expression

Error code in OceanBase Database: 5814
Cause: The subexpression contains a back reference.
Solution: Make sure that the referenced subexpression is valid.

ERROR 5815 (HY000): invalid range in regular expression

Error code in OceanBase Database: 5815
Cause: An invalid range is found in the regular expression.
Solution: Use a valid range.

ERROR 5816 (HY000): invalid character class in regular expression

Error code in OceanBase Database: 5816
Cause: An unknown character class is found in the regular expression.
Solution: Use a valid character class.

ERROR 5817 (HY000): invalid collation class in regular expression

Error code in OceanBase Database: 5817
Cause: An unknown collation class is found in the regular expression.
Solution: Use a valid collation class.

ERROR 5818 (HY000): braces {} not balanced in in regular expression

Error code in OceanBase Database: 5818
Cause: Braces ({}) in the regular expression are not in pair.
Solution: Correct the braces ({}) in the regular expression.

ERROR 5819 (HY000): invalid repetition count(s) in regular expression

Error code in OceanBase Database: 5819
Cause: The number of repeated matches in the regular expression engine is invalid.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5820 (HY000): The regular expression was too complex and current library can't be parsed

Error code in OceanBase Database: 5820
Cause: The regular expression is too complex and cannot be parsed by the current regular expression engine.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5821 (HY000): regular expression internal error

Error code in OceanBase Database: 5821
Cause: The regular expression is too complex and cannot be parsed by the current regular expression engine.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5822 (HY000): invalid argument in regular expression

Error code in OceanBase Database: 5822
Cause: Invalid arguments are found in the regular expression.
Solution: Check the validity of arguments in the regular expression.

ERROR 5823 (HY000): character widths of regex and string differ in regular expression

Error code in OceanBase Database: 5823
Cause: The regular expression engine contains a mixed character set.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5824 (HY000): invalid embedded option in regular expression

Error code in OceanBase Database: 5824
Cause: The pattern match parameter in the regular expression is invalid.
Solution: Correct the pattern match parameter in the regular expression.

ERROR 5825 (HY000): nfa has too many states in regular expression, may be the regular expression too long

Error code in OceanBase Database: 5825
Cause: The transfer state machine in the regular expression engine is abnormal.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5827 (HY000): the definition of relative objects have been modified, please check and retry

Error code in OceanBase Database: 5827
Cause: Concurrent DDL operations conflict.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5828 (HY000): Subscript beyond count

Error code in OceanBase Database: 5828
Cause: The subscript exceeds the maximum length of the VARRAY or is too large for the nested table.
Solution: Check the program logic and perform explicit extension if necessary.

ERROR 5829 (HY000): PARTITION () clause on non partitioned table

Error code in OceanBase Database: 5829
Cause: The table or index is not partitioned. The syntax is invalid.
Solution: Retry the command with the valid syntax.

ERROR 5830 (HY000): Unknown subpartition

Error code in OceanBase Database: 5830
Cause: No subpartition is found for the object.
Solution: Use the valid subpartition name and try again.

ERROR 5831 (HY000): Invalid SQL ROW LIMITING expression was specified

Error code in OceanBase Database: 5831
Cause: The ROW LIMITING expression of the SQL statement contains components other than literals, bind variables, correlation variables, or subqueries.
Solution: Modify the ROW LIMITING expression of the SQL statement and retry the operation.

ERROR 5833 (HY000): not implemented in SQL static typing engine

Error code in OceanBase Database: 5833
Cause: The new engine does not support this feature.
Solution: Troubleshooting is not required. The SQL engine will automatically retry the operation.

ERROR 5834 (HY000): name is already used by an existing object

Error code in OceanBase Database: 5834
Cause: The object already exists.
Solution: Do not use a PL statement to repeatedly create an object that already exists.

ERROR 5835 (HY000): connection description for remote database not found

Error code in OceanBase Database: 5835
Cause: No connection description is found for the remote database.

ERROR 5836 (HY000): database link not found

Error code in OceanBase Database: 5836
Cause: The database link to be deleted is not found in the dictionary.
Solution: Modify the database link name.

ERROR 5837 (HY000): Reference to uninitialized composite

Error code in OceanBase Database: 5837
Cause: The object, LOB, or another multi-level partition referenced on the left side is not initialized.
Solution: Initialize the multi-level partition by using an appropriate constructor or through global object assignment.

ERROR 5838 (HY000): Reference to uninitialized collection

Error code in OceanBase Database: 5838
Cause: A nested table, VARRAY element, or member function is referenced, but the collection is not initialized.
Solution: Initialize the collection by using an appropriate constructor or through global object assignment.

ERROR 5839 (HY000): no more rows needed

Error code in OceanBase Database: 5839
Cause: The caller of the pipelined function does not require the pipelined function to generate more rows.
Solution: Do not handle the NO_DATA_NEEDED exception in an exception handling block.

ERROR 5840 (HY000): PL/SQL: program error

Error code in OceanBase Database: 5840
Cause: An internal error occurred. An error was detected in the PL program.
Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 5841 (HY000): PL/SQL: Return types of Result Set variables or query do not match

Error code in OceanBase Database: 5841
Cause: The number or type of columns in the query does not match the return types declared by result set variables, or the types declared by two result set variables do not match.
Solution: Modify the program statement or declaration.

ERROR 5842 (HY000): PL/SQL: storage error

Error code in OceanBase Database: 5842
Cause: The PL program cannot allocate other storage. The program may be out of control.
Solution:
1. Make sure that the PL program does not use additional memory.
2. Release unused objects by programming. For example, set them to NULL.
3. Increase the size of available shared or process memory (if applicable).

ERROR 5843 (HY000): Subscript outside of limit

Error code in OceanBase Database: 5843
Cause: The subscript exceeds the upper limit for a VARRAY array, or the subscript is a non-positive value of a VARRAY array or nested table.
Solution: Check the program logic and increase the upper limit for a VARRAY array if necessary.

ERROR 5844 (HY000): invalid cursor

Error code in OceanBase Database: 5844
Cause: The specified cursor is invalid.

ERROR 5845 (HY000): invalid username/password; logon denied

Error code in OceanBase Database: 5845
Cause: The username or password is invalid, and the login is denied.

ERROR 5846 (HY000): not logged on

Error code in OceanBase Database: 5846
Cause: You have not logged in.

ERROR 5847 (HY000): method dispatch on NULL SELF argument is disallowed

Error code in OceanBase Database: 5847
Cause: A MEMBER method is called by the NULL SELF argument.
Solution: Change the method call type to pass a valid SELF argument.

ERROR 5848 (HY000): timeout occurred while waiting for a resource

Error code in OceanBase Database: 5848
Cause: Dead instances exist.
Solution: Check whether dead or unrecovered instances exist. If yes, recover the instances.

ERROR 5849 (HY000): column to be modified to NOT NULL is already NOT NULL

Error code in OceanBase Database: 5849
Cause: The column to be set to NOT NULL already has the NOT NULL attribute.

ERROR 5850 (HY000): column to be modified to NULL cannot be modified to NULL

Error code in OceanBase Database: 5850
Cause: The column already allows NULL values, and the NOT NULL constraint is part of the primary key or CHECK constraint.
Solution: If the primary key or CHECK constraint forcibly enables the NOT NULL constraint, delete the constraint.

ERROR 5851 (HY000): cannot enable (%.s.%.s) - null values found

Error code in OceanBase Database: 5851
Cause: The operation to enable the constraint for the table failed because some values in the table do not meet the constraint.

ERROR 5852 (HY000): Argument should be a constant

Error code in OceanBase Database: 5852
Cause: The argument value is not a constant.

ERROR 5853 (HY000): not a single-group group function

Error code in OceanBase Database: 5853
Cause: A non-single-group group function is used.

ERROR 5854 (HY000): illegal zero-length identifier

Error code in OceanBase Database: 5854
Cause: The zero-length identifier is invalid.

ERROR 5855 (HY000): parameter cannot be modified because specified value is invalid

Error code in OceanBase Database: 5855
Cause: The initialization parameter can be modified, but the modified value is invalid.
Solution: Check the value range of the parameter in the OceanBase Database Reference Guide of the corresponding version.

ERROR 5856 (HY000): DBMS_SQL access denied

Error code in OceanBase Database: 5856
Cause: DBMS_SQL access is denied for security purposes.
Solution: Obtain more information from the alert logs and trace file.

ERROR 5857 (HY000): not all variables bound

Error code in OceanBase Database: 5857
Cause: Some variables are not configured.

ERROR 5859 (HY000): column is referenced in a multi-column constraint

Error code in OceanBase Database: 5859
Cause: The column to be deleted is referenced by a constraint.
Solution: Delete all constraints that reference the column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5860 (HY000): cannot modify column datatype with current constraint(s)

Error code in OceanBase Database: 5860
SQLSTATE: HY000
Cause: You are attempting to to modify the data type of the column constrained by the CHECK constraint. However, the data type of the column constrained by the CHECK constraint can be changed only from CHAR to VARCHAR.
Solution: Delete the constraint or do not perform the operation.

ERROR 5861 (HY000): The percentile value should be a number between 0 and 1

Error code in OceanBase Database: 5861
Cause: The percentile value specified for the PERCENTILE_CONT or PERCENTILE_DISC function is not within the valid range.
Solution: Specify a value within the range of [0,1].

ERROR 5862 (HY000): The argument should be of numeric or date/datetime type

Error code in OceanBase Database: 5862
Cause: The argument value must be a number or a date/datetime.

ERROR 5863 (HY000): ALTER TABLE|INDEX RENAME may not be combined with other operations

Error code in OceanBase Database: 5863
Cause: The ALTER TABLE or ALTER INDEX statement attempted to combine the RENAME operation with other operations, which is not allowed.
Solution: Make sure that the ALTER TABLE or ALTER INDEX statement contains only the RENAME operation.

ERROR 5864 (HY000): only simple column names allowed here

Error code in OceanBase Database: 5864
Cause: Only a simple column name is allowed.

ERROR 5866 (HY000): cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)

Error code in OceanBase Database: 5866
Cause: The request generates a default partition description (possibly by using PARTITIONS number-of-partitions) and specifies the <(sub)partition-description> clause, which is not allowed.
Solution: Delete one of the clauses.

ERROR 5867 (HY000): Duplicate partition name %.*s

Error code in OceanBase Database: 5867
Cause: The index name or the name of the subpartition created for the table or index is not unique.
Solution: Rename the subpartition to make sure that its name is unique among subpartitions created for the table or index.

ERROR 5868 (HY000): Incorrect usage of UPDATE and ORDER BY

Error code in OceanBase Database: 5868
Cause: The ORDER BY clause is not allowed in the UPDATE statement executed for multiple tables.
Solution: Remove the ORDER BY clause.

ERROR 5869 (HY000): Incorrect usage of UPDATE and LIMIT

Error code in OceanBase Database: 5869
Cause: The LIMIT clause is not allowed in the UPDATE statement executed for multiple tables.
Solution: Remove the LIMIT clause.

ERROR 5870 (HY000): rowid type mismatch, expect %.s, got %.s

Error code in OceanBase Database: 5870
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5871 (HY000): rowid num mismatch, expect %ld, actual %ld

Error code in OceanBase Database: 5871
Cause: This is an internal error code.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5872 (HY000): must name %.*s with a column alias

Error code in OceanBase Database: 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

Error code in OceanBase Database: 5873
Cause: When code in FX or FM format is specified for the input date, the number of digits must be exactly the same as that specified by the format code. For example, 9 does not match the format specifier DD, but 09 does.
Solution: Correct the input date or disable the specifier for the FX or FM format in the format string.

ERROR 5874 (HY000): invalid datatype

Error code in OceanBase Database: 5874
Cause: The data type is invalid.

ERROR 5875 (HY000): table is not partitioned by composite partition method

Error code in OceanBase Database: 5875
Cause: A subpartition maintenance operation is performed on a non-subpartitioned table.
Solution: Make sure that the table is a subpartitioned table.

ERROR 5876 (HY000): VALUES IN (<value list>) cannot be used for Range subpartitioned tables

Error code in OceanBase Database: 5876
Cause: The VALUES (value list) clause is used for RANGE-subpartitioned tables.
Solution: Use the VALUES LESS THAN or AT clause for RANGE-subpartitioned tables.

ERROR 5877 (HY000): VALUES IN (<value list>) clause expected

Error code in OceanBase Database: 5877
Cause: The VALUES (value list) clause is not specified for a LIST-subpartitioned table.
Solution: Specify the VALUES (value list) clause.

ERROR 5879 (HY000): Expecting VALUES LESS THAN or AT clause

Error code in OceanBase Database: 5879
Cause: The VALUES (value list) clause can be used only for LIST-partitioned tables.
Solution: Use the VALUES LESS THAN clause for RANGE-partitioned tables.

ERROR 5880 (HY000): procedure, function, package, or package body does not exist

Error code in OceanBase Database: 5880
Cause: The procedure, function, package, or package body to be accessed does not exist.
Solution: Make sure that the name of the object to be accessed is valid.

ERROR 5882 (HY000): invalid time limit specified

Error code in OceanBase Database: 5882
Cause: A non-positive value is specified for the time parameter of the dbms_lock.sleep(time) package.
Solution: Specify a positive value.

ERROR 5883 (HY000): ## ERROR(s) in array DML

Error code in OceanBase Database: 5883
Cause: The execution of one or more rows in the DML statement failed.
Solution: View the error stack during exception handling to identify the specific exception.

ERROR 5884 (42000): %s \'%.s.%.s\' compile error

Error code in OceanBase Database: 5884
Cause: The DDL statement used to create the trigger is invalid.
Solution: Modify the DDL statement as prompted and execute it again.

ERROR 5887 (HY000): missing or invalid password(s)

Error code in OceanBase Database: 5887
Cause: The password is incorrect.
Solution: Use the valid password and try again.

ERROR 5889 (HY000): no matching unique or primary key for this column-list

Error code in OceanBase Database: 5889
Cause: The REFERENCES clause in the CREATE TABLE or ALTER TABLE statement specifies a column list that does not match a unique constraint or primary key in the referenced table.
Solution: Query the ALL_CONS_COLUMNS view for the correct column name.

ERROR 5890 (HY000): duplicate referential constraint specifications

Error code in OceanBase Database: 5890
Cause: The table to be created contains multiple foreign key constraints with the same referencing and referenced columns.
Solution: Modify the CREATE TABLE statement to make sure that the table does not contain multiple foreign key constraints with the same referencing and referenced columns.

ERROR 5891 (HY000): such a referential constraint already exists in the table

Error code in OceanBase Database: 5891
Cause: The table to be modified contains multiple foreign key constraints with the same referencing and referenced columns.
Solution: Modify the ALTER TABLE statement to make sure that the table does not contain multiple foreign key constraints with the same referencing and referenced columns.

ERROR 5893 (HY000): specified data type is not supported for a virtual column

Error code in OceanBase Database: 5893
Cause: The data type of the generated column is LOB, which is not supported.
Solution: Modify the data type of the generated column.

ERROR 5894 (HY000): referenced table does not have a primary key

Error code in OceanBase Database: 5894
Cause: The foreign key table does not have a primary key because no referenced column is specified for the foreign key.
Solution: Before you create a foreign key, create a primary key or unique index for the referenced column.

ERROR 5895 (HY000): data type or length of a table partitioning column may not be changed

Error code in OceanBase Database: 5895
Cause: The data type and length of the partitioning column cannot be modified.

ERROR 5896 (HY000): data type or length of a table partitioning column may not be changed

Error code in OceanBase Database: 5896
Cause: The data type and length of the subpartitioning column cannot be modified.

ERROR 5897 (HY000): cannot decrease column length because some value is too big

Error code in OceanBase Database: 5897
Cause: The maximum length of a column cannot be decreased.

ERROR 5898 (HY000): Datetime/Interval internal error

Error code in OceanBase Database: 5898
Cause: An internal error occurred.
Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 5899 (HY000): partition extended table name cannot refer to a remote object

Error code in OceanBase Database: 5899
Cause: The extended partitioned table syntax is used to name a remote object.
Solution: Correct the expression and try again.

ERROR 5901 ( HY000 ): a view is not appropriate here

Error code in OceanBase Database: 5901
Cause: You are attempting to to define EDITIONING_VIEW in a view.
Solution: Create EDITIONING_VIEW in a base table.

ERROR 5902 (HY000): cannot select ROWID from,or sample, a join view without a key-preserved table

Error code in OceanBase Database: 5902
Cause: You cannot query ROWID from a join view or a sample without key-preserved table.

ERROR 5903 (HY000): cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc

Error code in OceanBase Database: 5903
Cause: The ROWID cannot be queried from a view with the DISTINCT or GROUP BY clause.

ERROR 5904 (HY000): table must have at least 1 column that is not virtual

Error code in OceanBase Database: 5904
Cause: You are attempting to create a table with only virtual columns.
Solution: Make sure that the table to be created contains at least one non-virtual column.

ERROR 5905 (HY000): only pure functions can be indexed

Error code in OceanBase Database: 5905
Cause: The SYSDATE or user environment is used in the index function.
Solution: Make sure that the PL function is a pure function, such as RNDS, RNPS, WNDS, or WNPS.

ERROR 5906 (HY000): only pure functions can be specified in a virtual column expression

Error code in OceanBase Database: 5906
Cause: The virtual column expression contains a function whose evaluation is non-deterministic.
Solution: Rewrite the column expression to reference only pure functions.

ERROR 5907 (HY000): UPDATE operation disallowed on virtual columns

Error code in OceanBase Database: 5907
Cause: You are attempting to update values of a virtual column.
Solution: Re-execute the statement without setting values for virtual columns.

ERROR 5908 (HY000): Invalid column expression was specified

Error code in OceanBase Database: 5908
Cause: The virtual column expression is not a valid arithmetic expression. It probably refers to another column in the table.
Solution: Modify the expression of the virtual column.

ERROR 5909 (HY000): table can have only one identity column

Error code in OceanBase Database: 5909
Cause: You are attempting to specify multiple identity columns for a table.
Solution: Specify only one identity column for each table.

ERROR 5910 (HY000): invalid NOT NULL constraint specified on an identity column

Error code in OceanBase Database: 5910
Cause: The NOT NULL constraint is not properly specified on the identity column.
Solution: If the NOT NULL constraint is specified for the identity column, enable the constraint, which must be non-deferrable.

ERROR 5911 (HY000): cannot modify NOT NULL constraint on an identity column

Error code in OceanBase Database: 5911
Cause: The NOT NULL constraint on the identity column cannot be modified.
Solution: Do not modify the NOT NULL constraint on an identity column.

ERROR 5912 (HY000): cannot drop NOT NULL constraint on an identity column

Error code in OceanBase Database: 5912
Cause: The NOT NULL constraint on the identity column cannot be deleted.
Solution: Do not delete the NOT NULL constraint from the identity column. To delete the constraint, call the DROP IDENTITY operation in the ALTER TABLE MODIFY statement to delete the identity attribute of the column.

ERROR 5913 (HY000): column to be modified is not an identity column

Error code in OceanBase Database: 5913
Cause: You are attempting to modify the identity attribute of a non-identity column.
Solution: Modify the identity attribute of only an identity column.

ERROR 5914 (HY000): identity column cannot have a default value

Error code in OceanBase Database: 5914
Cause: You are attempting to add a default value to an identity column.
Solution: Do not specify a default value for an identity column.

ERROR 5915 (HY000): identity column must be a numeric type

Error code in OceanBase Database: 5915
Cause: You are attempting to create non-numeric values for an identity column or change the values of an identity column into non-numeric values.
Solution: Do not assign a non-numeric data type to an identity column.

ERROR 5916 (HY000): prebuilt table managed column cannot be an identity column

Error code in OceanBase Database: 5916
Cause: You are attempting to create an instantiated view on a pre-built table with an identity column.
Solution: Delete the identity attribute or delete the identity column from the instantiated view.

ERROR 5917 (HY000): cannot alter a system-generated sequence

Error code in OceanBase Database: 5917
Cause: You are attempting to to modify a system-generated sequence.
Solution: Do not modify sequences generated by the system, such as a sequence created for the identity column.

ERROR 5918 (HY000): cannot drop a system-generated sequence

Error code in OceanBase Database: 5918
Cause: You are attempting to to drop a system-generated sequence.
Solution: Do not drop sequences generated by the system, for example, a sequence created for the identity column.

ERROR 5919 (HY000): cannot insert into a generated always identity column

Error code in OceanBase Database: 5919
Cause: You are attempting to insert a value into an identity column created by using the GENERATED ALWAYS keyword.
Solution: Do not directly insert a value into an identity column that is created by using the GENERATED ALWAYS keyword. Instead, the value should be provided by the associated sequence generator.

ERROR 5920 (HY000): cannot update a generated always identity column

Error code in OceanBase Database: 5920
Cause: You are attempting to update an identity column created by using the GENERATED ALWAYS keyword.
Solution: Do not directly update an identity column that is created by using the GENERATED ALWAYS keyword.

ERROR 5921 (HY000): identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION

Error code in OceanBase Database: 5921
Cause: Sequences of identity columns of two tables specified in the EXCHANGE statement are neither incremented nor decremented.
Solution: Make sure that the sequences of the identity columns with INCREMENT BY have the same symbol.

ERROR 5922 (HY000): cannot rename a system-generated sequence

Error code in OceanBase Database: 5922
Cause: You are attempting to rename a system-generated sequence.
Solution: Do not rename sequences generated by the system, such as a sequence created for the identity column.

ERROR 5923 (HY000): UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

Error code in OceanBase Database: 5923
Cause: The UPDATE or REFERENCES operation can be revoked only from the entire table but not by column.

ERROR 5924 (HY000): not executed, type body '%.*s' does not exist

Error code in OceanBase Database: 5924
Cause: The stored procedure to be executed does not exist.
Solution: Make sure that the procedure name is correct.

ERROR 5925 (HY000): The argument [%s] of WIDTH_BUCKET function is NULL or invalid

Error code in OceanBase Database: 5925
Cause: The [%s] argument of the WIDTH_BUCKET function is NULL or invalid.

ERROR 5926 (HY000): Not enough memory for CONNECT BY operation

Error code in OceanBase Database: 5926
Cause: On an engine of the current version, an error is returned if the recursion depth exceeds 2^30. On an engine of an earlier version, an error is returned if the total number of nodes on the path from the root node to the current node, including the subnodes, exceeds a specific value (2^30). The current recursion depth limit is fixed and suitable in general cases.
Solution: No solution is available now. The issue cannot be resolved by simply increasing the memory size. However, you can reduce the recursion levels or the data amount to work around this issue.

ERROR 5927 (HY000): illegal parameter in SYS_CONNECT_BY_PATH function

Error code in OceanBase Database: 5927
Cause: The SYS_CONNECT_BY_PATH function contains invalid arguments.

ERROR 5928 (HY000): host %.*s unknown

Error code in OceanBase Database: 5928
Cause: The specified host is unknown.
Solution: Check the spelling of the host name or the IP address, and ensure that the host name and the IP address are valid.

ERROR 5929 (HY000): Window name '%.*s' is not defined

Error code in OceanBase Database: 5929
Cause: The specified analytic function does not exist.
Solution: Make sure that the analytic function has been created and the name of the analytic function is correct.

ERROR 5930 (HY000): maximum open cursors exceeded

Error code in OceanBase Database: 5930
Cause: The number of opened cursors in the system exceeds the upper limit.
Solution: Close cursors or modify the open_cursors parameter.

ERROR 5931 (HY000): argument is null, invalid, or out of range

Error code in OceanBase Database: 5931
Cause: The passed argument value is NULL, invalid, or out of range. For example, the value of the location or size parameter of LOB/FILE data is beyond the range of 1 to (4 GB - 1), or a file is opened in an invalid opening mode.
Solution: Check and correct the program to avoid passing NULL, invalid, or out-of-range parameter values.

ERROR 5932 (HY000): unexpected name string

Error code in OceanBase Database: 5932
Cause: The name string is invalid.

ERROR 5933 (HY000): PL/SQL: could not findprogram unit being called: '%.*s'

Error code in OceanBase Database: 5933
Cause: The program unit is not found.

ERROR 5934 (HY000): fetch out of sequence

Error code in OceanBase Database: 5934
SQLSTATE: HY000
Cause: You are attempting to to fetch data from an invalid cursor. Possible causes:
- The data is fetched from the cursor after the retrieval reaches the last line and the OBE-1403 error is returned.
- The FOR UPDATE clause is used to open the cursor, and then the data is fetched after the COMMIT statement is issued.
- All placeholders in the SQL statement are re-bound, and the data is fetched before the statement is re-executed.
Note

This error can also occur if a PL cursor is circularly and implicitly fetched.
Solution:
- Do not issue the FETCH statement after the retrieval reaches the last line.
- After you use the FOR UPDATE clause to open the cursor, do not fetch the data after you issue the COMMIT statement.
- Bind placeholders again, execute the SQL statement, and then fetch the data.

ERROR 5959 (HY000): invalid SIZE specified

Error code in OceanBase Database: 5959
Cause: The SIZE value specified for the histogram is out of the range.
Solution: Specify a SIZE value within the range of [1,2048].

ERROR 5975 (HY000): \ndblink remote error code: %d,\nremote error msg: %.*s"

Error code in OceanBase Database: 5975
Cause: An error occurred while connecting to the remote database, and the returned error code cannot be mapped to the compatible error code in OceanBase Database.
Solution: Locate the cause based on the error code in the error message.

ERROR 5976 (HY000): can not find the expected version of OCI LIB: %.*s

Error code in OceanBase Database: 5976
Cause: The Oracle Call Interface (OCI) library of the expected version was not found.
Solution: For more information, see Install and configure OCI.

Note

The error message for this error code is changed from oci lib not founded to can not find the expected version of OCI LIB: %.*s since OceanBase Database V4.3.0.

Previous topic

4500 to 4999

Last

Next topic

6000 to 6999

Customer Stories

Documentation

5000 to 5999

ERROR 5002 (HY000): Resolve error

ERROR 5010 (21000): Unknown operator

ERROR 5011 (42000): Duplicated star

ERROR 5012 (HY000): Illegal ID

ERROR 5014 (HY000): Illegal value

ERROR 5016 (HY000): Generate logical plan error

ERROR 5017 (HY000): Schema not set

ERROR 5023 (S1004): unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date

ERROR 5031 (HY000): Column not found

ERROR 5034 (01007): No user

ERROR 5050 (42710): User exists

ERROR 5053 (HY093): Incorrect arguments number to EXECUTE, need %ld arguments but give %ld

ERROR 5058 (42000): Duplicated parameters

ERROR 5063 (42000): Unknown hint

ERROR 5066 (HY000): Session interrupted

ERROR 5071 (42000): Cannot alter index column

ERROR 5074 (23000): NOP cannot be used here

ERROR 5081 (25000): The server is read only now

ERROR 5083 (22000): invalid obj type for type promotion: left_type=%s right_type=%s

ERROR 5084 (22000): Can not cast varchar value to bool type

ERROR 5085 (22000): Not a number Can not cast varchar value to number type

ERROR 5086 (22000): Not timestamp Can not cast varchar value to timestamp type

ERROR 5087 (22000): Result value was out of range when cast to number

ERROR 5090 (22000): Precision was out of range

ERROR 5091 (22000): Scale value was out of range

ERROR 5092 (42000): Unknown index

ERROR 5098 (22001): Data too long(%d>%ld) for column '%s'

ERROR 5099 (42000): System config unknown

ERROR 5106 (42000): EXTRACT() expected timestamp or a string as date argument

ERROR 5107 (42000): Invalid operand type for IS operator, lval=%s

ERROR 5108 (42000): function LENGTH() expected a varchar argument

ERROR 5110 (42000): TIME_TO_USEC() expected timestamp or a string as date argument

ERROR 5111 (42000): USEC_TO_TIME expected a interger number as usec argument

ERROR 5112 (42P01): Variable %.*s does not exists

ERROR 5114 (42000): Invalid numeric char '%c'

ERROR 5116 (HY000): Logical operator child index overflow

ERROR 5117 (HY000): fail to explain plan

ERROR 5118 (HY000): fail to copy logical operator

ERROR 5119 (HY000): fail to generate plan

ERROR 5120 (HY000): fail to create raw expr

ERROR 5121 (HY000): fail to generate join order

ERROR 5122 (HY000): optimizer general error

ERROR 5130 (HY000): sql resolver no memory

ERROR 5131 (HY000): plan cache support dml only

ERROR 5133 (42000): No such grant defined

ERROR 5136 (HY000): plan exists in plan cache already

ERROR 5137 (HY000): plan is expired

ERROR 5138 (HY000): no plan exist

ERROR 5144 (HY000): COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'

ERROR 5150 (HY000): Tenant not in this server

ERROR 5151 (42P01): tablegroup not exist

ERROR 5156 (HY000): tenant \'%s\' already exist

ERROR 5157 (HY000): Unknown tenant '%.*s'

ERROR 5159 (HY000): tablegroup already exist

ERROR 5160 (HY000): invalid tenant name specified in connection string

ERROR 5212 (42000): auto-increment column '%.*s' should not be part of partition key

ERROR 5223 (42000): wrong ident name

ERROR 5226 (42000): plan cache memory used reach the high water mark

ERROR 5234 (HY000): The database \'%.*s\' is read only so it cannot execute this statement

ERROR 5235 (HY000): The table \'%.*s.%.*s\' is read only so it cannot execute this statement

ERROR 5243 (HY000): system variables' version maybe different

ERROR 5245 (HY000): some tasks are skipped, skipped server addr is '%s', the orginal error code is %d

ERROR 5248 (HY000): Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'

ERROR 5252 (HY000): Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes

ERROR 5258 (HY000): Invalid block size, block size should between 1024 and 1048576

ERROR 5260 (HY000): Tenant \'%.*s\' is locked

ERROR 5264 (HY000): Outline '%.*s' already exists

ERROR 5265 (HY000): Outline \'%.*s.%.*s\' doesn\'t exist

ERROR 5267 (HY000): invalid outline ,error info:%s

ERROR 5268 (HY000): SQL reach max concurrent num %ld

ERROR 5269 (HY000): can not perform DDL/DML over objects in Recycle Bin

ERROR 5270 (HY000): object not in RECYCLE BIN

ERROR 5272 (HY000): Outline content '%.*s' of outline '%.*s' already exists when added

ERROR 5273 (HY000): Max concurrent in outline '%.*s' already exists when added

ERROR 5278 (HY000): This partition value with incorrect charset type

ERROR 5291 (HY000): The CTXCAT column must be contiguous in the index column list

ERROR 5296 (42000): there has no readable replica

ERROR 5144 (HY000): COLLATION '%.s' is notvalid for CHARACTER SET '%.s'

ERROR 5235 (HY000): The table \'%.s.%.s\' is read only so it cannot execute this statement

ERROR 5265 (HY000): Outline \'%.s.%.s\' doesn\'t exist

ERROR 5272 (HY000): Outline content '%.s' of outline '%.s' already exists when added

ERROR 5299 (HY000): synonym \'%.s.%.s\' doesn\'t exist

ERROR 5319 (HY000): Child column \'%.s\' data length cannot be less than parent column \'%.s\' data length

ERROR 5371 (HY000): grant option does not exist for '%.s.%.s'

ERROR 5379 (HY000): ROLE '%.s' not granted to '%.s'