Errors may be caused by a variety of scenarios. All errors are logged in the database server log file. In addition, user-related errors are returned to the user as part of the response to the query, transaction or stored procedure execution or to database administration action.
Errors reported in the Server log include – Function, Entity, Context, Error message, Error description and Severity.
Errors reported to users are translated into standard PostgreSQL error codes and may consist of an MOT-specific message and description.
The following lists the error messages, error descriptions and error codes. The error code is actually an internal code and not logged or returned to users.
Errors Written the Log File
All errors are logged in the database server log file. The following lists the errors that are written to the database server log file and are not returned to the user. The log is located in the data folder and named postgresql-DATE-TIME.log.
Table 1 Errors Written Only to the Log File
Errors Returned to the User
The following lists the errors that are written to the database server log file and are returned to the user.
MOT returns PG standard error codes to the envelope using a Return Code (RC). Some RCs cause the generation of an error message to the user who is interacting with the database.
The PG code (described below) is returned internally by MOT to the database envelope, which reacts to it according to standard PG behavior.
NOTE: %s, %u and %lu in the message are replaced by relevant error information, such as query, table name or another information.
%s – String
%u – Number
%lu – Number
Table 2 Errors Returned to the User and Logged to the Log File
Top comments (0)