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
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 |