Problem Note 67789: Instances of "...duplicate key value violates unique constraint..." errors occur in the SAS® Web Infrastructure Platform Database log file
In the SAS Web Infrastructure Platform Database log file, you might see errors like the following:
2021-04-09 06:14:49.008 EDTDETAIL: Key ("timestamp", measurement_id)=(1617963000000, 25458) already exists.
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (25458, 1617963000000, 0.00000)
2021-04-09 06:14:49.008 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
2021-04-09 06:14:49.008 EDTDETAIL: Key ("timestamp", measurement_id)=(1617963000000, 23796) already exists.
2021-04-09 06:14:49.008 EDTSTATEMENT: INSERT INTO HQ_METRIC_DATA_7D_0S (measurement_id, timestamp, value) VALUES (23796, 1617963000000, 0.24998)
2021-04-09 06:14:49.009 EDTERROR: duplicate key value violates unique constraint "hq_metric_data_7d_0s_pkey"
The errors are related to SAS® Environment Manager and can be ignored.
Operating System and Release Information
| SAS System | SAS Environment Manager | Microsoft® Windows® for x64 | | |
| 64-bit Enabled AIX | | |
| 64-bit Enabled Solaris | | |
| HP-UX IPF | | |
| Linux for x64 | | |
| Solaris for x64 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-04-15 15:36:35 |
| Date Created: | 2021-04-15 13:11:46 |