Thread

1. Postmaster refuses to start

   Roberto Mello <rmello@cc.usu.edu> — 2001-05-04T20:08:07Z

   	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    
   
   

2. Re: Postmaster refuses to start

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-04T23:05:52Z

   Roberto Mello <rmello@cc.usu.edu> writes:
   > 	My postmaster is refusing to start. I don't know what's wrong. If
   > anyone has pointers/tips/whatever, please tell me. 
   
   Perhaps a gdb backtrace from one of the core files would yield clues.
   
   			regards, tom lane