--000e0cd29cb6f9021a048b4836bf
Content-Type: text/plain; charset=ISO-8859-1

Hello,

I am trying to determine what might cause an issue like this. This was a
large (several hundred GB) data warehouse server with PG 8.2.4. I can't
really determine what caused this issue. We ended up restoring the data
from a backup.

Here are some of the errors in the log:

postmaster.1:Jul 11 14:13:36 postgres[18051]: [8-1] ERROR: cache lookup
failed for operator 660

postmaster.1:Jul 11 15:27:00 postgres[26428]: [2-1] ERROR: cache lookup
failed for operator 93

Attempting to list the tables using psql:

#\dt

ERROR: operator does not exist: oid = oid

LINE 6: JOIN pg_catalog.pg_roles r ON r.oid = c.relowner

^

HINT: No operator matches the given name and argument type(s). You may need
to add explicit type casts.

Deron

--000e0cd29cb6f9021a048b4836bf
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hello,</div>
<div>=A0</div>
<div>I am trying to determine what might cause an issue like this.=A0=A0 Th=
is was a large (several hundred=A0GB)=A0data warehouse server with PG 8.2.4=
..=A0=A0 I can't really determine what caused this issue.=A0 We ended up=
restoring the data from a backup.</div>

<div>=A0</div>
<div>Here are some of the errors in the log:</div>
<div><font face=3D"r_ansi" size=3D"2"><font face=3D"r_ansi" size=3D"2">
<p>postmaster.1:Jul 11 14:13:36=A0 postgres[18051]: [8-1] ERROR: cache look=
up failed for operator 660</p><font face=3D"r_ansi" size=3D"2"><font face=
=3D"r_ansi" size=3D"2">
<p>postmaster.1:Jul 11 15:27:00=A0 postgres[26428]: [2-1] ERROR: cache look=
up failed for operator 93</p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">Attempting to list the tables using psql:</s=
pan></p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">#\dt</span></p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">ERROR:=A0 operator does not exist: oid =3D o=
id</span></p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">LINE 6:=A0=A0=A0=A0=A0 JOIN pg_catalog.pg_ro=
les r ON r.oid =3D c.relowner</span></p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0 ^</span></p>
<p class=3D"MsoNormal" style=3D"MARGIN: 0in 0in 0pt"><span style=3D"FONT-SI=
ZE: 10pt; FONT-FAMILY: r_ansi">HINT:=A0 No operator matches the given name =
and argument type(s). You may need to add explicit type casts.</span></p>
<p>Deron</p></font></font></font></font></div>

--000e0cd29cb6f9021a048b4836bf--

On Tue, Jul 13, 2010 at 10:29:42AM -0700, Deron wrote:
> Hello,
>
> I am trying to determine what might cause an issue like this. This was a
> large (several hundred GB) data warehouse server with PG 8.2.4. I can't
> really determine what caused this issue. We ended up restoring the data
> from a backup.
>
> Here are some of the errors in the log:
>
> postmaster.1:Jul 11 14:13:36 postgres[18051]: [8-1] ERROR: cache lookup
> failed for operator 660
>
> postmaster.1:Jul 11 15:27:00 postgres[26428]: [2-1] ERROR: cache lookup
> failed for operator 93
>
> Attempting to list the tables using psql:
>
> #\dt
>
> ERROR: operator does not exist: oid = oid
>
> LINE 6: JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
>
> ^
>
> HINT: No operator matches the given name and argument type(s). You may need
> to add explicit type casts.
>
> Deron

Could it be the result of running an over 3 year old version of
8.2? Try checking the release notes for the last 13 releases and
see if any of the fixes might apply to your situation. I would
certainly upgrade to prevent future problems and data loss. There
are good reasons for all of the point releases for the major
PostgreSQL releases. Maybe someone else can remember details of
a problem such as yours.

Good luck.
Ken

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Deron <fecastle [at] gmail.com> writes:
> I am trying to determine what might cause an issue like this. This was a
> large (several hundred GB) data warehouse server with PG 8.2.4. I can't
> really determine what caused this issue. We ended up restoring the data
> from a backup.

> Here are some of the errors in the log:

> postmaster.1:Jul 11 14:13:36 postgres[18051]: [8-1] ERROR: cache lookup
> failed for operator 660

> postmaster.1:Jul 11 15:27:00 postgres[26428]: [2-1] ERROR: cache lookup
> failed for operator 93

Evidently you had corruption in the pg_operator catalog. If you were
lucky, a REINDEX of pg_operator might have fixed it, but unless you kept
a physical copy of the corrupted database there's no way to investigate
further now.

8.2.4 is extremely out of date btw, you should be using 8.2.17 or
something close to that.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin