database system was interrupted sometimes untill we restart it can be used

From: snowsnake <sheleishe(at)sina(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: database system was interrupted sometimes untill we restart it can be used
Date: 2014-05-30 08:59:46
Message-ID: 1401440386089-5805533.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

postgresql 8.1.11
we found the database can't be connected at 2014/5/9 23:00 and 2014/5/10
17:03 which you can see from below log. We checked the CUP and memory also,
it is normal. And the server generated many postmaster process at the
interrupted time. Untill we restart the database, it becomes normal. So why
this could happens?

DB log : 5/9 23:00 ~ 00:00
tail postgresql-Fri.log
[PID=16483]: [user=ec_operator,db=eservice,ip=10.100.66.37][time=2014-05-09
23:00:03 CST]LOG: duration: 0.024 ms
[PID=16485]: [user=ec_operator,db=eservice,ip=10.100.66.37][time=2014-05-09
23:00:03 CST]LOG: statement: <BIND>

head postgresql-Sat.log
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: database
system was interrupted at 2014-05-09 23:01:04 CST
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: checkpoint
record is at CCF/66A731F8
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: redo record
is at CCF/66A731F8; undo record is at 0/0; shutdown FALSE
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: next
transaction ID: 1752693096; next OID: 1143806
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: next
MultiXactId: 1; next MultiXactOffset: 0
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: database
system was not properly shut down; automatic recovery in progress
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: record with
zero length at CCF/66A73248
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: redo is not
required
[PID=5263]: [user=,db=,ip=][time=2014-05-10 00:15:58 CST]LOG: database
system is ready

5/10 19:00~20:00
[PID=13060]: [user=ec_operator,db=eservice,ip=10.100.66.37][time=2014-05-10
19:03:21 CST]LOG: statement: EXECUTE <unnamed> [PREPARE: select
currval('public.ec_messagebackup_id_seq')]
[PID=13060]: [user=ec_operator,db=eservice,ip=10.100.66.37][time=2014-05-10
19:03:21 CST]LOG: duration: 0.032 ms
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: database
system was interrupted at 2014-05-10 19:05:21 CST

head 2014051020_21
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: database
system was interrupted at 2014-05-10 19:05:21 CST
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: checkpoint
record is at CD2/41498F80
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: redo record
is at CD2/41498F80; undo record is at 0/0; shutdown FALSE
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: next
transaction ID: 1754216008; next OID: 1151998
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: next
MultiXactId: 1; next MultiXactOffset: 0
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: database
system was not properly shut down; automatic recovery in progress
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: record with
zero length at CD2/41498FD0
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: redo is not
required
[PID=19628]: [user=,db=,ip=][time=2014-05-10 20:52:24 CST]LOG: database
system is ready

--
View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-was-interrupted-sometimes-untill-we-restart-it-can-be-used-tp5805533.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2014-05-30 12:00:44 Re: Error while upgrading from 8.4 to 9.3
Previous Message Dmitry Samonenko 2014-05-30 07:44:07 Re: Fwd: libpq: indefinite block on poll during network problems