climateprediction.net home page
XML stats problems

XML stats problems

Message boards : Number crunching : XML stats problems
Message board moderation

To post messages, you must log in.

Previous · 1 · 2 · 3 · Next

AuthorMessage
Profile geophi
Volunteer moderator

Send message
Joined: 7 Aug 04
Posts: 2184
Credit: 64,822,615
RAC: 5,275
Message 12729 - Posted: 20 May 2005, 17:33:20 UTC

When looking at my hosts on boinccstats, any that I started in 2005 are not listed, while all those from 2004 are.
ID: 12729 · Report as offensive     Reply Quote
[BOINCstats] Willy

Send message
Joined: 12 Aug 04
Posts: 36
Credit: 488,399
RAC: 0
Message 12947 - Posted: 30 May 2005, 7:04:22 UTC
Last modified: 30 May 2005, 7:05:07 UTC

Is the host problem going to be resolved?

<img src="http://www.boincstats.com/stats/project_graph1.php?pr=cp&amp;table=hosts">
BOINCstats
ID: 12947 · Report as offensive     Reply Quote
Profile old_user504
Avatar

Send message
Joined: 7 Aug 04
Posts: 33
Credit: 215,841
RAC: 0
Message 12950 - Posted: 30 May 2005, 15:00:47 UTC

I don't know how but I just got 1300 credit for something I havn't done. 1000 credit off an WU that I only just started and hasn't trickled once, and 200 off another one.

What's going on?
ID: 12950 · Report as offensive     Reply Quote
crandles
Volunteer moderator

Send message
Joined: 16 Oct 04
Posts: 692
Credit: 277,679
RAC: 0
Message 12951 - Posted: 30 May 2005, 15:37:58 UTC

Sounds like the misallocated WU problem

See <a href="http://climateapps2.oucs.ox.ac.uk/cpdnboinc/forum_thread.php?id=2577">this thread</a>

Don't really want one WU being processed by more than one host. Since someone else has got further, it would be sensible to abort these WUs before you get too far.
ID: 12951 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13074 - Posted: 2 Jun 2005, 17:19:15 UTC

Yes, it seems that the "fluke" I saw in the host XML has persisted. The problem is an invalid character in the host XML file. I believe one host has some illegal data in its p_vendor field. See this copy/paste from the XML:

&lt;host&gt;
&lt;id&gt;82994&lt;/id&gt;
&lt;userid&gt;19151&lt;/userid&gt;
&lt;total_credit&gt;567.105002&lt;/total_credit&gt;
&lt;expavg_credit&gt;0.058292&lt;/expavg_credit&gt;
&lt;expavg_time&gt;1112096428.038390&lt;/expavg_time&gt;
&lt;p_vendor&gt;^B&lt;/p_vendor&gt;
&lt;p_model&gt;Pentium&lt;/p_model&gt;
...

Notice the ^B inside the p_vendor tags. This is actually an undisplayable control character (the hex value of the byte is 02) and it causes any standards compliant XML parser to stop parsing and throw an error. I emailed tolu about it las week. On Tuesday db_dump was upgraded to the latest version however this still didn't fix the problem. Now it would seem that db_dump is turned off completely. I'm pretty sure all that is needed is a one-line SQL statement to change the p_vendor field of host number 82994 to something reasonable like 'Intel' (since it is a Pentium...). I replied to tolu on Tuesday night but haven't heard back. Someone care to poke them with a pointy stick? :)
ID: 13074 · Report as offensive     Reply Quote
Les Bayliss
Volunteer moderator

Send message
Joined: 5 Sep 04
Posts: 7629
Credit: 24,240,330
RAC: 0
Message 13082 - Posted: 2 Jun 2005, 23:42:03 UTC
Last modified: 2 Jun 2005, 23:48:41 UTC

According to <a href="http://www.climateprediction.net/board/viewtopic.php?t=2811&amp;postdays=0&amp;postorder=asc&amp;start=30"> this</a> post by Hannah, Tolu has been given time off for good behavour. And about time too; he's earned it.
Some of the moderators are looking for an alternate email address to contact Neil.

In the meantime, good work Toby.
This may be the problem. Or part of it, if there are more of these in the file.

This is the top of the BOINCstats list for "users with 1 computer" before the recent problems: (based on my appearance as a 1 computer person)

1 Michael Siemon 93,308
2 quimillo 88,128
3 chejlava 87,542
4 Les Bayliss 86,087
5 Fred Pafford 84,801
6 Oddbits 83,629
7 David Wood 83,308
8 Timothy Pagen 78,960
9 Judd Goldberg 78,828
10 Bob Pauls 75,746
11 Cadgod 74,593
12 GwydionT 74,480
13 Quixote 74,404
14 Will 72,892
15 jckcpdn 72,079
16 Alex_Van_den_Broeck 71,625
17 ninesouls 71,002
18 Ian Mordant 69,395
19 poolball 67,864
20 Marcel Portanger 67,504
21 Magnus Kessler 67,372
22 neil_nn11 67,032
23 Bruce Boytler 66,937
24 Kai 65,576
25 Kricke 65,179
*******************************************
And this is how it is now:

1 Mark2112 668,031
2 old511 250,849
3 DigitalDarkness 219,904
4 davewave 207,239
5 Overseer 152,702
6 Alan J. Simpson 150,661
7 josti 144,876
8 Miroslav Deml 144,631
9 Ian Coole 142,854
10 Alan Lund 134,555
11 chejlava 128,846
12 Kernunos 127,977
13 Matthias Essenburger 124,045
14 Grenadier 120,926
15 KWSN - 3 119,905
16 KeeperC 119,489
17 Jerome de Nazareth 118,033
18 quimillo 115,444
19 Les Bayliss 114,442
20 Oddbits 113,875
21 Judd Goldberg 112,570
22 Jean-David Beyer 112,457
23 David Wood 110,434
24 CRAIC 109,565
25 piet 108,147
*******************************************
(It doesn't format well!)
Most of those above me now, are actually multi computer people, (based on CPDN stats), but BOINCstats only lists one of their computers.
The credits listed are for their totals, but the credits on their host stats page is for just the listed computer.

This is the only list where I was doing OK. Sigh.

Les


ID: 13082 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13127 - Posted: 5 Jun 2005, 8:16:45 UTC

*sigh - still nothing. I have submitted a report via their web form as well. Still no response from that. Anyone alive over there? The solution is really simple... one line of SQL typed into a mysql console:

update host set p_vendor = 'Intel' where id = 82994;

And then I guess someone needs to figure out how to restart db_dump. Anyone happen to have the CPDN root password laying around? :)
ID: 13127 · Report as offensive     Reply Quote
Profile Pooh Bear 27
Avatar

Send message
Joined: 5 Feb 05
Posts: 465
Credit: 1,914,189
RAC: 0
Message 13133 - Posted: 5 Jun 2005, 18:23:59 UTC

I feel for you Toby. I really want to see stats, also. I am starving to see where the balls are all bouncing, etc.

Knock, knock, is anyone out there? Do we need to make a project to find the people on earth who can fix these things? (-;


<img src="http://seti.mundayweb.com/stats.php?userID=344&amp;trans=off">
<img src="http://boinc.mundayweb.com/one/stats.php?userID=584&amp;trans=off">
ID: 13133 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13213 - Posted: 7 Jun 2005, 22:48:12 UTC - in response to Message 13196.  

&gt; We are here but we are incredibly busy. Actually we = I while Tolu is away
&gt; :)
&gt; I've updated the mysql db as Toby suggested. I'm a little worried about how
&gt; this occured and that there may be more unprintable characters in the db.
&gt; Unfortunately I haven't figured out how to query for unprintables yet :)

If you restart db_dump and give us some new XML I'll be able to tell you in about 2 minutes if there are any more bad characters :) db_dump was modified back in February to automatically filter out bad characters in most text fields such as user/team name as well as some host fields. I guess not all of the host fields were included - I might have to take that up on the stats mailing list. Of course this only fixes it on the XML side of things and as you said, random strange characters showing up in the DB are a bit worrysome. However if it IS just this one host, it could be that something went wrong on the host and the p_vendor field got some bad data in it from the client and the server just accepted it without question. As far ast the database is concerned, there is nothing wrong with the character. It is just when it gets dumped into XML that it becomes a problem since XML has a specific character set that is allowed.
ID: 13213 · Report as offensive     Reply Quote
Profile old_user5994

Send message
Joined: 31 Aug 04
Posts: 239
Credit: 2,933,299
RAC: 0
Message 13231 - Posted: 8 Jun 2005, 11:43:50 UTC - in response to Message 13196.  

&gt; I've updated the mysql db as Toby suggested. I'm a little worried about how
&gt; this occured and that there may be more unprintable characters in the db.
&gt; Unfortunately I haven't figured out how to query for unprintables yet :)

I am sure you tried this ...

You should be able to make your WHERE clause to be

WHERE column LIKE '%?%'

where the ? mark is replaced by the bad character. you may have to use the character conversion to create the bad character. Of course, it would be easier if I knew what the bad character looked like ...


ID: 13231 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13243 - Posted: 8 Jun 2005, 15:08:20 UTC - in response to Message 13231.  

&gt; Of course, it would be
&gt; easier if I knew what the bad character looked like ...

That is the problem... the character in question doesn't "look" like anything and can't be typed on a keyboard. It was a reserved control character. The byte had a hex value of 02 in the XML which is a "start of text" character. I'm not sure if you can even query mysql on non-printable characters... It would have to give you a way to enter the ASCII/hex codes for the characters. Might be possible but I have never done it.
ID: 13243 · Report as offensive     Reply Quote
[BOINCstats] Willy

Send message
Joined: 12 Aug 04
Posts: 36
Credit: 488,399
RAC: 0
Message 13246 - Posted: 8 Jun 2005, 17:00:21 UTC - in response to Message 13243.  

&gt; I'm not sure if you can even query mysql on non-printable characters... It
&gt; would have to give you a way to enter the ASCII/hex codes for the characters.
&gt; Might be possible but I have never done it.
&gt;
&gt;

You can do something like (PHP example):
$sql = "SELECT * FROM table WHERE column LIKE '%".chr(02)."%'";

But I'm sure the developers are much better with SQL then I am.
<a href="http://www.boincstats.com/"><img src="http://www.boincstats.com/stats/banner.php?cpid=a4c31845a9413499815907bae59136ac" border="0"> <img src="http://www.boincstats.com/stats/teambanner.php?teamname=BOINCstats" border="0"></a>
ID: 13246 · Report as offensive     Reply Quote
old_user70741

Send message
Joined: 16 Apr 05
Posts: 7
Credit: 13,526
RAC: 0
Message 13255 - Posted: 8 Jun 2005, 20:07:02 UTC
Last modified: 8 Jun 2005, 20:07:41 UTC

Just checked BOINC stats and.................

Climate has been updated today!!

Well done all concerned especially Toby.


<img src="http://www.boincstats.com/stats/banner.php?cpid=dff6f0f73ac52826ebac01d8716dc4a8">
It's not the speed, but the quality - Until I get a faster computer
ID: 13255 · Report as offensive     Reply Quote
Profile old_user5994

Send message
Joined: 31 Aug 04
Posts: 239
Credit: 2,933,299
RAC: 0
Message 13256 - Posted: 8 Jun 2005, 20:10:49 UTC

CHAR(N,...)

CHAR() interprets the arguments as integers and returns a string consisting of the characters given by the code values of those integers. NULL values are skipped.

mysql&gt; SELECT CHAR(77,121,83,81,'76');
-&gt; 'MySQL'
mysql&gt; SELECT CHAR(77,77.3,'77.3');
-&gt; 'MMM'

from the docs...

if it is failing at an extract, you could create a "scan" using a similar query then see if there are any records that dont come out. if you have 50 records and only5 come out you know you have a problem, then create a minus query whre the ones that extract are taken from the full set and that will give you the list of the ones that have to be looked at ...

I am poking in the dark cause I can't look at the queries or the table with the data ...
ID: 13256 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13265 - Posted: 9 Jun 2005, 0:02:58 UTC

Wohoo! Did tolu come back or did someone else finally find the right button to push? :) There is going to be a big jump in my history graphs in about 7 hours!

Now for the bad news:
The hosts.xml file is even more damaged now :/

It *LOOKS* like the same problem seti@home experienced just a little while ago. It was discussed on the boinc_stats mailing list. Read here if you wish:
http://www.ssl.berkeley.edu/pipermail/boinc_stats/2005-May/000095.html

The problem in their case was that a user was deleted from the user table. This should <b>*NEVER*</b> <b><i>*EVER*</i></b> be done! Doing so leaves orphaned records in other tables which can cause problems like this and are very hard to track down. In seti's case the user was deleted and then db_dump went to look up the owner of a host to determine wether or not to put the &lt;userid&gt; tag in or not (if the user has his hosts hidden, it is not put in). This lookup failed and caused the host record to be terminated prematurely with no closing &lt;/host&gt; tag which will also completely hose most XML parsers. Here is an example from the CPDN XML file:

&lt;host&gt;
&lt;id&gt;79&lt;/id&gt;
&lt;host&gt;
&lt;id&gt;83&lt;/id&gt;
&lt;userid&gt;57&lt;/userid&gt;
&lt;total_credit&gt;24385.515355&lt;/total_credit&gt;
...

The record for host #79 is obviously truncated. There are a total of 34 hosts which have this problem. Here is a list and the command I used to get it from the XML (email might be better for this but since I'm not getting any response from anyone on the team...):

grep -B 1 "&lt;host&gt;" host.xml | grep -v \\-\\- | grep -v "&lt;/host&gt;" | grep -v "&lt;host&gt;"

&lt;id&gt;79&lt;/id&gt;
&lt;id&gt;294&lt;/id&gt;
&lt;id&gt;549&lt;/id&gt;
&lt;id&gt;692&lt;/id&gt;
&lt;id&gt;2174&lt;/id&gt;
&lt;id&gt;2184&lt;/id&gt;
&lt;id&gt;3089&lt;/id&gt;
&lt;id&gt;3706&lt;/id&gt;
&lt;id&gt;4569&lt;/id&gt;
&lt;id&gt;4684&lt;/id&gt;
&lt;id&gt;6248&lt;/id&gt;
&lt;id&gt;6881&lt;/id&gt;
&lt;id&gt;7273&lt;/id&gt;
&lt;id&gt;7406&lt;/id&gt;
&lt;id&gt;7773&lt;/id&gt;
&lt;id&gt;8425&lt;/id&gt;
&lt;id&gt;8495&lt;/id&gt;
&lt;id&gt;8926&lt;/id&gt;
&lt;id&gt;9398&lt;/id&gt;
&lt;id&gt;10088&lt;/id&gt;
&lt;id&gt;10623&lt;/id&gt;
&lt;id&gt;11839&lt;/id&gt;
&lt;id&gt;13726&lt;/id&gt;
&lt;id&gt;14043&lt;/id&gt;
&lt;id&gt;15016&lt;/id&gt;
&lt;id&gt;18664&lt;/id&gt;
&lt;id&gt;19690&lt;/id&gt;
&lt;id&gt;20010&lt;/id&gt;
&lt;id&gt;20423&lt;/id&gt;
&lt;id&gt;20659&lt;/id&gt;
&lt;id&gt;21136&lt;/id&gt;
&lt;id&gt;21367&lt;/id&gt;
&lt;id&gt;21416&lt;/id&gt;
&lt;id&gt;21459&lt;/id&gt;

As to how to fix this... (*IF* this really is the problem - somene with access to the DB will have to verify) Deleting the offending hosts is probably not the way to go as that may cause other problems. Dr. Anderson did change db_dump.C to fix this problem but I'm not sure if it is in the public branch yet so you may have to get it from the development branch. You will want version 1.83 checked in on 5/12/05. You might also want to check with Dr. Anderson to double check...

As I said, this is my theory since it looks the same as what happened to seti but I'm only on the outside looking in...

And remember <b>NEVER</b> delete users! :)
ID: 13265 · Report as offensive     Reply Quote
old_user909

Send message
Joined: 17 Aug 04
Posts: 56
Credit: 63,814
RAC: 0
Message 13356 - Posted: 12 Jun 2005, 6:23:11 UTC

*cough* anyone still there or is this project running itself while everyone is on vacation? The problem still remains...
ID: 13356 · Report as offensive     Reply Quote
[B^S] mavau

Send message
Joined: 30 Aug 04
Posts: 142
Credit: 9,936,132
RAC: 0
Message 13418 - Posted: 13 Jun 2005, 18:46:49 UTC

Anyone else noticed how RAC is wrong on top team stats and btw on BOINC Synergy's stats as well?

<a href="http://www.boincsynergy.com"><img src="http://www.boincsynergy.com/images/stats/308cpdn.png"></a> <a href="http://climateapps2.oucs.ox.ac.uk/cpdnboinc/forum_text_search_form.php"> <b>SEARCH THE FORUM</b></a>
ID: 13418 · Report as offensive     Reply Quote
Les Bayliss
Volunteer moderator

Send message
Joined: 5 Sep 04
Posts: 7629
Credit: 24,240,330
RAC: 0
Message 13422 - Posted: 13 Jun 2005, 20:33:37 UTC

Yes. It's RAC in general.
<a href="http://climateapps2.oucs.ox.ac.uk/cpdnboinc/forum_thread.php?id=2714"> Read this.</a>


ID: 13422 · Report as offensive     Reply Quote
STE\/E

Send message
Joined: 15 Aug 04
Posts: 57
Credit: 10,360,323
RAC: 1,102
Message 13479 - Posted: 16 Jun 2005, 8:02:25 UTC
Last modified: 16 Jun 2005, 10:39:29 UTC

It looks like theres a problem with the Total Credit now, my Stats haven't moved in the last 24 hours and I don't show any new Trickles turned in since about 10:30 AM yesterday even though I know I've turned in about 30-35 of them ... :?

I looked at a few other peoples Accounts &amp; they show the same thing, no trickles turned in since yesterday so it must be a server problem ...

<img src="http://boinc.mundayweb.com/one/stats.php?userID=22">
ID: 13479 · Report as offensive     Reply Quote
Previous · 1 · 2 · 3 · Next

Message boards : Number crunching : XML stats problems

©2024 cpdn.org