Not remote enough

It’s not often that I completely take a day off from working. Seems there is always some little thing that needs attention, whether it’s testing out some new code, checking stats, responding to email, or addressing some sort of issue. Well, today wasn’t one of those days off, but if ya gotta work, there are worse places to be when working.

Remote working with Django

I was out for a hike near my house with our dog Django (no relation to the web framework, but some relation to Django Reinhardt), when I received an alert from our server monitoring system. Nothing critical, but it was something that needed to be addressed before it became critical. Perched on the nearest rock, I pulled out my Treo 650 (I’m not going to upgrade until I can get a Linux based Palm device), which has pssh installed. The signal is not great around here, but usable, so I was able to access the server in our data center, correct the issue, and continue our walk. This photo, taken with that same Treo, was my view from that rock after receiving the “recovery” alert. (Django is pretty patient with server alerts.)

Makes me wonder just how remote I can go, with the fewest and smallest devices, and still be effective. Not many look at this site, but I’m interested in any thoughts or comments regarding minimal tools used to work remotely in a technology related position. Sure, a laptop makes it easy. Let’s go smaller.

MySQL fatal error 1236

MySQL error message when attempting to start a replication slave:

Got fatal error 1236: ‘Could not find first log file name in binary log index file’ from master when reading data from binary log

I banged my head against a wall for a short period of time trying resolve this one. The resolution is easy, but I didn’t find it in my searching. Hopefully this will allow someone to move forward more quickly than I did, providing I am not the only one that didn’t immediately realize what was going on. The full error reads something like:

060903 11:01:58 [Note] Slave SQL thread initialized, starting replication in log '/var/mysql/logs/mysql-log.000125' at position 97277001, relay log './slave-relay-bin.000001' position: 4
060903 11:01:58 [Note] Slave I/O thread: connected to master 'slave@master:3306', replication started in log '/var/mysql/logs/mysql-log.000125' at position 97277001
060903 11:01:58 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
060903 11:01:58 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
060903 11:01:58 [Note] Slave I/O thread exiting, read up to log '/var/mysql/logs/mysql-log.000125', position 97277001

The slave was being started from an InnoDB Hot Backup created on the master. After restoring the backup and starting up MySQL, the following binlog position was reported:

InnoDB: Last MySQL binlog file position 0 97277001, file name /var/mysql/logs/mysql-log.000125

which suggests the change master statement:

CHANGE MASTER TO
MASTER_HOST='master',
MASTER_USER='slave',
MASTER_LOG_FILE='/var/mysql/logs/mysql-log.000125',
MASTER_LOG_POS=97277001;

However, the full path to the log file is what causes the ‘Could not find first log file name in binary log index file’ error. MySQL looks for the log file in the defined log directory, /var/mysql/logs in this case. Simply adjusting the change master statement:

CHANGE MASTER TO
MASTER_HOST='master',
MASTER_USER='slave',
MASTER_LOG_FILE='mysql-log.000125',
MASTER_LOG_POS=97277001;

results in:

060903 11:15:16 [Note] Slave SQL thread initialized, starting replication in log 'mysql-log.000125' at position 97277001, relay log './slave-relay-bin.000001' position: 4
060903 11:15:16 [Note] Slave I/O thread: connected to master 'slave@master:3306', replication started in log 'mysql-log.000125' at position 97277001

And we’re replicating. Maybe if I had more occasion to bring up new MySQL replication slaves, this would have been obvious.

Compassionate Breakfast

According to Wikipedia:

A meal can be considered breakfast if it satisfies 2 of the following 3 criteria: 1. It is the first meal of the day 2. It consists of “breakfast style food” 3. It is eaten before noon.

There are plenty of references to breakfast being the most important meal of the day. After all, you are breaking a fast that lasted since the previous night’s dinner. (“Since six o’clock last night, you haven’t eaten a bite…” — from a Saturday morning cartoon that used to air when I was a kid, featuring some small blob looking guy in a top hat singing and dancing in a refrigerator.) If I skip breakfast, I’m miserable way before it’s time for lunch. Usually a simple bowl of cereal with some fruit added is enough to do the trick, possibly accompanied by a protein drink.

Some mornings, as much as I value a good breakfast, it’s tough to squeeze it in and get to work at a decent hour. I’m not much of a morning guy, preferring to stay up late rather than rise early, and often my morning can be a balancing act between getting enough sleep, good nutrition, taking care of the random morning crises (work related or otherwise) and actually getting myself out the door. Breakfast can be even more tentative when my wife Suzanne is out of town, which is frequent.

Enter Jamba Juice. I started frequenting one particular location during my morning commute, and I guess one would call me “a regular” now. I feel a bit like Norm from Cheers. Everybody there knows my name. They also know my juice, and it’s usually sitting on the counter in front of me by the time I reach the register. The team there always brightens my day, whether it’s just a cheery “Hey, Doug!” or enthusiastic support for Suzanne’s work in Belarus.

This morning they named me Customer of the Week. Seems like a simple thing. It doesn’t take much work on my part; I just get out of the car and hand over some cash. Still, for reasons not completely clear to me, I was really touched. I filled out a form and they took my picture for the Customer of the Week bulletin board. It’s only a week. I’m not the first Customer of the Week and I won’t be the last. Why was I so touched? Could it be I’m just missing my wife, who I haven’t seen for a week and won’t see for a few more days, and I’m craving attention? I don’t think so, as I’m not much for seeking out attention (although the act of posting this on the Internet and using a domain that is my name might suggest otherwise). Could it be the few free smoothie cards I received? Nah, the dollar amount is a drop in the bucket compared to what I spend there.

I really think it’s the genuine kindness demonstrated by the Jamba Juice team. Sure, they are just doing their jobs, but with so much hate still filling so many lives, so much negative news on TV, so many instances of needless suffering throughout the world, it doesn’t take much for us to be moved by kindness. It’s actually amazing how easy it is to spread a little kindness and compassion. It strikes me that naming someone Customer of the Week isn’t really all that different than the work Suzanne is doing in Belarus. Sure, the scope is about as different as the Grand Canyon is deep, but the intent comes from a similar place. To quote Suzanne:

If we knew we didn?t matter to anyone ? really, what would be the point? Everyone needs to know that someone cares and is happy they are alive.

Showing that one cares can be as significant as traveling half way around the world to help childeren in a radiation exclusion zone or as simple as saying we want to take your picture for regularly coming into our store.

I just recently experienced another situation where kindness had a poignant effect. This past weekend, my brother and I traveled to North Carolina to visit Dad. On my Southwest return flight from Raleigh to Pheonix, I snagged good seat near the front of the plane next to the window — perfect for my plan to sleep through as much of the flight as I could. If you are unfamiliar with Southwest’s “cattle call” seating method, this is not always an easy feat. On top of that, nobody took the middle seat. This is close to perfect in the Southwest cross country flight world.

Just before take-off, the flight attendent announces that a woman and her five year old daughter cannot find a seat together, and would anyone care to switch seats. Flipping through a magazine, I don’t pay too much attention at first. Besides, they are all the way in the back of the plane.

After a few minutes, the announcement is made again. This time it catches my attention. I offer my seat, since there is an empty one right next to it, pick up my carry on pack and head to the back of the plane; the very last row in the plane, as it turns out. No big deal. Cute kid, frazzled mother — glad I can help. As I walk down the isle, I am a little surprised to get a few pats on the back. Literally, a couple guys pat me on the back. Then someone starts clapping. Within a few seconds, there is a full round of applause going on as I take my seat at the rear of the plane. The flight attendent offers to buy any drinks I would like during the flight (and if it were not an 8:00AM flight, I would have graciously accepted at least one), just for “helping her out.”

I was not the only passenger sitting next to an empty seat, so I have to wonder, a) Why didn’t anyone else give up their seat? and b) Why was I treated like I just pulled someone from a burning building? Are we really that starved for kindness? Are demonstrations of compassion and genuine caring for others really so rare? My own experience in being named Customer of the Week suggests yes, kindness and compassion are so lacking in our daily lives that even small examples can have a moving effect.

So thanks Jenny, Brianna and the rest of the Jamba Juice team in “my store.” Naming someone Customer of the Week might seem like a simple thing, but the attention and recognition came from the heart, and that’s what touches another’s life.

Chernobyl Hope – People Magazine

We knew the article was being written. After all, one of the authors and a photo journalist met Suzanne and her colleagues during the last trip they made to Belarus. What we didn’t know was what would be written, what photos would be used, or even exactly when it would be published.

Chernobyl Hope - Suzanne Reese - Photo by Antonin KratochvilOpening the April 24, 2006 issue of People Magazine to page 104, it is hard not to get choked up at the two page image of my wife offering comfort to 4 year old Nastya Gerasimuk while the dressing on a wound is changed. The photo speaks volumes about lives of the disabled children who call the Vesnova Children’s Asylum in Belarus their home, the dedication Suzanne has to improving their lives, and how much these children have touched our lives. Yes, our lives, and I’ve not met any of them.

The article chronicals a few days spent with Suzanne, Jennifer O’Dea and Kathy Ryan at the asylum in Vesnova this past March. Jen is an occupational therapist chosen along with Suzanne to join the efforts of the Chernobyl Children’s Project International back in October, 2005. Kathy is the executive directory of CCPI. There are many volunteers who travel to Vesnova, mostly from Ireland, working to improve the lives of the children in the asylum. The specialties of the volunteers are varied. Nurses, therapists, and construction workers are among the types of people Suzanne has worked alongside during her visits to Belarus.

Brief yet informative, the People article touches on a lot of a typical day in the asylum. It still seems a bit surreal to me, with a photo of Jessica Simpson on the page before the article, and a birthday tribute to Queen Elizabeth II on the pages that follow. Proud? I’m telling everyone I know.

Previous entries reference preparing for the first trip and Suzanne’s experiences from that trip. Suzanne’s new web site, www.CompassionateChild.com, contains more on her experiences and her efforts to improve our world by “nurturing the inherent love and compassion our children are born to share.”