Duplicate RADIUS accounting, same everything except radacctid

[Michael Ducharme]

Hi Alan, thanks, we figured that out yesterday morning - the table was for
some reason missing the UNIQUE constraint for the key acctuniqueid. We had
to craft a DELETE to get rid of the duplicate data and then corrected the
constraint.

On Wed, Aug 15, 2018 at 6:19 AM Alan DeKok <aland at deployingradius.com>
wrote:

> 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.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html