Re: [Sqlrelay-discussion] 0.37 pre 2

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

It built succesfully after removing the old install.

The connections and the listener start up properly, but when attempting t=
o=20
run any query (or even ping), it hangs. The same happens from sqlrsh.
I tried building it both against the instantclient and the 9i oracle=20
installation -- same result.

Ionut

----- Original Message -----=20
From: "Firstworks/4access" <dav...@fi...>
To: <sql...@li...>
Sent: Wednesday, September 14, 2005 10:41 PM
Subject: Re: [Sqlrelay-discussion] 0.37 pre 2 [Old: memory corruption,apa=
che=20
segfault]

It looks like you might have an old version of SQL Relay installed on
your system and the build process is including the sqlrclient.h header
file from the old version when trying to build the command line tools.

Try removing the old SQL Relay and Rudiments installations before
building the new ones.

Dave
dav...@fi...

On Wed, 2005-09-14 at 22:25 +0300, Ionut Ciocirlan wrote:
> Another issue: it builds the mysql stuff, although configured
> 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
>=20
> -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/i=
nclude
>  -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/sq=
lrelay.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/i=
nclude
>  -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/sq=
lrelay.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/i=
nclude
>  -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 -lsqlrclie=
nt =20
> -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 -lc=
rypt
> -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/firs=
tworks/lib
>  -L/usr/kerberos/lib -L/usr/lib -L/usr/local/src/sqlrelay/src/api/c++/s=
rc
> /usr/local/firstworks/lib/libsqlrclient.so
> /usr/local/firstworks/lib/librudiments.so -lpthread -lssl -lcrypto -lgs=
sapi_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 l=
ong
> long)'
> .libs/query.o(.text+0x4b9): In function `main':
> : undefined reference to `sqlrcursor::getField(unsigned long long,=20
> unsigned
> 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=20
> > into
> > 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): 0x0a174a=
80
> > ***
> > | > [notice] child pid 15277 exit signal Aborted (6)
> > | >
> > | > *** glibc detected *** double free or corruption (!prev): 0x094d0=
ee0
> > ***
> > | > [notice] child pid 4004 exit signal Aborted (6)
> > | >
> > | > *** glibc detected *** double free or corruption (out): 0x0948c59=
8=20
> > ***
> > | > [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=
=20
> > all
> > | > 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 (rare=
ly)=20
> > i
> > get
> > | > no crash, but apache hangs without replying, and the browser hang=
s
> > 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 mi=
x=20
> > 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_sendQuer=
y:
> > | >
> > | > $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 afte=
r
> > several
> > | > such events starts behaving erratically. Sshd and samba get errat=
ic
> > too
> > | > (connections lost etc.). Also, after several hours of
> > testing/debugging,
> > my
> > | > kernel Oopsed. And just now network connectivity went into oblivi=
on.
> > 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 extens=
ion
> > against
> > | > the same oracle instant client libs, and i get the expected outpu=
t,
> > plus
> > no
> > | > crashes;
> > | > - i also recompiled sqlrelay against the 9.1 oracle installation;=
=20
> > same
> > | > results;
> > | > - might be a problem that appeared since 0.34 (we did some extens=
ive
> > testing
> > | > back then, and it all worked out fine); i wanted to test now on 0=
.34
> > 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 & EXP=
O
> > | > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > Practices
> > | > Agile & Plan-Driven Development * Managing Projects & Teams *=20
> > Testing
> > &
> > 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 o=
wn
> > | Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.p=
hp
> > | _______________________________________________
> > | 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.=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.=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