Alpha

These pages are built from turborel-php’s main, turborel 0.0.0. Anything may change from one build to the next: SQL, API, protocol and files alike.

Appendix B: Errors

Every failure reaches a program as a Turborel\TurborelException of a SQLSTATE and a SQLCODE (Errors). The first two characters of the SQLSTATE are its class.

The driver's own

SQLSTATE SQLCODE Raised when Ends the connection
08006 -919 The server is not reached, TLS fails, a wait runs out, a reply's frame is malformed or a reply comes out of turn, or the connection is lost; a capability not granted, more than 32 attributes or one past its bounds, a timeout of zero, or a certificate checked with no authority trusted, refused before anything is sent yes, but of what is refused before anything is sent
28000 -919 A secret would go over plain TCP; SCRAM's exchange is refused yes, of a login
22003 -301 A number, or a field's value, is out of its range no
22018 -301 A UUID's text is not one, as turborel's CAST refuses it no
22021 -301 A string is not UTF-8 no
22032 -301 JSON text does not parse no
TB916 -916 A JSON stored form is damaged; a reply holds a value the driver cannot take, a truth or units byte not 0 or 1, a malformed condition, value tags 18 and 19, its statement failing alone after the rest of its replies are read past no
0A000 -900 JSON is past turborel's limits, nested more than 128 deep or a stored form past 256 MiB; of a reply, its statement failing alone no
2200N -301 An XML value's text is not well-formed content no
22000 -301 The protocol has no value for a PHP value no
TB910 -910 The program misused the API where turborel-client has no case of it: a request other than a copy's rows, its end or Ping while the copy is under way; a TCP port not one, a negative timeout, a cancel key or UUID not of 16 octets, or a delimiter of no use; a pooled connection asked for once given back; the standard interface's misuse, as a named parameter, an attribute not taken, or a transaction ended where none is no
08001 -919 Settings that cannot be read, or name no user; of several servers tried, none kept, or a server not of the role asked; no pooled connection back within wait no connection was made
08003, 08002, 2E000, 08001, 08004 -919 The SQL-agent's: no such connection, a name in use, a name that is no identifier, a server not reached, a server refusing no
0A001 -900 The SQL-agent's CONNECT or SET CONNECTION within an active transaction no
28000 -104 The SQL-agent's CONNECT of a user that is no authorization identifier no
25000 -917 The SQL-agent's DISCONNECT of a connection in a transaction no
2A000 -101, -102, -103 The SQL-agent's statement that is no tokens, as turborel's lexer refuses it (-101); its connection statement that does not parse, or names by no character string literal no
0A000 -900 The SQL-agent's connection statement of a variable specification, or a literal of a character set other than SQL_TEXT no
22000 -301 An import's input cannot be read, or does not fit the table: a record of too many or too few fields, a session with a transaction active, a table name that is not one no
22001 -301 An import's string is longer than its column, found before it is sent no

The server's

The server's failures come as it sends them. Their classes, those a program meets most:

Class What Ends the connection
01 A warning: a condition of the statement, never thrown no
02 No data: SQLCODE 100, a completion, never thrown no
07 A dynamic SQL error, as 07001 of values not one for each parameter no
08 A connection exception, as 08004 of a connection refused; 08003 names another connection yes, but 08003
22 A data exception, as 22012 of a division by zero, or 2200W of an XML value that cannot be serialized no
23 An integrity constraint violation, as of a duplicate key no
24 An invalid cursor state no
26 An invalid SQL statement name: a prepared statement that is no more no
28 Credentials refused: SQLCODE -919 as a connection is made, or as a change of user is refused yes, of SQLCODE -919
2A A syntax error or access rule violation no
40 A transaction rollback, as 40002 of a commit that fails no
TB turborel's own: TB920, SQLCODE -920, a statement cancelled; TBR01, SQLCODE -920, a replica that had not applied REPLICATION.READ_AFTER's position in time no

A notice of the server's own comes as a Turborel\Session\Notice, never as a failure: 01T01, of severity NOTICE, tells that a reset or a change of user rolled a transaction back.