Estou trabalhando com o postgreSQL 9.2.3 com replicação,, ao fazer r o
slave se recuperar por aquivos de Wall o slave vem perdendo a
sincronização e parando post, retornando o seguinte log :
2016-11-11 23:27:51 BRST WARNING: page 153915 of relation
base/1112632/4839804 is uninitialized
2016-11-11 23:27:51 BRST CONTEXT: xlog redo vacuum: rel
1663/1112632/4839804; blk 153947, lastBlockVacuumed 153914
2016-11-11 23:27:51 BRST PANIC: WAL contains references to invalid pages
2016-11-11 23:27:51 BRST CONTEXT: xlog redo vacuum: rel
1663/1112632/4839804; blk 153947, lastBlockVacuumed 153914
2016-11-11 23:27:51 BRST LOG: startup process (PID 30277) was
terminated by signal 6: Aborted
2016-11-11 23:27:51 BRST LOG: terminating any other active server processes
agora ao tentar fazer a sincronização de novo, ao termino ele retorna
no seguinte log e ja para o postgreSQL
2016-11-15 18:27:18 BRST LOG: streaming replication successfully
connected to primary
2016-11-15 18:40:43 BRST WARNING: page 3711319 of relation
base/36523/5016501 is uninitialized
2016-11-15 18:40:43 BRST CONTEXT: xlog redo delete: index
1663/36523/5016505; iblk 606571, heap 1663/36523/5016501;
2016-11-15 18:40:43 BRST PANIC: WAL contains references to invalid pages
2016-11-15 18:40:43 BRST CONTEXT: xlog redo delete: index
1663/36523/5016505; iblk 606571, heap 1663/36523/5016501;
2016-11-15 18:40:43 BRST LOG: startup process (PID 17115) was
terminated by signal 6: Aborted
2016-11-15 18:40:43 BRST LOG: terminating any other active server processes
2016-11-15 18:40:43 BRST WARNING: terminating connection because of
crash of another server process
2016-11-15 18:40:43 BRST DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2016-11-15 18:40:43 BRST HINT: In a moment you should be able to
reconnect to the database and repeat your command.
estou enviando os arquivos de wall pelo rsync para um diretório no slave
e usando pg_archivecleanup . Alguém já passou por uma situação parecida ?
--
*Att. Mauricio Martini*| TI
Sysmo Sistemas Ltda
São Miguel do Oeste - SC | Filial: Itajaí - SC
Fone: 49 3631.0600 | Ramal: 653
www.sysmo.com.br <http://www.sysmo.com.br>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
