Mon Aug 8 03:12:57 PDT 2005
- Previous message: [Slony1-general] Problem with Database Replication
- Next message: [Slony1-general] Problem with Database Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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/slony1/bugs/bugupdate.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 at streamshield.com> > To: "Steven Prasetya" <steven.prasetya at globalmobility.net>; > <slony1-general-bounces at gborg.postgresql.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 > > slon sql_cluster "dbname=contactdb user=postgres" >> outputfile1 & > > slon sql_cluster "dbname=contactdb_slave user=postgres" >> outputfile2 > & > > 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050808/a4c016da/attachment-0001.html
- Previous message: [Slony1-general] Problem with Database Replication
- Next message: [Slony1-general] Problem with Database Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list