Error Codes Tagged: database

sqlalchemy.exc.OperationalError

Python ExceptionsError

sqlalchemy.exc.OperationalError

A database operation failed due to a connection or database-level error.

python

08001

08001 — Client Unable to Establish Connection

The client could not establish a connection to the database server.

08003

08003 — Connection Does Not Exist

The specified database connection does not exist or has been closed.

08006

08006 — Connection Failure

An established database connection was unexpectedly lost.

22001

22001 — String Data Right Truncation

A string value is too long for the target column.

22003

22003 — Numeric Value Out of Range

A numeric value is outside the range of the target column's data type.

22007

22007 — Invalid Datetime Format

A date, time, or timestamp value is in an invalid format.

22008

22008 — Datetime Field Overflow

A datetime value is outside the valid range for the field.

22012

22012 — Division by Zero

A division by zero was attempted in a SQL expression.

22P02

22P02 — Invalid Text Representation

A value could not be converted to the required data type.

23502

23502 — Not Null Violation

An INSERT or UPDATE attempted to set a NOT NULL column to NULL.

23503

23503 — Foreign Key Violation

An INSERT or UPDATE violates a foreign key constraint.

23505

23505 — Unique Violation

An INSERT or UPDATE violates a unique constraint or primary key.

23514

23514 — Check Constraint Violation

An INSERT or UPDATE violates a CHECK constraint on the table.

23P01

23P01 — Exclusion Violation

An INSERT or UPDATE violates an exclusion constraint.

25001

25001 — Active SQL Transaction

The command cannot be executed inside an active transaction.

25006

25006 — Read-Only SQL Transaction

An attempt was made to modify data in a read-only transaction.

25P02

25P02 — In Failed SQL Transaction

A command was issued in a transaction that has already failed.

28000

28000 — Invalid Authorization Specification

The authentication credentials are invalid.

28P01

28P01 — Invalid Password

The password provided for authentication is incorrect.

3D000

3D000 — Invalid Catalog Name

The specified database does not exist.

3F000

3F000 — Invalid Schema Name

The specified schema does not exist in the database.

40001

40001 — Serialization Failure

The transaction was rolled back due to a serialization conflict.