Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Rene Churchill writes:
>>
>> I'm having a problem with mysql forgetting the location
>> of it's datadir. After the server has been running for
>> some time, it looses track and starts throwing errors
>> when I attempt to select a database. Killing mysqld
>> and letting safe_mysqld restart it fixes the problem
>> for a while, but having to do it 10 times a day is a
>> bit much.
>>
>> I've recompiled the server with the datadir set via
>> ./configure instead of the command line of safe_mysqld.
>> That seems to have reduced but not eliminated the
>> frequency of the problem. This could also be a side
>> effect of less traffic on the weekends.
>>
>> mysqld - 3.23.29
>> gcc - 2.95.2
>> OS - MaxOS 10.0, Darwin 1.3.7
>> Apache - 1.3.19
>> PHP - 4.0.x?
>>
>> I'm currently waiting for it to start throwing these
>> errors again before I can do a mysqladmin variables
>> and extended-status. These will be submitted via
>> support.mysql.com
>>
>> Has anybody else seen this kind of behavior? Any
>> suggestions on how to debug it?
We have seen this problem before on BSDI. In this case the problem
was that when we executed the system call 'realpath', the system
sometimes changed the current directory 'under our feets.
Could you try by recompiling MySQL and setting the option
-DHAVE_BROKEN_REALPATH to the CFLAGS environment variable ?
CFLAGS=-DHAVE_BROKEN_REALPATH ./configure
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
