Skip to content

Instantly share code, notes, and snippets.

/spc01 Secret

Created September 21, 2017 00:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/a20f4097396037cd30903d232a3e6d0f to your computer and use it in GitHub Desktop.
Save anonymous/a20f4097396037cd30903d232a3e6d0f to your computer and use it in GitHub Desktop.
mysql deadlocks
2017-09-20 04:37:09 0bf29fad [app] [E] Fact processor32 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 115, 109229, '2017-09-20 11:37:09', '2017-09-20 11:37:09')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 115, 109229, '2017-09-20 11:37:09', '2017-09-20 11:37:09')
2017-09-20 08:30:14 b8a9768a [app] [E] Fact processor2_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 241 AND `fact_values`.`host_id` = 109253) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 241 AND `fact_values`.`host_id` = 109253) LIMIT 1
2017-09-20 09:34:00 5ba54f37 [app] [E] Fact wol_eth1 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 427 AND `fact_values`.`host_id` = 109298) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 427 AND `fact_values`.`host_id` = 109298) LIMIT 1
| Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction
2017-09-20 12:22:53 da1c2a48 [app] [E] Fact bmc_netmask could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('255.255.255.0', 163, 109415, '2017-09-20 19:22:53', '2017-09-20 19:22:53')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('255.255.255.0', 163, 109415, '2017-09-20 19:22:53', '2017-09-20 19:22:53')
2017-09-20 12:24:55 dbd870cf [app] [E] Fact processor52_frequency could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 498 AND `fact_values`.`host_id` = 109442) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 498 AND `fact_values`.`host_id` = 109442) LIMIT 1
2017-09-20 12:25:24 415d83e6 [app] [E] Fact processor23 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 97, 109454, '2017-09-20 19:25:24', '2017-09-20 19:25:24')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 97, 109454, '2017-09-20 19:25:24', '2017-09-20 19:25:24')
2017-09-20 12:25:59 5d519f3b [app] [E] Fact processor57 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 464 AND `fact_values`.`host_id` = 109481) LIMIT 1
2017-09-20 12:26:05 5d519f3b [app] [E] Fact processor6_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 257, 109481, '2017-09-20 19:26:01', '2017-09-20 19:26:01')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 257, 109481, '2017-09-20 19:26:01', '2017-09-20 19:26:01')
2017-09-20 12:26:46 cdf0e71e [app] [E] Fact serialnumber could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 46 AND `fact_values`.`host_id` = 109511) LIMIT 1
2017-09-20 12:26:55 cdf0e71e [app] [E] Fact processor28_frequency could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('1200', 343, 109511, '2017-09-20 19:26:52', '2017-09-20 19:26:52')
2017-09-20 12:26:55 e18b2672 [app] [E] Fact serialnumber could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('EBY0627171736', 46, 109514, '2017-09-20 19:26:55', '2017-09-20 19:26:55')
2017-09-20 12:27:01 e18b2672 [app] [E] Fact network_eth1 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('169.254.1.0', 54, 109514, '2017-09-20 19:26:59', '2017-09-20 19:26:59')
2017-09-20 12:27:01 85bb541a [app] [E] Fact lib could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('/var/www/minios/local/facter:/var/www/minios/foreman', 1, 109517, '2017-09-20 19:27:01', '2017-09-20 19:27:01')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('1200', 343, 109511, '2017-09-20 19:26:52', '2017-09-20 19:26:52')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('169.254.1.0', 54, 109514, '2017-09-20 19:26:59', '2017-09-20 19:26:59')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('/var/www/minios/local/facter:/var/www/minios/foreman', 1, 109517, '2017-09-20 19:27:01', '2017-09-20 19:27:01')
2017-09-20 12:27:49 e5a384f8 [app] [E] Fact processor29 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 109, 109547, '2017-09-20 19:27:49', '2017-09-20 19:27:49')
2017-09-20 12:27:55 e5a384f8 [app] [E] Fact processor10_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 273, 109547, '2017-09-20 19:27:52', '2017-09-20 19:27:52')
2017-09-20 12:27:55 9eb1826f [app] [E] Fact blockdevice_sda_model could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('TOSHIBA MG04ACA2', 21, 109550, '2017-09-20 19:27:55', '2017-09-20 19:27:55')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 273, 109547, '2017-09-20 19:27:52', '2017-09-20 19:27:52')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('TOSHIBA MG04ACA2', 21, 109550, '2017-09-20 19:27:55', '2017-09-20 19:27:55')
2017-09-20 12:28:47 b49b9706 [app] [E] Fact nic1_macaddress could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'nic1_macaddress' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'nic1_macaddress' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
2017-09-20 12:29:01 9186f576 [app] [E] Fact core_count could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('16', 175, 109574, '2017-09-20 19:29:01', '2017-09-20 19:29:01')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('16', 175, 109574, '2017-09-20 19:29:01', '2017-09-20 19:29:01')
2017-09-20 12:29:41 6c4b4a4e [app] [E] Fact default_gateway_device could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 179 AND `fact_values`.`host_id` = 109589) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 179 AND `fact_values`.`host_id` = 109589) LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.233:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 429 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.241:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 13 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.212:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 427 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.231:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 201 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.215:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 153 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.243:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 448 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.234:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 157 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.211:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109323 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.69.239:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 155 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.214:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 223 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.210:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 191 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.212:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109274 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.247:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: COMMIT
| RuntimeError: Could not get facts from proxy https://10.84.69.217:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 35 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.211:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109341 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.214:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109338 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.232:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 417 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.231:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 62 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.220:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 315 ORDER BY fact_names.name LIMIT 1
2017-09-20 14:20:54 0c8480da [app] [E] Fact port_eth0 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Direct Attach Copper', 413, 109628, '2017-09-20 21:20:54', '2017-09-20 21:20:54')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Direct Attach Copper', 413, 109628, '2017-09-20 21:20:54', '2017-09-20 21:20:54')
| Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction
2017-09-20 14:24:23 44c3cfae [app] [E] Fact processor5_frequency could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor5_frequency' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor5_frequency' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.233:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 73 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.200:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109618 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.69.210:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 255 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.241:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109268 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.254:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 257 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.225:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 434 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.218:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 409 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.212:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 411 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.234:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 393 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.221:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 45 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.222:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109292 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.219:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT fact_names.name FROM `fact_values` INNER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` WHERE `fact_values`.`host_id` = 109674 AND (fact_names.type = 'PuppetFactName')
| RuntimeError: Could not get facts from proxy https://10.84.71.217:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 430 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.244:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 405 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.206:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 448 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.224:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 424 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.245:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109344 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
2017-09-20 08:28:12 474d3b3c [app] [E] Fact processor39_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 389 AND `fact_values`.`host_id` = 109245) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 389 AND `fact_values`.`host_id` = 109245) LIMIT 1
2017-09-20 09:34:12 933d84c9 [app] [E] Fact core_count could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'core_count' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'core_count' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
2017-09-20 09:36:01 f13c130c [app] [E] Fact network_eth0 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('10.84.64.0', 53, 109326, '2017-09-20 16:36:01', '2017-09-20 16:36:01')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('10.84.64.0', 53, 109326, '2017-09-20 16:36:01', '2017-09-20 16:36:01')
2017-09-20 12:24:46 29445d7f [app] [E] Fact processor44_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 410, 109440, '2017-09-20 19:24:46', '2017-09-20 19:24:46')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 410, 109440, '2017-09-20 19:24:46', '2017-09-20 19:24:46')
2017-09-20 12:26:21 3eeb6639 [app] [E] Fact processor45 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 141 AND `fact_values`.`host_id` = 109500) LIMIT 1
2017-09-20 12:26:25 3eeb6639 [app] [E] Fact processorcount could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('64', 132, 109500, '2017-09-20 19:26:22', '2017-09-20 19:26:22')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('64', 132, 109500, '2017-09-20 19:26:22', '2017-09-20 19:26:22')
2017-09-20 12:26:46 3172310e [app] [E] Fact lsbdistdescription could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 35 AND `fact_values`.`host_id` = 109509) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 35 AND `fact_values`.`host_id` = 109509) LIMIT 1
2017-09-20 12:28:21 4eba1f9c [app] [E] Fact processor57 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 464, 109563, '2017-09-20 19:28:21', '2017-09-20 19:28:21')
2017-09-20 12:28:24 4eba1f9c [app] [E] Fact processor58 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 466, 109563, '2017-09-20 19:28:21', '2017-09-20 19:28:21')
2017-09-20 12:28:25 6704e2b2 [app] [E] Fact processor13_frequency could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor13_frequency' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor13_frequency' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 466, 109563, '2017-09-20 19:28:21', '2017-09-20 19:28:21')
2017-09-20 12:29:14 3833ea57 [app] [E] Fact processor4_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 249, 109581, '2017-09-20 19:29:14', '2017-09-20 19:29:14')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ondemand', 249, 109581, '2017-09-20 19:29:14', '2017-09-20 19:29:14')
2017-09-20 12:29:46 d981d06e [app] [E] Fact facterversion could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 11 AND `fact_values`.`host_id` = 109584) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 11 AND `fact_values`.`host_id` = 109584) LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.209:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109265 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.224:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 186 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.214:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 27675 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.69.247:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 233 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.249:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 217 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.220:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 61 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.229:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 307 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.211:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 38 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.234:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 4404 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.207:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 50 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.229:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 411 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.242:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109286 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.69.210:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109346 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.69.232:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109293 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.218:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 482 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.246:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 151 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.254:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 193 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.240:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 281 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.245:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109344 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
2017-09-20 16:47:03 6b96a337 [app] [E] Fact disk10_model could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 1230 AND `fact_values`.`host_id` = 109719) LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 1230 AND `fact_values`.`host_id` = 109719) LIMIT 1
2017-09-20 12:22:56 01695fa5 [app] [E] Fact lib could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT 1 AS one FROM `fact_values` WHERE (`fact_values`.`fact_name_id` = BINARY 1 AND `fact_values`.`host_id` = 109420) LIMIT 1
2017-09-20 12:23:02 01695fa5 [app] [E] Fact processor36 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 123, 109420, '2017-09-20 19:22:59', '2017-09-20 19:22:59')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('Intel(R) Xeon(R) CPU E5-2683 v4 @ 2.10GHz', 123, 109420, '2017-09-20 19:22:59', '2017-09-20 19:22:59')
2017-09-20 12:25:40 aedb7529 [app] [E] Fact processor58_governor could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor58_governor' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
2017-09-20 12:25:44 aedb7529 [app] [E] Fact ipmi_subnet_mask could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('255.255.255.0', 436, 109468, '2017-09-20 19:25:40', '2017-09-20 19:25:40')
2017-09-20 12:25:45 d7e4b22d [app] [E] Fact link_eth1 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('false', 428, 109471, '2017-09-20 19:25:45', '2017-09-20 19:25:45')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('255.255.255.0', 436, 109468, '2017-09-20 19:25:40', '2017-09-20 19:25:40')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('false', 428, 109471, '2017-09-20 19:25:45', '2017-09-20 19:25:45')
2017-09-20 12:26:19 61f49b3a [app] [E] Fact ps could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ps -ef', 134, 109495, '2017-09-20 19:26:19', '2017-09-20 19:26:19')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('ps -ef', 134, 109495, '2017-09-20 19:26:19', '2017-09-20 19:26:19')
| RuntimeError: Could not get facts from proxy https://10.84.69.221:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 187 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.201:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 283 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.242:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT fact_names.name FROM `fact_values` INNER JOIN `fact_names` ON `fact_names`.`id` = `fact_values`.`fact_name_id` WHERE `fact_values`.`host_id` = 109286 AND (fact_names.type = 'PuppetFactName')
| RuntimeError: Could not get facts from proxy https://10.84.67.239:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 413 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.201:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109283 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.246:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 34 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.218:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109399 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.71.211:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109323 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.231:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 225 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.249:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109343 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.210:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 323 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.208:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 425 ORDER BY fact_names.name LIMIT 1
2017-09-20 14:17:43 6a12d0cf [app] [E] Fact nic1_pcislot could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'nic1_pcislot' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'nic1_pcislot' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
2017-09-20 14:26:25 185dd36c [app] [E] Fact hostname could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('minios', 15, 109657, '2017-09-20 21:26:25', '2017-09-20 21:26:25')
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: INSERT INTO `fact_values` (`value`, `fact_name_id`, `host_id`, `created_at`, `updated_at`) VALUES ('minios', 15, 109657, '2017-09-20 21:26:25', '2017-09-20 21:26:25')
2017-09-20 14:27:10 d27b86e0 [app] [E] Fact processor18 could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor18' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'processor18' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
2017-09-20 14:31:46 ede22e37 [app] [E] Fact virtual could not be imported because of Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'virtual' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`type` IN ('PuppetFactName') AND `fact_names`.`name` = 'virtual' AND `fact_names`.`type` = 'PuppetFactName' ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.218:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109603 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.231:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109340 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.218:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 235 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.254:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 409 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.212:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 393 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.71.229:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 442 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.215:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109335 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.65.225:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 279 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.230:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 161 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.65.238:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (SELECT id FROM (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` = 109681 AND `fact_names`.`type` = 'PuppetFactName' AND (`fact_names`.`name` NOT IN ('lib', 'architecture', 'augeasversion', 'discovery_version', 'discovery_release', 'minios_version', 'esams_connectivity', 'spc_ep', 'blockdevice_sda_size', 'blockdevice_sda_vendor', 'blockdevice_sda_model', 'blockdevices', 'domain', 'macaddress', 'lsbdistid', 'facterversion', 'fqdn', 'hardwareisa', 'hardwaremodel', 'hostname', 'id', 'interfaces', 'ipaddress_eth0', 'macaddress_eth0', 'netmask_eth0', 'mtu_eth0', 'ipaddress_eth1', 'macaddress_eth1', 'netmask_eth1', 'mtu_eth1', 'ipaddress_lo', 'netmask_lo', 'mtu_lo', 'ipaddress', 'lsbdistcodename', 'lsbdistdescription', 'lsbdistrelease', 'lsbmajdistrelease', 'boardmanufacturer', 'boardproductname', 'boardserialnumber', 'bios_vendor', 'bios_version', 'bios_release_date', 'manufacturer', 'productname', 'serialnumber', 'uuid', 'type', 'memorysize', 'memorysize_mb', 'memorytotal', 'netmask', 'network_eth0', 'network_eth1', 'network_lo', 'physicalprocessorcount', 'processor0', 'processor1', 'processor2', 'processor3', 'processor4', 'processor5', 'processor6', 'processor7', 'processor8', 'processor9', 'processor10', 'processor11', 'processor12', 'processor13', 'processor14', 'processor15', 'processor16', 'processor17', 'processor18', 'processor19', 'processor20', 'processor21', 'processor22', 'processor23', 'processorcount', 'ps', 'puppetversion', 'selinux', 'sshdsakey', 'sshfp_dsa', 'sshrsakey', 'sshfp_rsa', 'sshecdsakey', 'sshfp_ecdsa', 'uniqueid', 'virtual', 'is_virtual', 'asset_tag', 'asset_uuid', 'bmc_ipaddress', 'bmc_macaddress', 'bmc_netmask', 'bmc_ipsource', 'bmc_gateway', 'bmc_version', 'bmc_users', 'bmc_health', 'core_count', 'default_gateway', 'default_gateway_device', 'dhcp_server', 'disks_count', 'disk1_device', 'disk1_vendor', 'disk1_model', 'disk1_firmware', 'disk1_size', 'disk1_id', 'disk1_serial', 'disk1_health', 'nic_count', 'nic1_device', 'nic1_pcislot', 'nic1_version', 'nic1_link', 'nic1_speed', 'nic1_network', 'nic1_ipaddress', 'nic1_netmask', 'nic1_macaddress', 'nic1_bootif', 'nic1_switch', 'nic1_port', 'nic1_vlans', 'nic1_native_vlan', 'nic2_device', 'nic2_pcislot', 'nic2_version', 'nic2_link', 'nic2_speed', 'nic2_network', 'nic2_ipaddress', 'nic2_netmask', 'nic2_macaddress', 'nic2_switch', 'nic2_port', 'nic2_vlans', 'nic2_native_vlan', 'nvidia_3d_count', 'processor0_frequency', 'processor0_governor', 'processor1_frequency', 'processor1_governor', 'processor2_frequency', 'processor2_governor', 'processor3_frequency', 'processor3_governor', 'processor4_frequency', 'processor4_governor', 'processor5_frequency', 'processor5_governor', 'processor6_frequency', 'processor6_governor', 'processor7_frequency', 'processor7_governor', 'processor8_frequency', 'processor8_governor', 'processor9_frequency', 'processor9_governor', 'processor10_frequency', 'processor10_governor', 'processor11_frequency', 'processor11_governor', 'processor12_frequency', 'processor12_governor', 'processor13_frequency', 'processor13_governor', 'processor14_frequency', 'processor14_governor', 'processor15_frequency', 'processor15_governor', 'processor16_frequency', 'processor16_governor', 'processor17_frequency', 'processor17_governor', 'processor18_frequency', 'processor18_governor', 'processor19_frequency', 'processor19_governor', 'processor20_frequency', 'processor20_governor', 'processor21_frequency', 'processor21_governor', 'processor22_frequency', 'processor22_governor', 'processor23_frequency', 'processor23_governor', 'raidctrl_count', 'raidctrl1_device', 'raidctrl1_version', 'raidctrl1_pd_count', 'raidctrl1_cachesize', 'raidctrl1_ld_count', 'raidctrl1_ld1_raidlevel', 'raidctrl1_ld1_health', 'raidctrl1_health', 'discovery_bootif', 'discovery_bootip', 'speed_eth0', 'duplex_eth0', 'port_eth0', 'auto_negotiation_eth0', 'wol_eth0', 'link_eth0', 'speed_eth1', 'duplex_eth1', 'port_eth1', 'auto_negotiation_eth1', 'wol_eth1', 'link_eth1', 'link_lo', 'ipmi_enabled', 'ipmi_ipaddress_source', 'ipmi_ipaddress', 'ipmi_subnet_mask', 'ipmi_macaddress', 'ipmi_gateway', 'ipmi_1_ipaddress_source', 'ipmi_1_ipaddress', 'ipmi_1_subnet_mask', 'ipmi_1_macaddress', 'ipmi_1_gateway'))) __active_record_temp)
| RuntimeError: Could not get facts from proxy https://10.84.67.219:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: UPDATE `fact_values` SET `fact_values`.`value` = '1600', `fact_values`.`updated_at` = '2017-09-20 22:42:00' WHERE `fact_values`.`id` = 17852649
| RuntimeError: Could not get facts from proxy https://10.84.67.246:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 255 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.69.229:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 239 ORDER BY fact_names.name LIMIT 1
| RuntimeError: Could not get facts from proxy https://10.84.67.219:8443: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` = 313 ORDER BY fact_names.name LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment