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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Attachment Content-Type Size
unknown_filename text/plain 752 bytes

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2004-04-16 12:59:08 Re: psql compiled with msys
Previous Message Merlin Moncure 2004-04-16 12:38:36 psql compiled with msys