These error codes are compatible with specific MySQL error codes.
ERROR 1007 (HY000): Can't create database '%s'; database exists
OceanBase error code: 5158
MySQL error code: 1007
ERROR 1008 (HY000): Can't drop database '%.*s'; database doesn't exist
OceanBase error code: 5166
MySQL error code: 1008
ERROR 1017 (HY000): File not exist
OceanBase error code: 4027
MySQL error code: 1017
ERROR 1018 (HY000): Directory not exist
OceanBase error code: 4066
MySQL error code: 1018
ERROR 1022 (23000): Can't write; duplicate key in table \'%.*s\'
OceanBase error code: 5595
MySQL error code: 1022
ERROR 1025 (HY000): ## ERROR on rename of \'%s.%s\' to \'%s.%s\'
OceanBase error code: 5215
MySQL error code: 1025
ERROR 1040 (08004): Too many connections
OceanBase error code: 5271
MySQL error code: 1040
ERROR 1041 (53000): Out of resource
OceanBase error code: 4153
MySQL error code: 1041
ERROR 1044 (42000): Access denied for user '%.*s'@'%.*s' to database '%.*s'
OceanBase error code: 5170
MySQL error code: 1044
ERROR 1045 (42000): Access denied for user '%.*s'@'%.*s' (using password: %s)
OceanBase error code: 4043
MySQL error code: 1045
ERROR 1046 (3D000 ): No database selected
OceanBase error code: 5134
MySQL error code: 1046
ERROR 1047 (HY001): Unknown packet
OceanBase error code: 4118
MySQL error code: 1047
ERROR 1048 (23000): Column '%.*s' cannot be null
OceanBase error code: 4235
MySQL error code: 1048
ERROR 1049 (42000): Unknown database '%.*s'
OceanBase error code: 5154
MySQL error code: 1049
ERROR 1050 (42S01): Table '%.*s' already exists
OceanBase error code: 5020
MySQL error code: 1050
ERROR 1051 (42S02): Unknown table '%.*s'
OceanBase error code: 5201
MySQL error code: 1051
ERROR 1052 (23000): Column '%.*s' in %.*s is ambiguous
OceanBase error code: 5207
MySQL error code: 1052
ERROR 1054 (42S22): Unknown column '%.*s' in '%.*s'
OceanBase error code: 5217
MySQL error code: 1054
ERROR 1055 (42000): \'%.*s\' is not in GROUP BY
OceanBase error code: 5218
MySQL error code: 1055
ERROR 1056 (42000): Can't group on '%.*s'
OceanBase error code: 5206
MySQL error code: 1056
ERROR 1059 (42000): Identifier name \'%.*s\' is too long
OceanBase error code: 5179 and 9526
MySQL error code: 1059
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 1060 (42S21): Duplicate column group name '%.*s'
OceanBase error code: 5404
MySQL error code: 1060
ERROR 1061 (42000): Duplicate key name \'%.*s\'
OceanBase error code: 5025
MySQL error code: 1061
ERROR 1062 (23000): Duplicate entry \'%s\' for key \'%.*s\'
OceanBase error code: 5024
MySQL error code: 1062
ERROR 1063 (42000): Incorrect column specifier for column '%.*s'
OceanBase error code: 5165
MySQL error code: 1063
ERROR 1064 (0B000): Failed to init SQL parser
OceanBase error code: 5000
MySQL error code: 1064
ERROR 1064 (42000): Parse error", "%s near \'%.*s\' at line %d
OceanBase error code: 5001
MySQL error code: 1064
ERROR 1064 (42000): Wrong number of partitions defined, mismatch with previous setting
OceanBase error code: 5282
MySQL error code: 1064
ERROR 1065 (42000): Query was empty
OceanBase error code: 5253
MySQL error code: 1065
ERROR 1066 (42000): Not unique table/alias: \'%.*s\'
OceanBase error code: 5208
MySQL error code: 1066
ERROR 1067 (42000): Invalid default value for \'%.*s\'
OceanBase error code: 5173
MySQL error code: 1067
ERROR 1068 (42000): Multiple primary key defined
OceanBase error code: 5210
MySQL error code: 1068
ERROR 1069 (42000): Too many keys specified; max %ld keys allowed
OceanBase error code: 5194
MySQL error code: 1069
ERROR 1070 (42000): Too many key parts specified; max %ld parts allowed
OceanBase error code: 5195
MySQL error code: 1070
ERROR 1071 (42000): Specified key was too long; max key length is %ld bytes
OceanBase error code: 5196
MySQL error code: 1071
ERROR 1072 (42000): Key column '%.*s' doesn't exist in table
OceanBase error code: 5211
MySQL error code: 1072
ERROR 1074 (42000): Column length too big for column '%s' (max = %d)
OceanBase error code: 5198
MySQL error code: 1074
ERROR 1074 (42000): Column length too big for column '%.*s' (max = %d); use BLOB or TEXT instead
OceanBase error code: 9577
MySQL error code: 1074
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column
OceanBase error code: 5193
MySQL error code: 1075
ERROR 1078 (01000): (string):%s: Got signal %d. Aborting
OceanBase error code: 4662
MySQL error code: 1078
ERROR 1082 (42S12): Illegal index
OceanBase error code: 5028
MySQL error code: 1082
ERROR 1082 (42000): Index unavailable
OceanBase error code: 5073
MySQL error code: 1082
ERROR 1083 (42000): Field separator argument is not what is expected; check the manual
OceanBase error code: 5295
MySQL error code: 1083
ERROR 1083 (HY000): Non-ASCII separator arguments are not fully supported
OceanBase error code: 5609
MySQL error code: 1083
ERROR 1083 (HY000): First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
OceanBase error code: 5610
MySQL error code: 1083
ERROR 1086 (58000): File already exist
OceanBase error code: 4117
MySQL error code: 1086
ERROR 1089 (HY000): Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
OceanBase error code: 5190
MySQL error code: 1089
ERROR 1090 (42000): You can't delete all columns with ALTER TABLE; use DROP TABLE instead
OceanBase error code: 5187
MySQL error code: 1090
ERROR 1091 (42000): Can't DROP '%.*s'; check that column/key exists
OceanBase error code: 5209
MySQL error code: 1091
ERROR 1093 (HY000): You can\'t specify target table \'%s\' for update in FROM clause
OceanBase error code: 5174
MySQL error code: 1093
ERROR 1094 (HY000): Unknown thread id: %lu
OceanBase error code: 4174
MySQL error code: 1094
ERROR 1095 (HY000): You are not owner of thread %lu
OceanBase error code: 5251
MySQL error code: 1095
ERROR 1096 (HY000): No tables used
OceanBase error code: 5185
MySQL error code: 1096
ERROR 1097 (HY000): Too many strings for column %.*s and SET
OceanBase error code: 5336
MySQL error code: 1097
ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column '%.*s' can't have a default value
OceanBase error code: 5430
MySQL error code: 1101
ERROR 1102 (42000): Incorrect database name '%.*s'
OceanBase error code: 5162
MySQL error code: 1102
ERROR 1103 (42000): Incorrect table name '%.*s'
OceanBase error code: 5163
MySQL error code: 1103
ERROR 1108 (HY000): Incorrect parameters to procedure '%.*s'
OceanBase error code: 5406
MySQL error code: 1108
ERROR 1109 (42S02): Unknown table '%.*s' in %.*s
OceanBase error code: 5200
MySQL error code: 1109
ERROR 1110 (42000): Column \'%s\' specified twice
OceanBase error code: 4228
MySQL error code: 1110
ERROR 1111 (HY000): Invalid use of group function
OceanBase error code: 5176
MySQL error code: 1111
ERROR 1113 (42000): A table must have at least 1 column
OceanBase error code: 5904
MySQL error code: 1113
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1115 (42000): Unknown character set: '%.*s'
OceanBase error code: 5142
MySQL error code: 1115
ERROR 1117 (42000): Too many columns
OceanBase error code: 5197
MySQL error code: 1117
ERROR 1118 (42000): Row size too large
OceanBase error code: 5199
MySQL error code: 1118
ERROR 1122 (HY000): Can not load function %s
OceanBase error code: 4291
MySQL error code: 1122
ERROR 1123 (HY000): Can not initialize function '%.*s'
OceanBase error code: 4292
MySQL error code: 1123
ERROR 1124 (HY000): No paths allowed for shared library
OceanBase error code: 4293
MySQL error code: 1124
ERROR 1125 (HY000): Function %.*s already exists
OceanBase error code: 4294
MySQL error code: 1125
ERROR 1126 (HY000): Can not open shared library '%.*s'
OceanBase error code: 4295
MySQL error code: 1126
ERROR 1127 (HY000): Can't find symbol %.*s in library
OceanBase error code: 4296
MySQL error code: 1127
ERROR 1133 (42000): Can not find any matching row in the user table'%.*s'
OceanBase error code: 4042
MySQL error code: 1133
ERROR 1133 (42000): Incorrect password
OceanBase error code: 5038
MySQL error code: 1133
ERROR 1136 (21S01): column count does not match value count at row '%d'
OceanBase error code: 5168
MySQL error code: 1136
ERROR 1136 (21S01): Column count doesn\'t match value count at row %ld
OceanBase error code: 5175
MySQL error code: 1136
ERROR 1138 (22004): Invalid use of NULL value
OceanBase error code: 5596
MySQL error code: 1138
ERROR 1139 (42000): Got error '%s' from regexp
OceanBase error code: 5115
MySQL error code: 1139
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
OceanBase error code: 5221
MySQL error code: 1140
ERROR 1142 (42000): %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'
OceanBase error code: 5171
MySQL error code: 1142
ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
OceanBase error code: 5183
MySQL error code: 1144
ERROR 1146 (42S02): Table \'%s.%s\' doesn\'t exist
OceanBase error code: 5019
MySQL error code: 1146
ERROR 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use
OceanBase error code: 5006
MySQL error code: 1149
ERROR 1153 (08S01): Got a packet bigger than \'max_allowed_packet\' bytes"
OceanBase error code: 4254
MySQL error code: 1153
ERROR 1166 (42000): Incorrect column name '%.*s'
OceanBase error code: 5164
MySQL error code: 1166
ERROR 1167 (42000): The used storage engine can't index column '%.*s'
OceanBase error code: 5216
MySQL error code: 1167
ERROR 1171 (42000): Insert null into %.*s
OceanBase error code: 5030
MySQL error code: 1171
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
OceanBase error code: 5256
MySQL error code: 1171
ERROR 1172 (42000): Result consisted of more than one row
OceanBase error code: 5294
MySQL error code: 1172
ERROR 1173 (42000): Primary key columns) not specified in the WHERE clause
OceanBase error code: 5047
MySQL error code: 1173
ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
OceanBase error code: 5865
MySQL error code: 1175
ERROR 1176 (42000): Key '%.*s' doesn't exist in table '%.*s'
OceanBase error code: 5289
MySQL error code: 1176
ERROR 1192 (HY000): Can't execute the given command because you have active locked tables or an active transaction
OceanBase error code: 5236
MySQL error code: 1192
ERROR 1193 (HY000): Unknown system variable '%.*s'
OceanBase error code: 5044
MySQL error code: 1193
ERROR 1203 (42000): Too many sessions
OceanBase error code: 5059
MySQL error code: 1203
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
OceanBase error code: 6003
MySQL error code: 1205
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
OceanBase error code: 6006
MySQL error code: 1205
ERROR 1210 (HY000): Incorrect arguments to %s
OceanBase error code: 4002
MySQL error code: 1210
ERROR 1210 (HY000): Miss argument for %s
OceanBase error code: 4272
MySQL error code: 1210
ERROR 1210 (HY000): Miss argument for %s
OceanBase error code: 4277
MySQL error code: 1210
ERROR 1213 (HY000): Deadlock
OceanBase error code: 4101
MySQL error code: 1213
ERROR 1215 (HY000): Cannot add foreign key constraint
OceanBase error code: 5317
MySQL error code: 1215
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
OceanBase error code: 5182
MySQL error code: 1221
ERROR 1221 (HY000): Incorrect usage of UNION and INTO
OceanBase error code: 9641
MySQL error code: 1221
ERROR 1222 (21000): The used SELECT statements have a different number of columns
OceanBase error code: 5007
MySQL error code: 1222
ERROR 1225 (HY000): Option '%s' used twice in statement
OceanBase error code: 4299
MySQL error code: 1225
ERROR 1226 (42000): User '%.*s' has exceeded the '%s' resource (current value: %lu)
OceanBase error code: 5967
MySQL error code: 1226
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1227 (42501): Access denied; you need (at least one of) the %s privilege(s) for this operation
OceanBase error code: 5036
MySQL error code: 1227
ERROR 1228 (HY000): Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL
OceanBase error code: 5100
MySQL error code: 1228
ERROR 1229 (HY000): Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL
OceanBase error code: 5101
MySQL error code: 1229
ERROR 1230 (42000): Variable '%.*s' doesn't have a default value
OceanBase error code: 4256
MySQL error code: 1230
ERROR 1231 (42000 ): Variable \'%.*s\' can't be set to the value of \'%.*s\'
OceanBase error code: 5145
MySQL error code: 1231
ERROR 1232 (42000): Incorrect argument type to variable '%.*s'
OceanBase error code: 5180
MySQL error code: 1232
ERROR 1234 (42000): Incorrect usage/placement of '%s'
OceanBase error code: 5213
MySQL error code: 1234
ERROR 1235 (0A000): %s not supported
OceanBase error code: 4007
MySQL error code: 1235
ERROR 1235 (42000): This version of OceanBase doesn't yet support 'multiple triggers with the same action time and event for one table'
OceanBase error code: 9581
MySQL error code: 1235
ERROR 1238 (HY000): Variable '%.*s' is a %.*s variable
OceanBase error code: 5103
MySQL error code: 1238
ERROR 1239 (42000): Incorrect foreign key definition: Key reference and table reference don't match
OceanBase error code: 5318
MySQL error code: 1239
ERROR 1241 (21000): Operand should contain %ld column(s)
OceanBase error code: 5042
MySQL error code: 1241
ERROR 1243 (HY007): statement not prepared, stmt_id=%u
OceanBase error code: 5043
MySQL error code: 1243
ERROR 1242 (21000): Subquery returns more than 1 row
OceanBase error code: 5153
MySQL error code: 1242
ERROR 1243 (HY000): Unknown prepared statement handle
OceanBase error code: 5560
MySQL error code: 1243
ERROR 1247 (42S22): Reference '%.*s' not supported (reference to group function)
OceanBase error code: 5225
MySQL error code: 1247
ERROR 1250 (42000): Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause
OceanBase error code: 5238
MySQL error code: 1250
ERROR 1252 (7280): All parts of a SPATIAL index must be NOT NULL.
OceanBase error code: 5238
MySQL error code: 1252
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 1253 (42000): COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'
OceanBase error code: 5144
MySQL error code: 1253
ERROR 1259 (HY000): ZLIB: Input data corrupted
OceanBase error code: 5124
MySQL error code: 1259
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1260 (42000): Row %ld was cut by GROUP_CONCAT()
OceanBase error code: 5254
MySQL error code: 1260
ERROR 1261 (1000): Row %ld doesn't contain data for all columns
OceanBase error code: 5611
MySQL error code: 1261
ERROR 1262 (1000): Row %ld was truncated; it contained more data than there were input columns
OceanBase error code: 5612
MySQL error code: 1262
ERROR 1264 (22003): Out of range value for column '%.*s' at row %ld
OceanBase error code: 4224
MySQL error code: 1264
ERROR 1264 (22003): value larger than specified precision(%ld,%ld) allowed for this column
OceanBase error code: 5088
MySQL error code: 1264
ERROR 1264 (22003): value(%s) larger than specified precision(%ld,%ld) allowed for this column
OceanBase error code: 5089
MySQL error code: 1264
ERROR 1264 (22003): Result value was out of range when casting varchar to number
OceanBase error code: 5093
MySQL error code: 1264
ERROR 1264 (22003): Out of range value for column '%.*s' at row %ld
OceanBase error code: 5229
MySQL error code: 1264
ERROR 1265 (01000): Data truncated for column '%.*s' at row %ld
OceanBase error code: 4249
MySQL error code: 1265
ERROR 1265 (01000): Timeout value truncated to 102 years
OceanBase error code: 4252
MySQL error code: 1265
ERROR 1267 (HY000): Illegal mix of collations
OceanBase error code: 5177
MySQL error code: 1267
ERROR 1273 (HY000): Unknown collation: '%.*s'
OceanBase error code: 5143
MySQL error code: 1273
ERROR 1280 (42000): Incorrect index name '%.*s'
OceanBase error code: 5224
MySQL error code: 1280
ERROR 1283 (HY000): Column '%.*s' cannot be part of FULLTEXT index
OceanBase error code: 5288
MySQL error code: 1283
ERROR 1286 (42000): Unknown storage engine \'%.*s\'
OceanBase error code: 5259
MySQL error code: 1286
ERROR 1288 (HY000): The target table %.*s of the %.*s is not updatable
OceanBase error code: 5228
MySQL error code: 1288
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement
OceanBase error code: 5233
MySQL error code: 1290
ERROR 1291 (HY000): Column '%.*s' has duplicated value '%.*s' in %s
OceanBase error code: 5334
MySQL error code: 1291
ERROR 1292 (22007): %s=%d must between %d and %d
OceanBase error code: 4158
MySQL error code: 1292
ERROR 1292 (22007): Incorrect value
OceanBase error code: 4190
MySQL error code: 1292
ERROR 1292 (01000): Truncated incorrect DOUBLE value: '%.*s'
OceanBase error code: 4262
MySQL error code: 1292
ERROR 1292 (22007): Incorrect datetime value: '%.*s' for column '%s'
OceanBase error code: 4219
MySQL error code: 1292
ERROR 1292 (22007): Truncated incorrect %.*s value: '%.*s'
OceanBase error code: 5222
MySQL error code: 1292
ERROR 1294 (HY000): Invalid ON UPDATE clause for \'%s\' column
OceanBase error code: 5172
MySQL error code: 1294
ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet
OceanBase error code: 5568
MySQL error code: 1295
ERROR 1298 (HY000): Unknown or incorrect time zone: \'%.*s\'
OceanBase error code: 5192
MySQL error code: 1298
ERROR 1300 (HY000): Invalid %.*s character string: \'%.*s\'
OceanBase error code: 5250
MySQL error code: 1300
ERROR 1301 (HY000): Result of %s() was larger than max_allowed_packet (%d) truncated
OceanBase error code: 5316
MySQL error code: 1301
ERROR 1302 (42000): Conflicting declarations: '%s' and '%s'
OceanBase error code: 5858
MySQL error code: 1302
ERROR 1303 (2F003): Cant create a routine from within another routine
OceanBase error code: 5582
MySQL error code: 1303
ERROR 1304 (42000): %s %.*s already exists
OceanBase error code: 5541
MySQL error code: 1304
ERROR 1305 (42000): %s %.*s does not exist
OceanBase error code: 5055
MySQL error code: 1305
ERROR 1305 (42000): %s %.*s.%.*s does not exist
OceanBase error code: 5542
MySQL error code: 1305
ERROR 1305 (42000): savepoint does not exist
OceanBase error code: 6242
MySQL error code: 1305
ERROR 1308 (42000): no matching label: %.*s
OceanBase error code: 5546 and 9505
MySQL error code: 1308
ERROR 1308 (42000): %s with no matching label: %s
OceanBase error code: 5593
MySQL error code: 1308
ERROR 1309 (42000): Redefining label '%.*s'
OceanBase error code: 9579
MySQL error code: 1309
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1313 (42000): RETURN is only allowed in a FUNCTION
OceanBase error code: 5583
MySQL error code: 1313
ERROR 1314 (HY000): '%.*s' is not allowed in stored procedure
OceanBase error code: 9580
MySQL error code: 1314
ERROR 1317 (70100): Query execution was interrupted
OceanBase error code: 5065
MySQL error code: 1317
ERROR 1318 (42000): Incorrect number of arguments for %s %s; expected %u, got %u
OceanBase error code: 5555
MySQL error code: 1318
ERROR 1319 (42000): Undefined CONDITION: %.*s
OceanBase error code: 5545
MySQL error code: 1319
ERROR 1320 (42000): No Return found in FUNCTION '%.*s'
OceanBase error code: 9575
MySQL error code: 1320
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1321 (2F005): FUNCTION %s ended without RETURN
OceanBase error code: 5580
MySQL error code: 1321
ERROR 1323 (42000): Cursor SELECT must not have INTO
OceanBase error code: 5584
MySQL error code: 1323
ERROR 1324 (42000): Undefined CURSOR: %.*s
OceanBase error code: 5547
MySQL error code: 1324
ERROR 1325 (24000): Cursor is already open
OceanBase error code: 5589
MySQL error code: 1325
ERROR 1326 (24000): Cursor is not open
OceanBase error code: 5590
MySQL error code: 1326
ERROR 1327 (42000): Undeclared variable: %.*s
OceanBase error code: 5543
MySQL error code: 1327
ERROR 1327 (42000): Undeclared type: %.*s
OceanBase error code: 5544
MySQL error code: 1327
ERROR 1328 (HY000): Incorrect number of FETCH variables
OceanBase error code: 5554
MySQL error code: 1328
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
OceanBase error code: 4026
MySQL error code: 1329
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1330 (42000): Duplicate parameter: %.*s
OceanBase error code: 5548
MySQL error code: 1330
ERROR 1330 (42000): Duplicate type: %.*s
OceanBase error code: 5550
MySQL error code: 1330
ERROR 1330 (42000): Duplicate label: %.*s
OceanBase error code: 5552
MySQL error code: 1330
ERROR 1331 (42000): Duplicate variable: %.*s
OceanBase error code: 5549
MySQL error code: 1331
ERROR 1332 (42000): Duplicate condition: %.*s
OceanBase error code: 5551
MySQL error code: 1332
ERROR 1333 (42000): Duplicate cursor: %.*s
OceanBase error code: 5553
MySQL error code: 1333
ERROR 1336 (0A000): %s is not allowed in stored function or trigger
OceanBase error code: 5569
MySQL error code: 1336
ERROR 1337 (42000): Variable or condition declaration after cursor or handler declaration
OceanBase error code: 5586
MySQL error code: 1337
ERROR 1338 (42000): Cursor declaration after handler declaration
OceanBase error code: 5587
MySQL error code: 1338
ERROR 1339 (20000): Case not found for CASE statement
OceanBase error code: 5571
MySQL error code: 1339
ERROR 1347 (HY000): \'%s.%s\' is not %s
OceanBase error code: 5214
MySQL error code: 1347
ERROR 1348 (HY000): Column '%.*s' is not updatable
OceanBase error code: 5719
MySQL error code: 1348
ERROR 1349 (HY000): View's SELECT contains a subquery in the FROM clause
OceanBase error code: 4238
MySQL error code: 1349
ERROR 1353 (HY000): View's SELECT and view's field list have different column counts
OceanBase error code: 5740
MySQL error code: 1353
ERROR 1356 (42S22): View \'%.*s.%.*s\' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
OceanBase error code: 5231
MySQL error code: 1356
ERROR 1360 (HY000): Trigger does not exist
OceanBase error code: 5733
MySQL error code: 1360
ERROR 1362 (HY000): Updating of %s row is not allowed in %s trigger
OceanBase error code: 9584
MySQL error code: 1362
ERROR 1363 (HY000): There is no %s row in on %s trigger
OceanBase error code: 9640
MySQL error code: 1363
ERROR 1364 (HY000): Field \'%s\' doesn't have a default value
OceanBase error code: 4227
MySQL error code: 1364
ERROR 1365 (22012): Divided by zero
OceanBase error code: 4078
MySQL error code: 1365
ERROR 1366 (22007): Incorrect datetime value: '%s' for column '%s'
OceanBase error code: 4219
MySQL error code: 1366
ERROR 1366 (HY000): Incorrect integer value for column '%.*s' at row %ld
OceanBase error code: 4226
MySQL error code: 1366
ERROR 1366 (HY000): Incorrect string value for column '%.*s' at row %ld
OceanBase error code: 4258
MySQL error code: 1366
ERROR 1367 (22007): Illegal %s '%.*s' value found during parsing
OceanBase error code: 5332
MySQL error code: 1367
ERROR 1368 (HY000): CHECK OPTION on non-updatable view '%.*s.%.*s'
OceanBase error code: 5972
MySQL error code: 1368
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1369 (HY000): CHECK OPTION failed '%.*s.%.*s'
OceanBase error code: 5971
MySQL error code: 1369
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1382 (HY000): The '%.*s' syntax is reserved for purposes internal to the OceanBase Server
OceanBase error code: 5405
MySQL error code: 1382
ERROR 1390 (54000): Prepared statement contains too many placeholders
OceanBase error code: 5080
MySQL error code: 1390
ERROR 1391 (HY000): Key part \'%.*s\' length cannot be 0
OceanBase error code: 5191
MySQL error code: 1391
ERROR 1393 (HY000): Can not modify more than one base table through a join view '%.*s.%.*s'
OceanBase error code: 5718
MySQL error code: 1393
ERROR 1395 (HY000): Can not delete from join view '%.*s.%.*s'
OceanBase error code: 5720
MySQL error code: 1395
ERROR 1396 (HY000): Operation %.*s failed for %.*s
OceanBase error code: 5155
MySQL error code: 1396
ERROR 1397 (XAE04): Unknown XID
OceanBase error code: 6245
MySQL error code: 1397
ERROR 1398 (XAE05): XAER_INVAL: Invalid arguments (or unsupported command)
OceanBase error code: 6249
MySQL error code: 1398
ERROR 1399 (XAE07): The command cannot be executed when global transaction is in the %s state
OceanBase error code: 6246
MySQL error code: 1399
ERROR 1399 (XAE07): RMFAIL: The command cannot be executed when global transaction is in the %s state
OceanBase error code: 6258
MySQL error code: 1399
ERROR 1400 (XAE09): Some work is done outside global transaction
OceanBase error code: 6248
MySQL error code: 1400
ERROR 1401 (XAE03): XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
OceanBase error code: 6250
MySQL error code: 1401
ERROR 1402 (XA100): XA_RBROLLBACK: Transaction branch was rolled back
OceanBase error code: 6252
MySQL error code: 1402
ERROR 1406 (22001): Data too long for column '%.*s' at row %ld
OceanBase error code: 5167
MySQL error code: 1406
ERROR 1406 (22001): Data too long for column
OceanBase error code: 5354
MySQL error code: 1406
ERROR 1407 (42000): Bad SQLSTATE: \'%.*s\'
OceanBase error code: 5585
MySQL error code: 1407
ERROR 1410 (42000): You are not allowed to create a user with GRANT
OceanBase error code: 5169
MySQL error code: 1410
ERROR 1411 (HY000): Incorrect %.*s value: '%.*s' for function %.*s
OceanBase error code: 5936
MySQL error code: 1411
ERROR 1413 (42000): Duplicate handler declared in the same block
OceanBase error code: 5581
MySQL error code: 1413
ERROR 1414 (42000): OUT or INOUT argument %d for routine %.*s is not a variable
OceanBase error code: 5592
MySQL error code: 1414
ERROR 1415 (0A000): Not allowed to return a result set from a %s
OceanBase error code: 5579
MySQL error code: 1415
ERROR 1416 (22003): Cannot get geometry object from data you send to the GEOMETRY field.
OceanBase error code: 7276
MySQL error code: 1416
Note
This error code is deprecated since OceanBase Database V4.0.0.
ERROR 1422 (HY000): Explicit or implicit commit is not allowed in stored function or trigger
OceanBase error code: 5576
MySQL error code: 1422
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1422 (HY000): '%.*s' is not allowed in stored function or trigger
OceanBase error code: 9576
MySQL error code: 1422
ERROR 1424 (HY000): Recursive stored functions are not allowed
OceanBase error code: 5570
MySQL error code: 1424
ERROR 1425 (42000): Too big scale %d specified for column '%s'. Maximum is %ld
OceanBase error code: 5202
MySQL error code: 1425
ERROR 1426 (42000): Too big precision %d specified for column '%s'. Maximum is %ld
OceanBase error code: 5203
MySQL error code: 1426
ERROR 1427 (42000): For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')
OceanBase error code: 5204
MySQL error code: 1427
ERROR 1435 (HY000): Trigger in wrong schema
OceanBase error code: 9582
MySQL error code: 1435
ERROR 1439 (42000): Display width out of range for column '%s' (max = %ld)
OceanBase error code: 5205
MySQL error code: 1439
ERROR 1439 (42000): Display width out of range for column '%.*s' (max = %d)
OceanBase error code: 9578
MySQL error code: 1439
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1440 (XAE08): The XID already exists
OceanBase error code: 6247
MySQL error code: 1440
ERROR 1441 (22008): Datetime overflow
OceanBase error code: 4261
MySQL error code: 1441
ERROR 1442 (HY000): Can't update table \'%s\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
OceanBase error code: 5791
MySQL error code: 1442
ERROR 1445 (HY000): Not allowed to set autocommit from a stored function or trigger
OceanBase error code: 5591
MySQL error code: 1445
ERROR 1449 (HY000): User not exist
OceanBase error code: 5035
MySQL error code: 1449
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
OceanBase error code: 5314
MySQL error code: 1451
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
OceanBase error code: 5618
MySQL error code: 1451
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails
OceanBase error code: 5315
MySQL error code: 1452
ERROR 1456 (HY000): Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine
OceanBase error code: 5567
MySQL error code: 1456
ERROR 1458 (42000): Incorrect routine name \'%.*s\'
OceanBase error code: 5588
MySQL error code: 1458
ERROR 1462 (42S02): \'%.*s'.'%.*s\' contains view recursion
OceanBase error code: 5239
MySQL error code: 1462
ERROR 1466 (HY000): Leading spaces are removed from name \'%.*s\'
OceanBase error code: 5247
MySQL error code: 1466
ERROR 1467 (HY000): Failed to read auto increment value from storage engine
OceanBase error code: 5184
MySQL error code: 1467
ERROR 1470 (HY000): String '%.*s' is too long for user name (should be no longer than 64)
OceanBase error code: 5181
MySQL error code: 1470
ERROR 1471 (HY000): The target table %.*s of the INSERT is not insertable-into
OceanBase error code: 5717
MySQL error code: 1471
ERROR 1474 (HY000): Name \'%.*s\' has become ''
OceanBase error code: 5246
MySQL error code: 1474
ERROR 1475 (42000): Ambiguous column
OceanBase error code: 5015
MySQL error code: 1475
ERROR 1486 (HY000): Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed
OceanBase error code: 5230
MySQL error code: 1486
ERROR 1488 (HY000): Field in list of fields for partition function not found in table
OceanBase error code: 5255
MySQL error code: 1488
ERROR 1491 (HY000): The PARTITION function returns the wrong type
OceanBase error code: 5257
MySQL error code: 1491
ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition%.*s
OceanBase error code: 5281
MySQL error code: 1493
ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition
OceanBase error code: 5353
MySQL error code: 1493
ERROR 1495 (HY000): Multiple definition of same constant in list partitioning
OceanBase error code: 5340
MySQL error code: 1495
ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined
OceanBase error code: 5188
MySQL error code: 1499
ERROR 1500 (HY000): It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
- OceanBase error code: 4398
- MySQL error code: 1500
- Cause: You have specified an incompatible partitioning method when you create the partitioned table. For example, you may have specified RANGE-LIST partitioning and HASH-KEY partitioning.
- Solution:
- Change the partitioning method. If you want to use both RANGE-LIST partitioning and HASH-KEY partitioning, you can use a compatible partitioning method. Note that changing the partitioning method or partitioning a partitioned table may affect the existing data and applications. Proceed with caution.
- Separate the partitions. If you need to use incompatible partitioning methods, you can split the partitioned table into multiple tables and use different partitioning methods for the tables.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 1503 (HY000): A %s must include all columns in the table's partitioning function
OceanBase error code: 5261
MySQL error code: 1503
ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table\'s partitioning function
OceanBase error code: 5283
MySQL error code: 1503
ERROR 1504 (HY000): Number of partitions = 0 is not an allowed value
OceanBase error code: 5189
MySQL error code: 1504
ERROR 1505 (HY000): Partition management on a not partitioned table is not possible
OceanBase error code: 5302
MySQL error code: 1505
ERROR 1507 (HY000): error in list of partitions to DROP
OceanBase error code: 5303
MySQL error code: 1507
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead
OceanBase error code: 5306
MySQL error code: 1508
ERROR 1512 (HY000): %s PARTITION can only be used on RANGE/LIST partitions
OceanBase error code: 5305
MySQL error code: 1512
ERROR 1517 (HY000): Duplicate partition name \'%.*s\'
OceanBase error code: 5280
MySQL error code: 1517
ERROR 1517 (HY000): Duplicate partition name %.*s
- OceanBase error code: 5493
- MySQL error code: 1517
- Cause: When you change the name of a partition, the new name is already taken by an existing partition. The concept of subpartitions is no longer used in OceanBase Database in MySQL mode since version 4.2.0. Therefore, the same error code is used for both partitions and subpartitions in MySQL tenants of OceanBase Database.
- Solution: Use another partition name or delete the existing partition with the name.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 1517 (HY000): Duplicate partition name %.*s
- OceanBase error code: 5494
- MySQL error code: 1517
- Cause: Partition names are duplicate.
- Solution: Use another name or delete the existing partition or subpartition with the name.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 1517 (HY000): missing or invalid WAIT interval
- OceanBase error code: 5495
- MySQL error code: 1517
- Cause: When you run the
WAITcommand, the specified wait time parameter is invalid or missing. - Solution: Check the syntax of the
WAITcommand and make sure that the wait time parameter is correctly specified.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 1520 (HY000): Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
OceanBase error code: 5566
MySQL error code: 1520
ERROR 1525 (HY000): Incorrect %s value: '%s'
OceanBase error code: 5241
MySQL error code: 1525
ERROR 1526 (HY000): Table has no partition for value
OceanBase error code: 5284
MySQL error code: 1526
ERROR 1562 (HY000): Cannot create temporary table with partitions
OceanBase error code: 5310
MySQL error code: 1562
ERROR 1563 (HY000): Partition constant is out of partition function domain
OceanBase error code: 5286
MySQL error code: 1563
ERROR 1564 (HY000): This partition function is not allowed
OceanBase error code: 5262
MySQL error code: 1564
ERROR 1566 (HY000): Not allowed to use NULL value in VALUES LESS THAN
OceanBase error code: 5285
MySQL error code: 1566
ERROR 1568 (25001): Transaction characteristics can't be changed while a transaction is in progress
OceanBase error code: 5219
MySQL error code: 1568
ERROR 1582 (42000): Incorrect parameter count in the call to native function '%.*s'
OceanBase error code: 5054
MySQL error code: 1582
ERROR 1583 (42000): Incorrect parameters in the call to native function '%.*s'
OceanBase error code: 5407
MySQL error code: 1583
ERROR 1613 (XA106): XA_RBTIMEOUT: Transaction branch was rolled back: took too long
OceanBase error code: 6253
MySQL error code: 1613
ERROR 1621 (HY000): variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value
OceanBase error code: 5102
MySQL error code: 1621
ERROR 1628 (HY000): Comment for table is too long (max = %ld)
OceanBase error code: 4229
MySQL error code: 1628
ERROR 1629 (HY000): Comment for field is too long (max = %ld)
OceanBase error code: 4230
MySQL error code: 1629
ERROR 1642 (01000): Unhandled user-defined warning condition
OceanBase error code: 9701
MySQL error code: 1642
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 1644 (HY000): Unhandled user-defined exception condition
OceanBase error code: 5556
MySQL error code: 1644
ERROR 1645 (0K000): RESIGNAL when handler not active
OceanBase error code: 9702
MySQL error code: 1645
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1646 (HY000): SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
OceanBase error code: 5557
MySQL error code: 1646
ERROR 1652 (HY000): Duplicate partition field name '%.*s'
OceanBase error code: 5237
MySQL error code: 1652
ERROR 1653 (HY000): Inconsistency in usage of column lists for partitioning
OceanBase error code: 5276
MySQL error code: 1653
ERROR 1654 (HY000): Partition column values of incorrect type
OceanBase error code: 5275
MySQL error code: 1654
ERROR 1654 (HY000): Partition column values of incorrect type
OceanBase error code: 5349
MySQL error code: 1654
ERROR 1654 (HY000): Partition column values of incorrect type
OceanBase error code: 5355
MySQL error code: 1654
ERROR 1655 (HY000): Too many fields in \'list of partition fields\'
OceanBase error code: 5287
MySQL error code: 1655
ERROR 1657 (HY000): Cannot have more than one value for this type of RANGE partitioning
OceanBase error code: 5277
MySQL error code: 1657
ERROR 1659 (HY000): Field \'%.*s\' is of a not allowed type for this type of partitioning
OceanBase error code: 5178
MySQL error code: 1659
ERROR 1688 (HY000): Comment for index is too long (max = %ld)
OceanBase error code: 4231
MySQL error code: 1688
ERROR 1690 (22003): %s value is out of range in '%s'
OceanBase error code: 4157
MySQL error code: 1690
ERROR 1697 (HY000): VALUES value for partition \'%.*s\' must have type INT
OceanBase error code: 5274
MySQL error code: 1697
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint %.*s
OceanBase error code: 5594
MySQL error code: 1701
ERROR 1706 (HY000): Primary key/index key/partition key update is not allowed since the table is updated both as '%.*s' and '%.*s'
OceanBase error code: 5344
MySQL error code: 1706
ERROR 1708 (HY000): The value of \'%s\' should be no less than the value of \'%s\'
OceanBase error code: 5266
MySQL error code: 1708
ERROR 1735 (HY000): Unkown partition '%.*s' in table '%.*s'
OceanBase error code: 5146
MySQL error code: 1735
ERROR 1748 (HY000): Found a row not matching the given partition set
OceanBase error code: 5147
MySQL error code: 1748
ERROR 1758 (35000): Invalid condition number
OceanBase error code: 9696
MySQL error code: 1758
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction
OceanBase error code: 5220
MySQL error code: 1792
ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction
OceanBase error code: 6226
MySQL error code: 1792
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
OceanBase error code: 4365
MySQL error code: 1819
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
OceanBase error code: 4366
MySQL error code: 1820
ERROR 1827 (42000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function
OceanBase error code: 5227
MySQL error code: 1827
ERROR 1869 (HY000): Auto-increment value in UPDATE conflicts with internally generated values
OceanBase error code: 5244
MySQL error code: 1869
ERROR 1882 (HY000): The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long
OceanBase error code: 4336
MySQL error code: 1882
ERROR 3004 (0Z002): GET STACKED DIAGNOSTICS when handler not active
OceanBase error code: 5402
MySQL error code: 3004
ERROR 3011 (HY000): Referenced trigger '%s' for the given action time and event type does not exist
OceanBase error code: 9704
MySQL error code: 3011
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3020 (2201E): Invalid argument for logarithm
OceanBase error code: 5565
MySQL error code: 3020
ERROR 3028 (HY000): Expression #%d of ORDER BY contains aggregate function and applies to a UNION
OceanBase error code: 5263
MySQL error code: 3028
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3033 (HY000): Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical
OceanBase error code: 7201
MySQL error code: 3033
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3034 (HY000): Calling geometry function %s with unsupported types of arguments
OceanBase error code: 7202
MySQL error code: 3034
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3035 (HY000): Unknown GIS error occurred in function %s
OceanBase error code: 7203
MySQL error code: 3035
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3036 (HY000): Unknown exception caught in GIS function %s
OceanBase error code: 7204
MySQL error code: 3036
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3037 (22023): Invalid GIS data provided to function %s
OceanBase error code: 7205
MySQL error code: 3037
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3038 (HY000): The geometry has no data in function %s.
OceanBase error code: 7206
MySQL error code: 3038
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3039 (HY000): Unable to calculate centroid because geometry is empty in function %s.
OceanBase error code: 7207
MySQL error code: 3039
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3040 (HY000): Geometry overlay calculation error: geometry data is invalid in function %s.
OceanBase error code: 7208
MySQL error code: 3040
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3041 (HY000): Geometry turn info calculation error: geometry data is invalid in function %s.
OceanBase error code: 7209
MySQL error code: 3041
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3042 (HY000): Analysis procedures of intersection points interrupted unexpectedly in function %s.
OceanBase error code: 7210
MySQL error code: 3042
ERROR 3043 (HY000): Unknown exception thrown in function %s.
OceanBase error code: 7211
MySQL error code: 3043
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3044 (HY000): Memory allocation error: %-.256s in function %s.
OceanBase error code: 7265
MySQL error code: 3044
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3045 (HY000): Domain error", "Domain error: %-.256s in function %s.
OceanBase error code: 7266
MySQL error code: 3045
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3046 (HY000): Length error: %-.256s in function %s.
OceanBase error code: 7267
MySQL error code: 3046
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3047 (HY000): Invalid argument error: %-.256s in function %s.
OceanBase error code: 7268
MySQL error code: 3047
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3048 (HY000): Out of range error: %-.256s in function %s.
OceanBase error code: 7269
MySQL error code: 3048
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3049 (HY000): Overflow error: %-.256s in function %s.
OceanBase error code: 7270
MySQL error code: 3049
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3050 (HY000): Range error: %-.256s in function %s.
OceanBase error code: 7271
MySQL error code: 3050
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3051 (HY000): Underflow error: %-.256s in function %s.
OceanBase error code: 7272
MySQL error code: 3051
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3052 (HY000): Logic error: %-.256s in function %s.
OceanBase error code: 7273
MySQL error code: 3052
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3053 (HY000): Runtime error: %-.256s in function %s.
OceanBase error code: 7274
MySQL error code: 3053
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3054 (HY000): Unknown exception: %-.384s in function %s.
OceanBase error code: 7275
MySQL error code: 3054
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3055 (HY000): Geometry byte string must be little endian.
OceanBase error code: 7212
MySQL error code: 3055
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3060 (HY000): Do not support online operation on table with GIS index
OceanBase error code: 7213
MySQL error code: 3060
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3064 (HY000): invalid type given for an argument
OceanBase error code: 5351
MySQL error code: 3064
ERROR 3105 (HY000): The value specified for generated column '%.*s' in table '%.*s' is not allowed
OceanBase error code: 5290
MySQL error code: 3105
ERROR 3106 (HY000): '%s' is not supported for generated columns
OceanBase error code: 5292
MySQL error code: 3106
ERROR 3108 (HY000): Column '%.*s' has a generated column dependency
OceanBase error code: 5293
MySQL error code: 3108
ERROR 3118 (HY000): User locked
OceanBase error code: 5039
MySQL error code: 3118
ERROR 3122 (HY000): Inconsistent intersection points.
OceanBase error code: 7214
MySQL error code: 3122
Note
This error code is deprecated since OceanBase Database V4.0.0.
ERROR 3134 (HY000): Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.
OceanBase error code: 7215
MySQL error code: 3134
Note
This error code is deprecated since OceanBase Database V4.0.0.
ERROR 3140 (22032): Invalid JSON text
OceanBase error code: 5411
MySQL error code: 3140
ERROR 3141 (22032): Invalid JSON text in argument
OceanBase error code: 5412
MySQL error code: 3141
ERROR 3142 (42000): The JSON binary value contains invalid data
OceanBase error code: 5413
MySQL error code: 3142
ERROR 3143 (42000): Invalid JSON path expression
OceanBase error code: 5414
MySQL error code: 3143
ERROR 3144 (22032): Cannot create a JSON value from a string
OceanBase error code: 5415
MySQL error code: 3144
ERROR 3145 (22032): Invalid JSON character data provided to function
OceanBase error code: 5416
MySQL error code: 3145
ERROR 3146 (22032): Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required
OceanBase error code: 5417
MySQL error code: 3146
ERROR 3147 (22032): Cannot CAST value to JSON
OceanBase error code: 5418
MySQL error code: 3147
ERROR 3148 (42000): A path expression must be encoded in the utf8 character set
OceanBase error code: 5419
MySQL error code: 3148
ERROR 3149 (42000): In this situation, path expressions may not contain the * and ** tokens
OceanBase error code: 5420
MySQL error code: 3149
ERROR 3150 (22032): The JSON value is too big to be stored in a JSON column
OceanBase error code: 5421
MySQL error code: 3150
ERROR 3151 (22032): The JSON object contains a key name that is too long
OceanBase error code: 5422
MySQL error code: 3151
ERROR 1351 (HY000): View's SELECT contains a variable or parameter
- OceanBase error code: 9748
- MySQL error code: 1351
- Cause: The
SELECTstatement that you use to query the view contains variables or parameters. - Solution: Make sure that the query statement does not contain variables or parameters.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 3153 (42000): The path expression is not allowed in this context
OceanBase error code: 5424
MySQL error code: 3153
ERROR 3154 (42000): The oneOrAll argument may take these values: \'one\' or \'all\'
OceanBase error code: 5425
MySQL error code: 3154
ERROR 3155 (22003): Out of range JSON value for CAST
OceanBase error code: 5426
MySQL error code: 3155
ERROR 3156 (22018): Invalid JSON value for CAST
OceanBase error code: 5427
MySQL error code: 3156
ERROR 3157 (22032): The JSON document exceeds the maximum depth
OceanBase error code: 5428
MySQL error code: 3157
ERROR 3158 (22032): JSON documents may not contain NULL member names
OceanBase error code: 5429
MySQL error code: 3158
ERROR 3165 (42000): A path expression is not a path to a cell in an array
OceanBase error code: 5431
MySQL error code: 3165
ERROR 3504 (HY000): Too many enumeration valuesfor column %.*s
OceanBase error code: 5335
MySQL error code: 3504
ERROR 3505 (HY000): Too long enumeration/setvalue for column %.*s
OceanBase error code: 5333
MySQL error code: 3505
ERROR 3516 (22S01): %.64s value is a geometry of unexpected type %.64s in %.64s.
OceanBase error code: 7216
MySQL error code: 3516
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3516 (22S01): Unknown WKB type(%d)! Full WKB type number was (%d).
OceanBase error code: 7288
MySQL error code: 3516
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3517 (SR002): Can't parse the spatial reference system definition of SRID %u.
OceanBase error code: 7217
MySQL error code: 3517
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3518 (SR003): The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.
OceanBase error code: 7218
MySQL error code: 3518
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3519 (01000): There's no spatial reference system with SRID %u.
OceanBase error code: 7219
MySQL error code: 3519
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3520 (22S00): Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian.
OceanBase error code: 7220
MySQL error code: 3520
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3521 (SR001): Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined.
OceanBase error code: 7221
MySQL error code: 3521
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3548 (SR001): There's no spatial reference system with SRID %u.
OceanBase error code: 7222
MySQL error code: 3548
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3548 (SR001): Spatial reference system is empty
OceanBase error code: 7285
MySQL error code: 3548
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3558 (22023): Invalid option key '%.192s' in function %.192s.
OceanBase error code: 7286
MySQL error code: 3558
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3559 (22023): Invalid value '%.192s' for option '%.192s' in function '%.192s'.
OceanBase error code: 7287
MySQL error code: 3559
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3560 (22023): The string '%.192s' is not a valid key %c value pair in function %.192s.
OceanBase error code: 7283
MySQL error code: 3560
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3565 (01000): There's no spatial reference system with SRID %u. The axis order is unknown.
OceanBase error code: 7223
MySQL error code: 3565
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3574 (HY000): Recursive Common Table Expression should have one or more non-recursive query blocks followed by one or more recursive ones: %s
OceanBase error code: 5982
MySQL error code: 3574
ERROR 3575 (HY000): Recursive Common Table Expression can contain neither aggregation nor window functions in recursive query block
Error code in OceanBase Database: 5758
MySQL error code: 3575
ERROR 3576 (HY000): In recursive query block of Recursive Common Table Expression, the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints
OceanBase error code: 5759
MySQL error code: 3576
ERROR 3577 (HY000): In recursive query block of Recursive Common Table Expression, the recursive table must be referenced only once, and not in any subquery
OceanBase error code: 5744
MySQL error code: 3577
ERROR 3581 (HY000): A window which depends on another cannot define partitioning
OceanBase error code: 5438
MySQL error code: 3581
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3582 (HY000): Window '%.*s' has a frame definition, so cannot be referenced by another window
OceanBase error code: 5439
MySQL error code: 3582
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3583 (HY000): Window '%.*s' cannot inherit '%.*s' since both contain an ORDER BY clause
OceanBase error code: 5440
MySQL error code: 3583
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3587 (HY000): Window '%s' with RANGE N PRECEDING/FOLLOWING frame requires exactly one ORDER BY expression of numeric or temporal type
OceanBase error code: 5984
MySQL error code: 3587
ERROR 3592 (HY000): Window '%s': ORDER BY or PARTITION BY uses legacy position indication, which is not supported use expression
OceanBase error code: 5985
MySQL error code: 3592
ERROR 3596 (HY000): Window '%s': INTERVAL can only be used with RANGE frames
OceanBase error code: 5983
MySQL error code: 3596
ERROR 3616 (22S02): Longitude %f is out of range in function %.192s. It must be within (%f, %f].
OceanBase error code: 7263
MySQL error code: 3616
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3617 (22S03): Latitude %f is out of range in function %.192s. It must be within [%f, %f].
OceanBase error code: 7264
MySQL error code: 3617
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3618 (22S00): %.192s(%.80s) has not been implemented for geographic spatial reference systems.
OceanBase error code: 7224
MySQL error code: 3618
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3636 (HY000): Recursive query aborted after %u iterations. Try increasing @@cte_max_recursion_depth to a larger value.
OceanBase error code: 5408
MySQL error code: 3636
ERROR 3643 (HY000): The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.
OceanBase error code: 7225
MySQL error code: 3643
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3644 (HY000): The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.
OceanBase error code: 7226
MySQL error code: 3644
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3674 (HY000): The spatial index on column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
OceanBase error code: 7227
MySQL error code: 3674
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3682 (22S00): Function %.192s is only defined for SRID 0 and SRID 4326.
OceanBase error code: 7228
MySQL error code: 3682
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3704 (22S00): %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.
OceanBase error code: 7229
MySQL error code: 3704
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3705 (22S00): %.192s(%.80s) has not been implemented for projected spatial reference systems.
OceanBase error code: 7230
MySQL error code: 3705
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3706 (22023): Invalid radius provided to function %s: Radius(%lf) must be greater than zero.
OceanBase error code: 7284
MySQL error code: 3706
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3708 (SR006): Missing mandatory attribute %s.
OceanBase error code: 7231
MySQL error code: 3708
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3709 (SR006): Multiple definitions of attribute %s.
OceanBase error code: 7232
MySQL error code: 3709
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3710 (SR006): The spatial reference system name can't be an empty string or start or end with whitespace.
OceanBase error code: 7233
MySQL error code: 3710
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3711 (SR006): The organization name can't be an empty string or start or end with whitespace.
OceanBase error code: 7234
MySQL error code: 3711
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3712 (SR004): There is already a spatial reference system with SRID %u.
OceanBase error code: 7235
MySQL error code: 3712
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3713 (01S00): There is already a spatial reference system with SRID %u.
OceanBase error code: 7236
MySQL error code: 3713
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3714 (SR000): SRID 0 is not modifiable.
OceanBase error code: 7237
MySQL error code: 3714
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3715 (01S01): The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified or removed without warning during upgrade.
OceanBase error code: 7238
MySQL error code: 3715
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3716 (SR005): Can't modify SRID %u. There is at least one column depending on it.
OceanBase error code: 7239
MySQL error code: 3716
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3717 (SR006): Invalid character in attribute %s.
OceanBase error code: 7240
MySQL error code: 3717
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3718 (SR006): Attribute %s is too long. The maximum length is %u characters.
OceanBase error code: 7241
MySQL error code: 3718
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3726 (22S00): Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.
OceanBase error code: 7242
MySQL error code: 3726
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3727 (22023): Function %s encountered a polygon that was too large. Polygons must cover less than half the planet.
OceanBase error code: 7243
MySQL error code: 3727
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3728 (HY000): Spatial indexes can't be primary or unique indexes.
OceanBase error code: 7244
MySQL error code: 3728
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3729 (HY000): The index type %.20s is not supported for spatial indexes.
OceanBase error code: 7245
MySQL error code: 3729
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3729 (HY000): The index type %s is not supported for spatial indexes.
OceanBase error code: 7281
MySQL error code: 3729
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3731 (22S02): A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].
OceanBase error code: 7246
MySQL error code: 3731
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3732 (22S03): A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].
OceanBase error code: 7247
MySQL error code: 3732
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3736 (SR002): The spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST.
OceanBase error code: 7248
MySQL error code: 3736
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3737 (SR002): The length of the semi-major axis must be a positive number.
OceanBase error code: 7249
MySQL error code: 3737
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3738 (SR002): The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere.
OceanBase error code: 7250
MySQL error code: 3738
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3739 (SR002): The angular unit conversion factor must be a positive number.
OceanBase error code: 7251
MySQL error code: 3739
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3740 (SR002): The prime meridian must be within (-180, 180] degrees, specified in the SRS angular unit.
OceanBase error code: 7252
MySQL error code: 3740
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3741 (22S00): Transformation from SRID %u is not supported.
OceanBase error code: 7253
MySQL error code: 3741
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3742 (22S00): Transformation to SRID %u is not supported.
OceanBase error code: 7254
MySQL error code: 3742
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3743 (22S00): Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
OceanBase error code: 7255
MySQL error code: 3743
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3744 (22S00): Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
OceanBase error code: 7256
MySQL error code: 3744
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3753 (42000): Cannot create a functional index on a function that returns a JSON or GEOMETRY value.
OceanBase error code: 7257
MySQL error code: 3753
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3754 (HY000): Functional index '%.*s' cannot refer to an auto-increment column.
- OceanBase error code: 5496
- MySQL error code: 3754
- Cause: You have used an auto-increment column as part of the function-based index that you want to create.
- Solution: Remove the auto-increment column from the function-based index, or use another column as part of the function-based index.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 3757 (HY000): Cannot create a functional index on an expression that returns a BLOB or TEXT. Please consider using CAST.
- OceanBase error code: 5498
- MySQL error code: 3757
- Cause: You have used an expression of the BLOB or TEXT type to create a function-based index.
- Solution: Use a CAST function to convert the expression of the BLOB or TEXT type to another type, and then use the converted expression to create the function-based index.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 3758 (HY000): Expression of functional index contains a disallowed function.
- OceanBase error code: 5905
- MySQL error code: 3758
- Cause: You have used an unsupported function to create the function-based index. The SYSDATE function or a user environment is used in the index function.
- Solution: Make sure that the index function is a pure function, such as RNDS, RNPS, WNDS, or WNPS.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 3760 (HY000): Spatial functional index is not supported.
OceanBase error code: 7258
MySQL error code: 3760
Note
This error code is introduced since OceanBase Database V3.2.4.
ERROR 3762 (HY000): Functional index on a column is not supported. Consider using a regular index instead.
- OceanBase error code: 5499
- MySQL error code: 3762
- Cause: When you create the function-based index, a single column is used as the index.
- Solution: Use a normal index.
Note
This error code is introduced since OceanBase Database V4.2.0.
ERROR 3812 (HY000): An expression of non-boolean type specified to a check constraint \'%.*s\'
OceanBase error code: 5987
MySQL error code: 3812
ERROR 3813 (HY000): Column check constraint \'%.*s\' references other column
OceanBase error code: 5786
MySQL error code: 3813
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3814 (HY000): An expression of a check constraint \'%.*s\' contains disallowed function: %.*s
OceanBase error code: 5991
MySQL error code: 3814
ERROR 3815 (HY000): An expression of a check constraint \'%.*s\' contains disallowed function
OceanBase error code: 5992
MySQL error code: 3815
ERROR 3816 (HY000): An expression of a check constraint \'%.*s\' cannot refer to a user or system variable
OceanBase error code: 5993
MySQL error code: 3816
ERROR 3818 (HY000): Check constraint \'%.*s\' cannot refer to an auto-increment column
OceanBase error code: 5990
MySQL error code: 3818
ERROR 3819 (HY000): check constraint violated
OceanBase error code: 5693
MySQL error code: 3819
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3820 (HY000): Check constraint \'%.*s\' refers to non-existing column \'%.*s\'
OceanBase error code: 5994
MySQL error code: 3820
ERROR 3821 (HY000): Check constraint \'%.*s\' is not found in the table
OceanBase error code: 5988
MySQL error code: 3821
ERROR 3822 (HY000): Duplicate check constraint name \'%.*s\'
OceanBase error code: 5678
MySQL error code: 3822
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3939 (HY000): Table has multiple constraints with the name \'%.*s\'. Please use constraint specific \'%.*s\' clause
OceanBase error code: 5986
MySQL error code: 3939
ERROR 3940 (HY000): Constraint \'%.*s\' does not exist
OceanBase error code: 5692
MySQL error code: 3940
Note
This error code is introduced since OceanBase Database V4.0.0.
ERROR 3941 (HY000): Altering constraint enforcement is not supported for the constraint \'%.*s\'. Enforcement state alter is not supported for the PRIMARY, UNIQUE and FOREIGN KEY type constraints
OceanBase error code: 5989
MySQL error code: 3941
ERROR 3959 (HY000): Check constraint \'%.*s\' uses column \'%.*s\', hence column cannot be dropped or renamed
OceanBase error code: 5859
MySQL error code: 3959
ERROR 3966 (22035): No value was found by '%.192s' on the specified path
OceanBase error code: 5432
MySQL error code: 3966
ERROR 3967 (22035): More than one value was found by '%.192s' on the specified path
OceanBase error code: 5433
MySQL error code: 3967