(RADIATOR) Logging Infinite Loop?

[Steve Brown]

Interesting thing happened today. When I enable <Log EMERALD> and the
following ERR comes up:
 
Tue Apr 16 13:55:41 2002: ERR: do failed for 'update ServerPorts set
Username='adm', AcctSessionId='adm15375', AcctStatusType= case 'Start'
wh
en 'Start' then 1 when 'Stop' then 2 else 3 end, CallDate=getdate(),
FramedAddress='', CallerId='', ConnectInfo='', ConnectionSpeed='',
Modula
tionType='', ModemTrainingTime=, ChassisCallSlot=, ChassisCallChannel=,
DisconnectReason='', AccountTermCause='' where ServerID=(select Server
ID from Servers where IPAddress='AAA.BBB.CCC.DDD') and Port=0':
 
It proceeds to try to log (via Perl, FreeTDS, SyBase) - then the insert
fails, so it logs that. The problem appears to be a failed insert
returns more data, and then it tries logging the error via Log EMERALD,
which returns even more data, then it tries to log that, and so on and
so on and so on . until you kill -9 the server before it chews up all
your RAM and slams the box to a halt.
 
I think it has something to do with the single quotes.
 
BTW, that ERR is perfectly acceptable - the AcctSQLStatement works just
fine when someone dials in, it is only a problem when adm logs into the
console which I don't care about (well, I do . but oh well)
 
Steve
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020416/a1e37959/attachment.html>