perfSONAR User Q&A and Other Discussion

[Hyojoon Kim <>]

Hi, 

Our perfSONAR MaDDash grid suddenly went down, and I’m not sure why. It is down since April 6, 2018. The perfSONAR MA machine is up and running, but the archive data itself seems unreachable. MaDDash and MA are in the same host machine.

Grid is down

Category:CONFIGURATION

Potential Solutions:

• If you just configured this grid in the mesh, you may just need to wait as it takes several hours for throughput data to populate (depending on the interval between tests)
• Verify maddash is configured properly. Look in the files under /var/log/maddash/ for any errors. Things to look for are incorrect paths to checks or connection errors.
• Verify that perfSONAR MeshConfig GUIAgent has run recently and you are looking at an accurate test mesh
• Verify that your measurement archive(s) are running
• Verify no firewall is blocking maddash from reaching your measurement archive(s)
• Verify your hosts are downloading the mesh configuration file and that there are tests defined in /etc/perfsonar/meshconfig-agent-tasks.conf
• Verify that perfsonar-meshconfig-agent is running ('/etc/init.d/perfsonar-meshconfig-agent status' or 'systemctl status perfsonar-meshconfig-agent')
• Verify your hosts are able to reach their configured measurement archive and that there are no errors in /var/log/perfsonar/meshconfig-agent.log

I’ve followed the “Potential Solutions” here, and I think the logs in “/var/log/maddash/maddash-server.log” gives an important hint. Could someone give me an idea why this happened and how to fix this? 

FYI,

===

* If you just configured this grid in the mesh, you may just need to wait as it takes several hours for throughput data to populate (depending on the interval between tests)

  — This Mesh and MaDDash have been running for years

* Verify maddash is configured properly. Look in the files under /var/log/maddash/ for any errors. Things to look for are incorrect paths to checks or connection errors.

  — I see following errors in /var/log/maddash/maddash-server.log

ERROR 2018-04-08 20:44:36,408 Error cleaning database An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:44:36,410 Error executing EventCalendarJob: An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:45:36,411 Error cleaning database An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:45:36,413 Error executing EventCalendarJob: An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:46:36,413 Error cleaning database An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:46:36,415 Error executing EventCalendarJob: An SQL data change is not permitted for a read-only connection, user or database.

ERROR 2018-04-08 20:47:36,416 Error cleaning database An SQL data change is not permitted for a read-only connection, user or database.

* Verify that perfSONAR MeshConfig GUIAgent has run recently and you are looking at an accurate test mesh

  — Verified.

* Verify that your measurement archive(s) are running

  — The MA machine is up and running.

* Verify no firewall is blocking maddash from reaching your measurement archive(s)

  — There are in the same host. No configuration change was made.

* Verify your hosts are downloading the mesh configuration file and that there are tests defined in /etc/perfsonar/meshconfig-agent-tasks.conf

  — Verified 

* Verify that perfsonar-meshconfig-agent is running ('/etc/init.d/perfsonar-meshconfig-agent status' or 'systemctl status perfsonar-meshconfig-agent’)

  — Verified. 

* Verify your hosts are able to reach their configured measurement archive and that there are no errors in /var/log/perfsonar/meshconfig-agent.log

  — Verified

===

Thanks,

Joon