Not a good idea

This morning I was investigating a problem at a customer site where their Manager (a program I wrote most of) is hanging. Thanks to “kill -3 pid” I discovered it was building a tool tip. Thanks to a database query, I found that the tool tip it was building was trying to display 430,000+ identical date ranges. Hmmm, looks like we’re going to be a while, and probably a little short of screen real estate at the same time.

I did a few database commands to remove the 430,000+ records and put back one copy of it. (I’m sure somebody has a command that will do both in one step – I did a “delete” followed by an “insert” because I’m lame.)

The Field Engineer at the customer site wrote to ask if I could tell him the database commands in case this happens again. I politely declined. I told my boss that this would be somewhat like giving handguns and tequila to a bunch of 9 year old boys. Repeat after me:

I’m sorry, you appear to have totally hosed the database. You’re going to have to wipe the database and re-injest all your content. You’ll probably be up and running again in two days or so.

This looks incredibly promising

Thanks to a post by Skud, I’ve discovered Freebase, which is, as Skud described it, “crack for information nerds”. It appears to be exactly what I was hoping to develop or find for my aviation navigation data project – a flexible structured information agregator, almost like a wiki with user definable fields.

You probably can’t see much of it, because right now it’s in alpha and by invitation only, but so far they’ve imported all of Wikipedia and added some links between then, and people have written some demo applications.

Like many AJAX applications, it has a tendency to get the dreaded “a script on this page is running slowly”, but otherwise it’s pretty nifty.

Spoke too soon

Yesterday I wrote that I’d turned off the old machine for the last time. Well, it turns out I was wrong. I had put the mp3s in the wrong location, and had the permissions wrong, and so the backup script’s rsync deleted the mp3s from the wrong place and then couldn’t write them to the correct place. Which meant that this evening I had to turn the old machine back on, copy the mp3s back over (only having to reboot the old machine twice as it froze up under heavy load as it is prone to do) and then shut down the old box once again. Now that that’s done, I have to re-import my iTunes library, which will undoubtedly continue long after I’ve gone to bed tonight.

On the plus side, though, I managed to get the UPS software NUT installed and working. My new box doesn’t have a serial port, which means I had to use the USB driver for the first time. The kernel first identifies the UPS as a X Box controller (xpad), but eventually the newhidups driver figured it out.

Cutover complete

The old box is shut down, hopefully never to be turned on again, and the new box is up and running with nearly all the old functionality. It’s very quiet in this office with that old beast off.

As well as the base install, and fixing all the Ubuntu stupidity (and a few bugs in the munin-node scripts), I had to install and configure all the following:

Apache2
Postfix
Postgresql
MovableType
Bind
user accounts
bogofilter
spamassassin
Root cronjobs
ssh tunnel
My cronjobs
trn
/etc/profile
Mutt configuration
munin
squirrelmail
iptables/ssh-black
frm/nfrm
ftp server
NFS export /mp3s

I still need to get nut set up to control the UPS, and hook up a printer and configure it. I’d also like to get Java and eclipse set up so I can do some work on it.

Right now iTunes is cranking away importing the “iTunes Music Library.xml” where I changed the old nfs mount point to the new one. It’s taking a while.