On Sat, Mar 29, 2003 at 07:53:32AM -0500, Bill Leonard wrote: > On 3/29/03 12:53 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote: > > >> Every so often, once every couple days or so, the databases just disappear. > >> Doing a show databases command yields an empty set. Actually sometimes, it > >> shows 1 or 2 in there. > >> > >> Any ideas as to what could be causing this, or how to troubleshoot it to > >> narrow it down further? MySQL is not quitting apparently, the databases just > >> disappear. Shutting down the service and restarting it fixes it. > > > > Any chance you're running FreeBSD? > > Well, we are running Mac OS X which is of course based on FreeBSD! So... I > suspect you have some news for me :-)
MySQL needs to be build with the HAVE_BROKEN_REALPATH flag. The realpath() on FreeBSD (and OS X) is not thread-safe. MySQL should auto-detect this when you build it. And the official binaries should be okay. But maybe you're using an old one? FWIW, the fix has been committed to FreeBSD 5.0. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 54 days, processed 1,848,966,807 queries (394/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
