Duplicate RADIUS accounting, same everything except radacctid

[Alan DeKok]

On Aug 13, 2018, at 5:13 PM, Michael Ducharme <mducharme at gmail.com> wrote:
> We have a FreeRADIUS 3.0.15 server on CentOS providing authentication for PPPoE. Very occasionally we are getting a couple random duplicate records in the radacct table. It happens a few times a month. We have about 600 customers total, and an interim-update of 30 minutes configured on our NAS, so there are many updates that are working and only a few strange and occasional exceptions that are not.
> 
> Below is an example of one such duplication (with information redacted). I checked the accounting text log in /var/log/radius/radacct/nasip and I see no duplication in that file for the same record shown below, it only appears once (it is an Interim-Update). Any ideas as to what the problem might be and how to fix it?

  If you have the correct indexes on the tables, then it *cannot* insert two rows with the sam Acct-Unique-ID.

  Alan DeKok.