Re: [Sqlrelay-discussion] memory corruption, apache segfault
Brought to you by:
mused
From: Ionut C. <ion...@av...> - 2005-09-14 18:57:55
|
Make fails for sqlrelay... (i think it's quite at the end..) make -C cmdline all make[2]: Entering directory `/usr/local/src/sqlrelay/src/cmdline' /bin/sh ../../libtool --mode=3Dcompile=20 + -Wall -pipe -DDEFAULT_CONFIG_FILE=3D\"/usr/local/firstworks/etc/sqlre= lay.conf\"=20 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -= I../../src/common=20 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc= lude=20 -I/usr/kerberos/include -I/usr/include/pcre -c query.C -o query.lo mkdir .libs g++ -Wall -pipe -DDEFAULT_CONFIG_FILE=3D\"/usr/local/firstworks/etc/sqlr= elay.conf\"=20 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -= I../../src/common=20 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc= lude=20 -I/usr/kerberos/include -I/usr/include/pcre -c query.C -fPIC -DPIC -o=20 .libs/query.o g++ -Wall -pipe -DDEFAULT_CONFIG_FILE=3D\"/usr/local/firstworks/etc/sqlr= elay.conf\"=20 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -= I../../src/common=20 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc= lude=20 -I/usr/kerberos/include -I/usr/include/pcre -c query.C -o query.o=20 >/dev/null 2>&1 /bin/sh ../../libtool --mode=3Dlink g++ -Wall -pipe -o query=20 query.lo -L../../src/util -lsqlrutil -L../../src/api/c++/src -lsqlrclient= -L/usr/local/firstworks/lib=20 -lrudiments -lpthread -L/usr/kerberos/lib -lssl -lcrypto -lgssapi_krb5 -= lkrb5=20 -lcom_err -lk5crypto -lresolv -ldl -lz -L/usr/lib -lpcre -lrt -lrt -lcry= pt =20 -ldl g++ -Wall -pipe -o .libs/query=20 libs/query.o -L/usr/local/src/sqlrelay/src/util=20 /usr/local/src/sqlrelay/src/util/.libs/libsqlrutil.so -L/usr/local/firstw= orks/lib=20 -L/usr/kerberos/lib -L/usr/lib -L/usr/local/src/sqlrelay/src/api/c++/src= =20 /usr/local/firstworks/lib/libsqlrclient.so=20 /usr/local/firstworks/lib/librudiments.so -lpthread -lssl -lcrypto -lgssa= pi_krb5=20 -lkrb5 -lcom_err -lk5crypto -lresolv -lz -lpcre -lrt -lcrypt -ldl -Wl,-= -rpath=20 -Wl,/usr/local/firstworks/lib .libs/query.o(.text+0x3ae): In function `main': : undefined reference to `sqlrconnection::sqlrconnection(char const*,=20 unsigned short, char const*, char const*, char const*, int, int)' .libs/query.o(.text+0x40a): In function `main': : undefined reference to `sqlrcursor::setResultSetBufferSize(unsigned lon= g=20 long)' .libs/query.o(.text+0x4b9): In function `main': : undefined reference to `sqlrcursor::getField(unsigned long long, unsign= ed=20 int)' collect2: ld returned 1 exit status make[2]: *** [query] Error 1 make[2]: Leaving directory `/usr/local/src/sqlrelay/src/cmdline' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/local/src/sqlrelay/src' make: *** [all] Error 2 Ionut ----- Original Message -----=20 From: "Firstworks/4access" <dav...@fi...> To: <sql...@li...> Sent: Wednesday, September 14, 2005 6:22 PM Subject: Re: [Sqlrelay-discussion] memory corruption, apache segfault Try http://www.firstworks.com/sqlrelay-0.37pre2.tar.gz and see what you get. I didn't specifically fix the problem, but some of the changes I made for handling non-ascii data may have fixed it. Dave dav...@fi... On Wed, 2005-09-14 at 16:09 +0300, Ionut Ciocirlan wrote: > Yes, still happening. > > Should i try CVS? > > Ionut > > ----- Original Message -----=20 > From: "David Muse" <dav...@fi...> > To: <sql...@li...> > Sent: Wednesday, September 14, 2005 4:27 AM > Subject: Re: [Sqlrelay-discussion] memory corruption, apache segfault > > > | Well, I said I'd look into this problem, then I misplaced the email > | until today :/ > | > | Are you still having this problem? > | > | David Muse > | dav...@fi... > | > | > | On Fri, 2005-08-19 at 07:48 +0300, Ionut Ciocirlan wrote: > | > Hi, > | > > | > Nasty problem I ran into: > | > > | > I'm running sqlrelay-0.36.4 compiled against oracle instant > client-10.1.0.4, > | > on fedora core 3, glibc-2.3.5; apache-2.0.53 / php-4.3.11. > | > > | > Trying to fetch text containing several utf-8 characters (namely > diacritics) > | > from clobs sometimes crashes apache, with glibc memory errors. > | > > | > NLS_LANG is .AL32UTF8 for both Oracle and SQL Relay; data posted in= to > Apache > | > is in UTF-8. > | > > | > Apache crashes with various messages: > | > > | > *** glibc detected *** malloc(): memory corruption: 0x094d6f20 *** > | > [notice] child pid 4005 exit signal Aborted (6) > | > > | > *** glibc detected *** free(): invalid next size (fast): 0x0a174a80= =20 > *** > | > [notice] child pid 15277 exit signal Aborted (6) > | > > | > *** glibc detected *** double free or corruption (!prev): 0x094d0ee= 0=20 > *** > | > [notice] child pid 4004 exit signal Aborted (6) > | > > | > *** glibc detected *** double free or corruption (out): 0x0948c598 = *** > | > [notice] child pid 4062 exit signal Aborted (6) > | > [notice] child pid 4009 exit signal Segmentation fault (11) > | > > | > The most common error is the first (memory corruption). On almost a= ll > | > occasions, the client browser gets a zero-sized reply. I'd say it's > random, > | > but on fast reruns it happens ~ 5 out of 6 times. Sometimes (rarely= ) i > get > | > no crash, but apache hangs without replying, and the browser hangs > waiting > | > for an answer. > | > > | > Reproduce this by inserting characters 'z =C4=83=C3=AE=C5=9F=C5=A3=C3= =A2 y =C4=82=C3=8E=C5=9E=C5=A2=C3=82 x' in a clob > column. > | > If it doesn't reproduce add this strign several more times and mix = it > with > | > various other text. > | > > | > So, this happens only on clob columns (never on char/varchar): > | > > | > Fetching (illegally?) in non-lob mode crashes at sqlrcur_sendQuery: > | > > | > $query =3D 'select column from table where id =3D xx'; > | > sqlrcur_sendQuery($cur,$query); > | > ---- crash > | > > | > Clob fetching crashes at sqlrcur_executeQuery: > | > > | > $query =3D 'begin > | > select column into :outvar from table where where id =3D xx; > | > end;' > | > sqlrcur_prepareQuery($cur, $query); > | > sqlrcur_defineOutputBindClob($cur, 'outvar'); > | > sqlrcur_executeQuery($cur); > | > ---- crash > | > > | > > | > The memory corruption issues seem to be pretty real: it reflects=20 > mainly > in a > | > flash communication server running on the same machine, that after > several > | > such events starts behaving erratically. Sshd and samba get erratic= =20 > too > | > (connections lost etc.). Also, after several hours of=20 > testing/debugging, > my > | > kernel Oopsed. And just now network connectivity went into oblivion= .=20 > The > | > only solution to restoring normal operation seems to be rebooting. > | > > | > Conclusions so far: > | > - not a machine problem; memtested the hell out of the ram; > | > - not an oracle/oci/glibc problem; i recompiled php's oci8 extensio= n > against > | > the same oracle instant client libs, and i get the expected output,= =20 > plus > no > | > crashes; > | > - i also recompiled sqlrelay against the 9.1 oracle installation; s= ame > | > results; > | > - might be a problem that appeared since 0.34 (we did some extensiv= e > testing > | > back then, and it all worked out fine); i wanted to test now on 0.3= 4 > too, > | > but for some reason it now fails to compile right from the start > | > > | > I hope this will be easy to reproduce / repair..... > | > > | > Regards, > | > Ionut > | > > | > > | > > | > ------------------------------------------------------- > | > SF.Net email is Sponsored by the Better Software Conference & EXPO > | > September 19-22, 2005 * San Francisco, CA * Development Lifecycle > Practices > | > Agile & Plan-Driven Development * Managing Projects & Teams * Testi= ng=20 > & > QA > | > Security * Process Improvement & Measurement * > http://www.sqe.com/bsce5sf > | > _______________________________________________ > | > Sqlrelay-discussion mailing list > | > Sql...@li... > | > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > | > > | > | > | > | ------------------------------------------------------- > | 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 > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server.=20 > 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 > ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Downl= oad 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=20 |