Slony1 PostgreSQL Replication - Problem with Database Replication

Author

Problem with Database Replication

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

Hiroshi Saito

2005-08-08, 3:25 am

From: "Steven Prasetya"

> 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.

Probably, There may be no libpq of yours at thread-safe...
"could not receive data from server" is libpq-message.

In the reason I do not know your environment, this is reference.

Regards,
Hiroshi Saito

cbbrowne-swQf4SbcV9C7WVzo/KQ3Mw@public.gmane.org

2005-08-08, 9:24 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 proble=
ms
> -
> see bug 1226
> <stdin>:4: NOTICE:
> http://gborg.postgresql.org/project...update.php?1226

The thing you ought to check on is what are the contents of the table
_sl_cluster.sl_table.

I expect that you'll find that there aren't any.

That would imply that the replication set has no tables (as indicated by
the message) and that it should not be any surprise that you run into the
conditions described by bug #1226.

Read the documentation that the warning messages are pointing you to; the=
y
should be quite helpful in explaining why you are encountering this
problem.

Sponsored Links