sqlrelay-discussion

[Sqlrelay-discussion] setConnectTimeout() not working correctly?

[Cal H. <ca...@fb...>]

Hi David,

I'm attempting to write a weighted round-robin connection method for an
easy failover mechanism on multiple SQL Relay servers.  It appears that the
C++ sqlrconnection::setConnectTimeout() function isn't behaving like I'd
expect.  It seems that no matter what values I pass to it, the connection
*always* fails.

Here's the general idea I'm doing:

bool success = false;
do
{
     /*
       select random sql relay server
      */

      tmpconn = new sqlrconnection(hostname, port, NULL,
            user, pass, 0, 1);
      tmpconn->debugOn();
      tmpconn->setConnectTimeout(10, 5000000);

      const char *version = tmpconn->serverVersion();
      printf("version: '%s'\n", version);
      if ( version )
         success = true;

      /* Breaking out after a few tries */
}
while ( success == false );

Running that, I get something like this:

<pre>
Connecting to listener...
</pre>
<pre>
Inet socket: 127.0.0.1:9000
</pre>
<pre>
Setting Error
</pre>
<pre>
Couldn't connect to the listener.
</pre>
version: '(null)'

But when I comment out the setConnectTimeout() call, it works just fine:

<pre>
Connecting to listener...
</pre>
<pre>
Inet socket: 127.0.0.1:9000
</pre>
<pre>
Authenticating :  ...
</pre>
<pre>
Server Version...
</pre>
<pre>
Checking for error
</pre>
<pre>
No error occurred
</pre>
<pre>
0.53.1
</pre>
version: '0.53.1'

I've played around with different values for seconds and microseconds.  (I
want a timeout of 5 seconds, however that can be accomplished)

Thanks for any help!

--Cal

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

[David M. <dav...@fi...>]

Hi Cal,

Interesting...  I'll do some tests here, figure out what's happening and 
let you know what I find.

Dave

On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
> Hi David,
>
> I'm attempting to write a weighted round-robin connection method for an
> easy failover mechanism on multiple SQL Relay servers.  It appears that
> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
> I'd expect.  It seems that no matter what values I pass to it, the
> connection *always* fails.
>
> Here's the general idea I'm doing:
>
> bool success = false;
> do
> {
>       /*
>         select random sql relay server
>        */
>
>        tmpconn = new sqlrconnection(hostname, port, NULL,
>              user, pass, 0, 1);
>        tmpconn->debugOn();
>        tmpconn->setConnectTimeout(10, 5000000);
>
>        const char *version = tmpconn->serverVersion();
>        printf("version: '%s'\n", version);
>        if ( version )
>           success = true;
>
>        /* Breaking out after a few tries */
> }
> while ( success == false );
>
> Running that, I get something like this:
>
> <pre>
> Connecting to listener...
> </pre>
> <pre>
> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> </pre>
> <pre>
> Setting Error
> </pre>
> <pre>
> Couldn't connect to the listener.
> </pre>
> version: '(null)'
>
> But when I comment out the setConnectTimeout() call, it works just fine:
>
> <pre>
> Connecting to listener...
> </pre>
> <pre>
> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> </pre>
> <pre>
> Authenticating :  ...
> </pre>
> <pre>
> Server Version...
> </pre>
> <pre>
> Checking for error
> </pre>
> <pre>
> No error occurred
> </pre>
> <pre>
> 0.53.1
> </pre>
> version: '0.53.1'
>
> I've played around with different values for seconds and microseconds.
> (I want a timeout of 5 seconds, however that can be accomplished)
>
> Thanks for any help!
>
> --Cal
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

[Cal H. <ca...@fb...>]

Hi David,

Yes, that appears to work as expected.  Thanks for the quick fix!

--Cal


On Wed, Jan 1, 2014 at 5:41 PM, David Muse <dav...@fi...>wrote:

> Hi Cal,
>
> It looks like I forgot to flip the sense of an if when I un-nested its
> contents.
>
> It'll be fixed in the next release of sqlrelay/rudiments, but for a
> quick fix...
>
> In the rudiments library, edit src/socketclient.cpp (or if you're using
> an older version, src/clientsocket.cpp) and look for an if statement
> like this, near line 235:
>
>         if (error::getErrorNumber()==EINPROGRESS ||
>                 error::getErrorNumber()==EWOULDBLOCK) {
>                 retval=RESULT_ERROR;
>                 goto cleanup;
>         }
>
> Change it to:
>
>         if (error::getErrorNumber()!=EINPROGRESS &&
>                 error::getErrorNumber()!=EWOULDBLOCK) {
>                 retval=RESULT_ERROR;
>                 goto cleanup;
>         }
>
> Note the !='s rather than =='s and && rather than ||.
>
> Recompile and reinstall rudiments:
>
>         make
>         sudo make install
>
> And it should work.
>
> Let me know if you run into any more problems.
>
> And thanks for finding that bug!
>
> Dave
> dav...@fi...
>
> On 1/1/2014 6:23 PM, David Muse wrote:
> > Hi Cal,
> >
> > Interesting...  I'll do some tests here, figure out what's happening and
> > let you know what I find.
> >
> > Dave
> >
> > On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
> >> Hi David,
> >>
> >> I'm attempting to write a weighted round-robin connection method for an
> >> easy failover mechanism on multiple SQL Relay servers.  It appears that
> >> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
> >> I'd expect.  It seems that no matter what values I pass to it, the
> >> connection *always* fails.
> >>
> >> Here's the general idea I'm doing:
> >>
> >> bool success = false;
> >> do
> >> {
> >>       /*
> >>         select random sql relay server
> >>        */
> >>
> >>        tmpconn = new sqlrconnection(hostname, port, NULL,
> >>              user, pass, 0, 1);
> >>        tmpconn->debugOn();
> >>        tmpconn->setConnectTimeout(10, 5000000);
> >>
> >>        const char *version = tmpconn->serverVersion();
> >>        printf("version: '%s'\n", version);
> >>        if ( version )
> >>           success = true;
> >>
> >>        /* Breaking out after a few tries */
> >> }
> >> while ( success == false );
> >>
> >> Running that, I get something like this:
> >>
> >> <pre>
> >> Connecting to listener...
> >> </pre>
> >> <pre>
> >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> >> </pre>
> >> <pre>
> >> Setting Error
> >> </pre>
> >> <pre>
> >> Couldn't connect to the listener.
> >> </pre>
> >> version: '(null)'
> >>
> >> But when I comment out the setConnectTimeout() call, it works just fine:
> >>
> >> <pre>
> >> Connecting to listener...
> >> </pre>
> >> <pre>
> >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
> >> </pre>
> >> <pre>
> >> Authenticating :  ...
> >> </pre>
> >> <pre>
> >> Server Version...
> >> </pre>
> >> <pre>
> >> Checking for error
> >> </pre>
> >> <pre>
> >> No error occurred
> >> </pre>
> >> <pre>
> >> 0.53.1
> >> </pre>
> >> version: '0.53.1'
> >>
> >> I've played around with different values for seconds and microseconds.
> >> (I want a timeout of 5 seconds, however that can be accomplished)
> >>
> >> Thanks for any help!
> >>
> >> --Cal
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >>
> >> Rapidly troubleshoot problems before they affect your business. Most IT
> >> organizations don't have a clear picture of how application performance
> >> affects their revenue. With AppDynamics, you get 100% visibility into
> >> your
> >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> >> AppDynamics Pro!
> >>
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> >>
> >>
> >> _______________________________________________________
> >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> >>                http://www.doteasy.com
> >>
> >>
> >>
> >> _______________________________________________
> >> Sqlrelay-discussion mailing list
> >> Sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >>
> >>
> >> _______________________________________________________
> >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> >>                http://www.doteasy.com
> >>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

[David M. <dav...@fi...>]

Woohoo!  No problem.

On 1/6/2014 4:08 PM, Cal Heldenbrand wrote:
> Hi David,
>
> Yes, that appears to work as expected.  Thanks for the quick fix!
>
> --Cal
>
>
> On Wed, Jan 1, 2014 at 5:41 PM, David Muse <dav...@fi...
> <mailto:dav...@fi...>> wrote:
>
>     Hi Cal,
>
>     It looks like I forgot to flip the sense of an if when I un-nested its
>     contents.
>
>     It'll be fixed in the next release of sqlrelay/rudiments, but for a
>     quick fix...
>
>     In the rudiments library, edit src/socketclient.cpp (or if you're using
>     an older version, src/clientsocket.cpp) and look for an if statement
>     like this, near line 235:
>
>              if (error::getErrorNumber()==EINPROGRESS ||
>                      error::getErrorNumber()==EWOULDBLOCK) {
>                      retval=RESULT_ERROR;
>                      goto cleanup;
>              }
>
>     Change it to:
>
>              if (error::getErrorNumber()!=EINPROGRESS &&
>                      error::getErrorNumber()!=EWOULDBLOCK) {
>                      retval=RESULT_ERROR;
>                      goto cleanup;
>              }
>
>     Note the !='s rather than =='s and && rather than ||.
>
>     Recompile and reinstall rudiments:
>
>              make
>              sudo make install
>
>     And it should work.
>
>     Let me know if you run into any more problems.
>
>     And thanks for finding that bug!
>
>     Dave
>     dav...@fi... <mailto:dav...@fi...>
>
>     On 1/1/2014 6:23 PM, David Muse wrote:
>      > Hi Cal,
>      >
>      > Interesting...  I'll do some tests here, figure out what's
>     happening and
>      > let you know what I find.
>      >
>      > Dave
>      >
>      > On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
>      >> Hi David,
>      >>
>      >> I'm attempting to write a weighted round-robin connection method
>     for an
>      >> easy failover mechanism on multiple SQL Relay servers.  It
>     appears that
>      >> the C++ sqlrconnection::setConnectTimeout() function isn't
>     behaving like
>      >> I'd expect.  It seems that no matter what values I pass to it, the
>      >> connection *always* fails.
>      >>
>      >> Here's the general idea I'm doing:
>      >>
>      >> bool success = false;
>      >> do
>      >> {
>      >>       /*
>      >>         select random sql relay server
>      >>        */
>      >>
>      >>        tmpconn = new sqlrconnection(hostname, port, NULL,
>      >>              user, pass, 0, 1);
>      >>        tmpconn->debugOn();
>      >>        tmpconn->setConnectTimeout(10, 5000000);
>      >>
>      >>        const char *version = tmpconn->serverVersion();
>      >>        printf("version: '%s'\n", version);
>      >>        if ( version )
>      >>           success = true;
>      >>
>      >>        /* Breaking out after a few tries */
>      >> }
>      >> while ( success == false );
>      >>
>      >> Running that, I get something like this:
>      >>
>      >> <pre>
>      >> Connecting to listener...
>      >> </pre>
>      >> <pre>
>      >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>     <http://127.0.0.1:9000>
>      >> </pre>
>      >> <pre>
>      >> Setting Error
>      >> </pre>
>      >> <pre>
>      >> Couldn't connect to the listener.
>      >> </pre>
>      >> version: '(null)'
>      >>
>      >> But when I comment out the setConnectTimeout() call, it works
>     just fine:
>      >>
>      >> <pre>
>      >> Connecting to listener...
>      >> </pre>
>      >> <pre>
>      >> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>     <http://127.0.0.1:9000>
>      >> </pre>
>      >> <pre>
>      >> Authenticating :  ...
>      >> </pre>
>      >> <pre>
>      >> Server Version...
>      >> </pre>
>      >> <pre>
>      >> Checking for error
>      >> </pre>
>      >> <pre>
>      >> No error occurred
>      >> </pre>
>      >> <pre>
>      >> 0.53.1
>      >> </pre>
>      >> version: '0.53.1'
>      >>
>      >> I've played around with different values for seconds and
>     microseconds.
>      >> (I want a timeout of 5 seconds, however that can be accomplished)
>      >>
>      >> Thanks for any help!
>      >>
>      >> --Cal
>      >>
>      >>
>      >>
>     ------------------------------------------------------------------------------
>      >>
>      >> Rapidly troubleshoot problems before they affect your business.
>     Most IT
>      >> organizations don't have a clear picture of how application
>     performance
>      >> affects their revenue. With AppDynamics, you get 100% visibility
>     into
>      >> your
>      >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>      >> AppDynamics Pro!
>      >>
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>      >>
>      >>
>      >> _______________________________________________________
>      >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>      >> http://www.doteasy.com
>      >>
>      >>
>      >>
>      >> _______________________________________________
>      >> Sqlrelay-discussion mailing list
>      >> Sql...@li...
>     <mailto:Sql...@li...>
>      >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>      >>
>      >>
>      >> _______________________________________________________
>      >> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>      >> http://www.doteasy.com
>      >>
>
>     ------------------------------------------------------------------------------
>     Rapidly troubleshoot problems before they affect your business. Most IT
>     organizations don't have a clear picture of how application performance
>     affects their revenue. With AppDynamics, you get 100% visibility
>     into your
>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>     AppDynamics Pro!
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>     _______________________________________________
>     Sqlrelay-discussion mailing list
>     Sql...@li...
>     <mailto:Sql...@li...>
>     https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>

Re: [Sqlrelay-discussion] setConnectTimeout() not working correctly?

[David M. <dav...@fi...>]

Hi Cal,

It looks like I forgot to flip the sense of an if when I un-nested its 
contents.

It'll be fixed in the next release of sqlrelay/rudiments, but for a 
quick fix...

In the rudiments library, edit src/socketclient.cpp (or if you're using 
an older version, src/clientsocket.cpp) and look for an if statement 
like this, near line 235:

	if (error::getErrorNumber()==EINPROGRESS ||
		error::getErrorNumber()==EWOULDBLOCK) {
		retval=RESULT_ERROR;
		goto cleanup;
	}

Change it to:

	if (error::getErrorNumber()!=EINPROGRESS &&
		error::getErrorNumber()!=EWOULDBLOCK) {
		retval=RESULT_ERROR;
		goto cleanup;
	}

Note the !='s rather than =='s and && rather than ||.

Recompile and reinstall rudiments:

	make
	sudo make install

And it should work.

Let me know if you run into any more problems.

And thanks for finding that bug!

Dave
dav...@fi...

On 1/1/2014 6:23 PM, David Muse wrote:
> Hi Cal,
>
> Interesting...  I'll do some tests here, figure out what's happening and
> let you know what I find.
>
> Dave
>
> On 12/31/2013 3:08 PM, Cal Heldenbrand wrote:
>> Hi David,
>>
>> I'm attempting to write a weighted round-robin connection method for an
>> easy failover mechanism on multiple SQL Relay servers.  It appears that
>> the C++ sqlrconnection::setConnectTimeout() function isn't behaving like
>> I'd expect.  It seems that no matter what values I pass to it, the
>> connection *always* fails.
>>
>> Here's the general idea I'm doing:
>>
>> bool success = false;
>> do
>> {
>>       /*
>>         select random sql relay server
>>        */
>>
>>        tmpconn = new sqlrconnection(hostname, port, NULL,
>>              user, pass, 0, 1);
>>        tmpconn->debugOn();
>>        tmpconn->setConnectTimeout(10, 5000000);
>>
>>        const char *version = tmpconn->serverVersion();
>>        printf("version: '%s'\n", version);
>>        if ( version )
>>           success = true;
>>
>>        /* Breaking out after a few tries */
>> }
>> while ( success == false );
>>
>> Running that, I get something like this:
>>
>> <pre>
>> Connecting to listener...
>> </pre>
>> <pre>
>> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>> </pre>
>> <pre>
>> Setting Error
>> </pre>
>> <pre>
>> Couldn't connect to the listener.
>> </pre>
>> version: '(null)'
>>
>> But when I comment out the setConnectTimeout() call, it works just fine:
>>
>> <pre>
>> Connecting to listener...
>> </pre>
>> <pre>
>> Inet socket: 127.0.0.1:9000 <http://127.0.0.1:9000>
>> </pre>
>> <pre>
>> Authenticating :  ...
>> </pre>
>> <pre>
>> Server Version...
>> </pre>
>> <pre>
>> Checking for error
>> </pre>
>> <pre>
>> No error occurred
>> </pre>
>> <pre>
>> 0.53.1
>> </pre>
>> version: '0.53.1'
>>
>> I've played around with different values for seconds and microseconds.
>> (I want a timeout of 5 seconds, however that can be accomplished)
>>
>> Thanks for any help!
>>
>> --Cal
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into
>> your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>> AppDynamics Pro!
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________________
>> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>>                http://www.doteasy.com
>>
>>
>>
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>>
>> _______________________________________________________
>> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>>                http://www.doteasy.com
>>