Re: [Sqlrelay-discussion] SQLRelay JAVA exception
Brought to you by:
mused
|
From: Rodrigo P. T. <te...@de...> - 2005-11-16 19:08:14
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDe4OHiLK8unYgEMQRAksXAJ9kfct6noDTfKlVkTYlHwPDn7Zv2QCfamh+ JdOQX8vda0hK+Z5Ma/PgFME= =7b3L -----END PGP SIGNATURE----- |