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
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 |