(RADIATOR) ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute/Describe)

[daniel.teran at es.jazztel.com]

Hello everybody,

I've got the same error for ages. It happens when Radiator is (re)started
and tries to
query BD for the first-second time. For example:

Thu May  3 19:46:50 2001: INFO: Server started: Radiator 2.17.1 on elektra.jazzlab.com
Thu May  3 19:47:49 2001: DEBUG: Reclaiming expired leases
Thu May  3 19:47:49 2001: DEBUG: do query is: update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912069

Thu May  3 19:47:49 2001: ERR: do failed for 'update RADPOOL set STATE=0 where state!=0 and EXPIRY
< 988912069': ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute)
Thu May  3 19:48:49 2001: DEBUG: Reclaiming expired leases
Thu May  3 19:48:49 2001: DEBUG: do query is: update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912129

Thu May  3 19:49:49 2001: DEBUG: Reclaiming expired leases
Thu May  3 19:49:49 2001: DEBUG: do query is: update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912189

Thu May  3 19:50:11 2001: DEBUG: Packet dump:
*** Received from 10.9.10.200 port 49152 ....
Code:       Access-Request
Identifier: 9
Authentic:  <233><174>&H<10><153><3>%<167>]<5>C<136><236>#3
Attributes:
        User-Name = "usuario1isp at clienteisp"
        CHAP-Password = "<1><241><237>ow<189><248>KO<127>G5<194>mB<244><200>"
        Acct-Session-Id = "42000058"
        NAS-IP-Address = x.x.x.x
        Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(14)"
        Service-Type = Framed-User
        Framed-Protocol = PPP
        Calling-Station-Id = "9xxxxxxxx"
        Called-Station-Id = "9xxxxxxxx"

Thu May  3 19:50:11 2001: DEBUG: Rewrote user name to usuario1isp at clienteisp
Thu May  3 19:50:11 2001: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu May  3 19:50:11 2001: DEBUG: SDB1 Deleting session for usuario1isp at clienteisp, x.x.x.x,
Thu May  3 19:50:11 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='x.x.x.x' and
     ACCTSESSIONID='42000058'

Thu May  3 19:50:11 2001: ERR: do failed for 'delete from RADONLINE where NASIDENTIFIER='x.x.x.x'
and ACCTSESSIONID='42000058'': ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute)

----------------------------...--------------------------

My scenario: Radiator 2.17.1 in Linux (2.2.14 or 2.4.1) and Oracle 8.1.6 in
Linux 2.4.1(PC) or Solaris 2.6 (Ultra-60).

I think it's a problem related with SQL Oracle Libraries but it only
happens at the beginning (not after) and it
seems not to be serious.

Bye,

Daniel.






===
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.