Informix Error -33070: Stack overflow occurred during statement parse.
Cause and resolution
Stack overflow occurred during statement parse.
This message, which indicates that the parser stack has overflowed, rarely occurs. It might occur, for example, if your embedded-language statement (SELECT, INSERT, UPDATE, DELETE, and so on) contains an extremely large or complicated clause (WHERE, MATCHES, LIKE, and so on) that the parser is trying to process. In that case, break up the clause and try again.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-33070 fires when the parser's internal stack overflows — per the official guidance, this
rarely occurs, typically from an extremely large or complicated clause (WHERE,
MATCHES, LIKE, and similar) in an embedded-language statement.
- An extremely large or complicated clause overflowing the parser's stack, per the official guidance — the direct, only cause.
Solutions / Resolution
- Break up the clause into smaller pieces and try again, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an overly complex clause.
Diagnostic Checks
- Identify the statement's largest/most complex clause, and break it up.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -33070 in this set yet.
The parser's internal stack overflowed on an extremely large/complicated clause — break the clause up into smaller pieces.