devicemgrd null ptr error loop causing high cpu load.

Question

Level 1

0 points

devicemgrd null ptr error loop causing high cpu load.

I've got a Mac Mini running Mavericks and Server 3, upgraded this morning. The install and migration appeared to run perfectly flawless (which it's never done before). After a couple reboots, I became worried about the fan which was still pegged on high. Activity Monitor reported that `devicemgrd` was consuming around 250% cpu. I got into Server.app and toggled Profile Manager off, which did nothing for devicemgrd. I killed the process in Activity Monitor, and the CPU usage died down and the fan calmed. After toggling Profile Manager back on, the CPU again shot up to fluctuate between 150% and 250%, devicemgrd being the culprit again.

Here are some log entries relevant to the issue:

/var/log/system.log:

Oct 23 08:44:51 stage devicemgrd[10507]: NSURLConnection/CFURLConnection HTTP load failed (kCFStreamErrorDomainSSL, -9843)
Oct 23 08:44:51 stage servermgrd[1364]: NSURLConnection/CFURLConnection HTTP load failed (kCFStreamErrorDomainSSL, -9843)
Oct 23 08:44:55 --- last message repeated 1 time ---

repeating, seemingly forever. "Security/SecureTransport.h", line 258 (MacOS10.9 SDK) claims that Code -9843 is: "errSSLHostNameMismatch = -9843, /* peer host name mismatch */"

/Library/Logs/ProfileManager/devicemgrd.log:

[7339] [2013/10/23 10:30:36.451] -[SULogFileCollection setGlobalLogLevelPrefix:]: YES
0:: [7339] [2013/10/23 10:30:36.453]
    ############################################################################
    devicemgrd-848.17 (PID:7339, OS:13A603, SERVER:13S440, ARCH:x86_64) starting
    LA: devicemgrd
    Log verbosity level = 1
    UID = 220, EUID = 220
    ############################################################################
0:: [7339] [2013/10/23 10:30:36.666] +[PGConnection reloadPreferences]: DBDebug = NO, DBLogNotices = NO, DBLogSQL = NO, DBMonitor = NO
0:: [7339] [2013/10/23 10:30:37.181] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.183] Profile Manager service STOPPED
0:: [7339] [2013/10/23 10:30:37.183] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.185] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.185]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb70ba03dc0> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.186] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.188] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.190] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.190]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb70970c540> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.191] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
1:: [7339] [2013/10/23 10:30:37.192] Incoming request: readSettings
0:: [7339] [2013/10/23 10:30:37.193] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.194] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.194]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb7094295b0> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.195] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.196] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.198] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.198]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb70970dff0> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.199] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.200] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.201] Registering for network reachability notifications to "gateway.push.apple.com".
1:: [7339] [2013/10/23 10:30:37.202] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.202]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb7097278e0> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.204] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.204] APNS topic = com.apple.mgmt.XServer.a26a4f58-983e-4371-9bfd-0ca50ed2c509
0:: [7339] [2013/10/23 10:30:37.205] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }
1:: [7339] [2013/10/23 10:30:37.207] -[NSException(devicemgr_Additions) error]: No error set for exception: -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
    ? | 140735560719989
    ? | 4360259180
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
0:: [7339] [2013/10/23 10:30:37.207]  Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fb70970dff0> [channel: 'objc_send', message: '[DMDevicemgrd updateAllProfilesForID:5]']. -[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL"
0:: [7339] [2013/10/23 10:30:37.208] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
0:: [7339] [2013/10/23 10:30:37.209] EXCEPTION:  NullPtr <-[PGDatabaseNotification sendToPayloadTargetInTransaction] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Framework-Models/Postgres/PGDatabaseNotification.m:150): "'((m = class_getInstanceMethod(t, s)))' is NULL">
    BACKTRACE: {
    ? | 4362365675
    ? | 4362406189
    ? | 4362403886
    ? | 4362522118
    ? | 4362403429
    ? | 140735534645333
    ? | 140735534511505
    ? | 140735534510651
    ? | 140735426040493
    ? | 140735426049679
    ? | 140735426054621
    ? | 140735426047907
    ? | 140735426052499
    ? | 140735497428728
    ? | 140735497441209
    }

again, repeating seemingly forever, and fast. This has the most noise, revealing this error: "((m = class_getInstanceMethod(t, s)))' is NULL". New exceptions get written to the file every few milliseconds or so. Running devicemgrd in this state for about 1 hour resulted in a 2.28 Gigabyte uncompressed logfile.

/Library/Logs/ProfileManager/PostgreSQL-2013-10-23.log: (today's date)

2013-10-23 09:17:58 MDTLOG:  database system was shut down at 2013-10-23 09:16:40 MDT
2013-10-23 09:17:58 MDTLOG:  autovacuum launcher started
2013-10-23 09:17:58 MDTLOG:  database system is ready to accept connections
2013-10-23 09:17:58 MDTLOG:  connection received: host=[local]
2013-10-23 09:17:58 MDTLOG:  connection authorized: user=_devicemgr database=template1
2013-10-23 09:17:58 MDTLOG:  connection received: host=[local]
2013-10-23 09:17:58 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:17:59 MDTLOG:  connection received: host=[local]
2013-10-23 09:17:59 MDTLOG:  replication connection authorized: user=_devicemgr
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "users" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:02 MDTLOG:  statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "media" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2013-10-23 09:18:03 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:03 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:03 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:03 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:03 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:03 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:03 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3857-2" ("value" varchar UNIQUE)
2013-10-23 09:18:03 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:03 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:03 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3861-2" ("value" varchar UNIQUE)
2013-10-23 09:18:04 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3869-2" ("value" varchar UNIQUE)
2013-10-23 09:18:04 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3869-5" ("value" varchar UNIQUE)
2013-10-23 09:18:04 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3876-2" ("value" varchar UNIQUE)
2013-10-23 09:18:04 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3876-5" ("value" varchar UNIQUE)
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3876-2"
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3876-5"
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3861-2"
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3869-2"
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3857-2"
2013-10-23 09:18:04 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3869-5"
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTLOG:  connection received: host=[local]
2013-10-23 09:18:19 MDTLOG:  connection authorized: user=_devicemgr database=devicemgr_v2m0
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.636912', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: | 
            [***REMOVED***]
 

          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.637496', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.761528', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.762069', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]

 
          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.762103', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.775118', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.803989', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.818087', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "server_organization" = NULL, "updated_at" = '2013-10-23 15:18:19.886453', "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:19 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:19 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:20 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:20 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:21 MDTERROR:  could not serialize access due to concurrent update
2013-10-23 09:18:21 MDTSTATEMENT:  UPDATE "settings" SET "knob_sets_enabled" = '---
        com.apple.carddav.account: 0
        ._com.apple.carddav.account: BOOLEAN
        com.apple.caldav.account: 0
        ._com.apple.caldav.account: BOOLEAN
        ', "trust_payloads" = '---
        ssl_trust_payload:
          PayloadVersion: 1
          PayloadDisplayName: "Root certificate for "
          PayloadIdentifier: com.apple.ssl.certificate
          PayloadType: com.apple.security.root
          PayloadContent: |
            [***REMOVED***]


          PayloadDescription: Installs the Root certificate for .
          PayloadUUID: C772D490-BEA3-4A99-9D09-05A14FD89452
        ' WHERE "id" = 1
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3943-2" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3949-2" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3960-2" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3960-5" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3962-2" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-3962-5" ("value" varchar UNIQUE)
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3960-5"
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3962-2"
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3962-5"
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3949-2"
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3960-2"
2013-10-23 09:18:35 MDTLOG:  statement: DROP TABLE "__runtime_temp_devicemgrd-3943-2"
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "users" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  connection received: host=[local]
2013-10-23 09:25:04 MDTLOG:  connection authorized: user=_devicemgr database=postgres
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2013-10-23 09:25:04 MDTLOG:  statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "media" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2013-10-23 09:25:05 MDTLOG:  unexpected EOF on client connection with an open transaction
2013-10-23 09:25:05 MDTLOG:  received smart shutdown request
2013-10-23 09:25:05 MDTLOG:  autovacuum launcher shutting down
2013-10-23 09:25:05 MDTLOG:  shutting down
2013-10-23 09:25:05 MDTLOG:  database system is shut down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000005' ... '/Library/Server/ProfileManager/Data/backup/000000010000000000000005'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/000000010000000000000005' --> '/Library/Server/ProfileManager/Data/backup/000000010000000000000005'

This log file is from between one reboot to the other lasting about 7 minutes. The Payload data is the base64 encoded x509 public key of the server, repeated over and over again.

Regarding the hostname mismatch, I don't think that's an issue, since running `hostname` reports the CommonName of the server's public key. It's a StartCom Class 1 Server certificate issued by "StartCom Class 1 Primary Intermediate Server CA".

I've chmodded the executable "/Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/devicemgrd" to 400 for the time being to prevent the server from melting (it was reporting up to 90ºC at the exhaust vent). Seeing as I use Profile Manager, I'd like to resolve this issue (I say this because a couple other threads suggest disabling profile manager as a solution).

Does anyone have any suggestions as to the cause, or any possible solutions?

Thank you.

Mac mini, OS X Server

Posted on Oct 23, 2013 11:34 AM

Reply

Answer 1

Mar 14, 2016 2:59 AM in response to Bosco1983

Thinking about the "active tasks" and clearing them out.... wouldnt it be normal to have a lot of active / pending tasks?

For example, if say 100 students login to computers, they will each bring a profile down from Profile Manager, which then links to their USER group and will also pull down a MACHINE level profile.

If I make a change to lets say the MACHINE level profile, this would then trigger 100 pending updates (assuming each user only signed in to one machine). Until the same user signed in to the same machine, this active task would still be pending.

Clearning these out would mean that the profile would not sync, and the user would be getting the old profile settings.

To force a re-check of profiles, one would need to edit a profile and re-save it to push out the settings which would then update the users and devices/machine profiles.

So to cut some waffle, I would say its normal to have lots of active tasks - certainly in a school environment where there are lots of different users logging in to different machines.

Reply

Answer 2

Mar 14, 2016 4:37 AM in response to Bosco1983

EDIT - adding the miliseconds resulted in the same error

Reply

Answer 3

Mar 15, 2016 11:11 AM in response to Hplogsdon

I still have the same problem after running the command. I wonder if the problem is related to the number of devices or users in Profile Manager?

I have 1800 iPads and 2400 users loaded.

Reply

Answer 4

Mar 16, 2016 2:18 AM in response to betolley1

I have around 1000 users, 400 iPads and 200 Macs/Macbooks and im having the same issue.

UPDATE:

I was running the command incorrectly and have just figured out how to run it. Ive updated my devices table and i'll see how I get on.

I had to run the command in 2 halves for anyone else thats struggling:

Firstly run this half:

sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL

which then allows you to run commands as the devicemgr user on the devicemgr_v2m0 database

then run the second half as follows

UPDATE devices SET first_push_time = '2015-12-12 00:00:00';

Reply