perfSONAR User Q&A and Other Discussion

["Bidwell, Matt" <>]

Mark, thanks for the reply. Should 'pscheduler internal db-update' be trying 
to run as the postgres user? I've the pscheduler db user defined in 
/etc/pscheduler/database/. -Matt

-----Original Message-----
From: Mark Feit <> 
Sent: Monday, August 17, 2020 12:38 PM
To: Bidwell, Matt <>; 
Subject: Re: [perfsonar-user] Upgrade may be missing a package

"Bidwell, Matt" writes:

    I'm running on RHEL 7 and I did an upgrade, but it appears I'm missing a 
function, which I assume is probably provided in an RPM, but looking at the 
available package list from the repo I didn't see anything that was obvious, 
though I thought I'd inquire here. The currently installed versions of 
Perfsonar are 4.2.4 versions. 

    scheduler[1954]: scheduler INFO     Started
    scheduler[1954]: safe_run/scheduler ERROR    Program threw an exception 
after 0:00:00.003814
    scheduler[1954]: safe_run/scheduler ERROR    Exception: ProgrammingError: 
function heartbeat_boot(unknown) does not exist
    scheduler[1954]: safe_run/scheduler ERROR    LINE 1: SELECT 
heartbeat_boot('scheduler')
    scheduler[1954]: safe_run/scheduler ERROR                   ^

That looks like the upgrade of the database code done by pscheduler-server 
failed midstream.  RPM doesn't fail if post-install or post-upgrade scripts 
fail, and there's nothing we can do about it.  (Links to gory details here:  
https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fperfsonar%2Fpscheduler%2Fissues%2F110&amp;data=02%7C01%7CMatt.Bidwell%40nrel.gov%7C36898f0d42904056203a08d842dcb83c%7Ca0f29d7e28cd4f5484427885aee7c080%7C0%7C0%7C637332863355547952&amp;sdata=0TTOnuyDjcqoENLWpxfIhUk5kMv9NBWh1QfVXdcNmqk%3D&amp;reserved=0.)
  There's probably something specific to that system going on.

As root, run "pscheduler internal db-update" and see if that fixes it or 
report any errors it throws and we'll look into it further.  This is the same 
action taken by the upgrade process will leave any data you have in the 
system intact.

--Mark