DVD arrived, still not satisfied

After the company ordering system said that it would be several days before I got my DVD burner, my boss sent his secretary out across the street to Staples, who have one on sale for $50. I got it and installed it, but unfortunately I can’t burn to it. I get the following error:
Blocks total: 2297888 Blocks current: 2297888 Blocks remaining: 948384
Starting to write CD/DVD at speed 4 in write mode for single session.
Last chance to quit, starting real write in 0 seconds. Operation starts.
Waiting for reader process to fill input buffer ... input buffer ready.
trackno=0
BURN-Free is OFF.
Performing OPC...
Sending CUE sheet...
Starting new track at sector: 1349670
Track 01: 0 of 2635 MB written./usr/bin/dvdrecord: Input/output error. write_g1: scsi sendcmd: no error
CDB: 2A 00 00 14 98 26 00 00 1F 00
status: 0x2 (CHECK CONDITION)
Sense Bytes: 70 00 05 00 00 00 00 12 00 00 00 00 21 02 00 00
Sense Key: 0x5 Illegal Request, Segment 0
Sense Code: 0x21 Qual 0x02 (logical block address out of range) [No matching qualifier] Fru 0x0
Sense flags: Blk 0 (not valid)
cmd finished after 0.003s timeout 200s

I think I’m going to have to shut down again and check that I’ve got the devices jumpered correctly.

That burning sensation

At work I’m working on a way to upgrade our systems in the field from RedHat 7.3 and the 3.3 version of our software to CentOS 3.4 and the 3.4 version of our software, while preserving as much as possible of our current content and state.

I’m experimenting with custom install DVDs with my own kickstart file. It’s been a process of trial and error, mostly error, so I’m burning about 3 or 4 DVDs a day. Each time I have to go bother the guy with the DVD burner to make sure he’s not burning anything, then copy my ISO file over to his machine, eject his blank CD (he always keeps on in the drive in case he has to burn something when he’s not here), burn the DVD, and run over to put the blank CD back.

I put in a request for a DVD burner. They cost about $50 these days, or $60 if you need the dual layer, which I don’t. My boss approved it, and I suggested that I go out after work and buy one at Circuit City, but for reasons I don’t quite understand, we have to go through “IT Purchasing”, aka “Mordoc, Preventer of Information Technology Upgrades”. Mordoc is charging our department $129 for this burner, and I’m told I should have it in two to three weeks, by which time I should be finished this project and not need to burn DVDs any more.

If I had any need for an IDE DVD burner at home, I’d buy one, install it at work, and when I’m done with this project take it home.

I’m trying to count up how many different ways this is wasting the company’s money doing it this way, and I keep running out of fingers.

Reason 147 why MySQL is not my favourite RDBMS

There are three components to my waypoint generator

  • A set of scripts to load or reload some of the data when an update comes in.
  • A set of scripts that actually generates the databases.
  • A web interface.

All three components are written in Perl, and all access the same database. As mentioned previously, I’m using MySQL because PostgreSQL was too slow on the limited resources I have on my Linode.

Last night, I ran one of the load scripts, and while it was running I tried to access the web interface. The web interface start up accesses and updates a couple of “session information” tables, which the load scripts have no reason to access. So somebody tell me why the web interface startup timed out with the error:

[Wed Jun 08 22:08:37 2005] [error] [client 66.67.112.52] FastCGI: server "/config_backup/navaid.com/htdocs/CoPilot/index.fpl" stderr: DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /config_backup/navaid.com/perl/WaypointDB.pm line 312.

Line 312 in WaypointDB.pm is a line that deletes from the table sess_main. And like I said, nobody else should be updating it. So why the hell should the fact that a load script is running cause a lock wait timeout on that table?

Oh Canada

You know, there are times when I really miss living in Canada. Two examples from today:

Calling for my weather briefing for the flight home: Most briefers at the Buffalo AFSS read you the text, exactly as you get it from the computer yourself using DUATS (Direct User Access Terminal System), and read at approximately broadband speeds. If you get a better than average one, he might summarize all the local forecasts like “four to six thousand scattered to broken”, which is fine and a good time saver and short hand. I rarely get any insight or analysis. But every single time I talk to the briefers at Gatineau Flight Service, I get advice, I get analysis, I get exactly what I need. Today, I’d seen the TAFs showing the possibility of thunderstorms during the period, but only as temporary (TEMPO) or widely scattered. I looked at the Intellicast Northeast Radar Loop, and didn’t see any signs of these thunderstorms so I breathed a sign of relief. When I called for my briefing, the briefer told me what to expect (marginal VFR conditions, high ceilings but very low visibility in haze), and then he explained that when the TAFs were issued the forecasters were unsure about where the atmospheric instability was going, but it seemed to have dissipated and moved off north of Montreal, and in his opinion I wouldn’t have to worry about anything developing along my route during my flight. He twice asked me if I had any more weather questions. I couldn’t have asked for a better briefing, and while I could see the far off lightning on the Lance’s Stormscope on the way home, there was no evidence of any activity anywhere near my route.

The other example was listening to Cross Country Checkup on CBC radio. They were discussing a pretty controversial topic, the post release restrictions on Karla Homulka. My favourite Canadian expatriate, Maddy, hated Rex Murphy, but to me he’s what a radio host on a call in show should be. He took calls from “law and order” types who lamented the fact that Canada doesn’t have the death penalty, people who expressed a fond hope that she’ll be murdered after her release, all the way to people who felt that while it’s unfortunate that the police botched the investigation so badly that they had to make a deal with devil, but they made a deal with her and so it isn’t fair to impose further penalties after she served her sentence, either because the restrictions are a slippery slope that could lead to life-time restrictions on lesser and lesser crimes, or just because it would make it harder to make these sorts of deals in cases where the police really do need some cooperation to save lives. And with all these callers expressing all these varied views, Rex was polite, he found something to agree with them and amplify, and sometime to challenge with probing further questions. He gently kept them on topic and got them to say their piece and get off. He never yelled at anybody, he never shouted anybody down or cut off their microphones, he never insulted them or made disparaging remarks about them after they were off the show. Such a huge difference to the Air America show I heard on the drive home from the airport, or any other call in show on either left wing or right wing radio in America.

A Wikipedia for Navigation Data

I was reading A blog entry about airport entries on Wikipedia and COPA (Canadian Owners and Pilots Association), and reflecting on how thousands of volunteers, people with too much time on their hands mostly, have made Wikipedia such a comprehensive resource. And it struck me that if we could harness the same sort of dedication and talent from pilots around the world, the vast number of us who rely on DAFIF (Digital Aeronautical Flight Information File) data for our flight planning, flight simulation, moving map navigators and other applications won’t be left out in the cold when DAFIF goes away.

I was envisioning something based on the Wikipedia source, but instead of a free form text entry you’d have a structured form for entering the data, and it would be pre-filled with the data already available from DAFIF, FAA and other databases. Then interested people could regularly check that against their local Aeronautical Information Publication and update it as necessary. The resultant database would be available free to any person or program who currently uses FAA and DAFIF data, such as my own waypoint database generators.

Since I posted a variation of this idea on Usenet last night, I have been informed that one DAFIF using program has already attempting the volunteer approach. The problem with that is that while they will only target users of their one individual program and only make the results available to the users of their one individual program. I think it would be better to make one system that draws volunteers from users of all programs that use DAFIF, and which makes its results available to all users of DAFIF.

My experience trying to recruit volunteers for entering data for my navaid.com systems is that people express interest, but there are very few people who follow through, and most of them lose interest after a few update cycles. The only solution is to make it as easy as possible for people to contribute, and to draw from the largest possible pool of volunteers.

Update: I contacted the people doing the volunteer project for their own product, and they have no interest in doing something for the benefit of the entire aviation community because they can’t make money off of it, and made disparaging remarks about the types of volunteers that this project would attract. Since they’re being assholes, I took the link to their site off this posting.