Sidekiq postgres connection leakage & locking

unsupported-install

(Junaid Mailk) #1

Hello Guys,

We are facing issue related to Postgres connection leaks. Sidekiq don’t release connections and keep lock on table. In case of Rails we are calling following code in config/application.rb for reaping Postgres connections. For sidekiq we are not running such code.

if defined?(PhusionPassenger)
  PhusionPassenger.on_event(:starting_worker_process) do |forked|
    if forked
      Discourse.after_fork
    end
  end
end    

Regards,
Junaid


(Jeff Atwood) #2

Are you running on our official docker based install?


(Alan Tan) #3

Probably not if they are using PhusionPassenger as the web sever.


(Junaid Mailk) #4

We are not using docker based install due to some limit on our servers as we have already have multiple hosted apps.


(Junaid Mailk) #6

Sidekiq is separate process and it would not have any issue.


(Sam Saffron) #7

I am afraid the team can not help you here, we only support the official docker install