perfsonar-user - [perfsonar-user] pscheduler problems

Subject: perfSONAR User Q&A and Other Discussion

List archive

[perfsonar-user] pscheduler problems

From: Daniel Manzo <>
To: perfsonar-user <>
Subject: [perfsonar-user] pscheduler problems
Date: Mon, 19 Jun 2017 15:37:35 +0000
Accept-language: en-US
Ironport-phdr: 9a23:+NcHLRHeWkz8JDBR8y5vip1GYnF86YWxBRYc798ds5kLTJ7zpM6wAkXT6L1XgUPTWs2DsrQf2rWQ4/2rCDZIyK3CmUhKSIZLWR4BhJdetC0bK+nBN3fGKuX3ZTcxBsVIWQwt1Xi6NU9IBJS2PAWK8TW94jEIBxrwKxd+KPjrFY7OlcS30P2594HObwlSijewZbF/IA+1oAjRucUbhZVuIbstxxXUpXdFZ/5Yzn5yK1KJmBb86Maw/Jp9/ClVpvks6c1OX7jkcqohVbBXAygoPG4z5M3wqBnMVhCP6WcGUmUXiRVHHQ7I5wznU5jrsyv6su192DSGPcDzULs5Vyiu47ttRRT1jioMKjw3/3zNisFojKxVvg+vpwBxzYDXYYGaKPVxc7jHct8GWWZMRNpdWzBfDo66coABD/ABPeFdr4TlqVUBtx2+BQiyC+Pr1zRGgWX53as70uQmDArL2xEvEMgIsHTVstr1ML0eUeWvw6nOzDTDaOhb1izn54nIbB8hu+uAUq53ccrU0EQiER7OgFaIqYH9IT+Zy/oBv3Ka4udvT+6jlXArpgFrrjSx2MsglJHFip8Jxlze9ih0zpw5KNO7RUJhZdOpHoNcty+EOIZ1Xs8vRmRltzomxrIdt562eSYKxZs5yxHCbvGKcIeF7xLtVOuUPDt1hmxpd6+5ih2v60av0Pf8WdOx0FtSripKjN3MtncV2hzI78iHVuN9/kKu2DqT2Q3f8PpLLlo0lKXFMZ4t2KM/mYQLvUTCGC/5hln2gbeIekk55OSk8eXqb7r8qpOCKYN5ihvyProwlsChGeg4NxIBX2mf+eSyzr3j+kj5Ta1XgfIslKnZsY7VJcABqq68GQBV1Ici6xGkAji9ytsZnWcILEhfdB2biIjpPknCIOrkAvenn1SsjDBryujePrL/GJXNIGPDkLDnfbln8U5Q0RczzctB6JJOEbwBJPPzWlTttNzDEBM1KQ20w+D7CNpjzIMeX3yAArOHPK/Ir1CH+/8vcKGwY9oNtSzzMP8j7uSrkGQ0gxdJZaSz04AQbnmiW+l9Ll+xYHzwj80HHHtQ+AcyUbq5pkeFVGt/bnCzUqZ0wzg9GoXuWYvKQIGghPqE1SGpGbVcb3FLEBaHFnK+JNbMYOsFdC/HepwpqTcDT7X0E4I=

Hi all,

I am currently running perfSONAR v4.0 on RHEL 7.3. I was previously having problems with postgresql-9.5, but now those are resolved. However, now I am having different errors with the pscheduler services.

Here is what is reported when running “sudo systemctl status pscheduler-archiver –l”:

Jun 19 11:25:38 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Restarting

Jun 19 11:25:38 by0ok5.na.bayer.cnb archiver[31896]: archiver ERROR Failed to delete defaults: relation "archive_default" does not exist

LINE 1: DELETE FROM archive_default

Jun 19 11:25:38 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Program threw an exception after 0:00:00.004839

Jun 19 11:25:38 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Exception: ProgrammingError: function archiving_next(integer) does not exist

LINE 5: FROM archiving_next(15)

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/archiver", line 522, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/archiver", line 478, in main_program

[options.max_parallel])

File "/usr/lib/python2.7/site-packages/pscheduler/db.py", line 197, in query

cursor.execute(query, args)

ProgrammingError: function archiving_next(integer) does not exist

LINE 5: FROM archiving_next(15)

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:25:38 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Waiting 16.5 seconds before restarting

Jun 19 11:25:55 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Restarting

Jun 19 11:25:55 by0ok5.na.bayer.cnb archiver[31896]: archiver ERROR Failed to delete defaults: relation "archive_default" does not exist

LINE 1: DELETE FROM archive_default

Jun 19 11:25:55 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Program threw an exception after 0:00:00.005056

Jun 19 11:25:55 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Exception: ProgrammingError: function archiving_next(integer) does not exist

LINE 5: FROM archiving_next(15)

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/archiver", line 522, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/archiver", line 478, in main_program

[options.max_parallel])

File "/usr/lib/python2.7/site-packages/pscheduler/db.py", line 197, in query

cursor.execute(query, args)

ProgrammingError: function archiving_next(integer) does not exist

LINE 5: FROM archiving_next(15)

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:25:55 by0ok5.na.bayer.cnb archiver[31896]: safe_run/archiver ERROR Waiting 16.75 seconds before restarting

Here is what is reported when running “sudo systemctl status pscheduler-runner –l”:

Jun 19 11:30:32 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Exception: ProgrammingError: relation "run" does not exist

LINE 11: run

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/runner", line 907, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/runner", line 817, in main_program

""", [refresh]);

ProgrammingError: relation "run" does not exist

LINE 11: run

Jun 19 11:30:32 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Waiting 20.5 seconds before restarting

Jun 19 11:30:53 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Restarting

Jun 19 11:30:53 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Program threw an exception after 0:00:00.002882

Jun 19 11:30:53 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Exception: ProgrammingError: relation "run" does not exist

LINE 11: run

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/runner", line 907, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/runner", line 817, in main_program

""", [refresh]);

ProgrammingError: relation "run" does not exist

LINE 11: run

Jun 19 11:30:53 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Waiting 20.75 seconds before restarting

Jun 19 11:31:14 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Restarting

Jun 19 11:31:14 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Program threw an exception after 0:00:00.002955

Jun 19 11:31:14 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Exception: ProgrammingError: relation "run" does not exist

LINE 11: run

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/runner", line 907, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/runner", line 817, in main_program

""", [refresh]);

ProgrammingError: relation "run" does not exist

LINE 11: run

Jun 19 11:31:14 by0ok5.na.bayer.cnb runner[31871]: safe_run/runner ERROR Waiting 21.0 seconds before restarting

Here is what is reported when running “sudo systemctl status pscheduler-scheduler –l”:

Jun 19 11:31:35 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Exception: ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/scheduler", line 662, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/scheduler", line 548, in main_program

""")

ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Jun 19 11:31:35 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Waiting 21.25 seconds before restarting

Jun 19 11:31:56 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Restarting

Jun 19 11:31:56 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Program threw an exception after 0:00:00.003653

Jun 19 11:31:56 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Exception: ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/scheduler", line 662, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/scheduler", line 548, in main_program

""")

ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Jun 19 11:31:56 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Waiting 21.5 seconds before restarting

Jun 19 11:32:17 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Restarting

Jun 19 11:32:17 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Program threw an exception after 0:00:00.002758

Jun 19 11:32:17 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Exception: ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/scheduler", line 662, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/scheduler", line 548, in main_program

""")

ProgrammingError: relation "schedule_runs_to_schedule" does not exist

LINE 3: FROM schedule_runs_to_schedule LIMIT 1

Jun 19 11:32:17 by0ok5.na.bayer.cnb scheduler[31846]: safe_run/scheduler ERROR Waiting 21.75 seconds before restarting

Here is what is reported when running “sudo systemctl status pscheduler-ticker –l”:

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:02 by0ok5.na.bayer.cnb ticker[32350]: ticker WARNING Queue maintainer got exception function http_queue_process_all() does not exist

LINE 1: SELECT http_queue_process_all()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:05 by0ok5.na.bayer.cnb ticker[32350]: safe_run/ticker ERROR Restarting

Jun 19 11:33:05 by0ok5.na.bayer.cnb ticker[32350]: safe_run/ticker ERROR Program threw an exception after 0:00:00.003517

Jun 19 11:33:05 by0ok5.na.bayer.cnb ticker[32350]: safe_run/ticker ERROR Exception: ProgrammingError: function cold_boot() does not exist

LINE 1: SELECT cold_boot()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Traceback (most recent call last):

File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 41, in safe_run

function()

File "/usr/libexec/pscheduler/daemons/ticker", line 153, in <lambda>

pscheduler.safe_run(lambda: main_program())

File "/usr/libexec/pscheduler/daemons/ticker", line 127, in main_program

cursor.execute("SELECT cold_boot()")

ProgrammingError: function cold_boot() does not exist

LINE 1: SELECT cold_boot()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Jun 19 11:33:05 by0ok5.na.bayer.cnb ticker[32350]: safe_run/ticker ERROR Waiting 21.25 seconds before restarting

So far, I have tried removing the pscheduler and perfsonar packages and then re-installing via yum. I have also tried just removing pscheduler packages and re-installing via yum. Not sure, what to do about these errors, so any and all help is appreciated.

Thanks,

Dan Manzo

[perfsonar-user] pscheduler problems, Daniel Manzo, 06/19/2017
- Re: [perfsonar-user] pscheduler problems, Andrew Lake, 06/19/2017
  - RE: [perfsonar-user] pscheduler problems, Daniel Manzo, 06/19/2017

List archive

[perfsonar-user] pscheduler problems