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

postmaster crash

From: "Michael Beckstette" <mbeckste(at)TechFak(dot)Uni-Bielefeld(dot)DE>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postmaster crash
Date: 2002-03-26 17:18:02
Message-ID: 1020326181802.ZM3107@teak.TechFak.Uni-Bielefeld.DE (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

from time to time my postmaster crashes with the below mentioned errormessage.

I am using PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 on
a 4CPU/4GB UltraSparc II system.

The crash happened during a VACUUM ANALYZE which i perform every 30 minutes.
At the point of the crash i had several open client connections which tried to
fill one table (table1),by a 'COPY table1 FROM stdin.....'  simultaniously.

LOG:
DEBUG:  --Relation cluster_nodes--
DEBUG:  Pages 52: Changed 0, reaped 52, Empty 0, New 0; Tup 23: Vac 1914,
Keep/VTL 0/0, Crash 0, UnUsed 28, MinLen 120, MaxLen 372; Re-using: Free/Avail.
Space 411044/405288; EndEmpty/Avail. Pages 0/51. CPU 0.00s/0.00u sec.
DEBUG:  Index node_index: Pages 14; Tuples 23: Deleted 1914. CPU 0.00s/0.08u
sec.
DEBUG:  Rel cluster_nodes: Pages: 52 --> 1; Tuple(s) moved: 23. CPU 0.00s/0.05u
sec.
DEBUG:  Index node_index: Pages 14; Tuples 23: Deleted 23. CPU 0.00s/0.00u sec.
DEBUG:  MoveOfflineLogs: remove 0000000D000000A3
FATAL 2:  MoveOfflineLogs: cannot read xlog dir: Invalid argument
Server process (pid 11560) exited with status 512 at Mon Mar 25 22:00:53 2002
Terminating any active server processes...
NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend  died abnormally
and possibly corrupted shared memory.
        I have rolled back the current transaction and am       going to
terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend  died abnormally
and possibly corrupted shared memory.
        I have rolled back the current transaction and am       going to
terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
'
'
'
'
'
'
Server processes were terminated at Mon Mar 25 22:00:53 2002
Reinitializing shared memory and semaphores
DEBUG:  database system was interrupted at 2002-03-25 22:00:53 MET
DEBUG:  CheckPoint record at (13, 2751970248)
DEBUG:  Redo record at (13, 2751936936); Undo record at (0, 0); Shutdown FALSE
DEBUG:  NextTransactionId: 254232066; NextOid: 52967926
DEBUG:  database system was not properly shut down; automatic recovery in
progress...
DEBUG:  redo starts at (13, 2751936936)
DEBUG:  ReadRecord: record with zero len at (13, 2751970312)
DEBUG:  redo done at (13, 2751970248)
DEBUG:  database system is in production state

Thanks for an almost :) excellent  product.



Regards
Michael Beckstette

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-03-26 17:37:49
Subject: Re: Inconsistant use of index.
Previous:From: Ron MayerDate: 2002-03-26 17:06:39
Subject: Inconsistant use of index.

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