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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-03-26 17:37:49 | Re: Inconsistant use of index. |
Previous Message | Ron Mayer | 2002-03-26 17:06:39 | Inconsistant use of index. |