<div dir="ltr"><div><div>The problem is that starting with slony 2.1 slon connects to the database using parameter conninfo and init script takes it from /etc/sysconfig/slony1-93(which is redundant), moreover by default it connects to postgres on localhost not to the database you are replicating , cannot find _slonycluster schema and throws above error. Adding database name to /etc/sysconfig/slony1-93 won't help<br>
<br></div><div>I've changed in the init script /etc/init.d/slony1-93 the following line:<br>$SU -l postgres -c "$SLONDAEMON -f $SLONCONF -p $SLONPID $SLONCLUSTERNAME $SLONCONNINFO &" >> "$SLONLOGDIR/slonystartup.log" 2>&1 < /dev/null<br>
</div><div>to <br></div> $SU -l postgres -c "$SLONDAEMON -f $SLONCONF -p $SLONPID $SLONCLUSTERNAME '$SLONCONNINFO' &" >> "$SLONLOGDIR/slonystartup.log" 2>&1 < /dev/null<br><br>
</div>and that solved the problem<br><div><div> </div></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><div><span style="color:rgb(153,153,153)"><font size="1">Shamshinur Taktayeva<br></font></span></div>
<span style="color:rgb(153,153,153)"><font size="1"><a href="mailto:shurale9811@gmail.com" target="_blank">shurale9811@gmail.com</a><br></font></span></div><span style="color:rgb(153,153,153)"><font size="1">mob:4164536209</font></span><br>
</div></div>
<br><br><div class="gmail_quote">On Thu, Oct 17, 2013 at 5:08 AM, Sebastien Marchand <span dir="ltr"><<a href="mailto:smarchand@sgo.fr" target="_blank">smarchand@sgo.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
This error :<br>
<div class="im"> ERROR: relation "_sloncluster.sl_local_node_id" does not exist at<br>
character 30<br>
<br>
</div>Appear every 10 seconds in postgresql logs.<br>
<br>
But i do another replication on another server (repli_local111) and no error<br>
! same virtual server same scripts but no error...<br>
<br>
I will try to find the problem.<br>
<div class="im"><br>
-----Message d'origine-----<br>
De : Steve Singer [mailto:<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>]<br>
</div>Envoyé : mercredi 16 octobre 2013 19:34<br>
<div class="im HOEnZb">À : Sebastien Marchand<br>
Cc : <a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a><br>
Objet : Re: [Slony1-general] Problem slony 2.2 and pg 9.3 double replication<br>
<br>
</div><div class="HOEnZb"><div class="h5">On 10/16/2013 12:05 PM, Sebastien Marchand wrote:<br>
> No slon running because script launch slon after create set.<br>
><br>
> So i launch before and IT WORKS !!! thx master ! thanks you so much<br>
><br>
> I don't know what it change in slony 2.0.7 and 2.2 but before i could<br>
> do this<br>
><br>
> But now it's ok :)<br>
><br>
<br>
<br>
What SHOULD happen with 2.2 when the slon isn't running is that slonik<br>
should keep printing:<br>
<br>
waiting for event (1,5000000004) ...<br>
<br>
messages, that isn't an error that is an information message saying that it<br>
is waiting for the event to be propogated, and that won't happen unless<br>
slonik is running.<br>
<br>
What I don't understand is how you were getting<br>
<br>
2013-10-15 10:55:10.950 CEST >ERROR: relation<br>
"_sloncluster.sl_local_node_id" does not exist at character 30<br>
<br>
<br>
type messages.<br>
<br>
> -----Message d'origine-----<br>
> De : Steve Singer [mailto:<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>] Envoyé : mercredi<br>
> 16 octobre 2013 17:56 À : Sebastien Marchand Objet : Re:<br>
> [Slony1-general] Problem slony 2.2 and pg 9.3 double replication<br>
><br>
> On 10/16/2013 11:52 AM, Sebastien Marchand wrote:<br>
>> Yes that's why i will delete all replication 2.0 and migrate<br>
>> postgresql after i rebuild new replication.<br>
>><br>
>> when i've my error " waiting for event (1,5000000004) to be<br>
>> confirmed on node 110 " in postgresql if i do :<br>
>><br>
>> select * from _repli_local110.sl_path; => 1;110;"dbname=RPP2<br>
>> host=192.168.0.101 port=5432 user=slony<br>
>> password=123";10<br>
>><br>
>> Why just one line ?? i need two lines !<br>
>><br>
>> In my sl_event :<br>
>><br>
>> 110;5000000001;"2013-10-16<br>
>> 17:50:54.697374+02";"695958:695958:";"STORE_PATH";"1";"110";"dbname=R<br>
>> P<br>
>> P2<br>
>> host=192.168.0.101 port=5432 user=slony password=123";"10";"";"";"";""<br>
>><br>
>> I think there is a problem here... or not<br>
><br>
> Slonik when it executes the STORE PATH , it will insert a row in<br>
> sl_path on each node.<br>
><br>
> When slon is running it will then replicate the STORE_PATH event from<br>
> one node to the other to create the second sl_path row in each node.<br>
><br>
> Is your slon running?<br>
><br>
><br>
>><br>
>> -----Message d'origine-----<br>
>> De : Steve Singer [mailto:<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>] Envoyé : mercredi<br>
>> 16 octobre 2013 17:02 À : Sebastien Marchand Cc :<br>
>> <a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a> Objet : Re: [Slony1-general] Problem<br>
>> slony 2.2 and pg 9.3 double replication<br>
>><br>
>> On 10/16/2013 10:57 AM, Sebastien Marchand wrote:<br>
>>> I already tried to put in script but no change.<br>
>>><br>
>>> Can you tell me where is the line of code that is generating this error<br>
?<br>
>>> it's a sql function ?<br>
>>><br>
>>> I continue to search i need this to migrate.<br>
>><br>
>><br>
>><br>
>> slon_mkquery(&query, "select max(ev_seqno) FROM \"_%s\".sl_event"<br>
>> " , \"_%s\".sl_node "<br>
>> " where ev_origin= "<br>
>> " (select last_value from<br>
>> \"_%s\".sl_local_node_id) "<br>
>> " AND %s AND sl_node.no_id="<br>
>> " ev_origin"<br>
>> ,script->clustername, script->clustername,<br>
>> script->clustername, event_filter);<br>
>><br>
>><br>
>> In slonik.c<br>
>><br>
>><br>
>> slonik_get_last_event_id(SlonikStmt * stmt,<br>
>> SlonikScript * script,<br>
>> const char *event_filter,<br>
>> int64 **events)<br>
>><br>
>><br>
>> Also, if you are planning on migrating from 2.0 to 2.2 with UPDATE<br>
>> FUNCTIONS you should be aware of bug #320<br>
>><br>
>><br>
>>><br>
>>> -----Message d'origine-----<br>
>>> De : Steve Singer [mailto:<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>] Envoyé : mercredi<br>
>>> 16 octobre 2013 16:53 À : Sebastien Marchand Cc :<br>
>>> <a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a> Objet : Re: [Slony1-general] Problem<br>
>>> slony 2.2 and pg 9.3 double<br>
>> replication<br>
>>><br>
>>> On 10/16/2013 10:48 AM, Steve Singer wrote:<br>
>>>> On 10/16/2013 10:06 AM, Sebastien Marchand wrote:<br>
>>>>>> CLUSTER NAME = repli_local110 ;<br>
>>>>>> NODE 101 ADMIN CONNINFO = 'dbname=RPP2 host=192.168.0.101<br>
>>>>>> port=5432 user=slony password=password'; NODE 110 ADMIN CONNINFO<br>
>>>>>> =<br>
>>>>>> 'dbname=RPP2 host=192.168.0.110 port=5432 user=slony<br>
>>>>>> password=password';<br>
>>>>><br>
>>>>> It's the file repli_local110.preamble but for email i copy this<br>
>>>>> file in my script :)<br>
>>>><br>
>>><br>
>>> Actually IGNORE what I said below,<br>
>>> I hit send way too quickly before reviewing my output.<br>
>>><br>
>>> I am NOT yet able to reproduce this, but try pasting your preamble<br>
>>> inline and see if it works.<br>
>>><br>
>>> I think I see the line of code that is generating the error you are<br>
>>> seeing but I don't understand how/why it is substituting using<br>
>>> _sloncluster instead of repli_local10;<br>
>>><br>
>>><br>
>>><br>
>>><br>
>>>> Sometimes details are important.<br>
>>>><br>
>>>> Copy the preamble file inline into your script and it will work<br>
>>>> (like you did in your email)<br>
>>>><br>
>>>> I can reproduce your issue with the preamble moved to a different file.<br>
>>>> This is a bug, it shouldn't be hard to fix, thanks for reporting<br>
it.<br>
>>>> I suspect the fix will be included in 2.2.1 due in the next<br>
>>>> few weeks (since this has been a busy week for 2.2.0 bugs - ie #318<br>
>>>> and<br>
>> #320).<br>
>>>><br>
>>>><br>
>>><br>
>><br>
><br>
<br>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
</div></div></blockquote></div><br></div>