Category: Activities

More madness

This morning I went flying. First time since I got back from Oshkosh. I had to take the club’s Dakota out to Batavia for its annual. It reminded me what I loved and everything I hated about flying. It took an hour to scrape the snow and ice off the wings, and then it took most of the way to Batavia to get my toes to stop freezing. I made a couple of rookie mistakes on the departure, including making a wrong turn on the taxiway and actually forgetting to push the push-to-talk at one point. But by the time I got to Batavia things were going pretty good, and I made three perfect landings. I definitely need to squeeze in some time to do this more often.

This afternoon I went paddling. It was even colder than last week, but it wasn’t windy at all and it wasn’t snowing and blowing like last week. I wore an anorak over the wet suit and polytherm I wore last week, and it was too much – I actually ended up taking off my toque for much of the time. As well as Dan and Steven, we also had Doug along. He hasn’t been out for a while, and his boat still has his race number for the Long Lake race on it. Steven was trying a different boat, the KayakPro Marlin that I kept asking Ken to try all year but the rudder wasn’t working. And sure enough, half way through it the rudder broke again. Doug and I paddled on ahead while Dan and Steven worked on the boat, and next time we saw them Dan was in the KayakPro Marlin and Steven was in the Epic 18X that he’d been trying last week.

There was a ice on parts of the canal – for much of it there was ice up against one bank or the other coming out a few feet. It was thin enough that if you got into it you could paddle through it and it would break. But far more fun was to paddle along beside it, because as your wake flexed the ice sheet it made a sound very much like electrical wires twanging in the breeze. It was erie and cool.

Dan was in top form today, taking time to call out encouragement and advice to everybody about their strokes. He was really riding Stephen’s ass too – it seemed almost mean, but Stephen gives as good as he gets and still has that desire to start paddling like crazy when he should be slowing down and thinking. I was doing an ok job of hanging on to Doug when he was paddling at a moderate pace, which I thought was a sign how far I’d progressed. I still need to work on not letting my technique fall apart when I’m tired or when I’m thinking of other things.

Oh, and just to top a perfect day, I was able to get out of my kayak at Dan’s dock without help for the first time. Now if only I could get the spray skirt on without help.

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.

This is madness! This is KAYAKING!

It’s 12:55. I’m dressed in a farmer-john wet suit, toque, and polar-therm long underwear. It’s 39°F and there is a hint of snow in the air. My hands are freezing and my feet are cold. And I’m putting my kayak on my roof rack in preparation for going paddling with Dan and some of the others.

It’s now 1:20. I’ve arrived at Dan’s house to find out that I’d gotten the time wrong, and I was supposed to be there at 12:30. But Ginny says that they only left a little while ago. If anything, it’s colder than it was at home, and it’s certainly windier. I have a perfect excuse to quit if I want. But instead I quickly load up. Ginny doesn’t know which way they went, but I assume they went upwind so they’d have the wind at their back on the way back.

It’s about 1:45. My shoulders are aching, and I’m spending more time resting than paddling. I’ve been weaving around the canal, trying to stay on the upwind side to stay out of the wind, which is bitter at times. It’s cutting through me – the wet suit certainly protects me, but the parts of my torso not covered by it are cold. At least my eyes have stopped streaming. I figure I’m not going to catch up to Dan’s group, but I’ll go to the “2 mile bridge” (a bridge which is, coincidentally enough, 2 miles from Dan’s dock) and back. 4 miles is a pretty decent work-out, even if I’m struggling as I am.

It’s about 1:50. I turn the last corner where I should be able to see the “2 mile bridge”, and there is Dan and Steve. Steve is paddling cross-ways across the canal, and Dan is watching them. I’m tucked in to the shore, between two docks, and I don’t think they can see me. I speed up to see if I can get closer without them seeing me. But Dan spots me. They’ve found a semi-sheltered part of the canal, and Steve has been trying to get used to a new boat he’s considering buying, an Epic 18X like Frank and Paul D paddle. Dan points out why my shoulders have been hurting – in my rush to catch up I’ve let my technique fall apart and I haven’t been pushing with my feet and getting good torso rotation. It’s like I have to learn that lesson over and over again. Frustrating. It starts to snow a bit. A man walking along the canal looks at us and shakes his head sadly.

It’s about 2:00. We’ve been heading home, and Dan has been trying to help Steve with his technique while I try to ride either Dan’s or Steve’s wake. I’m not having to stop to rest anywhere near as much as I had on the way up, as I’m using my legs and torso much better. Plus the tail wind is helping. When I’m trying to ride his wake, it’s obvious that Steve is having trouble with his rudder and he’s weaving around. It’s much easier to stay in Dan’s wake because he doesn’t weave from side to side. He brings the speed up and down, and I follow. And the snow stops, but we’ve in and out of the wind as the canal changes direction.

It’s about 2:15, and Steve has, as he so often does, gotten frustrated with himself and stopped listening to Dan and just plunged on ahead. Even I can see that his technique has fallen apart. On the other hand, Dan wants me to finish up on a high note so we slow down and work on getting a good catch, good rotation, and a good glide. With the technique still good, we brought the pace up slowly, and finished up with 10 good hard strokes. I’m tired, but proud of myself. I really did it.