Re: Error con logical replication

motum hesa escribió:

> Esto me muestra el log después de activar log_connections:
>
> 93396: [unknown]: 2017-12-21 18:01:51 UTC : [unknown](at)xxx [unknown] :LOG:
> connection received: host=xxx port=14768
> 93396: [unknown]: 2017-12-21 18:01:51 UTC : replicador(at)xxx test :LOG:
> replication connection authorized: user=replicador SSL enabled
> (protocol=TLSv1.2, cipher=ECDHE-RSA-AES128-GCM-SHA256, compression=off)
> 93396: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :LOG:
> logical decoding found consistent point at 38A/9789A0D0
> 93396: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :DETAIL:
> There are no running transactions.
> 93397: [unknown]: 2017-12-21 18:01:52 UTC : [unknown](at)xxx [unknown] :LOG:
> connection received: host=xxxx port=19955
> 93397: [unknown]: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :LOG:
> replication connection authorized: user=replicador SSL enabled
> (protocol=TLSv1.2, cipher=ECDHE-RSA-AES128-GCM-SHA256, compression=off)
> 93397: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :LOG:
> starting logical decoding for slot "subtest"
> 93397: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :DETAIL:
> streaming transactions committing after 38A/9789A108, reading WAL from
> 38A/9789A0D0
> 93397: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :LOG:
> logical decoding found consistent point at 38A/9789A0D0
> 93397: subtest: 2017-12-21 18:01:52 UTC : replicador(at)xxx test :DETAIL:
> There are no running transactions.
>
> ps ax | grep 93397
> 93397 - Rs 1:07.54 postgres: wal sender process replicador
> xxxx(19955) (postgres)
>
> ps ax | grep 93396
>
> No hay proceso con ese PID

Por alguna razón los procesos se abren y se cierran de inmediato. Eso
es un bug pero falta información para poder depurarlo.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services