Re: BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker

Hi Tom.

Thanks for so quick response.

It quite difficult to reproduce.
The only observation. Usually it crashes with parallelism only on quite big tables with inheritance .

The main table contains many partitions (inherited tables)
We query main table with condition on date_id = ? . In the execution plan we can see one partition only. All the next runs crashes as well.
Reconnect to the DB can help but no always.
After some time the same query can successfully be run.

Anyway I will try to write script to reproduce it. But not sure if I could be so lucky to reproduce it on a sample.

Thanks!
Best Regards,
Stepan Yankevych
Lead Software Engineer

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, March 7, 2017 18:03 PM
To: stepya(at)ukr(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #14581: invalid cache ID: 41 CONTEXT: parallel worker

stepya(at)ukr(dot)net writes:
> Time to time i have invalid cache ID: 41 while running simple query
> with parallelism.

Interesting, but unless you can show us how to reproduce this, we're not going to be able to do much about it.

regards, tom lane