Re: [GENERAL] Getting cache lookup failed for aggregate error

2014-06-25 Thread Igor Neyman
FWIW the SQL is DROP AGGREGATE IF EXISTS array_cat_aggregate(anyarray); CREATE AGGREGATE array_cat_aggregate(anyarray) ( SFUNC = array_cat, STYPE = anyarray, INITCOND = '{}' ); Followed by the other statement given in my previous email. But, I think you've thoroughly

[GENERAL] Getting cache lookup failed for aggregate error

2014-06-24 Thread Patrick Krecker
Hello everyone -- We received a strange error today on our production write master. During a routine maintenance script, we got the following error: ERROR: cache lookup failed for aggregate 5953992 I think I found the culprit. We have a cron script that (among other things) recreates the

Re: [GENERAL] Getting cache lookup failed for aggregate error

2014-06-24 Thread Tom Lane
Patrick Krecker patr...@judicata.com writes: Hello everyone -- We received a strange error today on our production write master. During a routine maintenance script, we got the following error: ERROR: cache lookup failed for aggregate 5953992 I think I found the culprit. We have a cron

Re: [GENERAL] Getting cache lookup failed for aggregate error

2014-06-24 Thread Patrick Krecker
On Tue, Jun 24, 2014 at 4:25 PM, Tom Lane t...@sss.pgh.pa.us wrote: Patrick Krecker patr...@judicata.com writes: Hello everyone -- We received a strange error today on our production write master. During a routine maintenance script, we got the following error: ERROR: cache lookup