You didn't specified in what server you removed the cluster.Maybe the
sequences on your remote server are all outdated.

2008/12/4 zferentz <zferentz at gmail.com>

>
> Hi,
>
> (First, i'd like to apologize , i've accidently submited this question to
> another group...)
>
> I've encountered two different problems that related to simple master/sla=
ve
> topology, i'd appreciate any help...
>
> First problem:
> my replication works just fine  (single master , single slave on remote
> machine) . however - when  I remove the cluster (schema) either by GUI
> (pgAdmin ) or by "DROP" script or by slonik script, i cannot add new items
> to my tables. i get "duplicate key value violates unique constraint" with
> my
> primary-key.
> I've noticed that the problem starts the moment i start the "slon" script,
> and the problem doesn't disappear even when i stopped/remove the slony
> cluster.
>
> Second problem:
> when i'm executing the "failover" script (as described in the
> documetnation)
> i get some  weird errors :
>
>     ERROR:  INSERT has more expressions than target columns
>      CONTEXT:  SQL statement "INSERT INTO "_esa_cluster".sl_event
> (ev_origin,         ev_seqno, ev_timestamp, ev_snapshot, ev_type, ev_data=
1,
> ev_data2, ev_data3, ev_data4)      values ( $1 ,
> "pg_catalog".nextval('"_esa_cluster".sl_event_seq'), CURRENT_TIMESTAMP,
> '0',
> '0', '0:0:', 'ACCEPT_SET',  $2 ::text,  $3 ::text,  $1 ::text,  $4 ::text=
)"
>     PL/pgSQL function "failoverset_int" line 35 at SQL statement
>     SQL statement "SELECT  "_esa_cluster".failoverSet_int( $1 ,  $2 ,  $3=
 ,
> $4 )"
>     PL/pgSQL function "failednode2" line 39 at PERFORM
>
> The net result of the two problems is that the slave is not usable , so i
> cannot use slony...
>
> I'm using Debian ,and everything was built from sourcecode (postgres-8.3.4
> ,
> slony1-2.0.0-rc2)
>
>
> Any help would be appreciated...
> --
> View this message in context:
> http://www.nabble.com/Slony-%282.0.0rc2%29-SLAVE-Failures-...-Help....-tp=
20829231p20829231.html
> Sent from the Slony-I -- General mailing list archive at Nabble.com.
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081205/=
401b27db/attachment.htm