Replika Sunucunun Kurulum Sonrası Çöküşü

Yeni bir PostgreSQL Replika sunucu kurmuştum ve çalışmaya başladıktan yaklaşık 5 saat sonra aşağıdaki hatayı vererek kendini kapatmıştı. Sorunu çözemeyip, yeniden bir replika kurulumu yaparak çalışmasını sağlamıştım ama hata burada dursun ileride lazım olabilir.

2013-02-03 19:40:12 EET [30490]: [1-1] user=,db= LOG: database system was interrupted while in recovery at log time  
2013-02-03 17:45:28 EET  
2013-02-03 19:40:12 EET [30490]: [2-1] user=,db= HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.  
2013-02-03 19:40:12 EET [30490]: [3-1] user=,db= LOG: entering standby mode  
2013-02-03 19:40:12 EET [30490]: [4-1] user=,db= LOG: restored log file "000000010000078300000036" from archive  
2013-02-03 19:40:12 EET [30490]: [5-1] user=,db= LOG: restored log file "000000010000078300000033" from archive  
2013-02-03 19:40:12 EET [30490]: [6-1] user=,db= LOG: redo starts at 783/33C1B878  
2013-02-03 19:40:12 EET [30490]: [7-1] user=,db= LOG: restored log file "000000010000078300000034" from archive  
2013-02-03 19:40:12 EET [30490]: [8-1] user=,db= LOG: restored log file "000000010000078300000035" from archive  
2013-02-03 19:40:13 EET [30490]: [9-1] user=,db= LOG: restored log file "000000010000078300000036" from archive  
2013-02-03 19:40:13 EET [30490]: [10-1] user=,db= LOG: restored log file "000000010000078300000037" from archive  
2013-02-03 19:40:13 EET [30490]: [11-1] user=,db= LOG: restored log file "000000010000078300000038" from archive  
2013-02-03 19:40:14 EET [30490]: [12-1] user=,db= LOG: restored log file "000000010000078300000039" from archive  
2013-02-03 19:40:14 EET [30490]: [13-1] user=,db= LOG: restored log file "00000001000007830000003A" from archive  
2013-02-03 19:40:14 EET [30490]: [14-1] user=,db= LOG: restored log file "00000001000007830000003B" from archive  
2013-02-03 19:40:15 EET [30490]: [15-1] user=,db= LOG: restored log file "00000001000007830000003C" from archive  
2013-02-03 19:40:15 EET [30490]: [16-1] user=,db= LOG: restored log file "00000001000007830000003D" from archive  
2013-02-03 19:40:16 EET [30490]: [17-1] user=,db= LOG: restored log file "00000001000007830000003E" from archive  
2013-02-03 19:40:16 EET [30490]: [18-1] user=,db= LOG: restored log file "00000001000007830000003F" from archive  
2013-02-03 19:40:16 EET [30490]: [19-1] user=,db= LOG: restored log file "000000010000078300000040" from archive  
2013-02-03 19:40:17 EET [30490]: [20-1] user=,db= LOG: restored log file "000000010000078300000041" from archive  
2013-02-03 19:40:17 EET [30490]: [21-1] user=,db= LOG: restored log file "000000010000078300000042" from archive  
2013-02-03 19:40:17 EET [30490]: [22-1] user=,db= LOG: restored log file "000000010000078300000043" from archive  
2013-02-03 19:40:18 EET [30490]: [23-1] user=,db= LOG: restored log file "000000010000078300000044" from archive  
2013-02-03 19:40:18 EET [30490]: [24-1] user=,db= LOG: restored log file "000000010000078300000045" from archive  
2013-02-03 19:40:19 EET [30490]: [25-1] user=,db= LOG: restored log file "000000010000078300000046" from archive  
2013-02-03 19:40:19 EET [30490]: [26-1] user=,db= LOG: restored log file "000000010000078300000047" from archive  
2013-02-03 19:40:19 EET [30490]: [27-1] user=,db= LOG: restored log file "000000010000078300000048" from archive  
2013-02-03 19:40:20 EET [30490]: [28-1] user=,db= LOG: restored log file "000000010000078300000049" from archive  
2013-02-03 19:40:20 EET [30490]: [29-1] user=,db= LOG: restored log file "00000001000007830000004A" from archive  
2013-02-03 19:40:20 EET [30490]: [30-1] user=,db= LOG: restored log file "00000001000007830000004B" from archive  
2013-02-03 19:40:21 EET [30490]: [31-1] user=,db= LOG: restored log file "00000001000007830000004C" from archive  
2013-02-03 19:40:21 EET [30490]: [32-1] user=,db= LOG: restored log file "00000001000007830000004D" from archive  
2013-02-03 19:40:21 EET [30490]: [33-1] user=,db= LOG: restored log file "00000001000007830000004E" from archive  
2013-02-03 19:40:22 EET [30490]: [34-1] user=,db= LOG: consistent recovery state reached at 783/4EE51078  
2013-02-03 19:40:22 EET [30487]: [1-1] user=,db= LOG: database system is ready to accept read only connections  
2013-02-03 19:40:22 EET [30490]: [35-1] user=,db= LOG: restored log file "00000001000007830000004F" from archive  
2013-02-03 19:40:22 EET [30490]: [36-1] user=,db= LOG: restored log file "000000010000078300000050" from archive  
2013-02-03 19:40:22 EET [30490]: [37-1] user=,db= LOG: restored log file "000000010000078300000051" from archive  
2013-02-03 19:40:23 EET [30490]: [38-1] user=,db= WARNING: page 152501 of relation pg_tblspc/39454576/PG_9.2_201204301/16416/14853906 is uninitialized  
2013-02-03 19:40:23 EET [30490]: [39-1] user=,db= CONTEXT: xlog redo visible: rel 39454576/16416/14853906; blk 152501  
2013-02-03 19:40:23 EET [30490]: [40-1] user=,db= PANIC: WAL contains references to invalid pages  
2013-02-03 19:40:23 EET [30490]: [41-1] user=,db= CONTEXT: xlog redo visible: rel 39454576/16416/14853906; blk 152501  
2013-02-03 19:40:52 EET [30487]: [2-1] user=,db= LOG: startup process (PID 30490) was terminated by signal 6: Aborted  
2013-02-03 19:40:52 EET [30487]: [3-1] user=,db= LOG: terminating any other active server processes  

Erkin Çakar

PostgreSQL DBA & Software developer