[Sqlrelay-discussion] 0.37 pre 2 [Old: memory corruption, apache segfault]

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Another issue: it builds the mysql stuff, although configured=20
with --disable-mysql (and the configure summary says "MySQL       no")

----- Original Message -----=20
From: "Ionut Ciocirlan" <ion...@av...>
To: <sql...@li...>
Sent: Wednesday, September 14, 2005 10:07 PM
Subject: Re: [Sqlrelay-discussion] memory corruption, apache segfault

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
+ -Wall -pipe   -DDEFAULT_CONFIG_FILE=3D\"/usr/local/firstworks/etc/sqlre=
lay.conf\"
 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -=
I../../src/common
 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc=
lude
 -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\"
 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -=
I../../src/common
 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc=
lude
 -I/usr/kerberos/include -I/usr/include/pcre -c query.C  -fPIC -DPIC -o
.libs/query.o
 g++ -Wall -pipe -DDEFAULT_CONFIG_FILE=3D\"/usr/local/firstworks/etc/sqlr=
elay.conf\"
 -DSYSTEM_SQLRSHRC=3D\"/usr/local/firstworks/etc/sqlrsh\" -I./ -I../../ -=
I../../src/common
 -I../../src/util -I../../src/api/c++/include -I/usr/local/firstworks/inc=
lude
 -I/usr/kerberos/include -I/usr/include/pcre -c query.C -o query.o
 >/dev/null 2>&1
/bin/sh ../../libtool --mode=3Dlink g++  -Wall -pipe   -o query
query.lo -L../../src/util -lsqlrutil -L../../src/api/c++/src -lsqlrclient=
 -L/usr/local/firstworks/lib
 -lrudiments -lpthread -L/usr/kerberos/lib -lssl -lcrypto -lgssapi_krb5 -=
lkrb5
 -lcom_err -lk5crypto -lresolv -ldl -lz -L/usr/lib -lpcre -lrt -lrt -lcry=
pt
-ldl
g++ -Wall -pipe -o .libs/query
libs/query.o  -L/usr/local/src/sqlrelay/src/util
/usr/local/src/sqlrelay/src/util/.libs/libsqlrutil.so -L/usr/local/firstw=
orks/lib
 -L/usr/kerberos/lib -L/usr/lib -L/usr/local/src/sqlrelay/src/api/c++/src
/usr/local/firstworks/lib/libsqlrclient.so
/usr/local/firstworks/lib/librudiments.so -lpthread -lssl -lcrypto -lgssa=
pi_krb5
 -lkrb5 -lcom_err -lk5crypto -lresolv -lz -lpcre -lrt -lcrypt -ldl  -Wl,-=
-rpath
 -Wl,/usr/local/firstworks/lib
.libs/query.o(.text+0x3ae): In function `main':
: undefined reference to `sqlrconnection::sqlrconnection(char const*,
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
long)'
.libs/query.o(.text+0x4b9): In function `main':
: undefined reference to `sqlrcursor::getField(unsigned long long, unsign=
ed
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
> ***
> | > [notice] child pid 15277 exit signal Aborted (6)
> | >
> | > *** glibc detected *** double free or corruption (!prev): 0x094d0ee=
0
> ***
> | > [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
> mainly
> in a
> | > flash communication server running on the same machine, that after
> several
> | > such events starts behaving erratically. Sshd and samba get erratic
> too
> | > (connections lost etc.). Also, after several hours of
> testing/debugging,
> my
> | > kernel Oopsed. And just now network connectivity went into oblivion=
.
> 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,
> 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
> &
> 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.
> 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

-------------------------------------------------------
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