7.2.2.2 Application error Errors

The following table lists and describes NDB Application errorerrors (error type AE).

Table 7.2 This table describes NDB API Application error errors

NDB Error Code MySQL Error Code NDB Error Type Error Message
QRY_REQ_ARG_IS_NULL DMEC AE Required argument is NULL
QRY_TOO_FEW_KEY_VALUES DMEC AE All required 'key' values was not specified
QRY_TOO_MANY_KEY_VALUES DMEC AE Too many 'key' or 'bound' values was specified
QRY_OPERAND_HAS_WRONG_TYPE DMEC AE Incompatible datatype specified in operand argument
QRY_CHAR_OPERAND_TRUNCATED DMEC AE Character operand was right truncated
QRY_NUM_OPERAND_RANGE DMEC AE Numeric operand out of range
QRY_MULTIPLE_PARENTS DMEC AE Multiple 'parents' specified in linkedValues for this operation
QRY_UNKNOWN_PARENT DMEC AE Unknown 'parent' specified in linkedValue
QRY_UNRELATED_INDEX DMEC AE Specified 'index' does not belong to specified 'table'
QRY_WRONG_INDEX_TYPE DMEC AE Wrong type of index specified for this operation
QRY_OPERAND_ALREADY_BOUND DMEC AE Can't use same operand value to specify different column values
QRY_DEFINITION_TOO_LARGE DMEC AE Query definition too large.
QRY_RESULT_ROW_ALREADY_DEFINED DMEC AE Result row already defined for NdbQueryOperation.
QRY_HAS_ZERO_OPERATIONS DMEC AE Query defintion should have at least one operation.
QRY_IN_ERROR_STATE DMEC AE A previous query operation failed, which you missed to catch.
QRY_ILLEGAL_STATE DMEC AE Query is in illegal state for this operation.
QRY_WRONG_OPERATION_TYPE DMEC AE This method cannot be invoked on this type of operation (lookup/scan/index scan).
QRY_SCAN_ORDER_ALREADY_SET DMEC AE Index scan order was already set in query definition.
QRY_PARAMETER_HAS_WRONG_TYPE DMEC AE Parameter value has an incompatible datatype
QRY_CHAR_PARAMETER_TRUNCATED DMEC AE Character Parameter was right truncated
QRY_MULTIPLE_SCAN_SORTED DMEC AE Query with multiple scans may not be sorted.
QRY_SEQUENTIAL_SCAN_SORTED DMEC AE Parallelism cannot be restricted for sorted scans.
QRY_BATCH_SIZE_TOO_SMALL DMEC AE Batch size for sub scan cannot be smaller than number of fragments.
QRY_EMPTY_PROJECTION DMEC AE Query has operation with empty projection.
NO_CONTACT_WITH_PROCESS DMEC AE No contact with the process (dead ?).
WRONG_PROCESS_TYPE DMEC AE The process has wrong type. Expected a DB process.
SEND_OR_RECEIVE_FAILED DMEC AE Send to process or receive failed.
INVALID_ERROR_NUMBER DMEC AE Invalid error number. Should be >= 0.
INVALID_TRACE_NUMBER DMEC AE Invalid trace number.
INVALID_BLOCK_NAME DMEC AE Invalid block name
NODE_SHUTDOWN_IN_PROGESS DMEC AE Node shutdown in progress
SYSTEM_SHUTDOWN_IN_PROGRESS DMEC AE System shutdown in progress
NODE_SHUTDOWN_WOULD_CAUSE_SYSTEM_CRASH DMEC AE Node shutdown would cause system crash
UNSUPPORTED_NODE_SHUTDOWN DMEC AE Unsupported multi node shutdown. Abort option required.
NODE_NOT_API_NODE DMEC AE The specified node is not an API node.
OPERATION_NOT_ALLOWED_START_STOP DMEC AE Operation not allowed while nodes are starting or stopping.
NO_CONTACT_WITH_DB_NODES DMEC AE No contact with database nodes }
242 DMEC AE Zero concurrency in scan
244 DMEC AE Too high concurrency in scan
261 DMEC AE DML count in transaction exceeds config parameter MaxDMLOperationsPerTransaction
269 DMEC AE No condition and attributes to read in scan
281 HA_ERR_NO_CONNECTION AE Operation not allowed due to cluster shutdown in progress
299 DMEC AE Operation not allowed or aborted due to single user mode
311 DMEC AE Undefined partition used in setPartitionId
320 DMEC AE Invalid no of nodes specified for new nodegroup
321 DMEC AE Invalid nodegroup id
322 DMEC AE Invalid node(s) specified for new nodegroup, node already in nodegroup
323 DMEC AE Invalid nodegroup id, nodegroup already existing
324 DMEC AE Invalid node(s) specified for new nodegroup, no node in nodegroup is started
417 DMEC AE Bad operation reference - double unlock
720 DMEC AE Attribute name reused in table definition
763 DMEC AE DDL is not supported with mixed data-node versions
771 HA_WRONG_CREATE_OPTION AE Given NODEGROUP doesn't exist in this cluster
776 DMEC AE Index created on temporary table must itself be temporary
777 DMEC AE Cannot create a temporary index on a non-temporary table
778 DMEC AE A temporary table or index must be specified as not logging
789 HA_WRONG_CREATE_OPTION AE Logfile group not found
793 DMEC AE Object definition too big
794 DMEC AE Schema feature requires data node upgrade
823 DMEC AE Too much attrinfo from application in tuple manager
829 DMEC AE Corrupt data received for insert/update
831 DMEC AE Too many nullable/bitfields in table definition
850 DMEC AE Too long or too short default value
851 DMEC AE Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNAMIC instead
874 DMEC AE Too much attrinfo (e.g. scan filter) for scan in tuple manager
876 DMEC AE 876
877 DMEC AE 877
878 DMEC AE 878
879 DMEC AE 879
880 DMEC AE Tried to read too much - too many getValue calls
884 DMEC AE Stack overflow in interpreter
885 DMEC AE Stack underflow in interpreter
886 DMEC AE More than 65535 instructions executed in interpreter
892 DMEC AE Unsupported type in scan filter
897 DMEC AE Update attempt of primary key via ndbcluster internal api (if this occurs via the MySQL server it is a bug, please report)
913 DMEC AE Invalid index for index stats update
920 DMEC AE Row operation defined after refreshTuple()
1233 DMEC AE Table read-only
1302 DMEC AE A backup is already running
1306 DMEC AE Backup not supported in diskless mode (change Diskless)
1329 DMEC AE Backup during software upgrade not supported
1342 DMEC AE Backup failed to allocate buffers (check configuration)
1343 DMEC AE Backup failed to setup fs buffers (check configuration)
1344 DMEC AE Backup failed to allocate tables (check configuration)
1345 DMEC AE Backup failed to insert file header (check configuration)
1346 DMEC AE Backup failed to insert table list (check configuration)
1347 DMEC AE Backup failed to allocate table memory (check configuration)
1348 DMEC AE Backup failed to allocate file record (check configuration)
1349 DMEC AE Backup failed to allocate attribute record (check configuration)
1701 DMEC AE Node already reserved
1702 DMEC AE Node already connected
1704 DMEC AE Node type mismatch
4004 DMEC AE Attribute name or id not found in the table
4100 DMEC AE Status Error in NDB
4101 DMEC AE No connections to NDB available and connect failed
4102 DMEC AE Type in NdbTamper not correct
4103 DMEC AE No schema connections to NDB available and connect failed
4104 DMEC AE Ndb Init in wrong state, destroy Ndb object and create a new
4105 DMEC AE Too many Ndb objects
4106 DMEC AE All Not NULL attribute have not been defined
4114 DMEC AE Transaction is already completed
4116 DMEC AE Operation was not defined correctly, probably missing a key
4117 DMEC AE Could not start transporter, configuration error
4118 DMEC AE Parameter error in API call
4120 DMEC AE Scan already complete
4121 DMEC AE Cannot set name twice for an Ndb object
4122 DMEC AE Cannot set name after Ndb object is initialised
4200 DMEC AE Status Error when defining an operation
4201 DMEC AE Variable Arrays not yet supported
4202 DMEC AE Set value on tuple key attribute is not allowed
4203 DMEC AE Trying to set a NOT NULL attribute to NULL
4204 DMEC AE Set value and Read/Delete Tuple is incompatible
4205 DMEC AE No Key attribute used to define tuple
4206 DMEC AE Not allowed to equal key attribute twice
4207 DMEC AE Key size is limited to 4092 bytes
4208 DMEC AE Trying to read a non-stored attribute
4209 DMEC AE Length parameter in equal/setValue is incorrect
4210 DMEC AE Ndb sent more info than the length he specified
4211 DMEC AE Inconsistency in list of NdbRecAttr-objects
4212 DMEC AE Ndb reports NULL value on Not NULL attribute
4213 DMEC AE Not all data of an attribute has been received
4214 DMEC AE Not all attributes have been received
4215 DMEC AE More data received than reported in TCKEYCONF message
4216 DMEC AE More than 8052 bytes in setValue cannot be handled
4217 DMEC AE It is not allowed to increment any other than unsigned ints
4218 DMEC AE Currently not allowed to increment NULL-able attributes
4219 DMEC AE Maximum size of interpretative attributes are 64 bits
4220 DMEC AE Maximum size of interpretative attributes are 64 bits
4221 DMEC AE Trying to jump to a non-defined label
4222 DMEC AE Label was not found, internal error
4223 DMEC AE Not allowed to create jumps to yourself
4224 DMEC AE Not allowed to jump to a label in a different subroutine
4225 DMEC AE All primary keys defined, call setValue/getValue
4226 DMEC AE Bad number when defining a label
4227 DMEC AE Bad number when defining a subroutine
4228 DMEC AE Illegal interpreter function in scan definition
4229 DMEC AE Illegal register in interpreter function definition
4230 DMEC AE Illegal state when calling getValue, probably not a read
4231 DMEC AE Illegal state when calling interpreter routine
4232 DMEC AE Parallelism can only be between 1 and 240
4233 DMEC AE Calling execute (synchronous) when already prepared asynchronous transaction exists
4234 DMEC AE Illegal to call setValue in this state
4235 DMEC AE No callback from execute
4236 DMEC AE Trigger name too long
4237 DMEC AE Too many triggers
4238 DMEC AE Trigger not found
4239 DMEC AE Trigger with given name already exists
4240 DMEC AE Unsupported trigger type
4241 DMEC AE Index name too long
4242 DMEC AE Too many indexes
4243 DMEC AE Index not found
4247 DMEC AE Illegal index/trigger create/drop/alter request
4248 DMEC AE Trigger/index name invalid
4249 DMEC AE Invalid table
4250 DMEC AE Invalid index type or index logging option
4251 HA_ERR_FOUND_DUPP_UNIQUE AE Cannot create unique index, duplicate keys found
4252 DMEC AE Failed to allocate space for index
4253 DMEC AE Failed to create index table
4254 DMEC AE Table not an index table
4255 DMEC AE Hash index attributes must be specified in same order as table attributes
4256 DMEC AE Must call Ndb::init() before this function
4257 DMEC AE Tried to read too much - too many getValue calls
4258 DMEC AE Cannot create unique index, duplicate attributes found in definition
4259 DMEC AE Invalid set of range scan bounds
4264 DMEC AE Invalid usage of blob attribute
4265 DMEC AE The method is not valid in current blob state
4266 DMEC AE Invalid blob seek position
4271 DMEC AE Invalid index object, not retrieved via getIndex()
4272 DMEC AE Table definition has undefined column
4275 DMEC AE The blob method is incompatible with operation type or lock mode
4276 DMEC AE Missing NULL ptr in end of keyData list
4277 DMEC AE Key part len is to small for column
4278 DMEC AE Supplied buffer to small
4279 DMEC AE Malformed string
4280 DMEC AE Inconsistent key part length
4281 DMEC AE Too many keys specified for key bound in scanIndex
4282 DMEC AE range_no not strictly increasing in ordered multi-range index scan
4283 DMEC AE key_record in index scan is not an index ndbrecord
4284 DMEC AE Cannot mix NdbRecAttr and NdbRecord methods in one operation
4285 DMEC AE NULL NdbRecord pointer
4286 DMEC AE Invalid range_no (must be < 4096)
4287 DMEC AE The key_record and attribute_record in primary key operation do not belong to the same table
4288 DMEC AE Blob handle for column not available
4289 DMEC AE API version mismatch or wrong sizeof(NdbDictionary::RecordSpecification)
4290 DMEC AE Missing column specification in NdbDictionary::RecordSpecification
4291 DMEC AE Duplicate column specification in NdbDictionary::RecordSpecification
4292 DMEC AE NdbRecord for tuple access is not an index key NdbRecord
4293 DMEC AE Error returned from application scanIndex() callback
4294 DMEC AE Scan filter is too large, discarded
4295 DMEC AE Column is NULL in Get/SetValueSpec structure
4296 DMEC AE Invalid AbortOption
4297 DMEC AE Invalid or unsupported OperationOptions structure
4298 DMEC AE Invalid or unsupported ScanOptions structure
4299 DMEC AE Incorrect combination of ScanOption flags, extraGetValues ptr and numExtraGetValues
4300 DMEC AE Tuple Key Type not correct
4301 DMEC AE Fragment Type not correct
4302 DMEC AE Minimum Load Factor not correct
4303 DMEC AE Maximum Load Factor not correct
4304 DMEC AE Maximum Load Factor smaller than Minimum
4305 DMEC AE K value must currently be set to 6
4306 DMEC AE Memory Type not correct
4307 DMEC AE Invalid table name
4308 DMEC AE Attribute Size not correct
4309 DMEC AE Fixed array too large, maximum 64000 bytes
4310 DMEC AE Attribute Type not correct
4311 DMEC AE Storage Mode not correct
4312 DMEC AE Null Attribute Type not correct
4313 DMEC AE Index only storage for non-key attribute
4314 DMEC AE Storage Type of attribute not correct
4315 DMEC AE No more key attributes allowed after defining variable length key attribute
4316 DMEC AE Key attributes are not allowed to be NULL attributes
4317 DMEC AE Too many primary keys defined in table
4318 DMEC AE Invalid attribute name or number
4319 DMEC AE createAttribute called at erroneus place
4322 DMEC AE Attempt to define distribution key when not prepared to
4323 DMEC AE Distribution Key set on table but not defined on first attribute
4324 DMEC AE Attempt to define distribution group when not prepared to
4325 DMEC AE Distribution Group set on table but not defined on first attribute
4326 DMEC AE Distribution Group with erroneus number of bits
4327 DMEC AE Distribution key is only supported on part of primary key
4328 DMEC AE Disk memory attributes not yet supported
4329 DMEC AE Variable stored attributes not yet supported
4335 DMEC AE Only one autoincrement column allowed per table. Having a table without primary key uses an autoincremented hidden key, i.e. a table without a primary key can not have an autoincremented column
4340 DMEC AE Result or attribute record must be a base table ndbrecord, not an index ndbrecord
4341 DMEC AE Not all keys read when using option SF_OrderBy
4400 DMEC AE Status Error in NdbSchemaCon
4401 DMEC AE Only one schema operation per schema transaction
4402 DMEC AE No schema operation defined before calling execute
4410 DMEC AE Schema transaction is already started
4411 DMEC AE Schema transaction not possible until upgrade complete
4501 DMEC AE Insert in hash table failed when getting table information from Ndb
4502 DMEC AE GetValue not allowed in Update operation
4503 DMEC AE GetValue not allowed in Insert operation
4504 DMEC AE SetValue not allowed in Read operation
4505 DMEC AE NULL value not allowed in primary key search
4506 DMEC AE Missing getValue/setValue when calling execute
4507 DMEC AE Missing operation request when calling execute
4508 DMEC AE GetValue not allowed for NdbRecord defined operation
4509 DMEC AE Non SF_MultiRange scan cannot have more than one bound
4510 DMEC AE User specified partition id not allowed for scan takeover operation
4511 DMEC AE Blobs not allowed in NdbRecord delete result record
4512 DMEC AE Incorrect combination of OperationOptions optionsPresent, extraGet/SetValues ptr and numExtraGet/SetValues
4513 DMEC AE Only one scan bound allowed for non-NdbRecord setBound() API
4514 DMEC AE Can only call setBound/equal() for an NdbIndexScanOperation
4515 DMEC AE Method not allowed for NdbRecord, use OperationOptions or ScanOptions structure instead
4516 DMEC AE Illegal instruction in interpreted program
4517 DMEC AE Bad label in branch instruction
4518 DMEC AE Too many instructions in interpreted program
4519 DMEC AE NdbInterpretedCode::finalise() not called
4520 DMEC AE Call to undefined subroutine
4521 DMEC AE Call to undefined subroutine, internal error
4522 DMEC AE setBound() called twice for same key
4523 DMEC AE Pseudo columns not supported by NdbRecord
4524 DMEC AE NdbInterpretedCode is for different table
4535 DMEC AE Attempt to set bound on non key column
4536 DMEC AE NdbScanFilter constructor taking NdbOperation is not supported for NdbRecord
4537 DMEC AE Wrong API. Use NdbInterpretedCode for NdbRecord operations
4538 DMEC AE NdbInterpretedCode instruction requires that table is set
4539 DMEC AE NdbInterpretedCode not supported for operation type
4540 DMEC AE Attempt to pass an Index column to createRecord. Use base table columns only
4542 DMEC AE Unknown partition information type
4543 DMEC AE Duplicate partitioning information supplied
4544 DMEC AE Wrong partitionInfo type for table
4545 DMEC AE Invalid or Unsupported PartitionInfo structure
4546 DMEC AE Explicit partitioning info not allowed for table and operation
4547 DMEC AE RecordSpecification has overlapping offsets
4548 DMEC AE RecordSpecification has too many elements
4549 DMEC AE getLockHandle only supported for primary key read with a lock
4550 DMEC AE Cannot releaseLockHandle until operation executed
4551 DMEC AE NdbLockHandle already released
4552 DMEC AE NdbLockHandle does not belong to transaction
4553 DMEC AE NdbLockHandle original operation not executed successfully
4554 DMEC AE NdbBlob can only be closed from Active state
4555 DMEC AE NdbBlob cannot be closed with pending operations
4600 DMEC AE Transaction is already started
4601 DMEC AE Transaction is not started
4602 DMEC AE You must call getNdbOperation before executeScan
4603 DMEC AE There can only be ONE operation in a scan transaction
4604 DMEC AE takeOverScanOp, to take over a scanned row one must explicitly request keyinfo on readTuples call
4605 DMEC AE You may only call readTuples() once for each operation
4607 DMEC AE There may only be one operation in a scan transaction
4608 DMEC AE You can not takeOverScan unless you have used openScanExclusive
4609 DMEC AE You must call nextScanResult before trying to takeOverScan
4707 DMEC AE Too many event have been defined
4708 DMEC AE Event name is too long
4709 DMEC AE Can't accept more subscribers
4710 DMEC AE Event not found
4711 DMEC AE Creation of event failed
4712 DMEC AE Stopped event operation does not exist. Already stopped?
4714 DMEC AE Index stats sys tables NDB_INDEX_STAT_PREFIX do not exist
4715 DMEC AE Index stats for specified index do not exist
4716 DMEC AE Index stats methods usage error
4717 DMEC AE Index stats cannot allocate memory
4720 DMEC AE Index stats sys tables NDB_INDEX_STAT_PREFIX partly missing or invalid
4723 DMEC AE Mysqld: index stats request ignored due to recent error
4724 DMEC AE Mysqld: index stats request aborted by stats thread
4725 DMEC AE Index stats were deleted by another process
21000 HA_ERR_CANNOT_ADD_FOREIGN AE Create foreign key failed - parent key is primary key and on-update-cascade is not allowed
21026 HA_ERR_CANNOT_ADD_FOREIGN AE Create foreign key failed in NDB - parent index is not unique index
21040 DMEC AE Drop foreign key failed in NDB - foreign key not found
21060 DMEC AE Build foreign key failed in NDB - foreign key not found
21081 HA_ERR_DROP_INDEX_FK AE Drop index not allowed in NDB - used as parent index of a foreign key
21082 HA_ERR_DROP_INDEX_FK AE Drop index not allowed in NDB - used as child index of a foreign key
21090 HA_ERR_CANNOT_ADD_FOREIGN AE Create foreign key failed in NDB - name contains invalid character (/)