| Hi George,
Looks like maybe you have some data that maybe only got partially inserted. Try the following:
1. Look in /opt/esmond/esmond.conf at the sql_db_password setting for your database's password 2. Run the command and give it the password from step 1 when prompted: psql -U esmond -c "DELETE FROM ps_metadata WHERE id NOT IN (SELECT DISTINCT metadata_id FROM ps_p2p_subject)"
That will hopefully delete the problematic entries.
Thanks, Andy
On Mar 10, 2015, at 12:18 PM, "Uhl, George D. (GSFC-423.0)[SGT INC]" <> wrote:
--------
WARNING: At least one of the links in the message below goes to an IP address (e.g.10.1.1.1), which could be malicious. To learn how to protect yourself, please go here: https://commons.lbl.gov/x/_591B
--------
Hi,
I’m having a similar problem that Jarvis was having a few months back with the (3.4.1-1) pS-toolkit Throughput / Latency graph GUI hanging during “Loading…”.
When I access the toolkit webpage with /esmond/perfsonar/archive/“format=json”, I get a blank screen.
I gziped a tarfile with the following files:
esmond.log
django.log
httpd/error_log
cassandra.log
pgstartup.log
I didn’t see any activity on this thread sine early January so I don’t if/how the problem was resolved.
Thanks,
George Uhl
--
Network Engineer
NASA ESDIS / SGT Inc.
Code 423
NASA Goddard Space Flight Center
Greenbelt, MD 20771
Office: 301-614-5155
Fax: 301-614-5700
email:
--
From: Jarvis Zhang <>
Date: Saturday, January 3, 2015 at 1:30 AM
To: Andrew Lake <>
Cc: Peter Jacobs <>, Aaron Brown <>, ""
<>
Subject: Re: [perfsonar-user] 'Throughput/Latency Graphs' page is stuck at 'Loading'
Hi Andy,
Thanks for your reply. I have restarted Cassandra, postgresql and httpd, but none of these commands return errors and the graphs still won’t load.
Attachments are the log files you mentioned.
Thanks again.
Regards,
Jarvis
在 2015年1月3日，上午12:12，Andrew Lake <> 写道：
Hi Jarvis,
The issue you are seeing is because your MA is not running properly. In Peter's case, there was an older version of the graphs on his host vs. what was on
nettest.lbl.gov, so that just showed us an update needed to happen. I don't think that's the case here unfortunately, but it was a good thing to check.
/etc/init.d/cassandra restart
/etc/init.d/postgresql restart
/etc/init.d/httpd restart
If any of those commands return errors let me know. If not and the graphs still won't load can you send me the following logs:
/var/log/httpd/error_log
/var/log/cassandra/cassandra.log
/var/lib/pgsql/pgstartup.log
Thanks,
Andy
On Dec 22, 2014, at 9:28 PM, Jarvis Zhang <> wrote:
--------
WARNING: At least one of the links in the message below goes to an IP address (e.g.10.1.1.1), which could be malicious. To learn how to protect yourself, please go here:
https://commons.lbl.gov/x/_591B
--------
Hi Peter,
Thanks for your reply. I have to say this symptom is amazing.
So, I tried it from another endpoint, but things don’t work out.
Here is my broken box.
Here is the url I imitate yours, and 115.25.138.245 is a healthy box.
Both of them are stuck at ‘Loading’.
Maybe our problem are not the same, and by the way, Andrew’s suggestion is really tricky.
Thank you all the same.
Regards,
Jarvis
在 2014年12月22日，下午10:01，Peter Jacobs <> 写道：
Jarvis (& Aaron):
You and I are having a similar problem and Andrew Lake worked with me on it a couple of weeks ago - I thought we had solved it, but it is back. Here is an interesting symptom.
If you go to my box, it times out after about 2 minutes (although it works 1 in 20 times).
If I go here (Andrew’s suggestion), I get my stats almost immediately and every time.
I don’t know what this means, but it likely narrows down the problem.
Peter
From:
[] On Behalf Of Jarvis Zhang
Sent: December-19-14 10:13 PM
To: Aaron Brown
Cc:
Subject: Re: [perfsonar-user] 'Throughput/Latency Graphs' page is stuck at 'Loading'
Hi Aaron,
Of course, attachments are the log files in ‘/var/log/esmond/’, and the directory ‘/var/log/esmond/crashlog/‘ is empty.
<logfiles.tar.gz> |
