Duplicate Accounting maybe once, twice a day

[Marius Pesé]

Hi everyone,

we are having an issue on our FreeRadius setup where our redundant servers will maybe once, twice a day create duplicate accounting entries.
I have switched the servers to debug for a full day and caught one of these incidents in the log file, see attached.

The strange thing is it only happens maybe once a day, regardless of realm or user, and the other couple of hundred accounting requests are fine.
Can anyone see why this particular one would bounce back and forth?

Our setup consists of two virtually identical FreeRadius2 servers, each with their own mySQL database, so each of them is capable of doing Auth and Acct, and proxies Acct to the other one.
Also I changed the acct_update_alt query to write to a failover table since I thought this was the alt query being triggered, but this does not make a difference. Still duplicates in radacct table.

Thanks!
Marius

__________________________________________
Marius Pesé
Senior Software Developer
B.Sc. Computer Science
[cid:image003.jpg at 01CBF85B.77F8AF50]<http://www.mindspring.co.za/>
Unit 5, Doncaster Office Park    Mindspring Computing
Punters Way, Kenilworth           P O Box 46926
Cape Town, South Africa           Glosderry 7702
Phone: +27 21 657 1780          Fax   : +27 21 671 7599
Cell : 072 100 70 73
E-mail: marius at mindspring.co.za<mailto:marius at mindspring.co.za>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110411/f0c34928/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 4708 bytes
Desc: image003.jpg
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110411/f0c34928/attachment.jpg>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dublette.txt
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110411/f0c34928/attachment.txt>