Guest User

Untitled

a guest
Mar 19th, 2018
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 62.29 KB | None | 0 0
  1. 2018-03-08T13:29:00 08095d8e [app] [I] Started POST "/api/hosts/facts" for 172.16.1.11 at 2018-03-08 13:29:00 +0100
  2. 2018-03-08T13:29:01 08095d8e [app] [I] Processing by Api::V2::HostsController#facts as JSON
  3. 2018-03-08T13:29:01 08095d8e [app] [I] Parameters: {"facts"=>"[FILTERED]", "name"=>"game.inparadise.se", "certname"=>"game.inparadise.se", "apiv"=>"v2", "host"=>{"certname"=>"game.inparadise.se", "name"=>"game.inparadise.se"}}
  4. 2018-03-08T13:29:01 08095d8e [sql] [D] (0.9ms) SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
  5. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'restrict_registered_smart_proxies' ORDER BY `settings`.`name` ASC LIMIT 1
  6. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'require_ssl_smart_proxies' ORDER BY `settings`.`name` ASC LIMIT 1
  7. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_client_cert_env' ORDER BY `settings`.`name` ASC LIMIT 1
  8. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_client_dn_env' ORDER BY `settings`.`name` ASC LIMIT 1
  9. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_client_verify_env' ORDER BY `settings`.`name` ASC LIMIT 1
  10. 2018-03-08T13:29:01 08095d8e [sql] [D] SmartProxy Load (0.8ms) SELECT `smart_proxies`.* FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` = 'Puppet'
  11. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (1.4ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'trusted_puppetmaster_hosts' ORDER BY `settings`.`name` ASC LIMIT 1
  12. 2018-03-08T13:29:01 08095d8e [app] [D] Verifying request from ["puppet.inparadise.se"] against ["puppet.inparadise.se", "puppet.inparadise.se"]
  13. 2018-03-08T13:29:01 08095d8e [sql] [D] User Load (0.7ms) SELECT `users`.* FROM `users` WHERE `users`.`lower_login` = 'foreman_api_admin' LIMIT 1
  14. 2018-03-08T13:29:01 08095d8e [app] [I] Current user: foreman_api_admin (administrator)
  15. 2018-03-08T13:29:01 08095d8e [app] [D] Setting current user thread-local variable to foreman_api_admin
  16. 2018-03-08T13:29:01 08095d8e [sql] [D] Host::Managed Load (0.9ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'game.inparadise.se' LIMIT 1
  17. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.8ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'create_new_host_when_facts_are_uploaded' ORDER BY `settings`.`name` ASC LIMIT 1
  18. 2018-03-08T13:29:01 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'excluded_facts' ORDER BY `settings`.`name` ASC LIMIT 1
  19. 2018-03-08T13:29:01 08095d8e [sql] [D] PuppetFactName Load (3.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` IN ('kernel', 'uptime_seconds', 'lsbmajdistrelease', 'hardwaremodel', 'os::name', 'os::family', 'os::release::major', 'os::release::minor', 'os::release::full', 'os::lsb::distcodename', 'os::lsb::distid', 'os::lsb::distdescription', 'os::lsb::release', 'os::lsb::distrelease', 'os::lsb::majdistrelease', 'os::lsb::minordistrelease', 'lsbrelease', 'rubysitedir', 'gid', 'operatingsystemmajrelease', 'kernelrelease', 'hardwareisa', 'kernelmajversion', 'macaddress', 'system_uptime::seconds', 'system_uptime::hours', 'system_uptime::days', 'system_uptime::uptime', 'physicalprocessorcount', 'virtual', 'architecture', 'operatingsystem', 'netmask', 'partitions::sda1::uuid', 'partitions::sda1::size', 'partitions::sda1::mount', 'partitions::sda1::filesystem', 'partitions::sda2::size', 'partitions::sda2::filesystem', 'puppetversion', 'timezone', 'hostname', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'sshed25519key', 'sshfp_ed25519', 'processors::models', 'processors::count', 'processors::physicalcount', 'ipaddress', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'lsbdistdescription', 'processor0', 'processor1', 'processor2', 'processor3', 'processorcount', 'memorysize', 'memoryfree', 'swapsize', 'swapfree', 'swapsize_mb', 'swapfree_mb', 'memorysize_mb', 'memoryfree_mb', 'path', 'uptime_hours', 'uptime', 'rubyversion', 'kernelversion', 'uptime_days', 'lsbdistid', 'fqdn', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevice_sr0_size', 'blockdevice_sr0_vendor', 'blockdevice_sr0_model', 'blockdevices', 'augeasversion', 'id', 'uniqueid', 'lsbdistcodename', 'lsbminordistrelease', 'interfaces', 'ipaddress_jumbo_nfs_1', 'macaddress_jumbo_nfs_1', 'netmask_jumbo_nfs_1', 'mtu_jumbo_nfs_1', 'ipaddress_jumbo_nfs_2', 'macaddress_jumbo_nfs_2', 'netmask_jumbo_nfs_2', 'mtu_jumbo_nfs_2', 'ipaddress_jumbo_iscsi_1', 'macaddress_jumbo_iscsi_1', 'netmask_jumbo_iscsi_1', 'mtu_jumbo_iscsi_1', 'ipaddress_jumbo_iscsi_2', 'macaddress_jumbo_iscsi_2', 'netmask_jumbo_iscsi_2', 'mtu_jumbo_iscsi_2', 'macaddress_eno1', 'mtu_eno1', 'macaddress_eno1_12', 'mtu_eno1_12', 'macaddress_eno1_13', 'mtu_eno1_13', 'macaddress_eno1_14', 'mtu_eno1_14', 'macaddress_eno1_15', 'mtu_eno1_15', 'macaddress_eno1_101', 'mtu_eno1_101', 'ipaddress_ovirtmgmt', 'macaddress_ovirtmgmt', 'netmask_ovirtmgmt', 'mtu_ovirtmgmt', 'vlans', 'osfamily', 'rubyplatform', 'filesystems', 'ps', 'facterversion', 'domain', 'operatingsystemrelease', 'selinux', 'selinux_enforced', 'selinux_policyversion', 'selinux_current_mode', 'selinux_config_mode', 'selinux_config_policy', 'lsbdistrelease', 'network_jumbo_nfs_1', 'network_jumbo_nfs_2', 'network_jumbo_iscsi_1', 'network_jumbo_iscsi_2', 'network_ovirtmgmt', 'concat_basedir', 'puppet_vardir', 'root_home', 'clientcert', 'clientversion', 'environment', 'puppetmaster_fqdn', 'os', 'os::release', 'os::lsb', 'system_uptime', 'partitions::sda1', 'partitions', 'partitions::sda2', 'processors') AND `fact_names`.`type` = 'PuppetFactName' ORDER BY `fact_names`.`id` ASC LIMIT 1000
  20. 2018-03-08T13:29:01 08095d8e [sql] [D] SQL (2.3ms) UPDATE `fact_names` SET `fact_names`.`compose` = 1 WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` IN ('os', 'os::release', 'os::lsb', 'system_uptime', 'partitions::sda1', 'partitions', 'partitions::sda2', 'processors') AND `fact_names`.`compose` = 0 ORDER BY fact_names.name
  21. 2018-03-08T13:29:01 08095d8e [sql] [D] (0.4ms) BEGIN
  22. 2018-03-08T13:29:01 08095d8e [sql] [D] (4.1ms) SELECT `fact_values`.`id` FROM `fact_values` INNER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` WHERE `fact_values`.`host_id` = 7 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_values`.`fact_name_id` NOT IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 18, 19, 22, 23, 24, 25, 26, 29, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 63, 64, 65, 66, 67, 68, 69, 70, 71, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 94, 97, 98, 99, 100, 119, 120, 121, 124, 125, 126, 127, 128, 129, 130, 133, 134, 135, 136, 137, 138, 139, 140, 141, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 228, 229, 230, 231, 232, 233, 234, 235))
  23. 2018-03-08T13:29:02 08095d8e [sql] [D] SQL (0.5ms) DELETE FROM `fact_values` WHERE 1=0
  24. 2018-03-08T13:29:02 08095d8e [audit] [I] [game.inparadise.se] deleted 0 (40.4ms)
  25. 2018-03-08T13:29:02 08095d8e [audit] [D] "{}"
  26. 2018-03-08T13:29:02 08095d8e [sql] [D] FactValue Load (3.6ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 7 AND `fact_values`.`fact_name_id` IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 18, 19, 22, 23, 24, 25, 26, 29, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 63, 64, 65, 66, 67, 68, 69, 70, 71, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 94, 97, 98, 99, 100, 119, 120, 121, 124, 125, 126, 127, 128, 129, 130, 133, 134, 135, 136, 137, 138, 139, 140, 141, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 228, 229, 230, 231, 232, 233, 234, 235) ORDER BY `fact_values`.`id` ASC LIMIT 1000
  27. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (1.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 5 ORDER BY fact_names.name LIMIT 1
  28. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 61 ORDER BY fact_names.name LIMIT 1
  29. 2018-03-08T13:29:02 08095d8e [sql] [D] SQL (1.5ms) UPDATE `fact_values` SET `fact_values`.`value` = '2990328', `fact_values`.`updated_at` = '2018-03-08 12:29:02' WHERE `fact_values`.`id` = 527
  30. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (12.1ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 158 ORDER BY fact_names.name LIMIT 1
  31. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 8 ORDER BY fact_names.name LIMIT 1
  32. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 31 ORDER BY fact_names.name LIMIT 1
  33. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 32 ORDER BY fact_names.name LIMIT 1
  34. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 33 ORDER BY fact_names.name LIMIT 1
  35. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.4ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 34 ORDER BY fact_names.name LIMIT 1
  36. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 35 ORDER BY fact_names.name LIMIT 1
  37. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 36 ORDER BY fact_names.name LIMIT 1
  38. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (2.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 37 ORDER BY fact_names.name LIMIT 1
  39. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 159 ORDER BY fact_names.name LIMIT 1
  40. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 160 ORDER BY fact_names.name LIMIT 1
  41. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 161 ORDER BY fact_names.name LIMIT 1
  42. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 162 ORDER BY fact_names.name LIMIT 1
  43. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 163 ORDER BY fact_names.name LIMIT 1
  44. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (11.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 164 ORDER BY fact_names.name LIMIT 1
  45. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 165 ORDER BY fact_names.name LIMIT 1
  46. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 166 ORDER BY fact_names.name LIMIT 1
  47. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 167 ORDER BY fact_names.name LIMIT 1
  48. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 70 ORDER BY fact_names.name LIMIT 1
  49. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 6 ORDER BY fact_names.name LIMIT 1
  50. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (7.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 63 ORDER BY fact_names.name LIMIT 1
  51. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 38 ORDER BY fact_names.name LIMIT 1
  52. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 7 ORDER BY fact_names.name LIMIT 1
  53. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 68 ORDER BY fact_names.name LIMIT 1
  54. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 40 ORDER BY fact_names.name LIMIT 1
  55. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 80 ORDER BY fact_names.name LIMIT 1
  56. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (11.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 81 ORDER BY fact_names.name LIMIT 1
  57. 2018-03-08T13:29:02 08095d8e [sql] [D] SQL (0.6ms) UPDATE `fact_values` SET `fact_values`.`value` = '2990328', `fact_values`.`updated_at` = '2018-03-08 12:29:02' WHERE `fact_values`.`id` = 554
  58. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 82 ORDER BY fact_names.name LIMIT 1
  59. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 83 ORDER BY fact_names.name LIMIT 1
  60. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 84 ORDER BY fact_names.name LIMIT 1
  61. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 125 ORDER BY fact_names.name LIMIT 1
  62. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 29 ORDER BY fact_names.name LIMIT 1
  63. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 3 ORDER BY fact_names.name LIMIT 1
  64. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 22 ORDER BY fact_names.name LIMIT 1
  65. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 19 ORDER BY fact_names.name LIMIT 1
  66. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 141 ORDER BY fact_names.name LIMIT 1
  67. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 168 ORDER BY fact_names.name LIMIT 1
  68. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 169 ORDER BY fact_names.name LIMIT 1
  69. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 170 ORDER BY fact_names.name LIMIT 1
  70. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 171 ORDER BY fact_names.name LIMIT 1
  71. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 172 ORDER BY fact_names.name LIMIT 1
  72. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 173 ORDER BY fact_names.name LIMIT 1
  73. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 174 ORDER BY fact_names.name LIMIT 1
  74. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 175 ORDER BY fact_names.name LIMIT 1
  75. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 1 ORDER BY fact_names.name LIMIT 1
  76. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 86 ORDER BY fact_names.name LIMIT 1
  77. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 66 ORDER BY fact_names.name LIMIT 1
  78. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (5.2ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 74 ORDER BY fact_names.name LIMIT 1
  79. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (2.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 75 ORDER BY fact_names.name LIMIT 1
  80. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (1.4ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 76 ORDER BY fact_names.name LIMIT 1
  81. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 77 ORDER BY fact_names.name LIMIT 1
  82. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 78 ORDER BY fact_names.name LIMIT 1
  83. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 79 ORDER BY fact_names.name LIMIT 1
  84. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 24 ORDER BY fact_names.name LIMIT 1
  85. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 126 ORDER BY fact_names.name LIMIT 1
  86. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 25 ORDER BY fact_names.name LIMIT 1
  87. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 127 ORDER BY fact_names.name LIMIT 1
  88. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 67 ORDER BY fact_names.name LIMIT 1
  89. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 119 ORDER BY fact_names.name LIMIT 1
  90. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 120 ORDER BY fact_names.name LIMIT 1
  91. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 121 ORDER BY fact_names.name LIMIT 1
  92. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 41 ORDER BY fact_names.name LIMIT 1
  93. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 42 ORDER BY fact_names.name LIMIT 1
  94. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 43 ORDER BY fact_names.name LIMIT 1
  95. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (1.4ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 44 ORDER BY fact_names.name LIMIT 1
  96. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 45 ORDER BY fact_names.name LIMIT 1
  97. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 46 ORDER BY fact_names.name LIMIT 1
  98. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 47 ORDER BY fact_names.name LIMIT 1
  99. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 48 ORDER BY fact_names.name LIMIT 1
  100. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 176 ORDER BY fact_names.name LIMIT 1
  101. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 140 ORDER BY fact_names.name LIMIT 1
  102. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 177 ORDER BY fact_names.name LIMIT 1
  103. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 178 ORDER BY fact_names.name LIMIT 1
  104. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 179 ORDER BY fact_names.name LIMIT 1
  105. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 26 ORDER BY fact_names.name LIMIT 1
  106. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 49 ORDER BY fact_names.name LIMIT 1
  107. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 50 ORDER BY fact_names.name LIMIT 1
  108. 2018-03-08T13:29:02 08095d8e [sql] [D] SQL (57.9ms) UPDATE `fact_values` SET `fact_values`.`value` = '1.35 GB', `fact_values`.`updated_at` = '2018-03-08 12:29:02' WHERE `fact_values`.`id` = 604
  109. 2018-03-08T13:29:02 08095d8e [sql] [D] FactName Load (14.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 51 ORDER BY fact_names.name LIMIT 1
  110. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 52 ORDER BY fact_names.name LIMIT 1
  111. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 53 ORDER BY fact_names.name LIMIT 1
  112. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (2.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 54 ORDER BY fact_names.name LIMIT 1
  113. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (7.4ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 55 ORDER BY fact_names.name LIMIT 1
  114. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 56 ORDER BY fact_names.name LIMIT 1
  115. 2018-03-08T13:29:03 08095d8e [sql] [D] SQL (0.7ms) UPDATE `fact_values` SET `fact_values`.`value` = '1385.36', `fact_values`.`updated_at` = '2018-03-08 12:29:02' WHERE `fact_values`.`id` = 610
  116. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 23 ORDER BY fact_names.name LIMIT 1
  117. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 60 ORDER BY fact_names.name LIMIT 1
  118. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 58 ORDER BY fact_names.name LIMIT 1
  119. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 71 ORDER BY fact_names.name LIMIT 1
  120. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (12.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 18 ORDER BY fact_names.name LIMIT 1
  121. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 59 ORDER BY fact_names.name LIMIT 1
  122. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 180 ORDER BY fact_names.name LIMIT 1
  123. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 85 ORDER BY fact_names.name LIMIT 1
  124. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 181 ORDER BY fact_names.name LIMIT 1
  125. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (1.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 182 ORDER BY fact_names.name LIMIT 1
  126. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (1.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 183 ORDER BY fact_names.name LIMIT 1
  127. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (6.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 128 ORDER BY fact_names.name LIMIT 1
  128. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 129 ORDER BY fact_names.name LIMIT 1
  129. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 130 ORDER BY fact_names.name LIMIT 1
  130. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 133 ORDER BY fact_names.name LIMIT 1
  131. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 4 ORDER BY fact_names.name LIMIT 1
  132. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 9 ORDER BY fact_names.name LIMIT 1
  133. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (1.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 134 ORDER BY fact_names.name LIMIT 1
  134. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (1.3ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 184 ORDER BY fact_names.name LIMIT 1
  135. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 185 ORDER BY fact_names.name LIMIT 1
  136. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 10 ORDER BY fact_names.name LIMIT 1
  137. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 188 ORDER BY fact_names.name LIMIT 1
  138. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 189 ORDER BY fact_names.name LIMIT 1
  139. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 190 ORDER BY fact_names.name LIMIT 1
  140. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (5.3ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 191 ORDER BY fact_names.name LIMIT 1
  141. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 192 ORDER BY fact_names.name LIMIT 1
  142. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 193 ORDER BY fact_names.name LIMIT 1
  143. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 194 ORDER BY fact_names.name LIMIT 1
  144. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 195 ORDER BY fact_names.name LIMIT 1
  145. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 196 ORDER BY fact_names.name LIMIT 1
  146. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 197 ORDER BY fact_names.name LIMIT 1
  147. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 198 ORDER BY fact_names.name LIMIT 1
  148. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 199 ORDER BY fact_names.name LIMIT 1
  149. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 200 ORDER BY fact_names.name LIMIT 1
  150. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 201 ORDER BY fact_names.name LIMIT 1
  151. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 202 ORDER BY fact_names.name LIMIT 1
  152. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 203 ORDER BY fact_names.name LIMIT 1
  153. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (1.0ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 204 ORDER BY fact_names.name LIMIT 1
  154. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 205 ORDER BY fact_names.name LIMIT 1
  155. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 206 ORDER BY fact_names.name LIMIT 1
  156. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 207 ORDER BY fact_names.name LIMIT 1
  157. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 208 ORDER BY fact_names.name LIMIT 1
  158. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 209 ORDER BY fact_names.name LIMIT 1
  159. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 210 ORDER BY fact_names.name LIMIT 1
  160. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 211 ORDER BY fact_names.name LIMIT 1
  161. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (7.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 212 ORDER BY fact_names.name LIMIT 1
  162. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 213 ORDER BY fact_names.name LIMIT 1
  163. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 214 ORDER BY fact_names.name LIMIT 1
  164. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 215 ORDER BY fact_names.name LIMIT 1
  165. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 216 ORDER BY fact_names.name LIMIT 1
  166. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 217 ORDER BY fact_names.name LIMIT 1
  167. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 218 ORDER BY fact_names.name LIMIT 1
  168. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 219 ORDER BY fact_names.name LIMIT 1
  169. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 228 ORDER BY fact_names.name LIMIT 1
  170. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 65 ORDER BY fact_names.name LIMIT 1
  171. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 69 ORDER BY fact_names.name LIMIT 1
  172. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 124 ORDER BY fact_names.name LIMIT 1
  173. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 57 ORDER BY fact_names.name LIMIT 1
  174. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 39 ORDER BY fact_names.name LIMIT 1
  175. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 87 ORDER BY fact_names.name LIMIT 1
  176. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.8ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 64 ORDER BY fact_names.name LIMIT 1
  177. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 135 ORDER BY fact_names.name LIMIT 1
  178. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.4ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 229 ORDER BY fact_names.name LIMIT 1
  179. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 136 ORDER BY fact_names.name LIMIT 1
  180. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 137 ORDER BY fact_names.name LIMIT 1
  181. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 138 ORDER BY fact_names.name LIMIT 1
  182. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 139 ORDER BY fact_names.name LIMIT 1
  183. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 230 ORDER BY fact_names.name LIMIT 1
  184. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 231 ORDER BY fact_names.name LIMIT 1
  185. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 232 ORDER BY fact_names.name LIMIT 1
  186. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 233 ORDER BY fact_names.name LIMIT 1
  187. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 234 ORDER BY fact_names.name LIMIT 1
  188. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 235 ORDER BY fact_names.name LIMIT 1
  189. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 88 ORDER BY fact_names.name LIMIT 1
  190. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.5ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 94 ORDER BY fact_names.name LIMIT 1
  191. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 89 ORDER BY fact_names.name LIMIT 1
  192. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 97 ORDER BY fact_names.name LIMIT 1
  193. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.7ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 98 ORDER BY fact_names.name LIMIT 1
  194. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 99 ORDER BY fact_names.name LIMIT 1
  195. 2018-03-08T13:29:03 08095d8e [sql] [D] FactName Load (0.6ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 100 ORDER BY fact_names.name LIMIT 1
  196. 2018-03-08T13:29:03 08095d8e [audit] [I] [game.inparadise.se] updated 4 (1643.2ms)
  197. 2018-03-08T13:29:03 08095d8e [audit] [D] "{\"uptime_seconds\"=>\"2990328\", \"system_uptime::seconds\"=>\"2990328\", \"memoryfree\"=>\"1.35 GB\", \"memoryfree_mb\"=>\"1385.36\"}"
  198. 2018-03-08T13:29:03 08095d8e [sql] [D] (2.5ms) SELECT `fact_values`.`fact_name_id` FROM `fact_values` WHERE `fact_values`.`host_id` = 7 AND `fact_values`.`fact_name_id` IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 18, 19, 22, 23, 24, 25, 26, 29, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 63, 64, 65, 66, 67, 68, 69, 70, 71, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 94, 97, 98, 99, 100, 119, 120, 121, 124, 125, 126, 127, 128, 129, 130, 133, 134, 135, 136, 137, 138, 139, 140, 141, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 228, 229, 230, 231, 232, 233, 234, 235)
  199. 2018-03-08T13:29:03 08095d8e [audit] [I] [game.inparadise.se] added 0 (11.1ms)
  200. 2018-03-08T13:29:03 08095d8e [audit] [D] "{}"
  201. 2018-03-08T13:29:03 08095d8e [sql] [D] (9.1ms) COMMIT
  202. 2018-03-08T13:29:03 08095d8e [app] [I] Import facts for 'game.inparadise.se' completed. Added: 0, Updated: 4, Deleted 0 facts
  203. 2018-03-08T13:29:03 08095d8e [sql] [D] (0.3ms) BEGIN
  204. 2018-03-08T13:29:03 08095d8e [sql] [D] Hostgroup Load (0.7ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 2 ORDER BY hostgroups.title LIMIT 1
  205. 2018-03-08T13:29:03 08095d8e [sql] [D] Setting Load (0.6ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'root_pass' ORDER BY `settings`.`name` ASC LIMIT 1
  206. 2018-03-08T13:29:03 08095d8e [sql] [D] CACHE Setting Load (0.0ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'root_pass' ORDER BY `settings`.`name` ASC LIMIT 1 [["name", "root_pass"], ["LIMIT", 1]]
  207. 2018-03-08T13:29:05 08095d8e [sql] [D] Nic::Base Load (1396.0ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 ORDER BY `nics`.`identifier` ASC
  208. 2018-03-08T13:29:14 08095d8e [sql] [D] Domain Load (0.6ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  209. 2018-03-08T13:29:27 08095d8e [sql] [D] (0.8ms) SELECT COUNT(*) FROM `permissions` WHERE `permissions`.`resource_type` = 'Host' AND (permissions.name LIKE 'edit_%')
  210. 2018-03-08T13:29:27 08095d8e [sql] [D] Permission Load (0.8ms) SELECT `permissions`.* FROM `permissions` WHERE `permissions`.`resource_type` = 'Host' AND (permissions.name LIKE 'edit_%')
  211. 2018-03-08T13:29:27 08095d8e [permissions] [D] verifying the transaction by permission edit_hosts for class Host::Managed
  212. 2018-03-08T13:29:27 08095d8e [sql] [D] (0.4ms) COMMIT
  213. 2018-03-08T13:29:27 08095d8e [sql] [D] Setting Load (0.6ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ignore_facts_for_operatingsystem' ORDER BY `settings`.`name` ASC LIMIT 1
  214. 2018-03-08T13:29:27 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ignore_facts_for_domain' ORDER BY `settings`.`name` ASC LIMIT 1
  215. 2018-03-08T13:29:27 08095d8e [sql] [D] Model Load (2.9ms) SELECT `models`.* FROM `models` WHERE `models`.`name` = 'System Product Name' ORDER BY models.name LIMIT 1
  216. 2018-03-08T13:29:27 08095d8e [sql] [D] Architecture Load (0.6ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`name` = 'x86_64' ORDER BY `architectures`.`id` ASC LIMIT 1
  217. 2018-03-08T13:29:27 08095d8e [sql] [D] Operatingsystem Load (4.5ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`name` = 'CentOS' AND `operatingsystems`.`major` = '7' AND `operatingsystems`.`minor` = '4.1708' ORDER BY `operatingsystems`.`title` ASC LIMIT 1
  218. 2018-03-08T13:29:27 08095d8e [sql] [D] (0.4ms) BEGIN
  219. 2018-03-08T13:29:27 08095d8e [sql] [D] OsParameter Load (0.8ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 2 ORDER BY parameters.name
  220. 2018-03-08T13:29:27 08095d8e [sql] [D] Operatingsystem Exists (0.7ms) SELECT 1 AS one FROM `operatingsystems` WHERE `operatingsystems`.`name` = BINARY 'CentOS' AND (`operatingsystems`.`id` != 2) AND `operatingsystems`.`major` = '7' AND `operatingsystems`.`minor` = '4.1708' LIMIT 1
  221. 2018-03-08T13:29:27 08095d8e [sql] [D] Operatingsystem Exists (0.7ms) SELECT 1 AS one FROM `operatingsystems` WHERE `operatingsystems`.`description` = BINARY 'CentOS Linux 7.4.1708' AND (`operatingsystems`.`id` != 2) LIMIT 1
  222. 2018-03-08T13:29:27 08095d8e [sql] [D] Operatingsystem Exists (0.7ms) SELECT 1 AS one FROM `operatingsystems` WHERE `operatingsystems`.`title` = BINARY 'CentOS Linux 7.4.1708' AND (`operatingsystems`.`id` != 2) LIMIT 1
  223. 2018-03-08T13:29:27 08095d8e [sql] [D] (0.9ms) SELECT COUNT(*) FROM `permissions` WHERE `permissions`.`resource_type` = 'Operatingsystem' AND (permissions.name LIKE 'edit_%')
  224. 2018-03-08T13:29:27 08095d8e [sql] [D] Permission Load (0.9ms) SELECT `permissions`.* FROM `permissions` WHERE `permissions`.`resource_type` = 'Operatingsystem' AND (permissions.name LIKE 'edit_%') ORDER BY `permissions`.`id` ASC LIMIT 1
  225. 2018-03-08T13:29:27 08095d8e [permissions] [D] verifying the transaction by permission edit_operatingsystems for class Redhat
  226. 2018-03-08T13:29:27 08095d8e [sql] [D] (0.4ms) COMMIT
  227. 2018-03-08T13:29:27 08095d8e [sql] [D] Domain Load (10.5ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'inparadise.se' ORDER BY domains.name LIMIT 1
  228. 2018-03-08T13:29:27 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ignore_puppet_facts_for_provisioning' ORDER BY `settings`.`name` ASC LIMIT 1
  229. 2018-03-08T13:29:27 08095d8e [sql] [D] Setting Load (0.7ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ignored_interface_identifiers' ORDER BY `settings`.`name` ASC LIMIT 1
  230. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier '_vdsmdummy_' since it was matched by 'ignored_interface_identifiers' setting
  231. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier 'lo' since it was matched by 'ignored_interface_identifiers' setting
  232. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier 'vnet0' since it was matched by 'ignored_interface_identifiers' setting
  233. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier 'vnet1' since it was matched by 'ignored_interface_identifiers' setting
  234. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier 'vnet3' since it was matched by 'ignored_interface_identifiers' setting
  235. 2018-03-08T13:29:27 08095d8e [app] [D] skipping interface with identifier 'vnet5' since it was matched by 'ignored_interface_identifiers' setting
  236. 2018-03-08T13:29:27 08095d8e [app] [D] We have following interfaces 'jumbo_nfs_1, jumbo_nfs_2, jumbo_iscsi_1, jumbo_iscsi_2, eno1, eno1_12, eno1_13, eno1_14, eno1_15, eno1_101, ovirtmgmt' based on facts
  237. 2018-03-08T13:29:27 08095d8e [app] [D] Interface jumbo_nfs_1 facts: {"ipaddress"=>"172.16.12.12", "macaddress"=>"54:04:a6:01:f8:a8", "netmask"=>"255.255.255.0", "mtu"=>9000, "network"=>"172.16.12.0"}
  238. 2018-03-08T13:29:27 08095d8e [app] [D] Interface jumbo_nfs_2 facts: {"ipaddress"=>"172.16.22.12", "macaddress"=>"54:04:a6:01:f8:a8", "netmask"=>"255.255.255.0", "mtu"=>9000, "network"=>"172.16.22.0"}
  239. 2018-03-08T13:29:27 08095d8e [app] [D] Interface jumbo_iscsi_1 facts: {"ipaddress"=>"172.16.13.12", "macaddress"=>"54:04:a6:01:f8:a8", "netmask"=>"255.255.255.0", "mtu"=>9000, "network"=>"172.16.13.0"}
  240. 2018-03-08T13:29:27 08095d8e [app] [D] Interface jumbo_iscsi_2 facts: {"ipaddress"=>"172.16.23.12", "macaddress"=>"54:04:a6:01:f8:a8", "netmask"=>"255.255.255.0", "mtu"=>9000, "network"=>"172.16.23.0"}
  241. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>9000}
  242. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1_12 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>9000}
  243. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1_13 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>9000}
  244. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1_14 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>9000}
  245. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1_15 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>9000}
  246. 2018-03-08T13:29:27 08095d8e [app] [D] Interface eno1_101 facts: {"macaddress"=>"54:04:a6:01:f8:a8", "mtu"=>1500}
  247. 2018-03-08T13:29:27 08095d8e [app] [D] Interface ovirtmgmt facts: {"ipaddress"=>"172.16.1.118", "macaddress"=>"54:04:a6:01:f8:a8", "netmask"=>"255.255.255.0", "mtu"=>1500, "network"=>"172.16.1.0"}
  248. 2018-03-08T13:29:27 08095d8e [sql] [D] Nic::Base Exists (0.7ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1
  249. 2018-03-08T13:29:28 08095d8e [sql] [D] Nic::Base Load (136.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1
  250. 2018-03-08T13:29:28 08095d8e [sql] [D] Nic::Base Load (1.3ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`type` = 'Nic::Bond' AND `nics`.`managed` = 1 ORDER BY `nics`.`identifier` ASC
  251. 2018-03-08T13:29:28 08095d8e [sql] [D] Setting Load (0.6ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'update_subnets_from_facts' ORDER BY `settings`.`name` ASC LIMIT 1
  252. 2018-03-08T13:29:28 08095d8e [sql] [D] Nic::Base Load (99.7ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`attached_to` = 'eno1' AND `nics`.`virtual` = 1 ORDER BY `nics`.`identifier` ASC
  253. 2018-03-08T13:29:28 08095d8e [sql] [D] (0.5ms) BEGIN
  254. 2018-03-08T13:30:33 08095d8e [sql] [D] Nic::Base Load (0.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`id` = 33388 LIMIT 1
  255. 2018-03-08T13:30:33 08095d8e [sql] [D] Nic::Managed Load (0.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`type` IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bridge') AND `nics`.`id` = 33388 LIMIT 1
  256. 2018-03-08T13:30:33 08095d8e [sql] [D] Audited::Audit Load (0.8ms) SELECT `audits`.* FROM `audits` WHERE `audits`.`auditable_id` = 33388 AND `audits`.`auditable_type` = 'Nic::Managed' ORDER BY `audits`.`version` DESC LIMIT 1
  257. 2018-03-08T13:30:33 08095d8e [sql] [D] SQL (0.8ms) INSERT INTO `audits` (`auditable_id`, `auditable_type`, `user_id`, `username`, `action`, `audited_changes`, `version`, `associated_id`, `associated_type`, `request_uuid`, `created_at`, `remote_address`, `associated_name`) VALUES (33388, 'Nic::Managed', 2, 'API Admin', 'update', '--- !ruby/hash:ActiveSupport::HashWithIndifferentAccess\nattached_to:\n- eno1\n- jumbo_nfs_1\nidentifier:\n- eno1.13\n- jumbo_nfs_1.13\n', 2, 7, 'Host::Base', '08095d8e-1e6f-42d6-af7a-d9f79da386ea', '2018-03-08 12:30:33', '172.16.1.11', 'game.inparadise.se')
  258. 2018-03-08T13:30:33 08095d8e [sql] [D] SQL (0.7ms) UPDATE `nics` SET `attached_to` = 'jumbo_nfs_1', `identifier` = 'jumbo_nfs_1.13', `updated_at` = '2018-03-08 12:30:33' WHERE `nics`.`id` = 33388
  259. 2018-03-08T13:30:33 08095d8e [sql] [D] (159.4ms) COMMIT
  260. 2018-03-08T13:30:33 08095d8e [sql] [D] (0.3ms) BEGIN
  261. 2018-03-08T13:31:11 08095d8e [sql] [D] Nic::Base Load (0.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`id` = 33389 LIMIT 1
  262. 2018-03-08T13:31:11 08095d8e [sql] [D] Nic::Managed Load (0.7ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`type` IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bridge') AND `nics`.`id` = 33389 LIMIT 1
  263. 2018-03-08T13:31:11 08095d8e [sql] [D] Audited::Audit Load (0.9ms) SELECT `audits`.* FROM `audits` WHERE `audits`.`auditable_id` = 33389 AND `audits`.`auditable_type` = 'Nic::Managed' ORDER BY `audits`.`version` DESC LIMIT 1
  264. 2018-03-08T13:31:11 08095d8e [sql] [D] SQL (1.0ms) INSERT INTO `audits` (`auditable_id`, `auditable_type`, `user_id`, `username`, `action`, `audited_changes`, `version`, `associated_id`, `associated_type`, `request_uuid`, `created_at`, `remote_address`, `associated_name`) VALUES (33389, 'Nic::Managed', 2, 'API Admin', 'update', '--- !ruby/hash:ActiveSupport::HashWithIndifferentAccess\nattached_to:\n- eno1\n- jumbo_nfs_1\nidentifier:\n- eno1.14\n- jumbo_nfs_1.14\n', 2, 7, 'Host::Base', '08095d8e-1e6f-42d6-af7a-d9f79da386ea', '2018-03-08 12:31:11', '172.16.1.11', 'game.inparadise.se')
  265. 2018-03-08T13:31:11 08095d8e [sql] [D] SQL (0.9ms) UPDATE `nics` SET `attached_to` = 'jumbo_nfs_1', `identifier` = 'jumbo_nfs_1.14', `updated_at` = '2018-03-08 12:31:11' WHERE `nics`.`id` = 33389
  266. 2018-03-08T13:31:11 08095d8e [sql] [D] (18.0ms) COMMIT
  267. 2018-03-08T13:31:11 08095d8e [sql] [D] (0.4ms) BEGIN
  268. 2018-03-08T13:31:49 08095d8e [sql] [D] Nic::Base Load (2.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`id` = 33390 LIMIT 1
  269. 2018-03-08T13:31:49 08095d8e [sql] [D] Nic::Managed Load (1.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`type` IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bridge') AND `nics`.`id` = 33390 LIMIT 1
  270. 2018-03-08T13:31:49 08095d8e [sql] [D] Audited::Audit Load (0.7ms) SELECT `audits`.* FROM `audits` WHERE `audits`.`auditable_id` = 33390 AND `audits`.`auditable_type` = 'Nic::Managed' ORDER BY `audits`.`version` DESC LIMIT 1
  271. 2018-03-08T13:31:49 08095d8e [sql] [D] SQL (0.8ms) INSERT INTO `audits` (`auditable_id`, `auditable_type`, `user_id`, `username`, `action`, `audited_changes`, `version`, `associated_id`, `associated_type`, `request_uuid`, `created_at`, `remote_address`, `associated_name`) VALUES (33390, 'Nic::Managed', 2, 'API Admin', 'update', '--- !ruby/hash:ActiveSupport::HashWithIndifferentAccess\nattached_to:\n- eno1\n- jumbo_nfs_1\nidentifier:\n- eno1.15\n- jumbo_nfs_1.15\n', 2, 7, 'Host::Base', '08095d8e-1e6f-42d6-af7a-d9f79da386ea', '2018-03-08 12:31:49', '172.16.1.11', 'game.inparadise.se')
  272. 2018-03-08T13:31:49 08095d8e [sql] [D] SQL (1.3ms) UPDATE `nics` SET `attached_to` = 'jumbo_nfs_1', `identifier` = 'jumbo_nfs_1.15', `updated_at` = '2018-03-08 12:31:49' WHERE `nics`.`id` = 33390
  273. 2018-03-08T13:31:49 08095d8e [sql] [D] (6.9ms) COMMIT
  274. 2018-03-08T13:31:49 08095d8e [app] [D] Saving jumbo_nfs_1 NIC for host game.inparadise.se
  275. 2018-03-08T13:31:49 08095d8e [sql] [D] (0.5ms) BEGIN
  276. 2018-03-08T13:32:21 08095d8e [sql] [D] Domain Load (0.8ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  277. 2018-03-08T13:32:21 08095d8e [sql] [D] Setting Load (0.6ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'append_domain_name_for_hosts' ORDER BY `settings`.`name` ASC LIMIT 1
  278. 2018-03-08T13:32:22 08095d8e [sql] [D] Subnet Load (0.7ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 AND `subnets`.`type` = 'Subnet::Ipv4' ORDER BY `subnets`.`vlanid` ASC LIMIT 1
  279. 2018-03-08T13:32:22 08095d8e [sql] [D] Nic::Base Load (0.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`ip` = '172.16.12.12'
  280. 2018-03-08T13:32:22 08095d8e [sql] [D] Nic::Base Load (0.9ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`domain_id` = 1 AND `nics`.`name` = 'game.inparadise.se'
  281. 2018-03-08T13:32:22 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  282. 2018-03-08T13:32:22 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  283. 2018-03-08T13:32:22 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  284. 2018-03-08T13:32:22 08095d8e [sql] [D] (0.6ms) ROLLBACK
  285. 2018-03-08T13:32:22 08095d8e [app] [W] Saving jumbo_nfs_1 NIC for host game.inparadise.se failed, skipping because:
  286. 2018-03-08T13:32:22 08095d8e [app] [W] IP address does not match selected subnet
  287. 2018-03-08T13:32:22 08095d8e [sql] [D] Nic::Base Exists (0.8ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1
  288. 2018-03-08T13:32:22 08095d8e [sql] [D] Nic::Base Load (52.4ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1
  289. 2018-03-08T13:32:22 08095d8e [sql] [D] Nic::Base Load (0.9ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`type` = 'Nic::Bond' AND `nics`.`managed` = 1 ORDER BY `nics`.`identifier` ASC
  290. 2018-03-08T13:32:23 08095d8e [sql] [D] Nic::Base Load (59.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`attached_to` = 'eno1' AND `nics`.`virtual` = 1 ORDER BY `nics`.`identifier` ASC
  291. 2018-03-08T13:32:23 08095d8e [app] [D] Saving jumbo_nfs_2 NIC for host game.inparadise.se
  292. 2018-03-08T13:32:23 08095d8e [sql] [D] (0.4ms) BEGIN
  293. 2018-03-08T13:32:58 08095d8e [sql] [D] Domain Load (1.4ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  294. 2018-03-08T13:32:59 08095d8e [sql] [D] Subnet Load (0.8ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 AND `subnets`.`type` = 'Subnet::Ipv4' ORDER BY `subnets`.`vlanid` ASC LIMIT 1
  295. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Load (0.7ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`ip` = '172.16.22.12'
  296. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Load (0.9ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`domain_id` = 1 AND `nics`.`name` = 'game.inparadise.se'
  297. 2018-03-08T13:32:59 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  298. 2018-03-08T13:32:59 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  299. 2018-03-08T13:32:59 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  300. 2018-03-08T13:32:59 08095d8e [sql] [D] (0.4ms) ROLLBACK
  301. 2018-03-08T13:32:59 08095d8e [app] [W] Saving jumbo_nfs_2 NIC for host game.inparadise.se failed, skipping because:
  302. 2018-03-08T13:32:59 08095d8e [app] [W] IP address does not match selected subnet
  303. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Exists (0.8ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1
  304. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Load (81.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1
  305. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Load (3.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`type` = 'Nic::Bond' AND `nics`.`managed` = 1 ORDER BY `nics`.`identifier` ASC
  306. 2018-03-08T13:32:59 08095d8e [sql] [D] Nic::Base Load (118.4ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`attached_to` = 'eno1' AND `nics`.`virtual` = 1 ORDER BY `nics`.`identifier` ASC
  307. 2018-03-08T13:32:59 08095d8e [app] [D] Saving jumbo_iscsi_1 NIC for host game.inparadise.se
  308. 2018-03-08T13:32:59 08095d8e [sql] [D] (0.6ms) BEGIN
  309. 2018-03-08T13:33:36 08095d8e [sql] [D] Domain Load (3.0ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  310. 2018-03-08T13:33:37 08095d8e [sql] [D] Subnet Load (1.1ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 AND `subnets`.`type` = 'Subnet::Ipv4' ORDER BY `subnets`.`vlanid` ASC LIMIT 1
  311. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Load (0.9ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`ip` = '172.16.13.12'
  312. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Load (0.8ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`domain_id` = 1 AND `nics`.`name` = 'game.inparadise.se'
  313. 2018-03-08T13:33:37 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  314. 2018-03-08T13:33:37 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  315. 2018-03-08T13:33:37 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  316. 2018-03-08T13:33:37 08095d8e [sql] [D] (0.4ms) ROLLBACK
  317. 2018-03-08T13:33:37 08095d8e [app] [W] Saving jumbo_iscsi_1 NIC for host game.inparadise.se failed, skipping because:
  318. 2018-03-08T13:33:37 08095d8e [app] [W] IP address does not match selected subnet
  319. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Exists (0.7ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1
  320. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Load (82.4ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1
  321. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Load (1.0ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`type` = 'Nic::Bond' AND `nics`.`managed` = 1 ORDER BY `nics`.`identifier` ASC
  322. 2018-03-08T13:33:37 08095d8e [sql] [D] Nic::Base Load (67.5ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`attached_to` = 'eno1' AND `nics`.`virtual` = 1 ORDER BY `nics`.`identifier` ASC
  323. 2018-03-08T13:33:37 08095d8e [app] [D] Saving jumbo_iscsi_2 NIC for host game.inparadise.se
  324. 2018-03-08T13:33:37 08095d8e [sql] [D] (0.4ms) BEGIN
  325. 2018-03-08T13:34:18 08095d8e [sql] [D] Domain Load (1.1ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  326. 2018-03-08T13:34:19 08095d8e [sql] [D] Subnet Load (1.6ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 AND `subnets`.`type` = 'Subnet::Ipv4' ORDER BY `subnets`.`vlanid` ASC LIMIT 1
  327. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Load (1.5ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`ip` = '172.16.23.12'
  328. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Load (1.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`domain_id` = 1 AND `nics`.`name` = 'game.inparadise.se'
  329. 2018-03-08T13:34:19 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  330. 2018-03-08T13:34:19 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  331. 2018-03-08T13:34:19 08095d8e [app] [W] Not queueing Nic::Managed: ["IP address does not match selected subnet"]
  332. 2018-03-08T13:34:19 08095d8e [sql] [D] (0.5ms) ROLLBACK
  333. 2018-03-08T13:34:19 08095d8e [app] [W] Saving jumbo_iscsi_2 NIC for host game.inparadise.se failed, skipping because:
  334. 2018-03-08T13:34:19 08095d8e [app] [W] IP address does not match selected subnet
  335. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Exists (0.6ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1
  336. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Load (61.9ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1
  337. 2018-03-08T13:34:19 08095d8e [sql] [D] CACHE Nic::Base Exists (0.1ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 LIMIT 1 [["host_id", 7], ["mac", "54:04:a6:01:f8:a8"], ["virtual", 0], ["LIMIT", 1]]
  338. 2018-03-08T13:34:19 08095d8e [sql] [D] CACHE Nic::Base Load (0.0ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`mac` = '54:04:a6:01:f8:a8' AND `nics`.`virtual` = 0 ORDER BY `nics`.`identifier` ASC LIMIT 1 [["host_id", 7], ["mac", "54:04:a6:01:f8:a8"], ["virtual", 0], ["LIMIT", 1]]
  339. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Load (1.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`type` = 'Nic::Bond' AND `nics`.`managed` = 1 ORDER BY `nics`.`identifier` ASC
  340. 2018-03-08T13:34:19 08095d8e [sql] [D] Nic::Base Load (92.5ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 7 AND `nics`.`attached_to` = 'eno1' AND `nics`.`virtual` = 1 ORDER BY `nics`.`identifier` ASC
  341. 2018-03-08T13:34:19 08095d8e [app] [D] Saving ovirtmgmt NIC for host game.inparadise.se
  342. 2018-03-08T13:34:19 08095d8e [sql] [D] (0.3ms) BEGIN
  343. 2018-03-08T13:35:00 08095d8e [sql] [D] Domain Load (14.2ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  344. 2018-03-08T13:35:00 08095d8e [sql] [D] Subnet Load (26.3ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 AND `subnets`.`type` = 'Subnet::Ipv4' ORDER BY `subnets`.`vlanid` ASC LIMIT 1
  345. 2018-03-08T13:35:00 08095d8e [sql] [D] Nic::Base Load (3.1ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`ip` = '172.16.1.118'
  346. 2018-03-08T13:35:00 08095d8e [sql] [D] Nic::Base Load (10.5ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`domain_id` = 1 AND `nics`.`name` = 'game.inparadise.se'
  347. 2018-03-08T13:35:00 08095d8e [sql] [D] (0.8ms) ROLLBACK
  348. 2018-03-08T13:35:00 08095d8e [app] [W] Action failed
  349. 2018-03-08T13:35:00 08095d8e [app] [I] Rendering api/v2/errors/standard_error.json.rabl within api/v2/layouts/error_layout
  350. 2018-03-08T13:35:00 08095d8e [app] [I] Rendered api/v2/errors/standard_error.json.rabl within api/v2/layouts/error_layout (2.5ms)
  351. 2018-03-08T13:35:00 08095d8e [app] [I] Completed 500 Internal Server Error in 359479ms (Views: 32.8ms | ActiveRecord: 2924.8ms)
  352. 2018-03-08T13:35:03 08095d8e [app] [F]
  353. 2018-03-08T13:35:03 08095d8e [app] [F] ActiveRecord::StatementInvalid (Mysql2::Error: This connection is still waiting for a result, try again once you have the result: SELECT `sessions`.* FROM `sessions` WHERE `sessions`.`session_id` = 'b39dffb93af6fbbc82e7a74d29b4010b' ORDER BY `sessions`.`id` ASC LIMIT 1):
  354. 2018-03-08T13:35:03 08095d8e [app] [F]
  355. 2018-03-08T13:35:03 08095d8e [app] [F] lib/foreman/silenced_logger.rb:37:in `silence'
Add Comment
Please, Sign In to add comment