What could cause total crash of a postgres installation?

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What could cause total crash of a postgres installation?
Date: 2002-11-29 10:06:53
Message-ID: 000001c2978f$0a8e7160$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Since about three days I am having strange problems with my postgresl
installation. Today in the morning at about 2am the database crashed
completely. I had the postmaster running at debug level 2 but no hint
can be found in the log. The server seemed to crash without notice.

2002-11-29 02:39:01 [3294] DEBUG: StartTransactionCommand
2002-11-29 02:39:01 [3294] DEBUG: query: select preface as
preface_txt,abstract as abstract_txt,display_type,section_auto_
numbering,lr_book_revision_id as revision_id from lr_books where
lr_book_revision_id = '115876';
2002-11-29 02:39:01 [3294] DEBUG: ProcessQuery
2002-11-29 02:39:01 [3294] DEBUG: CommitTransactionCommand
2002-11-29 02:39:01 [3294] DEBUG: QUERY STATISTICS
! system usage stats:
! 0.001286 elapsed 0.000000 user 0.000000 system sec
! [456.870000 user 12.170000 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 0/0 [57092/25680] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [0/0] voluntary/involuntary context switches
! postgres usage stats:
! Shared blocks: 0 read, 0 written, <- last
entry

At that time more or less nothing was going on in the system. I was
already collection all kinds of log information, but I can find nothing
unusual. I could start the database with no problems.

What kind of problems could cause such a crash? Could bad memory
settings (sort, buffers) cause something like that? What kind of server
statistics should I look at?

Many TIA,

peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-11-29 10:15:47 Re: What could cause total crash of a postgres installation?
Previous Message Han Holl 2002-11-29 09:49:32 Re: How to access OLD and NEW with rule on update