Hello After a reboot, the database server running Redhat 7.2 and mySQL 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the server, nothing happens and when i check in the log file for mysql, i get something like:
Number of processes running now: 1 mysqld process hanging, pid 11437 - killed 021012 01:24:09 mysqld restarted /usr/libexec/mysqld: ready for connections (It looks like mysql crash when i connect) At the start, i had no clue what was going on, i checked all the tables with myisamchk. No errors found. I had a secound server, with Redhat 7.3 and mySQL. I don't know how smart this is, but i deletet /var/lib/mysql/* and replaced the files with the ones from the other server.(Containing the database data). Now, the same problem was on that server. (As on the other, with the error message: "Lost connection to server during query" ) I removed the /var/lib/mysql/* files again, and replaced them with the old backup, and restarted mySQL. Still the same problem. (Lost connection..) I now deletet all the mysql rpm's (and deletet /var/log/mysql/*) and reinstalled them. Still the same problem. Im not a guru or anything, but for me it looks like it act like a virus. (As i can't find any solution). The thing is: I can use the mysql client and login to localhost (mysql -u root -p -h localhost) but if i use the server ip, i get the lost connection error. Don't know if this is a bug, or what it is, but if you could help, i would be greatfull. Best regards. Øystein --------------------------------------------------------------------- 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
