Re: [Sqlrelay-discussion] SQLRelay JAVA exception
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] SQLRelay JAVA exception
|
From: David M. <dav...@fi...> - 2006-01-25 15:38:27
|
Yes, there's an updated version of rudiments in the tarball. Dave On Wed, 2006-01-25 at 11:18 -0200, Rodrigo P. Telles wrote: > Hi David, > > Thanks for your answer! > Should I have to upgrade rudiments too? > > Best regards, > > Telles > > David Muse wrote: > > 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 > >>>> > >>> > >>> > > > > > > > > ------------------------------------------------------- > > 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&kid=103432&bid=230486&dat=121642 > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > |
