Koji: ServerOffline

[Oliver Falk]

Hi Jitesh!

Jitesh Shah wrote:
> Hi,
> I've been running a local koji instance at my workplace. It worked
> absolutely fine for a fortnight. But, since Monday, I am getting this
> error : "ServerOffline: database outage" for any CLI command that I try
> to execute.
> 
> I initially suspected that it might be because koji cannot connect to
> the database. But, I checked that I can login to the database through
> command-line.
>  >> psql
> 
> Also, I wrote a small script in python which mimics koji's method of
> connecting to the database (with reference
> to /usr/lib/python2.5/site-packages/koji/db.py) and it works fine!
> 
> Just to make sure, I restarted postgresql service in vain.
> Re-initialised the database (Remove /var/lib/pgsql and run "service
> postgresql initdb" and all the other steps) to no avail.
> 
> I started seeing this problem after a run of the koji-shadow script. It
> exited abnormally giving this very error. Since then, I cannot even
> access koji-cli.. neither koji-web.
> 
> I have been tracing through the koji scripts and I see that the SSL
> login succeeds and then the very first rpc call: "getAPIVersion" fails.
> Wireshark shows that the koji-hub replies with "Connection: close" to
> the getAPIVersion call.
> 
> Any idea as to what is going wrong?
> Any pointers?

You have not written if you have tried to restart Apache. koji(hub) has 
no auto-reconnect if it looses connection to the database. So if for 
whatever reason it lost the connection to PostgreSQL, it will never 
reconnect. You have to manually restart Apache!

-of