[ckan-dev] SOLR or PostgreSQL not coming up after update of CentOS

Wed Jul 22 13:19:25 UTC 2015

Hi experts,
after updating my CentOS after a couple of weeks my CKAN on this machine 
does not work any more :-(
The website is running but I don't get any connection to the database.

The httpd error log says:

[Wed Jul 22 14:36:57 2015] [error] 2015-07-22 14:36:57,431 INFO 
[ckan.lib.base]  /organization/e9efca69-3ff7-419b-839f-7485d4195daf 
render time 0.018 seconds
[Wed Jul 22 14:37:04 2015] [error] [client 10.0.0.29] Error - <class 
'ckan.lib.search.common.SearchError'>: SOLR returned an error running 
query: {'sort': 'score desc, metadata_modified desc', 'fq': [' 
capacity:"public" +site_id:"default" +state:active'], 'facet.mincount': 
1, 'rows': 2, 'facet': 'true', 'q': '*:*', 'facet.limit': '50', 'wt': 
'json', 'fl': 'id validated_data_dict'} Error: 'Not Found'
[Wed Jul 22 14:37:04 2015] [error] 2015-07-22 14:37:04,835 INFO 
[ckan.lib.base]  / render time 0.015 seconds
[Wed Jul 22 14:37:05 2015] [error] 2015-07-22 14:37:05,067 INFO 
[ckan.lib.base]  /api/i18n/de render time 0.003 seconds

When I try to access solr via web interface (on port 8080) I get a valid 
html page and the log in catalina.out says:

Jul 21, 2015 3:33:48 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jul 21, 2015 3:33:49 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jul 21, 2015 3:33:49 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/66  config=null
Jul 21, 2015 3:33:49 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 5717 ms

How can this happen?
What can I do to find out what is going wrong?

I'm running CKAN 2.2 on a CentOS 6.6 machine.

TIA Stephan