Error Code

In MatrixOne, the error information is classified according to the error code. A specific type of error code will be unified into a specific error code for troubleshooting. All messages sent by the MatrixOne database service are assigned a five-character error code, which contains both the type of error code and the specific category of error code.

During actual use, you can first check the error code and use the text error message attached to the error code to determine what kind of error occurred. Error encodings do not change across versions and do not change due to the localization of error messages.

Note

The SQL standard defines some of the error codes generated by MatrixOne; some additional error codes for conditions not defined by the standard were invented or borrowed from other databases.

Error encoding headType
201Internal Error
202Number and function error
203Invalid Operation
204Unknown Error or IO Error
205RPC Timeout
206Transaction Error or Storage Engine Error

For more information on the details of these errors, please refer to the following table:

Error codeError numberDescriptionError type
20100ErrStartinternal error code startInternal error
20101ErrInternalInternal errorInternal error
20103ErrNYInot yet implementedInternal error
20104ErrOOMout of memoryInternal error
20105ErrQueryInterruptedquery interruptedInternal error
20106ErrNotSupportednot supportedInternal error
20200ErrDivByZerodivision by zeroNumbers and functions
20201ErrOutOfRangedata out of rangeNumbers and functions
20202ErrDataTruncateddata truncatedNumbers and functions
20203ErrInvalidArginvalid argumentNumbers and functions
20204ErrTruncatedWrongValueForFieldtruncated wrong value for columnNumbers and functions
20300ErrBadConfiginvalid configurationInvalid operation
20301ErrInvalidInputinvalid inputInvalid operation
20302ErrSyntaxErrorSQL syntax errorInvalid operation
20303ErrParseErrorSQL parser errorInvalid operation
20304ErrConstraintViolationconstraint violationInvalid operation
20305ErrDuplicatetae data duplicatedInvalid operation
20306ErrRoleGrantedToSelfcannot grant roleInvalid operation
20307ErrDuplicateEntryduplicate entry for keyInvalid operation
20400ErrInvalidStateinvalid stateUnknown status or I/O error
20401ErrLogServiceNotReadylog service not readyUnknown status or I/O error
20402ErrBadDBinvalid databaseUnknown status or I/O error
20403ErrNoSuchTableno such tableUnknown status or I/O error
20404ErrEmptyVectorempty vectorUnknown status or I/O error
20405ErrFileNotFoundfile is not foundUnknown status or I/O error
20406ErrFileAlreadyExistsfile alread existsUnknown status or I/O error
20407ErrUnexpectedEOFunexpteded end of fileUnknown status or I/O error
20408ErrEmptyRangeempty range of fileUnknown status or I/O error
20409ErrSizeNotMatchfile size does not matchUnknown status or I/O error
20410ErrNoProgressfile has no io progressUnknown status or I/O error
20411ErrInvalidPathinvalid file pathUnknown status or I/O error
20412ErrShortWritefile io short writeUnknown status or I/O error
20413ErrInvalidWritefile io invalid writeUnknown status or I/O error
20414ErrShortBufferfile io short bufferUnknown status or I/O error
20415ErrNoDBnot connect to a databaseUnknown status or I/O error
20416ErrNoWorkingStoreno working storeUnknown status or I/O error
20417ErrNoHAKeepercannot locate ha keeperUnknown status or I/O error
20418ErrInvalidTruncateLsninvalid truncate lsn, shard already truncatedUnknown status or I/O error
20419ErrNotLeaseHoldernot lease holder, current lease holder ID xxxUnknown status or I/O error
20420ErrDBAlreadyExistsdatabase already existsUnknown status or I/O error
20421ErrTableAlreadyExiststable already existsUnknown status or I/O error
20422ErrNoServiceservice not foundUnknown status or I/O error
20423ErrDupServiceNameduplicate service nameUnknown status or I/O error
20424ErrWrongServicewrong service, expecting A, got BUnknown status or I/O error
20425ErrBadS3Configbad s3 configUnknown status or I/O error
20426ErrBadViewinvalid viewUnknown status or I/O error
20427ErrInvalidTaskinvalid taskUnknown status or I/O error
20428ErrInvalidServiceIndexinvalid service idxUnknown status or I/O error
20429ErrDragonboatTimeoutDragonboat timeoutUnknown status or I/O error
20430ErrDragonboatTimeoutTooSmallDragonboat timeout too smallUnknown status or I/O error
20431ErrDragonboatInvalidDeadlineDragonboat invalid deadlineUnknown status or I/O error
20432ErrDragonboatRejectedDragonboat rejectedUnknown status or I/O error
20433ErrDragonboatInvalidPayloadSizeinvalid payload sizeUnknown status or I/O error
20434ErrDragonboatShardNotReadyshard not readyUnknown status or I/O error
20435ErrDragonboatSystemClosedDragonboat system closedUnknown status or I/O error
20436ErrDragonboatInvalidRangeDragonboat invalid rangeUnknown status or I/O error
20437ErrDragonboatShardNotFoundshard not foundUnknown status or I/O error
20438ErrDragonboatOtherSystemErrorother system errorUnknown status or I/O error
20439ErrDropNonExistsDBCan’t drop database ; database doesn’t existUnknown status or I/O error
20500ErrRPCTimeoutrpc timeoutRPC Timeout
20501ErrClientClosedclient closedRPC Timeout
20502ErrBackendClosedbackend closedRPC Timeout
20503ErrStreamClosedstream closedRPC Timeout
20504ErrNoAvailableBackendno available backendRPC Timeout
20600ErrTxnClosedthe transaction has been committed or abortedTransaction
20601ErrTxnWriteConflicttransaction write conflictTransaction
20602ErrMissingTxnmissing transactionTransaction
20603ErrUnresolvedConflictunresolved conflictTransaction
20604ErrTxnErrortransaction errorTransaction
20605ErrDNShardNotFoundTN shard not foundTransaction
20606ErrShardNotReportedTN shard not reportedTransaction
20607ErrTAEErrortae errorTAE Error
20608ErrTAEReadtae read errorTAE Error
20609ErrRpcErrorrpc errorTAE Error
20610ErrWaitTxntransaction wait errorTAE Error
20611ErrTxnNotFoundtransaction not foundTAE Error
20612ErrTxnNotActivetransaction not activeTAE Error
20613ErrTAEWritetae write errorTAE Error
20614ErrTAECommittae commit errorTAE Error
20615ErrTAERollbacktae rollback errorTAE Error
20616ErrTAEPreparetae prepare errorTAE Error
20617ErrTAEPossibleDuplicatetae possible duplicateTAE Error
20618ErrTxnRWConflictr-w conflictTAE Error
20619ErrTxnWWConflictw-w conflictTAE Error
20620ErrNotFoundtransaction not foundTAE Error
20621ErrTxnInternaltransaction internal errorTAE Error
20622ErrTxnReadConflicttransaction read conflictTAE Error
20623ErrPrimaryKeyDuplicatedduplicated primary keyTAE Error
20624ErrAppendableSegmentNotFoundappendable segment not foundTAE Error
20625ErrAppendableBlockNotFoundappendable block not foundTAE Error
20626ErrTAEDebugTAE debugTAE Error