:: 25-Nov-2003 13:48 GMT (Tuesday) ::

If anyone running external stats needs the mapping between new and old teams,
it’s available at http://stats.distributed.net/new_team_id.csv.

:: 25-Nov-2003 09:51 GMT (Tuesday) ::

There was a bug (http://n0cgi.distributed.net/bugs/show_bug.cgi?id=3504) that
was preventing old team work from being properly re-assigned.

I’ve fixed the stats-proc bug, but now I need to re-process the past ten
days to make everything correct. I think this can be done without actually
re-processing all the work for those days, but I’ll have to dive a little
deeper before I’ll know for certain.

:: 20-Nov-2003 10:58 GMT (Thursday) ::

Stats didn’t update last night. I should have everything working again in an
hour or two.

:: 19-Nov-2003 17:21 GMT (Wednesday) ::

Sorry, that url should be http://distributed.net/~decibel/stats.tar.gz

:: 19-Nov-2003 16:00 GMT (Wednesday) ::

Team creation is turned on. :)

The last thing to do is turn on retires. This can’t happen until we can test it
on a non-stats database, and this is where you can help!

You can find the stats code-base at http://distributed.net/~decibel/stats.tar.gz
Grab a copy and install it on a box with PostgreSQL. Run
stats-sql/build/build.sh to install the database on your PGSQL server. Point
the config at a set of pproxy logfiles (you’ll need to be using daily or hourly
rotation) and get the statsrun to work. :)

Obviously it’s not that easy, otherwise we’d have done it by now. We’re looking
for help to first document the process, then make it less painful. I don’t
think there’s any huge surprises or gotchas; anyone who can read Perl can
probably figure things out (but I’ve been working with this code for years, so
I’m probably not a good judge of that ;) ).

If you do decide to help, please join the stats-dev mailing list; submit
questions, findings, patches, etc. there.

Now that we’re using tools that are readily available to everyone, I hope
that people will come forward and help tackle the bugs in bugzilla as well
as implement new features. There’s certainly things that we’re working on
internally too (such as using GUIDs as user identifiers instead of email
addresses), but I’m sure everyone knows how slow our development can be at
times. Hopefully many hands will make light work and we can move on to fun
stuff like subteams. :)

:: 19-Nov-2003 15:26 GMT (Wednesday) ::

Teams are now renumbered. Next up: team creation!

:: 18-Nov-2003 13:58 GMT (Tuesday) ::

There are a few new clients on the pre-release page since my last plan
entry including: Mac OS X, OpenBSD/x86, VMS/Alpha, and the first two
clients for AMD’s x86_64 architecture (Linux/x86_64 and FreeBSD/x86_64).
As always, please give reports of any problems in our Bugzilla.

:: 18-Nov-2003 09:45 GMT (Tuesday) ::

Looks like I was a bit too clever when I partitioned blower and now it’s biting
me in the butt (though I hadn’t anticipated 2 20G databases sharing the same
box).

Anyway, I’m moving the OGR verification database to a different partition. I
don’t know how long it’ll take; I’m guessing an hour. PostgreSQL has to stay
down while I’m doing this, and that means stats has to be down as well. I’ll
have it back up ASAP.

:: 18-Nov-2003 02:03 GMT (Tuesday) ::

Turns out that queries against the team table are locked out while this RI is
being added. Rather than take the site down while this is going on, I’ve hacked
up the PHP a bit to set a database query timeout and to display a crude error
message when a database error occurs. I don’t really know how to get rid of
the inaccurate error messages (such as ‘team not found’; your team is still
there, you just can’t see it right now). Hopefully the database error text
makes people realize this is a temporary issue.

I know this is an ugly hack of a solution; anyone so inclined is welcome to
submit a patch to any of the stats bugs (there’s already one open about the
error reporting). If you’re really adventurous, figure out how to modify
PostgreSQL so that adding RI doesn’t block all table access. ;)

:: 18-Nov-2003 01:01 GMT (Tuesday) ::

I’m finally adding RI between the main history table and other tables.
Unfortunately, I have to disable phistory while this is happening. I should be
able to turn it back on in the morning.