csschwe

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

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

csschwe

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