sqlrelay-discussion Mailing List for SQL Relay (Page 47)
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion — Discussion of topics related to SQL Relay
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(20) |
Mar
(27) |
Apr
(17) |
May
(32) |
Jun
(45) |
Jul
(49) |
Aug
(68) |
Sep
(44) |
Oct
(29) |
Nov
(64) |
Dec
(25) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(61) |
Feb
(22) |
Mar
(25) |
Apr
(31) |
May
(18) |
Jun
(28) |
Jul
(19) |
Aug
(16) |
Sep
(8) |
Oct
(17) |
Nov
(32) |
Dec
(4) |
| 2007 |
Jan
(20) |
Feb
(25) |
Mar
(5) |
Apr
(12) |
May
(11) |
Jun
(18) |
Jul
(16) |
Aug
(22) |
Sep
(37) |
Oct
(20) |
Nov
(11) |
Dec
(2) |
| 2008 |
Jan
(11) |
Feb
(33) |
Mar
(12) |
Apr
(18) |
May
(22) |
Jun
(31) |
Jul
(23) |
Aug
(6) |
Sep
|
Oct
(10) |
Nov
(22) |
Dec
|
| 2009 |
Jan
(12) |
Feb
(8) |
Mar
(11) |
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(27) |
Aug
(2) |
Sep
(10) |
Oct
(5) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(11) |
Feb
(18) |
Mar
(10) |
Apr
(28) |
May
(28) |
Jun
|
Jul
(27) |
Aug
(9) |
Sep
(21) |
Oct
(2) |
Nov
(2) |
Dec
(11) |
| 2011 |
Jan
|
Feb
(2) |
Mar
(4) |
Apr
(2) |
May
(2) |
Jun
(44) |
Jul
(9) |
Aug
(2) |
Sep
(12) |
Oct
(7) |
Nov
(11) |
Dec
(7) |
| 2012 |
Jan
(5) |
Feb
|
Mar
(9) |
Apr
(9) |
May
(12) |
Jun
|
Jul
(13) |
Aug
(3) |
Sep
(3) |
Oct
(1) |
Nov
(1) |
Dec
(10) |
| 2013 |
Jan
(21) |
Feb
(3) |
Mar
(4) |
Apr
|
May
(3) |
Jun
(2) |
Jul
(3) |
Aug
(3) |
Sep
(3) |
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(7) |
Feb
|
Mar
(1) |
Apr
|
May
(2) |
Jun
|
Jul
(4) |
Aug
(2) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: David M. <dav...@fi...> - 2006-01-23 16:41:44
|
My apologies. I did get your last email, but it got lost in my cluttered inbox. I just responded to it. In the future, if we have a thread going, and I fail to respond, feel free to send an email to me directly, or send a "hey dave! answer my question!" to the group :) Dave dav...@fi... On Thu, 2006-01-19 at 09:31 -0200, Rodrigo P. Telles wrote: > Hi David, > > Did you get my last e-mail about that problem? > > Best regards, > -- > ============================================ > Rodrigo P. Telles <te...@de...> > IT Manager > Devel-IT - http://www.devel.it > IVOZ # 1029 > +55 14 3324-1200 > Bestcom Group > ============================================ > email message attachment (Re: [Sqlrelay-discussion] SQLRelay JAVA > exception) > On Thu, 2006-01-19 at 09:31 -0200, Rodrigo P. Telles wrote: > > Hi David, > > > > At last I think we (our team) found a cause of the exception! > > > > I think there was a misunderstood from my part in that answer (about > > "long queries"). > > I understood "long queries" as "long result sets" - and not the lenght > > of the queries - when in fact the queries has about 397-580 characters. > > I don't know if it's big enough to be considered "long" but it's the > > cause of the problem. If we changes that long queries to small ones > > (selecting or updating only 3 fields instead of 34) the problem go away > > and everything works fine. > > > > Problematic query: > > > > SELECT phplib_id, username, domain, password, first_name, last_name, > > phone, email_address, datetime_created, datetime_modified, confirmation, > > flag, sendnotification, greeting, ha1, ha1b, perms, allow_find, > > timezone, rpid, empresa, codInscricao, numInscricao, endereco, bairro, > > cep, cidade, estado, pais, listaPublica, sigame, temSigame, status, > > macAddress FROM subscriber WHERE username='2740' > > > > Solution query: > > > > SELECT phplib_id, username, first_name FROM subscriber WHERE username='2740' > > > > So as you said perhaps it's easy to patch. > > We'll test with how many fields the query starts to generate an exception. > > > > best regards, > > Telles > > > > Rodrigo P. Telles wrote: > > > > > Hi David, > > > > > > Firstworks/4access wrote: > > > > > > >Is it possible to reliably reproduce the problem with a particular > > > >query, or is it kind of random? > > > > > > > > > No it doesn't, it happens in a random fashion. Could happens twice in > > > a week or > > > once in a month. > > > > > > >Offhand, it looks like java is trying to run (or return from) a native > > > >C++ function and has the wrong address for the function (or wrong return > > > >address) and it ends up jumping off into the weeds, possibly into a > > > >non-executable page of memory. This typically happens when a buffer > > > >overrun occurs and overwrites a jump address. > > > > > > >Does this happen with really long queries? With > > > > > > > > > No it doesn't. > > > It happens in a simple query using INSERT or SELECT! > > > > > > >Java/Perl/PHP/Ruby/TCL/Python, SQL Relay makes a copy of the query. > > > >It's possible that there's some kind of bug where the SQL Relay client > > > >is copying too much data and overrunning it's buffer. If it's only long > > > >queries, that would make sense and should be easy to patch. > > > > > > >Let me know... > > > > > > > > > Let me know if I can do any thing to "collect" more informations about > > > that problem. > > > Thanks for your answer. > > > > > > Telles > > > > > > >David Muse > > > >dav...@fi... > > > > > > >On Fri, 2005-11-11 at 17:48 -0200, Rodrigo P. Telles wrote: > > > > > > >Hi Guys, > > > > > > >I've been experiencing some errors using JAVA with sqlrelay-0.35 API > > > and MySQL > > > >4.1.7 as a DB backend. > > > > > > >Some thimes when I'm doing a query the application failed with that > > > output > > > >exception: > > > >---------------------------------------------------------------------------------- > > > >An unexpected exception has been detected in native code outside the VM. > > > >Unexpected Signal : 11 occurred at PC=0x400C6C48 > > > >Function=(null)+0x400C6C48 > > > >Library=/lib/libc.so.6 > > > > > > >NOTE: We are unable to locate the function name symbol for the error > > > > just occurred. Please refer to release documentation for possible > > > > reason and solutions. > > > > > > > > > >Current Java thread: > > > > at com.firstworks.sqlrelay.SQLRCursor.prepareQuery(Native Method) > > > > at it.devel.Dao.getBean(Dao.java:185) > > > > at > > > it.devel.wiser.TerminadorDAO.calculaMinutagem(TerminadorDAO.java:131) > > > > at it.devel.Bilhetagem.getTempoCorrigido(Bilhetagem.java:342) > > > > at it.devel.Bilhetagem.bilhetaTerminador(Bilhetagem.java:320) > > > > at it.devel.Bilhetagem.bilhetar(Bilhetagem.java:141) > > > > at it.devel.Bilhetagem.main(Bilhetagem.java:693) > > > > > > >Dynamic libraries: > > > >08048000-08056000 r-xp 00000000 08:06 246208 > > > /usr/local/j2sdk1.4.2_06/bin/java > > > >08056000-08059000 rwxp 0000d000 08:06 246208 > > > /usr/local/j2sdk1.4.2_06/bin/java > > > >40000000-40011000 r-xp 00000000 08:05 212994 /lib/ld-2.3.3.so > > > >40011000-40012000 rwxp 00011000 08:05 212994 /lib/ld-2.3.3.so > > > >40018000-40026000 r-xp 00000000 08:05 213024 /lib/libpthread-0.10.so > > > >40026000-40028000 rwxp 0000d000 08:05 213024 /lib/libpthread-0.10.so > > > >4006a000-4006c000 r-xp 00000000 08:05 213005 /lib/libdl-2.3.3.so > > > >4006c000-4006d000 rwxp 00001000 08:05 213005 /lib/libdl-2.3.3.so > > > >4006d000-40167000 r-xp 00000000 08:05 213001 /lib/libc-2.3.3.so > > > >40167000-40170000 rwxp 000fa000 08:05 213001 /lib/libc-2.3.3.so > > > >40173000-4056f000 r-xp 00000000 08:06 134540 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > > > >4056f000-4058b000 rwxp 003fb000 08:06 134540 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > > > >405a2000-405b1000 r-xp 00000000 08:05 213009 /lib/libnsl-2.3.3.so > > > >405b1000-405b2000 rwxp 0000f000 08:05 213009 /lib/libnsl-2.3.3.so > > > >405b4000-405d4000 r-xp 00000000 08:05 213007 /lib/libm-2.3.3.so > > > >405d4000-405d5000 rwxp 0001f000 08:05 213007 /lib/libm-2.3.3.so > > > >405d5000-405dd000 r-xp 00000000 08:06 101710 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > > > >405dd000-405de000 rwxp 00007000 08:06 101710 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > > > >405de000-405e2000 rwxs 00000000 08:09 14628 > > > /tmp/hsperfdata_callstart/19866 > > > >405e3000-405ec000 r-xp 00000000 08:05 213015 > > > /lib/libnss_files-2.3.3.so > > > >405ec000-405ed000 rwxp 00009000 08:05 213015 > > > /lib/libnss_files-2.3.3.so > > > >405ed000-405fd000 r-xp 00000000 08:06 101717 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > > > >405fd000-405ff000 rwxp 0000f000 08:06 101717 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > > > >405ff000-4061f000 r-xp 00000000 08:06 101718 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > > > >4061f000-40621000 rwxp 0001f000 08:06 101718 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > > > >40621000-40635000 r-xp 00000000 08:06 101720 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > > > >40635000-40638000 rwxp 00013000 08:06 101720 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > > > >40638000-41fdf000 r-xs 00000000 08:06 101803 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/rt.jar > > > >42029000-4203f000 r-xs 00000000 08:06 101742 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/sunrsasign.jar > > > >4203f000-4211c000 r-xs 00000000 08:06 101787 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/jsse.jar > > > >4211c000-4212d000 r-xs 00000000 08:06 101743 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/jce.jar > > > >4212d000-42686000 r-xs 00000000 08:06 101788 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/charsets.jar > > > >4472e000-4472f000 r-xs 00000000 08:06 117021 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/Itau.jar > > > >4c7b0000-4c7cc000 r-xs 00000000 08:06 117679 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/sunjce_provider.jar > > > >4c7cc000-4c7cf000 r-xs 00000000 08:06 117680 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/dnsns.jar > > > >4c7cf000-4c7dc000 r-xs 00000000 08:06 117682 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/ldapsec.jar > > > >4c7dc000-4c898000 r-xs 00000000 08:06 117684 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/localedata.jar > > > >4c898000-4c8a6000 r-xs 00000000 08:06 117022 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/activation.jar > > > >4c8a6000-4c8d3000 r-xs 00000000 08:06 117023 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/mailapi.jar > > > >4c8d3000-4c92a000 r-xs 00000000 08:06 117024 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/mail.jar > > > >4c92a000-4c930000 r-xs 00000000 08:06 117025 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/pop3.jar > > > >4c930000-4c936000 r-xs 00000000 08:06 117026 > > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/smtp.jar > > > >4c936000-4c939000 r-xp 00000000 08:06 377923 > > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > > > >4c939000-4c93a000 rwxp 00002000 08:06 377923 > > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > > > >4c93a000-4c950000 r-xp 00000000 08:06 265533 > > > >/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > > > >4c950000-4c953000 rwxp 00015000 08:06 265533 > > > >/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > > > >4c953000-4c998000 r-xp 00000000 08:06 377564 > > > >/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > > > >4c998000-4c9a2000 rwxp 00044000 08:06 377564 > > > >/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > > > >4c9a7000-4c9d2000 r-xp 00000000 08:06 115308 /usr/lib/libssl.so.0.9.7 > > > >4c9d2000-4c9d5000 rwxp 0002a000 08:06 115308 /usr/lib/libssl.so.0.9.7 > > > >4c9d5000-4caab000 r-xp 00000000 08:06 115306 > > > /usr/lib/libcrypto.so.0.9.7 > > > >4caab000-4cabc000 rwxp 000d6000 08:06 115306 > > > /usr/lib/libcrypto.so.0.9.7 > > > >4cac0000-4cac4000 r-xp 00000000 08:05 213003 /lib/libcrypt-2.3.3.so > > > >4cac4000-4cac5000 rwxp 00003000 08:05 213003 /lib/libcrypt-2.3.3.so > > > >4caec000-4cb8a000 r-xp 00000000 08:06 114711 > > > /usr/lib/libstdc++.so.5.0.5 > > > >4cb8a000-4cba0000 rwxp 0009d000 08:06 114711 > > > /usr/lib/libstdc++.so.5.0.5 > > > >4cba5000-4cbac000 r-xp 00000000 08:06 114701 /usr/lib/libgcc_s.so.1 > > > >4cbac000-4cbad000 rwxp 00006000 08:06 114701 /usr/lib/libgcc_s.so.1 > > > >4cbad000-4cbb7000 r-xp 00000000 08:06 377924 > > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > > >4cbb7000-4cbb9000 rwxp 0000a000 08:06 377924 > > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > > > > > >Heap at VM Abort: > > > >Heap > > > > def new generation total 576K, used 236K [0x44730000, 0x447d0000, > > > 0x44c10000) > > > > eden space 512K, 43% used [0x44730000, 0x44767248, 0x447b0000) > > > > from space 64K, 24% used [0x447b0000, 0x447b3fa8, 0x447c0000) > > > > to space 64K, 0% used [0x447c0000, 0x447c0000, 0x447d0000) > > > > tenured generation total 1408K, used 339K [0x44c10000, 0x44d70000, > > > 0x48730000) > > > > the space 1408K, 24% used [0x44c10000, 0x44c64f58, 0x44c65000, > > > 0x44d70000) > > > > compacting perm gen total 4096K, used 1696K [0x48730000, > > > 0x48b30000, 0x4c730000) > > > > the space 4096K, 41% used [0x48730000, 0x488d8380, 0x488d8400, > > > 0x48b30000) > > > > > > >Local Time = Fri Nov 11 15:34:29 2005 > > > >Elapsed Time = 771 > > > ># > > > ># The exception above was detected in native code outside the VM > > > ># > > > ># Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode) > > > >- > > > >-------------------------------------------------------------------------------------------------------- > > > > > > >At the moment is not so easy for me to update to 0.36.x. > > > >Does some one can help with that problem? > > > > > > >Thanks in advance. > > > >-- > > > >============================================ > > > >Rodrigo P. Telles <te...@de...> > > > >IT Manager > > > >Devel-IT - http://www.devel.it > > > >IVOZ # 1029 > > > >+55 14 3324-1200 > > > >Bestcom Group > > > >============================================ > > > > > > > > > ------------------------------------------------------- > > > SF.Net email is sponsored by: > > > Tame your development challenges with Apache's Geronimo App Server. > > > Download > > > it for free - -and be entered to win a 42" plasma tv or your very own > > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > > _______________________________________________ > > > Sqlrelay-discussion mailing list > > > Sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > > > > > > > > > >------------------------------------------------------- > > > >This SF.Net email is sponsored by the JBoss Inc. Get Certified Today > > > >Register for a JBoss Training Course. Free Certification Exam > > > >for All Training Attendees Through End of 2005. For more info visit: > > > >http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click > > > >_______________________________________________ > > > >Sqlrelay-discussion mailing list > > > >Sql...@li... > > > >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > |
|
From: David M. <dav...@fi...> - 2006-01-23 16:38:33
|
Long queries should actually mean queries that are longer than 32k characters. A query with only 397 characters or so shouldn't cause a problem. I vaguely remember an issue like this though, and if it's what I remember, I think I fixed it in 0.36. Is it possible for you to upgrade SQL Relay to more current version? If so, try http://www.firstworks.com/sqlrelay-0.37pre5.tar.gz or sqlrelay-0.36.4 from the sqlrelay website and see if the problem still persists. If it does (or if you can't easily upgrade), then let me know and I'll see if I can get you some code with debug in it and we'll patch the version you're running now. Dave dav...@fi... On Wed, 2006-01-04 at 10:34 -0200, Rodrigo P. Telles wrote: > Hi David, > > At last I think we (our team) found a cause of the exception! > > I think there was a misunderstood from my part in that answer (about > "long queries"). > I understood "long queries" as "long result sets" - and not the lenght > of the queries - when in fact the queries has about 397-580 characters. > I don't know if it's big enough to be considered "long" but it's the > cause of the problem. If we changes that long queries to small ones > (selecting or updating only 3 fields instead of 34) the problem go away > and everything works fine. > > Problematic query: > > SELECT phplib_id, username, domain, password, first_name, last_name, > phone, email_address, datetime_created, datetime_modified, confirmation, > flag, sendnotification, greeting, ha1, ha1b, perms, allow_find, > timezone, rpid, empresa, codInscricao, numInscricao, endereco, bairro, > cep, cidade, estado, pais, listaPublica, sigame, temSigame, status, > macAddress FROM subscriber WHERE username='2740' > > Solution query: > > SELECT phplib_id, username, first_name FROM subscriber WHERE username='2740' > > So as you said perhaps it's easy to patch. > We'll test with how many fields the query starts to generate an exception. > > best regards, > Telles > > Rodrigo P. Telles wrote: > > > Hi David, > > > > Firstworks/4access wrote: > > > > >Is it possible to reliably reproduce the problem with a particular > > >query, or is it kind of random? > > > > > > No it doesn't, it happens in a random fashion. Could happens twice in > > a week or > > once in a month. > > > > >Offhand, it looks like java is trying to run (or return from) a native > > >C++ function and has the wrong address for the function (or wrong return > > >address) and it ends up jumping off into the weeds, possibly into a > > >non-executable page of memory. This typically happens when a buffer > > >overrun occurs and overwrites a jump address. > > > > >Does this happen with really long queries? With > > > > > > No it doesn't. > > It happens in a simple query using INSERT or SELECT! > > > > >Java/Perl/PHP/Ruby/TCL/Python, SQL Relay makes a copy of the query. > > >It's possible that there's some kind of bug where the SQL Relay client > > >is copying too much data and overrunning it's buffer. If it's only long > > >queries, that would make sense and should be easy to patch. > > > > >Let me know... > > > > > > Let me know if I can do any thing to "collect" more informations about > > that problem. > > Thanks for your answer. > > > > Telles > > > > >David Muse > > >dav...@fi... > > > > >On Fri, 2005-11-11 at 17:48 -0200, Rodrigo P. Telles wrote: > > > > >Hi Guys, > > > > >I've been experiencing some errors using JAVA with sqlrelay-0.35 API > > and MySQL > > >4.1.7 as a DB backend. > > > > >Some thimes when I'm doing a query the application failed with that > > output > > >exception: > > >---------------------------------------------------------------------------------- > > >An unexpected exception has been detected in native code outside the VM. > > >Unexpected Signal : 11 occurred at PC=0x400C6C48 > > >Function=(null)+0x400C6C48 > > >Library=/lib/libc.so.6 > > > > >NOTE: We are unable to locate the function name symbol for the error > > > just occurred. Please refer to release documentation for possible > > > reason and solutions. > > > > > > >Current Java thread: > > > at com.firstworks.sqlrelay.SQLRCursor.prepareQuery(Native Method) > > > at it.devel.Dao.getBean(Dao.java:185) > > > at > > it.devel.wiser.TerminadorDAO.calculaMinutagem(TerminadorDAO.java:131) > > > at it.devel.Bilhetagem.getTempoCorrigido(Bilhetagem.java:342) > > > at it.devel.Bilhetagem.bilhetaTerminador(Bilhetagem.java:320) > > > at it.devel.Bilhetagem.bilhetar(Bilhetagem.java:141) > > > at it.devel.Bilhetagem.main(Bilhetagem.java:693) > > > > >Dynamic libraries: > > >08048000-08056000 r-xp 00000000 08:06 246208 > > /usr/local/j2sdk1.4.2_06/bin/java > > >08056000-08059000 rwxp 0000d000 08:06 246208 > > /usr/local/j2sdk1.4.2_06/bin/java > > >40000000-40011000 r-xp 00000000 08:05 212994 /lib/ld-2.3.3.so > > >40011000-40012000 rwxp 00011000 08:05 212994 /lib/ld-2.3.3.so > > >40018000-40026000 r-xp 00000000 08:05 213024 /lib/libpthread-0.10.so > > >40026000-40028000 rwxp 0000d000 08:05 213024 /lib/libpthread-0.10.so > > >4006a000-4006c000 r-xp 00000000 08:05 213005 /lib/libdl-2.3.3.so > > >4006c000-4006d000 rwxp 00001000 08:05 213005 /lib/libdl-2.3.3.so > > >4006d000-40167000 r-xp 00000000 08:05 213001 /lib/libc-2.3.3.so > > >40167000-40170000 rwxp 000fa000 08:05 213001 /lib/libc-2.3.3.so > > >40173000-4056f000 r-xp 00000000 08:06 134540 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > > >4056f000-4058b000 rwxp 003fb000 08:06 134540 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > > >405a2000-405b1000 r-xp 00000000 08:05 213009 /lib/libnsl-2.3.3.so > > >405b1000-405b2000 rwxp 0000f000 08:05 213009 /lib/libnsl-2.3.3.so > > >405b4000-405d4000 r-xp 00000000 08:05 213007 /lib/libm-2.3.3.so > > >405d4000-405d5000 rwxp 0001f000 08:05 213007 /lib/libm-2.3.3.so > > >405d5000-405dd000 r-xp 00000000 08:06 101710 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > > >405dd000-405de000 rwxp 00007000 08:06 101710 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > > >405de000-405e2000 rwxs 00000000 08:09 14628 > > /tmp/hsperfdata_callstart/19866 > > >405e3000-405ec000 r-xp 00000000 08:05 213015 > > /lib/libnss_files-2.3.3.so > > >405ec000-405ed000 rwxp 00009000 08:05 213015 > > /lib/libnss_files-2.3.3.so > > >405ed000-405fd000 r-xp 00000000 08:06 101717 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > > >405fd000-405ff000 rwxp 0000f000 08:06 101717 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > > >405ff000-4061f000 r-xp 00000000 08:06 101718 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > > >4061f000-40621000 rwxp 0001f000 08:06 101718 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > > >40621000-40635000 r-xp 00000000 08:06 101720 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > > >40635000-40638000 rwxp 00013000 08:06 101720 > > >/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > > >40638000-41fdf000 r-xs 00000000 08:06 101803 > > >/usr/local/j2sdk1.4.2_06/jre/lib/rt.jar > > >42029000-4203f000 r-xs 00000000 08:06 101742 > > >/usr/local/j2sdk1.4.2_06/jre/lib/sunrsasign.jar > > >4203f000-4211c000 r-xs 00000000 08:06 101787 > > >/usr/local/j2sdk1.4.2_06/jre/lib/jsse.jar > > >4211c000-4212d000 r-xs 00000000 08:06 101743 > > >/usr/local/j2sdk1.4.2_06/jre/lib/jce.jar > > >4212d000-42686000 r-xs 00000000 08:06 101788 > > >/usr/local/j2sdk1.4.2_06/jre/lib/charsets.jar > > >4472e000-4472f000 r-xs 00000000 08:06 117021 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/Itau.jar > > >4c7b0000-4c7cc000 r-xs 00000000 08:06 117679 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/sunjce_provider.jar > > >4c7cc000-4c7cf000 r-xs 00000000 08:06 117680 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/dnsns.jar > > >4c7cf000-4c7dc000 r-xs 00000000 08:06 117682 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/ldapsec.jar > > >4c7dc000-4c898000 r-xs 00000000 08:06 117684 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/localedata.jar > > >4c898000-4c8a6000 r-xs 00000000 08:06 117022 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/activation.jar > > >4c8a6000-4c8d3000 r-xs 00000000 08:06 117023 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/mailapi.jar > > >4c8d3000-4c92a000 r-xs 00000000 08:06 117024 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/mail.jar > > >4c92a000-4c930000 r-xs 00000000 08:06 117025 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/pop3.jar > > >4c930000-4c936000 r-xs 00000000 08:06 117026 > > >/usr/local/j2sdk1.4.2_06/jre/lib/ext/smtp.jar > > >4c936000-4c939000 r-xp 00000000 08:06 377923 > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > > >4c939000-4c93a000 rwxp 00002000 08:06 377923 > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > > >4c93a000-4c950000 r-xp 00000000 08:06 265533 > > >/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > > >4c950000-4c953000 rwxp 00015000 08:06 265533 > > >/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > > >4c953000-4c998000 r-xp 00000000 08:06 377564 > > >/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > > >4c998000-4c9a2000 rwxp 00044000 08:06 377564 > > >/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > > >4c9a7000-4c9d2000 r-xp 00000000 08:06 115308 /usr/lib/libssl.so.0.9.7 > > >4c9d2000-4c9d5000 rwxp 0002a000 08:06 115308 /usr/lib/libssl.so.0.9.7 > > >4c9d5000-4caab000 r-xp 00000000 08:06 115306 > > /usr/lib/libcrypto.so.0.9.7 > > >4caab000-4cabc000 rwxp 000d6000 08:06 115306 > > /usr/lib/libcrypto.so.0.9.7 > > >4cac0000-4cac4000 r-xp 00000000 08:05 213003 /lib/libcrypt-2.3.3.so > > >4cac4000-4cac5000 rwxp 00003000 08:05 213003 /lib/libcrypt-2.3.3.so > > >4caec000-4cb8a000 r-xp 00000000 08:06 114711 > > /usr/lib/libstdc++.so.5.0.5 > > >4cb8a000-4cba0000 rwxp 0009d000 08:06 114711 > > /usr/lib/libstdc++.so.5.0.5 > > >4cba5000-4cbac000 r-xp 00000000 08:06 114701 /usr/lib/libgcc_s.so.1 > > >4cbac000-4cbad000 rwxp 00006000 08:06 114701 /usr/lib/libgcc_s.so.1 > > >4cbad000-4cbb7000 r-xp 00000000 08:06 377924 > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > >4cbb7000-4cbb9000 rwxp 0000a000 08:06 377924 > > >/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > > > >Heap at VM Abort: > > >Heap > > > def new generation total 576K, used 236K [0x44730000, 0x447d0000, > > 0x44c10000) > > > eden space 512K, 43% used [0x44730000, 0x44767248, 0x447b0000) > > > from space 64K, 24% used [0x447b0000, 0x447b3fa8, 0x447c0000) > > > to space 64K, 0% used [0x447c0000, 0x447c0000, 0x447d0000) > > > tenured generation total 1408K, used 339K [0x44c10000, 0x44d70000, > > 0x48730000) > > > the space 1408K, 24% used [0x44c10000, 0x44c64f58, 0x44c65000, > > 0x44d70000) > > > compacting perm gen total 4096K, used 1696K [0x48730000, > > 0x48b30000, 0x4c730000) > > > the space 4096K, 41% used [0x48730000, 0x488d8380, 0x488d8400, > > 0x48b30000) > > > > >Local Time = Fri Nov 11 15:34:29 2005 > > >Elapsed Time = 771 > > ># > > ># The exception above was detected in native code outside the VM > > ># > > ># Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode) > > >- > > >-------------------------------------------------------------------------------------------------------- > > > > >At the moment is not so easy for me to update to 0.36.x. > > >Does some one can help with that problem? > > > > >Thanks in advance. > > >-- > > >============================================ > > >Rodrigo P. Telles <te...@de...> > > >IT Manager > > >Devel-IT - http://www.devel.it > > >IVOZ # 1029 > > >+55 14 3324-1200 > > >Bestcom Group > > >============================================ > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. > > Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > > > >------------------------------------------------------- > > >This SF.Net email is sponsored by the JBoss Inc. Get Certified Today > > >Register for a JBoss Training Course. Free Certification Exam > > >for All Training Attendees Through End of 2005. For more info visit: > > >http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click > > >_______________________________________________ > > >Sqlrelay-discussion mailing list > > >Sql...@li... > > >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > |
|
From: David M. <dav...@fi...> - 2006-01-23 16:29:35
|
Are you sure ping() returns false even when the database has come back up? I just tested it and it works for me: [mused@localhost ~]$ sqlr-start -id mysqltest Starting listener: sqlr-listener -id mysqltest -config /usr/local/firstworks/etc/sqlrelay.conf Warning: could not change group to nobody Warning: could not change user to nobody Starting 1 connections to db : sqlr-connection-mysql -id mysqltest -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf Warning: could not change group to nobody Warning: could not change user to nobody Starting cache manager: sqlr-cachemanager Warning: using default id. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. [mused@localhost ~]$ sqlrsh -id mysqltest SQLRShell - Version 0.22 Connected to: localhost:8006 as mysqltest type help; for a help. 0> select * from testtable; col1 ==== 1 Rows Returned : 1 Fields Returned : 1 System time : 20000 (here I shut the db down in another window) 0> ping; The database is down. (here I brought it back up) 0> ping; The database is up. 0> select * from testtable; col1 ==== 1 Rows Returned : 1 Fields Returned : 1 System time : 20000 0> quit 1> ; I tried a couple of other combinations, but ping() appears to work properly to me, at least with MySQL. Dave dav...@fi... On Fri, 2006-01-20 at 16:10 +0600, Kumara S wrote: > Hi, > > We are develpoping a web application that connects to MySQL thru > sqlrelay... > > We thought of using PHP pear DB classes to abstract the > database. My requirement is to connect to the database server and check > if it can handle further queries successfully. When the MySQL server > goes down, sqlrelay sendQuery() keeps retrying infinitely and returns > only after the DB comes up. Since i can't allow my page to wait till > everything becomes normal, i thought of using ping() to check the status > of MySQL before querying. but, even when the DB recovers later, ping() > returns false. Following ealier discussions with Maciej Wisniowski, > ping() just gives the status of the connection that went to CLOSE_WAIT > state and does not attempt to reconnect to DB. It is only the first > sendQuery that reconnects. > > So, using ping() before sendQuery() does > not allow my application to recover even when MySQL is up. > Calling > sendQuery() directly sends my application to infinite loop in case of DB > failure. > > The problem is simple. Connect to DB when it is available in > a single try, return false in case of a DB failure. API calls like > mysql_connect gives me just that. but, sqlrelay either gives me infinite > retries(when DB goes down) or no try at all (when it > recovers). > > Please give me a workaround. > > Thanks! > > Kumara > Sundaram > |
|
From: David M. <dav...@fi...> - 2006-01-23 16:03:00
|
Maciej, I think I see what's causing that. It looks like NewObjectArray() returns jarray instead of jobjectArray and it has to be explcitly cast. I just fixed that and uploaded 0.37pre5 to http://www.firstworks.com/sqlrelay-0.37pre5.tar.gz I'm getting really close to releasing 0.37. I've been testing it on all the platforms I have access to and fixing platform-specific bugs, and it looks like I'll be done with that pretty soon. Thanks for finding that bug :) What version of java are you using? Dave dav...@fi... On Mon, 2006-01-23 at 12:27 +0100, Maciej Wisniowski wrote: > Hi >=20 > When trying to install SQLRelay 0.37pre4 I get error as below. The prob= lem > only appears when java is enabled. I've removed > /usr/local/firstworks folder before installation but the problem persis= ts. >=20 > com_firstworks_sqlrelay_SQLRCursor.C: In function `__jobjectArray* > Java_com_firstworks_sqlrelay_SQLRCursor_getRow(JNIEnv*, __jobject*, = long > long int)': > com_firstworks_sqlrelay_SQLRCursor.C:1172: invalid conversion from=20 > `__jarray*' > to `__jobjectArray*' > com_firstworks_sqlrelay_SQLRCursor.C: In function `__jobjectArray* > Java_com_firstworks_sqlrelay_SQLRCursor_getColumnNames(JNIEnv*, > __jobject*)': > com_firstworks_sqlrelay_SQLRCursor.C:1219: invalid conversion from=20 > `__jarray*' > to `__jobjectArray*' > make[3]: *** [com_firstworks_sqlrelay_SQLRCursor.lo] B=C5=82=C4=85d 1 > make[3]: Leaving folder=20 > `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37/src/api/java' > make[2]: *** [all] Error 2 > make[2]: Leaving folder=20 > `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37/src/api' > make[1]: *** [all] Error 2 > make[1]: Leaving folder `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37= /src' > make: *** [all] B=C5=82=C4=85d 2 >=20 |
|
From: Maciej W. <mac...@co...> - 2006-01-23 11:27:25
|
Hi When trying to install SQLRelay 0.37pre4 I get error as below. The problem only appears when java is enabled. I've removed /usr/local/firstworks folder before installation but the problem persists. com_firstworks_sqlrelay_SQLRCursor.C: In function `__jobjectArray* Java_com_firstworks_sqlrelay_SQLRCursor_getRow(JNIEnv*, __jobject*, long long int)': com_firstworks_sqlrelay_SQLRCursor.C:1172: invalid conversion from `__jarray*' to `__jobjectArray*' com_firstworks_sqlrelay_SQLRCursor.C: In function `__jobjectArray* Java_com_firstworks_sqlrelay_SQLRCursor_getColumnNames(JNIEnv*, __jobject*)': com_firstworks_sqlrelay_SQLRCursor.C:1219: invalid conversion from `__jarray*' to `__jobjectArray*' make[3]: *** [com_firstworks_sqlrelay_SQLRCursor.lo] Błąd 1 make[3]: Leaving folder `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37/src/api/java' make[2]: *** [all] Error 2 make[2]: Leaving folder `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37/src/api' make[1]: *** [all] Error 2 make[1]: Leaving folder `/home/zope/install/sqlrelay-0.37/sqlrelay-0.37/src' make: *** [all] Błąd 2 -- Maciej Wisniowski |
|
From: Kumara S <kum...@si...> - 2006-01-20 10:26:00
|
Hi, We are develpoping a web application that connects to MySQL thru sqlrelay... We thought of using PHP pear DB classes to abstract the database. My requirement is to connect to the database server and check if it can handle further queries successfully. When the MySQL server goes down, sqlrelay sendQuery() keeps retrying infinitely and returns only after the DB comes up. Since i can't allow my page to wait till everything becomes normal, i thought of using ping() to check the status of MySQL before querying. but, even when the DB recovers later, ping() returns false. Following ealier discussions with Maciej Wisniowski, ping() just gives the status of the connection that went to CLOSE_WAIT state and does not attempt to reconnect to DB. It is only the first sendQuery that reconnects. So, using ping() before sendQuery() does not allow my application to recover even when MySQL is up. Calling sendQuery() directly sends my application to infinite loop in case of DB failure. The problem is simple. Connect to DB when it is available in a single try, return false in case of a DB failure. API calls like mysql_connect gives me just that. but, sqlrelay either gives me infinite retries(when DB goes down) or no try at all (when it recovers). Please give me a workaround. Thanks! Kumara Sundaram |
|
From: Kumara S <kum...@si...> - 2006-01-20 10:22:38
|
Hi, We are develpoping a web application that connects to MySQL thru sqlrelay... We thought of using PHP pear DB classes to abstract the database. My requirement is to connect to the database server and check if it can handle further queries successfully. When the MySQL server goes down, sqlrelay sendQuery() keeps retrying infinitely and returns only after the DB comes up. Since i can't allow my page to wait till everything becomes normal, i thought of using ping() to check the status of MySQL before querying. but, even when the DB recovers later, ping() returns false. Following ealier discussions with Maciej Wisniowski, ping() just gives the status of the connection that went to CLOSE_WAIT state and does not attempt to reconnect to DB. It is only the first sendQuery that reconnects. So, using ping() before sendQuery() does not allow my application to recover even when MySQL is up. Calling sendQuery() directly sends my application to infinite loop in case of DB failure. The problem is simple. Connect to DB when it is available in a single try, return false in case of a DB failure. API calls like mysql_connect gives me just that. but, sqlrelay either gives me infinite retries(when DB goes down) or no try at all (when it recovers). Please give me a workaround. Thanks! Kumara Sundaram |
|
From: Maciej W. <mac...@co...> - 2006-01-19 13:32:38
|
> Hi David, > Did you get my last e-mail about that problem? > Best regards, Check the list archives to see if your message was properly sent, or send this kind of emails only to David ;) -- Maciej Wisniowski |
|
From: Rodrigo P. T. <te...@de...> - 2006-01-19 11:32:02
|
Hi David, Did you get my last e-mail about that problem? Best regards, -- ============================================ Rodrigo P. Telles <te...@de...> IT Manager Devel-IT - http://www.devel.it IVOZ # 1029 +55 14 3324-1200 Bestcom Group ============================================ |
|
From: Maciej W. <mac...@co...> - 2006-01-18 22:29:15
|
Hi >./sqlr-start -id Vega > > Starting listener: > sqlr-listener-debug -id Vega -config /usr/local/firstworks/etc/sqlrelay.conf & > sh: line 1: sqlr-listener-debug: command not found Maybe you should check your PATH environment variable. Seems that sqlr-start is not able to find other executables. -- Maciej Wisniowski |
|
From: Gerson S. <gsa...@gm...> - 2006-01-18 17:54:07
|
Hi I have a debian linux with oracle 10g client and sqlrelay 0.36.4 and I trie= d connect zope 2.7 instance with ZSQLRelayDA to a remote Oracle 8i linux server. After sqlrelay install process I edited etc/sqlrelay.conf file and I tried execute sqlr-start ------------------ ./sqlr-start -id Vega Starting listener: sqlr-listener-debug -id Vega -config /usr/local/firstworks/etc/sqlrelay.conf & sh: line 1: sqlr-listener-debug: command not found Starting 2 connections to VEGA : sqlr-connection-oracle8 -id Vega -connectionid VEGA -config /usr/local/firstworks/etc/sqlrelay.conf sh: line 1: sqlr-connection-oracle8: command not found sqlr-connection-oracle8 failed to start. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. ---------------- Then I tried to run sqlr-listener / sqlr-connection-oracle8 manually but th= e sqlrsh don't return any query then I run sqlr-listener-debug and the var/sqlrelay/debug/sqlrelay-listener.24918 was -------------- 01/18/2006 16:48:49 BRST listener [24918] : id filename: 01/18/2006 16:48:49 BRST listener [24918] : /usr/local/firstworks/var/sqlrelay/tmp/ipc/Vega 01/18/2006 16:48:49 BRST listener [24918] : creating shared memory... 01/18/2006 16:48:49 BRST listener [24918] : creating semaphores... 01/18/2006 16:48:49 BRST listener [24918] : waiting for client connection..= . ------------- My sqlrelay.conf ------------- <?xml version=3D"1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <instance id=3D"Vega" port=3D"9000" socket=3D"/tmp/vega_mega.socket" dbase=3D"oracle8" connections=3D"2" maxconnections=3D"10" maxqueu elength=3D"0" growby=3D"1" ttl=3D"60" endofsession=3D"commit" sessiontimeou= t=3D"600" runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"5" authtier=3D"listener" handoff=3D"pass" debug=3D"listener"> <users> <user user=3D"HPS" password=3D"HPS"/> </users> <connections> <connection connectionid=3D"VEGA" string=3D"user=3DHPS;password=3DHPS;oracle_sid=3DVEGA.MEGA" metric=3D"1"/> </connections> </instance> </instances> ----------- My tnsnames.ora ---------- VEGA.MEGA =3D (DESCRIPTION =3D (ADDRESS_LIST =3D (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 10.10.69.16)(PORT =3D 1521)) ) (CONNECT_DATA =3D (SID =3D VEGADB) (SERVER =3D DEDICATED) ) ) --------- Thanks in advance for any help Gerson |
|
From: Maciej W. <jo...@po...> - 2006-01-18 16:54:40
|
Today on Zope-DB group Seth Gotlieb has pointed to some interesting links: http://contenthere.blogspot.com/2005/12/zoracle-part-i-problem.html http://contenthere.blogspot.com/2005/12/zoracle-part-ii-solution.html http://contenthere.blogspot.com/2005/12/zoracle-part-iii-connecting-zope-to.html Especially the last one is worth reading in context of SQLRelay and Zope. I would add that I've resolved issue with a lack of support of bindings in ZSQLRelayDA by writing own product for stored procedures that are similiar to these in DCOracle2 DA. -- Maciej Wisniowski |
|
From: David M. <dav...@fi...> - 2006-01-18 16:52:35
|
I think I see what's going on. SQL Relay has it's own client/server protocol and client API. Programs that use oracle directly use Oracle's client API and use the OCI protocol to talk to the oracle database. If you try to connect to SQL Relay using a program that was written to talk to oracle directly, that program will try to use the OCI protocol to talk to SQL Relay rather than SQL Relay's protocol and you'll get an authentication error. There are a few solutions. If you just want to run queries, SQL Relay comes with a tool called sqlrsh that is similar to sqlplus or the mysql client. If you have an app that uses PHP Pear DB or Perl DBI, Python DB, or Ruby DBI, then you can just configure your app to use the SQL Relay driver rather than the Oracle driver. However, if your app uses native Oracle function calls, then the only solution is to modify it to use SQL Relay's function calls. Hope this helps. David Muse dav...@fi... On Fri, 2006-01-13 at 11:38 +0000, Corey Gill wrote: > Hello. I have installed oracle 10gr2 client and sqlrelay 0.36.4 on a > whitebox linux machine (pentium 4, kernel 2.4.21-15.ELsmp). The sqlrelay > daemons are connecting to an oracle10gr2 database (on windows 2003) ok and I > am able to execute queries using the query command line interface. > > When I try to connect using an oracle client (sqlplus, php, etc), I receive > an ora-12537: connection closed error. The following message appears in the > sqlrelay debug file: > 01/13/2006 11:21:05 GMT listener [29984] : authentication failed: user size > is wrong > > In the sqlnet trace, the following appears: > [13-JAN-2006 10:27:37:666] ntt2err: entry > [13-JAN-2006 10:27:37:666] ntt2err: Read unexpected EOF ERROR on 9 > [13-JAN-2006 10:27:37:666] ntt2err: exit > [13-JAN-2006 10:27:37:666] nsprecv: error exit > [13-JAN-2006 10:27:37:666] nserror: entry > [13-JAN-2006 10:27:37:666] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; > nt[ > 0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 > > I have tried setting authtier to all of the possible options with the same > result. > > I downloaded .37pre3 but this will not compile on the whitebox machine due > to errors related to uint32_t: > debugfile.h:22: type specifier omitted for parameter `uint32_t' > > Does this appear to be a problem due to the operating system or is this a > config issue? > > Thanks, > Corey > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: David M. <dav...@fi...> - 2006-01-18 16:31:41
|
Zsolt, I'm afraid SQL Relay probably won't help you with this problem. SQL Relay does have a mysql-drop-in replacement library that you could use in place of libmysql.dll that would make it so the program would transparently use SQL Relay rather than MySQL without having to recode it, but it doesn't currently work on windows. It also appears that you're looking for a way to keep the 2 databases synchronized. SQL Relay doesn't currently provide a way to do that either. You'd have to use MySQL's replication feature. So, even if you could get your apps to use SQL Relay, I'm not sure that it would help out too much in this case. David Muse dav...@fi... On Tue, 2006-01-17 at 00:21 +0100, Xor wrote: > Hi, > > Recently i think sqlrelay is a solution for me, but now i don't know. I > try to explain what I would like to do. I have written a software on > win32 platform in c++. It's using mysql database and connecting to it > with libmysql.dll. The task is connect two local network throught the > internet using "one" database. (or master / slave database ?) The > modifications have to come into force immediately on local networks but > the syncronization between networks can be late. > > I have no problem on local network of course. The problem is come > forward when i would like to connect to the mysql server throught > internet. When i'm running querys which hit a lot of records it takes a > long time to get result and while mysql serves this query the local > clients is waiting too because of select read lock. (nolock is not a > solution) > > I planed to use one database server and sqlrelay, but unfortunately i > have to realize that sqlrelay is not "transparent" - so i can't connect > to it like to a mysql server. I can't rewrite the win32 software to use > sqlrelay c++ api so i can't use it? > > Please help if you have any idea / software to handle this situation! > MySQL master/slave replication maybe a solution but i don't know what's > happening when i trying to modifiy the slave database? The modification > not get on the master, am i right? > > Thank you in advance! > > Best Regards > Zsolt > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: David M. <dav...@fi...> - 2006-01-17 21:17:37
|
Piotr, You can access data in multiple schemas by creating an oracle user that has the necessary permissions to access data in other schemas, configure SQL Relay to log in as that user, and then refer to table using the SCHEMA.TABLE notation. But, you can also set up an oracle user that proxies several other users and, set authtier="database" in the sqlrelay.conf file and then code your apps to log into SQL Relay using the user/password for the schema you want to access. Here's a page describing how to do it: http://sqlrelay.sourceforge.net/sqlrelay/oraclentier.html I'm curious about the segfault though, what are you doing to try to switch schemas within your app that causes the segfault? David Muse dav...@fi... On Tue, 2006-01-17 at 11:35 +0100, pt...@po... wrote: > Hello. > > As I managed to run succesfully SQLRelay with single DB instance connection, I've been trying to rewrite further apps so they communicate with OCI9i database. Then I bumped into issue: when I switch the DB schema inside the application code, it crashes with segfault. If I understand it correctly SQLR is to be configured for one database per daemon only? Is there any way to make it pool connections to different schemas without deploying greater number of daemons? > Thanks in advance, regards > > Piotr > > ---------------------------------------------------------------------- > Kliknij po wiecej! >>> http://link.interia.pl/f18ed > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: <pt...@po...> - 2006-01-17 10:35:59
|
Hello. As I managed to run succesfully SQLRelay with single DB instance connection= , I've been trying to rewrite further apps so they communicate with OCI9i d= atabase. Then I bumped into issue: when I switch the DB schema inside the a= pplication code, it crashes with segfault. If I understand it correctly SQL= R is to be configured for one database per daemon only? Is there any way to= make it pool connections to different schemas without deploying greater nu= mber of daemons? Thanks in advance, regards Piotr ---------------------------------------------------------------------- Kliknij po wiecej! >>> http://link.interia.pl/f18ed |
|
From: Xor <xo...@ps...> - 2006-01-16 23:25:44
|
Hi,
Recently i think sqlrelay is a solution for me, but now i don't know. I
try to explain what I would like to do. I have written a software on
win32 platform in c++. It's using mysql database and connecting to it
with libmysql.dll. The task is connect two local network throught the
internet using "one" database. (or master / slave database ?) The
modifications have to come into force immediately on local networks but
the syncronization between networks can be late.
I have no problem on local network of course. The problem is come
forward when i would like to connect to the mysql server throught
internet. When i'm running querys which hit a lot of records it takes a
long time to get result and while mysql serves this query the local
clients is waiting too because of select read lock. (nolock is not a
solution)
I planed to use one database server and sqlrelay, but unfortunately i
have to realize that sqlrelay is not "transparent" - so i can't connect
to it like to a mysql server. I can't rewrite the win32 software to use
sqlrelay c++ api so i can't use it?
Please help if you have any idea / software to handle this situation!
MySQL master/slave replication maybe a solution but i don't know what's
happening when i trying to modifiy the slave database? The modification
not get on the master, am i right?
Thank you in advance!
Best Regards
Zsolt
|
|
From: Maciej W. <mac...@co...> - 2006-01-15 22:42:36
|
> Is it possible to have a sqlrelay-client which will connect to sqlrelay daemon, > in an internal language of course, and force the sqlrelay-daemon to connect > via another medium of connection (like JDBC or internal language …) ? I can't catch your point here. Are you asking if it is possible to connect to database with SQLRelay via JDBC? AFAIK the answer is no. > Actually, I want to run the client in C++, and the daemon/server in Java. Again, I'm not sure whether you're talking about SQLRelay daemon/server or your own daemon/server... Do you want to have application written in C++ (client) that uses SQLRelay to connect to database, and apllication written in Java (server) that uses SQLRelay to connect to database too? If so, then It is possible and but you don't need JDBC here (simply use SQLRelay in Java). -- Maciej Wisniowski |
|
From: Batoussa M. <bmo...@sa...> - 2006-01-14 23:26:49
|
Hi, =20 I'd like to have information I didn't manage to find on the provided documentation. Is it possible to have a sqlrelay-client which will connect to sqlrelay daemon, in an internal language of course, and force the sqlrelay-daemon to connect via another medium of connection (like JDBC or internal language ...) ? Actually, I want to run the client in C++, and the daemon/server in Java. =20 =20 Thank you, Batoussa |
|
From: Nathan M. <na...@dr...> - 2006-01-13 20:54:13
|
Hi,
I've got a plsql procedure as follows:
PROCEDURE test_null (
p_return_value OUT VARCHAR2
) IS
BEGIN
p_return_value :=3D NULL;
END;
When executing it through php + sqlrelay, i get the following back as=20
the p_return_value, anyone know what might cause this or how to fix it?
Thanks,
Nathan
Result set:
Result Set Buffer Size:
Opening cached result set:
%s.indSQLRELAYCACHEFile is either corrupt or not a cache file.Couldn't=20
open and %s.indCaching data to
Resuming caching data to SQLRELAYCACHEError caching data to Finishing=20
caching.
Resuming Result Set of Cursor:
The query is too large. MAXQUERYSIZE is
File name / is too long.File: The file could not be opened.
The query in is too large. No query to execute.'' is NULL $(-- debug
Sending Query:
Length: Requesting Cursor: Requesting a new cursor.
Requesting re-execution of previous query.Sending Input Bind Variables:
(:NULL)
:STRING)=3D):LONG)=3D:DOUBLE)=3D:,:BLOB)=3D:CLOB)=3DSending Output Bind V=
ariables:
Send Column Info: yes
Send Column Info: no
Checking For An Error... Failed to determine whether an error occurred=20
or not.
A network error may have ocurred.none.
error!!!
Getting Cursor ID...
Failed to get a cursor id.
A network error may have ocurred.Cursor ID:
Failed to determine whether the session was suspended or not.
A network error may have ocurred.Failed to get the index of the last=20
row of a previously suspended result set.
A network error may have ocurred.Previous result set was suspended at=20
row index: not suspended.
Getting Error From Server
There was an error, but the connection died trying to retrieve it. =20
Sorry.Setting Error
UNKNOWNCHARINTSMALLINTTINYINTMONEYDATETIMENUMERICDECIMALSMALLDATETIMESMAL=
LMONEYIMAGEBINARYBITREALFLOATTEXTVARCHARVARBINARYLONGCHARLONGBINARYLONGIL=
LEGALSENSITIVITYBOUNDARYVOIDUSHORTUNDEFINEDDOUBLEDATETIMETIMESTAMPUINTLAS=
TREALSTRINGVARSTRINGLONGLONGMEDIUMINTYEARNEWDATENULLENUMSETTINYBLOBMEDIUM=
BLOBLONGBLOBBLOBVARCHAR2NUMBERROWIDRAWLONG_RAWMLSLABELCLOBBFILEBIGINTINTE=
GERLONGVARBINARYLONGVARCHARGRAPHICVARGRAPHICLONGVARGRAPHICDBCLOBDATALINKU=
SER_DEFINED_TYPESHORT_DATATYPETINY_DATATYPED_FLOATARRAYQUADINT64DOUBLE=20
PRECISIONBOOLBYTEANAMEINT8INT2INT2VECTORINT4REGPROCOIDTIDXIDCIDOIDVECTORS=
MGRPOINTLSEGPATHBOXPOLYGONLINE_LINEFLOAT4FLOAT8ABSTIMERELTIMETINTERVALCIR=
CLE_CIRCLE_MONEYMACADDRINETCIDR_BOOL_BYTEA_CHAR_NAME_INT2_INT2VECTOR_INT4=
_REGPROC_TEXT_oid_TID_XID_CID_OIDVECTOR_BPCHAR_VARCHAR_INT8_POINT_LSEG_PA=
TH_BOX_FLOAT4_FLOAT8_ABSTIME_RELTIME_TINTERVAL_POLYGONACLITEM_ACLITEM_MAC=
ADDR_INET_CIDRBPCHAR_TIMESTAMP_DATE_TIMETIMESTAMPTZ_TIMESTAMPTZINTERVAL_I=
NTERVAL_NUMERICTIMETZ_TIMETZ_BITVARBIT_VAR
BITREFCURSOR_REFCURSORREGPROCEDUREREGOPERREGOPERATORREGCLASSREGTYPE_REGPR=
OCEDURE_REGOPER_REGOPERATOR_REGCLASS_REGTYPERECORDCSTRINGANYANYARRAYTRIGG=
ERLANGUAGE_HANDLERINTERNALOPAQUEParsing=20
Column Info
Actual row count: Failed to get whether the server knows the number=20
actual rows or not.
A network error may have occurred.Failed to get the number of actual row=
s.
A network error may have occurred.unknown
Affected row count: Failed to get whether the server knows the number of=20
affected rows or not.
A network error may have occurred.Failed to get the number of affected=20
rows.
A network error may have occurred.Failed to get whether the server is=20
sending column info or not.
A network error may have occurred.Failed to get the column count.
A network error may have occurred.Column count: Failed to whether=20
column types will be predefined id's or strings.
A network error may have occurred.Failed to get the column name length.
A network error may have occurred.Failed to get the column name.
A network error may have occurred.Failed to get the column type.
A network error may have occurred.Failed to get the column type length.
A network error may have occurred.Failed to get column info.
A network error may have occurred."",", (,) NOT NULL Primary Key=20
Unique Part of a Key Unsigned Zero Filled Binary Auto-Increment=20
Receiving Output Bind Values:
Failed to get data type.
A network error may have occurred.Failed to get string value length.
A network error may have occurred.Failed to get string value.
A network error may have occurred.Failed to get cursor id.
A network error may have occurred.Failed to get total length.
A network error may have occurred.Failed to get chunk type.
A network error may have occurred.Failed to get chunk length.
A network error may have occurred.Failed to get chunk data.
A network error may have occurred.=3D
Parsing Data
Already at the end of the result set
Failed to get the field type.
A network error may have occurredGot end of result set.
Creating extra rows.
Failed to get the field length.
A network error may have occurredFailed to get the field data.
A network error may have occurredFailed to get total length.
A network error may have occurredFailed to get chunk type.
A network error may have occurredFailed to get chunk length.
A network error may have occurredFailed to get chunk data.
A network error may have occurred"",,
Skipping and Fetching
row to get:
Fetching rows
The cache file index appears to be corrupt.Skipping Aborting Result Set=20
For Cursor:
Getting the rest of the result set, since this is a cached result set.
=01=1B=03;=1B=AD=03=FF=FF$=1B=D0=04=FF=FFL=1B =06=FF=FFt=1Br=08=FF=FFoe=1B=
D
=FF=FF=E0=1B$=0B=FF=FF=1C=1C=0C=FF=FF =1C,=0E=FF=FFD=1C=08=0F=FF=FFd=1C=EC=
=0F=FF=FF"=1C?=12=FF=FF=B0=1C=BE=12=FF=FF=D0=1C=EC=12=FF=FF=F0=1COE=14=FF=
=FF=10=1D"=15=FF=FF0=1D=B0=16=FF=FFP=1D4=17=FF=FFp=1DEUR=17=FF=FF?=1D=D6=17=
=FF=FF=B0=1D,=18=FF=FF=D0=1D"=18=FF=FF=F0=1D=F4=18=FF=FF=10=1E=AE=19=FF=FF=
0=1E~=1A=FF=FFP=1E@=1B=FF=FFt=1E~=1B=FF=FF"=1Eh=1C=FF=FF=B4=1E0=1D=FF=FF=D4=
=1E=0C=1E=FF=FF=F4=1Ef=1E=FF=FF=14=1F=D6=1E=FF=FF4=1F=D0=20
=FF=FFt=1F,#=FF=FF =1FD,=FF=FF=18 x,=FF=FFT =C2/=FF=FF| =0C3=FF=FF=C0 N6=FF=
=FF=E0 =AE9=FF=FF! :=FF=FF=20
!;=FF=FF@!@<=FF=FFd!+<=FF=FF"!=F2<=FF=FF=A4!:=3D=FF=FF=C4!,=3D=FF=FF=E4!=CA=
=3D=FF=FF=04"=1A>=FF=FF$"j>=FF=FFD"=BA>=FF=FFd"
?=FF=FF""Z?=FF=FF=A4"=AA?=FF=FF=C4"=FA?=FF=FF=E4"J@=FF=FF=04#'@=FF=FF$#=FE=
@=FF=FFD#FA=FF=FFd#Z(A=FF=FF"#=D6A=FF=FF=A4#&B=FF=FF=C4#vB=FF=FF=E4#=C6B=FF=
=FF=04$=16C=FF=FF$$fC=FF=FFD$=B6C=FF=FFd$=06D=FF=FF"$VD=FF=FF=A4$=20
D=FF=FF=C4$=10E=FF=FF=E4$EURE=FF=FF=04%,F=FF=FF$%~F=FF=FFD%=D2F=FF=FFd%=EA=
G=FF=FF^%<(B[=FF=FF`(>\=FF=FF"(H]=FF=FF=A8(R^=FF=FF=CC(^_=FF=FF=F0(=10`=FF=
=FF=18)P`=FF=FF<)=C4`=FF=FF`)^a=FF=FF^)=20
b=FF=FF=B0)Lb=FF=FF=D4)vb=FF=FF=F8)=20
b=FF=FF=1C*=CAb=FF=FF@*=0Cf=FF=FFh*=1Cg=FF=FFOE*lg=FF=FF=B0*=BEg=FF=FF=D4=
*Th=FF=FF=F8*=12i=FF=FF=1C+=BCi=FF=FF\+hk=FF=FF|+xl=FF=FF=BC+=D6p=FF=FF=F0=
+=ACq=FF=FF=10,=CCr=FF=FF@,"w=FF=FFt,'w=FF=FF~,=D6w=FF=FF=BC,S({=FF=FF=E0=
,^}=FF=FF=04-&=0C
7;=FF=FF(-=C6?=FF=FFL-=20
EUR=FF=FF^-=D0EUR=FF=FF=A8-=B0,=FF=FF=E8-=E8,=FF=FF=10.B"=FF=FF4.=E60/00=FF=
=FF\.*S(=FF=FF".tS(=FF=FF=C4.=B0S(=FF=FF=E4.=F0S(=FF=FF=04/D<=FF=FFD/=FC?=
=FF=FFOE/=04"=FF=FF=B0/("=FF=FF=F4/=C4"=FF=FF=140j^(TM)=FF=FF40=D4=A4=FF=FF=
T0*=A8=FF=FFt04=A9=FF=FF"0=F0=AA=FF=FF=B40h=AC=FF=FF=D40=CA=AD=FF=FF=F40=B6=
=AF=FF=FF=141=F2=B0=FF=FF81"=B1=FF=FF\14=B2=FF=FF|1=D2=B3=FF=FFoe1B=B4=FF=
=FF=BC1=B2=B4=FF=FF=DC1(=B5=FF=FF=FC1(=C1=FF=FF=20
2=D4=C1=FF=FFD2=C0=C7=FF=FF^2j=CF=FF=FF=AC26=D0&y
uml;=FF=D42=CC=D0=FF=FF=183"=D1=FF=FF83=FA=D1=FF=FFX3p=D4=FF=FFx3L=D5=FF=FF=
~3Z=D6=FF=FF=B83<=D7=FF=FF=D83H=D9=FF=FF=FC3 =DB=FF=FF=1C4=1C=DC=FF=FF@4<=
=DD=FF=FFd4=E0y=01=E0>=01+J=013J=018J=01K=01GK=01QK=01VK=01^K=01cK=01hK=01=
lK=01uK=01EURK=010/00K=01Z(K=01--K=01z(K=01=A4K=01=A8K=01=B1K=01=BAK=01=BF=
K=01=C5K=01=CCK=01=D4K=01=E2K=01=EEK=01=F6K=01=01L=01=10L=01=17L=01=20
L=012L=01AL=01OL=01WL=01]L=01bL=01hL=01yL=01~L=01"L=010/00L=01Z(L=01"L=01=
z(L=01=A3L=01=ABL=01=AFL=01=B3L=01=B7L=01=BBL=01=C5L=01=CAL=01=D0L=01=D5L=
=01=DAL=01=DEL=01=E6L=01=EBL=01=F1L=01=F8L=01=FFL=01=07M=01=0FM=01=19M=01=
=20
M=01(M=01/M=017M=01V=01EV=01OV=01XV=01bV=01gV=01oV=01tV=01yV=01}V=01+V=01=
'V=01s(V=01Y"V=01=A8V=01=AFV=01=B5V=01=B9V=01=C2V=01=CBV=01=D0V=01=D6V=01=
=DDV=01=E5V=01=F3V=01=FFV=01=07W=01=12W=01!W=01(W=011W=01CW=01RW=01`W=01h=
W=01nW=01sW=01yW=01S(W=01?W=01.W=01s(W=01Y"W=01=A4W=01=AFW=01=B4W=01=BCW=01=
=C0W=01=C4W=01=C8W=01=CCW=01=D6W=01=DBW=01=E1W=01=E6W=01=EBW=01=EFW=01=F7=
W=01=FCW=01=02X=01 =20
X=01=10X=01=18X=01 X=01*X=011X=019X=01@X=01HX=01MX=01RX=01XX=01_X=01eX=01=
kX=01qX=01}X=01fX=01OEX=01'X=01--X=01oeX=01=A1X=01=A6X=01=B1X=01=B9X=01=C2=
X=01=C8X=01=CFX=01=D5X=01=DBX=01=E0X=01=E8X=01=F0X=01=F9X=01=02Y=01
Y=01=16Y=01=1EY=01'Y=010Y=016Y=01<=FF=FFd!+<=FF=FF"!=F2<=FF=FF=A4!:=3D'=FF=
=FF=C4!,=3D=FF=FF=E4!=CA=3D=FF=FF=04"=1A' :=FF=FF =AE9=FF=FF! N6=FF=FF=E0=
=20
3=FF=FF=C0 =FF=FF| =C2 x,=FF=FFT =FF=FFt=1F,#=FF=FF =1FD,=FF=FF=18 =1E=FF=
=FF=F4=1Ef=1E=FF=FF=14=1F=D6=1E=FF=FF4=1F=D0 =1C,=0E=FF=FFD=1C=08=0F=FF=FF=
d=1C=EC=0F=FF=FF"=1C?=12=FF=FF=B0=1C=BE=12=FF=FF=D0=1C=EC=12=FF=FF=F0=1CO=
E=14=FF=FF=10=1D"=15=FF=FF0=1D=B0=16=FF=FFP=1D4=17=FF=FFp=1DEUR=17=FF=FF?=
=1D=D6=17=FF=FF=B0=1D,=18=FF=FF=D0=1D"=18=FF=FF=F0=1D=F4=18=FF=FF=10=1E=AE=
=19=FF=FF0=1E~=1A=FF=FFP=1E@=1B=FF=FFt=1E~=1B=FF=FF"=1Eh=1C=FF=FF=B4=1E0=1D=
=FF=FF=D4=1E=20
=FF=FF =FF=FF=1C=1C =FF=FF=E0=1B$ =01=1B=03;=1B=AD=03=FF=FF$=1B=D0=04=FF=FF=
L=1B =06=FF=FFt=1Br
=08=FF=FFoe=1BD set. result cached a is this since set, the of rest Getti=
ng=20
Cursor: For Set Result Aborting corrupt.Skipping be to appears index=20
file cache The rows Fetching get: row and Skipping occurred??,, have may=20
error network A data. chunk get occurredFailed length. type. total field=20
Failed rows. extra Creating end occurredGot set at Already Data=20
occurred.=3D"Parsing" occurred.Failed id. cursor=20
=05Ef=04+=03j.=20
=05Ef=04+=03R.=10$t$=EB=FE=FF=D2=01=047=19A=0E=08...=02B=20
=05Ef=04+=03R.=10$L|=E9=FE=FF=D0=01=04G=19A=0E=08...=02B =04=04^=01$$=D4=E7=
=FE=FF=D0=01=04W=19A=0E=08...=02B>=FF=FF$"j>=FF=FFD"=BA>=FF=FFd"
?=FF=FF""Z?=FF=FF=A4"=AA?=FF=FF=C4"=FA?=FF=FF=E4"J@=FF=FF=04#'@=FF=FF$#=FE=
@=FF=FFD#FA=FF=FFd#Z(A=FF=FF"#=D6A=FF=FF=A4#&B=FF=FF=C4#vB=FF=FF=E4#=C6B=FF=
=FF=04$=16C=FF=FF$$fC=FF=FFD$=B6C=FF=FFd$=06D=FF=FF"$VD=FF=FF=A4$=20
D=FF=FF=C4$=10E=FF=FF=E4$EURE=FF=FF=04%,F=FF=FF$%~F=FF=FFD%=D2F=FF=FF
|
|
From: Corey G. <cor...@ve...> - 2006-01-13 11:38:21
|
Hello. I have installed oracle 10gr2 client and sqlrelay 0.36.4 on a whitebox linux machine (pentium 4, kernel 2.4.21-15.ELsmp). The sqlrelay daemons are connecting to an oracle10gr2 database (on windows 2003) ok and I am able to execute queries using the query command line interface. When I try to connect using an oracle client (sqlplus, php, etc), I receive an ora-12537: connection closed error. The following message appears in the sqlrelay debug file: 01/13/2006 11:21:05 GMT listener [29984] : authentication failed: user size is wrong In the sqlnet trace, the following appears: [13-JAN-2006 10:27:37:666] ntt2err: entry [13-JAN-2006 10:27:37:666] ntt2err: Read unexpected EOF ERROR on 9 [13-JAN-2006 10:27:37:666] ntt2err: exit [13-JAN-2006 10:27:37:666] nsprecv: error exit [13-JAN-2006 10:27:37:666] nserror: entry [13-JAN-2006 10:27:37:666] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[ 0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 I have tried setting authtier to all of the possible options with the same result. I downloaded .37pre3 but this will not compile on the whitebox machine due to errors related to uint32_t: debugfile.h:22: type specifier omitted for parameter `uint32_t' Does this appear to be a problem due to the operating system or is this a config issue? Thanks, Corey |
|
From: David M. <dav...@fi...> - 2006-01-07 06:43:46
|
On Thu, 2006-01-05 at 14:32 -0500, NetComrade wrote: > We are thinking of using sqlrelay in between our php enabled apaches and > our multiple databases to minimize the # of connections between apaches > and databases. > > Quesions: > 1) Can sqlrelay easily maintain multiple connections in various > #'s? (e.g. 10 to db1, 12 to db2, 8 to db3, 11 to db11, etc), by a database > here i mean a schema or username in the Oracle world. > >From these lines, it would seem so: > > The client will send a user and password to the sqlr-listener and > sqlr-connection daemons when it connects to them. The authtier attribute > indicates which daemon will actually pay attention to that user and > password. A single SQL Relay instance can maintain different numbers of connections to various database servers, but it assumes that the database servers are all replicated copies of each other or nodes in a cluster and distributes client sessions over the database servers in proportion to the number of connections that it maintains to each. For instance, if 2 connections are maintained to db1 and only 1 is maintained to db2, then when a client connects to SQL Relay, it is twice as likely to end up running it's queries against db1 than db2. You can set up multiple instances of SQL Relay against multiple database servers. Eg. one instance maintaining 10 connections to db1, a second instance maintaining 12 connections to db2, etc. but each instance must run on a seperate port/socket. So the clients will need to use the appropriate port/socket/user/password to connect to the appropriate database. There is currently no facility for SQL Relay to listen on a single port/socket and route clients to different database servers based on the user/password. If you have a single database server with multiple schema's, you can set up a single SQL Relay instance to maintain multiple connections to that server and use the authtier="database". When authtier="database", when a client logs into SQL Relay, it is authenticated against the database rather than against SQL Relay's list of users and if authentication is successful, it ends up logged into the schema belonging to the username that it used to log in as. For example, one client could log in as scott/tiger and it would end up logged in to the SCOTT schema, the next client could log in as system/manager and would end up logged in to the SYSTEM schema. This requires setting up a proxy user though. See http://sqlrelay.sourceforge.net/sqlrelay/oraclentier.html for more info on setting up proxy users and setting up SQL Relay to use them. > > 2) Can the tool be easily ported to Solaris x86? We are currently porting > our application server from Solaris Sparc to Solaris x86, and it'll not > run on Linux (uses lots of old libraries I am told). We are developing > some of our newer products with php, and would like to be able to limit > the # of persistent connections into the db. If this has been done, let me > know, if it hasn't been done but should be possible, we'll be happy to > share the steps we had to take with the community. Solaris x86 is one of the platforms that I test against before making a release. When I released 0.36, it compiled on Solaris 9 x86 (that was the current version then) with whatever the current gcc for Solaris 9 was at the time. Since then, I've made some modifications, but I believe they'll compile. Version 0.37 is coming out soon, and I will make sure it compiles on Solaris 8, 9 and 10 before releasing it. I did some work and accepted some patches to 0.37 to get it to compile using Sun's native toolchain too. If there are any modifications that need to be made to SQL Relay to make it work with Solaris x86, I'd imagine they'd be minor. > > Thanks! Thank you for your interest! Let me know if you have any more questions. David Muse dav...@fi... |
|
From: David M. <dav...@fi...> - 2006-01-07 05:27:53
|
Jose, I did some testing with the current version and I can't reproduce the problem with the 60 second ttl. It's possible that there's a bug in 0.36.2 but the code is pretty similar, so if there's a bug, it's a subtle one. If using a ttl of something other than 60 works for you, then I'd recommend doing that. If you need to use a ttl of 60, then you'll probably have to upgrade to the current version. Dave dav...@fi... On Tue, 2005-12-13 at 11:13 -0800, Jose Selva wrote: > Hi, > > My name is Jose and I'm having a problem with sqlrelay 0.36.2. I'm using Debian linux stable, PHP 4.3, and ORACLE 9.2. > > The current sqlrelay configuration is: > > <instance id="test-con" port="9090" socket="/tmp/test-con.socket" dbase="oracle8" connections="0" maxconnections="25" maxqueuelength="0" growby="3" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="oracle" runasgroup="oracle" cursors="10" authtier="listener" handoff="pass"> > <users> > <user user="test" password="test"/> > </users> > <connections> > <connection connectionid="test" string="user=test;password=test;oracle_sid=JOSE.WORLD" metric="1"/> > </connections> > </instance> > > As you can see, we have a ttl of 60. Here is the problem I'm currently having: > > The benchmark environment is set up so the site gets 3 requests every 5-10 seconds, which needs between 1 and 3 connections active. (Note that we have an average of 25 queries per PHP page) > > If I run apache benchmark requesting 500 pages with a level of concurrency of 5, the number of connections in the pool increases to reach 12-15. > > The problem comes after the apache benchmark is done. Since the volume of requests goes down again, I was expecting to see the number of connections in the pool going down after 60 seconds of inactivity, but this does not happen. > > If I run the apache benchmark again (500 pages and 5 concurrency) the number of connections would go up again to reach 21-24. After the requests are handled, the number of connections would not decrease. > > This is a problem because it seems that those connections used during high volumes of requests are not available anymore once they have been inactive more than 60 seconds, and instead of being released, they stay in the pool and not available for more upcoming requests. > > If I run the same experiment described above with a 15 TTL this problem does not happen. The number of connections goes down right after the connections have been inactive more than that TTL. > > Here is an excerpt of the debug statements found in the connections that have this problem (60 TTL): > > 12/09/2005 00:36:10 GMT connection [18919] : done initializing session... > > 12/09/2005 00:36:10 GMT connection [18919] : announcing availability... > > 12/09/2005 00:36:10 GMT connection [18919] : acquiring announce mutex > > ---- Stuck here --- > > > And this is what I got when using 15 TTL: > > 12/08/2005 14:28:34 PST connection [31305] : initializing session... > > 12/08/2005 14:28:34 PST connection [31305] : done initializing session... > > 12/08/2005 14:28:34 PST connection [31305] : announcing availability... > > 12/08/2005 14:28:34 PST connection [31305] : acquiring announce mutex > > 12/08/2005 14:29:34 PST connection [31305] : decrementing connection count... > > ---- Releases resources just fine ---- > > > Do you have any ideas on why the 60 TTL is causing this problem?. > > Also, if I go ahead with the 15 TTL, what would be the performance impact in my application? > > Any ideas/help would be much appreciated > > Thanks in advance. > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://ads.osdn.com/?ad_idv37&alloc_id865&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: NetComrade <net...@bo...> - 2006-01-05 18:59:53
|
We are thinking of using sqlrelay in between our php enabled apaches and our multiple databases to minimize the # of connections between apaches and databases. Quesions: 1) Can sqlrelay easily maintain multiple connections in various #'s? (e.g. 10 to db1, 12 to db2, 8 to db3, 11 to db11, etc), by a database here i mean a schema or username in the Oracle world. From these lines, it would seem so: The client will send a user and password to the sqlr-listener and sqlr-connection daemons when it connects to them. The authtier attribute indicates which daemon will actually pay attention to that user and password. 2) Can the tool be easily ported to Solaris x86? We are currently porting our application server from Solaris Sparc to Solaris x86, and it'll not run on Linux (uses lots of old libraries I am told). We are developing some of our newer products with php, and would like to be able to limit the # of persistent connections into the db. If this has been done, let me know, if it hasn't been done but should be possible, we'll be happy to share the steps we had to take with the community. Thanks! |
|
From: David M. <dav...@fi...> - 2006-01-05 17:08:48
|
You should be able to use more than 1 ref cursor. Looks like there may
be a bug. I'll check it out and let you know what I find.
Dave
dav...@fi...
On Tue, 2006-01-03 at 16:50 -0500, Biswa Chowdhury wrote:
> Hello All,
>
> When calling an Oracle procedure that returns more than one ref cursor,
> SQLRelay returns the same data for all the ref cursors.
>
> Is this a limitation of SQLRelay that or am I not using it correctly ?
>
> Appreciate any help.
>
> Thanks.
>
> Biswa
>
>
> /************************************************************
> * test_ref_cursor.prc - test oracle procedure
> ************************************************************/
> CREATE OR REPLACE PROCEDURE test_ref_cursor(
> p_out1 OUT SYS_REFCURSOR,
> p_out2 OUT SYS_REFCURSOR,
> ) IS
> BEGIN
> OPEN p_out1 FOR SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') the_date
> FROM DUAL;
> OPEN p_out2 FOR SELECT TO_CHAR(SYSDATE,'HH24:MI:SS') the_time
> FROM DUAL;
> END test_ref_cursor;
> /
>
> /************************************************************
> * test_ref_cursor.pl test perl script
> ************************************************************/
> use SQLRelay::Connection;
> use SQLRelay::Cursor;
>
> $con=SQLRelay::Connection->new("localhost",9000,"","oracletest","oraclet
> est",0,1);
> $cur=SQLRelay::Cursor->new($con);
>
> $cur->prepareQuery("begin test_ref_cursor(:1, :2); end;");
> $cur->defineOutputBindCursor("1");
> $cur->defineOutputBindCursor("2");
> $cur->executeQuery();
>
> # get first rs
> my $bindcur1 = $cur->getOutputBindCursor('1');
> $bindcur1->fetchFromBindCursor();
> print $bindcur1->getField(0,0),"\n";
>
> # get second rs
> my $bindcur2 = $cur->getOutputBindCursor('2');
> $bindcur2->fetchFromBindCursor();
> print $bindcur2->getField(0,0),"\n";
>
>
>
> This correspondence is from Napster, Inc. or its affiliated entities
> and is intended only for use by the recipient named herein. This
> correspondence may contain privileged, proprietary and/or confidential
> information, and is intended only to be seen and used by named addressee(s).
> You are notified that any discussion, dissemination,distribution or copying
> of this correspondence and any attachments, is strictly prohibited,
> unless otherwise authorized or consented to in writing by the sender.
> If you have received this correspondence in error, please notify the
> sender immediately, and please permanently delete the original and any
> copies of it and any attachment and destroy any related printouts without
> reading or copying them.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
16 messages has been excluded from this view by a project administrator.
