**Problem:*Foreman Ansible Job stuck in pending state and fails to excute the trigger job *
**Expected outcome:Job to execute and complet on remote host succesfully
**Foreman and Proxy versions:1.24
**Foreman and Proxy plugin versions:1.24 Katello: 3.14
Distribution and version:
Other relevant data:
/var/log/foreman/dynflow_executor.output:3960:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:146:in `async_exec': PG::ConnectionBad: PQsocket() can't get socket descriptor (Sequel::DatabaseDisconnectError) /var/log/foreman/dynflow_executor.output:3965: from /opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:110:in `check_disconnect_errors' /var/log/foreman/dynflow_executor.output:3972: from /opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:478:in `check_database_errors' /var/log/foreman/dynflow_executor.output:3979:E, [2019-12-12T11:40:51.145060 #23841] ERROR -- /parallel-executor-core/pool remote_execution/worker-9: PG::ConnectionBad: PQsocket() can't get socket descriptor: SET client_min_messages TO 'warning' (ActiveRecord::StatementInvalid) /var/log/foreman/dynflow_executor.output:4029:E, [2019-12-12T11:40:51.146217 #23841] ERROR -- /client-dispatcher: PG::UnableToSend: server closed the connection unexpectedly /var/log/foreman/dynflow_executor.output:4032: (Sequel::DatabaseDisconnectError) /var/log/foreman/dynflow_executor.output:4038:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:110:in `check_disconnect_errors' /var/log/foreman/dynflow_executor.output:4042:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:478:in `check_database_errors' /var/log/foreman/dynflow_executor.output:4105:E, [2019-12-12T11:40:51.146628 #23841] ERROR -- /client-dispatcher: Could not find an executor for Dynflow::Dispatcher::Envelope[request_id: 53d8d9da-7604-40d4-a892-0907bbe9d8dd-10, sender_id: 53d8d9da-7604-40d4-a892-0907bbe9d8dd, receiver_id: Dynflow::Dispatcher::UnknownWorld, message: Dynflow::Dispatcher::Event[execution_plan_id: dac1c2ee-c9b8-4011-bd06-e9aae4a944cd, step_id: 2, event: Dynflow::Action::WithPollingSubPlans::Poll, time: 2019-12-12 11:40:51 -0600]] (Dynflow::Error) /var/log/foreman/dynflow_executor.output:4145:E, [2019-12-12T11:40:53.108921 #23841] ERROR -- /parallel-executor-core: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4148: (Sequel::DatabaseConnectionError) /var/log/foreman/dynflow_executor.output:4191:E, [2019-12-12T11:41:00.199064 #23841] ERROR -- /connector-database-core: caused by Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4194: (Dynflow::Errors::FatalPersistenceError) /var/log/foreman/dynflow_executor.output:4234:E, [2019-12-12T11:41:00.207578 #23841] ERROR -- /connector-database-core: Receiving envelopes failed on PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4238:E, [2019-12-12T11:41:10.216823 #23841] ERROR -- /connector-database-core: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4241: (Sequel::DatabaseConnectionError) /var/log/foreman/dynflow_executor.output:4271:E, [2019-12-12T11:53:00.257830 #12332] ERROR -- /parallel-executor-core: no manager for Dynflow::Director::Event[request_id: f06940d9-e984-46ef-97b5-98b1992ec6f7-5, execution_plan_id: e3ad6f58-6bf3-4626-bed5-1c569cd4e9cd, step_id: 2, event: Dynflow::Action::WithPollingSubPlans::Poll, result: #<Concurrent::Promises::ResolvableFuture:0x0000000012146da8 pending>] (Dynflow::Error) /var/log/foreman/dynflow_executor.output:4316:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:146:in `async_exec': PG::ConnectionBad: PQsocket() can't get socket descriptor (Sequel::DatabaseDisconnectError) /var/log/foreman/dynflow_executor.output:4321: from /opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:110:in `check_disconnect_errors' /var/log/foreman/dynflow_executor.output:4328: from /opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:478:in `check_database_errors' /var/log/foreman/dynflow_executor.output:4335:E, [2019-12-12T12:53:38.735288 #31755] ERROR -- /parallel-executor-core/pool remote_execution/worker-9: PG::ConnectionBad: PQsocket() can't get socket descriptor: SET client_min_messages TO 'warning' (ActiveRecord::StatementInvalid) /var/log/foreman/dynflow_executor.output:4385:E, [2019-12-12T12:53:38.736658 #31755] ERROR -- /client-dispatcher: PG::UnableToSend: server closed the connection unexpectedly /var/log/foreman/dynflow_executor.output:4388:Screenshot from 2019-12-12 14-52-36 (Sequel::DatabaseDisconnectError) /var/log/foreman/dynflow_executor.output:4394:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:110:in `check_disconnect_errors' /var/log/foreman/dynflow_executor.output:4398:/opt/theforeman/tfm/root/usr/share/gems/gems/sequel-5.7.1/lib/sequel/adapters/postgres.rb:478:in `check_database_errors' /var/log/foreman/dynflow_executor.output:4461:E, [2019-12-12T12:53:38.737053 #31755] ERROR -- /client-dispatcher: Could not find an executor for Dynflow::Dispatcher::Envelope[request_id: 704cbd77-8b17-4f63-9183-d89b573354ec-86, sender_id: 704cbd77-8b17-4f63-9183-d89b573354ec, receiver_id: Dynflow::Dispatcher::UnknownWorld, message: Dynflow::Dispatcher::Event[execution_plan_id: 8765f669-0c1d-4cb9-abe6-406d00b2d879, step_id: 2, event: Dynflow::Action::WithPollingSubPlans::Poll, time: 2019-12-12 12:53:38 -0600]] (Dynflow::Error) /var/log/foreman/dynflow_executor.output:4501:E, [2019-12-12T12:53:42.656345 #31755] ERROR -- /parallel-executor-core: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4504: (Sequel::DatabaseConnectionError) /var/log/foreman/dynflow_executor.output:4547:E, [2019-12-12T12:53:48.052907 #31755] ERROR -- /connector-database-core: caused by Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4550: (Dynflow::Errors::FatalPersistenceError) /var/log/foreman/dynflow_executor.output:4590:E, [2019-12-12T12:53:48.065080 #31755] ERROR -- /connector-database-core: Receiving envelopes failed on PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4594:E, [2019-12-12T12:53:58.076393 #31755] ERROR -- /connector-database-core: PG::ConnectionBad: could not connect to server: No such file or directory /var/log/foreman/dynflow_executor.output:4597: (Sequel::DatabaseConnectionError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:13:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:39:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:41:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:95:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:121:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:123:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:418:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:444:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:446:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:570:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:596:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:598:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:744:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:770:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:772:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:877:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:903:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:905:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1064:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1090:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1092:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1217:SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1221:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1225:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1229:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1233:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1237:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1241:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept returned=1 errno=0 state=SSLv3 read client certificate A: sslv3 alert certificate unknown (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1245:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept SYSCALL returned=5 errno=0 state=SSLv3 read client certificate A (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1277:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1303:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1305:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1395:no implicit conversion of Dynflow::Utils::IndifferentHash into String (TypeError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1421:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `block in with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1423:/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.4.1/lib/dynflow/action.rb:475:in `with_error_handling' /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1500:SSL_accept SYSCALL returned=5 errno=0 state=SSLv2/v3 read client hello A (OpenSSL::SSL::SSLError) /var/log/foreman-proxy/smart_proxy_dynflow_core.log:1504:/opt/rh/rh-ruby25/root/usr/share/ruby/webrick/server.rb:297:in `block in start_thread'SSL_accept SYSCALL returned=5 errno=0 state=SSLv2/v3 read client hello A (OpenSSL::SSL::SSLError)