...
To resolve this problem, edit the original license server in License Statistics and merge it with the duplicated license server as described in "Merging server data" in Combining duplicate license servers under a single server.
...
Inability to update UsersCount table (duplicate entry error)
A bug introduced in an older version of License Statistics can result in the database index being prematurely exhausted if License Statistics is restarted too often. In such cases, there will be a problem updating the UsersCount table and you will see one or both of the following MySQL errors in the License Statistics log:
...
- Shut down License Statistics.
- Backup your data for the affected UsersCount table using the following SQL command (we will use the UsersCount table for this example):
SELECT Date, Total, DailyUsers, Hosts INTO OUTFILE 'userscount.dump' FROM UsersCount;
- After successful backup, truncate the data and reset the index:
TRUNCATE UsersCount;
ALTER TABLE UsersCount AUTO_INCREMENT = 1; - Restore the data:
LOAD DATA INFILE 'userscount.dump' INTO TABLE UsersCount (Date, Total, DailyUsers, Hosts); - Restart License Statistics.
...