Re: More problems with Golden Gate

Postgres log contains the following:

|2024-01-11 20:33:30.178 EST [4690] LOG:  could not receive data from client: Connection reset by peer
2024-01-11 20:33:30.178 EST [4691] LOG:  could not receive data from client: Connection reset by peer
(END)|
|
|
I verified the connectivity by installing psql client onto the Oracle side. Connection goes seamlessly. The only idea left is that the port 6666 that I am using for the manager process is no good. I am too tired to devote too much time to this tonight. I'll switch back to default port tomorrow.

On 1/11/24 19:25, Mladen Gogala wrote:
>
> have another, rather strange problem. My REPLICAT is running and
> opening files, but the transactions are not getting applied. Here is
> what I have:
>
>
> GGSCI (pgsql16.home.com) 1> info all
>
> Program     Status      Group       Lag at Chkpt  Time Since Chkpt
>
> MANAGER     RUNNING
> REPLICAT    RUNNING     PGREP       00:00:00      00:00:08
>
>
> GGSCI (pgsql16.home.com) 2> info replicat pgrep
>
> Replicat   PGREP     Last Started 2024-01-11 16:53   Status RUNNING
> Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
> Process ID           4730
> Log Read Checkpoint  File ./dirdat/pr000000003
>                      2024-01-11 16:54:16.299849  RBA 1412
>
> I am loading 5M rows on the Oracle side and I expected to see them on
> the Postgres side. Unfortunately, that is not happening.
>
> postgres_at_pgsql16 dirprm]$ psql -U scott
> psql (13.13)
> Type "help" for help.
>
> scott=> select count(*) from test_tab;
>  count
> -------
>      0
> (1 row)
>
> I attached  my ggserr.log and PGREP.rpt. I don't see any problems
> there. I tried fixing it with defgen, but defs are getting ignored
> since trail files contain metadata.  Trail files are being opened
>
> postgres_at_pgsql16 GG_home]$ ls -l dirdat
> total 8
> -rw-r----- 1 postgres postgres 1412 Jan 11 16:54 pr000000002
> -rw-r----- 1 postgres postgres 1412 Jan 11 16:54 pr000000003
>
> However, the files are rather small:
>
> [postgres_at_pgsql16 GG_home]$ du -h ./dirdat/pr*
> 4.0K    ./dirdat/pr000000002
> 4.0K    ./dirdat/pr000000003
>
> I don't know where to look for a clue.
>
> Thank you very much for your help.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l