In this blog post, let’s learn about the error message “2053 Optimizer pass two assertion failure (failure-text) in file file-name at line line-num.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2053 Optimizer pass two assertion failure (failure-text) in file file-name at line line-num.
Reason for the Error
This is an informational message that is a result of the two-pass mechanism of the optimizer. The optimizer created a simple plan, and then while refining that plan, an internal error occurred, so the simple plan was not improved. The simple plan is still valid and will work.
Solution
Informational message only; no corrective action is needed. This message will be accompanied by an assertion failure message and, possibly, CONTROL QUERY SHAPE information. However, report the entire message, and the preceding assertion failure message, to your service provider.
This additional information will also be helpful: the DDL for the tables involved, the query that produced this warning, and any CONTROL QUERY SHAPE and CONTROL QUERY DEFAULT settings in effect when the error occurred
