perfSONAR User Q&A and Other Discussion

[Daniel Manzo <>]

Hi all,

 

After upgrading my server from RHEL 6.8 to 7.3, I needed to re-install perfSONAR (going from 3.5 to 4.0) on my machine. After installation, postgresql-9.5 will not start and all pscheduler tasks are reported as “active (running)” but throw errors. The errors from each are shown below:

 

Pscheduler

 

Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Restarting

Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Program threw an exception after 0:00:00.000908

Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Exception: IOError: [Errno 13] Permission denied: '/etc/pscheduler/database/database-dsn'#012Traceback (most recent call last):#012  File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run#012    function()#012  File "/usr/libexec/pscheduler/daemons/ticker", line 153, in <lambda>#012    pscheduler.safe_run(lambda: main_program())#012  File "/usr/libexec/pscheduler/daemons/ticker", line 123, in main_program#012    db = pscheduler.pg_connection(dsn)#012  File "/usr/lib/python2.7/site-packages/pscheduler/db.py", line 28, in pg_connection#012    dsn = string_from_file(dsn)#012  File "/usr/lib/python2.7/site-packages/pscheduler/filestring.py", line 23, in string_from_file#012    with open(path, 'r') as content:#012IOError: [Errno 13] Permission denied: '/etc/pscheduler/database/database-dsn'

Jun  7 13:35:06 by0ok5 journal: safe_run/ticker ERROR    Waiting 60.0 seconds before restarting

 

Postgresql-9.5

 

â postgresql-9.5.service - PostgreSQL 9.5 database server

   Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled; vendor preset: disabled)

   Active: failed (Result: exit-code) since Mon 2017-06-05 11:10:05 EDT; 2 days ago

  Process: 31031 ExecStartPre=/usr/pgsql-9.5/bin/postgresql95-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

 

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Starting PostgreSQL 9.5 database server...

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: postgresql-9.5.service: control process exited, code=exited status=1

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Failed to start PostgreSQL 9.5 database server.

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: Unit postgresql-9.5.service entered failed state.

Jun 05 11:10:05 by0ok5.na.bayer.cnb systemd[1]: postgresql-9.5.service failed.

 

I think that the two problems are related, but I’m not sure what needs to be done in order to fix the errors. To fix the ‘Permission denied’ error, I have tried changing the owner and group of /etc/pscheduler/database/ to ‘pscheduler’ instead of ‘root’ and changed file permissions. This did not work, and I am running out of ideas. Any and all help is greatly appreciated.

 

Thank you,

Dan Manzo