[prev in list] [next in list] [prev in thread] [next in thread]
List: slony1-general
Subject: [Slony1-general] Re: Slony1-general Digest, Vol 22, Issue 13
From: Melvin Davidson <mdavidson () cctus ! com>
Date: 2005-11-14 17:19:16
Message-ID: 4378C714.2020601 () cctus ! com
[Download RAW message or body]
>On Friday November 11 2005 3:02 pm, Melvin Davidson wrote:
>> I am trying to set up a simple 3 node rep schema.
>>
>> Server A -> Slave 1-> Slave2
>> db1( tbl1) db1(tbl1) db1(tbl1)
>>
>> I have no problem implementing Server A -> Slave 1, but when
>> I try with the 3rd node, (Slave 2), I get
>>
>> [postgres@slv postgres]$ ./slony_reverse.sh
>> <stdin>:105: loading of file
>> /usr/local/pgsql/share//xxid.v74.sql: PGRES_FATAL_ERROR ERROR:
>> current transaction is aborted, commands ignored until end of
>> transaction block
>> ERROR: current transaction is aborted, commands ignored until
>> end of transaction block
>What does your server log show as the statement causing the first
>error?
>Ed
____________________________________________________________
Thanks for all that responded.
Apparently I had a slight case of brain fog.
The original problem was due to the 3rd server node
not being started. DUH!
However, I have now come to a second, and hopefully
final problem.
I am able to have the second node to successfully
subscribe to the set, however, attempting to execute
*slave_node3_subscribe.sh* to subscribe the third node
fails with:
*-bash: ./slony_reverse_slv1.sh: Permission denied*
The following are the scripts involved.
define_nodes_and_sets.sh <- This script executes correctly
=====================================================================
slonik <<_EOF_
CLUSTER NAME = $SLONYCLUSTER;
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=$PGPORT user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
port=$PGPORT user=$REPLICATIONUSER';
node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$MASTERHOST
port=5450 user=$REPLICATIONUSER';
init cluster ( id=1, comment = 'Comet Master Node');
CREATE SET (ID=1, ORIGIN=1, COMMENT = 'Comet tables');
SET ADD TABLE (SET ID=1, ORIGIN=1, ID=101, FULLY QUALIFIED NAME =
'slony.table1', comment='table1');
store node (id=2, comment = 'Slony Slave node');
store node (id=3, comment = 'Slony Reverse Slave node');
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME
host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER ');
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME
host=$SLAVEHOST port=$PGPORT user=$REPLICATIONUSER ');
store path (server = 3, client = 2, conninfo='dbname=$REVERSESLAVEDB
host=$MASTERHOST port=5450 user=$REPLICATIONUSER ');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
store listen (origin=3, provider = 3, receiver =2);
store listen (origin=2, provider = 2, receiver =3);
slave_node2_subscribe.sh <- This script executes correctly
=====================================================================
#!/bin/sh
slonik <<_EOF_
cluster name = $SLONYCLUSTER;
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=5480 user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST port=5480
user=$REPLICATIONUSER';
# ----
# Node 2 subscribes sets
# ----
subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
slave_node2_subscribe.sh <- This script fails when executed
=====================================================================
#!/bin/sh
slonik <<_EOF_
node 1 admin conninfo = 'dbname=$MASTERDB host=$MASTERHOST port=5480
user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$REVERSEMASTERDB host=$REVERSEHOST
port=5480 user=$REPLICATIONUSER';
node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$REVERSESLAVE
port=5450 user=$REPLICATIONUSER';
subscribe set ( id = 1, provider = 2, receiver = 3, forward = no);
[Attachment #3 (text/html)]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
>On Friday November 11 2005 3:02 pm, Melvin Davidson wrote:<br>
<br>
>> I am trying to set up a simple 3 node rep schema.<br>
>><br>
>> Server A -> Slave 1-> Slave2<br>
>> db1( tbl1) db1(tbl1) db1(tbl1)<br>
>><br>
>> I have no problem implementing Server A -> Slave 1, but
when<br>
>> I try with the 3rd node, (Slave 2), I get<br>
>><br>
>> [postgres@slv postgres]$ ./slony_reverse.sh<br>
>> <stdin>:105: loading of file<br>
>> /usr/local/pgsql/share//xxid.v74.sql: PGRES_FATAL_ERROR ERROR:<br>
>> current transaction is aborted, commands ignored until end of<br>
>> transaction block<br>
>> ERROR: current transaction is aborted, commands ignored until<br>
>> end of transaction block<br>
<br>
<br>
>What does your server log show as the statement causing the first <br>
>error?<br>
<br>
>Ed<br>
____________________________________________________________<br>
<br>
Thanks for all that responded.<br>
Apparently I had a slight case of brain fog. <br>
The original problem was due to the 3rd server node<br>
not being started. DUH!<br>
<br>
However, I have now come to a second, and hopefully<br>
final problem.<br>
<br>
I am able to have the second node to successfully<br>
subscribe to the set, however, attempting to execute<br>
<font color="#3333ff"><b>slave_node3_subscribe.sh</b></font> to
subscribe the third node <br>
fails with:<br>
<br>
<b><font color="#ff0000">-bash: ./slony_reverse_slv1.sh: Permission
denied</font></b><br>
<br>
The following are the scripts involved.<br>
<br>
define_nodes_and_sets.sh <- This script executes correctly<br>
=====================================================================<br>
slonik <<_EOF_<br>
<br>
CLUSTER NAME = $SLONYCLUSTER;<br>
<br>
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=$PGPORT user=$REPLICATIONUSER';<br>
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
port=$PGPORT user=$REPLICATIONUSER';<br>
node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$MASTERHOST
port=5450 user=$REPLICATIONUSER';<br>
<br>
init cluster ( id=1, comment = 'Comet Master Node');<br>
<br>
CREATE SET (ID=1, ORIGIN=1, COMMENT = 'Comet tables');<br>
<br>
SET ADD TABLE (SET ID=1, ORIGIN=1, ID=101, FULLY QUALIFIED NAME =
'slony.table1', comment='table1');<br>
<br>
store node (id=2, comment = 'Slony Slave node');<br>
store node (id=3, comment = 'Slony Reverse Slave node');<br>
<br>
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME
host=$MASTERHOST port=$PGPORT user=$REPLICATIONUSER ');<br>
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME
host=$SLAVEHOST port=$PGPORT user=$REPLICATIONUSER ');<br>
store path (server = 3, client = 2, conninfo='dbname=$REVERSESLAVEDB
host=$MASTERHOST port=5450 user=$REPLICATIONUSER ');<br>
<br>
store listen (origin=1, provider = 1, receiver =2);<br>
store listen (origin=2, provider = 2, receiver =1);<br>
store listen (origin=3, provider = 3, receiver =2);<br>
store listen (origin=2, provider = 2, receiver =3);<br>
<br>
<br>
slave_node2_subscribe.sh <- This script executes correctly<br>
=====================================================================<br>
#!/bin/sh<br>
slonik <<_EOF_<br>
cluster name = $SLONYCLUSTER;<br>
<br>
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=5480 user=$REPLICATIONUSER';<br>
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST port=5480
user=$REPLICATIONUSER';<br>
<br>
# ----<br>
# Node 2 subscribes sets<br>
# ----<br>
subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);<br>
<br>
<br>
slave_node2_subscribe.sh <- <font color="#ff0000">This script fails
when executed</font><br>
=====================================================================<br>
#!/bin/sh<br>
slonik <<_EOF_<br>
<br>
node 1 admin conninfo = 'dbname=$MASTERDB host=$MASTERHOST port=5480
user=$REPLICATIONUSER';<br>
node 2 admin conninfo = 'dbname=$REVERSEMASTERDB host=$REVERSEHOST
port=5480 user=$REPLICATIONUSER';<br>
node 3 admin conninfo = 'dbname=$REVERSESLAVEDB host=$REVERSESLAVE
port=5450 user=$REPLICATIONUSER';<br>
<br>
subscribe set ( id = 1, provider = 2, receiver = 3, forward = no);<br>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic