PG Crashed at CheckExprStillValid with state == NULL (PG 11.2)

From: Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PG Crashed at CheckExprStillValid with state == NULL (PG 11.2)
Date: 2020-10-26 13:50:06
Message-ID: CAKU4AWprp1+d4dJUyvoiMgkwyi2y03ryZ-WFuQQ+=zmr8sHvxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Ayub M 2020-10-26 14:45:35 Re: postgres materialized view refresh performance
Previous Message Hu Bert 2020-10-26 13:34:50 postgis update wants to install postgresql-13