| Steven Prasetya 2005-08-08, 3:25 am |
| Hi,
I've run the daemon and got the following message when I tried to subscribe:
<stdin>:4: NOTICE: subscribeSet:: set 1 has no tables - risk of problems -
see bug 1226
<stdin>:4: NOTICE:
http://gborg.postgresql.org/project...update.php?1226
I read "outputfile1" and found this kind of message:
ERROR remoteListenThread_2
: "select ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip, ev_type,
ev_data1, ev_data2, ev_data3, ev_data4, ev_data5,
ev_data6, ev_data7, ev_data8 from "_sql_cluster".
sl_event e where (e.ev_origin = '2' and e.ev_seqno > '0') order by
e.ev_origin, e.ev_seqno" - could not receive data from serv
er: Error 0
What is wrong this time? I'm really stuck here. Thanks a lot for your help.
Regards,
Steven
----- Original Message -----
> From: "Victoria Parsons" <victoria.parsons- UVxggvuNoGJxTUc3asy8
/Q@public.gmane.org>
> To: "Steven Prasetya" <steven.prasetya-SnPfbo0DsQ3Jp/ IOKR4046xOck334EZe@p
ublic.gmane.org>;
> <slony1-general-bounces- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org>
> Sent: Friday, August 05, 2005 4:27 PM
> Subject: RE: [Slony1-general] Problem with Database Replication
>
>
> Do you still get this warning?
>
> stdin>:4: NOTICE: subscribeSet:: set 1 has no tables - risk of problems
> - see bug 1226
>
> I think the set will still subscribe, this is just a warning not an
> error. You can see if a set is subscribed by looking in
> _sql_cluster.sl_subscribe on the master. There should be a single entry
> for the slave node in there.
>
> Please post the error you are seeing when you try to subscribe the set.
>
> Make sure you are running a slon daemon for each node with commands
> &
>
> You can run these after the first of your scripts before you try and
> subscribe the set. The subscription will not take place until the slons
> are running. Check the output files for any errors that may give a clue
> as to what is not set up properly.
>
> Vicki
|