From: | Kristofer Munn <kmunn(at)munn(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | ERROR: cannot find attribute 1 of relation pg_temp.13465.1 |
Date: | 2000-06-16 16:08:21 |
Message-ID: | Pine.LNX.4.04.10006161201360.14299-100000@munn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Greetings.
I'm running into a recurring error on my system that has been running fine
for quite a while. I dumped, dropped, created, rebuild and reloaded the
database (all 2+ gigs) yesterday in the hopes of correcting whatever might
be the problem.
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
The following lines show up in my /var/log/messages...
Jun 16 11:39:44 mymailman logger: ERROR: cannot find attribute 1 of
relation pg_temp.13465.1
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: FATAL 1: Socket command type
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: ERROR: unknown frontend message was
received
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: NOTICE: AbortTransaction and not in
in-progress state
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: pq_recvbuf: recv() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: FATAL 1: Socket command type ? unknown
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: ERROR: unknown frontend message was
received
Jun 16 11:39:44 mymailman logger: pq_flush: send() failed: Bad file
descriptor
Jun 16 11:39:44 mymailman logger: NOTICE: AbortTransaction and not in
in-progress state
Etc etc. It goes off into an infinite recursion and then a script I have
running detects that and shuts down and restarts postgres. Then the
scripts that run restart themselves and everything's fine for a few more
minutes and then we're back where we started from.
I was waiting to upgrade to 7.0.2 for awhile to let it shake out before
putting it on a production system.
Thanks in advance for the consideration...
- K
Kristofer Munn * KMI * 732-254-9305 * AIM KrMunn * http://www.munn.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-06-16 16:26:24 | create user and transactions |
Previous Message | Tom Lane | 2000-06-16 15:46:41 | Re: Big 7.1 open items |