Chuck Schweizer csschwe
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| foreman=# select * from hosts where name='servername.localdomain.com'; | |
| id | name | last_compile | last_report | updated_at | created_at | root_pass | architecture_id | operatingsystem_id | envir | |
| onment_id | ptable_id | medium_id | build | comment | disk | installed_at | model_id | hostgroup_id | owner_id | owner_type | enabled | puppet_ca_proxy_id | managed | use_image | image_file | uu | |
| id | compute_resource_id | puppet_proxy_id | certname | image_id | organization_id | location_id | type | otp | realm_id | compute_profile_id | provision_method | grub | |
| _pass | global_status | lookup_value_matcher | |
| -----+----------------------------+---------------------+---------------------+----------------------------+----------------------------+-----------+-----------------+--------------------+------ | |
| ----------+-----------+-----------+-------+---------+------+--------------+----------+--------------+----------+---- |
csschwe
/ gist:4cc4d9be58e1cb96ec6c
Created
April 14, 2015 13:12
foreman errors with counter_cache_fix.rb
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ERROR: deadlock detected | |
| DETAIL: Process 12111 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12208. | |
| Process 12208 waits for ShareLock on transaction 4279180907; blocked by process 12095. | |
| Process 12095 waits for ExclusiveLock on tuple (0,78) of relation 16591 of database 16384; blocked by process 12111. | |
| Process 12111: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3 | |
| Process 12208: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3 | |
| Process 12095: UPDATE "architectures" SET "hosts_count" = 12506 WHERE "architectures"."id" = 3 | |
| HINT: See server log for query details. | |
| STATEMENT: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 3 | |
| ERROR: deadlock detected |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Nov 12 17:45:47 fqdn.com systemd[1]: Starting puppetserver Service... | |
| Nov 12 17:45:47 fqdn.com systemd[1]: Started puppetserver Service. | |
| Nov 12 17:46:12 fqdn.com java[56495]: Failed to load feature test for posix: can't find user for 0 | |
| Nov 12 17:46:12 fqdn.com java[56495]: Cannot run on Microsoft Windows without the win32-process, win32-dir and win32-service gems: Win32API only supported on win32 | |
| Nov 12 17:46:12 fqdn.com java[56495]: Puppet::Error: Cannot determine basic system flavour | |
| Nov 12 17:46:12 fqdn.com java[56495]: (root) at /usr/share/ruby/vendor_ruby/puppet/feature/base.rb:32 | |
| Nov 12 17:46:12 fqdn.com java[56495]: require at org/jruby/RubyKernel.java:1065 | |
| Nov 12 17:46:12 fqdn.com java[56495]: (root) at /usr/share/puppetserver/puppet-server-release.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:1 | |
| Nov 12 17:46:12 fqdn.com java[56495]: require at /usr/share/puppetserver/puppet-server-release.jar!/META-INF/jruby.home/lib/ruby/shared/rubygems/core_ext/kernel_require.rb:55 | |
| Nov |