Re: [Fwd: Re: [Sqlrelay-discussion] SQLRelay JAVA exception]
Brought to you by:
mused
Menu
▾
▴
Re: [Fwd: Re: [Sqlrelay-discussion] SQLRelay JAVA exception]
|
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 > > > > > > > > > |
