Appendix B Error Messages and Common Problems

Table of Contents

B.1 Error Message Sources and Elements

B.2 Error Information Interfaces

B.3 Problems and Common Errors

B.3.1 How to Determine What Is Causing a Problem

B.3.2 Common Errors When Using MySQL Programs

B.3.3 Administration-Related Issues

B.3.4 Query-Related Issues

B.3.5 Optimizer-Related Issues

B.3.6 Table Definition-Related Issues

B.3.7 Known Issues in MySQL

This appendix describes the types of error information MySQL provides and how to obtain information about them. The final section is for troubleshooting. It describes common problems and errors that may occur and potential resolutions.

Additional Resources

Other error-related documentation includes:

• Information about configuring where and how the server writes the error log: Section 7.4.2, “The Error Log”

• Information about the character set used for error messages: Section 12.6, “Error Message Character Set”

• Information about the language used for error messages: Section 12.12, “Setting the Error Message Language”

• Information about errors related to InnoDB: Section 17.20.5, “InnoDB Error Handling”

• Information about errors specific to NDB Cluster: NDB Cluster API Errors; see also NDB API Errors and Error Handling, and MGM API Errors

• Descriptions of the error messages that the MySQL server and client programs generate: MySQL 9.1 Error Message Reference