Skip to Content.
Sympa Menu

perfsonar-user - Re: [perfsonar-user] pscheduler problems

Subject: perfSONAR User Q&A and Other Discussion

List archive

Re: [perfsonar-user] pscheduler problems


Chronological Thread 
  • From: Andrew Lake <>
  • To: perfsonar-user <>, Daniel Manzo <>
  • Subject: Re: [perfsonar-user] pscheduler problems
  • Date: Mon, 19 Jun 2017 09:51:55 -0700
  • Ironport-phdr: 9a23:Z/bd4B/T1vQPhP9uRHKM819IXTAuvvDOBiVQ1KB42+8cTK2v8tzYMVDF4r011RmSDNqdu68P0rKJ+4nbGkU4qa6bt34DdJEeHzQksu4x2zIaPcieFEfgJ+TrZSFpVO5LVVti4m3peRMNQJW2aFLduGC94iAPERvjKwV1Ov71GonPhMiryuy+4ZPebgFKiTanYr5/LBq6oRjNusQUnIBvNrs/xhzVr3VSZu9Y33loJVWdnxb94se/4ptu+DlOtvwi6sBNT7z0c7w3QrJEAjsmNXs15NDwuhnYUQSP/HocXX4InRdOHgPI8Qv1Xpb1siv9q+p9xCyXNtD4QLwoRTiv6bpgRQT2gykbKTE27GDXitRxjK1FphKhuwd/yJPQbI2MKfZyYr/RcdYcSGFcXMheSjZBD5u8YYQNAeoPOulXoYf+qVUTsxWxGRKhC/nzxjJSnHL7x7E23uYnHArb3AIgBdUOsHHModjpMqcdTPq1w7fGzD7eaf1ZwzT955bVeR0mu/6MW69/cMrKxEYxDAPJlFOQppL5Pz6M0OkGrmuV7/J4WO6ylWIqqBt9rza1ysojl4XFnIAYxk3c+Sh7z4s5P8C0RFB7bNK+E5ZduTuWOoloTs4kXmpmojw1yqcctp6+ZCUKyIooxxrYa/GffYiH/B3uWPyVIThjgHJpYr2/hxGs8US4y+38UNe70EpSoyZYjNXBtWoB2hLJ5sWIV/dx5EWs1SuX2wDW8O5EIEQ0laTBK54mx749joAcsULeES72g0j5krSWel8i+ue29+Treq/mqYOEN49olgH+NbwjmtShDuQiPAgORG+b+eKm27355EH5Xa5KgeMskqTCtJDaJN8bprKiAwNLyIoj6hC/Dyu439QCm3kIMk5FdAydg4f3Jl7OPaOwMfDqm1m2nixswfnce6D6D4+FemDOirn6erB08QtB0wcp5dFZ+59ODLwderT+VlKn8JT0Bxk4Pgj85u/hGtI1go8XX2OCBumcOaXAtneC7/MiOa+HY4pD6xjnLP1wzvjil3Im0XsUfqThiZIRZGGQE+8gJUiFNym/yuwdGHsH61JtBNfhj0ePBHsKPy6/
Hi,

Looks like your pscheduler database is not setup properly. You can try running the command "pscheduler internal db-update” to see if that fixes things or possibly gives any useful errors. . The tables usually get setup when the pscheduler-server package is installed so “yum reinstall pscheduler-server” is another way to trigger the same process, but sounds like you tried that already. 

Andy


On June 19, 2017 at 11:38:55 AM, Daniel Manzo () wrote:

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


Archive powered by MHonArc 2.6.19.

Top of Page