8 Dec
2005
8 Dec
'05
2:30 p.m.
"Sharma Raj" <Raj.Sharma@orange.ch> wrote:
In our setup of Radius, we use an Oracle database. Ordinarily, when NAS sends Accounting Start messages to Radius, Radius sends Update messages to Oracle. Periodically, something odd happens - Radius sends a Rollback message to Oracle which undoes the Update.
Maybe the UPDATE transaction fails, so that one update is being rolled back.
The Oracle DB listener trace for the first message shows the DML was received ok but the end of a trace shows a ROLLBACK (this undoes all the DMLs since the last COMMIT was sent). Details:
In sql_oracle.c, the sql_query function executes the UPDATE and commits it if it was OK, so any rollback should be confined to one update only. Alan DeKok.