What could cause total crash of a postgres installation? - Mailing list pgsql-general

From Peter Alberer
Subject What could cause total crash of a postgres installation?
Date
Msg-id 000001c2978f$0a8e7160$5be0d089@ekelhardt
Whole thread Raw
Responses Re: What could cause total crash of a postgres installation?
Re: What could cause total crash of a postgres installation?
List 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


pgsql-general by date:

Previous
From: Han Holl
Date:
Subject: Re: How to access OLD and NEW with rule on update
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: What could cause total crash of a postgres installation?