Postgresql error while stating PBS

[bharti]

After new installation of PBS , I am getting below error while starting pbs service.

Starting PBS
PBS Home directory /var/spool/pbs needs updating.
Running /opt/pbs/libexec/pbs_habitat to update it.

---

*** Error initializing the PBS dataservice
Error details:
Creating the PBS Data Service…
Starting PBS Data Service…
waiting for server to start…2018-08-06 14:56:05 ISTFATAL: could not create lock file “/var/run/postgresql/.s.PGSQL.15007.lock”: No such file or directory
stopped waiting
pg_ctl: could not start server
Examine the log output.
Failed to start PBS Data Service
Error starting PBS Data Service

[adarsh]

Please check

Problem starting PBS server

PBSPro uses pgsql to store the server configuration, and comes with a pgsql embedded (see rpm -ql pbspro-server). You will need to create a new system-level user, typically called ‘pbsdata’, and ensure that /var/spool/pbs/datastore is owned by that user. The RPM does not automatically create that user, which is not obvious, in my opinion. I would do this on a new PBSPro install: groupadd pbsdata useradd -g pbsdata -r pbsdata mkdir -p /var/spool/pbs/datastore chown pbsdata:pbsdata /var/spool/pbs…

Problem starting PBS server

Just to clarify… the commercial version of PBS Pro comes packaged with PostgreSQL, where the open source version lists PostgreSQL as a prerequisite. When PostgreSQL is installed independently of PBS Pro it creates a user named postgres, and the open source release uses that user ID for the PBS Pro database. I’ve seen cases where the ownership of the PBS Pro database directory has been inadvertently changed. This can be fixed with the following command: chown -R postgres:postgres /var/spool/pbs/…

Issue starting PBS

It appears the “postgres pbs_datastore” process is missing. The most common reason I’m aware of is permission problems within the PBS_HOME/datastore directory itself. There may be files or directories with incorrect ownership and/or permissions. Before you try anything I suggest, please backup your PBS_HOME directory. Shut down PBS Pro and then archive PBS_HOME so you can restore it later if necessary. A couple things to try… With PBS stopped, run the following command as root: chown -R postgr…

[bharti]

I have gone through these suggstions but none worked. Still i am not able to start pbs service.

[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
drwxr-xr-x 2 root root 4096 Aug 9 14:44 /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# chown -R postgres:postgres /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
drwxr-xr-x 2 postgres postgres 4096 Aug 9 14:44 /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# ps uax|grep pbs
root 22310 0.0 0.0 112704 972 pts/0 S+ 14:45 0:00 grep --color=auto pbs
[root@engit-05 ~]#
[root@engit-05 ~]# /opt/pbs/sbin/pbs_server
Connecting to PBS dataservice…Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
continuing in background.
[root@engit-05 ~]#
[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
drwxr-xr-x 2 postgres postgres 4096 Aug 9 14:44 /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# chown -R pbsdata:pbsdata /var/spool/pbs/datastore
[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
drwxr-xr-x 2 pbsdata pbsdata 4096 Aug 9 14:44 /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# ps uax|grep pbs
root 22523 0.0 0.0 89836 1820 ? Ss 14:46 0:00 /opt/pbs/sbin/pbs_server.bin
root 22765 0.0 0.0 112704 976 pts/0 S+ 14:47 0:00 grep --color=auto pbs
[root@engit-05 ~]#
[root@engit-05 ~]# kill -9 22523
[root@engit-ssd-05 ~]# /opt/pbs/sbin/pbs_server
Connecting to PBS dataservice…Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
.Failed to start PBS dataservice:[PBS Data Service not initialized]
continuing in background.
[root@engit-05 ~]# ps uax|grep pbs
root 23020 0.0 0.0 89836 1824 ? Ss 14:47 0:00 /opt/pbs/sbin/pbs_server.bin
root 23142 0.0 0.0 112704 976 pts/0 R+ 14:48 0:00 grep --color=auto pbs
[root@engit-05 ~]#

I notice that when I restarted pbs with below method , it removed “/var/spool/pbs/datastore”. do not know why it happens.

[root@engit-05 ~]#
[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
drwxr-xr-x 2 pbsdata pbsdata 4096 Aug 9 14:44 /var/spool/pbs/datastore
[root@engit-05 ~]#
[root@engit-05 ~]# /etc/init.d/pbs start
Starting PBS
PBS Home directory /var/spool/pbs needs updating.
Running /opt/pbs/libexec/pbs_habitat to update it.

---

*** Error initializing the PBS dataservice
Error details:
Creating the PBS Data Service…
Starting PBS Data Service…
pg_ctl: could not start server
Examine the log output.
Failed to start PBS Data Service
Error starting PBS Data Service
[root@engit-05 ~]#
[root@engit-05 ~]# ls -ld /var/spool/pbs/datastore
ls: cannot access /var/spool/pbs/datastore: No such file or directory
[root@engit-05 ~]#
[root@engit-05 ~]#

[adarsh]

Could you please share the Operating System flavour and version.
Did you compile is from the source or used the rpms ?
Would it be possible to re-install from scratch ?

Thank you

[vstumpf]

pg_ctl is failing somewhere, and it says to check postgres logs. What do they say?

[Source]

your postgresql-server installation uses unix socket location which is not exist on your distribution.
it’s hard to reveal this error but easy to fix.

find the line
unix_socket_directories=’/var/run/postgresql’ (it’s default location of distribution Debian/Ubuntu)
to
unix_socket_directories=’/tmp’ (it’s default for CentOS/RHEL) in your postgresql.conf would fix this.

[amozejko]

I had an issue with similar symptoms, not sure if the underlying issue is the same or not but putting here for anyone else who it might benefit.

as root:
cd /opt/pbs/libexec
./install_db
./pbs_init.d start

[agrawalravi90]

I wasted a lot of time suffering with this issue today, tried all suggestions on this and other related pages, nothing worked. What did work in the end was disabling SElinux, posting in case it helps others.

[cherryppju]

Yes. Selinux must be disabled before starting pbs. You can write one checking script about env before installing PBSPro.