perfSONAR User Q&A and Other Discussion

[Andrew Lake <>]

Hi,

Sounds like maybe your old postgresql data didn’t move over for some reason. Since we saw this once today, any of you keeping your postgresql data someplace that’s not /var/lib/pgsql? If you do have the data someplace else, let me know and the steps below are a bit different.

If you have it in the standard location of /var/lib/pgsql, you can look in /var/log/yum.log which may or may not have a reason why. Usually when this happens the old version of postgresql didn't shutdown or start back up properly during the migration.You can run the migration again with the following commands that shutdown anything using postgres, remove the empty 9.5 database that got created, migrate the old data and rebuild the pscheduler databases:

/etc/init.d/httpd stop

/etc/init.d/httpd24-httpd stop

/etc/init.d/pscheduler-scheduler stop

/etc/init.d/pscheduler-runner stop

/etc/init.d/pscheduler-ticker stop

/etc/init.d/pscheduler-archiver stop

/etc/init.d/postgresql stop

/etc/init.d/postgresql-9.5 stop

pkill -9 -f postgres

rm -rf /var/lib/pgsql/9.5/data/*

/usr/lib/esmond-database/upgrade-pgsql95.sh

/etc/init.d/httpd24-httpd start

yum reinstall pscheduler-server

Let me know if that gives you any trouble. You’ll know things are good if you can open "http://your-host/esmond/perfsonar/archive/?limit=1” in your browser and see an old result. You should see the data immediately. 

Thanks,

Andy

On April 18, 2017 at 2:13:46 PM, Vollmer, David () () wrote:

Same trouble here.

> On Apr 18, 2017, at 10:46 AM, C. Aaron Smith <> wrote:
>
> Hello everyone,
>
> A test box was allowed to upgrade to 4.0 this morning and now "Details"
> of the test results are not showing.
> The base web page is shown without any errors. When selecting "Details"
> under a specific test, the new page shows these messages:
> "Error loading data
> Error retrieving data
> No data found in the measurement archive"
>
> Not sure where to start.
> Thanks,
> Aaron
>
>
> --
> C. Aaron Smith
> Senior Network Engineer
> ISC Tech Services
> University of Pennsylvania
> OpenPGP Key ID: 0xC311AB25