Profile Manager duplicate key value violates unique constraint

Hi,

I have a big problem with my Profile Manager (Server 5.10, Catalina).

To the log I have (repeat x time each second...) :

0:: [303] [2022/01/20 14:17:50.209]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7f8136a92930> [channel: 'objc_send', message: '[LibraryItemMetadata parseAvailableOSUpdatesForLibraryItemMetadataID:72899]'].
    -[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)=(72899, 9064494) already exists.
    )"
1:: [303] [2022/01/20 14:17:50.210] EXCEPTION:  !IF <-[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'">
0:: [303] [2022/01/20 14:17:50.210] Caught unhandled exception -[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'"
0:: [303] [2022/01/20 14:17:50.210] Caught exception processing queued DB notification: -[PGConnection beginTransactionWithID:priority:perform:] (PGConnection.m:350): "'((_transactionAborted))'"
1:: [303] [2022/01/20 14:17:50.211] INVOKING [LibraryItemMetadata parseAvailableOSUpdatesForLibraryItemMetadataID: {"72899"}]
0:: [303] [2022/01/20 14:17:50.218] 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)=(72899, 9064495) 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)=(72899, 9064495) already exists.\n";
    }

I don't understand why. Ref for device_id is 72899. Where I can find device_id in my Profile Manager?

The message like logs files.... :

Posted on Jan 20, 2022 5:35 AM

Similar questions

3 replies

Graphiz Author

Level 1

21 points

Jan 20, 2022 8:46 AM in response to Graphiz

Find solution :

Find the device, backup database :

sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/pg_dump -h /Library/Server/ProfileManager/Config/var/PostgreSQL -U _devicemgr devicemgr_v2m0 -c -f /tmp/device_manageme.sql

Open the backup file and find the device_id (look to the logs) to see the name of device.

Remove it from the MDM.

Feb 7, 2022 6:52 AM in response to Graphiz

I have this exact same issue with the same server hardware and software version. I have removed the offending machine from the MDM, however the issue remains, it seems to jump to another device_id.

If I carry on down this road, soon I won’t have any machines left in the MDM

Graphiz Author

Level 1

21 points

Feb 9, 2022 1:47 PM in response to AppleGrapple

Almost all computers from MDM have lost their profiles.

Cause : 1 computer upgrade from Catalina to Monterey.

It is a big problem that all profiles of all computers can disappear. This is not serious Apple.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Profile Manager duplicate key value violates unique constraint