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@deployingradius.com> wrote:
On Aug 13, 2018, at 5:13 PM, Michael Ducharme <mducharme@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