Error while fetching object while opening API Proxies page
On opening the API Proxy page, I am seeing "Error while fetching object org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Conneciton; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP Connections.)
What should I do to resolve the issue?
Best Answer
Apigee uses the Postgres database for storing analytics data. On opening the API proxies page in the management UI, the Apigee management UI would load the API proxy performance data from the Postgres database for the Performance section following the API proxy list. The error indicates that the Apigee management server is not able to contact the Postgres server to retrieve the data.
If the connection is down between the management server and the postgres server, please fix the network issue between the two nodes. If there is no network connection problem, please do 'nc -z <IP of the Postgres server> 5432' from the management server to see if the port is open for access. If the port is not open for access, please go to the Postgres server and check if the postmaster process is running, e.g, ps -elf | grep postmaster and you should see something similar to /usr/pgsql-9.3/bin/postmaster -p 5432 -D /ebs/pgdata. If the postmaster process does not exist, you could try running the <apigee-bin>/all-stop.sh script then the <apigee-bin>all-start.sh script on the Postgres server and see if the postmaster process would start and the error in the management UI would disappear.
There are more links regarding Postgres server setup and could help further diagnose the problem, for example, http://www.postgresql.org/docs/9.0/static/server-start.html and http://stackoverflow.com/questions/20825734/postgresql-connection-refused-check-that-the-hostname-and-port-are-correct-an.
