Skip site navigation (1) Skip section navigation (2)

Re: crash on bad database connect

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: crash on bad database connect
Date: 2004-04-16 12:57:09
Message-ID: 200404161257.i3GCv9U00168@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Merlin Moncure wrote:
> Right now, when I try and connect to a database on psql that doesn't
> exist, it crashes the postmaster.  All connections, etc. are from
> localhost.  Does anybody else get this?
> 
> Merlin
> 
> 
> LOG:  database system was shut down at 2004-04-15 17:35:00 Eastern
> Daylight Time
> LOG:  checkpoint record is at 0/A9A068
> LOG:  redo record is at 0/A9A068; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 819; next OID: 25404
> LOG:  database system is ready
> FATAL:  database "Merlin.Moncure" does not exist
> LOG:  server process (PID 2764) exited with unexpected status 128
> LOG:  terminating any other active server processes
> WARNING:  terminating connection because of crash of another server
> process
> DETAIL:  The postmaster has commanded this server process to roll back
> the current transaction and e
> xit, because another server process exited abnormally and possibly
> corrupted shared memory.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> LOG:  all server processes terminated; reinitializing
> FATAL:  could not attach to proper memory at fixed address:
> shmget(key=5432001, addr=00F60000) faile
> d: No such file or directory

Sorry, this was caused by my fix to make SIGTERM safe.  I had forgotten
to deal with Warn_restart_ready properly.  Patch attached and applied.

Thanks for the report.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2004-04-16 12:59:08
Subject: Re: psql compiled with msys
Previous:From: Merlin MoncureDate: 2004-04-16 12:38:36
Subject: psql compiled with msys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group