Solved: OnPrem Apigee 4.16.01 - apigee-postgresql is dead - Page 2

ask4saif · 07-27-2016 11:00 PM

Hi experts,

Any idea about the following issue. Please also tell where I can find the log files for the apigee components.

[saifulislamkhan@apigee-edge ~]$ /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql start
apigee-configutil: apigee-postgresql: # OK
apigee-service: apigee-postgresql: Not running (NO_LOCKFILE)
apigee-service: apigee-postgresql: status=2, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: status=3, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: apigee-postgresql is dead
[saifulislamkhan@apigee-edge ~]$ /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql update
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: centos.webwerks.com
* extras: centos.webwerks.com
* updates: mirrors.nhanhoa.com
No packages marked for update
[saifulislamkhan@apigee-edge ~]$ /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql setup
Validating setup variables
Checking for required variables
Checking required variable HOSTIP...OK
Checking required variable RUN_USER...OK
Checking required variable RUN_GROUP...OK

Checking for optional variables
apigee-service: apigee-postgresql: Not running (DEAD)
Missing PG_MASTER, assuming stand-alone.
Data directory is not empty!
Skipping database initialization
Creating symlinks for config files
Restarting apigee-postgresql
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-configutil: apigee-postgresql: # OK
apigee-service: apigee-postgresql: Not running (NO_LOCKFILE)
apigee-service: apigee-postgresql: status=2, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: status=3, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: apigee-postgresql is dead
Waiting for postgres to finish start
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/opt/apigee/var/run/apigee-postgresql/.s.PGSQL.5432"?
Retrying in 5 sec (1)
^Z
[3]+ Stopped /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql setup
[saifulislamkhan@apigee-edge ~]$ /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql start
apigee-configutil: apigee-postgresql: # OK
apigee-service: apigee-postgresql: Not running (NO_LOCKFILE)
apigee-service: apigee-postgresql: status=2, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: status=3, continuing
apigee-service: apigee-postgresql: Not running (DEAD)
apigee-service: apigee-postgresql: apigee-postgresql is dead

Report Inappropriate Content

Hi there!

Can you check the logs for apigee-postgresql? You can find the logs under /opt/apigee/var/log/apigee-postgresql. Check pgstartup.log and postgresql-*.log. It should give you the enough info about the issue. Hope this helps.

Thanks,

Archendra

View solution in original post

ask4saif

Hi experts,

After all the hard work I found the solution. As I am new to Apigee OPDK, I didn't new where the logs were. Finally I found it and saw it was a permission issue for the postgresql data directory. I changed the directory read, write & execute permissions and that worked out for me. Following are the steps I performed to get rid of the issue:

//Log file for Apigee-postgresql folder is located at /opt/apigee/var/log/apigee-postgresql/apigee-postgresql.log
Found the data directory at location "/opt/apigee/data/apigee-postgresql/pgdata"
changed the permission in two steps:
1. sudo chown -R apigee:apigee /opt/apigee (This was just making sure for the owning rights)
2. sudo chmod -R 700 /opt/apigee/data/apigee-postgresql/pgdata (changing permission)
/opt/apigee/apigee-service/bin/apigee-service apigee-postgresql setup (will also start the component)

Note: This issue normally will not happen. It was due to my system shutdown abnormally and after facing the issue I uninstalled and then reinstalled the apigee-postgresql without checking the logs. Lesson learnt always check the log files, they mostly say everything.

View solution in original post