Category: Rant

Blergh

I didn’t sleep last night. My elbows were killing me, and I had a very acid stomach. As a matter of fact, sometime around breakfast time I figured out there might be a common cause – if I didn’t take enough water with my evening Aleve, it doesn’t go down all the way and gives me acid and doesn’t help my joints. On top of that I’m tired as hell. I couldn’t get comfortable all night – my legs were always cold and my trunk was always too hot. And I had a bunch of stuff running around my head.

Right now I’m not 100% sure if I’m going to have explosive diarrhea or vomit. So I’ve come home. Maybe I can get some sleep.

Yeah, you don’t want to dare me that

I’ve written earlier about how I have flown so little this year that I’m seriously considering going “inactive” in the club? Well, on top of that, I’ve been Secretary for the club for most of the time I’ve been a member – I think it started soon after I created a web site for the club on my own. I suck at it. I’m not organized enough, and I don’t like doing it. I got free of it once, but the person who took it on quit after a year or two and dumped it back on me.

And the club communications are now totally dysfunctional. There is a “officers” mailing list for officers and board members to communicate, but the current president of the club, and a couple of others, totally refuse to use it. Instead, they send email to long lists of CCs, which means that you personally have no control over what email address you receive the message, or in what format. It also means that sometimes you find out that a conversation is going on because sometime in the middle of it somebody stops hitting “Reply All” and uses their own address list. One extremely annoying example of this happened when the club officers and BOD were discussing selling the Lance (which I knew about) but didn’t include me in most of a long thread about some of the details in spite of the fact that I was one of three members of the club who used the Lance, I was one of two officers who used the Lance, and the detail they were discussing had to do with on-line advertising. Anyway, the President last year said “I can see why people would want the email list, but I’ll continue to use my own list”, and subscribed. But sometime between then and now he’s unsubscribed again (which I didn’t know). Meanwhile, he’s stubbornly using his alias list (which includes people who haven’t been officers in 4 or 5 years and who don’t live in the US any more), and I’m stubbornly using the mailing list.

So last night (it’s now 3:30am and I haven’t been able to sleep all night because I’m so riled up about this) he sent me an email basically saying “communicate with me my way, or we’ll replace you as secretary”, and talking about how he didn’t want to be president but it was thrust upon him because nobody else would take it. I responded with an ecstatic “YES, PLEASE DO” and explained how I didn’t want to be secretary, have had it thrust upon me twice, and have been doing it for about 10 years total of my 15 years in the club.

I guess I’ll have to wait to see if I’ve called his bluff or whether I’m really going to be free of this horrible task. Maybe I’ll spend some time converting the club web site to Joomla so I can hand off more of that to others in the club.

It never fails

It never fails that when on “FAA Data Reload Day” (which occurs every 56 days on the ICAO cycle), I manage to screw something up and end up staying up late. It doesn’t matter how early I start.

Today’s screw up was after loading the data, I realized that I’d done something wrong, and needed to restore the database to the state it was before I started the load. For reasons too complicated to go into here, I load the data on my home Linux box, and then scp it up to my colo box where the web site lives. The database that lives on my home box doesn’t have all the same tables as the one on my colo box, just the tables that are important to data loading.

So, I thought, the easiest way to get back to the data as it was before the data load is to upload the script I use to export the appropriate tables on the home box to the colo box, run it there, copy the file back to the home box and load it. Except after I loaded it, I noticed a distinct lack of data on my home box. As a matter of fact, it appears that the load went way too fast, like it had no data at all. A quick look at the export file confirmed that there wasn’t any data in it, just some table deletion and creation stuff. Oh oh.

That’s when I realized that one of the consequences of having different versions of PostgreSQL on the two boxes was that “pg_dump … -t waypoint -t comm_freqs -t runway…” works on my home box, but not on the colo. Not thinking too straight, I then used a ‘for table in …” command to run pg_dump on each table individually. When I copied them home, I discovered that this messed up the foreign keys rather badly. So I tried to manually stitch all the files together. That wasn’t working very well, because I had things in the wrong order and the foreign key stuff still wasn’t right.

That’s when it suddenly hit me. Duh. The whole reason I have an external drive on my machine is so that I can do hourly rsync backups. I have a copy of the postgis.dump file that I copied over 56 days ago. As a matter of fact, I have dozens of copies of it. The only reason I was avoiding it was because I had done a few small manual modifications to the database since then. But those were still in the history buffer of psql, and so they were easy to reproduce. I restored the backup, made the changes at around 10:45, ran the updates again, and now here it is at 11:30 and everything is finally done.

I just hope this doesn’t happen again in 56 days, although I’m sure it will.

I hate to admit it but…

Much as I bitch and moan about my new job, I have to say that in spite of the extra work involved and the constant worrying about stains, I love the look and feel of a good dress shirt, especially those Joseph and Feiss no-iron ones. Dress pants I’m not so enamoured of, mostly because they feel tight around my thighs when I’m sitting down. And dress shoes should vanish off the face of the earth. Immediately.

I remember when I was at Gandalf I dressed up most of the time, except when I was either feeling pissed off about something, in which case I couldn’t be bothered to make the effort, or when I was anticipating spending time in the lab rewiring networks or upgrading computers. And that was with riding my bike to work in the morning, showering and changing there, and going for a long ride after work. My shirt and pants for the day were folded into a MountainSmiths backpack that I’d bought for doing the Silver Courier du Bois in the Canadian Ski Marathon, so they probably weren’t as unwrinkled as they should have been. Or as uncontaminated by ski wax.