sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] Support planned for MySQL 5.1?

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

Yes, there are plans for supporting 5.1, 6.0 and future versions.  The
next major release should support 5.1

Dave Muse
dav...@fi...

On Tue, 2007-09-18 at 23:39 -0600, Matthew J Kettlewell wrote:
> Hello,
> 
> I just came across sqlrelay, and like the idea of a drop-in MySQL
> replacement for C++.  
> 
> I will test it out on my 5.0.27 build, but was wondering if there were
> plans to make it usable with 5.1 (and beyond) ?
> 
> Thanks
> 
> Matt
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> _________________________________________________________________
> Need personalized email and website? Look no further. It's easy
> with Doteasy $0 Web Hosting! Learn more at www.doteasy.com

[Sqlrelay-discussion] Support planned for MySQL 5.1?

[Matthew J K. <ma...@ta...>]

Hello,

I just came across sqlrelay, and like the idea of a drop-in MySQL
replacement for C++.  

I will test it out on my 5.0.27 build, but was wondering if there were
plans to make it usable with 5.1 (and beyond) ?

Thanks

Matt

[Sqlrelay-discussion] bad pl/sql kill sqlrelay connexion

[Huve L. <l....@fo...>]

Hello,

We have a strange problem since we use oracle pl/sql and sqlrelay. 
That arrived when we debug proc or test new proc, sqlrelay connexions
are kill and disappear so we must restart it.

Do you think there is something to do to avoid this problem

I give you the connexion log and the error I find.

Thank's a lot
Loic



error : 
- getting command failed: client sent bad command or timed out

connexion log :

begin
PCK_LEAD_INFO.P_GET_PRICE_ONLINE(  :FUPID , :SITE_ID , :COUNTRY_CODE , :CURSEUR , :ERROR  ); end;
getting query succeeded
getting input binds...
:FUPID
STRING
00020905
:SITE_ID
INTEGER
1
:COUNTRY_CODE
STRING
fr
done getting input binds
getting output binds...
:CURSEUR
CURSOR
found a free cursor:
1
:ERROR
INTEGER
done getting output binds
getting send column info...
don't send column info
done getting send column info...
processing query...
preparing/executing...
commit or rollback check...
commit or rollback needed
done with commit or rollback check
processing query failed
done processing query
handling error...
returning error...
failed to handle query: error
done returning error
done handling error...
getting command...
done getting command
getting a cursor...
done getting a cursor
fetch from bind cursor
handling query...
getting send column info...
send column info
done getting send column info...
processing query...
bind cursor...
commit or rollback check...
commit or rollback needed
done with commit or rollback check
processing query succeeded
done processing query
returning result set header...
returning row counts...
sending row counts...
actual rows unknown
affected rows: 0
done sending row counts
done returning row counts
column info will be sent
returning column counts...
done returning column counts
sending column type format...
id's
done sending column type format
returning column info...
done returning column info
returning output bind values
2
2
0:CURSOR:
1
1:INTEGER:
0
done returning output bind values
done returning result set header
handle query succeeded
returning result set data...
done returning result set data
getting command...
done getting command
getting a cursor...
done getting a cursor
abort result set
getting command...
getting command failed: client sent bad command or timed out <==========
and my connexion is kill.
end session
ending session...
aborting all busy cursors...
1

Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

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

Aaah, somehow I managed to reply to myself a while back.  I just updated
the code.  If you grab sqlrelay from CVS, it should have all of this
taken care of.

Below is the original message that I intended to send to you:

Dave
dav...@fi...



Ok, here's how it works:

postgresql types are just numbers called oid's.  They correspond to
entries in a table called pg_type.

In the sqlrelay.conf file's postgresql connect string, you can set the
typemangling parameter to "no", "yes" or "lookup".  Setting it to "no"
will return the oid, "yes" will do a static translation and "lookup"
will cause sqlrelay to "select oid,typname from pg_type" at startup,
cache the result and do a translation based on that.

There is actually a bug though.  Setting typemangling="no" currently has
the same effect as "lookup".  You have to remove the typemangling
parameter altogether to get the "no" behavior.  This will be fixed in
the next major release.

At any rate.  If I set typemangling="lookup" then I get "_text" for the
column type.  Removing the typemangling parameter gave me 1009 for the
column type.  Similar tests with other array types returned "_int8",
"_int2", etc.  It appears that if there's an underscore in the column
type, then it's an array type.

So, the real issue is that when typemangling="yes", it doesn't correctly
translate the type.  This can be fixed by editing
src/connections/postgresql/postgresqlconnection.C, around line 556 or
so.  There's a big if block (which really could be a switch block) which
tests pgfieldtype (the result of PQftype) against a set of common
datatypes.  But it's an incomplete list.  It doesn't even handle all of
the different types defined in common/datatypes.h for postgresql.  You
could add support for array types (and the other missing types) by
extending that if block.  You can get the oid and type names for
"built-in" data types by running a "select oid,typname from pg_type
where oid < 10000" query.  You might also want to update
common/datatypes.h and change the type names from names like
"_TEXT_DATATYPE" to names like "TEXT_ARRAY_DATATYPE" or similar.

Give it a try, I'd be glad to accept a patch like this.

Dave
dav...@fi...


On Fri, 2007-09-14 at 17:40 -0400, Alfred J Fazio wrote:
> Should I assume that this is not possible?  Thank you for your time.
> 
> On 9/7/07, Alfred J Fazio <alf...@gm...> wrote:
>         Many thanks, David.  If you find that you do not have the time
>         to implement this, feel free to point me in the right
>         direction and I'll pick up from there.  I wouldn't mind adding
>         clauses for additional column types such as bit strings, etc.
>         Again, thank you so much! 
>         
>         -- 
>         Alfred J Fazio,
>         alf...@gm... 
>         
>         On 9/7/07, David Muse <dav...@fi...> wrote:
>                 This should be simple to fix.  I'm looking into it now
>                 and I'll let you
>                 know what I find shortly.
>                 
>                 Dave
>                 dav...@fi...
>                 
>                 On Wed, 2007-09-05 at 16:29 -0400, Alfred J Fazio
>                 wrote: 
>                 > Hi everyone,
>                 >
>                 >     I am using SQLRelay 0.38 via Python (2.4.4) to
>                 connect to a
>                 > PostgreSQL (8.1.9) database.  I have noticed that if
>                 I create a table
>                 > with an ARRAY column, that Sqlrelay returns the
>                 column type as 
>                 > UNKNOWN.  E.g., if I issue the following SQL:
>                 >
>                 > CREATE TABLE test (arr TEXT[][]);
>                 >
>                 > And fill it will some test data:
>                 >
>                 > INSERT INTO test (arr) VALUES (ARRAY[['fname',
>                 'alfred'], ['lname', 
>                 > 'fazio'], ['age', '24'], ['employer',
>                 'smoothstone']]);
>                 >
>                 > I will get an UNKNOWN value when calling
>                 getColumnType on the arr
>                 > column above:
>                 >
>                 > >>> c.sendQuery("SELECT arr FROM test")
>                 > >>> c.getField(0, 0)
>                 >
>                 '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}'
>                 > >>> c.getColumnType(0)
>                 > 'UNKNOWN' 
>                 >
>                 > It would be very convenient if I could test whether
>                 the column I am
>                 > fetching is an ARRAY.  If so, I can automatically
>                 parse the result of
>                 > the query into a native Python list.  I briefly
>                 peeked in the source 
>                 > code and saw that there has been a datatype declared
>                 for arrays for
>                 > PostgreSQL in the src/common/datatypes.h file
>                 (called 'ANYARRAY').
>                 > However, I didn't look around for long to see where
>                 I might implement 
>                 > the code needed to detect the column type.  Could
>                 somebody please
>                 > point me to the right direction within the source
>                 code where I can
>                 > perhaps add a clause for this situation?  I will
>                 then be happy to 
>                 > submit a patch to the list.
>                 >
>                 > Thanks for your time!
>                 >
>                 > --
>                 > Alfred J Fazio,
>                 > alf...@gm...
>                 >
>                 ------------------------------------------------------------------------- 
>                 > This SF.net email is sponsored by: Splunk Inc.
>                 > Still grepping through log files to find
>                 problems?  Stop.
>                 > Now Search log events and configuration files using
>                 AJAX and a browser.
>                 > Download your FREE copy of Splunk now >>
>                 http://get.splunk.com/
>                 > _______________________________________________
>                 Sqlrelay-discussion mailing list
>                 Sql...@li...
>                 https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>                 
>                 
>                 ------------------------------------------------------------------------- 
>                 This SF.net email is sponsored by: Splunk Inc.
>                 Still grepping through log files to find
>                 problems?  Stop.
>                 Now Search log events and configuration files using
>                 AJAX and a browser.
>                 Download your FREE copy of Splunk now >>
>                 http://get.splunk.com/
>                 _______________________________________________
>                 Sqlrelay-discussion mailing list
>                 Sql...@li...
>                 https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion 
>         
> 
> 
> 
> -- 
> Alfred J Fazio,
> alf...@gm... 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

[Alfred J F. <alf...@gm...>]

Should I assume that this is not possible?  Thank you for your time.

On 9/7/07, Alfred J Fazio <alf...@gm...> wrote:
>
> Many thanks, David.  If you find that you do not have the time to
> implement this, feel free to point me in the right direction and I'll pick
> up from there.  I wouldn't mind adding clauses for additional column types
> such as bit strings, etc.  Again, thank you so much!
>
> --
> Alfred J Fazio,
> alf...@gm...
>
> On 9/7/07, David Muse <dav...@fi...> wrote:
> >
> > This should be simple to fix.  I'm looking into it now and I'll let you
> > know what I find shortly.
> >
> > Dave
> > dav...@fi...
> >
> > On Wed, 2007-09-05 at 16:29 -0400, Alfred J Fazio wrote:
> > > Hi everyone,
> > >
> > >     I am using SQLRelay 0.38 via Python (2.4.4) to connect to a
> > > PostgreSQL (8.1.9) database.  I have noticed that if I create a table
> > > with an ARRAY column, that Sqlrelay returns the column type as
> > > UNKNOWN.  E.g., if I issue the following SQL:
> > >
> > > CREATE TABLE test (arr TEXT[][]);
> > >
> > > And fill it will some test data:
> > >
> > > INSERT INTO test (arr) VALUES (ARRAY[['fname', 'alfred'], ['lname',
> > > 'fazio'], ['age', '24'], ['employer', 'smoothstone']]);
> > >
> > > I will get an UNKNOWN value when calling getColumnType on the arr
> > > column above:
> > >
> > > >>> c.sendQuery("SELECT arr FROM test")
> > > >>> c.getField(0, 0)
> > > '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}'
> > > >>> c.getColumnType(0)
> > > 'UNKNOWN'
> > >
> > > It would be very convenient if I could test whether the column I am
> > > fetching is an ARRAY.  If so, I can automatically parse the result of
> > > the query into a native Python list.  I briefly peeked in the source
> > > code and saw that there has been a datatype declared for arrays for
> > > PostgreSQL in the src/common/datatypes.h file (called 'ANYARRAY').
> > > However, I didn't look around for long to see where I might implement
> > > the code needed to detect the column type.  Could somebody please
> > > point me to the right direction within the source code where I can
> > > perhaps add a clause for this situation?  I will then be happy to
> > > submit a patch to the list.
> > >
> > > Thanks for your time!
> > >
> > > --
> > > Alfred J Fazio,
> > > alf...@gm...
> > >
> > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc.
> > > Still grepping through log files to find problems?  Stop.
> > > Now Search log events and configuration files using AJAX and a
> > browser.
> > > Download your FREE copy of Splunk now >>   http://get.splunk.com/
> > > _______________________________________________ Sqlrelay-discussion
> > mailing list Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
> >
> > -------------------------------------------------------------------------
> >
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>   http://get.splunk.com/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
>
>


-- 
Alfred J Fazio,
alf...@gm...

Re: [Sqlrelay-discussion] sqlrelay-0.39.4

[Ingmar B. <sw...@gm...>]

Hi David,

This is great :-) The problems I've described have been solved. Connections
are no longer kept by clients, and cursors and blobs are read out correctlty
in situations that were  previously erroneous. You've made my day :-)

Friendly greetings

Ingmar

Re: [Sqlrelay-discussion] Bug report, empty cursor/blob, with code to reproduce problem

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

Ok, I think I took care of it.

It looks like it had to do with not re-initializing the null indicator,
which oracle doesn't re-initialize for cursor binds.  So, since the
first bind variable came back as NULL in the first query and the null
indicator for the first bind variable wasn't reset, even though a valid
cursor came back in the second query, the null indicator was still set
to true and that overrode the cursor and just sent a NULL back for the
cursor.

It should be fixed in 0.39.4 which was just released.

Give it a try, let me know what you find.

Dave
dav...@fi...

On Wed, 2007-09-12 at 12:47 +0200, Ingmar Brouns wrote:
> Hi David,
> 
> Thanks for your reply.
> 
> I was curious whether there has already been made some progress in
> tracing
> the cause of this bug. 
> The strange thing about  this bug is that seems to be related with the
> freeing of 
> resources. When you comment out the first query after you excecuted
> the first 
> query once in the bug situation,  then the second query will
> repeatedly give 
> faulty results, even with the first query commented out. In more
> complex situations 
> I have seen that sometimes the client connections are kept while they
> should 
> have been freed at the end of a php script. That behavior always
> occured 
> together with an instance of this bug.   
> If can provide you with more  information, please let me know.
> 
> Friendly greetings, 
> 
> Ingmar 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] sqlrelay-0.39.4

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

Well, 2 releases in 2 days.  I think that's a new record :)

This release fixes an important bug with output bind cursors where the
cursor returned would be NULL if the bind variable in the same position
from a previous query was NULL, even if a cursor should really have been
returned.

sqlrelay-0.39.4 is out on sqlrelay.sourceforge.net

Give it a try, report any bugs.

David Muse
dav...@fi...

Re: [Sqlrelay-discussion] dynamically adding connections

[Duncan M. <dwm...@gm...>]

David,

So (at least in theory) I could have spare machines that upon boot
(after running a simple process to make sure their data is up-to-date)
they could register themselves with the sql-relay central process and
be ready to accept queries?

Thanks,

Duncan

On 8/30/07, David Muse <dav...@fi...> wrote:
> There is a dynamic scaling option.  In the sqlrelay.conf file, the
> "connections" parameter defines the number of db connections that start
> up when sqlrelay starts.  There's another parameter called
> "maxconnections".  If it's greater than "connections", then new
> connections will start up as-needed.  The "ttl" parameter determines how
> long they will hang around if they go unused.  The "maxqueuelength"
> parameter determines how many waiting clients must be queued up before
> new connections will be started.  The "growby" parameter determines how
> many new connections will be started when the maxqueuelength is
> exceeded.
>
> I believe that you can even set connections="0" and no connections will
> be started when sqlrelay is started up.  In effect, it will be entirely
> dynamic.
>
> You should also be able to manually start sqlr-connection deamons if you
> like, just by running them from the command line.  They will register
> themselves with the sqlr-listener process and service requests just as
> if they had been started by sqlr-start.
>
> Hope this helps.
>
> David Muse
> dav...@fi...
>
> On Mon, 2007-08-27 at 22:55 -0500, Duncan McQueen wrote:
> > I looked thru the documentation and it appears that you define all the
> > database connections at startup.  Is there a way to dynamically add
> > new connections after sqlrelay has started?
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
> >
> > _________________________________________________________________
> > Need personalized email and website? Look no further. It's easy
> > with Doteasy $0 Web Hosting! Learn more at www.doteasy.com
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Bug report, empty cursor/blob, with code to reproduce problem

[Ingmar B. <sw...@gm...>]

Hi David,

Thanks for your reply.

I was curious whether there has already been made some progress in tracing
the cause of this bug.
The strange thing about  this bug is that seems to be related with the
freeing of
resources. When you comment out the first query after you excecuted the
first
query once in the bug situation,  then the second query will repeatedly give

faulty results, even with the first query commented out. In more complex
situations
I have seen that sometimes the client connections are kept while they should

have been freed at the end of a php script. That behavior always occured
together with an instance of this bug.
If can provide you with more  information, please let me know.

Friendly greetings,

Ingmar

Re: [Sqlrelay-discussion] I need help -- Sometimes I got this : nativecode=Couldn't connect to the listener

[Dante M. <ma...@si...>]

Hey!
It seems like I found a way to prevent this error by adding a stupid loop after "DB:isError".
something like:

********* getting connection *********************
$connected = 0;
if ( DB::isError($dbh) ){
	for( $i=0; $i<10; $i++ ){
		/* try 10 times */
		$dbh = DB::connect("$type://$user:$pass@$host:$poolport/$dbname");
		if ( !DB::isError( $dbh) ) {
			$connected = 1;
			break;
		} else {
			sleep(1);
		}
	}
}
if($connected!=1) die("connect error:".$this->dbh->getDebugInfo()."\n");

********* doing query *********************
if (DB::isError($result)){
	$got_res=0;
	if(strpos($result->getDebugInfo(),"Couldn't connect to the listener") ){
		/* try to do the query 5 times */
		for($i=0;$i<5;$i++){
			$result = $this->dbh->getAll($sql, DB_FETCHMODE_ASSOC) ;
			if(DB::isError($result)){
				sleep(1);
			} else {
				$got_res=1;
				break;
			}
		}
	}
	if($got_res!=1) die("query error:".$result->getDebugInfo()."\n") ;
}


I don't know if this is a good way to prevent that error, but it works.

Regards,

Dante Mason

[Sqlrelay-discussion] sqlrelay-0.39.3

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

Hello List,

I just uploaded sqlrelay-0.39.3 to sourceforge.  This minor release
fixes the issue where freetds connections had trouble connecting to
servers which were missing the sp_version stored procedure.

Give it a try, report any bugs.

David Muse
dav...@fi...

Re: [Sqlrelay-discussion] Why the Opened Server Connections keep increasing?

[Zhuguo S. <blu...@gm...>]

I am using MySQL. And recently we found out it might because we didn't free
the variables. We use stored procedure in our project, and at first we did
not use 'sqlrcur_free' or 'sqlrcon_endSession' to release the resources.
When we added them to our code, it is much better. Could you please give me
some more details on 'sqlrcur_free' and 'sqlrcon_endSession' or any related
functions?

On 9/8/07, David Muse <dav...@fi...> wrote:
>
> That's very strange.  The opened server connections should only increase
> if sqlrelay has decided that it needs to open new connections to handle
> a flood of incoming client requests.  Sounds like a bug.
>
> What db are you using?  I'll see if I can figure out what's going on.
>
> Actually, are you using MS SQL Server?  If so, you may find that the
> issue is really a missing stored procedure sp_version.  In the newest
> version of SQL relay, it tries to run that procedure to get the version
> of the database at startup.  Sybase has that procedure, but MS SQL
> Server doesn't and it causes problems.  There are 2 workarounds:
>
>
> * add a sp_version stored procedure to the db which returns some bogus
> string of data.
> * comment out lines 409-424 in src/connections/freetds/freetds.C and
> replace them with:
>         freetdsconn->dbversion=charstring::duplicate("unknown");
>
> I'm going to fix that problem and get an update out soon.
>
> Let me know if that turns out to be the issue or not.
>
> David Muse
> dav...@fi...
>
> On Fri, 2007-08-31 at 21:42 +0800, Zhuguo Shi wrote:
> > When I use the SQL 'set names utf8' through sqlrealy, sometimes
> > sqlrelay doesn't response. I use 'sqlr-status' command to check what's
> > going on, the Opened Server Connections are keeping incrsasing. Some
> > one can help me?
> >
> > and I use 'sqlrcon_ping' to test if the connection is established, is
> > that right?
> >
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________ Sqlrelay-discussion
> mailing list Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] I need help -- Sometimes I got this : nativecode=Couldn't connect to the listener

[<ma...@si...>]

Thanks for your response.

I log the host,port number, user/password when that error occurs,
there's nothing different between sqlrelay.conf and settings in php scripts.

I wonder if it's caused by TIME_WAIT ?
So I do the following things that documented:
echo 30 > /proc/sys/net/ipv4/tcp_fin_timeout
echo 1 > /proc/sys/net/ipv4/tcp_tw_reuse
echo 1 > /proc/sys/net/ipv4/tcp_tw_recycle

but it still happens.

Here is how I make that error message comes up
(I wrote a simple bash script):
#!/bin/bash
for i in `seq 1 200`
do
   /usr/bin/php -f ./sr.php &
done

After I executed that bash script,=20
the frequency of "Couldn't connect to the listener" comes up
is about 1~2 times in 200 php executing.


On Fri, Sep 07, 2007 at 11:15:08AM -0400, David Muse wrote:
> That message means that the client software (the PHP script) couldn't
> connect to the sqlrelay server.
>=20
> What parameters are you using in your PHP code to connect to the server?
>=20
> A common mistake is to aim your PHP script at the oracle db rather than
> at SQL Relay.  Make sure that in the parameters, the host is set to
> whatever machine SQL Relay is running on, the port is set to 9000 and
> the user/password are set to whatever user/password you set up in the
> <users> section of your config file.
>=20
> David Muse
> dav...@fi...
>=20
> On Fri, 2007-09-07 at 17:12 +0800, Dante Mason wrote:
> > Hello,
> >=20
> > This is the 4th mail I sent this afternoon,=20
> > the content of previous 3 mails are the same as this one.
> > But some how gmail sent them in MIME. That was a mass.
> > I am really sorry sent suplicate content,
> > but I really need a direction to solve my problem.
> >=20
> > I use sqlrelay-0.39.2, and I did not use previous versions before.
> > I am using it to connect to oracle.
> > Everything goes fine till I got some complains from my users,
> > they claimed that they get the error message from php PEAR's getUserInf=
o,
> > and that message is "[nativecode=3DCouldn't connect to the listener]".
> >=20
> > But I didn't see any strange information from sqlr-connection.<pid>s.
> >=20
> > here is my sqlrelay.conf (only the instance part)=EF=BC=9A
> > <instance id=3D"orcl_dev" port=3D"9000" socket=3D"/tmp/orcl_dev.socket"
> > dbase=3D"oracle8" connections=3D"30" maxconnections=3D"150"
> > maxqueuelength=3D"2" growby=3D"1" ttl=3D"600" endofsession=3D"commit"
> > sessiontimeout=3D"600" runasuser=3D"webuser" runasgroup=3D"webuser"
> > cursors=3D"5" authtier=3D"listener" handoff=3D"pass" deniedips=3D""
> > allowedips=3D"" debug=3D"connection" maxquerysize=3D"65536"
> > maxstringbindvaluelength=3D"4000" maxlobbindvaluelength=3D"71680"
> > idleclienttimeout=3D"-1" maxlisteners=3D"-1" listenertimeout=3D"0"
> > reloginatstart=3D"yes">
> >=20
> > Is there any setting I should try to change in the config file?
> > Or, does this is apparently a network problem ?
> > I really appreciate any help.
> >=20
> > Regards,
> >=20
> > Dante Mason
> >=20
> > -----------------------------------------------------------------------=
--
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> > &#0;&#0;5=E7=9D=A5v7zf=D7=8B'=17"=1Ej=CC=B0C=D7=9A-=16y=D8=A7y=0C=1D=D7=
=9A'(
>=20
>=20
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

[Alfred J F. <alf...@gm...>]

Many thanks, David.  If you find that you do not have the time to implement
this, feel free to point me in the right direction and I'll pick up from
there.  I wouldn't mind adding clauses for additional column types such as
bit strings, etc.  Again, thank you so much!

-- 
Alfred J Fazio,
alf...@gm...

On 9/7/07, David Muse <dav...@fi...> wrote:
>
> This should be simple to fix.  I'm looking into it now and I'll let you
> know what I find shortly.
>
> Dave
> dav...@fi...
>
> On Wed, 2007-09-05 at 16:29 -0400, Alfred J Fazio wrote:
> > Hi everyone,
> >
> >     I am using SQLRelay 0.38 via Python (2.4.4) to connect to a
> > PostgreSQL (8.1.9) database.  I have noticed that if I create a table
> > with an ARRAY column, that Sqlrelay returns the column type as
> > UNKNOWN.  E.g., if I issue the following SQL:
> >
> > CREATE TABLE test (arr TEXT[][]);
> >
> > And fill it will some test data:
> >
> > INSERT INTO test (arr) VALUES (ARRAY[['fname', 'alfred'], ['lname',
> > 'fazio'], ['age', '24'], ['employer', 'smoothstone']]);
> >
> > I will get an UNKNOWN value when calling getColumnType on the arr
> > column above:
> >
> > >>> c.sendQuery("SELECT arr FROM test")
> > >>> c.getField(0, 0)
> > '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}'
> > >>> c.getColumnType(0)
> > 'UNKNOWN'
> >
> > It would be very convenient if I could test whether the column I am
> > fetching is an ARRAY.  If so, I can automatically parse the result of
> > the query into a native Python list.  I briefly peeked in the source
> > code and saw that there has been a datatype declared for arrays for
> > PostgreSQL in the src/common/datatypes.h file (called 'ANYARRAY').
> > However, I didn't look around for long to see where I might implement
> > the code needed to detect the column type.  Could somebody please
> > point me to the right direction within the source code where I can
> > perhaps add a clause for this situation?  I will then be happy to
> > submit a patch to the list.
> >
> > Thanks for your time!
> >
> > --
> > Alfred J Fazio,
> > alf...@gm...
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________ Sqlrelay-discussion
> mailing list Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] Why the Opened Server Connections keep increasing?

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

That's very strange.  The opened server connections should only increase
if sqlrelay has decided that it needs to open new connections to handle
a flood of incoming client requests.  Sounds like a bug.

What db are you using?  I'll see if I can figure out what's going on.

Actually, are you using MS SQL Server?  If so, you may find that the
issue is really a missing stored procedure sp_version.  In the newest
version of SQL relay, it tries to run that procedure to get the version
of the database at startup.  Sybase has that procedure, but MS SQL
Server doesn't and it causes problems.  There are 2 workarounds:


* add a sp_version stored procedure to the db which returns some bogus
string of data.
* comment out lines 409-424 in src/connections/freetds/freetds.C and
replace them with:
        freetdsconn->dbversion=charstring::duplicate("unknown");

I'm going to fix that problem and get an update out soon.

Let me know if that turns out to be the issue or not.

David Muse
dav...@fi...

On Fri, 2007-08-31 at 21:42 +0800, Zhuguo Shi wrote:
> When I use the SQL 'set names utf8' through sqlrealy, sometimes
> sqlrelay doesn't response. I use 'sqlr-status' command to check what's
> going on, the Opened Server Connections are keeping incrsasing. Some
> one can help me? 
> 
> and I use 'sqlrcon_ping' to test if the connection is established, is
> that right?
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] the efficiency of sqlrelay

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

Hmm,

I suspect that the issue is that the first time the query is parsed,
Oracle has to do work to parse it.  But then afterward, the
already-parsed query is cached (as is the result set, or at least part
of it) and oracle just has to look it up.  I bet that if you restart the
db, and run the query using php-oci first, then using php-sqlrelay,
you'll see that in that case, php-oci is slower than php-sqlrelay.

Dave
dav...@fi...

On Wed, 2007-09-05 at 17:32 +0800, 孙庚 wrote:
> hi,all:
>  
>  
> why sqlrelay query a intricate sql will so slow ?
> the same sql query :
>    php-sqlrelay:0.16688680648804s
>    php-oci func:0.046548843383789s
>  
>  
>  
>  
> my PC:
> intel c4 2.4 with 512ram
> my OS:
> rh linux 9
> oracle 9i
> apache 2
> php4.4
>  
>  
> when i try to user php with sqlrelay link this:
>  
> select i.P_PRODUCTNAME as P_PRODUCTNAME , i.p_companyid , i.p_id as
> p_id , i.p_type , to_char( I.P_CREATETIME, 'yy-mm-dd hh24:mi:ss') as
> createtime , i.p_user as user_name , to_char( I.P_CHECKTIME ,
> 'yy-mm-dd hh24:mi:ss') as checktime , to_char( I.p_lastupdatetime,
> 'yy-mm-dd hh24:mi:ss') as updatetime , i.p_admin , i.P_STATUS as sta ,
> l.g_languagename , l.g_id , i.p_productimage from c_product i ,
> g_language l where l.g_id=i.p_languageid and i.p_languageid=1 and
> I.P_CREATETIME>=to_date('2006-08-13 00:00:00','YYYY-MM-DD HH24:MI:SS')
> and I.P_CREATETIME<=to_date('2007-08-13 23:59:59','YYYY-MM-DD
> HH24:MI:SS') and i.p_productimage>0 order by I.P_CREATETIME desc
>  
> the timer tell me:
> conn time: 0.00015997886657715
> prase time: 0.16688680648804
> disconn time: 0.00068283081054688
> all time: 0.16797995567322
>  
> but,when i try php self oci functions to query the same sql:
> conn time: 0.046813011169434
> prase time: 0.046548843383789
> disconn time: 0.00010800361633301
> all time: 0.093719959259033
>  
> and i try php with sqlrelay agein:
> select a_admin from g_admin
>  
> the timer tell me:
> conn time: 0.00015783309936523
> prase time: 0.014791011810303
> disconn time: 0.00018692016601562
> all time: 0.015383958816528
>  
> and i try php self oci function:
> select a_admin from g_admin
>  
> the timer tell me:
> conn time: 0.048692941665649
> prase time: 0.0018470287322998
> disconn time: 9.1075897216797E-05
> all time: 0.050878047943115
>  
>  
> my sqlrelay.conf:
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> <instances>
>         <instance id="oracletest" port="9000"
> socket="/tmp/oracletest.socket" dbase="oracle8" connections="10"
> maxconnections="100" maxqueuelength="5" growby="2" ttl="60"
> endofsession="commit" sessiontimeout="600" runasuser="nobody"
> runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"
> debug="none">
>                 <users>
>                         <user user="oracletest"
> password="oracletest"/>
>                 </users>
>                 <connections>
>                         <connection connectionid="oracletest"
> string="user=bigfish_test;password=bigfish_test;oracle_sid=bigfish;oracle_home=/opt/oracle/product/9i2" metric="1"/>
>                 </connections>
>         </instance>
> </instances>
> 
>  
>  
>  
>  
>  
> 
> 
> 
> ______________________________________________________________________
> 独有“帐号保险柜”，保护网银网游密码，瑞星2008版免费
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

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

This should be simple to fix.  I'm looking into it now and I'll let you
know what I find shortly.

Dave
dav...@fi...

On Wed, 2007-09-05 at 16:29 -0400, Alfred J Fazio wrote:
> Hi everyone,
> 
>     I am using SQLRelay 0.38 via Python (2.4.4) to connect to a
> PostgreSQL (8.1.9) database.  I have noticed that if I create a table
> with an ARRAY column, that Sqlrelay returns the column type as
> UNKNOWN.  E.g., if I issue the following SQL:
> 
> CREATE TABLE test (arr TEXT[][]);
> 
> And fill it will some test data:
> 
> INSERT INTO test (arr) VALUES (ARRAY[['fname', 'alfred'], ['lname',
> 'fazio'], ['age', '24'], ['employer', 'smoothstone']]); 
> 
> I will get an UNKNOWN value when calling getColumnType on the arr
> column above:
> 
> >>> c.sendQuery("SELECT arr FROM test")
> >>> c.getField(0, 0)
> '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}' 
> >>> c.getColumnType(0)
> 'UNKNOWN'
> 
> It would be very convenient if I could test whether the column I am
> fetching is an ARRAY.  If so, I can automatically parse the result of
> the query into a native Python list.  I briefly peeked in the source
> code and saw that there has been a datatype declared for arrays for
> PostgreSQL in the src/common/datatypes.h file (called 'ANYARRAY').
> However, I didn't look around for long to see where I might implement
> the code needed to detect the column type.  Could somebody please
> point me to the right direction within the source code where I can
> perhaps add a clause for this situation?  I will then be happy to
> submit a patch to the list. 
> 
> Thanks for your time!
> 
> -- 
> Alfred J Fazio,
> alf...@gm... 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] getColumnType returns 'UNKNOWN' for PostgreSQL ARRAY column type.

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

On Wed, 2007-09-05 at 17:07 -0400, Alfred J Fazio wrote:
> I noticed that I was running an old version of SQLRelay.  I have
> installed version 0.39.2 and get the same results.  Just FYI :).
> Since I'm already bugging the list, I must say I'm surprised that
> there is no API call (at least in Python) to find out the current
> version of the SQLRelay client.  I guess nobody has had a need for
> it? 

Yeah, nobody's asked for that yet.  Good idea though I'll put it on the
TODO list for the next major release.

Dave
dav...@fi...

> 
> Cheers
> 
> On 9/5/07, Alfred J Fazio <alf...@gm...> wrote:
>         Hi everyone,
>         
>             I am using SQLRelay 0.38 via Python (2.4.4) to connect to
>         a PostgreSQL (8.1.9) database.  I have noticed that if I
>         create a table with an ARRAY column, that Sqlrelay returns the
>         column type as UNKNOWN.  E.g., if I issue the following SQL:
>         
>         CREATE TABLE test (arr TEXT[][]);
>         
>         And fill it will some test data:
>         
>         INSERT INTO test (arr) VALUES (ARRAY[['fname', 'alfred'],
>         ['lname', 'fazio'], ['age', '24'], ['employer',
>         'smoothstone']]); 
>         
>         I will get an UNKNOWN value when calling getColumnType on the
>         arr column above:
>         
>         >>> c.sendQuery("SELECT arr FROM test")
>         >>> c.getField(0, 0)
>         '{{fname,alfred},{lname,fazio},{age,24},{employer,smoothstone}}' 
>         >>> c.getColumnType(0)
>         'UNKNOWN'
>         
>         It would be very convenient if I could test whether the column
>         I am fetching is an ARRAY.  If so, I can automatically parse
>         the result of the query into a native Python list.  I briefly
>         peeked in the source code and saw that there has been a
>         datatype declared for arrays for PostgreSQL in the
>         src/common/datatypes.h file (called 'ANYARRAY').  However, I
>         didn't look around for long to see where I might implement the
>         code needed to detect the column type.  Could somebody please
>         point me to the right direction within the source code where I
>         can perhaps add a clause for this situation?  I will then be
>         happy to submit a patch to the list. 
>         
>         Thanks for your time!
>         
>         -- 
>         Alfred J Fazio,
>         alf...@gm...
> 
> 
> 
> -- 
> Alfred J Fazio,
> alf...@gm... 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] I need help -- Sometimes I got this : nativecode=Couldn't connect to the listener

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

That message means that the client software (the PHP script) couldn't
connect to the sqlrelay server.

What parameters are you using in your PHP code to connect to the server?

A common mistake is to aim your PHP script at the oracle db rather than
at SQL Relay.  Make sure that in the parameters, the host is set to
whatever machine SQL Relay is running on, the port is set to 9000 and
the user/password are set to whatever user/password you set up in the
<users> section of your config file.

David Muse
dav...@fi...

On Fri, 2007-09-07 at 17:12 +0800, Dante Mason wrote:
> Hello,
> 
> This is the 4th mail I sent this afternoon, 
> the content of previous 3 mails are the same as this one.
> But some how gmail sent them in MIME. That was a mass.
> I am really sorry sent suplicate content,
> but I really need a direction to solve my problem.
> 
> I use sqlrelay-0.39.2, and I did not use previous versions before.
> I am using it to connect to oracle.
> Everything goes fine till I got some complains from my users,
> they claimed that they get the error message from php PEAR's getUserInfo,
> and that message is "[nativecode=Couldn't connect to the listener]".
> 
> But I didn't see any strange information from sqlr-connection.<pid>s.
> 
> here is my sqlrelay.conf (only the instance part)：
> <instance id="orcl_dev" port="9000" socket="/tmp/orcl_dev.socket"
> dbase="oracle8" connections="30" maxconnections="150"
> maxqueuelength="2" growby="1" ttl="600" endofsession="commit"
> sessiontimeout="600" runasuser="webuser" runasgroup="webuser"
> cursors="5" authtier="listener" handoff="pass" deniedips=""
> allowedips="" debug="connection" maxquerysize="65536"
> maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
> idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
> reloginatstart="yes">
> 
> Is there any setting I should try to change in the config file?
> Or, does this is apparently a network problem ?
> I really appreciate any help.
> 
> Regards,
> 
> Dante Mason
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> &#0;&#0;5睥v7zf׋'"j̰Cך-yاyך'(

[Sqlrelay-discussion] I need help -- Sometimes I got this : nativecode=Couldn't connect to the listener

[<ma...@si...>]

Hello,

This is the 4th mail I sent this afternoon, 
the content of previous 3 mails are the same as this one.
But some how gmail sent them in MIME. That was a mass.
I am really sorry sent suplicate content,
but I really need a direction to solve my problem.

I use sqlrelay-0.39.2, and I did not use previous versions before.
I am using it to connect to oracle.
Everything goes fine till I got some complains from my users,
they claimed that they get the error message from php PEAR's getUserInfo,
and that message is "[nativecode=Couldn't connect to the listener]".

But I didn't see any strange information from sqlr-connection.<pid>s.

here is my sqlrelay.conf (only the instance part)：
<instance id="orcl_dev" port="9000" socket="/tmp/orcl_dev.socket"
dbase="oracle8" connections="30" maxconnections="150"
maxqueuelength="2" growby="1" ttl="600" endofsession="commit"
sessiontimeout="600" runasuser="webuser" runasgroup="webuser"
cursors="5" authtier="listener" handoff="pass" deniedips=""
allowedips="" debug="connection" maxquerysize="65536"
maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
reloginatstart="yes">

Is there any setting I should try to change in the config file?
Or, does this is apparently a network problem ?
I really appreciate any help.

Regards,

Dante Mason

[Sqlrelay-discussion] Sometimes I got [nativecode=Couldn't connect to the listener]

[<ma...@si...>]

Hello,

I use sqlrelay-0.39.2, and I did not use previous versions before.
I am using it to connect to oracle.
Everything goes fine till I got some complains from my users,
they claimed that they get the error message from php PEAR's getUserInfo,
and that message is "[nativecode=Couldn't connect to the listener]".

But I didn't see any strange information from sqlr-connection.<pid>s.

here is my sqlrelay.conf (only the instance part)：
<instance id="orcl_dev" port="9000" socket="/tmp/orcl_dev.socket"
dbase="oracle8" connections="30" maxconnections="150"
maxqueuelength="2" growby="1" ttl="600" endofsession="commit"
sessiontimeout="600" runasuser="webuser" runasgroup="webuser"
cursors="5" authtier="listener" handoff="pass" deniedips=""
allowedips="" debug="connection" maxquerysize="65536"
maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
reloginatstart="yes">

Is there any setting I should try to change in the config file?
Or, does this is apparently a network problem ?
I really appreciate any help.

Regards,
Mason

[Sqlrelay-discussion] Sometimes I got [nativecode=Couldn't connect to the listener]

[<ma...@si...>]

I don't know why Gmail always send my mails in MIME.
I am so sorry to send the same mail 3 times...
But this time, it's plain text.
====================================================
Hello,

I use sqlrelay-0.39.2, and I did not use previous versions before.
I am using it to connect to oracle.
Everything goes fine till I got some complains from my users,
the claimed that they get the error message from php PEAR's getUserInfo,
and that message is "[nativecode=Couldn't connect to the listener]".

But I didn't see any strange information from sqlr-connection.<pid>s.

here is my sqlrelay.conf (only the instance part)：
<instance id="orcl_dev" port="9000" socket="/tmp/orcl_dev.socket"
dbase="oracle8" connections="30" maxconnections="150"
maxqueuelength="2" growby="1" ttl="600" endofsession="commit"
sessiontimeout="600" runasuser="webuser" runasgroup="webuser"
cursors="5" authtier="listener" handoff="pass" deniedips=""
allowedips="" debug="connection" maxquerysize="65536"
maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
reloginatstart="yes">

Is there any setting I should try to change in the config file?
Or, does this is apparently a network problem ?
I really appreciate any help.

Regards,
Dante Mason

[Sqlrelay-discussion] Sometimes I got [nativecode=Couldn't connect to the listener]

[Dante M. <dan...@gm...>]

SGVsbG8sCgpJIHVzZSBzcWxyZWxheS0wLjM5LjIsIGFuZCBJIGRpZCBub3QgdXNlIHByZXZpb3Mg
dmVyc2lvbnMgYmVmb3JlLgpJIGFtIHVzaW5nIGl0IHRvIGNvbm5lY3QgdG8gb3JhY2xlLgpFdmVy
eXRoaW5nIGdvZXMgZmluZSB0aWxsIEkgZ290IHNvbWUgY29tcGlhbGlucyBmcm9tIG15IHVzZXJz
LAp0aGUgY2xhaW1lZCB0aGF0IHRoZXkgZ2V0IHRoZSBlcnJvciBtZXNzYWdlIGZyb20gcGhwIFBF
QVIncyBnZXRVc2VySW5mbywKYW5kIHRoYXQgbWVzc2FnZSBpcyAiW25hdGl2ZWNvZGU9Q291bGRu
J3QgY29ubmVjdCB0byB0aGUgbGlzdGVuZXJdIi4KCkJ1dCBJIGRpZG4ndCBzZWUgYW55IHN0cmFu
Z2UgaW5mb3JtYXRpb24gZnJvbSBzcWxyLWNvbm5lY3Rpb24uPHBpZD5zLgoKaGVyZSBpcyBteSBz
cWxyZWxheS5jb25mIChvbmx5IHRoZSBpbnN0YW5jZSBwYXJ0KaFHCjxpbnN0YW5jZSBpZD0ib3Jj
bF9kZXYiIHBvcnQ9IjkwMDAiIHNvY2tldD0iL3RtcC9vcmNsX2Rldi5zb2NrZXQiCmRiYXNlPSJv
cmFjbGU4IiBjb25uZWN0aW9ucz0iMzAiIG1heGNvbm5lY3Rpb25zPSIxNTAiIG1heHF1ZXVlbGVu
Z3RoPSIyIgpncm93Ynk9IjEiIHR0bD0iNjAwIiBlbmRvZnNlc3Npb249ImNvbW1pdCIgc2Vzc2lv
bnRpbWVvdXQ9IjYwMCIKcnVuYXN1c2VyPSJ3ZWJ1c2VyIiBydW5hc2dyb3VwPSJ3ZWJ1c2VyIiBj
dXJzb3JzPSI1IiBhdXRodGllcj0ibGlzdGVuZXIiCmhhbmRvZmY9InBhc3MiIGRlbmllZGlwcz0i
IiBhbGxvd2VkaXBzPSIiIGRlYnVnPSJjb25uZWN0aW9uIgptYXhxdWVyeXNpemU9IjY1NTM2IiBt
YXhzdHJpbmdiaW5kdmFsdWVsZW5ndGg9IjQwMDAiCm1heGxvYmJpbmR2YWx1ZWxlbmd0aD0iNzE2
ODAiIGlkbGVjbGllbnR0aW1lb3V0PSItMSIgbWF4bGlzdGVuZXJzPSItMSIKbGlzdGVuZXJ0aW1l
b3V0PSIwIiByZWxvZ2luYXRzdGFydD0ieWVzIj4KCklzIHRoZXJlIGFueSBzZXR0aW5nIEkgc2hv
dWxkIHRyeSB0byBjaGFuZ2UgaW4gdGhlIGNvbmZpZyBmaWxlPwpPciwgZG9lcyB0aGlzIGlzIGFw
cGFyZW50bHkgYSBuZXR3b3JrIHByb2JsZW0gPwpJIHJlYWxseSBhcHByZWNpYXRlIGFueSBoZWxw
LgotLSAKVGhleSBwcm9taXNlZCBtZSBhIG1pcmFjbGUKYSBwcml2YXRlIGdvZCBmb3IgbWUgdG8g
aG9sZAo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0KRGFudGUgTWFzb24gPGRhbnRlbWFz
b25AZ21haWwuY29tPgo=

[Sqlrelay-discussion] Sometimes I got [nativecode=Couldn't connect to the listener]

[Dante M. <dan...@gm...>]

SGVsbG8sCgpJIHVzZSBzcWxyZWxheS0wLjM5LjIsIGFuZCBJIGRpZCBub3QgdXNlIHByZXZpb3Vz
IHZlcnNpb25zIGJlZm9yZS4KSSBhbSB1c2luZyBpdCB0byBjb25uZWN0IHRvIG9yYWNsZS4KRXZl
cnl0aGluZyBnb2VzIGZpbmUgdGlsbCBJIGdvdCBzb21lIGNvbXBsYWlucyBmcm9tIG15IHVzZXJz
LAp0aGUgY2xhaW1lZCB0aGF0IHRoZXkgZ2V0IHRoZSBlcnJvciBtZXNzYWdlIGZyb20gcGhwIFBF
QVIncyBnZXRVc2VySW5mbywKYW5kIHRoYXQgbWVzc2FnZSBpcyAiW25hdGl2ZWNvZGU9Q291bGRu
J3QgY29ubmVjdCB0byB0aGUgbGlzdGVuZXJdIi4KCkJ1dCBJIGRpZG4ndCBzZWUgYW55IHN0cmFu
Z2UgaW5mb3JtYXRpb24gZnJvbSBzcWxyLWNvbm5lY3Rpb24uPHBpZD5zLgoKaGVyZSBpcyBteSBz
cWxyZWxheS5jb25mIChvbmx5IHRoZSBpbnN0YW5jZSBwYXJ0KaFHCjxpbnN0YW5jZSBpZD0ib3Jj
bF9kZXYiIHBvcnQ9IjkwMDAiIHNvY2tldD0iL3RtcC9vcmNsX2Rldi5zb2NrZXQiCmRiYXNlPSJv
cmFjbGU4IiBjb25uZWN0aW9ucz0iMzAiIG1heGNvbm5lY3Rpb25zPSIxNTAiCm1heHF1ZXVlbGVu
Z3RoPSIyIiBncm93Ynk9IjEiIHR0bD0iNjAwIiBlbmRvZnNlc3Npb249ImNvbW1pdCIKc2Vzc2lv
bnRpbWVvdXQ9IjYwMCIgcnVuYXN1c2VyPSJ3ZWJ1c2VyIiBydW5hc2dyb3VwPSJ3ZWJ1c2VyIgpj
dXJzb3JzPSI1IiBhdXRodGllcj0ibGlzdGVuZXIiIGhhbmRvZmY9InBhc3MiIGRlbmllZGlwcz0i
IgphbGxvd2VkaXBzPSIiIGRlYnVnPSJjb25uZWN0aW9uIiBtYXhxdWVyeXNpemU9IjY1NTM2Igpt
YXhzdHJpbmdiaW5kdmFsdWVsZW5ndGg9IjQwMDAiIG1heGxvYmJpbmR2YWx1ZWxlbmd0aD0iNzE2
ODAiCmlkbGVjbGllbnR0aW1lb3V0PSItMSIgbWF4bGlzdGVuZXJzPSItMSIgbGlzdGVuZXJ0aW1l
b3V0PSIwIgpyZWxvZ2luYXRzdGFydD0ieWVzIj4KCklzIHRoZXJlIGFueSBzZXR0aW5nIEkgc2hv
dWxkIHRyeSB0byBjaGFuZ2UgaW4gdGhlIGNvbmZpZyBmaWxlPwpPciwgZG9lcyB0aGlzIGlzIGFw
cGFyZW50bHkgYSBuZXR3b3JrIHByb2JsZW0gPwpJIHJlYWxseSBhcHByZWNpYXRlIGFueSBoZWxw
LgoKLS0gClRoZXkgcHJvbWlzZWQgbWUgYSBtaXJhY2xlCmEgcHJpdmF0ZSBnb2QgZm9yIG1lIHRv
IGhvbGQKPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09CkRhbnRlIE1hc29uIDxkYW50ZW1h
c29uQGdtYWlsLmNvbT4K