Server Error has occurred when loading profile manager page
I am getting message saying Server Error has occurred when I login into profile manager web page. How can i solve this issue. I am using Mavericks Server.
Logs?
Apple Event: May 7th at 7 am PT
7 replies
Sorry new to Mac Server area, which log should i check and where.
System log, PM logs, web server error log.
PM Logs
2014-03-07 00:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322439-2" ("value" varchar UNIQUE)
2014-03-07 00:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 00:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322439-2" ("value" varchar UNIQUE)
2014-03-07 01:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322441-2" ("value" varchar UNIQUE)
2014-03-07 01:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 01:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322441-2" ("value" varchar UNIQUE)
2014-03-07 02:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322443-2" ("value" varchar UNIQUE)
2014-03-07 02:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 02:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322443-2" ("value" varchar UNIQUE)
2014-03-07 03:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322445-2" ("value" varchar UNIQUE)
2014-03-07 03:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 03:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322445-2" ("value" varchar UNIQUE)
2014-03-07 04:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322447-2" ("value" varchar UNIQUE)
2014-03-07 04:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 04:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322447-2" ("value" varchar UNIQUE)
2014-03-07 05:15:27 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322449-2" ("value" varchar UNIQUE)
2014-03-07 05:15:27 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 05:15:27 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322449-2" ("value" varchar UNIQUE)
2014-03-07 06:15:28 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322451-2" ("value" varchar UNIQUE)
2014-03-07 06:15:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 06:15:28 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322451-2" ("value" varchar UNIQUE)
2014-03-07 07:15:28 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322453-2" ("value" varchar UNIQUE)
2014-03-07 07:15:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 07:15:28 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322453-2" ("value" varchar UNIQUE)
2014-03-07 08:15:28 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322455-2" ("value" varchar UNIQUE)
2014-03-07 08:15:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 08:15:28 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322455-2" ("value" varchar UNIQUE)
2014-03-07 09:15:28 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322457-2" ("value" varchar UNIQUE)
2014-03-07 09:15:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 09:15:28 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322457-2" ("value" varchar UNIQUE)
2014-03-07 10:15:28 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322459-2" ("value" varchar UNIQUE)
2014-03-07 10:15:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 10:15:28 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322459-2" ("value" varchar UNIQUE)
2014-03-07 10:18:03 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322461-2" ("value" varchar UNIQUE)
2014-03-07 10:18:03 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 10:18:03 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322461-2" ("value" varchar UNIQUE)
2014-03-07 11:15:29 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322463-2" ("value" varchar UNIQUE)
2014-03-07 11:15:29 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 11:15:29 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322463-2" ("value" varchar UNIQUE)
2014-03-07 12:15:29 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322465-2" ("value" varchar UNIQUE)
2014-03-07 12:15:29 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 12:15:29 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322465-2" ("value" varchar UNIQUE)
2014-03-07 13:15:29 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322467-2" ("value" varchar UNIQUE)
2014-03-07 13:15:29 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 13:15:29 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322467-2" ("value" varchar UNIQUE)
2014-03-07 14:15:29 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322469-2" ("value" varchar UNIQUE)
2014-03-07 14:15:29 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 14:15:29 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322469-2" ("value" varchar UNIQUE)
2014-03-07 15:05:34 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322472-2" ("value" varchar UNIQUE)
2014-03-07 15:05:34 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:05:34 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322472-2" ("value" varchar UNIQUE)
2014-03-07 15:06:11 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322474-2" ("value" varchar UNIQUE)
2014-03-07 15:06:11 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:06:11 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322474-2" ("value" varchar UNIQUE)
2014-03-07 15:06:45 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:06:45 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:06:45 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322480)
2014-03-07 15:06:53 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:06:53 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:06:53 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322482)
2014-03-07 15:07:56 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:07:56 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:07:56 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322485)
2014-03-07 15:08:04 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:08:04 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:08:04 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322489)
2014-03-07 15:09:06 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:06 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:06 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322495)
2014-03-07 15:09:15 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:15 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:15 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322497)
2014-03-07 15:09:19 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:19 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:19 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322500)
2014-03-07 15:09:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:28 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:28 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322502)
2014-03-07 15:09:43 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:43 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:43 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322504)
2014-03-07 15:09:48 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:48 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:48 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322506)
2014-03-07 15:09:52 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:09:52 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:09:52 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322508)
2014-03-07 15:13:59 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322519-2" ("value" varchar UNIQUE)
2014-03-07 15:13:59 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:13:59 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322519-2" ("value" varchar UNIQUE)
2014-03-07 15:14:11 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:14:11 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:14:11 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322522)
2014-03-07 15:15:40 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:40 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:15:41 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322586-2" ("value" varchar UNIQUE)
2014-03-07 15:15:41 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:15:41 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322586-2" ("value" varchar UNIQUE)
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:15:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:15:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:16:10 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:16:10 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:16:10 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322599)
2014-03-07 15:16:20 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:16:47 NZDTLOG: connection received: host=[local]
2014-03-07 15:16:47 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:16:52 NZDTLOG: connection received: host=[local]
2014-03-07 15:16:52 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:16:53 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:16:53 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:16:53 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:17:01 NZDTLOG: connection received: host=[local]
2014-03-07 15:17:01 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:17:01 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:17:01 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:17:01 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:17:14 NZDTLOG: connection received: host=[local]
2014-03-07 15:17:14 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:17:14 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:17:14 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:17:14 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:17:20 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:17:26 NZDTLOG: connection received: host=[local]
2014-03-07 15:17:26 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:17:26 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:17:26 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:17:26 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:17:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:17:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:17:31 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:17:31 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:17:31 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:18:00 NZDTLOG: connection received: host=[local]
2014-03-07 15:18:00 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:18:01 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:18:01 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE _affected_profiles ON COMMIT DROP AS
SELECT DISTINCT tp.profile_id
FROM view_truth_profiles AS tp
WHERE tp.mdm_target_id = after.id
AND (tp.device_substitution_keys & fn.mask) <> 0"
PL/pgSQL function dm_deferred_update_profiles_by_device_substitutions(devices,devices) line 40 at SQL statement
SQL statement "SELECT dm_deferred_update_profiles_by_device_substitutions(OLD, NEW)"
PL/pgSQL function _dm_after_device_modify() line 37 at PERFORM
2014-03-07 15:18:01 NZDTSTATEMENT: UPDATE "devices" SET ("updated_at","active_checkin_token","udid") = (dm_current_timestamp(),$1,$2) WHERE id = $3
2014-03-07 15:18:20 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:19:20 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:20:16 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:20:16 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:20:16 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322639)
2014-03-07 15:20:20 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:20:26 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:20:26 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:20:26 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322641)
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:21:11 NZDTLOG: connection received: host=[local]
2014-03-07 15:21:11 NZDTLOG: connection authorized: user=_devicemgr database=postgres
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:21:11 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:21:12 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:21:13 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:21:14 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:21:14 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:21:14 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:21:14 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: received smart shutdown request
2014-03-07 15:21:14 NZDTLOG: autovacuum launcher shutting down
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:21:14 NZDTLOG: shutting down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D0 ' ... '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D0'
2014-03-07 15:21:14 NZDTLOG: database system is shut down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D0 ' --> '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D0'
2014-03-07 15:22:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:15 NZDTLOG: database system was shut down at 2014-03-07 15:21:14 NZDT
2014-03-07 15:22:15 NZDTFATAL: the database system is starting up
2014-03-07 15:22:15 NZDTFATAL: the database system is starting up
2014-03-07 15:22:15 NZDTLOG: autovacuum launcher started
2014-03-07 15:22:15 NZDTLOG: database system is ready to accept connections
2014-03-07 15:22:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:15 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:22:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:15 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:16 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:22:16 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:22:17 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:22:17 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:22:17 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:22:17 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:22:18 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:22:18 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:22:18 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:22:18 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:22:19 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:22:19 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:22:19 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:22:19 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:22:20 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:22:20 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:20 NZDTLOG: replication connection authorized: user=_devicemgr
2014-03-07 15:22:20 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:22:20 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:20 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:20 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:22:21 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:22:21 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:22:21 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:22:21 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:22:22 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:22:23 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:22:24 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:22:24 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:22:24 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:22:24 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:24 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:24 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:24 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:24 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:24 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:24 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:24 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:24 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322725-2" ("value" varchar UNIQUE)
2014-03-07 15:22:25 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:22:25 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322725-2" ("value" varchar UNIQUE)
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:31 NZDTLOG: connection received: host=[local]
2014-03-07 15:22:31 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:22:35 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322728-2" ("value" varchar UNIQUE)
2014-03-07 15:22:35 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:22:35 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322728-2" ("value" varchar UNIQUE)
2014-03-07 15:22:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:23:11 NZDTLOG: connection received: host=[local]
2014-03-07 15:23:11 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:23:11 NZDTLOG: connection received: host=[local]
2014-03-07 15:23:11 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:23:11 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322766-2" ("value" varchar UNIQUE)
2014-03-07 15:23:12 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:23:12 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322766-2" ("value" varchar UNIQUE)
2014-03-07 15:24:14 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:24:14 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:24:14 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322870)
2014-03-07 15:27:19 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322874-2" ("value" varchar UNIQUE)
2014-03-07 15:27:19 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:27:19 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322874-2" ("value" varchar UNIQUE)
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:27:52 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322875-2" ("value" varchar UNIQUE)
2014-03-07 15:27:52 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:27:52 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322875-2" ("value" varchar UNIQUE)
2014-03-07 15:28:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:15 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:28:16 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322881-2" ("value" varchar UNIQUE)
2014-03-07 15:28:16 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:28:16 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4322881-2" ("value" varchar UNIQUE)
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:19 NZDTLOG: connection received: host=[local]
2014-03-07 15:28:19 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:28:53 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:28:53 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:28:53 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322886)
2014-03-07 15:29:16 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:29:16 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:29:16 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322888)
2014-03-07 15:29:23 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:29:23 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:29:23 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322890)
2014-03-07 15:29:28 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:29:28 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:29:28 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322892)
2014-03-07 15:29:38 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:29:38 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:29:38 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322894)
2014-03-07 15:34:34 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:34:34 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:34:34 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322921)
2014-03-07 15:34:45 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:34:45 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:34:45 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322923)
2014-03-07 15:34:49 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:34:49 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:34:49 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322927)
2014-03-07 15:34:52 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:34:52 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:34:52 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322929)
2014-03-07 15:35:11 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:35:11 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:35:11 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322931)
2014-03-07 15:35:14 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:35:14 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:35:14 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322933)
2014-03-07 15:35:53 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:35:53 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:35:53 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322936)
2014-03-07 15:35:58 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:35:58 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:35:58 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322939)
2014-03-07 15:36:01 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:01 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:01 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322941)
2014-03-07 15:36:06 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:06 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:06 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322944)
2014-03-07 15:36:06 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:06 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:06 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322945)
2014-03-07 15:36:12 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:12 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:12 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322948)
2014-03-07 15:36:23 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:23 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:23 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322950)
2014-03-07 15:36:26 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:26 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:26 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322952)
2014-03-07 15:36:42 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:36:42 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:36:42 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4322954)
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:37:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:38:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:39:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:35 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:40:56 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: connection received: host=[local]
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: connection authorized: user=_devicemgr database=postgres
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:40:57 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:40:58 NZDTLOG: received smart shutdown request
2014-03-07 15:40:58 NZDTLOG: autovacuum launcher shutting down
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:40:58 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:40:59 NZDTLOG: shutting down
2014-03-07 15:40:59 NZDTLOG: database system is shut down
2014-03-07 15:41:05 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:05 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:10 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:10 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:15 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:15 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:20 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:20 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:25 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:25 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:30 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:30 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:35 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:35 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:40 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:40 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:45 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:45 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:50 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:50 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:41:55 NZDTFATAL: the database system is shutting down
2014-03-07 15:41:56 NZDTFATAL: archive command was terminated by signal 15: Terminated
2014-03-07 15:41:56 NZDTDETAIL: The failed archive command was: python /Applications/Server.app/Contents/ServerRoot/usr/bin/xpostgres archive pg_xlog/0000000100000001000000D1 ../backup/0000000100000001000000D1
2014-03-07 15:41:56 NZDTLOG: archiver process (PID 257) exited with exit code 1
2014-03-07 15:43:04 NZDTLOG: database system was shut down at 2014-03-07 15:40:59 NZDT
2014-03-07 15:43:05 NZDTLOG: autovacuum launcher started
2014-03-07 15:43:05 NZDTLOG: database system is ready to accept connections
2014-03-07 15:43:05 NZDTLOG: connection received: host=[local]
2014-03-07 15:43:05 NZDTLOG: replication connection authorized: user=_devicemgr
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D1 ' === '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D1'
2014-03-07 15:43:21 NZDTLOG: connection received: host=[local]
2014-03-07 15:43:21 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:43:21 NZDTLOG: connection received: host=[local]
2014-03-07 15:43:21 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:43:22 NZDTLOG: connection received: host=[local]
2014-03-07 15:43:22 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:43:22 NZDTLOG: connection received: host=[local]
2014-03-07 15:43:22 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:43:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_11"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_12"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_15"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_14"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_16"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_9"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_10"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:44:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_13"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:45:01 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:01 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:45:03 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:03 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:03 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:03 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:03 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323051-2" ("value" varchar UNIQUE)
2014-03-07 15:45:03 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:45:03 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323051-2" ("value" varchar UNIQUE)
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:45:07 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:45:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:46:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:47:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:47:34 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:47:34 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:47:34 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4323186)
2014-03-07 15:47:45 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:47:45 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:47:45 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4323188)
2014-03-07 15:48:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:49:21 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323191-2" ("value" varchar UNIQUE)
2014-03-07 15:49:21 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:49:21 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323191-2" ("value" varchar UNIQUE)
2014-03-07 15:49:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:49:50 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323192-2" ("value" varchar UNIQUE)
2014-03-07 15:49:50 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:49:50 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323192-2" ("value" varchar UNIQUE)
2014-03-07 15:50:04 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:50:04 NZDTCONTEXT: SQL statement "CREATE TEMPORARY TABLE IF NOT EXISTS temp_updated_target_tasks (
LIKE view_target_tasks
) ON COMMIT DELETE ROWS"
PL/pgSQL function dm_prepare_updated_target_tasks(bigint,bigint[]) line 6 at SQL statement
2014-03-07 15:50:04 NZDTSTATEMENT: SELECT dm_prepare_updated_target_tasks(4323193)
2014-03-07 15:50:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:51:25 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:52:26 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:53:26 NZDTLOG: autovacuum: found orphan temp table "pg_temp_18"."temp_updated_target_tasks" in database "devicemgr_v2m0"
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:53:57 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:53:58 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:53:59 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:00 NZDTLOG: connection authorized: user=_devicemgr database=postgres
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:54:00 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:54:01 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:54:01 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:54:01 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:54:01 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:54:01 NZDTFATAL: terminating connection due to administrator command
2014-03-07 15:54:01 NZDTLOG: received smart shutdown request
2014-03-07 15:54:01 NZDTLOG: autovacuum launcher shutting down
2014-03-07 15:54:01 NZDTLOG: shutting down
2014-03-07 15:54:01 NZDTLOG: database system is shut down
2014-03-07 15:54:07 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:07 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:12 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:12 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:17 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:17 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:22 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:22 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:27 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:27 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:32 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:32 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:37 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:37 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:42 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:42 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:47 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:47 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:52 NZDTLOG: connection received: host=[local]
2014-03-07 15:54:52 NZDTFATAL: the database system is shutting down
2014-03-07 15:54:57 NZDTFATAL: archive command was terminated by signal 15: Terminated
2014-03-07 15:54:57 NZDTDETAIL: The failed archive command was: python /Applications/Server.app/Contents/ServerRoot/usr/bin/xpostgres archive pg_xlog/0000000100000001000000D2 ../backup/0000000100000001000000D2
2014-03-07 15:54:57 NZDTLOG: archiver process (PID 206) exited with exit code 1
2014-03-07 15:56:41 NZDTLOG: database system was shut down at 2014-03-07 15:54:01 NZDT
2014-03-07 15:56:41 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:41 NZDTFATAL: the database system is starting up
2014-03-07 15:56:41 NZDTLOG: autovacuum launcher started
2014-03-07 15:56:41 NZDTLOG: database system is ready to accept connections
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D2 ' === '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D2'
2014-03-07 15:56:41 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:41 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 15:56:42 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:42 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 15:56:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:44 NZDTLOG: replication connection authorized: user=_devicemgr
2014-03-07 15:56:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:44 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:44 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:45 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323281-2" ("value" varchar UNIQUE)
2014-03-07 15:56:45 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:45 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:45 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:56:45 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323281-2" ("value" varchar UNIQUE)
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:56:55 NZDTLOG: connection received: host=[local]
2014-03-07 15:56:55 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 15:57:04 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323284-2" ("value" varchar UNIQUE)
2014-03-07 15:57:04 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:57:04 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323284-2" ("value" varchar UNIQUE)
2014-03-07 15:57:31 NZDTLOG: statement: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323357-2" ("value" varchar UNIQUE)
2014-03-07 15:57:31 NZDTERROR: could not read block 46 in file "base/17197/12027": read only 0 of 8192 bytes
2014-03-07 15:57:31 NZDTSTATEMENT: CREATE TEMPORARY TABLE "__runtime_temp_devicemgrd-4323357-2" ("value" varchar UNIQUE)
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "widgets" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "preference_panes" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "printers" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "installed_applications" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "users" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "profiles" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "dm_schema_information" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "provisioning_profiles" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "od_nodes" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "user_groups" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "network_lab_sessions" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "enterprise_apps" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "library_items" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "data_files" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "knob_sets" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "od_library_items" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "user_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "work_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "mdm_targets" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "asset_metadata" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "auto_join_profiles" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "db_notifications" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "internal_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "library_item_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "vpp_licenses" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "settings" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "media" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "device_groups" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "lab_sessions" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "owner_lab_sessions" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "library_item_metadata" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "mdm_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "completed_tasks" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "system_applications" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "dynamic_attributes_defaults" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "assets" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "devices" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "vpp_products" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "library_items_assets" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "its_accounts" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: statement: ALTER TABLE "profile_substitution_caches" ENABLE TRIGGER USER
2014-03-07 16:06:34 NZDTLOG: connection received: host=[local]
2014-03-07 16:06:34 NZDTLOG: connection authorized: user=_devicemgr database=postgres
2014-03-07 16:06:35 NZDTLOG: received smart shutdown request
2014-03-07 16:06:35 NZDTLOG: autovacuum launcher shutting down
2014-03-07 16:06:35 NZDTLOG: shutting down
2014-03-07 16:06:35 NZDTLOG: database system is shut down
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D3 ' ... '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D3'
'/Library/Server/ProfileManager/Data/PostgreSQL/pg_xlog/0000000100000001000000D3 ' --> '/Library/Server/ProfileManager/Data/backup/0000000100000001000000D3'
2014-03-07 16:09:06 NZDTLOG: database system was shut down at 2014-03-07 16:06:35 NZDT
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTFATAL: the database system is starting up
2014-03-07 16:09:06 NZDTLOG: autovacuum launcher started
2014-03-07 16:09:06 NZDTLOG: database system is ready to accept connections
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:06 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:06 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 16:09:07 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:07 NZDTLOG: replication connection authorized: user=_devicemgr
2014-03-07 16:09:25 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:25 NZDTLOG: connection authorized: user=_devicemgr database=template1
2014-03-07 16:09:26 NZDTLOG: connection received: host=[local]
2014-03-07 16:09:26 NZDTLOG: connection authorized: user=_devicemgr database=devicemgr_v2m0
2014-03-07 16:09:26 NZDTLOG: autovacuum: found orphan temp table "pg_temp_17"."temp_updated_target_tasks" in database "devicemgr_v2m0"
cannot fine Server or webserver logs
Thanks that solved my problem. I have more faith in Apple Forum now. Thanks again.
Server Error has occurred when loading profile manager page