[Sqlrelay-discussion] sqlr-listener-${INSTANCE} dying

[Dan T. <dtr...@to...>]

Hi, all -

I'm trying to trace down a problem with sqlrelay, in particular 
sqlr-listener-${INSTANCENAME}.

Long story short, my debbuging reveals that sqlr-start will start a 
listener (in this case sqlr-listener-development, as defined per 
sqlrelay.conf), create N number of sqlr-connection-freetds isntances 
(again, per my configuration file), then finally an attempt at 
sqlr-scaler.  Assuming that's the correct order, then I would be seeing 
sqlr-listener-development dying immediately after my 20 worker processes 
are created, but still being created prior to any of those worker 
processes being started.  Below is a sniplet of the error:


Starting scaler:
   sqlr-scaler -id development -debug  -config /etc/sqlrelay.conf

sqlr-scaler error:
   The file /var/sqlrelay/tmp/pids/sqlr-listener-development was not 
found.  This usually means that the sqlr-listener is not running.  The 
sqlr-listener must be running for the sqlr-scaler to start.


This is in fact true, as the pid file does exist while the workers are 
being started, but is removed immediately after.

I've turned debugging on for both the listener and the connector; from 
that I don't get much information, just what that specific binary is 
doing, which I can get in large part from just a 'ps'.

At this point I'm looking for reasons as to why 
sqlr-listener-development would even die.

I'm kind of stumped as to where I should go from here.  If anyone has 
any suggestions, I would greatly appreciate it.  I can provide any such 
information that may aide in the resolution of this.

Thanks!
-dant