---
title: "0001 ~ 3999 | OceanBase 文档中心"
description: "0001 ~ 3999 此错误码范围表示兼容 MySQL 的错误码。 ERROR 1007 (HY000) : Can&#x27;t create database &#x27;%s&#x27;; database exists OceanBase 错误码：5158 兼容 MySQL 错误码：1007 ERROR 1008 (HY000) : C…"
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 3.2.1 企业版

# 0001 ~ 3999

更新时间：2023-07-17 13:53:43

此错误码范围表示兼容 MySQL 的错误码。

## ERROR 1007 (HY000) : Can't create database '%s'; database exists

- OceanBase 错误码：5158
 - 兼容 MySQL 错误码：1007

## ERROR 1008 (HY000) : Can't drop database '%.*s'; database doesn't exist

- OceanBase 错误码：5166
 - 兼容 MySQL 错误码：1008

## ERROR 1017 (HY000) : File not exist

- OceanBase 错误码：4027
 - 兼容 MySQL 错误码：1017

## ERROR 1018 (HY000) : Directory not exist

- OceanBase 错误码：4066
 - 兼容 MySQL 错误码：1018

## ERROR 1022 (23000) : Can't write; duplicate key in table \'%.*s\'

- OceanBase 错误码：5595
 - 兼容 MySQL 错误码：1022

## ERROR 1025 (HY000) : Error on rename of \'%s.%s\' to \'%s.%s\'

- OceanBase 错误码：5215
 - 兼容 MySQL 错误码：1025

## ERROR 1040 (08004) : Too many connections

- OceanBase 错误码：5271
 - 兼容 MySQL 错误码：1040

## ERROR 1041 (53000) : Out of resource

- OceanBase 错误码：4153
 - 兼容 MySQL 错误码：1041

## ERROR 1044 (42000) : Access denied for user '%.*s'@'%.*s' to database '%.*s'

- OceanBase 错误码：5170
 - 兼容 MySQL 错误码：1044

## ERROR 1045 (42000) : Access denied for user '%.*s'@'%.*s' (using password: %s)

- OceanBase 错误码：4043
 - 兼容 MySQL 错误码：1045

## ERROR 1046 (3D000 ) : No database selected

- OceanBase 错误码：5134
 - 兼容 MySQL 错误码：1046

## ERROR 1047 (HY001) : Unknown packet

- OceanBase 错误码：4118
 - 兼容 MySQL 错误码：1047

## ERROR 1048 (23000) : Column '%.*s' cannot be null

- OceanBase 错误码：4235
 - 兼容 MySQL 错误码：1048

## ERROR 1049 (42000) : Unknown database '%.*s'

- OceanBase 错误码：5154
 - 兼容 MySQL 错误码：1049

## ERROR 1050 (42S01) : Table '%.*s' already exists

- OceanBase 错误码：5020
 - 兼容 MySQL 错误码：1050

## ERROR 1051 (42S02) : Unknown table '%.*s'

- OceanBase 错误码：5201
 - 兼容 MySQL 错误码：1051

## ERROR 1052 (23000) : Column '%.*s' in %.*s is ambiguous

- OceanBase 错误码：5207
 - 兼容 MySQL 错误码：1052

## ERROR 1054 (42S22) : Unknown column '%.*s' in '%.*s'

- OceanBase 错误码：5217
 - 兼容 MySQL 错误码：1054

## ERROR 1055 (42000) : \'%.*s\' is not in GROUP BY

- OceanBase 错误码：5218
 - 兼容 MySQL 错误码：1055

## ERROR 1056 (42000) : Can't group on '%.*s'

- OceanBase 错误码：5206
 - 兼容 MySQL 错误码：1056

## ERROR 1059 (42000) : Identifier name \'%.*s\' is too long

- OceanBase 错误码：5179
 - 兼容 MySQL 错误码：1059

## ERROR 1060 (42S21) : Duplicate column name '%.*s'

- OceanBase 错误码：5008
 - 兼容 MySQL 错误码：1060

## ERROR 1061 (42000) : Duplicate key name \'%.*s\'

- OceanBase 错误码：5025
 - 兼容 MySQL 错误码：1061

## ERROR 1062 (23000) : Duplicate entry \'%s\' for key \'%.*s\'

- OceanBase 错误码：5024
 - 兼容 MySQL 错误码：1062

## ERROR 1063 (42000) : Incorrect column specifier for column '%.*s'

- OceanBase 错误码：5165
 - 兼容 MySQL 错误码：1063

## ERROR 1064 (0B000) : Failed to init SQL parser

- OceanBase 错误码：5000
 - 兼容 MySQL 错误码：1064

## ERROR 1064 (42000) : Parse error", "%s near \'%.*s\' at line %d

- OceanBase 错误码：5001
 - 兼容 MySQL 错误码：1064

## ERROR 1064 (42000) : Wrong number of partitions defined, mismatch with previous setting

- OceanBase 错误码：5282
 - 兼容 MySQL 错误码：1064

## ERROR 1065 (42000) : Query was empty

- OceanBase 错误码：5253
 - 兼容 MySQL 错误码：1065

## ERROR 1066 (42000) : Not unique table/alias: \'%.*s\'

- OceanBase 错误码：5208
 - 兼容 MySQL 错误码：1066

## ERROR 1067 (42000) : Invalid default value for \'%.*s\'

- OceanBase 错误码：5173
 - 兼容 MySQL 错误码：1067

## ERROR 1068 (42000) : Multiple primary key defined

- OceanBase 错误码：5210
 - 兼容 MySQL 错误码：1068

## ERROR 1069 (42000) : Too many keys specified; max %ld keys allowed

- OceanBase 错误码：5194
 - 兼容 MySQL 错误码：1069

## ERROR 1070 (42000) : Too many key parts specified; max %ld parts allowed

- OceanBase 错误码：5195
 - 兼容 MySQL 错误码：1070

## ERROR 1071 (42000) : Specified key was too long; max key length is %ld bytes

- OceanBase 错误码：5196
 - 兼容 MySQL 错误码：1071

## ERROR 1072 (42000) : Key column '%.*s' doesn't exist in table

- OceanBase 错误码：5211
 - 兼容 MySQL 错误码：1072

## ERROR 1074 (42000) : Column length too big for column '%s' (max = %d)

- OceanBase 错误码：5198
 - 兼容 MySQL 错误码：1074

## ERROR 1075 (42000) : Incorrect table definition; there can be only one auto column

- OceanBase 错误码：5193
 - 兼容 MySQL 错误码：1075

## ERROR 1078 (01000) : (string):%s: Got signal %d. Aborting!

- OceanBase 错误码：4662
 - 兼容 MySQL 错误码：1078

## ERROR 1082 (42S12) : Illegal index

- OceanBase 错误码：5028
 - 兼容 MySQL 错误码：1082

## ERROR 1082 (42000) : Index unavailable

- OceanBase 错误码：5073
 - 兼容 MySQL 错误码：1082

## ERROR 1083 (42000) : Field separator argument is not what is expected; check the manual

- OceanBase 错误码：5295
 - 兼容 MySQL 错误码：1083

## ERROR 1083 (HY000) : Non-ASCII separator arguments are not fully supported

- OceanBase 错误码：5609
 - 兼容 MySQL 错误码：1083

## ERROR 1083 (HY000) : First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY

- OceanBase 错误码：5610
 - 兼容 MySQL 错误码：1083

## ERROR 1086 (58000) : File already exist

- OceanBase 错误码：4117
 - 兼容 MySQL 错误码：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 错误码：5190
 - 兼容 MySQL 错误码：1089

## ERROR 1090 (42000) : You can't delete all columns with ALTER TABLE; use DROP TABLE instead.

- OceanBase 错误码：5187
 - 兼容 MySQL 错误码：1090

## ERROR 1091 (42000) : Can't DROP '%.*s'; check that column/key exists

- OceanBase 错误码：5209
 - 兼容 MySQL 错误码：1091

## ERROR 1093 (HY000) : You can\'t specify target table \'%s\' for update in FROM clause

- OceanBase 错误码：5174
 - 兼容 MySQL 错误码：1093

## ERROR 1094 (HY000) : Unknown thread id: %lu

- OceanBase 错误码：4174
 - 兼容 MySQL 错误码：1094

## ERROR 1095 (HY000) : You are not owner of thread %lu

- OceanBase 错误码：5251
 - 兼容 MySQL 错误码：1095

## ERROR 1096 (HY000) : No tables used

- OceanBase 错误码：5185
 - 兼容 MySQL 错误码：1096

## ERROR 1097 (HY000) : Too many strings for column %.*s and SET

- OceanBase 错误码：5336
 - 兼容 MySQL 错误码：1097

## ERROR 1102 (42000) : Incorrect database name '%.*s'

- OceanBase 错误码：5162
 - 兼容 MySQL 错误码：1102

## ERROR 1103 (42000) : Incorrect table name '%.*s'

- OceanBase 错误码：5163
 - 兼容 MySQL 错误码：1103

## ERROR 1109 (42S02) : Unknown table '%.*s' in %.*s

- OceanBase 错误码：5200
 - 兼容 MySQL 错误码：1109

## ERROR 1110 (42000): Column \'%s\' specified twice

- OceanBase 错误码：4228
 - 兼容 MySQL 错误码：1110

## ERROR 1111 (HY000) : Invalid use of group function

- OceanBase 错误码：5176
 - 兼容 MySQL 错误码：1111

## ERROR 1115 (42000) : Unknown character set: '%.*s'

- OceanBase 错误码：5142
 - 兼容 MySQL 错误码：1115

## ERROR 1117 (42000) : Too many columns

- OceanBase 错误码：5197
 - 兼容 MySQL 错误码：1117

## ERROR 1118 (42000) : Row size too large

- OceanBase 错误码：5199
 - 兼容 MySQL 错误码：1118

## ERROR 1122 (HY000) : Can not load function %s

- OceanBase 错误码：4291
 - 兼容 MySQL 错误码：1122

## ERROR 1123 (HY000) : Can not initialize function '%.*s'

- OceanBase 错误码：4292
 - 兼容 MySQL 错误码：1123

## ERROR 1124 (HY000) : No paths allowed for shared library

- OceanBase 错误码：4293
 - 兼容 MySQL 错误码：1124

## ERROR 1125 (HY000) : Function %.*s already exists

- OceanBase 错误码：4294
 - 兼容 MySQL 错误码：1125

## ERROR 1126 (HY000) : Can not open shared library '%.*s'

- OceanBase 错误码：4295
 - 兼容 MySQL 错误码：1126

## ERROR 1127 (HY000) : Can't find symbol %.*s in library

- OceanBase 错误码：4296
 - 兼容 MySQL 错误码：1127

## ERROR 1133 (42000) : Can not find any matching row in the user table'%.*s'

- OceanBase 错误码：4042
 - 兼容 MySQL 错误码：1133

## ERROR 1133 (42000) : Incorrect password

- OceanBase 错误码：5038
 - 兼容 MySQL 错误码：1133

## ERROR 1136 (21S01) : column count does not match value count at row '%d'

- OceanBase 错误码：5168
 - 兼容 MySQL 错误码：1136

## ERROR 1136 (21S01) : Column count doesn\'t match value count at row %ld

- OceanBase 错误码：5175
 - 兼容 MySQL 错误码：1136

## ERROR 1138 (22004) : Invalid use of NULL value

- OceanBase 错误码：5596
 - 兼容 MySQL 错误码：1138

## ERROR 1139 (42000) : Got error 'empty (sub)expression' from regexp

- OceanBase 错误码：5115
 - 兼容 MySQL 错误码：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 错误码：5221
 - 兼容 MySQL 错误码：1140

## ERROR 1142 (42000) : %.*s command denied to user '%.*s'@'%.*s' for table '%.*s'

- OceanBase 错误码：5171
 - 兼容 MySQL 错误码：1142

## ERROR 1144 (42000) : Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

- OceanBase 错误码：5183
 - 兼容 MySQL 错误码：1144

## ERROR 1146 (42S02) : Table \'%s.%s\' doesn\'t exist

- OceanBase 错误码：5019
 - 兼容 MySQL 错误码：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 错误码：5006
 - 兼容 MySQL 错误码：1149

## ERROR 1153 (08S01) : Got a packet bigger than \'max_allowed_packet\' bytes"

- OceanBase 错误码：4254
 - 兼容 MySQL 错误码：1153

## ERROR 1166 (42000) : Incorrect column name '%.*s'

- OceanBase 错误码：5164
 - 兼容 MySQL 错误码：1166

## ERROR 1167 (42000) : The used storage engine can't index column '%.*s'

- OceanBase 错误码：5216
 - 兼容 MySQL 错误码：1167

## ERROR 1171 (42000) : Insert null into %.*s

- OceanBase 错误码：5030
 - 兼容 MySQL 错误码：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 错误码：5256
 - 兼容 MySQL 错误码：1171

## ERROR 1172 (42000) : Result consisted of more than one row

- OceanBase 错误码：5294
 - 兼容 MySQL 错误码：1172

## ERROR 1173 (42000) : Primary key columns) not specified in the WHERE clause

- OceanBase 错误码：5047
 - 兼容 MySQL 错误码：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 错误码：5865
 - 兼容 MySQL 错误码：1175

## ERROR 1176 (42000) : Key '%.*s' doesn't exist in table '%.*s'

- OceanBase 错误码：5289
 - 兼容 MySQL 错误码：1176

## ERROR 1192 (HY000) : Can't execute the given command because you have active locked tables or an active transaction.

- OceanBase 错误码：5236
 - 兼容 MySQL 错误码：1192

## ERROR 1193 (HY000) : Unknown system variable '%.*s'

- OceanBase 错误码：5044
 - 兼容 MySQL 错误码：1193

## ERROR 1203 (42000) : Too many sessions

- OceanBase 错误码：5059
 - 兼容 MySQL 错误码：1203

## ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction

- OceanBase 错误码：6003
 - 兼容 MySQL 错误码：1205

## ERROR 1205 (HY000) : Lock wait timeout exceeded; try restarting transaction

- OceanBase 错误码：6006
 - 兼容 MySQL 错误码：1205

## ERROR 1210 (HY000) : Incorrect arguments to %s

- OceanBase 错误码：4002
 - 兼容 MySQL 错误码：1210

## ERROR 1210 (HY000) : Miss argument for %s

- OceanBase 错误码：4272
 - 兼容 MySQL 错误码：1210

## ERROR 1210 (HY000) : Miss argument for %s

- OceanBase 错误码：4277
 - 兼容 MySQL 错误码：1210

## ERROR 1213 (HY000) : Deadlock

- OceanBase 错误码：4101
 - 兼容 MySQL 错误码：1213

## ERROR 1215 (HY000) : Cannot add foreign key constraint

- OceanBase 错误码：5317
 - 兼容 MySQL 错误码：1215

## ERROR 1221 (HY000) : Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

- OceanBase 错误码：5182
 - 兼容 MySQL 错误码：1221

## ERROR 1222 (21000) : The used SELECT statements have a different number of columns

- OceanBase 错误码：5007
 - 兼容 MySQL 错误码：1222

## ERROR 1225 (HY000) : Option '%s' used twice in statement

- OceanBase 错误码：4299
 - 兼容 MySQL 错误码：1225

## ERROR 1227 (42501) : Access denied; you need (at least one of) the %s privilege(s) for this operation

- OceanBase 错误码：5036
 - 兼容 MySQL 错误码：1227

## ERROR 1228 (HY000) : Variable \'%.*s\' is a SESSION variable and can't be used with SET GLOBAL

- OceanBase 错误码：5100
 - 兼容 MySQL 错误码：1228

## ERROR 1229 (HY000) : Variable \'%.*s\' is a GLOBAL variable and should be set with SET GLOBAL

- OceanBase 错误码：5101
 - 兼容 MySQL 错误码：1229

## ERROR 1230 (42000) : Variable '%.*s' doesn't have a default value

- OceanBase 错误码：4256
 - 兼容 MySQL 错误码：1230

## ERROR 1231 (42000 ) : Variable \'%.*s\' can't be set to the value of \'%.*s\'

- OceanBase 错误码：5145
 - 兼容 MySQL 错误码：1231

## ERROR 1232 (42000) : Incorrect argument type to variable '%.*s'

- OceanBase 错误码：5180
 - 兼容 MySQL 错误码：1232

## ERROR 1234 (42000) : Incorrect usage/placement of '%s'

- OceanBase 错误码：5213
 - 兼容 MySQL 错误码：1234

## ERROR 1235 (0A000) : %s not supported

- OceanBase 错误码：4007
 - 兼容 MySQL 错误码：1235

## ERROR 1235 (0A000) : %s not supported

- OceanBase 错误码：4259
 - 兼容 MySQL 错误码：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 错误码：9581
 - 兼容 MySQL 错误码：1235

## ERROR 1238 (HY000) : Variable '%.*s' is a %.*s variable

- OceanBase 错误码：5103
 - 兼容 MySQL 错误码：1238

## ERROR 1239 (42000) : Incorrect foreign key definition: Key reference and table reference don't match

- OceanBase 错误码：5318
 - 兼容 MySQL 错误码：1239

## ERROR 1241 (21000) : Operand should contain %ld column(s)

- OceanBase 错误码：5042
 - 兼容 MySQL 错误码：1241

## ERROR 1243 (HY007) : statement not prepared, stmt_id=%u

- OceanBase 错误码：5043
 - 兼容 MySQL 错误码：1243

## ERROR 1242 (21000) : Subquery returns more than 1 row

- OceanBase 错误码：5153
 - 兼容 MySQL 错误码：1242

## ERROR 1243 (HY000) : Unknown prepared statement handle

- OceanBase 错误码：5560
 - 兼容 MySQL 错误码：1243

## ERROR 1247 (42S22) : Reference '%.*s' not supported (reference to group function)

- OceanBase 错误码：5225
 - 兼容 MySQL 错误码：1247

## ERROR 1250 (42000) : Table \'%.*s\' from one of the SELECTs cannot be used in global ORDER clause

- OceanBase 错误码：5238
 - 兼容 MySQL 错误码：1250

## ERROR 1253 (42000) : COLLATION '%.*s' is not valid for CHARACTER SET '%.*s'

- OceanBase 错误码：5144
 - 兼容 MySQL 错误码：1253

## ERROR 1260 (42000) : Row %ld was cut by GROUP_CONCAT()

- OceanBase 错误码：5254
 - 兼容 MySQL 错误码：1260

## ERROR 1261 (1000) : Row %ld doesn't contain data for all columns

- OceanBase 错误码：5611
 - 兼容 MySQL 错误码：1261

## ERROR 1262 (1000) : Row %ld was truncated; it contained more data than there were input columns

- OceanBase 错误码：5612
 - 兼容 MySQL 错误码：1262

## ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld

- OceanBase 错误码：4224
 - 兼容 MySQL 错误码：1264

## ERROR 1264 (22003) : value larger than specified precision(%ld,%ld) allowed for this column

- OceanBase 错误码：5088
 - 兼容 MySQL 错误码：1264

## ERROR 1264 (22003) : value(%s) larger than specified precision(%ld,%ld) allowed for this column

- OceanBase 错误码：5089
 - 兼容 MySQL 错误码：1264

## ERROR 1264 (22003) : Result value was out of range when casting varchar to number

- OceanBase 错误码：5093
 - 兼容 MySQL 错误码：1264

## ERROR 1264 (22003) : Out of range value for column '%.*s' at row %ld

- OceanBase 错误码：5229
 - 兼容 MySQL 错误码：1264

## ERROR 1265 (01000) : Data truncated for column '%.*s' at row %ld

- OceanBase 错误码：4249
 - 兼容 MySQL 错误码：1265

## ERROR 1265 (01000) : Timeout value truncated to 102 years

- OceanBase 错误码：4252
 - 兼容 MySQL 错误码：1265

## ERROR 1267 (HY000) : Illegal mix of collations

- OceanBase 错误码：5177
 - 兼容 MySQL 错误码：1267

## ERROR 1273 (HY000) : Unknown collation: '%.*s'

- OceanBase 错误码：5143
 - 兼容 MySQL 错误码：1273

## ERROR 1280 (42000) : Incorrect index name '%.*s'

- OceanBase 错误码：5224
 - 兼容 MySQL 错误码：1280

## ERROR 1283 (HY000) : Column '%.*s' cannot be part of FULLTEXT index

- OceanBase 错误码：5288
 - 兼容 MySQL 错误码：1283

## ERROR 1286 (42000) : Unknown storage engine \'%.*s\'

- OceanBase 错误码：5259
 - 兼容 MySQL 错误码：1286

## ERROR 1288 (HY000) : The target table %.*s of the %.*s is not updatable

- OceanBase 错误码：5228
 - 兼容 MySQL 错误码：1288

## ERROR 1290 (HY000) : The MySQL server is running with the --read-only option so it cannot execute this statement

- OceanBase 错误码：5233
 - 兼容 MySQL 错误码：1290

## ERROR 1291 (HY000) : Column '%.*s' has duplicated value '%.*s' in %s

- OceanBase 错误码：5334
 - 兼容 MySQL 错误码：1291

## ERROR 1292 (22007) : %s=%d must between %d and %d

- OceanBase 错误码：4158
 - 兼容 MySQL 错误码：1292

## ERROR 1292 (22007) : Incorrect value

- OceanBase 错误码：4190
 - 兼容 MySQL 错误码：1292

## ERROR 1292 (01000) : Truncated incorrect DOUBLE value: '%.*s'

- OceanBase 错误码：4262
 - 兼容 MySQL 错误码：1292

## ERROR 1292 (22007) : Truncated incorrect %.*s value: '%.*s'

- OceanBase 错误码：5222
 - 兼容 MySQL 错误码：1292

## ERROR 1294 (HY000) : Invalid ON UPDATE clause for \'%s\' column

- OceanBase 错误码：5172
 - 兼容 MySQL 错误码：1294

## ERROR 1295 (HY000) : This command is not supported in the prepared statement protocol yet

- OceanBase 错误码：5568
 - 兼容 MySQL 错误码：1295

## ERROR 1298 (HY000) : Unknown or incorrect time zone: \'%.*s\'

- OceanBase 错误码：5192
 - 兼容 MySQL 错误码：1298

## ERROR 1300 (HY000) : Invalid %.*s character string: \'%.*s\'

- OceanBase 错误码：5250
 - 兼容 MySQL 错误码：1300

## ERROR 1301 (HY000) : Result of %s() was larger than max_allowed_packet (%d) - truncated

- OceanBase 错误码：5316
 - 兼容 MySQL 错误码：1301

## ERROR 1302 (42000) : Conflicting declarations: '%s' and '%s'

- OceanBase 错误码：5858
 - 兼容 MySQL 错误码：1302

## ERROR 1303 (2F003) : Cant create a routine from within another routine

- OceanBase 错误码：5582
 - 兼容 MySQL 错误码：1303

## ERROR 1304 (42000) : %s %.*s already exists

- OceanBase 错误码：5541
 - 兼容 MySQL 错误码：1304

## ERROR 1305 (42000) : FUNCTION %.*s does not exist

- OceanBase 错误码：5055
 - 兼容 MySQL 错误码：1305

## ERROR 1305 (42000) : %s %.*s.%.*s does not exist

- OceanBase 错误码：5542
 - 兼容 MySQL 错误码：1305

## ERROR 1305 (42000) : savepoint does not exist

- OceanBase 错误码：6242
 - 兼容 MySQL 错误码：1305

## ERROR 1308 (42000) : no matching label: %.*s

- OceanBase 错误码：5546，9505
 - 兼容 MySQL 错误码：1308

## ERROR 1308 (42000) : %s with no matching label: %s

- OceanBase 错误码：5593
 - 兼容 MySQL 错误码：1308

## ERROR 1313 (42000) : RETURN is only allowed in a FUNCTION

- OceanBase 错误码：5583
 - 兼容 MySQL 错误码：1313

## ERROR 1317 (70100) : Query execution was interrupted

- OceanBase 错误码：5065
 - 兼容 MySQL 错误码：1317

## ERROR 1318 (42000) : Incorrect number of arguments for %s %s; expected %u, got %u

- OceanBase 错误码：5555
 - 兼容 MySQL 错误码：1318

## ERROR 1319 (42000) : Undefined CONDITION: %.*s

- OceanBase 错误码：5545
 - 兼容 MySQL 错误码：1319

## ERROR 1321 (2F005) : FUNCTION %s ended without RETURN

- OceanBase 错误码：5580
 - 兼容 MySQL 错误码：1321

## ERROR 1323 (42000) : Cursor SELECT must not have INTO

- OceanBase 错误码：5584
 - 兼容 MySQL 错误码：1323

## ERROR 1324 (42000) : Undefined CURSOR: %.*s

- OceanBase 错误码：5547
 - 兼容 MySQL 错误码：1324

## ERROR 1325 (24000) : Cursor is already open

- OceanBase 错误码：5589
 - 兼容 MySQL 错误码：1325

## ERROR 1326 (24000) : Cursor is not open

- OceanBase 错误码：5590
 - 兼容 MySQL 错误码：1326

## ERROR 1327 (42000) : Undeclared variable: %.*s

- OceanBase 错误码：5543
 - 兼容 MySQL 错误码：1327

## ERROR 1327 (42000) : Undeclared type: %.*s

- OceanBase 错误码：5544
 - 兼容 MySQL 错误码：1327

## ERROR 1328 (HY000) : Incorrect number of FETCH variables

- OceanBase 错误码：5554
 - 兼容 MySQL 错误码：1328

## ERROR 1330 (42000) : Duplicate parameter: %.*s

- OceanBase 错误码：5548
 - 兼容 MySQL 错误码：1330

## ERROR 1330 (42000) : Duplicate type: %.*s

- OceanBase 错误码：5550
 - 兼容 MySQL 错误码：1330

## ERROR 1330 (42000) : Duplicate label: %.*s

- OceanBase 错误码：5552
 - 兼容 MySQL 错误码：1330

## ERROR 1331 (42000) : Duplicate variable: %.*s

- OceanBase 错误码：5549
 - 兼容 MySQL 错误码：1331

## ERROR 1332 (42000) : Duplicate condition: %.*s

- OceanBase 错误码：5551
 - 兼容 MySQL 错误码：1332

## ERROR 1333 (42000) : Duplicate cursor: %.*s

- OceanBase 错误码：5553
 - 兼容 MySQL 错误码：1333

## ERROR 1336 (0A000) : %s is not allowed in stored function or trigger

- OceanBase 错误码：5569
 - 兼容 MySQL 错误码：1336

## ERROR 1337 (42000) : Variable or condition declaration after cursor or handler declaration

- OceanBase 错误码：5586
 - 兼容 MySQL 错误码：1337

## ERROR 1338 (42000) : Cursor declaration after handler declaration

- OceanBase 错误码：5587
 - 兼容 MySQL 错误码：1338

## ERROR 1339 (20000) : Case not found for CASE statement

- OceanBase 错误码：5571
 - 兼容 MySQL 错误码：1339

## ERROR 1347 (HY000) : \'%s.%s\' is not %s

- OceanBase 错误码：5214
 - 兼容 MySQL 错误码：1347

## ERROR 1348 (HY000) : Column '%.*s' is not updatable

- OceanBase 错误码：5719
 - 兼容 MySQL 错误码：1348

## ERROR 1349 (HY000) : View's SELECT contains a subquery in the FROM clause

- OceanBase 错误码：4238
 - 兼容 MySQL 错误码：1349

## ERROR 1353 (HY000) : View's SELECT and view's field list have different column counts

- OceanBase 错误码：5242
 - 兼容 MySQL 错误码：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 错误码：5231
 - 兼容 MySQL 错误码：1356

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

- OceanBase 错误码：5733
 - 兼容 MySQL 错误码：1360

## ERROR 1362 (HY000) : Updating of %s row is not allowed in %strigger

- OceanBase 错误码：9584
 - 兼容 MySQL 错误码：1362

## ERROR 1364 (HY000): Field \'%s\' doesn't have a default value

- OceanBase 错误码：4227
 - 兼容 MySQL 错误码：1364

## ERROR 1365 (42000) : Divided by zero

- OceanBase 错误码：4078
 - 兼容 MySQL 错误码：1365

## ERROR 1366 (22007) : Incorrect datetime value: '%s' for column '%s'

- OceanBase 错误码：4219
 - 兼容 MySQL 错误码：1366

## ERROR 1366 (HY000) : Incorrect integer value: '%.*s'

- OceanBase 错误码：4226
 - 兼容 MySQL 错误码：1366

## ERROR 1366 (HY000) : Incorrect string value for column '%.*s' at row %ld

- OceanBase 错误码：4258
 - 兼容 MySQL 错误码：1366

## ERROR 1367 (22007) : Illegal %s '%.*s' value found during parsing

- OceanBase 错误码：5332
 - 兼容 MySQL 错误码：1367

## ERROR 1390 (54000) : Prepared statement contains too many placeholders

- OceanBase 错误码：5080
 - 兼容 MySQL 错误码：1390

## ERROR 1391 (HY000) : Key part \'%.*s\' length cannot be 0

- OceanBase 错误码：5191
 - 兼容 MySQL 错误码：1391

## ERROR 1393 (HY000) : Can not modify more than one base table through a join view '%.*s.%.*s'

- OceanBase 错误码：5718
 - 兼容 MySQL 错误码：1393

## ERROR 1395 (HY000) : Can not delete from join view '%.*s.%.*s'

- OceanBase 错误码：5720
 - 兼容 MySQL 错误码：1395

## ERROR 1396 (HY000) : Operation %.*s failed for %.*s

- OceanBase 错误码：5155
 - 兼容 MySQL 错误码：1396

## ERROR 1397 (XAE04) : Unknown XID

- OceanBase 错误码：6245
 - 兼容 MySQL 错误码：1397

## ERROR 1398 (XAE05) : XAER_INVAL: Invalid arguments (or unsupported command)

- OceanBase 错误码：6249
 - 兼容 MySQL 错误码：1398

## ERROR 1399 (XAE07) : The command cannot be executed when global transaction is in the %s state

- OceanBase 错误码：6246
 - 兼容 MySQL 错误码：1399

## ERROR 1399 (XAE07) : RMFAIL: The command cannot be executed when global transaction is in the %s state

- OceanBase 错误码：6258
 - 兼容 MySQL 错误码：1399

## ERROR 1400 (XAE09) : Some work is done outside global transaction

- OceanBase 错误码：6248
 - 兼容 MySQL 错误码：1400

## ERROR 1401 (XAE03) : XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

- OceanBase 错误码：6250
 - 兼容 MySQL 错误码：1401

## ERROR 1402 (XA100) : XA_RBROLLBACK: Transaction branch was rolled back

- OceanBase 错误码：6252
 - 兼容 MySQL 错误码：1402

## ERROR 1440 (XAE08) : The XID already exists

- OceanBase 错误码：6247
 - 兼容 MySQL 错误码：1440

## ERROR 1406 (22001) : Data too long for column '%.*s' at row %ld

- OceanBase 错误码：5167
 - 兼容 MySQL 错误码：1406

## ERROR 1406 (22001) : Data too long for column

- OceanBase 错误码：5354
 - 兼容 MySQL 错误码：1406

## ERROR 1407 (42000) : Bad SQLSTATE: \'%.*s\'

- OceanBase 错误码：5585
 - 兼容 MySQL 错误码：1407

## ERROR 1410 (42000) : You are not allowed to create a user with GRANT

- OceanBase 错误码：5169
 - 兼容 MySQL 错误码：1410

## ERROR 1411 (HY000) : Incorrect %.*s value: '%.*s' for function %.*s

- OceanBase 错误码：5936
 - 兼容 MySQL 错误码：1411

## ERROR 1413 (42000) : Duplicate handler declared in the same block

- OceanBase 错误码：5581
 - 兼容 MySQL 错误码：1413

## ERROR 1414 (42000) : OUT or INOUT argument %d for routine %.*s is not a variable

- OceanBase 错误码：5592
 - 兼容 MySQL 错误码：1414

## ERROR 1415 (0A000) : Not allowed to return a result set in pl function

- OceanBase 错误码：5579
 - 兼容 MySQL 错误码：1415

## ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger

- OceanBase 错误码：5576
 - 兼容 MySQL 错误码：1422

## ERROR 1424 (HY000) : Recursive stored functions are not allowed

- OceanBase 错误码：5570
 - 兼容 MySQL 错误码：1424

## ERROR 1425 (42000) : Too big scale %d specified for column '%s'. Maximum is %ld

- OceanBase 错误码：5202
 - 兼容 MySQL 错误码：1425

## ERROR 1426 (42000) : Too big precision %d specified for column '%s'. Maximum is %ld

- OceanBase 错误码：5203
 - 兼容 MySQL 错误码：1426

## ERROR 1427 (42000) : For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s')

- OceanBase 错误码：5204
 - 兼容 MySQL 错误码：1427

## ERROR 1435 (HY000) : Trigger in wrong schema

- OceanBase 错误码：9582
 - 兼容 MySQL 错误码：1435

## ERROR 1439 (42000) : Display width out of range for column '%s' (max = %ld)

- OceanBase 错误码：5205
 - 兼容 MySQL 错误码：1439

## ERROR 1441 (22008) : Datetime overflow

- OceanBase 错误码：4261
 - 兼容 MySQL 错误码：1441

## ERROR 1445 (HY000) : Not allowed to set autocommit from a stored function or trigger

- OceanBase 错误码：5591
 - 兼容 MySQL 错误码：1445

## ERROR 1449 (01007) : User not exist

- OceanBase 错误码：5035
 - 兼容 MySQL 错误码：1449

## ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails

- OceanBase 错误码：5314
 - 兼容 MySQL 错误码：1451

## ERROR 1451 (23000) : Cannot delete or update a parent row: a foreign key constraint fails

- OceanBase 错误码：5618
 - 兼容 MySQL 错误码：1451

## ERROR 1452 (23000) : Cannot add or update a child row: a foreign key constraint fails

- OceanBase 错误码：5315
 - 兼容 MySQL 错误码：1452

## ERROR 1456 (HY000) : Recursive limit %ld (as set by the max_sp_recursion_depth variable) was exceeded for routine

- OceanBase 错误码：5567
 - 兼容 MySQL 错误码：1456

## ERROR 1458 (42000) : Incorrect routine name \'%.*s\'

- OceanBase 错误码：5588
 - 兼容 MySQL 错误码：1458

## ERROR 1462 (42S02) : \'%.*s'.'%.*s\' contains view recursion

- OceanBase 错误码：5239
 - 兼容 MySQL 错误码：1462

## ERROR 1466 (HY000) : Leading spaces are removed from name \'%.*s\'

- OceanBase 错误码：5247
 - 兼容 MySQL 错误码：1466

## ERROR 1467 (HY000) : Failed to read auto-increment value from storage engine

- OceanBase 错误码：5184
 - 兼容 MySQL 错误码：1467

## ERROR 1470 (HY000) : String '%.*s' is too long for user name (should be no longer than 16)

- OceanBase 错误码：5181
 - 兼容 MySQL 错误码：1470

## ERROR 1471 (HY000) : The target table %.*s of the INSERT is not insertable-into

- OceanBase 错误码：5717
 - 兼容 MySQL 错误码：1471

## ERROR 1474 (HY000) : Name \'%.*s\' has become ''

- OceanBase 错误码：5246
 - 兼容 MySQL 错误码：1474

## ERROR 1475 (42000) : Ambiguous column

- OceanBase 错误码：5015
 - 兼容 MySQL 错误码：1475

## ERROR 1486 (HY000) : Constant or random or timezone-dependent expressions in sub)partitioning function are not allowed

- OceanBase 错误码：5230
 - 兼容 MySQL 错误码：1486

## ERROR 1488 (HY000) : Field in list of fields for partition function not found in table

- OceanBase 错误码：5255
 - 兼容 MySQL 错误码：1488

## ERROR 1491 (HY000) : The PARTITION function returns the wrong type

- OceanBase 错误码：5257
 - 兼容 MySQL 错误码：1491

## ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition%.*s

- OceanBase 错误码：5281
 - 兼容 MySQL 错误码：1493

## ERROR 1493 (HY000) : VALUES LESS THAN value must be strictly increasing for each partition

- OceanBase 错误码：5353
 - 兼容 MySQL 错误码：1493

## ERROR 1495 (HY000) : Multiple definition of same constant in list partitioning

- OceanBase 错误码：5340
 - 兼容 MySQL 错误码：1495

## ERROR 1499 (HY000) : Too many partitions (including subpartitions) were defined

- OceanBase 错误码：5188
 - 兼容 MySQL 错误码：1499

## ERROR 1503 (HY000) : A %s must include all columns in the table's partitioning function

- OceanBase 错误码：5261
 - 兼容 MySQL 错误码：1503

## ERROR 1503 (HY000) : A PRIMARY KEY must include all columns in the table\'s partitioning function

- OceanBase 错误码：5283
 - 兼容 MySQL 错误码：1503

## ERROR 1504 (HY000) : Number of partitions = 0 is not an allowed value

- OceanBase 错误码：5189
 - 兼容 MySQL 错误码：1504

## ERROR 1505 (HY000) : Partition management on a not partitioned table is not possible

- OceanBase 错误码：5302
 - 兼容 MySQL 错误码：1505

## ERROR 1507 (HY000) : Error in list of partitions to %s

- OceanBase 错误码：5303
 - 兼容 MySQL 错误码：1507

## ERROR 1508 (HY000) : Cannot remove all partitions, use DROP TABLE instead

- OceanBase 错误码：5306
 - 兼容 MySQL 错误码：1508

## ERROR 1512 (HY000) : %s PARTITION can only be used on RANGE/LIST partitions

- OceanBase 错误码：5305
 - 兼容 MySQL 错误码：1512

## ERROR 1517 (HY000) : Duplicate partition name \'%.*s\'

- OceanBase 错误码：5280
 - 兼容 MySQL 错误码：1517

## ERROR 1520 (HY000) : Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range

- OceanBase 错误码：5566
 - 兼容 MySQL 错误码：1520

## ERROR 1525 (HY000) : Incorrect %s value: '%s'

- OceanBase 错误码：5241
 - 兼容 MySQL 错误码：1525

## ERROR 1526 (HY000) : Table has no partition for value

- OceanBase 错误码：5284
 - 兼容 MySQL 错误码：1526

## ERROR 1562 (HY000) : Cannot create temporary table with partitions

- OceanBase 错误码：5310
 - 兼容 MySQL 错误码：1562

## ERROR 1563 (HY000) : Partition constant is out of partition function domain

- OceanBase 错误码：5286
 - 兼容 MySQL 错误码：1563

## ERROR 1564 (HY000) : This partition function is not allowed

- OceanBase 错误码：5262
 - 兼容 MySQL 错误码：1564

## ERROR 1566 (HY000) : Not allowed to use NULL value in VALUES LESS THAN

- OceanBase 错误码：5285
 - 兼容 MySQL 错误码：1566

## ERROR 1568 (25001) : Transaction characteristics can't be changed while a transaction is in progress

- OceanBase 错误码：5219
 - 兼容 MySQL 错误码：1568

## ERROR 1582 (42000) : Incorrect parameter count in the call to native function '%.*s'

- OceanBase 错误码：5054
 - 兼容 MySQL 错误码：1582

## ERROR 1613 (XA106) : XA_RBTIMEOUT: Transaction branch was rolled back: took too long

- OceanBase 错误码：6253
 - 兼容 MySQL 错误码：1613

## ERROR 1621 (HY000) : variable is read only", "%.*s variable '%.*s' is read-only. Use SET %.*s to assign the value

- OceanBase 错误码：5102
 - 兼容 MySQL 错误码：1621

## ERROR 1628 (HY000) : Comment for table is too long (max = %ld)

- OceanBase 错误码：4229
 - 兼容 MySQL 错误码：1628

## ERROR 1629 (HY000) : Comment for field is too long (max = %ld)

- OceanBase 错误码：4230
 - 兼容 MySQL 错误码：1629

## ERROR 1644 (HY000) : Unhandled user-defined exception condition

- OceanBase 错误码：5556
 - 兼容 MySQL 错误码：1644

## ERROR 1646 (HY000) : SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

- OceanBase 错误码：5557
 - 兼容 MySQL 错误码：1646

## ERROR 1652 (HY000) : Duplicate partition field name '%.*s'

- OceanBase 错误码：5237
 - 兼容 MySQL 错误码：1652

## ERROR 1653 (HY000) : Inconsistency in usage of column lists for partitioning

- OceanBase 错误码：5276
 - 兼容 MySQL 错误码：1653

## ERROR 1654 (HY000) : Partition column values of incorrect type

- OceanBase 错误码：5275
 - 兼容 MySQL 错误码：1654

## ERROR 1654 (HY000) : Partition column values of incorrect type

- OceanBase 错误码：5349
 - 兼容 MySQL 错误码：1654

## ERROR 1654 (HY000) : Partition column values of incorrect type

- OceanBase 错误码：5355
 - 兼容 MySQL 错误码：1654

## ERROR 1655 (HY000) : Too many fields in \'list of partition fields\'

- OceanBase 错误码：5287
 - 兼容 MySQL 错误码：1655

## ERROR 1657 (HY000) : Cannot have more than one value for this type of RANGE partitioning

- OceanBase 错误码：5277
 - 兼容 MySQL 错误码：1657

## ERROR 1659 (HY000) : Field \'%.*s\' is of a not allowed type for this type of partitioning

- OceanBase 错误码：5178
 - 兼容 MySQL 错误码：1659

## ERROR 1688 (HY000) : Comment for index is too long (max = %ld)

- OceanBase 错误码：4231
 - 兼容 MySQL 错误码：1688

## ERROR 1690 (22003) ：%s value is out of range in '%s'

- OceanBase 错误码：4157
 - 兼容 MySQL 错误码：1690

## ERROR 1697 (HY000) : VALUES value for partition \'%.*s\' must have type INT

- OceanBase 错误码：5274
 - 兼容 MySQL 错误码：1697

## ERROR 1701 (42000) : Cannot truncate a table referenced in a foreign key constraint %.*s

- OceanBase 错误码：5594
 - 兼容 MySQL 错误码：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 错误码：5344
 - 兼容 MySQL 错误码：1706

## ERROR 1708 (HY000) : The value of \'%s\' should be no less than the value of \'%s\'

- OceanBase 错误码：5266
 - 兼容 MySQL 错误码：1708

## ERROR 1735 (HY000) : Unkown partition '%.*s' in table '%.*s'

- OceanBase 错误码：5146
 - 兼容 MySQL 错误码：1735

## ERROR 1748 (HY000) : Found a row not matching the given partition set

- OceanBase 错误码：5147
 - 兼容 MySQL 错误码：1748

## ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction

- OceanBase 错误码：5220
 - 兼容 MySQL 错误码：1792

## ERROR 1792 (25006) : Cannot execute statement in a READ ONLY transaction

- OceanBase 错误码：6226
 - 兼容 MySQL 错误码：1792

## ERROR 1819 (HY000) : Your password does not satisfy the current policy requirements

- OceanBase 错误码：4365
 - 兼容 MySQL 错误码：1819

## ERROR 1820 (HY000) : You must reset your password using ALTER USER statement before executing this statement

- OceanBase 错误码：4366
 - 兼容 MySQL 错误码：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 错误码：5227
 - 兼容 MySQL 错误码：1827

## ERROR 1869 (HY000) : Auto-increment value in UPDATE conflicts with internally generated values

- OceanBase 错误码：5244
 - 兼容 MySQL 错误码：1869

## ERROR 1882 (HY000) : The initialization vector supplied to aes_encrypt is too short. Must be at least 16 bytes long

- OceanBase 错误码：4336
 - 兼容 MySQL 错误码：1882

## ERROR 3020 (2201E) : Invalid argument for logarithm

- OceanBase 错误码：5565
 - 兼容 MySQL 错误码：3020

## ERROR 3028 (HY000) : Expression #%d of ORDER BY contains aggregate function and applies to a UNION

- OceanBase 错误码：5263
 - 兼容 MySQL 错误码：3028

## ERROR 3105 (HY000) : The value specified for generated column '%.*s' in table '%.*s' is not allowed

- OceanBase 错误码：5290
 - 兼容 MySQL 错误码：3105

## ERROR 3106 (HY000) : '%s' is not supported for generated columns

- OceanBase 错误码：5292
 - 兼容 MySQL 错误码：3106

## ERROR 3108 (HY000) : Column '%.*s' has a generated column dependency

- OceanBase 错误码：5293
 - 兼容 MySQL 错误码：3108

## ERROR 3118 (HY000) : User locked

- OceanBase 错误码：5039
 - 兼容 MySQL 错误码：3118

## ERROR 3504 (HY000) : Too many enumeration valuesfor column %.*s

- OceanBase 错误码：5335
 - 兼容 MySQL 错误码：3504

## ERROR 3505 (HY000) : Too long enumeration/setvalue for column %.*s.

- OceanBase 错误码：5333
 - 兼容 MySQL 错误码：3505

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线
