Question & Answer
Question
You are seeing error such as the following, but do not know what it means:- ERROR: 15 : Compiler cancelled during 823.pln (Terminated (signal 15))
Cause
Signal 15 is SIGTERM (Signal for termination).
When a Ctrl-C / abort happen in the middle of the query execution it will shown as :
"ERROR: Transaction rolled back by client"
But when a Ctrl-C / abort happened in the middle of the query is being processed by the compiler, this error will be shown instead :
"ERROR 15: Compiler cancelled during <plan id>.pln (signal 15)"
Answer
This simply means a user abort action is detected.
There are plan to fix the error message to more meaningful in later NPS release.
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21675128