[Sqlrelay-discussion] Issue with Microsoft SQL/FreeTDS and SQLRelay

[Stephen b. <sql...@ca...>]

David, List,

    We are trying to upgrade from an older installation of SQLRelay...

SQLRelay      0.39.4
Rudiments   0.31
FreeTDS        0.63

       to the latest version

SQLRelay     0.45
Rudiments  0.36
FreeTDS       0.91


FreeTDS compiles and builds, can connect to the database (Microsoft SQL 
2008)
with no issues using their tsql utility.

freetds.conf

*[callemall]
         host = XXXX.XXXX.com
         port = 1433
         tds version = 8.0
         dump file = /tmp/freetds.log
         debug flags = 0xffff
         timeout = 45
         connect timeout = 10

*
_*freetds "tsql" tool...*_

*root@VM-MXTelecom:/usr/local/src/freetds-0.91/src/apps# ./tsql -S 
callemall -U XXXX -P XXXXX
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> use callemall;
2> go
1> select count(*) from tbcdr;
2> go

2513548
(1 row affected)
1> select db_name();
2> go

callemall
(1 row affected)
1> quit

*
I turn on SQL trace and IP sniffers and what happens is this... I start 
up requesting
5 connection to the database, SQLRelay starts, but after the startup 
script is done
there are NO running sqlr-connection-freetds processes running.


_*When I try to perform a Query ::*_

*SQLRShell - Version 0.22
         Connected to: localhost:9000 as CEA-RW

         type help; for a help.

0> select count(*) from tbcdr;

*
It hangs indefinitely but the status changes to this...

   Open   Server Connections:  5
   Opened Server Connections:  5

   Open   Client Connections:  0
   Opened Client Connections:  0

   Open   Server Cursors:      15
   Opened Server Cursors:      20

   Times  New Cursor Used:     0
   Times  Cursor Reused:       0

   Total  Queries:             5
   Total  Errors:              0

   Forked Listeners: *1 <-----*

Scaler's view:
   Connections:                5
   Sessions: *1 <----*

Semaphores:
   +---------------------------------------------+
   | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  10 |
   +---+---+---+---+---+---+---+---+---+---+-----+
   | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |   1 |
   +---------------------------------------------+

  When I started SQLRelay the sqlr-connection-freetds *did* connect to 
the Database,
log in and perform some queries such as "select db_name()" and "use 
callemall" etc..

I was able to see these with my SQL Server Trace and my IP Sniffer

My sqlrelay.conf file:

*<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<instance       id="CEA"
                         port="9000"
                         socket="/tmp/cea.socket"
                         dbase="freetds"
                         connections="5"
                         maxconnections="10"
                         maxqueuelength="0"
                         growby="1"
                         ttl="60"
                         maxsessioncount="10"
                         endofsession="commit"
                         sessiontimeout="600"
                         runasuser="nobody"
                         runasgroup="nobody"
                         cursors="3"
                         authtier="listener"
                         handoff="pass"
                         maxquerysize="65536"
                         maxstringbindvaluelength="4000"
                         maxlobbindvaluelength="71680"
                         idleclienttimeout="-1"
                         maxlisteners="-1"
                         listenertimeout="0"
                         reloginatstart="no"
                         timequeriessec="0"
                         timequeriesusec="0"
                         debug="none">
<users>
<user
                                 user="XXXX"
                                 password="XXXX"
                         />
</users>
<connections>
<connection
                                 connectionid="CEA"
                                 
string="server=callemall;db=callemall;user=XXXX;password=XXXX;"
                                 metric="1"
                                 behindloadbalancer="no"
                         />
</connections>
</instance>
</instances>
*
I compiled in debug mode and am able to step through connecting, 
creating the connection
including the cursors, but when I reach   sqlrconnection/main.cpp:82

int sqlrconnection_svr::main(int argc, const char **argv,
                                         sqlrconnection_svr *c) {

         #include <version.h>

         conn=c;

         // handle signals
         sigh=conn->handleSignals(sqlrconnection_svr::shutDown);

         // open the connection to the db
         bool    result=false;
         if ((result=conn->initConnection(argc,argv))) {
                 // wait for client connections
*result=conn->listen(); <---- SIGSEGV*
         }

         // If sqlr-stop has been run, we may be here because the 
sqlr-listener
         // has been killed.  In that case, we'll get a SIGINT soon, but we
         // want to ignore it and just let the shutdown proceed normally,
         // otherwise we could be halfway through cleanUp() below when we
         // get it, which will ultimately run cleanUp() again and result in
         // double-free's and a crash.  If we happen to receive the SIGINT
         // before this point, then the shutdown will proceed that way.
         shutdowninprogress=1;

         // unsuccessful completion
         cleanUp();

         // return successful or unsuccessful completion based on 
listenresult
         process::exit((result)?0:1);
}


I get the following error:

*Program received signal SIGSEGV, Segmentation fault.
0xb7c0cca1 in memcpy () from /lib/i686/cmov/libc.so.6
*
Any assistance would be appreciated, I have really been trying almost 
everything that I can
think of,  this is a completely clean Debian Virtual machine with the 
base packages then I added..

apt-get install gcc
apt-get install g++
apt-get install make

and then retrieved the packages..

cd /usr/local/src

wget http://prdownloads.sourceforge.net/sqlrelay/sqlrelay-0.45.tar.gz
wget http://prdownloads.sourceforge.net/rudiments/rudiments-0.36.tar.gz
wget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz

Of course I have since added gdb and ddd to debug but I am at the end of my
resources without some further input..


-- 

Respectfully,


*Stephen Barclay*
Partner, Telecom Engineer
www.call-em-all.com
Direct: 972.893.3119