Question: Profilel Manager DB error 23505
Hi All!
Got some issues in our Profile Manager database, the devicemgr.log keeps getting 10MB in just a couple of minutes and then it archives and keep filling up the disk. The error in log file is:
:: [344] [2020/04/20 08:03:59.022] Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7ff211f72b20> [channel: 'objc_send', message: '[LibraryItemMetadata parseAvailableOSUpdatesForLibraryItemMetadataID:6134]']. -[PGConnection executeSQL:withParams:] (/Library/Caches/com.apple.xbs/Sources/RemoteDeviceManagement/RemoteDeviceManagement-920.37/Compiled/Framework-Models/Postgres/PGConnection.m:626): "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)=(6134, 215) already exists.)"
1:: [344] [2020/04/20 08:03:59.023] EXCEPTION: !IF <-[PGConnection beginTransactionWithID:priority:perform:] (/Library/Caches/com.apple.xbs/Sources/RemoteDeviceManagement/RemoteDeviceManagement-920.37/Compiled/Framework-Models/Postgres/PGConnection.m:352): "'((_transactionAborted))'">
0:: [344] [2020/04/20 08:03:59.023] Caught unhandled exception -[PGConnection beginTransactionWithID:priority:perform:] (/Library/Caches/com.apple.xbs/Sources/RemoteDeviceManagement/RemoteDeviceManagement-920.37/Compiled/Framework-Models/Postgres/PGConnection.m:352): "'((_transactionAborted))'"
0:: [344] [2020/04/20 08:03:59.023] Caught exception processing queued DB notification: -[PGConnection beginTransactionWithID:priority:perform:] (/Library/Caches/com.apple.xbs/Sources/RemoteDeviceManagement/RemoteDeviceManagement-920.37/Compiled/Framework-Models/Postgres/PGConnection.m:352): "'((_transactionAborted))'"
It seem like the os_update_id 215 is the one that is causing something. Tried removing all lines in os_updates_device but nothing happened. If I remove the device_id from Profile Manager, the logfile changes device_id to a new one. I can keep removing/reverting to placeholder and it will change device_id but I do not know how many devices I need to remove before it will solve itself.
Any suggestions what could be causing the issue? Had this once before but it solved when removing one object, but not this time.
Regards
Michael