this is weird. I have been running mysql 3.23.40 for a long time, no problems. I attempted an upgrade to 3.23.49, but mysql segfaults when I load safe_mysqld as uid root.
my typical startup for mysql would be: /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=128M -O table_cache=512 -O sort_buffer=32M -O record_buffer=10M (I have a bunch of other stuff too, but for this, I am only using the above command line, which doesn't work). btw this machine has 1GB of ram and 1GB of swap so there's plenty of memory for the buffers. even running with no options other then --user=mysql it segfaults. the .err file has some stack traces and stuff. but the REALLY weird thing, is if I su to mysql, and run that same command line it works fine. I am thinking it is a library problem, I had this error before a couple of months ago on 3.23.40 after I had upgraded libc6 (apt-get upgrade on debian), it was fixed by just recompiling mysql(I had the same source tree, I originally used, just did make clean ; make ; make install). it ran fine(and runs fine). I added /usr/local/mysql/lib/mysql to /etc/ld.so.conf and ran ldconfig, I added /usr/local/mysql/lib/mysql to $LD_LIBRARY_PATH and it still segfaults. for now I have it just running in su'd mode so one of the employees can run some tests to see if there is any difference over 3.23.40 for this one app we use. really weird ....the DB is fully functional from what I can see. I am not sure what is different by su'n to user mysql. if the .err file is required i can provide it, i would do it now but I overwrote it when i re-started it as user mysql and don't really want to shut the db down if my co worker is doing stuff on it. i can shut it down again later tonight though OS: Debian GNU/Linux 3.0 Kernel: 2.2.19+a few patches system runs a lot of other things such as openldap, apache, apache-ssl, and a bunch of stunnel processes for mysql and for openldap. system activity is pretty low though, my network doesn't have a lot of users. thanks for any pointers!! nate --------------------------------------------------------------------- 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
