(RADIATOR) Re: Radiator Dropping DB Connections

[Andrew Stevenson]

Sorry to reply to my own posting but I have just tried switching on
tracing for one particular DBI connection (through the debugger) and I
get (from inside Radius::SqlDb::do):

    -> do for DBD::Sybase::db (DBI::db=HASH(0x890bc18)~0x89a172c 'DELETE
FROM Radius..acc WHERE     nas_ip = 'X.X.X.X' AND
port = '1'')
1   -> prepare for DBD::Sybase::db (DBI::db=HASH(0x89a172c)~INNER 'DELETE
FROM Radius..acc WHERE    nas_ip = 'X.X.X.X' AND
port = '1'' undef)
    dbih_setup_handle(DBI::st=HASH(0x89a1798)=>DBI::st=HASH(0x890b144),
DBD::Sybase::st, 890b084, Null!)
    dbih_make_com(DBI::db=HASH(0x89a172c), 89a1800, DBD::Sybase::st, 396,
0) thr#0
1   <- prepare= DBI::st=HASH(0x89a1798) at Sybase.pm line 150
    -> execute for DBD::Sybase::st (DBI::st=HASH(0x89a1798)~0x890b144)
    syb_st_execute() -> ct_command() OK
    syb_st_execute() -> ct_send() OK
    st_next_result() -> ct_results(4047) == 1
ct_results() final retcode = 15
    st_next_result() -> lasterr = 0, lastsev = 0
    <- execute= 1667200099 at Sybase.pm line 151
    -> err in DBD::_::common for DBD::Sybase::st
(DBI::st=HASH(0x89a1798)~0x890b144)
    <- err= undef at Sybase.pm line 152
    -> rows for DBD::Sybase::st (DBI::st=HASH(0x89a1798)~0x890b144)
    <- rows= 1667200099 at Sybase.pm line 153
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x890b144)~INNER
'syb_more_results')
    .. FETCH DBI::st=HASH(0x890b144) 'syb_more_results' = undef
    <- FETCH= undef at Sybase.pm line 154
    <> DESTROY ignored for outer handle DBI::st=HASH(0x89a1798) (inner
DBI::st=HASH(0x890b144))
    -> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x890b144)~INNER)
    syb_st_finish() -> flushing
DBI handle cleared whilst still active at
/usr/local/lib/perl5/5.8.0/perl5db.pl line 1409.


Hope that helps...looks like something is going out of scope but how to
fix it...

Thanks,

Andrew
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.