« Blah / Yay | Main | What Should I Do with My Life? »

Grrrr

I'm at the point that I really need to step back, take a deep breath, count to ten and then maybe I can put into words the last two hours. All I wanted to do was upgrade Gallery. Next thing I know I'm having to reboot my box and troubleshoot a MySQL that has started throwing errors that its perror utility says doesn't even exist! The worst part is I have no faith right now that the problem is even fixed or how long / bad the problem has been going on since it seems to have manifested in such subtle ways.

The gist was mysql throwing an error like this:

060221 1:21:47 /usr/local/libexec/mysqld: Can't find file: './test/test_test.frm' (errno: 9)

And the all helpful perror:

> perror 9
Illegal error code: 9

This thread had some ideas but I wasn't keen on rebooting again. I'd already pulled the Windows approach and rebooted since this guy had some success with it. No dice. Don't know where I ran across it, but a startup flag helped. Adding --open-files-limit worked for me. I did see somewhere else that someone thought that the OpenBSD 3.8 package mysql-server-4.0.24p1 was junk.

And to top it all off I still think (while probably all psychosomatic now) that this new monitor is just not working out. LCDs are not supposed to cause eye strain!

Comments

Is the 2nd LCD on an analog port? And...wait...didn't you already have an LCD? what about using only the new one for a little bit? Or just buying a bigger bottle of aspirin...
I had a SyncMaster 570V TFT. I got a SyncMaster 910T. I'm currently using the 910T hooked up digitally to my original nVidia card and it still doesn't feel right. Things felt worse when I had the 910T hooked up to the digital on the new ATI card and the 570V on the analog. Like I said, I think it maybe psychosomatic at this point.
That errno is not a MySQL error and so perror doesn't have it. It's an OS error. An errno of 9 means that the file (or socket, stream, etc) descriptor is bad. I have a C example on neophi that can make this happen as well. Usually indicates a programming bug.