Streaming Replication Server Crash

Поиск
Список
Период
Сортировка
От raghu ram
Тема Streaming Replication Server Crash
Дата
Msg-id CALnrrJQ81icyt7EpzPwPuXPK0SbSv4+C8uyA=6Nwqh+mLw2hOw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Streaming Replication Server Crash  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: oracle_fdw
Следующее
От: Arvind Singh
Дата:
Сообщение: Re: Improve MMO Game Performance