PG Crashed at CheckExprStillValid with state == NULL (PG 11.2) - Mailing list pgsql-general

From Andy Fan
Subject PG Crashed at CheckExprStillValid with state == NULL (PG 11.2)
Date
Msg-id CAKU4AWprp1+d4dJUyvoiMgkwyi2y03ryZ-WFuQQ+=zmr8sHvxg@mail.gmail.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Hu Bert
Date:
Subject: postgis update wants to install postgresql-13
Next
From: Ayub M
Date:
Subject: Re: postgres materialized view refresh performance