<br>Greetings Bogdan;<br><br><div class="gmail_quote">On Fri, Mar 12, 2010 at 5:29 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">
> If I start OpenSIPs and then on the .100 DB do an iptables REJECT to<br>
> simulate a DB problem OpenSIPs will simply retry the alias lookup<br>
> infinitely.<br>
</div><br>the retry is from mysql lib or from opensips mysql module ?<br></blockquote><div><br>You know, I'm not sure. The way I knew it was retrying was by watching port 3306 traffic via ngrep. How would be able to tell which lib was initiating the retry?<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">><br>
> Curiously, if I set up the iptables block, THEN start OpenSIPs, and<br>
> toggle the block on and off, the failure mode appears to work as it<br>
> should, which really confuses me.<br>
</div>The difference may come from the fact that the failure is detected at<br>
startup - if you start with the DB server down, opensips will not<br>
connect at all at that DB.<br>
<br>
Have you tried to start opensips with all DB servers up and simple stop<br>
the primary one ? does this case work ?<br></blockquote><div><br>No, unfortunately not. This case it retries repeatedly without end, apparently.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">><br>
> Have I got an issue with how I expect this to work? How I've got it<br>
> set up? Or do we think my testing methodology is bunk?<br>
</div>I would rather say there is something wrong in the DB virtual...<br>
<br>
I will try asap to make a test setup to see what exactly is going on<br></blockquote><div> <br>Thank you very much, Bogdan! Let me know what I can do to help, if anything.<br><br> - Jock<br></div></div><br>