Great, big errors ... Again.

From: "Mitch Vincent" <mitch(at)huntsvilleal(dot)com>
To: <pgsql-hackers(at)hub(dot)org>
Subject: Great, big errors ... Again.
Date: 2000-05-10 15:57:28
Message-ID: 010e01bfba98$710aed00$4100000a@venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Ok, it appears the database backend is being stupid again, I'm getting all
kinds of errors.

From my PHP code, I'm getting this kind of error now:

heap_beginscan:
!RelationIsValid(relation) in classes/db_pgsql.inc on line 63
Database error: Invalid SQL: select
user_id_hash,session_id,user_id,agency_id,date_part('epoch',created) as
start,date_part('epoch',updated) as age from users_online where
user_id_hash='9de5085eac89de8be0169b6dc6801524'
PostgreSQL Error: 1 (ERROR: heap_beginscan: !RelationIsValid(relation) )
Session halted

I got "Sorry, too many clients already" -- a little while ago..

I'm running at debug level 3, but have nothing to show for it in the log
file except this :

NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died
abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate
your database system connection and exit.
Please reconnect to the database system and repeat your query.
/usr/local/pgsql/bin/postmaster: CleanupProc: sending SIGUSR1 to process
44639
/usr/local/pgsql/bin/postmaster: CleanupProc: reinitializing shared memory
and semaphores
shmem_exit(0) [#0]

So.. Now that I've got it to break, any ideas on what I can do to figure out
why it's happening? This is still a 6.5.3 server.. (I weas going to upgrade
today believe it or not.)

- Mitch

"The only real failure is quitting."

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-05-10 15:58:56 Re: pg_hba.conf && ident ...
Previous Message Malcolm Beattie 2000-05-10 15:51:35 Re: pg_hba.conf && ident ...