Park Camino Database lock up | Feb 24th 2006
Mary Gregory called me at home at 8:42 and asked me to check the Park Camino escrow database. Eugene reported that when users login to the database, they get a message that the database is open for read-only access. I called Eugene and had him open the database. He did not get the error message anymore. I asked him to call me if any issues come up again. Around 9:00 am, Sherrie reported that when she tries to create a new escrow entry, the database takes her to the debug mode. I told her I’d look into it when I get to the office. When I checked on her at the office, she told me all the issues went away after Mary put in the second backup tape. She thinks the server might have been in the middle of backing up the database when it asked for the next tape and locked the database file up until it was done backing up the entire file. I think that may be what happened.
The problem is if this continues to happen every day. They can’t wait until the tape is changed so they can access their database. Possible solutions: 1. Install a bigger tape drive 2. Reduce the amount of files on the server so it will fit on one drive. 3. Do not backup the entire server, just backup the directories that changes every day.