Hi: The call stack is below:
#0 0x00007fdecbe924eb in raise () from /lib64/libpthread.so.0 #1 0x0000000000886888 in . () #2 <signal handler called> #3 0x00000000006cb364 in ?? () #4 0x00000000006cb2a4 in CheckExprStillValid () --> *state == NULL* #5 0x00000000006c9563 in ExecInterpExprStillValid () #6 0x00000000006f2601 in ExecIndexEvalRuntimeKeys () #7 0x00000000006ea8b5 in ExecReScanBitmapIndexScan () #8 0x00000000006c20fa in ExecReScan () #9 0x00000000006e8c18 in ExecReScanBitmapAnd () #10 0x00000000006c21ca in ExecReScan () #11 0x00000000006c2232 in ExecReScan () #12 0x00000000006fed4f in ExecReScanNestLoop () #13 0x00000000006c212e in ExecReScan () #14 0x00000000006fea5b in ?? () #15 0x00000000006dab67 in ?? () #16 0x00000000006fea7d in ?? () #17 0x00000000006dab67 in ?? () #18 0x00000000006e32c5 in ?? () #19 0x00000000006dab67 in ?? () #20 0x0000000000701ba0 in ?? () #21 0x00000000006dab67 in ?? () #22 0x0000000000702161 in ?? () #23 0x00000000006dab67 in ?? () #24 0x00000000006d22ed in standard_ExecutorRun () #25 0x00007fdec4140537 in ?? () from /u01/..._stat_plans.so #26 0x00007fdec3b21670 in ?? () from /u01/...l/pg_stat_statements.so #27 0x00007fdec3719850 in ?? () from /u01/.../auto_explain.so #28 0x000000000088b3ef in ?? () #29 0x000000000088af73 in PortalRun () #30 0x0000000000885cf1 in PostgresMain () #31 0x00000000007d9598 in ?? () #32 0x00000000007d8aa3 in ?? () #33 0x00000000007d5579 in PostmasterMain () #34 0x000000000072cefc in main () In my environment, if I run the query in psql, everything is good. However if I run it in some java code(including other sql), it would crash for 95% cases. I'm sorry that I can't provide a runnable test case, I'm posting here just to see if anyone has run into the similar case before or can provide some hints on this. Thanks! -- Best Regards Andy Fan
