Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: Hplogsdon
Hplogsdon Author
User level: 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
94 replies
User profile for user: mscott_mdm
mscott_mdm
User level: Level 2
459 points

Oct 31, 2013 7:59 AM in response to josh.miller

Josh,


Which issue are you experiencing and which commands did you run? Unfortunately, this thread has multiple commands in it which I used to diagnose the issue first, and other issues have been discussed here, so it's a little unclear to me. If you have the problem where devicemgrd is using 200% CPU then you need to run the commands in my long post on page 2 with the timestamp and note "Oct 24, 2013 11:11 AM(in response to amt60)"


(Of course, the timestamp will be different based on your local time. I think that time would be 5:11PM GMT.)


If those commands are successfully applied (that post will tell you how to know if they were), and you're still experiencing devicemgrd using 200% CPU, then you almost certainly have a different problem. In that case, please run this command and paste the output into your reply:


sudo tail -n 100 /Library/Logs/ProfileManager/devicemgrd.log


Thanks.

Reply
User profile for user: josh.miller
josh.miller
User level: Level 1
0 points

Oct 31, 2013 9:16 AM in response to mscott_mdm

mscott_mdm,


Here is the output of that command. I used the commands on page 2:


0:: [8418] [2013/10/31 12:15:05.828] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)">

USERINFO: {

SQLSTATE = 25P02;

errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";

}

BACKTRACE:

? | 4455392736

? | 4455366316

? | 4455363283

? | 4455364557

? | 4455399136

? | 4455280229

? | 140735548358741

? | 140735548224913

? | 140735548224059

? | 140735491142317

? | 140735491151503

? | 140735491156445

? | 140735491149731

? | 140735491154323

? | 140735532142328

0:: [8418] [2013/10/31 12:15:05.829] Caught unhandled exception -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)"

0:: [8418] [2013/10/31 12:15:05.829] Caught exception processing queued DB notification: -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)"

0:: [8418] [2013/10/31 12:15:16.500] EXCEPTION: Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 22001 (ERROR: value too long for type character varying(63)

)">

0:: [8418] [2013/10/31 12:15:16.501] EXCEPTION: Postgres <-[PGConnection executeSQL:withParams:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:432): "Postgres error 22001 (ERROR: value too long for type character varying(63)

)">

USERINFO: {

SQLSTATE = 22001;

errorMessage = "ERROR: value too long for type character varying(63)\n";

}

BACKTRACE:

? | 4455396805

? | 4455249468

? | 4455312994

? | 4455202951

? | 4455211723

? | 140735502994924

? | 140735502994516

? | 140735503660966

? | 4455243378

? | 4455282989

? | 4455280686

? | 4455398918

? | 4455280229

? | 140735548358741

? | 140735548224913

0:: [8418] [2013/10/31 12:15:16.501] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)">

0:: [8418] [2013/10/31 12:15:16.502] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)">

USERINFO: {

SQLSTATE = 25P02;

errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";

}

BACKTRACE:

? | 4455392736

? | 4455234614

? | 4455204712

? | 4455211723

? | 140735502994924

? | 140735502994516

? | 140735503660966

? | 4455243378

? | 4455282989

? | 4455280686

? | 4455398918

? | 4455280229

? | 140735548358741

? | 140735548224913

? | 140735548224059

0:: [8418] [2013/10/31 12:15:16.502] Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7f91203b93d0> [channel: 'objc_send', message: '[LibraryItemMetadata parseApplicationsForLibraryItemMetadataID:175]']. -[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)"

0:: [8418] [2013/10/31 12:15:16.503] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)">

0:: [8418] [2013/10/31 12:15:16.504] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (/SourceCache/RemoteDeviceManagement/RemoteDeviceManagement-848.17/Compiled/Fra mework-Models/Postgres/PGConnection.m:323): "Postgres error 25P02 (ERROR: current transaction is aborted, commands ignored until end of transaction block

)">

USERINFO: {

SQLSTATE = 25P02;

errorMessage = "ERROR: current transaction is aborted, commands ignored until end of transaction block\n";

}

BACKTRACE:

? | 4455392736

? | 4455366316

? | 4455363283

? | 4455364557

? | 4455399136

? | 4455280229

? | 140735548358741

? | 140735548224913

? | 140735548224059

? | 140735491142317

? | 140735491151503

? | 140735491156445

? | 140735491149731

? | 140735491154323

? | 140735532142328

Reply
User profile for user: takh
takh
User level: Level 1
0 points

Nov 4, 2013 3:14 PM in response to mscott_mdm

Hi,


After upgrading to Server 3, I noticed that my Mac Mini was running slower and slower... After running DaisyDisk, I noticed that the devicemgrd.log was over 50GB size! I got to the point where I manage to figure out that the culpri is definitely Profile Manager...


I've tried running the commands that you've suggested but the problem is not going away. I don't actually have an issue with high-load CPU. Rather that the server app keeps writing to the log file... Here's a quick extract of what happens when I turn on Profile Manager (from blank log file to this):


1:: [52814] [2013/11/04 23:12:28.739] Incoming request: readSettings

1:: [52814] [2013/11/04 23:12:28.784] Incoming request: readAppDistributionSettings

1:: [52814] [2013/11/04 23:12:37.994] Incoming request: readSettings

1:: [52814] [2013/11/04 23:12:38.053] Incoming request: readAppDistributionSettings

1:: [52814] [2013/11/04 23:12:38.770] Incoming request: writeSettings

1:: [52814] [2013/11/04 23:12:39.295] Incoming request: noOp

1:: [52814] [2013/11/04 23:12:50.854] Incoming request: setWebAppState

0:: [52814] [2013/11/04 23:12:50.858] Profile Manager service started.

-9:: [52814] [2013/11/04 23:12:50.880] [0x7fc771d208d0/<DMDevicemgrd:0x7fc771d1e4a0>] -[DMDevicemgrd sendPendingEmailNotifications]

1:: [52814] [2013/11/04 23:12:51.568] -[DMODSyncRunner _syncUserODRecords:returningGUIDs:]: Synced 7 users

1:: [52814] [2013/11/04 23:12:51.637] +[DMODQueries syncUserGroupWithODRecord:updateTxnBlock:]: Querying OD for new users and groups

1:: [52814] [2013/11/04 23:12:51.662] -[DMODSyncRunner _syncGroupODRecords:returningGUIDs:]: Synced 7 groups

1:: [52814] [2013/11/04 23:12:51.665] +[DMODQueries syncUserGroupWithODRecord:updateTxnBlock:]: Querying OD for new users and groups

1:: [52814] [2013/11/04 23:12:51.684] -[DMODSyncRunner _syncGroupODRecords:returningGUIDs:]: Synced 1 groups

1:: [52814] [2013/11/04 23:12:51.697] -[DMODSyncRunner _syncGroupODRecords:returningGUIDs:]: Synced 1 groups

1:: [52814] [2013/11/04 23:12:51.702] -[DMODSyncRunner _syncGroupODRecords:returningGUIDs:]: Synced 1 groups

0:: [52814] [2013/11/04 23:12:51.738] Full sync of bound directory services completed in 0.878 seconds.

1:: [52814] [2013/11/04 23:12:53.010] Incoming request: setSSLState

1:: [52814] [2013/11/04 23:12:54.958] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:12:54 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=100

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:12:59.037] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:12:59 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=99

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:13:03.108] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:13:03 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=98

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:13:07.186] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:13:07 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=97

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:13:11.259] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:13:11 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=96

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:13:15.336] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:13:15 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=95

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

1:: [52814] [2013/11/04 23:13:19.408] didReceiveResponse: 403 (forbidden)

headers:

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————

Accept-Ranges : bytes

Cache-Control : no-cache

Connection : Keep-Alive

Content-Language : en

Content-Length : 1585

Content-Location : websitesoff403.html.en

Content-Type : text/html

Date : Mon, 04 Nov 2013 23:13:19 GMT

Etag : "631-4e9b3d652a1c0;4e9b3d652a1c0"

Keep-Alive : timeout=15, max=94

Last-Modified : Sun, 27 Oct 2013 07:21:51 GMT

MS-Author-Via : DAV

Server : Apache/2.2.24 (Unix) DAV/2 PHP/5.4.17 mod_fastcgi/2.4.6 mod_ssl/2.2.24 OpenSSL/0.9.8y

TCN : choice

Vary : negotiate,accept-language,User-Agent

——————————————————+———————————————————————————————————————————————————————————— —————————————————————————



The problem becomes even worse when I have the Web Server running as it seems to put into the log file the HTML codes for the front page of my website...


Thanks in advance.

Reply
User profile for user: Paul Verity
Paul Verity
User level: Level 1
16 points

Nov 4, 2013 4:39 PM in response to mscott_mdm

This fixed it for me too. Took a while, but devicemgrd was still consuming huge amounts of CPU for about 5-10 minutes. Now my system is calm again. CPU normal and fan has finally spun down.


This was taking out my entire server. I was losing e-mails because of this. When I returned home and logged in I was greeted with a Force Quit dialog saying that my system was out of memory and that I should quit some apps. All that was running was Safari and Activity Monitor (which was Paused).


Many thanks for your help!


I think Mavericks will need a few maintenance updates before it's as stable as the 'big cat' releases. Perhaps the most unstabe OS X release so far. I've had my entire system reboot just using Safari on my iMac.

Reply
User profile for user: Paul Verity
Paul Verity
User level: Level 1
16 points

Nov 8, 2013 5:15 PM in response to Hplogsdon

Argh! No! It's happening again and this time that SQL fix doesn't work! My server is going to run out of memory in about 10 mins! Apple, help!


I get the error continually recurring:


0:: [4404] [2013/11/09 01:11:30.073] Caught exception sending objc_msgsend-style notification <PGDatabaseNotification:0x7fe1821c6580> [channel: 'objc_send', message: '[LibraryItemMetadata parseCertificatesForLibraryItemMetadataID:39]']. -[NSNull countByEnumeratingWithState:objects:count:]: unrecognized selector sent to instance 0x7fff72a3b1f0

1:: [4404] [2013/11/09 01:11:30.262] -[NSException(devicemgr_Additions) error]: No error set for exception: -[NSNull countByEnumeratingWithState:objects:count:]: unrecognized selector sent to instance 0x7fff72a3b1f0


I have tried:

sudo serveradmin stop devicemgr


But it keeps getting respawned! I've also turned off Profile Manager...

Reply
User profile for user: Paul Verity
Paul Verity
User level: Level 1
16 points

Nov 8, 2013 5:54 PM in response to Paul Verity

I think I've managed to stem the bleeding.


sudo launchctl unload /Applications/Server.app/Contents/ServerRoot/System/Library/LaunchDaemons/com.a pple.DeviceManagement.devicemgrd.plist


But shortly after it got spawned again! So I moved all the com.apple.DeviceManagement.* into a subdirectory


I also noticed some Java webapps that run under Tomcat (JDK 7 u45) consuming vast amounts of memory so stopped thost too and rebooted.


I'm running on reduced functionality now, but at least I'm running!!!

Reply

devicemgrd null ptr error loop causing high cpu load.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.
Learn more Sign up