database error xx000?

From: Kenneth Tilton <ktilton(at)mcna(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: database error xx000?
Date: 2012-04-26 17:42:07
Message-ID: CAECCA8auoaCv+O5gKw8+1OijEnhEdH07tULCHn3NRmn84oK=1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am doing a ton of pgsql over here defining and redefining functions and
triggers and every day or so I get this:

Error: Database error XX000: cache lookup failed for type 5276542
>
> Query: select dcm.task_user_dispos(42895::bigint, 870::bigint)
>
> [condition type: internal-error]
>
>
If I exit everything and start over (but not bouncing the PG server) the
problem goes away.

I gather this kind of DB error is not a user error, but I would still be
interested in learning how to avoid it because even in production we will
need to be redefining functions periodically.

Does the above give anyone any ideas at all about what is going on?

Environemnt is:

Version string PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by
> gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit

Thx, ken

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-04-26 18:24:01 Re: database error xx000?
Previous Message Dmitry Koterov 2012-04-26 14:29:14 Re: Stange "duplicate key value violates unique constraint" after "delete" at ON UPDATE trigger