Обсуждение: Crash

Hello All,

I'm pretty new to Postgres, but have managed to build a substantial site on
it.  I built the entire thing locally on some dev servers, and then put it
online.  The production DB server is a superb machine (twin PIII Ghz, 2 gigs
RAM) so it should be able to handle anything my dev servers could.

I have not begun directing users to the new site, while it's public it has
no name so I'm basically the only one using it.

When running a script that worked perfectly locally, I will always get this
error before script completion:

psql: ERROR:  cannot find attribute 1 of relation pg_proc_oid_index

At that point the server has crapped out and is no longer accepting any
connections.  It daemon has to be restarted to work properly.

Any ideas?

-John

"John W Cunningham" <john@pickaprof.com> writes:
> psql: ERROR:  cannot find attribute 1 of relation pg_proc_oid_index

This sounds like there's something pretty fundamentally broken.  Did you
build your executables yourself (if so, with what compiler and what
configuration options) or grab an RPM from somewhere (if so, where)?
Have you tried running the regression tests on your installation?

            regards, tom lane

The server was installed by my ISP for me (when I install it's from a
GreatBridge rpm).  How do I run the regression tests?

-John

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, March 14, 2001 9:59 AM
To: John W Cunningham
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Crash


"John W Cunningham" <john@pickaprof.com> writes:
> psql: ERROR:  cannot find attribute 1 of relation pg_proc_oid_index

This sounds like there's something pretty fundamentally broken.  Did you
build your executables yourself (if so, with what compiler and what
configuration options) or grab an RPM from somewhere (if so, where)?
Have you tried running the regression tests on your installation?

            regards, tom lane

"John W Cunningham" <john@pickaprof.com> writes:
> How do I run the regression tests?

See
http://www.postgresql.org/users-lounge/docs/7.0/postgres/regress.htm

            regards, tom lane

I can't even find the source file, I really need to see what these guys used
when installing.

-JOhn

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Wednesday, March 14, 2001 12:02 PM
To: John W Cunningham
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Crash


"John W Cunningham" <john@pickaprof.com> writes:
> How do I run the regression tests?

See
http://www.postgresql.org/users-lounge/docs/7.0/postgres/regress.htm

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

I ran the test - can anyone tell me what these results mean and how I can
fix it?

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Wednesday, March 14, 2001 12:02 PM
To: John W Cunningham
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Crash


"John W Cunningham" <john@pickaprof.com> writes:
> How do I run the regression tests?

See
http://www.postgresql.org/users-lounge/docs/7.0/postgres/regress.htm

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

"John W Cunningham" <john@pickaprof.com> writes:
> I ran the test - can anyone tell me what these results mean and how I can
> fix it?

The diffs look like locale issues --- specifically, I'd say that your
server is running in en_US or some other locale with ISO-like sorting
rules for strings.

I am now wondering if your original problem
    ERROR:  cannot find attribute 1 of relation pg_proc_oid_index
might also be a locale issue.  Specifically, if the server was initdb'd
with one locale but is now being run in another, it could be suffering
from apparent index corruption (because the indexes are not in order
according to its current idea of what ordering means).  If this is
happening in the system indexes then you've got big problems.

Release 7.1 will have defenses against this common error, but in earlier
releases it's critical to ensure that every postmaster start has the
same locale environment variables as were seen by initdb.  That's *real*
easy to get wrong, since initdb is normally done by hand while the
postmaster is commonly started from boot scripts (which won't have the
exact same environment a login shell has).

I'd suggest discussing this with your ISP --- they probably need to redo
the initdb under the same locale that the postmaster will routinely run
under.  It's usually a smart idea to set the locale environment (LANG
or LC_ALL) explicitly in the script that launches the postmaster.

BTW, if you don't actually *need* any locale-sensitive processing, a
good way to avoid the whole problem is to build the software without
locale support.

            regards, tom lane