[Slony1-general] SLONY waiting por event tobe confirmed never end

Fontana Daniel C (Desartec S.R.L.) desartecsrl at gmail.com
Mon Jun 8 14:51:35 UTC 2020


Hi i am trying to do my first sync with slony 2.2.6. and PostgreSQL version
10,windows 7 on both terminals.

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 script for slonik

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 script for slonik

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?




More information about the Slony1-general mailing list