Thread: SLONY waiting por event tobe confirmed never end
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?
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@gmail.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"