Fri Dec 10 21:48:34 PST 2004
- Previous message: [Slony1-general] Adding tables to an existing set in Slony1?
- Next message: [Slony1-general] Adding tables to an existing set in Slony1?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks for the quick reply. In this simple test case, the two tables
that I'm adding are empty; the application will handle filling the
master at some point after the database is prepared. However, I've run
into a strange problem: I can't subscribe the new, temporary set.
Here's the script that I'm using (assume the env vars are correct):
${SLONIK} <<EOF
cluster name=$CLUSTER_NAME;
node 1 admin conninfo = '$MASTER_CONNINFO';
node 2 admin conninfo = '$SLAVE_CONNINFO';
echo 'create a new temp set';
try {
# 110 is the current MAX(tab_id)
create set ( id = $TEMP_SET_ID, origin = 1, comment = 'temporary set'
);
echo 'new set created';
set add table ( set id = $TEMP_SET_ID, origin = 1, id = 111, full
qualified name = 'public.foo' );
set add table ( set id = $TEMP_SET_ID, origin = 1, id = 112, full
qualified name = 'public.bar' );
echo 'new tables added';
subscribe set ( id = $TEMP_SET_ID, provider = 1, receiver = 2,
forward = no );
echo 'subscription ok';
} on success {
echo 'OK!';
} on error {
echo 'failure!';
}
EOF
The script fails at the subscribe, as so:
<stdin>:24: PGRES_FATAL_ERROR select "_tii".subscribeSet(5, 1, 2, 'f');
- ERROR: Slony-I: set 5 not found
I can't find anything more interesting in the logs; should I bump up
the level of logging on the backend?
Thanks,
jfb
--
What can be said at all can be said clearly; and what we cannot speak
about we must pass over in silence.
- Previous message: [Slony1-general] Adding tables to an existing set in Slony1?
- Next message: [Slony1-general] Adding tables to an existing set in Slony1?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list