Hplogsdon

Q: 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

Close

Q: devicemgrd null ptr error loop causing high cpu load.

  • All replies
  • Helpful answers

Previous Page 2 of 7 last Next
  • by Hplogsdon,

    Hplogsdon Hplogsdon Oct 24, 2013 10:36 AM in response to mscott_mdm
    Level 1 (0 points)
    Oct 24, 2013 10:36 AM in response to mscott_mdm

    So, that seemed to work. I received 5 log messages in /var/log/system.log pertaining to devicemgrd after running it, but it doesn't look like it was anything to worry about:

     

     

    Oct 23 12:48:31 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd[20385]): Job failed to exec(3) for weird reason: 13

    Oct 23 12:48:31 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd): Throttling respawn: Will start in 10 seconds

    Oct 23 12:48:41 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd[20399]): Job failed to exec(3) for weird reason: 13

    Oct 23 12:48:41 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd): Throttling respawn: Will start in 10 seconds

    Oct 23 12:48:51 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd[20410]): Job failed to exec(3) for weird reason: 13

    Oct 23 12:48:51 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd): Throttling respawn: Will start in 10 seconds

    Oct 23 12:49:01 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd[20421]): Job failed to exec(3) for weird reason: 13

    Oct 23 12:49:01 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd): Throttling respawn: Will start in 10 seconds

    Oct 23 12:49:11 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd[20432]): Job failed to exec(3) for weird reason: 13

    Oct 23 12:49:11 server com.apple.launchd[1] (com.apple.DeviceManagement.devicemgrd): Throttling respawn: Will start in 10 seconds

     

     

     

    var/log/devicemgr/devicemgrd.log appears clean with normal entries. CPU usage seems normal so far, but I'll keep an eye out if FortKnUX is still seeing issues.

  • by mscott_mdm,

    mscott_mdm mscott_mdm Oct 24, 2013 10:42 AM in response to FortKnUX
    Level 2 (225 points)
    Oct 24, 2013 10:42 AM in response to FortKnUX

    OK, FortKnUX, can you paste the output of the following TWO commands:

     

    sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/psql -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "SELECT id, name, uuid, version, library_item_id, library_item_type FROM profiles WHERE library_item_id = 13;"

     

    sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/psql -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "SELECT * FROM library_items WHERE id = 13;"

  • by FortKnUX,

    FortKnUX FortKnUX Oct 24, 2013 10:53 AM in response to mscott_mdm
    Level 1 (17 points)
    Oct 24, 2013 10:53 AM in response to mscott_mdm

    I think it's good now, the first command shows 0 rows.

     

    I think the reason it didn't work the first time is that I deleted the row after killing devicemgr process and when I rebooted the server the messages came back. This time I deleted the row while the process was running and seems now stable even after reobooting the server.

  • by mscott_mdm,

    mscott_mdm mscott_mdm Oct 24, 2013 11:11 AM in response to amt60
    Level 2 (225 points)
    Oct 24, 2013 11:11 AM in response to amt60

    The following should fix this once and for all. First, you need to start a psql session with the Profile Manager database. In Terminal on your server, copy and paste this command (it's all one line):

     

     

    sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/psql -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL

     

     

    You should see a prompt like this:

     

    devicemgr_v2m0=#

     

    Now, paste the lines below into the psql session:

     

     

    CREATE OR REPLACE FUNCTION dm_deferred_remove_profile_from_all_targets(profile profiles) RETURNS void LANGUAGE plpgsql AS $$

    <<fn>>

    BEGIN

      IF profile.is_a_la_carte IS NOT TRUE AND profile.library_item_id IS NOT NULL AND profile.library_item_type IS NOT NULL THEN

        PERFORM _dm_objc_send(format('[DMDevicemgrd updateAllProfilesFor%sID:%s]', profile.library_item_type, profile.library_item_id));

      END IF;

      RETURN;

    END

    $$;

    DELETE FROM db_notifications WHERE message LIKE '[DMDevicemgrd updateAllProfilesForID:%';

    \q

     

     

    Your output should look something like this:

     

    devicemgr_v2m0=# CREATE OR REPLACE FUNCTION dm_deferred_remove_profile_from_all_targets(profile profiles) RETURNS void LANGUAGE plpgsql AS $$

    devicemgr_v2m0$# <<fn>>

    devicemgr_v2m0$# BEGIN

    devicemgr_v2m0$#   IF profile.is_a_la_carte IS NOT TRUE AND profile.library_item_id IS NOT NULL AND profile.library_item_type IS NOT NULL THEN

    devicemgr_v2m0$#     PERFORM _dm_objc_send(format('[DMDevicemgrd updateAllProfilesFor%sID:%s]', profile.library_item_type, profile.library_item_id));

    devicemgr_v2m0$#   END IF;

    devicemgr_v2m0$#

    devicemgr_v2m0$#   RETURN;

    devicemgr_v2m0$# END

    devicemgr_v2m0$# $$;

    CREATE FUNCTION

    devicemgr_v2m0=# DELETE FROM db_notifications WHERE message LIKE '[DMDevicemgrd updateAllProfilesForID:%';

    DELETE 0

    devicemgr_v2m0=# \q

     

     

    In particular, make sure you see the "CREATE FUNCTION" and "DELETE x" lines (highlighted above, but your DELETE will probably show x > 0).

     

    After doing this, you will probably want to restart devicemgrd so your monsterous log file gets rolled and compressed.

     

    sudo killall devicemgrd

     

    If you wish to delete the compressed log file(s) to recover the space, this should do the trick:

     

    sudo rm -f /Library/Logs/ProfileManager/devicemgrd-*.log.bz2

    Note that it might take some time for devicemgrd to start back up, especially if you've turned off Profile Manager. The easiest way to make sure it's started is to toggle Profile Manager off and back on in Server.app.

  • by FortKnUX,

    FortKnUX FortKnUX Oct 24, 2013 11:24 AM in response to mscott_mdm
    Level 1 (17 points)
    Oct 24, 2013 11:24 AM in response to mscott_mdm

    I get error "could not save history to file "/var/empty/.psql_history": Permission denied" (see below) but that's probably fine in my case since the x=0.

     

    # sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/psql -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL

    psql (9.2.4)

    Type "help" for help.

     

     

    devicemgr_v2m0=# CREATE OR REPLACE FUNCTION dm_deferred_remove_profile_from_all_targets(profile profiles) RETURNS void LANGUAGE plpgsql AS $$

    devicemgr_v2m0$# <<fn>>

    devicemgr_v2m0$# BEGIN

    devicemgr_v2m0$#   IF profile.is_a_la_carte IS NOT TRUE AND profile.library_item_id IS NOT NULL AND profile.library_item_type IS NOT NULL THEN

    devicemgr_v2m0$#     PERFORM _dm_objc_send(format('[DMDevicemgrd updateAllProfilesFor%sID:%s]', profile.library_item_type, profile.library_item_id));

    devicemgr_v2m0$#   END IF;

    devicemgr_v2m0$#   RETURN;

    devicemgr_v2m0$# END

    devicemgr_v2m0$# $$;

    CREATE FUNCTION

    devicemgr_v2m0=# DELETE FROM db_notifications WHERE message LIKE '[DMDevicemgrd updateAllProfilesForID:%';

    DELETE 0

    devicemgr_v2m0=# \q

    could not save history to file "/var/empty/.psql_history": Permission denied

    #

  • by mscott_mdm,

    mscott_mdm mscott_mdm Oct 24, 2013 11:27 AM in response to FortKnUX
    Level 2 (225 points)
    Oct 24, 2013 11:27 AM in response to FortKnUX

    Yes, the "could not save history to file..." is because the _devicemgr user does not have a home directory. You can safely ignore that. Since you got a "DELETE 0", it does sound like the first command I gave did fix the underlying problem, but devicemgrd might have been in a state where it didn't notice.

     

    Please reply on this thread if you have any futher problems with this issue. Thanks for your help!

  • by Hplogsdon,

    Hplogsdon Hplogsdon Oct 24, 2013 11:29 AM in response to mscott_mdm
    Level 1 (0 points)
    Oct 24, 2013 11:29 AM in response to mscott_mdm

    Awesome. Thanks for your help mscott_mdm. I really appreciate it.

  • by amt60,

    amt60 amt60 Oct 24, 2013 1:27 PM in response to mscott_mdm
    Level 1 (5 points)
    Oct 24, 2013 1:27 PM in response to mscott_mdm

    Thanks, mscott_mdm.

     

    Your statements fixed my issue with the task devicemgrd.

     

    Is it possible to get a little bit more background what has happend in the database?

  • by mscott_mdm,

    mscott_mdm mscott_mdm Oct 24, 2013 2:00 PM in response to amt60
    Level 2 (225 points)
    Oct 24, 2013 2:00 PM in response to amt60

    I don't really know for sure what happened, but it appears that there was an issue with the upgrade from the earlier server that left some bad data in one table, although the data it originated from had either been fixed or deleted shortly afterwards. (That's why the test queries I asked you to run did not return any rows.)

  • by Cysis,

    Cysis Cysis Oct 24, 2013 8:22 PM in response to mscott_mdm
    Level 1 (0 points)
    Oct 24, 2013 8:22 PM in response to mscott_mdm

    I followed this and my tasks are looking calm and stable.  Thanks for the help mscott

  • by jparryuk,

    jparryuk jparryuk Oct 25, 2013 2:23 AM in response to mscott_mdm
    Level 1 (0 points)
    Oct 25, 2013 2:23 AM in response to mscott_mdm

    Hi,

     

    We have a Mac Mini running OS X Server Mavericks 3 that we use to manage our company iPhones.  We found a bug in the last version that meant we couldn't change the users on the device as it was being cached (thats another story!) so we decided to upgrade to v3 yesterday, which is when the issues began.

     

    We experienced the exact same issues as everyone else and we basically had a bricked Mini on our hands, so we decided to follow mscott_mdm's suggestions and it has completley fixed our issues!

     

    Massive thankyou to mscott_mdm, you just saved us!

     

    I hope other OS X Server 3 users find this thread.

  • by misterhyde,

    misterhyde misterhyde Oct 25, 2013 4:25 AM in response to jparryuk
    Level 1 (0 points)
    Oct 25, 2013 4:25 AM in response to jparryuk

    Worked for my Mac Mini 2010 as well !!!

    Thanks a lot mscott_mdm !!!!!!

  • by wolfgang66,

    wolfgang66 wolfgang66 Oct 25, 2013 4:47 AM in response to mscott_mdm
    Level 1 (5 points)
    iPhone
    Oct 25, 2013 4:47 AM in response to mscott_mdm

    Worked here as well. Thanks!

  • by Mr. Z.,

    Mr. Z. Mr. Z. Oct 25, 2013 5:06 AM in response to mscott_mdm
    Level 1 (0 points)
    Oct 25, 2013 5:06 AM in response to mscott_mdm

    I also have tried this, after reinstalling Mavericks and Mavericks Server again.

    Again, devicemgrd got a hickup, but after applying your commands it is running smoothly.


    But now postgresql cannot start:

     

    2013-10-25 13:56:33 CESTLOG:  startup process (PID 3102) was terminated by signal 6: Abort trap

    2013-10-25 13:56:33 CESTLOG:  aborting startup due to startup process failure

    2013-10-25 13:56:43 CESTLOG:  database system was interrupted; last known up at 2013-10-16 21:02:45 CEST

    2013-10-25 13:56:43 CESTLOG:  record with zero length at 0/1B05AF70

    2013-10-25 13:56:43 CESTLOG:  invalid primary checkpoint record

    2013-10-25 13:56:43 CESTLOG:  record with zero length at 0/1B05AF10

    2013-10-25 13:56:43 CESTLOG:  invalid secondary checkpoint record

    2013-10-25 13:56:43 CESTPANIC:  could not locate a valid checkpoint record

     

    As the launchdaemon still tries to start postgres every ten seconds, I stopped it.

     

    This is what I have done before in order to get the devicemgrd back to normal operation

    -- note the difference at the DELETE line to your example.

     

    sh-3.2# sudo -u _devicemgr /Applications/Server.app/Contents/ServerRoot/usr/bin/psql -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL

    could not identify current directory: Permission denied

    could not identify current directory: Permission denied

    psql (9.2.4)

    Type "help" for help.

     

     

    devicemgr_v2m0=# CREATE OR REPLACE FUNCTION dm_deferred_remove_profile_from_all_targets(profile profiles) RETURNS void LANGUAGE plpgsql AS $$

    devicemgr_v2m0$# <<fn>>

    devicemgr_v2m0$# BEGIN

    devicemgr_v2m0$#   IF profile.is_a_la_carte IS NOT TRUE AND profile.library_item_id IS NOT NULL AND profile.library_item_type IS NOT NULL THEN

    devicemgr_v2m0$#     PERFORM _dm_objc_send(format('[DMDevicemgrd updateAllProfilesFor%sID:%s]', profile.library_item_type, profile.library_item_id));

    devicemgr_v2m0$#   END IF;

    devicemgr_v2m0$#   RETURN;

    devicemgr_v2m0$# END

    devicemgr_v2m0$# $$;

    CREATE FUNCTION

    devicemgr_v2m0=# DELETE FROM db_notifications WHERE message LIKE '[DMDevicemgrd updateAllProfilesForID:%';

    DELETE 1

    devicemgr_v2m0=# \q

    could not save history to file "/var/empty/.psql_history": Permission denied

    sh-3.2# sudo killall devicemgrd

     

    ----

     

    Interestingly, although postgresql cant start up, the Profilemanager is running still. So I opened it and found one device beeing grayed out. I deleted it, but that did not help.

     

    So, what should I try now? I have found a hint, which tells me, to reset the write-ahead log

    using  pg_resetxlog. Is this the right thing to do? If so, how can I apply it?

    I dont know the path to the data base files.

     

    Can you help?

     

    Thanks in advance,

     

    Mr. Z.

  • by mscott_mdm,

    mscott_mdm mscott_mdm Oct 25, 2013 7:27 AM in response to Mr. Z.
    Level 2 (225 points)
    Oct 25, 2013 7:27 AM in response to Mr. Z.

    Mr. Z.,

     

    The postgres messages you're seeing are not coming from the Profile Manager postgres database. If that were failing to start, you would be unable to do anything at all with Profile Manager. In Server 3, most (if not all) of the services use their own private postgres cluster, and there is also the "default" cluster for other applications to use. I can't tell from the information you've provided which postgres cluster is having difficulty, but it's definitely not Profile Manager's.

     

    I am curious about what you mean by "found one device being grayed out", however. Can you attach a screen capture of what you're talking about?

Previous Page 2 of 7 last Next