Re: SLONY waiting por event tobe confirmed never end

Hi Fontana,

This is a pgAdmin mailing list and does not support slonik. Probably, ask
the question to the slonik team.

On Mon, Jun 8, 2020 at 6:41 PM Fontana Daniel C (Desartec S.R.L.) <
desartecsrl(at)gmail(dot)com> wrote:

> Hi i am trying to do my first sync with slony 2.2.6. and PostgreSQL version
> 10
>
> Server IP = 192.168.1.229
> Slave IP = 192.168.1.252
>
> Just a basic table
> CREATE TABLE dba.prueba
> (
> id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1
> START
> 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
> descripcion character(100) COLLATE pg_catalog."default" NOT NULL,
> CONSTRAINT prueba_pkey PRIMARY KEY (id)
> )
> WITH (
> OIDS = FALSE
> )
> TABLESPACE pg_default;
>
> ALTER TABLE dba.prueba
> OWNER to postgres;
>
> On the master node
>
> cluster name = sync_articulos;
> node 1 admin conninfo = 'dbname = 30711404879 host = 192.168.1.229 port =
> 5434 user = replicator password = 1234';
> node 2 admin conninfo = 'dbname = 30711404879 host = 192.168.1.252 port =
> 5434 user = replicator password = 1234';
> INIT CLUSTER ( ID = 1, COMMENT = 'nodo maestro' );
> CREATE SET ( ID = 1, ORIGIN = 1, COMMENT = 'aqui van todas mis tablas' );
> set add table (set id=1, origin=1, id=1, fully qualified name =
> 'dba.prueba', comment = 'tabla articulos');
> store node (id = 2, comment = 'nodo esclavo', EVENT NODE = 1);
> store path (server = 1, client = 2, conninfo = 'dbname = 30711404879 host =
> 192.168.1.229 user = replicator password = 1234');
> store path (server = 2, client = 1, conninfo = 'dbname = 30711404879 host =
> 192.168.1.252 user = replicator password = 1234');
> store listen (origin = 1, provider = 1, receiver = 2);
> store listen (origin = 2, provider = 2, receiver = 1);
>
> When i run
>
> C:\Program Files\PostgreSQL\10\bin>slonik maestro.com
> maestro.com:14: Possible unsupported PostgreSQL version (101300) 10.13,
> defaulti
> ng to 8.4 support
> maestro.com:34: Possible unsupported PostgreSQL version (101300) 10.13,
> defaulti
> ng to 8.4 support
> maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2
> maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2
> maestro.com:39: waiting for event (1,5000000007) to be confirmed on node 2
> and continues.....
>
> on the slave node
>
> cluster name = sync_articulos;
> node 1 admin conninfo = 'dbname = 30711404879 host = 192.168.1.229 port =
> 5434 user = replicator password = 1234';
> node 2 admin conninfo = 'dbname = 30711404879 host = 192.168.1.252 port =
> 5434 user = replicator password = 1234';
> SUBSCRIBE SET ( ID = 1, PROVIDER = 1, RECEIVER = 2, FORWARD = YES);
>
> When i run
>
> c:\Program Files\PostgreSQL\10\bin>slonik esclavo.com
> waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1
> waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1
> waiting for events (2,5000000001) only at (2,0) to be confirmed on node 1
> and continues.....
>
>
> !these processes never end!, what is the problem?
>
>
>
>
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"