Earthlink sucks, film at 11.

Earthlink is blocking email from my colo box (which is on a static IP, has never sent spam, and isn’t on any known block list in the world). I jumped through their hoops to report this fact, and got two emails within a few seconds of each other:

  • One claiming that I’m not blocked, so why am I claiming I am?
  • One claiming that they’re removed the block that they just finished claiming wasn’t there.

And of course, email is still bouncing. Of course they did caution that removing the non-existant block will take 2-24 hours.

Don’t you just love consistency?

In the last hour, I’ve been told

  • Don’t use SYSDATE in inserts/updates because although it’s bog standard SQL (I’m not sure if it’s ANSI standard, but it’s pretty common), it’s not supported by all Microsoft databases (even though we only use Oracle in this project)
  • Do use VARCHAR2 instead of VARCHAR, because although VARCHAR2 is only supported by Oracle, and in the current release it’s just a synonym for VARCHAR, some day it’s going to have different comparison semantics than VARCHAR and Oracle says to use it, so we have to use it.

I’ve also been told that these two tables, which I have to populate by hand using manually taking the rows and columns of a spreadsheet and writing “INSERT…VALUES(‘row’,’column’,’value’)” statements several hundred times, can’t use semantic primary keys because they want to use UUIDs. So instead of looking at the spreadsheet and seeing that in the row labelled “Insurance” and the column labelled “Security” that the value is “V” and converting that to “INSERT … VALUES(‘insurance’,’security’,’V’)”, I’ve got too look up the uuid for the Insurance row and the uuid for the Security column, and change that to “INSERT … VALUES(‘6BAC51EC-C636-4C31-9E95-367062AC23F7′,’C78BF79B-3178-4F07-ACD3-92DF2742C932′,’V’)”. And I’ve got to do that several hundred times. Yes, that seems *much* less error prone that using keys I can actually tell what they mean and easily tell if I’ve got the wrong one. Oh, and even better, the code that uses the information in this table will have to hit the database to look up these uuids so that they can find the value of the “insurance” versus “security” instead of just coding those values directly.

First Official Team Practice of the season

Almost the whole team met at Baycreek today, and it was so great to see everybody again (we missed you, Mike). I’d seen most of them here and there over the winter, but this is the first time we paddled as a huge group since last fall. I was in my Thunderbolt, and several other people were in surf skis, but Dan and Jim were in downriver boats. Dan’s especially was a bit of a barge and threw out a beautifully huge wake to ride.

The weather has started to cool off a bit since Thursday, and it was pretty windy as well, so I was back in the straight jacket (farmer john and hydroskin shirt). I’ve been paddling a lot, and this is my fourth time paddling this week, but the traffic and the boat wakes added a new challenge.

Because of the wind, we didn’t go out on the bay and just paddled up and down the creek while Dan went around yelling out advice and correction to everybody. We didn’t do any formal drills, but being us, we of course had times when we paddled hard and times when we paddled not so hard, some paddling along chatting and catching up, and sometimes head to head rivalry. On our second last time up the river Frank took the lead and started hammering, and Dan and I tried very hard to keep up with him. I was doing ok until Dan purposely cut me off (don’t worry, I’d tried to do the same thing to him the time before, so it was legitimate payback) and I lost his wake, and once I lost his wake I was done for and ended up several boat lengths behind the two of them. Dan confessed afterwards that he’d been almost at his limit at that point. Frank is considerably older than us, but he’d just come back from a couple of weeks paddling in Florida, so maybe he was a little more at his in-season prime that us.

But once again I was reminded about the best part of paddling as a team isn’t the races or the matching jerseys and the big Bay Creek Racing stickers on our boats, it’s just being with a bunch of fun guys messing around in boats.

Overdid it a bit. Or maybe a lot.


I was waiting on some information at work, and kind of stuck until I got it, so I headed off to meet up with Stephen and Jim for their regular 1:30 paddle starting at the Black Creek access. I got there just before 1:30, and there was no sign of them. I paddled a 10 minute warm up, and still no sign of them. So fine, I thought, I’d head up stream at a moderate pace, and either I’d get a nice long paddle at my own pace, or they’d catch me up. Usually when I paddle with those two, they end up going hard so I end up in the 150-165 heart rate zone, but on my own I tried to keep it down in the high 130s or low 140s. I wasn’t entirely successful at that.

As I reached about the 2 mile point the river turns, and I took one last chance to paddle out into the middle to look downstream, but I didn’t see them. Ok, long slow paddle it is. I decided to see if I could reach the 6 mile point before I turned around. Since I’d done about .75 miles in my warm-up, that would leave me 5.25 miles to return, and put me over 10 miles on the day. Mental arithmetic isn’t my strong point – I really should have aimed for a turnaround at the 4.7 mile point to reach the 10 mile goal. But I wanted a bit of a cushion because on the way up you’re following the banks pretty closely and ferrying across the river to keep out of the current, but on the way back you blast down the middle.

The current was strong, and the wind was also strong in places, but at least they were going the same direction. The current swirled and eddied, and a couple of times I found myself having to brace to avoid dumping. As I got higher and higher up the river, I was getting slower and slower. Once I decided not to ferry across the river to get on the inside because I didn’t want to be so exposed to the wind, and that was a big mistake because not only was it slow on the outside of the bend, but it was also more roiled up with eddies and swirls and other challenges. I wasn’t sure if I was getting slower and having to brace more because the current and wind were getting stronger, or if I was getting fatigued and making mistakes because of that, and I was a little worried about being out here alone if I was making mistakes. After one really hard brace, I decided I’d had enough and turned around at the 5.6 mile point.

Turning downstream, my speed immediately went up into the low 9s. I don’t think I’ve ever paddled that fast before. I was just flying down. And I was starting to think my problems before were really problems with the river, not my own fatigue. After 6.7 miles (1.1 miles after I turned around), I met Jim coming upstream. That was good, that meant I’d have company when I was most tired. Not too much later, we met Stephen and Julia coming upstream as well. Stephen wanted to go as far as the RIT dock before he turned downstream, so I turned upstream again and went with him. That added another half mile of upstream to my total.

Going downstream was uneventful except when Stephen and Jim did their inevitable sprint for the bridge at the end, I didn’t have the energy to raise my speed even an iota to try to catch one of their wakes. But the worst was yet to come. Where Black Creek comes out into the Genesee there is a hellacious eddy. Last time I hit it just right and it spun my boat and accelerated me into Black Creek. This time, I hit it wrong and dumped. With about 10 yards left to go, I dumped into the freezing cold water. I walked up onto the bank, and slipped in the clay mud and fell back into the water. But I got my stuff semi-organized, and Julia jumped out of her boat to help me wrangle my stuff on the shore, while Jim paddled over and helped me dump out the water. Fortunately the air was wonderfully warm, so I wasn’t too chilled.

I just checked my blog, and the first time I paddled 10 miles last year was May 30th, the weekend before the Tupper Lake 9 miler. I’d say I’m a bit ahead of that schedule this year.

Total miles: 11.16
Total time: 2:09
Year to date: 83 miles!