"termeau sebastien" <termeau at gmail.com> writes:
> 2007/11/22, termeau sebastien <XXXXXXXX>:
>
>           Hello,
>      
>      I am using Slony 1.2.12 with Postgresql 8.2.5
>      I have 2 nodes replicating a small database.
>      The replication works fine but when I try to use failover and switchover I got an error.
>      Failover and switchover were working perfectly before but now I can't use these features anymore, even I downgrade to Slony 1.2.9.
>      Can you please help to find the source of this error?
>      Thanks in advance
>      
>      #########################
>      <stdin>:6: PGRES_FATAL_ERROR select "_my_cluster".failedNode(1, 2);  - ERROR:  relation "PartInd_my_cluster_sl_log_2-" already exists
>      CONTEXT:  SQL statement "create index "PartInd_my_cluster_sl_log_2-node-2" on "_my_cluster".sl_log_2 USING btree(log_xid "_my_cluster".xxid_ops)
>      where (log_origin = 2);"
>      PL/pgSQL function "addpartiallogindices" line 34 at execute statement
>      SQL statement "SELECT  "_my_cluster".addPartialLogIndices()"
>      PL/pgSQL function "failednode" line 158 at perform
>      <stdin>:8: Failure to fail node 1 over to 2
>      #########################
>      
>
>
> Hello again,
> I am glad to be able to answer to my own question ...
> It seems that my cluster name is too long ( yes I replaced the name of the cluster in the exemples above by a fake one, for confidential purpose). Then it
> takes more than 64 char to write the index name PartInd_*.
> I had to rebuild postgresql with NAMEDATALEN=128 to solve my problem.

Ah, OK, I was getting worried that it might be a bug in the handling
of creation of the sl_log_N indices.

We probably ought to set up some constraint to prevent people from
creating cluster names so long that this sort of thing can happen.

I have set up a low priority bug for this...

http://www.slony.info/bugzilla/show_bug.cgi?id=15
-- 
output = ("cbbrowne" "@" "acm.org")
http://cbbrowne.com/info/wp.html
Rules of  the Evil Overlord  #149. "Ropes supporting  various fixtures
will not be  tied next to open windows  or staircases, and chandeliers
will be hung way at the top of the ceiling."
<http://www.eviloverlord.com/>