From: Cédric Villemain <cedric.villemain.debian@gmail.com>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: out of memory ...
Date: Mon, 3 May 2010 13:56:50 +0200
Message-ID: <j2ke94e14cd1005030456tb67aafd6gd3ffd164e04bd4d0@mail.gmail.com> (raw)
In-Reply-To: <20100503111556.18910@gmx.net>
References: <20100503111556.18910@gmx.net>
2010/5/3 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>:
> Hello,
>
> how fatal is it for the server/data if a server runs out of memory?
>
> Happened on a Windows server some time ago. A transaction got too large. In the log it began with:
>
> ------------
> TopMemoryContext: 37171728 total in 4046 blocks; 67640 free (4060 chunks); 37104088 used
> TopTransactionContext: 24576 total in 2 blocks; 18848 free (17 chunks); 5728 used
> CurTransactionContext: 8192 total in 1 blocks; 8176 free (1 chunks); 16 used
> ...
> ------------
>
> Although all other clients had been closed no new connection was possible to terminate the session responsible for the out of memory problem. I guess it's because this transaction had been started by a superuser ...
>
> ------------
>
> In the end the server was shut down via the service manager.
>
> On the next start of the server the log contained the following lines:
>
> ------------
> LOG: database system was interrupted; last known up at 2010-03-26 11:22:36 CET
> LOG: database system was not properly shut down; automatic recovery in progress
> LOG: record with zero length at 1F/D2454CD0
> ------------
>
> The data still seemed to be okay - all the other transactions made before seem to be in the database.
>
> Is it okay to continue using the database(s) or is there a risk of hidden data corruption (fsync is on)?
okay to continue if your filesystem didn't have issues (if postgres
start, then it is ok from its side)
>
> Could you tell me, please?
>
> Thank you very much,
>
> Peter
>
>
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Cédric Villemain
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cedric.villemain.debian@gmail.com, Jan-Peter.Seifert@gmx.de
Subject: Re: out of memory ...
In-Reply-To: <j2ke94e14cd1005030456tb67aafd6gd3ffd164e04bd4d0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox