perfsonar-user - Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table"
Subject: perfSONAR User Q&A and Other Discussion
List archive
- From: Kathy Benninger <>
- To: perfsonar-user <>
- Subject: Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table"
- Date: Tue, 26 Jun 2018 11:16:32 -0400
- Dkim-filter: OpenDKIM Filter v2.11.0 mailer2.psc.edu w5QFGbq0018820
- Ironport-phdr: 9a23:/A5AJBVEZlxiynf3Bb+sWxTvgNbV8LGtZVwlr6E/grcLSJyIuqrYbByPt8tkgFKBZ4jH8fUM07OQ7/i9HzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9yIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KptVRTmijoINyQh/W/Xl8J+kqxbrhGvqRNxzIHbYp2aOeFkca/BZ94XX3ZNU8hTWiFHH4iyb5EPD+0EPetAqofyvUcOrRu+BAKxGe7g1DlIhnn33a083OQuDxvG1xEnEt0VrnvUqtP1NKYUUeC60qbI1y7Ob+tN2Tjh8oTHbA0uoeyVUL92bMHfx04vFwbfgVWRr4zoJzyU1v8TvGeG8eVsT+Wvi3Qoqw1pozivwNsshZfThoIT1F/E6Tt1zJwrKtKlVU52Z8OvHphItyyCKod6XMAvT3t1tCs51LEKo5y2cDQQxJg62xLSauSLf5WW7h/gTuqdPDR1iGx/dL6ihhu+7VKsxvDhWsSw1ltBszBLncPWtn8X0hze8siHReV5/kemwTuP0hrc6uBAIU8qj6rXNYQtwqYrlpUPq0jMADL5mFjugK+XcEUr5PSo5vz6brn4pZKQLZJ4hwLgPqg0mMGzHf40PhUSU2Wa4ei80afs/Uz9QLVElP02lazZvYjBKssFoK65BQ5V0oAs6xmhFTery8wYnWIbI15fZh2IkpXpN0nUIP/kFfe/n0iskDBzyvDeILLhGJvNLmPEkLfnZ7l98VdQyBcozd9B/ZJZEbUBIPPoWk/tr9zUEAU1Mw2yw+b7Ftp9zIUeVnyTAqOHKq/dr0KH5v98a9SKf5If7TbhN+A+tbmpiX4ihURbfK+10IERZWziWPlqPgKCcH/0i5AaEGgMuQQwC/TnklOZVjhafTOvRK8mtQ08XZqrF4nYQYakmvmcxyqhVslOa3pIEVeKGG2tap6JQd8Nbj6fOMlsjmZCWLS8HdwPzxar4Szz17p2ZsDZ/CsZs53uzpAh7eDVkxA0+jFuJ9yG2CeAQ3wizTBAfCM/wK0q+R818VyEy6Ut2/E=
Hello! Follow-up to my prior inquiry: A second run of ps-migrate-restore.sh restored the archived data, which is now being displayed. Yay! Unfortunately, some of the pscheduler services seem to need a manual restart after reboot to run cleanly: systemctl -l status pscheduler-scheduler systemctl -l status pscheduler-archiver systemctl -l status pscheduler-ticker all show errors (copied below) after a reboot. pscheduler-runner starts and runs cleanly without intervention. Since pscheduler-scheduler doesn't start, scheduled testing doesn't start. After a manual: systemctl restart pscheduler-scheduler testing runs, old and new data are graphed, things look OK. Yay! systemctl -l status pscheduler-archiver systemctl -l status pscheduler-ticker also show errors until they are restarted. Thanks for any ideas on what to do. I haven't seen this problem on any of the four machines that I've previously upgraded so I'm a bit stumped. (I manage the machine remotely and, while I have a great contact there to help with hands-on, I'm trying to debug as much as I can before I need to pull him back into the fray.) Kathy [root@ps benninge]# systemctl -l status pscheduler-scheduler â pscheduler-scheduler.service - pScheduler server - scheduler Loaded: loaded (/usr/lib/systemd/system/pscheduler-scheduler.service; enabled; vendor preset: disabled) Active: active (running) since Mon 2018-06-25 17:06:52 EDT; 2min 9s ago Main PID: 2258 (scheduler) CGroup: /system.slice/pscheduler-scheduler.service ââ2258 /usr/bin/python /usr/libexec/pscheduler/daemons/scheduler --daemon --pid-file /var/run/pscheduler-scheduler.pid --dsn @/etc/pscheduler/database/database-dsn Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Starting pScheduler server - scheduler... Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Started pScheduler server - scheduler. Jun 25 17:06:52 ps.nics.xsede.org scheduler[2258]: scheduler INFO Started Jun 25 17:07:12 ps.nics.xsede.org scheduler[2258]: safe_run/scheduler ERROR Program threw an exception after 0:00:19.816066 Jun 25 17:07:12 ps.nics.xsede.org scheduler[2258]: safe_run/scheduler ERROR Exception: DatabaseError: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 72, in safe_run function() File "/usr/libexec/pscheduler/daemons/scheduler", line 809, in <lambda> pscheduler.safe_run(lambda: main_program()) File "/usr/libexec/pscheduler/daemons/scheduler", line 764, in main_program cursor.execute(query, args) DatabaseError: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Jun 25 17:07:12 ps.nics.xsede.org scheduler[2258]: safe_run/scheduler ERROR Waiting 0.25 seconds before restarting Jun 25 17:07:12 ps.nics.xsede.org scheduler[2258]: safe_run/scheduler ERROR Restarting: ['/usr/libexec/pscheduler/daemons/scheduler', '--daemon', '--pid-file', '/var/run/pscheduler-scheduler.pid', '--dsn', '@/etc/pscheduler/database/database-dsn'] Jun 25 17:07:12 ps.nics.xsede.org scheduler[2258]: scheduler INFO Started [root@ps benninge]# systemctl -l status pscheduler-archiver â pscheduler-archiver.service - pScheduler server - archiver Loaded: loaded (/usr/lib/systemd/system/pscheduler-archiver.service; enabled; vendor preset: disabled) Active: active (running) since Mon 2018-06-25 17:06:52 EDT; 2min 19s ago Main PID: 2250 (archiver) CGroup: /system.slice/pscheduler-archiver.service ââ2250 /usr/bin/python /usr/libexec/pscheduler/daemons/archiver --daemon --pid-file /var/run/pscheduler-archiver.pid --dsn @/etc/pscheduler/database/database-dsn ââ5649 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5731 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5796 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5803 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5810 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5816 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5826 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5846 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5854 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive ââ5864 /usr/bin/python /usr/libexec/pscheduler/commands/../classes/archiver/esmond/archive Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Starting pScheduler server - archiver... Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Started pScheduler server - archiver. Jun 25 17:06:52 ps.nics.xsede.org archiver[2250]: archiver INFO Started Jun 25 17:07:12 ps.nics.xsede.org archiver[2250]: safe_run/archiver ERROR Program threw an exception after 0:00:19.816605 Jun 25 17:07:12 ps.nics.xsede.org archiver[2250]: safe_run/archiver ERROR Exception: DatabaseError: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 72, in safe_run function() File "/usr/libexec/pscheduler/daemons/archiver", line 855, in <lambda> pscheduler.safe_run(lambda: main_program()) File "/usr/libexec/pscheduler/daemons/archiver", line 811, in main_program [options.max_parallel]) File "/usr/lib/python2.7/site-packages/pscheduler/db.py", line 188, in query cursor.execute(query, args) DatabaseError: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Jun 25 17:07:12 ps.nics.xsede.org archiver[2250]: safe_run/archiver ERROR Waiting 0.25 seconds before restarting Jun 25 17:07:12 ps.nics.xsede.org archiver[2250]: safe_run/archiver ERROR Restarting: ['/usr/libexec/pscheduler/daemons/archiver', '--daemon', '--pid-file', '/var/run/pscheduler-archiver.pid', '--dsn', '@/etc/pscheduler/database/database-dsn'] Jun 25 17:07:12 ps.nics.xsede.org archiver[2250]: archiver INFO Started [root@ps benninge]# systemctl -l status pscheduler-ticker â pscheduler-ticker.service - pScheduler server - ticker Loaded: loaded (/usr/lib/systemd/system/pscheduler-ticker.service; enabled; vendor preset: disabled) Active: active (running) since Mon 2018-06-25 17:06:52 EDT; 2min 24s ago Main PID: 2255 (ticker) CGroup: /system.slice/pscheduler-ticker.service ââ2255 /usr/bin/python /usr/libexec/pscheduler/daemons/ticker --daemon --pid-file /var/run/pscheduler-ticker.pid --dsn @/etc/pscheduler/database/database-dsn Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Starting pScheduler server - ticker... Jun 25 17:06:52 ps.nics.xsede.org systemd[1]: Started pScheduler server - ticker. Jun 25 17:07:12 ps.nics.xsede.org ticker[2255]: ticker WARNING Queue maintainer got exception server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Jun 25 17:07:16 ps.nics.xsede.org ticker[2255]: safe_run/ticker ERROR Program threw an exception after 0:00:23.667070 Jun 25 17:07:16 ps.nics.xsede.org ticker[2255]: safe_run/ticker ERROR Exception: OperationalError: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/pscheduler/saferun.py", line 72, in safe_run function() File "/usr/libexec/pscheduler/daemons/ticker", line 157, in <lambda> pscheduler.safe_run(lambda: main_program()) File "/usr/libexec/pscheduler/daemons/ticker", line 137, in main_program cursor.execute("SELECT ticker()") OperationalError: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Jun 25 17:07:16 ps.nics.xsede.org ticker[2255]: safe_run/ticker ERROR Waiting 0.25 seconds before restarting Jun 25 17:07:16 ps.nics.xsede.org ticker[2255]: safe_run/ticker ERROR Restarting: ['/usr/libexec/pscheduler/daemons/ticker', '--daemon', '--pid-file', '/var/run/pscheduler-ticker.pid', '--dsn', '@/etc/pscheduler/database/database-dsn'] On 6/20/2018 2:26 PM, Kathy Benninger
wrote:
Hi Andy, |
- [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Kathy Benninger, 06/19/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Andrew Lake, 06/20/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Kathy Benninger, 06/20/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Kathy Benninger, 06/26/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Mark Feit, 06/26/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Kathy Benninger, 06/26/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Kathy Benninger, 06/20/2018
- Re: [perfsonar-user] After CentOS6->7 upgrade - "No data available in table", Andrew Lake, 06/20/2018
Archive powered by MHonArc 2.6.19.