Project

General

Profile

Bug #2023 ยป clean.log

Log of the problem happening - Greg Sutcliffe, 12/09/2012 08:12 AM

 


Started GET "/node/3ff935fc-681a-4fa1-86c1-3e7c6678f9b0?format=yml" for 172.20.10.20 at 2012-12-09 13:09:07 +0000
Processing by HostsController#externalNodes as YML
Parameters: {"name"=>"3ff935fc-681a-4fa1-86c1-3e7c6678f9b0"}
User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."login" = 'admin' LIMIT 1
Setting current user thread-local variable to admin
Host Load (1.7ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."certname" = '3ff935fc-681a-4fa1-86c1-3e7c6678f9b0' LIMIT 1
SmartProxy Load (1.3ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 2 ORDER BY LOWER(smart_proxies.name) LIMIT 1
Domain Load (1.2ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY LOWER(domains.name) LIMIT 1
Hostgroup Load (1.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 AND (1=1) LIMIT 1
Hostgroup Load (1.4ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (2, 3) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 2 ORDER BY LOWER(smart_proxies.name) LIMIT 1
Environment Load (1.2ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
CommonParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'CommonParameter'
DomainParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'DomainParameter' AND ("parameters".reference_id = 1)
Operatingsystem Load (1.3ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1
OsParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'OsParameter' AND ("parameters".reference_id = 1)
Hostgroup Load (1.3ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (2, 3, 1) AND (1=1)
GroupParameter Load (1.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'GroupParameter' AND ("parameters".reference_id IN (1,2,3))
HostParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'HostParameter' AND ("parameters".reference_id = 85)
SQL (2.7ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"hostgroups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (2.7ms)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"hostgroup_classes"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

Puppetclass Load (2.8ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "hostgroup_classes" ON "puppetclasses"."id" = "hostgroup_classes"."puppetclass_id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "hostgroup_classes"."hostgroup_id" WHERE "hostgroups"."id" IN (2, 3, 1) ORDER BY puppetclasses.name
Puppetclass Load (2.1ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses".id = "host_classes".puppetclass_id WHERE (("host_classes".host_id = 85)) ORDER BY puppetclasses.name
LookupKey Load (1.8ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (63, 80, 90) ORDER BY lookup_keys.key
SQL (1.2ms) SELECT host_classes.puppetclass_id FROM "host_classes" WHERE ("host_classes".host_id = 85)
SQL (1.5ms) SELECT hostgroup_classes.puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (2, 3, 1)
SQL (3.4ms)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"environment_classes"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

LookupKey Load (3.4ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."puppetclass_id" IN (63, 80, 90, 90) AND "environment_classes"."environment_id" = 1 ORDER BY lookup_keys.key
Puppetclass Load (1.6ms) SELECT "puppetclasses".* FROM "puppetclasses" WHERE "puppetclasses"."id" IN (63, 80, 90, 90) ORDER BY puppetclasses.name
Setting Load (2.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY LOWER(settings.name) LIMIT 1
Rendered text template (0.0ms)
Completed 200 OK in 160ms (Views: 2.2ms | ActiveRecord: 42.6ms)


Started POST "/fact_values/create" for 172.20.10.20 at 2012-12-09 13:09:10 +0000
Processing by FactValuesController#create as
Parameters: {"facts"=>"[FILTERED]"}
User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."login" = 'admin' LIMIT 1
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
Host Load (1.6ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'installer.elysium.emeraldreverie.org' LIMIT 1
gss {"mtu_lo"=>"16436", "swapfree"=>"455.77 MB", "network_lo"=>"127.0.0.0", "physicalprocessorcount"=>"1", "netmask"=>"255.255.255.0", "processorcount"=>"1", "kernel"=>"Linux", "fqdn"=>"installer.elysium.emeraldreverie.org", "uniqueid"=>"007f0101", "lsbmajdistrelease"=>"6", "ipaddress_lo"=>"127.0.0.1", "operatingsystemrelease"=>"6.0.6", "clientversion"=>"3.0.1", "memorysize"=>"244.95 MB", "is_virtual"=>"true", "virtual"=>"kvm", "augeasversion"=>"0.7.2", "ipaddress"=>"172.20.10.51", "rubysitedir"=>"/usr/local/lib/site_ruby/1.8", "kernelrelease"=>"2.6.32-5-amd64", "hardwaremodel"=>"x86_64", "ps"=>"ps -ef", "netmask_lo"=>"255.0.0.0", "domain"=>"elysium.emeraldreverie.org", "macaddress_eth0"=>"52:54:00:0f:51:ec", "netmask_eth0"=>"255.255.255.0", "uptime_days"=>"5", "memorytotal"=>"244.95 MB", "id"=>"root", "timezone"=>"GMT", "interfaces"=>"eth0,lo", "lsbdistrelease"=>"6.0.6", "type"=>"Other", "hardwareisa"=>"unknown", "processor0"=>"QEMU Virtual CPU version 1.2.0", "uptime_hours"=>"121", "memoryfree"=>"122.88 MB", "selinux"=>"false", "osfamily"=>"Debian", "manufacturer"=>"Bochs", "lsbdistcodename"=>"squeeze", "path"=>"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "lsbdistdescription"=>"Debian GNU/Linux 6.0.6 (squeeze)", "kernelversion"=>"2.6.32", :_timestamp=>2012-12-09 13:09:09 +0000, "puppetversion"=>"3.0.1", "uptime"=>"5 days", "hostname"=>"installer", "swapsize"=>"465.99 MB", "kernelmajversion"=>"2.6", "ipaddress_eth0"=>"172.20.10.51", "serialnumber"=>"Not Specified", "macaddress"=>"52:54:00:0f:51:ec", "operatingsystem"=>"Debian", "sshrsakey"=>"AAAAB3NzaC1yc2EAAAADAQABAAABAQDH5UDOQT/nQUS9C6lkRLAgGCfesqU5+lkdS9wbOqpNFKKcoxkj7Y0ACOzkK8DhG3P8lrv+Jfcv9v/E4Jn5+GPnQpDVAjUlbQLIt1q8d3dlQMu33NyCdR+R/vBXsroFOVPrkiFjxYFHwGQ41bpeGP8ljvLptK/SwJs4KJKCkaO9KttKhdckKMX4QkS8W0tn6qWh6oJwVHF8iOnXbRUYbw990UxsNJakpnQfZzlOIu0mWKcG42zHfKUlxsY+rL8WUyl0JUdCt4aoS6k8zgvVPKMMUOlJ71oEXa//e9lZkmEBYFIL92WgUTh8jOQqJiMuZks7+Vg/j8Cd+V43BA704mDT", "facterversion"=>"1.6.16", "clientcert"=>"3ff935fc-681a-4fa1-86c1-3e7c6678f9b0", "mtu_eth0"=>"1500", "productname"=>"Bochs", "network_eth0"=>"172.20.10.0", "rubyversion"=>"1.8.7", "sshdsakey"=>"AAAAB3NzaC1kc3MAAACBAPb++cUbghXJoAi9Q7I4RhIXLtkNiOXS3yNEUWq1eQi1Bj/IcE4tY3nZoOv/cLjPMKx8iOFDQIKlic2DWVLPGsQdDX0PiR50QxWbFf2vxE83+ITdUxjHFlzBWGZxV6OAb9H7Jnpyt1su0GLloggJArdpkoYTpyT5Mc58UkvqSRqRAAAAFQCpxkk8JZ3K0NGwSKlYO2V+qki3EQAAAIA5eDDUBuwrNn7vDu5SbqnrxUz2ZHtQUAJEyIZVbqUyaQYWf05cD0z4W8wldbPswhPt+ymrpfBhBXaFIpl3m7E3SzpPXmd2Ul7WOPg6TswN6Py7Fy9KdHGqonBWVFs0eRhrMOYoN4gbWHiHjEEc9IO+SYlCvnsJ5pbXkf3gG5IMPgAAAIASfwNrFR4C0UuKbgEG8R5T5/9ktGwTJqCaoUbhlGRyrIimmibFJjkOEdU2srBeG2S79vkw2AwI7RT4QJq6ZyAUW23y8hhulL0m6eYSWmNJ5XmGZnbCD5DLamctrLpSMYMuTB2BgrsXWFLL7Wg5tEcSEglhpKJiuDKlFHybpa/k2Q==", "architecture"=>"amd64", "uptime_seconds"=>"435762", "lsbdistid"=>"Debian"}
Failed to save installer.elysium.emeraldreverie.org: Host is pending for Build
Rendered text template (0.0ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 21ms (Views: 1.6ms | ActiveRecord: 2.7ms)


Started GET "/node/3ff935fc-681a-4fa1-86c1-3e7c6678f9b0?format=yml" for 172.20.10.20 at 2012-12-09 13:09:10 +0000
Processing by HostsController#externalNodes as YML
Parameters: {"name"=>"3ff935fc-681a-4fa1-86c1-3e7c6678f9b0"}
User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."login" = 'admin' LIMIT 1
Setting current user thread-local variable to admin
Host Load (1.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."certname" = '3ff935fc-681a-4fa1-86c1-3e7c6678f9b0' LIMIT 1
SmartProxy Load (1.1ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 2 ORDER BY LOWER(smart_proxies.name) LIMIT 1
Domain Load (1.1ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY LOWER(domains.name) LIMIT 1
Hostgroup Load (1.1ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 AND (1=1) LIMIT 1
Hostgroup Load (1.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (2, 3) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 2 ORDER BY LOWER(smart_proxies.name) LIMIT 1
Environment Load (1.1ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
CommonParameter Load (1.0ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'CommonParameter'
DomainParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'DomainParameter' AND ("parameters".reference_id = 1)
Operatingsystem Load (1.2ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1
OsParameter Load (1.0ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'OsParameter' AND ("parameters".reference_id = 1)
Hostgroup Load (1.1ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (2, 3, 1) AND (1=1)
GroupParameter Load (1.1ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'GroupParameter' AND ("parameters".reference_id IN (1,2,3))
HostParameter Load (1.0ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" = 'HostParameter' AND ("parameters".reference_id = 85)
SQL (2.3ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"hostgroups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (2.0ms)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"hostgroup_classes"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

Puppetclass Load (2.1ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "hostgroup_classes" ON "puppetclasses"."id" = "hostgroup_classes"."puppetclass_id" INNER JOIN "hostgroups" ON "hostgroups"."id" = "hostgroup_classes"."hostgroup_id" WHERE "hostgroups"."id" IN (2, 3, 1) ORDER BY puppetclasses.name
Puppetclass Load (1.5ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses".id = "host_classes".puppetclass_id WHERE (("host_classes".host_id = 85)) ORDER BY puppetclasses.name
LookupKey Load (1.4ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (63, 80, 90) ORDER BY lookup_keys.key
SQL (0.9ms) SELECT host_classes.puppetclass_id FROM "host_classes" WHERE ("host_classes".host_id = 85)
SQL (1.0ms) SELECT hostgroup_classes.puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (2, 3, 1)
SQL (2.3ms)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"environment_classes"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

LookupKey Load (2.1ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."puppetclass_id" IN (63, 80, 90, 90) AND "environment_classes"."environment_id" = 1 ORDER BY lookup_keys.key
Puppetclass Load (1.2ms) SELECT "puppetclasses".* FROM "puppetclasses" WHERE "puppetclasses"."id" IN (63, 80, 90, 90) ORDER BY puppetclasses.name
Setting Load (1.5ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY LOWER(settings.name) LIMIT 1
Rendered text template (0.0ms)
Completed 200 OK in 124ms (Views: 2.3ms | ActiveRecord: 33.9ms)


Started POST "/reports/create?format=yml" for 172.20.10.20 at 2012-12-09 13:09:12 +0000
Processing by ReportsController#create as YML
Parameters: {"report"=>"[FILTERED]"}
User Load (1.2ms) SELECT "users".* FROM "users" WHERE "users"."login" = 'admin' LIMIT 1
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
processing report for 3ff935fc-681a-4fa1-86c1-3e7c6678f9b0
Host Load (1.4ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."certname" = '3ff935fc-681a-4fa1-86c1-3e7c6678f9b0' LIMIT 1
SQL (0.4ms) BEGIN
AREL (1.4ms) UPDATE "hosts" SET "last_report" = '2012-12-09 13:09:09.865592', "updated_at" = '2012-12-09 13:09:12.993516' WHERE "hosts"."id" = 85
SQL (38.4ms) COMMIT
SQL (0.4ms) BEGIN
SQL (1.0ms) SELECT 1 FROM "reports" WHERE "reports"."host_id" = 85 AND ("reports"."reported_at" = '2012-12-09 13:09:09.865592') LIMIT 1
SQL (1.0ms) INSERT INTO "reports" ("host_id", "reported_at", "created_at", "updated_at", "status", "metrics") VALUES (85, '2012-12-09 13:09:09.865592', '2012-12-09 13:09:13.055428', '2012-12-09 13:09:13.055428', 100663296, '---
time:
config_retrieval: 2.24147200584412
cron: 0.000992
file: 0.012647
filebucket: 0.000204
package: 0.001082
service: 0.105833
total: 2.36567000584412
user: 0.00344
events:
failure: 0
success: 0
total: 0
resources:
changed: 0
failed: 0
failed_to_restart: 0
out_of_sync: 0
restarted: 0
scheduled: 0
skipped: 6
total: 20
changes:
total: 0') RETURNING "id"
SQL (8.2ms) COMMIT
Message Load (1.6ms) SELECT "messages".* FROM "messages" WHERE "messages"."value" = 'Retrieving plugin' LIMIT 1
Source Load (1.3ms) SELECT "sources".* FROM "sources" WHERE "sources"."value" = 'Puppet' LIMIT 1
SQL (0.5ms) BEGIN
SQL (1.5ms) INSERT INTO "logs" ("source_id", "message_id", "report_id", "level_id", "created_at", "updated_at") VALUES (1, 3347, 38439, 1, '2012-12-09 13:09:13.087082', '2012-12-09 13:09:13.087082') RETURNING "id"
SQL (12.3ms) COMMIT
Message Load (1.5ms) SELECT "messages".* FROM "messages" WHERE "messages"."value" = 'Caching catalog for 3ff935fc-681a-4fa1-86c1-3e7c6678f9b0' LIMIT 1
SQL (0.5ms) BEGIN
SQL (1.4ms) INSERT INTO "messages" ("value") VALUES ('Caching catalog for 3ff935fc-681a-4fa1-86c1-3e7c6678f9b0') RETURNING "id"
SQL (25.6ms) COMMIT
Source Load (1.3ms) SELECT "sources".* FROM "sources" WHERE "sources"."value" = 'Puppet' LIMIT 1
SQL (0.5ms) BEGIN
SQL (1.4ms) INSERT INTO "logs" ("source_id", "message_id", "report_id", "level_id", "created_at", "updated_at") VALUES (1, 4794, 38439, 1, '2012-12-09 13:09:13.153957', '2012-12-09 13:09:13.153957') RETURNING "id"
SQL (13.4ms) COMMIT
Message Load (1.4ms) SELECT "messages".* FROM "messages" WHERE "messages"."value" = 'Applying configuration version ''1355002524''' LIMIT 1
Source Load (1.3ms) SELECT "sources".* FROM "sources" WHERE "sources"."value" = 'Puppet' LIMIT 1
SQL (0.5ms) BEGIN
SQL (1.4ms) INSERT INTO "logs" ("source_id", "message_id", "report_id", "level_id", "created_at", "updated_at") VALUES (1, 4782, 38439, 1, '2012-12-09 13:09:13.187313', '2012-12-09 13:09:13.187313') RETURNING "id"
SQL (16.0ms) COMMIT
Message Load (1.6ms) SELECT "messages".* FROM "messages" WHERE "messages"."value" = 'Finished catalog run in 0.48 seconds' LIMIT 1
Source Load (1.3ms) SELECT "sources".* FROM "sources" WHERE "sources"."value" = 'Puppet' LIMIT 1
SQL (0.5ms) BEGIN
SQL (1.4ms) INSERT INTO "logs" ("source_id", "message_id", "report_id", "level_id", "created_at", "updated_at") VALUES (1, 4156, 38439, 2, '2012-12-09 13:09:13.223355', '2012-12-09 13:09:13.223355') RETURNING "id"
SQL (18.2ms) COMMIT
Puppet::Rails::FactValue Load (12.9ms) SELECT "fact_values".* FROM "fact_values" WHERE ("fact_values".host_id = 85)
Operatingsystem Load (1.7ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."name" IS NULL ORDER BY LOWER(operatingsystems.name) LIMIT 1
SQL (0.6ms) BEGIN
SQL (0.4ms) ROLLBACK
Setting Load (1.3ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_environment_from_facts' ORDER BY LOWER(settings.name) LIMIT 1
Environment Load (1.0ms) SELECT "environments".* FROM "environments" WHERE "environments"."name" = 'production' ORDER BY environments.name LIMIT 1
Environment Load (1.0ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
SQL (0.4ms) BEGIN
Host Load (1.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = 85 LIMIT 1
SQL (1.5ms) SELECT MAX("audits"."version") AS max_id FROM "audits" WHERE "audits"."auditable_id" = 85 AND "audits"."auditable_type" = 'Host'
SQL (1.3ms) INSERT INTO "audits" ("auditable_id", "auditable_type", "user_id", "user_type", "username", "action", "audited_changes", "version", "comment", "associated_id", "associated_type", "created_at", "remote_address", "auditable_name", "associated_name") VALUES (85, 'Host', NULL, NULL, 'Admin User', 'update', '---
operatingsystem_id:
- 1
- ', 5, NULL, NULL, NULL, '2012-12-09 13:09:13.369133', '172.20.10.20', 'installer.elysium.emeraldreverie.org', NULL) RETURNING "id"
AREL (1.7ms) UPDATE "hosts" SET "operatingsystem_id" = NULL, "updated_at" = '2012-12-09 13:09:13.376937' WHERE "hosts"."id" = 85
SQL (11.7ms) COMMIT
Rendered text template (0.0ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 487ms (Views: 3.2ms | ActiveRecord: 197.0ms)


Started GET "/hosts/installer.elysium.emeraldreverie.org" for 172.20.10.171 at 2012-12-09 13:09:14 +0000
Processing by HostsController#show as HTML
Parameters: {"id"=>"installer.elysium.emeraldreverie.org"}
User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
Setting current user thread-local variable to admin
Host Load (1.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'installer.elysium.emeraldreverie.org' LIMIT 1
Report Load (1.2ms) SELECT status FROM "reports" WHERE ("reports".host_id = 85) AND (reported_at > '2012-12-02 13:09:14.973823') ORDER BY reported_at
ComputeResource Load (1.1ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY LOWER(compute_resources.name) LIMIT 1
Setting Load (1.3ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY LOWER(settings.name) LIMIT 1
SQL (0.9ms) SELECT COUNT(*) FROM "resources" WHERE ("resources".host_id = 85)
SQL (1.0ms) SELECT COUNT(*) FROM "reports" WHERE ("reports".host_id = 85)
Report Load (1.2ms) SELECT "reports".* FROM "reports" WHERE ("reports".host_id = 85) LIMIT 1
SQL (1.1ms) SELECT COUNT(*) FROM "reports" WHERE ("reports".host_id = 85) AND (reported_at > '2012-12-02 13:09:15.113664')
Domain Load (1.1ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY LOWER(domains.name) LIMIT 1
Environment Load (1.0ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
Architecture Load (0.9ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 3 LIMIT 1
Hostgroup Load (1.1ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 AND (1=1) LIMIT 1
Hostgroup Load (1.3ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (2, 3) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
Rendered hosts/_overview.html.erb (29.5ms)
Rendered hosts/_metrics.html.erb (1.0ms)
TemplateKind Load (0.9ms) SELECT "template_kinds".* FROM "template_kinds"
Rendered compute_resources_vms/show/_libvirt.html.erb (47.4ms)
Report Load (1.2ms) SELECT "reports".* FROM "reports" WHERE ("reports".host_id = 85) AND (reported_at > '2012-12-02 13:09:15.203793') ORDER BY reported_at
Report Load (1.2ms) SELECT "reports".* FROM "reports" WHERE ("reports".host_id = 85) AND (reported_at > '2012-12-02 13:09:15.220907') ORDER BY reported_at
Read fragment views/tabs_and_title_records-1 (0.7ms)
Rendered home/_topbar.rhtml (4.4ms)
Rendered hosts/show.html.erb within layouts/application (260.8ms)
Completed 200 OK in 281ms (Views: 247.9ms | ActiveRecord: 21.1ms)
    (1-1/1)