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

[Mariano Absatz]

Hi,

Daniel seems to be right... it only happens "in the beginning", i.e. when 
you try to access de DB for the first time after Radiator starts... that 
explains my "kill -HUP" errors the other day, since I wasn't doing 
anything at all, the "kill -HUP" was the frist access to the DB.


El 9 May 2001, a las 9:55, daniel.teran at es.jazztel.com escribió:

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


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