- 10.12.1 errorcode Module
- 10.12.2 errors.Error Exception
- 10.12.3 errors.DataError Exception
- 10.12.4 errors.DatabaseError Exception
- 10.12.5 errors.IntegrityError Exception
- 10.12.6 errors.InterfaceError Exception
- 10.12.7 errors.InternalError Exception
- 10.12.8 errors.NotSupportedError Exception
- 10.12.9 errors.OperationalError Exception
- 10.12.10 errors.PoolError Exception
- 10.12.11 errors.ProgrammingError Exception
- 10.12.12 errors.Warning Exception
- 10.12.13 errors.custom_error_exception() Function
Themysql.connector.errors module defines exception classes for errors and warnings raised by MySQL Connector/Python. Most classes defined in this module are available when you importmysql.connector.
The exception classes defined in this module mostly follow the Python Database API Specification v2.0 (PEP 249). For some MySQL client or server errors it is not always clear which exception to raise. It is good to discuss whether an error should be reclassified by opening a bug report.
MySQL Server errors are mapped with Python exception based on their SQLSTATE value (seeServer Error Message Reference). The following table shows the SQLSTATE classes and the exception Connector/Python raises. It is, however, possible to redefine which exception is raised for each server error. The default exception isDatabaseError.
Table 10.1 Mapping of Server Errors to Python Exceptions
| SQLSTATE Class | Connector/Python Exception |
|---|---|
02 | DataError |
02 | DataError |
07 | DatabaseError |
08 | OperationalError |
0A | NotSupportedError |
21 | DataError |
22 | DataError |
23 | IntegrityError |
24 | ProgrammingError |
25 | ProgrammingError |
26 | ProgrammingError |
27 | ProgrammingError |
28 | ProgrammingError |
2A | ProgrammingError |
2B | DatabaseError |
2C | ProgrammingError |
2D | DatabaseError |
2E | DatabaseError |
33 | DatabaseError |
34 | ProgrammingError |
35 | ProgrammingError |
37 | ProgrammingError |
3C | ProgrammingError |
3D | ProgrammingError |
3F | ProgrammingError |
40 | InternalError |
42 | ProgrammingError |
44 | InternalError |
HZ | OperationalError |
XA | IntegrityError |
0K | OperationalError |
HY | DatabaseError |