Daniel R.

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!