Hi,
I'm running a hardware load balanced Radiator setup with multiple
Radiator back end servers. With the exception of a handful of
variables,each back end server runs an identical config file.
Accounting records are processed through the use of 3 <Handlers>, one
for start records, one for interim records and one for stop records.
The problem is that as any back end server can process an accounting
record, I'm getting loads of deadlock messages appearing in my
Radiator logs (see below). The example below is where I'm updating a
mysql record using info from a RADIUS interim packet.
The SessionDatabase config is
<SessionDatabase SQL>
Identifier Hull_Wired_Dot1x_Alive
DBSource dbi:mysql:radSupport:%{GlobalVar:accountingDb}:3306
DBUsername XXXXX
DBAuth YYYYYY
SQLRecoveryFile %L/wired-sqlfailures-%Y-%m-%d
## Timeout 0
## FailureBackoffTime 10
ReplaceQuery update RADONLINE set
TIME_STAMP_STR=current_timestamp, servicetype='Dot1x-
Alive',ACCTSESSTIME=%{Acct-Session-Time},ACCTINOCTETS=%{Acct-Input-
Octets},ACCTOUTOCTETS=%{Acct-Output-Octets} \
where IDENTIFIER='%{NAS-IP-Address}' and ACCTSESSIONID='%{Acct-
Session-Id}'
DeleteQuery
ClearNasQuery
</SessionDatabase>
Wed Jun 8 10:23:38 2011 922998: ERR: do failed for 'update RADONLINE
set
nasidentifier
='Trapeze',identifier='150.237.252.3',calling_station_id='58-1F-AA-C2-
EF-54', nasport='AP103/1',nasporttype='Wireless',servicetype='Trapeze-
Stop',username='lcs...@hull.ac.uk',
acctinoctets
=
4181
,acctoutoctets
=
18311
,authstatus='',time_stamp=1307525018,time_stamp_str=current_timestamp,
ACCTSESSIONID='SESS-24877-30e39b-524912-773' where
NASIDENTIFIER='Trapeze' and CALLING_STATION_ID=LOWER('58-1F-AA-C2-
EF-54') and ACCTSESSIONID='SESS-24877-30e39b-524912-773'': Deadlock
found when trying to get lock; try restarting transaction
I'm guessing I need to set auto commit somewhere for each of my
session database definitions... .
Is this doable?
Rgds
Alex
Checked by Hu-fw-yhman
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
