Entries from August 2010 ↓

MySQL/InnoDB – ‘Unable to lock’ issue

Today, one of our MySQL database suddenly went unresponsive. The first thing I noticed was the following lines in the error.log:

InnoDB: Unable to lock /path/to/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

Upon further investigation, I found a not perfectly matched issue but does look similar: http://forums.mysql.com/read.php?22,22344,24497#msg-24497.  I took a chance and did the following:

Continue reading →

Recover lost Windows 7 user profile

At work, I had just received a new Dell desktop computer pre-installed with Windows 7.  First thing I did was to ‘join’ the computer into our internal Active Directory domain.  That was all good and I was able login to my desktop using my domain user id.  Then I started installing software and ‘personalizing’ my windows 7.  At some point, for some stupid reasons, I somehow removed my user profile folder (C:\Users\{myuserid}) … oops :-(    

From that point on, I wasn’t able to persistently store any personalization.  Everytime I logged off and re-logged in, a new ‘temporary’ profile is created.  On every logged in, windows would present me with a ‘warning’ message that in essence said it was not able to find my ‘profile’.  I did a few things to try to fix this issue, including:    

  1. manually adding C:\Users\myuserid folder
  2. removing/re-adding my domain user to the desktop
  3. detaching/re-joining the desktop to the domain

None helped.    

Continue reading →