postmaster quits

From: Marc Prewitt <mprewitt(at)chelsea(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postmaster quits
Date: 2001-08-28 20:54:28
Message-ID: 3B8C0504.718A0935@chelsea.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches(at)postgresql(dot)org instead. Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Marc Prewitt
Your email address : mprewitt(at)chelsea(dot)net

System Configuration
---------------------
Architecture (example: Intel Pentium) : Sparcstation 20/sun4m

Operating System (example: Linux 2.0.26 ELF) : Solaris 5.8

PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1beta4

Compiler used (example: gcc 2.8.0) : gcc 2.95.3

Please enter a FULL description of your problem:
------------------------------------------------

Our development server, on occaision, runs out of swap space and
inevitably when it does, the postmaster process stops. When restarted,
the following info is in the log (the machine ran out of swap around
19:17):

DEBUG: starting up
DEBUG: database system was interrupted at 2001-08-27 19:17:33
DEBUG: CheckPoint record at (0, 218748312)
DEBUG: Redo record at (0, 218748312); Undo record at (0, 0); Shutdown
FALSE
DEBUG: NextTransactionId: 213780; NextOid: 297035
DEBUG: database system was not properly shut down; automatic recovery in
progress...
DEBUG: ReadRecord: record with zero len at (0, 218748376)
DEBUG: Formatting logfile 0 seg 13 block 78 at offset 5592
DEBUG: The last logId/logSeg is (0, 13)
DEBUG: redo is not required
DEBUG: database system is in production state

It is odd that postgresql doesn't create a core file or retry it's
mallocs. We are running mysql and Oracle on the same machine and neither
of them have had this problem during the temporary memory shortage.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Run of of swap space.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Apua Paquola 2001-08-28 22:24:41 Indices get ignored in large tables
Previous Message Ron Looi 2001-08-28 09:02:33 RE: Error on postgresql driver (or pg_hba)