Streaming Replication Server Crash

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Streaming Replication Server Crash
Date: 2012-10-19 08:40:21
Message-ID: CALnrrJQ81icyt7EpzPwPuXPK0SbSv4+C8uyA=6Nwqh+mLw2hOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi All,

We have configured Streaming Replication b/w Primary and Standby server and
Pgpool-II load balancing module diverting SELECT statements to Standby
server. As per our observations, Standby server crashed during peak hours
on today and error message as follows:

2012-10-19 12:26:43 IST [11934]: [1-1] user=postgres,db=hmis LOG:
duration: 20345.702 ms execute <unnamed>: SELECT DISTINCT
y.ais_insm_name,y.ais_insm_type,ha_dism_name,ha_hudm_name,x2.ais_equip_receipt_details_value_lov,
x3.ais_equip_receipt_details_value,x4.ais_equip_receipt_details_value,
mast_frm_freq, t_report_code, t_report_date, t_report_month,
t_report_year,t_report_createdate,t_report_date2, t_report_month2,
t_report_year2,mast_frm_validity_days FROM TNHSPTOOL_FORM_MASTER,
TRAN_712_MASTER full join ais_institution_master as y on(
t_instiution_code = y.ais_insm_code) full join ha_district_master on(
t_district_code=ha_dism_code ) full join ha_hud_master on(
t_hud_code=ha_hudm_code )full join tran_712_664 x2 on
(x2.t_rep_code=t_report_code and x2.t_rep_rowno=3) full join tran_712_664
x3 on (x3.t_rep_code=t_report_code and x3.t_rep_rowno=5) full join
tran_712_664 x4 on (x4.t_rep_code=t_report_code and x4.t_rep_rowno=36)
WHERE mast_frm_code = T_REPORT_FRMID AND y.ais_insm_code ='00231' and
T_REPORT_FRMID =712 and T_REPORT_OLDFLAG='O' ORDER BY T_REPORT_CODE DESC

2012-10-19 12:26:46 IST [1338]: [18-1] user=,db= LOG: server process (PID
15565) was terminated by signal 10

2012-10-19 12:26:46 IST [1338]: [19-1] user=,db= LOG: terminating any
other active server processes

2012-10-19 12:26:46 IST [18450]: [3-1] user=postgres,db=DBHMS WARNING:
terminating connection because of crash of another server process

Standby Server configuration Details as follows:

> max_wal_senders = 5
> wal_sender_delay = 200ms
> wal_keep_segments = 128
> vacuum_defer_cleanup_age = 0
> hot_standby = on
> max_standby_archive_delay = -1
> max_standby_streaming_delay = -1

PostgreSQL version: 9.0.4
OS: Solaris 64bit

Could you please share your inputs,to fix this issue.

Thanks & Regards,

Raghu Ram

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Heath 2012-10-19 10:55:02 Cannot close 'an error has occurred' dialogue box
Previous Message Shams Khan 2012-10-19 07:14:33 User creation

Browse pgsql-general by date

  From Date Subject
Next Message Arvind Singh 2012-10-19 09:49:25 Re: Improve MMO Game Performance
Previous Message Albe Laurenz 2012-10-19 08:38:08 Re: oracle_fdw