sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] build problems on Solaris 2.8

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

Those are some strange errors like I've never seen before :)  It looks
like libtool is having trouble figuring out the rules for your system
and adding .libs before the library when it shouldn't.  What platform
are you building on?

Also, look in /auto/tte/its/SQLRELAY/lib, are there any librudiments
files installed there?

You might need to re-libtoolize for your system.  Do you have the
libtool and autoconf packages installed?  If so, let me know and I'll
walk you through it.

Dave
dav...@fi...


On Wed, 2008-01-30 at 16:07 -0500, John Klassa wrote:
> I finally got rudiments to build, but to do so, I had to get rid of
> the "-rpath $(libdir)" from the Makefile, and then also had to remove
> a bogus, trailing "i" from the value of "instname" (in libtool).
> 
> When I try to build SQL Relay proper, though, I get this far:
> 
> % make
> make -C src all
> make[1]: Entering directory `/tmp/sqlrelay-0.39.4/src'
> make -C util all
> make[2]: Entering directory `/tmp/sqlrelay-0.39.4/src/util'
> /bin/sh ../../libtool --mode=link g++ -o libsqlrutil.la cmdline.lo
> debugfile.lo tempdir.lo sqlrconfigfile.lo authenticator.lo
> -L/auto/tte/its/SQLRELAY/lib -lrudiments -lsocket -lrt -lresolv
> -rpath /auto/tte/its/SQLRELAY/lib -release 0.39.4 -version-info 1:0:0
> -no-undefined
> rm -fr  .libs/libsqlrutil.lax
> rm -fr .libs/libsqlrutil.lax
> mkdir .libs/libsqlrutil.lax
> rm -fr .libs/libsqlrutil.lax/librudiments.a
> mkdir .libs/libsqlrutil.lax/librudiments.a
> (cd .libs/libsqlrutil.lax/librudiments.a && ar x
> /auto/tte/its/SQLRELAY/lib/.libs/librudiments.a)
> ar: /auto/tte/its/SQLRELAY/lib/.libs/librudiments.a: No such file or directory
> make[2]: *** [libsqlrutil.la] Error 9
> make[2]: Leaving directory `/tmp/sqlrelay-0.39.4/src/util'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/tmp/sqlrelay-0.39.4/src'
> make: *** [all] Error 2
> Exit 2
> 
> Note that /auto/tte/its/SQLRELAY is what I passed in via
> --with-rudiments-prefix.  Why is it looking in
> /auto/tte/its/SQLRELAY/lib/.libs rather than just
> /auto/tte/its/SQLRELAY/lib, though (i.e. why the extra ".libs")?
> 
> Confused,
> JK
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> 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] build problems on Solaris 2.8

[John K. <kl...@gm...>]

I finally got rudiments to build, but to do so, I had to get rid of
the "-rpath $(libdir)" from the Makefile, and then also had to remove
a bogus, trailing "i" from the value of "instname" (in libtool).

When I try to build SQL Relay proper, though, I get this far:

% make
make -C src all
make[1]: Entering directory `/tmp/sqlrelay-0.39.4/src'
make -C util all
make[2]: Entering directory `/tmp/sqlrelay-0.39.4/src/util'
/bin/sh ../../libtool --mode=link g++ -o libsqlrutil.la cmdline.lo
debugfile.lo tempdir.lo sqlrconfigfile.lo authenticator.lo
-L/auto/tte/its/SQLRELAY/lib -lrudiments -lsocket -lrt -lresolv
-rpath /auto/tte/its/SQLRELAY/lib -release 0.39.4 -version-info 1:0:0
-no-undefined
rm -fr  .libs/libsqlrutil.lax
rm -fr .libs/libsqlrutil.lax
mkdir .libs/libsqlrutil.lax
rm -fr .libs/libsqlrutil.lax/librudiments.a
mkdir .libs/libsqlrutil.lax/librudiments.a
(cd .libs/libsqlrutil.lax/librudiments.a && ar x
/auto/tte/its/SQLRELAY/lib/.libs/librudiments.a)
ar: /auto/tte/its/SQLRELAY/lib/.libs/librudiments.a: No such file or directory
make[2]: *** [libsqlrutil.la] Error 9
make[2]: Leaving directory `/tmp/sqlrelay-0.39.4/src/util'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/tmp/sqlrelay-0.39.4/src'
make: *** [all] Error 2
Exit 2

Note that /auto/tte/its/SQLRELAY is what I passed in via
--with-rudiments-prefix.  Why is it looking in
/auto/tte/its/SQLRELAY/lib/.libs rather than just
/auto/tte/its/SQLRELAY/lib, though (i.e. why the extra ".libs")?

Confused,
JK

Re: [Sqlrelay-discussion] large-scale deployment?

[John K. <kl...@gm...>]

Excellent...  Thank you, David!

On Jan 30, 2008 9:35 AM, David Muse <dav...@fi...> wrote:
> I've worked with several clients, 3 that I can think of offhand, to do
> large scale deployments with that level of traffic, but not spread out
> geographically like that.
>
> I really couldn't go into the details without getting permission from
> each of the clients.  Hopefully some of them will respond here :)
>
> SQL Relay should be able to handle that level of traffic, so unless
> there's an odd, complicating factor in your setup, then I imagine SQL
> Relay would perform well for you.
>
> David Muse
> dav...@fi...
>
>
> On Wed, 2008-01-30 at 09:15 -0500, John Klassa wrote:
> > Hi,
> >
> > I browsed through the list archive, but didn't see anything on this topic...
> >
> > I'm considering SQL Relay for a particular need we have, for which it
> > seems amazingly, wonderfully suited.  However, the environment in
> > which I'm working is rather large...
> >
> > We've got thousands of users spread all over the global, over an
> > intranet/WAN.  They run perl scripts that hit a database, where the
> > separation between the clients and the servers can be on the order of
> > thousands of miles (California to India, in some cases).  These
> > scripts get run, literally, 250,000+ times a day.  And at that, our
> > database can't handle the concurrency that results from the arbitrary,
> > ad-hoc execution of these scripts, from anywhere and everywhere.  We'd
> > like to employ some connection pooling and throttling, to even things
> > out.
> >
> > (No, I didn't design the system. :-))
> >
> > Anyway, before I get too excited about SQL Relay, can anyone share a
> > success story, where SQL Relay was used in an environment this large?
> >
> > Thanks in advance...
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> 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] large-scale deployment?

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

I've worked with several clients, 3 that I can think of offhand, to do
large scale deployments with that level of traffic, but not spread out
geographically like that.

I really couldn't go into the details without getting permission from
each of the clients.  Hopefully some of them will respond here :)

SQL Relay should be able to handle that level of traffic, so unless
there's an odd, complicating factor in your setup, then I imagine SQL
Relay would perform well for you.

David Muse
dav...@fi...

On Wed, 2008-01-30 at 09:15 -0500, John Klassa wrote:
> Hi,
> 
> I browsed through the list archive, but didn't see anything on this topic...
> 
> I'm considering SQL Relay for a particular need we have, for which it
> seems amazingly, wonderfully suited.  However, the environment in
> which I'm working is rather large...
> 
> We've got thousands of users spread all over the global, over an
> intranet/WAN.  They run perl scripts that hit a database, where the
> separation between the clients and the servers can be on the order of
> thousands of miles (California to India, in some cases).  These
> scripts get run, literally, 250,000+ times a day.  And at that, our
> database can't handle the concurrency that results from the arbitrary,
> ad-hoc execution of these scripts, from anywhere and everywhere.  We'd
> like to employ some connection pooling and throttling, to even things
> out.
> 
> (No, I didn't design the system. :-))
> 
> Anyway, before I get too excited about SQL Relay, can anyone share a
> success story, where SQL Relay was used in an environment this large?
> 
> Thanks in advance...
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> 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] large-scale deployment?

[John K. <kl...@gm...>]

Hi,

I browsed through the list archive, but didn't see anything on this topic...

I'm considering SQL Relay for a particular need we have, for which it
seems amazingly, wonderfully suited.  However, the environment in
which I'm working is rather large...

We've got thousands of users spread all over the global, over an
intranet/WAN.  They run perl scripts that hit a database, where the
separation between the clients and the servers can be on the order of
thousands of miles (California to India, in some cases).  These
scripts get run, literally, 250,000+ times a day.  And at that, our
database can't handle the concurrency that results from the arbitrary,
ad-hoc execution of these scripts, from anywhere and everywhere.  We'd
like to employ some connection pooling and throttling, to even things
out.

(No, I didn't design the system. :-))

Anyway, before I get too excited about SQL Relay, can anyone share a
success story, where SQL Relay was used in an environment this large?

Thanks in advance...

Re: [Sqlrelay-discussion] SQLRelay can't handle queries larger than 65535 bytes

[Martin F. <mar...@po...>]

David Muse schreef:
> Your intuition is probably correct! :)
>
> There's a parameter in the sqlrelay.conf file called maxquerysize that
> determines the maximum length query that the sqlrelay server will
> accept.  The default is 64K, but you can make it larger if you like.
> See http://sqlrelay.sourceforge.net/sqlrelay/configuring.html for more
> info on that.
>
> It's odd that you get that particular error though.  I think that may be
> a bug.  I did recently fix a bug that caused that error to show up in
> several cases where it shouldn't, so it may be fixed in CVS.
>
> Try modifying maxquerysize and see if it doesn't solve the problem.
>   
It solves the problem, thanks!

A different error message would be appropriate, however.

Best regards,

Martin

Re: [Sqlrelay-discussion] SQLRelay can't handle queries larger than 65535 bytes

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

Your intuition is probably correct! :)

There's a parameter in the sqlrelay.conf file called maxquerysize that
determines the maximum length query that the sqlrelay server will
accept.  The default is 64K, but you can make it larger if you like.
See http://sqlrelay.sourceforge.net/sqlrelay/configuring.html for more
info on that.

It's odd that you get that particular error though.  I think that may be
a bug.  I did recently fix a bug that caused that error to show up in
several cases where it shouldn't, so it may be fixed in CVS.

Try modifying maxquerysize and see if it doesn't solve the problem.

David Muse
dav...@fi...

On Fri, 2008-01-18 at 12:53 +0100, Martin Fleurke wrote:
> Hello,
> 
> When you issue a query that is larger than 65535*) bytes, you get a 
> "Failed to get a cursor id. A network error may have ocurred." error.
> 
> This is with Oracle 10g as database, and php, and sqlrelay 0.39.4. The 
> php-OCI8 functions do not have this limit.
> 
> *) I could go to a max of 65536 according to php-strlen() function, but 
> I assume it has something to do with 2^16 = 65535.
> 
> Regards,
> 
> Martin
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> 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 can't handle queries larger than 65535 bytes

[Martin F. <mar...@po...>]

Hello,

When you issue a query that is larger than 65535*) bytes, you get a 
"Failed to get a cursor id. A network error may have ocurred." error.

This is with Oracle 10g as database, and php, and sqlrelay 0.39.4. The 
php-OCI8 functions do not have this limit.

*) I could go to a max of 65536 according to php-strlen() function, but 
I assume it has something to do with 2^16 = 65535.

Regards,

Martin

Re: [Sqlrelay-discussion] mysql - timout (2)

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

Hello, sorry for the delay.  The holiday season was hectic.

I've gotten 2 reports of this so far.  I'm not sure yet what's causing
it, but I'll send out a message to the group when I figure it out.  It
shouldn't be too hard to track down, but no luck yet :/

Dave
dav...@fi...

On Thu, 2007-12-27 at 13:09 +0100, F=C3=BCrchti wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
> Hello,
>=20
> I did some more testing and found out that whenever a connection to
> mysql is closed (sql-server restart...) the connection tries to issue
> querys and gets an error, but does not reconnect or stop. the debug file
> just keeps on growing as well as the opened server connections. to
> reproduce this error:
>=20
> - - start mysql and sqlrelay
> - - issue a query via the command line tool query
> - - restart mysql server
> - - issue another query
>=20
>=20
> Help is highly appriciated...
>=20
> Abraham M=C3=BCller
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.4-svn0 (GNU/Linux)
> Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
>=20
> iQCVAwUBR3OV/6hLB9IsCDIAAQKG6AP/Tn8Axyf2VNUWwolYPuhuDGxGu251vP0w
> RhiFbnAZXWZVWHfp9596uGXlqksD9Mzdoxp00mALHtiEFK17htjZ7C1Qsvefpi5A
> kzjJobclUocIadL2TF4aPsOrLXlEpG2L3vI9jQEEV+fPpS4hBnyeQE310dXJ0PRT
> OYpDp8x8Tk4=3D
> =3DqErY
> -----END PGP SIGNATURE-----
>=20
> -------------------------------------------------------------------------
> 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
>=20

[Sqlrelay-discussion] mysql - timout (2)

[<ab...@gm...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

I did some more testing and found out that whenever a connection to
mysql is closed (sql-server restart...) the connection tries to issue
querys and gets an error, but does not reconnect or stop. the debug file
just keeps on growing as well as the opened server connections. to
reproduce this error:

- - start mysql and sqlrelay
- - issue a query via the command line tool query
- - restart mysql server
- - issue another query


Help is highly appriciated...

Abraham Müller
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iQCVAwUBR3OV/6hLB9IsCDIAAQKG6AP/Tn8Axyf2VNUWwolYPuhuDGxGu251vP0w
RhiFbnAZXWZVWHfp9596uGXlqksD9Mzdoxp00mALHtiEFK17htjZ7C1Qsvefpi5A
kzjJobclUocIadL2TF4aPsOrLXlEpG2L3vI9jQEEV+fPpS4hBnyeQE310dXJ0PRT
OYpDp8x8Tk4=
=qErY
-----END PGP SIGNATURE-----

[Sqlrelay-discussion] mysql - timeout

[<ab...@gm...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello all,

I have a problem with the sqlrelay using mysql. When mysql closes the
connection due to timeout (specified by wait_timeout) sqlrelay hangs.
sqlrelay keeps increasing the opened server connections and the open
server connection stay the same, but no answer to my php script.

Any suggestions? Thanks for your help in advance.

Abraham Müller
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iQCVAwUBR3IbUahLB9IsCDIAAQIibQP/W20zGYyfahEYAsAdsjMkbJ/xeFwU3l7j
pqYm8pwAo3OYDfLbS5qVdzoQ0ebtN1NKqzfVEG1117zRp/L6c61VRg7kPVxbb40i
J5FsbKNTbgqwZhmoGlfYLd9gop08v6H0tgVXDn1b9zzMx25v+xFylR4+xPm4JLMM
YZSIvsa8iAU=
=bQW4
-----END PGP SIGNATURE-----

Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

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

Hi David,

I have been trying to debug what's going on. The connection process
crashes on this statement

                OCIHandleFree(def[i],OCI_HTYPE_DEFINE);

line 1744 of oracle8connection.C with a segmentation fault. I've not
been able to figer out why this happens. I am new to C++ and GDB and I
cannot view the contents of the OCIDefine object. However, when I
looked into the Oracle Call Interface Programmer's Guide

http://www.ewp.rpi.edu/hartford/webgen//appdocs/oracle/doc/appdev.920/a96584/oci02bas.htm

it said the following:

OCI_HTYPE_DEFINE = OCI define handle

and

Bind and define handles are freed when the statement handle is freed
or when a new statement is prepared on the statement handle.

So my question is, why is it being freed explicitly anyway? I've
compiled sqlrelay with the statement commented out, and now everything
seems to be going fine. For what situations is the
OCIHandleFree(def[i],OCI_HTYPE_DEFINE) statement neccesary?

Anxiously awaiting your reply,

Ingmar

Re: [Sqlrelay-discussion] Fwd: problem config sqlrelay router

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

Hello,

I'm not sure what you're attempting to do.  If you're trying to use
sqlrelay between psql and postmaster, then you just need to use 1
instance of SQL Relay configured to connect to the postgresql database
and you need to use the postgresql drop-in replacement library on the
client machine.

You'll need to use a configuration similar to the one defined in:
http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/postgresql.html#sqlrelay
to connect to the postgresql database.  You should use sqlrsh to test
it.

If that's working, then you need to use the drop-in replacement library
as described in:
http://sqlrelay.sourceforge.net/sqlrelay/dropin/postgresql.html
to use psql.

You only need to use sqlrelay as a router if you want to send some
queries to one instance of postgresql and other queries to a different
instance.

David Muse
dav...@fi...


On Sun, 2007-11-18 at 17:44 +0100, Heiko L. wrote:
> 
> hallo *!
> 
> 
> I try one config with router, but it does not work.
> 
> - config:
> 
>   psql ----- :9000 sqlrelay ------ :5432 postmaster
>   x.x.x.87      x.x.x.73               x.x.x.74
> 
> 
> $ egrep "instance |user |route " /usr/local/firstworks/etc/sqlrelay.conf |
> cut -c  1-70
>         <instance id="inspg1" port="9000" unixport="/tmp/psql.socket"
>                         <user user="smuser" password="smpass"/>
>                         <user user="smuser" password="smpass"/>
>                         <route host="x.x.x.74" port="5432" socket
> 
> 
> - Test route sqlrelay-0.35-10 (debian sarge)
> 
> sqlrelay $ sqlr-start -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf
> 
>  Starting listener:
>    sqlr-listener -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf Could not listen on inet port:
> 5432
>    Make sure that no other processes are listening on that port.
> 
> 
>    sqlr-listener failed to start.
> 
> - Test route sqlrelay-0.39
> 
> sqlrelay $ /usr/local/firstworks/bin/sqlr-start -id inspg1 ; netstat -anep
> | grep sqlr ;
> 
> 
> Starting listener:
>   sqlr-listener -id inspg1 -config /usr/local/firstworks/etc/sqlrelay.conf
> 
> Starting 1 connections to defaultid :
>   sqlr-connection-router -id inspg1 -connectionid defaultid -config
> /usr/local/f
> irstworks/etc/sqlrelay.conf
> 
> Starting cache manager:
>   sqlr-cachemanager
> Warning: using default id.
> 
> 
> tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
>     6
> 5534      18502296   5338/sqlr-listener
> tcp        0      0 0.0.0.0:52403           0.0.0.0:*               LISTEN
>     6
> 5534      18502793   5343/sqlr-connectio
> tcp        0      0 x.x.x.73:9000      x.x.x.87:54624     ESTABLISHED6
> 5534      18503113   5338/sqlr-listener
> unix  2      [ ACC ]     STREAM     LISTENING     18502297
> 5338/sqlr-listener  /tmp/psql.socket
> unix  2      [ ACC ]     STREAM     LISTENING     18502791
> 5343/sqlr-connectio /
> 
> usr/local/firstworks/var/sqlrelay/tmp/sockets/6
> 
> $ tail /var/log/postgresql/postgres.log;
> 2007-11-16 15:54:31 [6098] LOG:  connection received: host=x.x.x.73
> port=55699
> 2007-11-16 15:54:31 [6098] LOG:  invalid length of startup packet
> 2007-11-16 15:54:31 [6099] LOG:  connection received: host=x.x.x.73
> port=55700
> 2007-11-16 15:54:31 [6099] LOG:  invalid length of startup packet
> 
> 
> - summary:
>   - 0.35-10
>     - sqlrelay listen on :5432 , should be :9000
>   - 0.39
>     - sqlrelay listen on :9000, but not forward connection to postmaster
> 
> Whats going wrong?
> 
> regards heiko
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------------------------
> 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] Fwd: problem config sqlrelay router

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

Hey Guys,

I promise the project is not dormant or dead.  But it does take me a
while to respond to the list sometimes.  I'll see if I can take care of
pending requests later today.

Dave Muse
dav...@fi...

On Tue, 2007-11-20 at 18:00 +1100, Mark Van De Vyver wrote:
> hi heiko,
> did you get any response to your post?
> I've been considering this project but it appears it may be dormant or
> worse dead?
> 
> Were you able to get the SQLrelay working?
> 
> Appreciate any response you can offer.
> Regards
> Mark
> 
> On Nov 19, 2007 3:44 AM, Heiko L. <he...@fh...> wrote:
> >
> >
> > hallo *!
> >
> >
> > I try one config with router, but it does not work.
> >
> > - config:
> >
> >   psql ----- :9000 sqlrelay ------ :5432 postmaster
> >   x.x.x.87      x.x.x.73               x.x.x.74
> >
> >
> > $ egrep "instance |user |route " /usr/local/firstworks/etc/sqlrelay.conf |
> > cut -c  1-70
> >         <instance id="inspg1" port="9000" unixport="/tmp/psql.socket"
> >                         <user user="smuser" password="smpass"/>
> >                         <user user="smuser" password="smpass"/>
> >                         <route host="x.x.x.74" port="5432" socket
> >
> >
> > - Test route sqlrelay-0.35-10 (debian sarge)
> >
> > sqlrelay $ sqlr-start -id inspg1 -config
> > /usr/local/firstworks/etc/sqlrelay.conf
> >
> >  Starting listener:
> >    sqlr-listener -id inspg1 -config
> > /usr/local/firstworks/etc/sqlrelay.conf Could not listen on inet port:
> > 5432
> >    Make sure that no other processes are listening on that port.
> >
> >
> >    sqlr-listener failed to start.
> >
> > - Test route sqlrelay-0.39
> >
> > sqlrelay $ /usr/local/firstworks/bin/sqlr-start -id inspg1 ; netstat -anep
> > | grep sqlr ;
> >
> >
> > Starting listener:
> >   sqlr-listener -id inspg1 -config /usr/local/firstworks/etc/sqlrelay.conf
> >
> > Starting 1 connections to defaultid :
> >   sqlr-connection-router -id inspg1 -connectionid defaultid -config
> > /usr/local/f
> > irstworks/etc/sqlrelay.conf
> >
> > Starting cache manager:
> >   sqlr-cachemanager
> > Warning: using default id.
> >
> >
> > tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
> >     6
> > 5534      18502296   5338/sqlr-listener
> > tcp        0      0 0.0.0.0:52403           0.0.0.0:*               LISTEN
> >     6
> > 5534      18502793   5343/sqlr-connectio
> > tcp        0      0 x.x.x.73:9000      x.x.x.87:54624     ESTABLISHED6
> > 5534      18503113   5338/sqlr-listener
> > unix  2      [ ACC ]     STREAM     LISTENING     18502297
> > 5338/sqlr-listener  /tmp/psql.socket
> > unix  2      [ ACC ]     STREAM     LISTENING     18502791
> > 5343/sqlr-connectio /
> >
> > usr/local/firstworks/var/sqlrelay/tmp/sockets/6
> >
> > $ tail /var/log/postgresql/postgres.log;
> > 2007-11-16 15:54:31 [6098] LOG:  connection received: host=x.x.x.73
> > port=55699
> > 2007-11-16 15:54:31 [6098] LOG:  invalid length of startup packet
> > 2007-11-16 15:54:31 [6099] LOG:  connection received: host=x.x.x.73
> > port=55700
> > 2007-11-16 15:54:31 [6099] LOG:  invalid length of startup packet
> >
> >
> > - summary:
> >   - 0.35-10
> >     - sqlrelay listen on :5432 , should be :9000
> >   - 0.39
> >     - sqlrelay listen on :9000, but not forward connection to postmaster
> >
> > Whats going wrong?
> >
> > regards heiko
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------------------------
> > 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
> >
> 
> -------------------------------------------------------------------------
> 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] Fwd: problem config sqlrelay router

[Mark V. De V. <mv...@gm...>]

hi heiko,
did you get any response to your post?
I've been considering this project but it appears it may be dormant or
worse dead?

Were you able to get the SQLrelay working?

Appreciate any response you can offer.
Regards
Mark

On Nov 19, 2007 3:44 AM, Heiko L. <he...@fh...> wrote:
>
>
> hallo *!
>
>
> I try one config with router, but it does not work.
>
> - config:
>
>   psql ----- :9000 sqlrelay ------ :5432 postmaster
>   x.x.x.87      x.x.x.73               x.x.x.74
>
>
> $ egrep "instance |user |route " /usr/local/firstworks/etc/sqlrelay.conf |
> cut -c  1-70
>         <instance id="inspg1" port="9000" unixport="/tmp/psql.socket"
>                         <user user="smuser" password="smpass"/>
>                         <user user="smuser" password="smpass"/>
>                         <route host="x.x.x.74" port="5432" socket
>
>
> - Test route sqlrelay-0.35-10 (debian sarge)
>
> sqlrelay $ sqlr-start -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf
>
>  Starting listener:
>    sqlr-listener -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf Could not listen on inet port:
> 5432
>    Make sure that no other processes are listening on that port.
>
>
>    sqlr-listener failed to start.
>
> - Test route sqlrelay-0.39
>
> sqlrelay $ /usr/local/firstworks/bin/sqlr-start -id inspg1 ; netstat -anep
> | grep sqlr ;
>
>
> Starting listener:
>   sqlr-listener -id inspg1 -config /usr/local/firstworks/etc/sqlrelay.conf
>
> Starting 1 connections to defaultid :
>   sqlr-connection-router -id inspg1 -connectionid defaultid -config
> /usr/local/f
> irstworks/etc/sqlrelay.conf
>
> Starting cache manager:
>   sqlr-cachemanager
> Warning: using default id.
>
>
> tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
>     6
> 5534      18502296   5338/sqlr-listener
> tcp        0      0 0.0.0.0:52403           0.0.0.0:*               LISTEN
>     6
> 5534      18502793   5343/sqlr-connectio
> tcp        0      0 x.x.x.73:9000      x.x.x.87:54624     ESTABLISHED6
> 5534      18503113   5338/sqlr-listener
> unix  2      [ ACC ]     STREAM     LISTENING     18502297
> 5338/sqlr-listener  /tmp/psql.socket
> unix  2      [ ACC ]     STREAM     LISTENING     18502791
> 5343/sqlr-connectio /
>
> usr/local/firstworks/var/sqlrelay/tmp/sockets/6
>
> $ tail /var/log/postgresql/postgres.log;
> 2007-11-16 15:54:31 [6098] LOG:  connection received: host=x.x.x.73
> port=55699
> 2007-11-16 15:54:31 [6098] LOG:  invalid length of startup packet
> 2007-11-16 15:54:31 [6099] LOG:  connection received: host=x.x.x.73
> port=55700
> 2007-11-16 15:54:31 [6099] LOG:  invalid length of startup packet
>
>
> - summary:
>   - 0.35-10
>     - sqlrelay listen on :5432 , should be :9000
>   - 0.39
>     - sqlrelay listen on :9000, but not forward connection to postmaster
>
> Whats going wrong?
>
> regards heiko
>
>
>
>
>
>
> -------------------------------------------------------------------------
> 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] [Fwd: sqlrelay overview]

[Heiko L. <he...@fh...>]

How to konfigueren sqlrelay?
unfortunately i found no overviews.
I analyzed sqrelay.config.examples and found 2 scenarios:

- connection


   client            sqlserver               sqlserver
  -------       ----------------------------------------------
  |psql |-------|instances - connection  -------  postmaster |
  -------       ----------------------------------------------
              :9000                        psql.socket

     <instance id="example" port="9000" socket="/tmp/example.socket"
        <connection connectionid="db1"

- router

   client            sqlrelay               sqlserver
  -------       -----------------------       -------------
  |psql |-------|instances - router   |------ |postmaster |
  -------       -----------------------       -------------
              :9000                        :5432


    <instance id="example" port="9000" socket="/tmp/example.socket"
      <route host="sqlserver" port="5432" socket=""

Is this correct?
Does it still more scenarios give?
which task has "instance socket"?


regards heiko

[Sqlrelay-discussion] Fwd: problem config sqlrelay router

[Heiko L. <he...@fh...>]

hallo *!


I try one config with router, but it does not work.

- config:

  psql ----- :9000 sqlrelay ------ :5432 postmaster
  x.x.x.87      x.x.x.73               x.x.x.74


$ egrep "instance |user |route " /usr/local/firstworks/etc/sqlrelay.conf |
cut -c  1-70
        <instance id="inspg1" port="9000" unixport="/tmp/psql.socket"
                        <user user="smuser" password="smpass"/>
                        <user user="smuser" password="smpass"/>
                        <route host="x.x.x.74" port="5432" socket


- Test route sqlrelay-0.35-10 (debian sarge)

sqlrelay $ sqlr-start -id inspg1 -config
/usr/local/firstworks/etc/sqlrelay.conf

 Starting listener:
   sqlr-listener -id inspg1 -config
/usr/local/firstworks/etc/sqlrelay.conf Could not listen on inet port:
5432
   Make sure that no other processes are listening on that port.


   sqlr-listener failed to start.

- Test route sqlrelay-0.39

sqlrelay $ /usr/local/firstworks/bin/sqlr-start -id inspg1 ; netstat -anep
| grep sqlr ;


Starting listener:
  sqlr-listener -id inspg1 -config /usr/local/firstworks/etc/sqlrelay.conf

Starting 1 connections to defaultid :
  sqlr-connection-router -id inspg1 -connectionid defaultid -config
/usr/local/f
irstworks/etc/sqlrelay.conf

Starting cache manager:
  sqlr-cachemanager
Warning: using default id.


tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
    6
5534      18502296   5338/sqlr-listener
tcp        0      0 0.0.0.0:52403           0.0.0.0:*               LISTEN
    6
5534      18502793   5343/sqlr-connectio
tcp        0      0 x.x.x.73:9000      x.x.x.87:54624     ESTABLISHED6
5534      18503113   5338/sqlr-listener
unix  2      [ ACC ]     STREAM     LISTENING     18502297
5338/sqlr-listener  /tmp/psql.socket
unix  2      [ ACC ]     STREAM     LISTENING     18502791
5343/sqlr-connectio /

usr/local/firstworks/var/sqlrelay/tmp/sockets/6

$ tail /var/log/postgresql/postgres.log;
2007-11-16 15:54:31 [6098] LOG:  connection received: host=x.x.x.73
port=55699
2007-11-16 15:54:31 [6098] LOG:  invalid length of startup packet
2007-11-16 15:54:31 [6099] LOG:  connection received: host=x.x.x.73
port=55700
2007-11-16 15:54:31 [6099] LOG:  invalid length of startup packet


- summary:
  - 0.35-10
    - sqlrelay listen on :5432 , should be :9000
  - 0.39
    - sqlrelay listen on :9000, but not forward connection to postmaster

Whats going wrong?

regards heiko

Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

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

Hi David,

Unfortunately the fix didn't work, it resulted in a lot of 'failed to
get a cursor id' errors. I'm thinking about building a simple
workaround. When the maximum number of client connections is reached,
I want to compare that number with the number of actual connection
processes in the processlist and decrement the connectioncounter
accordingly. Do you think that would work as a quickfix ?

Friendly greetings,

Ingmar

Re: [Sqlrelay-discussion] ORA-01480 with long CLOBs?

[Alexander K. <ak-...@cy...>]

Hi David,

On Tue, Nov 06, 2007 at 10:43:01PM -0500, David Muse wrote:
> Sorry for the delay, I've been really busy and a little sick for the
> past couple of weeks.
No worries - thanks for the reply and glad to hear you're better ...

> If you could send me some example code then I'm sure I can track down
> the problem.

Here is some code that shows the problem. Apparently, the problem starts
at 65k+1:

use DBI;
use strict;
use warnings;

my $dbh = DBI->connect('dbi:SQLRelay:', 'user1', 'password1');

my $sth = $dbh->prepare('CREATE TABLE tmp (bla CLOB)');
$sth->execute() or die 'CREATE TABLE failed: ' . $dbh->err . ', ' . $dbh->errstr;

# this works just fine
$sth = $dbh->prepare_cached('INSERT INTO tmp VALUES (?)');
my @bind_values = ('A' x 65536);
$sth->execute(@bind_values) or die 'Insert failed: ' . $dbh->err . ', ' . $dbh->errstr;

# this fails with ORA-01480
$sth = $dbh->prepare_cached('INSERT INTO tmp VALUES (?)');
@bind_values = ('A' x 65537);
$sth->execute(@bind_values) or die 'Insert failed: ' . $dbh->err . ', ' . $dbh->errstr;

For what it's worth, here's some info on the Oracle instance I am using:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Thanks for your help,
Best regards,
  Alex
-- 
Dipl.-Math. Alexander Klink | IT-Security Engineer
        ak-...@cy... | working @ urn:oid:1.3.6.1.4.1.11417

Re: [Sqlrelay-discussion] ORA-01480 with long CLOBs?

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

Hey Alexander,

Sorry for the delay, I've been really busy and a little sick for the
past couple of weeks.

If you could send me some example code then I'm sure I can track down
the problem.

Some oracle lob functions take the number of characters rather than
bytes for some operations, and if the string contains unicode, then they
aren't always the same.  I have fixed a couple of bugs like that in the
past, so it might be something like that.

Dave
dav...@fi...

On Mon, 2007-11-05 at 13:08 +0100, Alexander Klink wrote:
> Hi David,
> 
> >> A quick fix is to edit src/connection/sqlrcursor/binds.C and around line
> >> 51, change:
> >>
> >> 		inbindvars[i].valuesize,
> >>
> >> to:
> >>
> >> 		inbindvars[i].valuesize+1,
> >>
> >> Then rebuild/reinstall.
> >>
> >> Give that a try and let me know if it fixes the problem or not.
> > Unfortunately, that did not help :-( Any other ideas?
> 
> Just checking whether you have any other ideas for solving this problem.
> I am happy to help debugging it as we would really like to use sqlrelay
> in our project ...
> 
> Best regards,
>   Alex
> 

Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

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

Hey Ingmar,

Sorry for the delayed response (and to others as well), I've been very,
very busy for the past few weeks, and was sick for a little while too.

But, yes, using your code I was recently able to track down the problem
and I think I have a solution for it.  An sqlr-connection-oracle8
process was crashing each time the script would run.  New ones might be
spawned to take the place of the crashed one, but the crash caused the
connection counter to miscount.

A quick fix is to edit src/connection/sqlrconnection/handlequery.C, go
to line 137 and change:

cursor->cleanUpData(false,true);

to:

cursor->cleanUpData(true,true);

If you trace down what would happen with "false,true", some column
definition pointers could be stale on the second iteration and when they
finally got around to being freed later, who knows what they were
pointing to.  This is the kind of bug that might not fail with a
different usage pattern, or might fail with certain versions of Oracle
but not others.

The only problem is that I can't remember why I wrote the code to use
"false,true" parameters in the first place.  It doesn't make any obvious
sense to me now, but clearly I intended to do it that way.  So either I
made a mistake before or I'm just not thinking correctly about it now.

At any rate, give it a try, let me know how it goes

Dave
dav...@fi...

On Wed, 2007-10-24 at 18:02 +0200, Ingmar Brouns wrote:
> 
> 
> Hi Dave,
> 
> I was just curious whether you've succeeded in reproducing the bug.
> 
> 
> Friendly greetings,
> 
> Ingmar
> 
> -------------------------------------------------------------------------
> 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] ORA-01480 with long CLOBs?

[Alexander K. <ak-...@cy...>]

Hi David,

>> A quick fix is to edit src/connection/sqlrcursor/binds.C and around line
>> 51, change:
>>
>> 		inbindvars[i].valuesize,
>>
>> to:
>>
>> 		inbindvars[i].valuesize+1,
>>
>> Then rebuild/reinstall.
>>
>> Give that a try and let me know if it fixes the problem or not.
> Unfortunately, that did not help :-( Any other ideas?

Just checking whether you have any other ideas for solving this problem.
I am happy to help debugging it as we would really like to use sqlrelay
in our project ...

Best regards,
  Alex

Re: [Sqlrelay-discussion] Bug report, open client connections not freed, with code to reproduce problem

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

Hi Dave,

I was just curious whether you've succeeded in reproducing the bug.


Friendly greetings,

Ingmar

Re: [Sqlrelay-discussion] DBD Borkenpipe

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

I believe the issue is that you're aiming the script at mysql rather
than at sqlrelay.

MySQL listens on port 3307.  SQL Relay connects to mysql and listens on
whatever port you configure it to listen on in your sqlrelay.conf file's
port parameter; usually 9000 or similar.  So your script would need to
connect to that port:

$dbh=DBI->connect("dbi:SQLRelay:host=127.0.0.1;port=9000;debug=1","user","password") or die DBI->errstr;

I think you're connecting to mysql and sending it sqlrelay commands,
which confuse it and eventually mysql closes the connection.

David Muse
dav...@fi...

On Wed, 2007-10-17 at 11:24 +0200, nemux wrote:
> Hello all,
> 
> i'm trying to do some tests with sqlrelay i'm doing that on :
> 
> FreeBSD 4.2 
> mysql client 3
> Mysql server 5.1
> sqlrelay-0.35_1 (installed from ports)
> 
> sqlrelay starts without problems but when i use this simple perl
> script :
> 
> #!/usr/bin/perl
> use DBI;
> 
> $dbh=DBI->connect("dbi:SQLRelay:host=127.0.0.1;port=3307;debug=1","user","password") or die DBI->errstr;
> 
> $dbh->disconnect;
> 
> #perl test.pl
> Connecting to listener...
> Inet socket: 127.0.0.1:3307
> Authenticating with listener : user:password
> No authentication error.
> Must Not Reconnect.
> Authenticating with connection : user:password
> Broken pipe
> #
> 
> I have the same error bypassing DBD using SQLRelay.pm  :
> 
> $con=SQLRelay::Connection->new("127.0.0.1","3307","","user","password",0,1);
> $cur=SQLRelay::Cursor->new($con);
> 
> $con->ping();
> 
> #perl testSQLRelay.pl
> Broken pipe
> #
> 
> i use DBI::mysql on the same server without issues 
> 
> Someone know how can i solve this issue ?
> 
> Thanks.
> 
> 
> -------------------------------------------------------------------------
> 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

Re: [Sqlrelay-discussion] Failed to get a cursor id!

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

What version of SQL Relay are you using?  I can't find it in the
changelog, but I remember fixing a bug recently that would return
"failed to get a cursor id" under the wrong circumstances.  I believe
that the most current version fixes the issue.

Dave
dav...@fi...

On Fri, 2007-10-19 at 09:19 +0800, jzhang wrote:
> Hi!
> I use mysql replication and sqlrelay for load banlancing. My symfony
> program got some error:
> ONE:[DBException]Failed to get a cursor id. A network error may have
> ocurred. Success stack trace
> TWO:[DBException] stack trace
> the hint followed them were the same. Just as follows:
> [DBException]
> stack trace
> at ()
> in SF_ROOT_DIR/lib/db.class.php line 370 ...
>  
> 367    if(!sqlrcur_executeQuery($sqlrcursor->cursor))
> 368    {
> 369      $this->errmessage =
> sqlrcur_errorMessage($sqlrcursor->cursor);
> 370      throw new DBException( $this->errmessage );
> 371    }
> 372    //sqlrcon_endSession($this->con);
> 373    return $sqlrcursor;
> at DB->execute(object('DB_sqlrelay_cursor'))
> in
> SF_ROOT_DIR/apps/frontend/modules/manage/actions/listMySuppliersAction.class.php line 16 ...
>  
>         //p_numPerPage int 
>         $db->setString($smst, '3',
> sfConfig::get('app_listMySuppliers') ); 
>          
>     $result = $db->execute($smst); 
>  
>         $suppliers=array(); 
>       while($row=$db->fetchAssoc($result)) { 
> at listMySuppliersAction->execute()
> in SF_SYMFONY_LIB_DIR/filter/sfExecutionFilter.class.php line 115 ...
>  
> 
>           // execute the action
>           $actionInstance->preExecute();
>           $viewName = $actionInstance->execute();
>           if ($viewName == '')
>           {
>             $viewName = sfView::SUCCESS;
> at sfExecutionFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_SYMFONY_LIB_DIR/filter/sfFlashFilter.class.php line 50 ...
>  
>     }
>  
>     // execute next filter
>     $filterChain->execute();
>  
>     // remove flash that are tagged to be removed
>     $names = $userAttributeHolder->getNames('symfony/flash/remove');
> at sfFlashFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_SYMFONY_LIB_DIR/filter/sfCommonFilter.class.php line 29 ...
>  
>   public function execute($filterChain)
>   {
>     // execute next filter
>     $filterChain->execute();
>  
>     // execute this filter only once
>     $response = $this->getContext()->getResponse();
> at sfCommonFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_ROOT_DIR/apps/frontend/lib/filter/navigatorFilter.class.php line
> 84 ...
>  
>         //var_dump($this->getContext());
>         $this->getContext()->getRequest()->setParameter('navigator',
> $navigator);
>         $this->getContext()->getRequest()->setParameter('menu',$menu);
>     $filterChain->execute();
>   }
> } 
> at navigatorFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in
> SF_ROOT_DIR/apps/frontend/lib/filter/myBasicSecurityFilter.class.php
> line 106 ...
>  
>       if ($credential === null || $user->hasCredential($credential))
>       {
>         // the user has access, continue
>         $filterChain->execute();
>       }
>       else
>       {
> at myBasicSecurityFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_SYMFONY_LIB_DIR/filter/sfWebDebugFilter.class.php line 35 ...
>  
>     }
>  
>     // execute next filter
>     $filterChain->execute();
>  
>     $context    = $this->getContext();
>     $response   = $context->getResponse();
> at sfWebDebugFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_SYMFONY_LIB_DIR/filter/sfRenderingFilter.class.php line 33 ...
>  
>   public function execute($filterChain)
>   {
>     // execute next filter
>     $filterChain->execute();
>  
>     if (sfConfig::get('sf_logging_enabled'))
>     {
> at sfRenderingFilter->execute(object('sfFilterChain'))
> in SF_SYMFONY_LIB_DIR/filter/sfFilterChain.class.php line 43 ...
>  
>       }
>  
>       // execute the next filter
>       $this->chain[$this->index]->execute($this);
>     }
>   }
>  
> at sfFilterChain->execute()
> in SF_SYMFONY_LIB_DIR/controller/sfController.class.php line 276 ...
>  
>         }
>  
>         // process the filter chain
>         $filterChain->execute();
>       }
>       else
>       {
> at sfController->forward('manage', 'listMySuppliers')
> in SF_SYMFONY_LIB_DIR/controller/sfFrontWebController.class.php line
> 48 ...
>  
>       $actionName = $request->getParameter('action');
>  
>       // make the first request
>       $this->forward($moduleName, $actionName);
>     }
>     catch (sfException $e)
>     {
> at sfFrontWebController->dispatch()
> in SF_ROOT_DIR/web/frontend/frontend_dev.php line 11 ...
>  
> 
> require_once(SF_ROOT_DIR.DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.SF_APP.DIRECTORY_SEPARATOR.'config'.DIRECTORY_SEPARATOR.'config.php');
>  
> sfContext::getInstance()->getController()->dispatch();
>  
> "SF_ROOT_DIR/lib/db.class.php" is a packaging program in order to
> supply a interface to sqlrelay for other programs . The error one
> comes out more often than error tow. I think the error one is brought
> by error two. If i use the router instance tranmit to the connection
> instance , the errors come often; if i get rid of router instance ,the
> errors gone. 
> This afternoon i debugged, results are as follows:
>  
> debugging from router instance:
> query:
> call sp_getMySuppliers(?,?,?,@totalCount,@totalPages,@currentPage)
> getting query succeeded
> getting input binds...
> :1
> STRING
> 75
> :2
> INTEGER
> 1
> :3
> INTEGER
> 5
> done getting input binds
> getting output binds...
> done getting output binds
> getting send column info...
> 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 succeeded
> done processing query
>  
>      debugging from connect instance:
>  
> query:
> call sp_getMySuppliers(?,?,?,@totalCount,@totalPages,@currentPage)
> getting query succeeded
> getting input binds...
> :1
> STRING
> 75
> :2
> INTEGER
> 1
> :3
> INTEGER
> 5
> done getting input binds
> getting output binds...
> done getting output binds
> getting send column info...
> 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 succeeded
> done processing query
> returning result set header...
> returning row counts...
> sending row counts...
> actual rows: 3
> affected rows: -1
> 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...
> supplierID:2:4 (10,0) NOT NULL Primary key 
> supplierInfoStateID:4:1 (1,0) NOT NULL 
> dataInputTypeID:4:1 (2,0) NOT NULL 
> branchEmployeeID:3:2 (5,0) 
> memberID:55:8 (15,0) 
> spiderSourceID:2:4 (10,0) 
> processDate:6:8 (19,0) NOT NULL 
> businessScope:1:763 (762,0) NOT NULL 
> description:44:16777215 (196605,0) NOT NULL 
> annualSales:1:61 (60,0) 
> contactID:55:8 (15,0) NOT NULL 
> dialCount:2:4 (10,0) NOT NULL 
> url:1:451 (450,0) 
> supplierType:34:3 (3,0) NOT NULL 
> supplierScore:15:4 (3,1) NOT NULL 
> pageStyle:4:1 (3,0) NOT NULL 
> hasPojaaPage:4:1 (1,0) 
> pojaaURL:1:451 (450,0) 
> profileLastUpdate:6:8 (19,0) NOT NULL 
> viewCounter:55:8 (20,0) NOT NULL 
> bookmarkCounts:2:4 (10,0) NOT NULL 
> submitIPAddress:1:121 (120,0) 
> enterpriseTypeID:4:1 (2,0) NOT NULL 
> companyName:1:301 (300,0) NOT NULL 
> companyNameAlias1:1:91 (90,0) 
> branchCompanyName:1:91 (90,0) 
> SFranchiseID:2:4 (10,0) 
> sub4industryCode:34:15 (15,0) 
> dateEstablished:6:8 (19,0) NOT NULL 
> registeredCapital:14:8 (22,31) 
> CurrencyTypeID:4:1 (3,0) 
> incorporationPlace:1:61 (60,0) 
> focusMarkets:1:751 (750,0) 
> CEO_President:1:61 (60,0) 
> chairman:1:61 (60,0) 
> annualExportUSD:1:61 (60,0) 
> numRDStaff:1:61 (60,0) 
> numStaff:1:61 (60,0) 
> OEMService:4:1 (1,0) NOT NULL 
> AuthorizedMemberID:55:8 (15,0) NOT NULL 
> ForeignSupplierCode:34:42 (42,0) 
> ChineseInvestor1:1:301 (300,0) 
> ForeignInvestor1:1:301 (300,0) 
> FI_NationID:4:1 (3,0) NOT NULL 
> numForeignStaff:1:61 (60,0) 
> majorCustomers:1:751 (750,0) 
> targetCustomers:1:751 (750,0) 
> sub3CategoryID:3:2 (5,0) NOT NULL 
> sub4CategoryID:3:2 (5,0) NOT NULL 
> done returning column info
> returning output bind values
> 0
> done returning output bind values
> done returning result set header
> handle query succeeded
> returning result set data...
> skipping 0 rows...
> done skipping rows
> fetching 10 rows...
> "384","3","1","0","75","0","2007-10-17
> 21:21:19","shop1111","shop1111","0","578","0","","E","0.0","0","0",NULL"2007-10-18 16:14:11","0","0","192.168.1.17","0","shop1111","","","0",NULL"0000-00-00 00:00:00","0","0","","","","","","","","0","0",NULL"","","1","","","","10020","50086",
> "383","3","1","0","75","0","2007-10-17
> 21:10:27","shop2222","shop2222","0","573","0","","E","0.0","0","0",NULL"2007-10-18 16:14:29","1","0","192.168.1.17","0","shop2222","","","0",NULL"0000-00-00 00:00:00","0","0","","","","","","","","0","0",NULL"","","1","","","","10010","50032",
> "381","3","1","0","75","0","2007-10-17
> 20:29:20","shop3333","shop3333","0","533","0","","E","0.0","0","0",NULL"2007-10-18 16:14:48","0","0","192.168.1.17","0","shop3333","","","0",NULL"0000-00-00 00:00:00","0","0","","","","","","","","0","0",NULL"","","1","","","","10025","50104",
> done returning result set data
> getting command...
> done getting command
> identify
> getting command...
> getting command failed: client sent bad command or timed out
> end session
> ending session...
> aborting all busy cursors...
>  
> 
> ______________________________________________________________________
> jzhang
> 2007-10-19
> -------------------------------------------------------------------------
> 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