- Used Zammad version: 2.9.0
- Operating system: CentOS 7
Hello everyone, our Zammad has stopped working out of the blue. If you go to the website comes the error 502 Bad Gateway.
275/5000
On the console, the command returned:
[root @ svsraa0011 backup] # zammad run rails c
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in `initialize ': could not connect to server: No such file or directory (PG: : ConnectionBad)
I urge you for help, the system is productive.
/var/log/messages is writing in a loop
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: => Booting Puma
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: => Rails 5.1.6.1 application starting in production
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: => Run rails server -h for more startup options
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: Exiting
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: bundler: failed to load command: script/rails (script/rails)
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: PG::ConnectionBad: could not connect to server: No such file or directory
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: Is the server running locally and accepting
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in initialize' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/pg-0.21.0/lib/pg.rb:56:innew’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/pg-0.21.0/lib/pg.rb:56:in connect' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/postgresql_adapter.rb:697:inconnect’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/postgresql_adapter.rb:221:in initialize' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/postgresql_adapter.rb:38:innew’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/postgresql_adapter.rb:38:in postgresql_connection' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:759:innew_connection’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:803:in checkout_new_connection' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:782:intry_to_checkout_new_connection’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:743:in acquire_connection' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:500:incheckout’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:374:in connection' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:931:inretrieve_connection’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_handling.rb:116:in retrieve_connection' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.1/lib/active_record/connection_handling.rb:88:inconnection’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/config/initializers/db_preferences_postgresql.rb:14:in <top (required)>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:286:inload’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:286:in block in load' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:258:inload_dependency’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:286:in load' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/engine.rb:655:inblock in load_config_initializer’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/notifications.rb:168:in instrument' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/engine.rb:654:inload_config_initializer’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/engine.rb:612:in block (2 levels) in <class:Engine>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/engine.rb:611:ineach’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/engine.rb:611:in block in <class:Engine>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:30:ininstance_exec’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:30:in run' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:59:inblock in run_initializers’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:228:in block in tsort_each' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:350:inblock (2 levels) in each_strongly_connected_component’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:422:in block (2 levels) in each_strongly_connected_component_from' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:431:ineach_strongly_connected_component_from’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:421:in block in each_strongly_connected_component_from' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:48:ineach’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:48:in tsort_each_child' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:415:incall’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:415:in each_strongly_connected_component_from' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:349:inblock in each_strongly_connected_component’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:347:in each' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:347:incall’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:347:in each_strongly_connected_component' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:226:intsort_each’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/tsort.rb:205:in tsort_each' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/initializable.rb:58:inrun_initializers’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/application.rb:353:in initialize!' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/config/environment.rb:5:in<top (required)>’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:292:in require' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:292:inblock in require’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:258:in load_dependency' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.1/lib/active_support/dependencies.rb:292:inrequire’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: config.ru:3:in block in <main>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/builder.rb:55:ininstance_eval’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/builder.rb:55:in initialize' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: config.ru:innew’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: config.ru:in <main>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/builder.rb:49:ineval’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/builder.rb:49:in new_from_string' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/builder.rb:40:inparse_file’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/server.rb:319:in build_app_and_options_from_config' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/server.rb:219:inapp’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands/server/server_command.rb:24:in app' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/server.rb:354:inwrapped_app’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/server.rb:283:in start' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands/server/server_command.rb:44:instart’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands/server/server_command.rb:135:in block in perform' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands/server/server_command.rb:130:intap’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands/server/server_command.rb:130:in perform' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/thor-0.20.3/lib/thor/command.rb:27:inrun’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/thor-0.20.3/lib/thor.rb:387:indispatch’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/command/base.rb:63:in perform' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/command.rb:44:ininvoke’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.1/lib/rails/commands.rb:16:in <top (required)>' Mar 11 17:41:54 svsraa0011 zammad-web-1.service: script/rails:6:inrequire’
Mar 11 17:41:54 svsraa0011 zammad-web-1.service: script/rails:6:in `<top (required)>’
Mar 11 17:41:54 svsraa0011 systemd: zammad-web-1.service: main process exited, code=exited, status=1/FAILURE
Mar 11 17:41:54 svsraa0011 systemd: Unit zammad-web-1.service entered failed state.
Mar 11 17:41:54 svsraa0011 systemd: zammad-web-1.service failed.
Mar 11 17:41:54 svsraa0011 systemd: zammad-web-1.service holdoff time over, scheduling restart.
Mar 11 17:41:54 svsraa0011 systemd: Stopped zammad-web-1.service.
Mar 11 17:41:54 svsraa0011 systemd: Started zammad-web-1.service.