Profile Manager - Don't push profile and Postgres error
Hi,
My profile manager doesn't push profiles on my machines anymore. To summarize, I have 100 MBP in a DEP, which are in my profile manager.
At the beginning, no problem, the machines were registering and getting the profiles. Towards the end, of was not the case any more, only the management profile is installed and that's all.
macOS 10.15.6
server 5.10
In the logs devicemgrd.log, there is the message below in a loop. This fills the logs and will create a lot of archive files and since 2 weeks.
0:: [278] [2020/09/10 16:05:30.283] Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7ffd80448d40> [channel: 'objc_send', message: '[LibraryItemMetadata parseAvailableOSUpdatesForLibraryItemMetadataID:72886]'].
-[PGConnection executeSQL:withParams:] (PGConnection.m:628): "Postgres error 23505 (ERROR: duplicate key value violates unique constraint "os_updates_devices_device_id_os_update_id_key"
DETAIL: Key (device_id, os_update_id)=(72886, 48) already exists.
)"
1:: [278] [2020/09/10 16:05:30.284] EXCEPTION: !IF <-[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'">
0:: [278] [2020/09/10 16:05:30.284] Caught unhandled exception -[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'"
0:: [278] [2020/09/10 16:05:30.284] Caught exception processing queued DB notification: -[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'"
1:: [278] [2020/09/10 16:05:30.285] INVOKING [LibraryItemMetadata parseAvailableOSUpdatesForLibraryItemMetadataID: {"72886"}]
0:: [278] [2020/09/10 16:05:30.290] EXCEPTION: Postgres <-[PGConnection executeSQL:withParams:] (PGConnection.m:628): "Postgres error 23505 (ERROR: duplicate key value violates unique constraint "os_updates_devices_device_id_os_update_id_key"
DETAIL: Key (device_id, os_update_id)=(72886, 48) already exists.
)">
USERINFO: {
SQLSTATE = 23505;
errorMessage = "ERROR: duplicate key value violates unique constraint \"os_updates_devices_device_id_os_update_id_key\"\nDETAIL: Key (device_id, os_update_id)=(72886, 48) already exists.\n";
}