Postmaster refuses to start

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Postmaster refuses to start
Date: 2001-05-04 20:08:07
Message-ID: 20010504140807.A2691@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

My postmaster is refusing to start. I don't know what's wrong. If
anyone has pointers/tips/whatever, please tell me.
One of my backup scripts was wrong so I don't have current backups
(that's what you get for trusting other people to do your backups). Any
way to recover my databases?
The oddities started yesterday. Everytime I'd call a PL/pgSQL
function, the backend would die. The function was working perfectly up to
that point so I know there's nothing wrong with it.
I am running PG 7.1 from the Debian packages.

Here's what my log says:

[tons of these]
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 3599) exited with status 11 at Thu May 3 10:32:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 10:32:55 2001
Reinitializing shared memory and semaphores
Server process (pid 3616) exited with status 11 at Thu May 3 10:35:21 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 10:35:21 2001
Reinitializing shared memory and semaphores
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Server process (pid 5115) exited with status 11 at Thu May 3 16:03:09 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:03:12 2001
Reinitializing shared memory and semaphores
Server process (pid 5118) exited with status 11 at Thu May 3 16:03:42 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:03:42 2001
Reinitializing shared memory and semaphores
Server process (pid 5122) exited with status 11 at Thu May 3 16:04:00 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:04:00 2001
Reinitializing shared memory and semaphores
Server process (pid 5158) exited with status 11 at Thu May 3 16:08:43 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:08:45 2001
Reinitializing shared memory and semaphores
Server process (pid 5176) exited with status 11 at Thu May 3 16:15:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:15:33 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
The Data Base System is starting up
pq_recvbuf: unexpected EOF on client connection
Smart Shutdown request at Thu May 3 16:17:59 2001
Server process (pid 5271) exited with status 11 at Thu May 3 16:21:35 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:21:36 2001
Reinitializing shared memory and semaphores
Server process (pid 5288) exited with status 11 at Thu May 3 16:26:47 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:26:49 2001
Reinitializing shared memory and semaphores
Server process (pid 5293) exited with status 11 at Thu May 3 16:28:32 2001
Terminating any active server processes...
Server processes were terminated at Thu May 3 16:28:32 2001
Reinitializing shared memory and semaphores
The Data Base System is starting up
Server process (pid 7780) exited with status 512 at Fri May 4 04:06:34 2001
Terminating any active server processes...
Server processes were terminated at Fri May 4 04:06:34 2001
Reinitializing shared memory and semaphores
/usr/lib/postgresql/bin/postmaster: Startup proc 7781 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9347 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9364 exited with status 512 - abort
/usr/lib/postgresql/bin/postmaster: Startup proc 9380 exited with status 512 - abort

These last lines are me trying to restart the postmaster via pg_ctl
with debugging set to 5.

Any help is very much appreciated.

-Roberto

--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-04 20:47:52 Re: Re: Metaphone function attachmenty
Previous Message Ken Hirsch 2001-05-04 19:58:07 Re: Re: New Linux xfs/reiser file systems