postmaster crash - Mailing list pgsql-bugs
From | Michael Beckstette |
---|---|
Subject | postmaster crash |
Date | |
Msg-id | 1020326181802.ZM3107@teak.TechFak.Uni-Bielefeld.DE Whole thread Raw |
Responses |
Re: postmaster crash
|
List | 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
pgsql-bugs by date: