Обсуждение: BUG #4892: postmaster died and didn't restart

The following bug has been logged online:

Bug reference:      4892
Logged by:          Rikard Pavelic
Email address:      rikard.pavelic@zg.htnet.hr
PostgreSQL version: 8.4 beta2
Operating system:   Windows XP SP3
Description:        postmaster died and didn't restart
Details:

log of death [i hate automatic translation feature :(]
%t LOG:  serverski proces (PID 5008) was terminated by exception 0xC0000142
%t HINT:  See C include file "ntstatus.h" for a description of the
hexadecimal value.
%t LOG:  terminiranje svih ostalih aktivnih serverskih procesa
%t WARNING:  terminating connection because of crash of another server
process
%t DETAIL:  The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
%t HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
%t WARNING:  terminating connection because of crash of another server
process
%t DETAIL:  The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
%t HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
%t LOG:  svi serverski procesi terminirani; reinicijalizacija
%t FATAL:  could not create shared memory segment: 1455
%t DETAIL:  Failed system call was CreateFileMapping(size=37044224,
name=Global/PostgreSQL:C:/Program Files/PostgreSQL/8.4/data).

and log after manual start
%t LOG:  database system was interrupted; last known up at 2009-06-25
23:41:15 CEST
%t FATAL:  rad baza podataka je u procesu startanja
%t LOG:  rad baze podataka nije bio ispravno prekinut; automatsko
oporavljanje u tijeku
%t LOG:  slog s nultom duljinom na 0/691A08
%t LOG:  redo nije tražen
%t LOG:  database system is ready to accept connections
%t LOG:  autovacuum launcher started

"Rikard Pavelic" <rikard.pavelic@zg.htnet.hr> writes:
> %t FATAL:  could not create shared memory segment: 1455
> %t DETAIL:  Failed system call was CreateFileMapping(size=37044224,
> name=Global/PostgreSQL:C:/Program Files/PostgreSQL/8.4/data).

I know little about Windows, but according to Google code 1455 is
"ERROR_COMMITMENT_LIMIT: The paging file is too small for this operation
to complete".  Which seems to be an out-of-memory kind of problem.
Perhaps you've got shared_buffers set to an unreasonably high value
for your machine?

            regards, tom lane

On Sun, 2009-06-28 at 22:54 +0000, Rikard Pavelic wrote:

> log of death [i hate automatic translation feature :(]

On UNIX, it's so easy to change what language PostgreSQL uses that it's
generally considered very helpful - the only time you really want to
disable it is when posting to mailing lists.

On Windows, it might be nice to be able to set a language for Pg.

--
Craig Ringer

Craig Ringer wrote:
> On Sun, 2009-06-28 at 22:54 +0000, Rikard Pavelic wrote:
>
> > log of death [i hate automatic translation feature :(]
>
> On UNIX, it's so easy to change what language PostgreSQL uses that it's
> generally considered very helpful - the only time you really want to
> disable it is when posting to mailing lists.
>
> On Windows, it might be nice to be able to set a language for Pg.

Just set lc_messages in postgresql.conf.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.