Re: [Sqlrelay-discussion] SQLRelay JAVA exception
Brought to you by:
mused
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:55:54
|
Is it possible to reliably reproduce the problem with a particular query, or is it kind of random? 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 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... David Muse dav...@fi... On Fri, 2005-11-11 at 17:48 -0200, Rodrigo P. Telles wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > 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 > ============================================ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.4 (GNU/Linux) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDdPWSiLK8unYgEMQRAuEZAJ9jSyOPrSfJynxqDc3vSbkA5KkDjACcCbPE > rdJgJ1Z38BuP57tnSJ2xDsU= > =qMXp > -----END PGP SIGNATURE----- > > > ------------------------------------------------------- > 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 > |