Re: It stoped working, and won't work anymore
What did you change? And the logs say? Lauren Matheson wrote: I've just bumped into the same problem - a RedHat 6.1 server that ran for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and the server just died and is having identical behaviour to that describe - hangs on creating tables, mysqladmin stalls.. Any help would be much appreciated! Lauren Matheson - 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 - 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
Re: It stoped working, and won't work anymore
I don't know of any changes that happened right at the time that it went down. Now, the box _was_ rooted :-), but I *think* mysql going down was independent of that. Since then I've reinstalled every rpm on the system, so it should be clean. MySQL hangs as I install the rpm for it though as soon as it gets to the stage where it starts mysqld The logs say nothing unfortunately, the mysql log just records that it is starting up. Thanks, Lauren. On Thu, 24 Jan 2002, Gerald Clark wrote: What did you change? And the logs say? Lauren Matheson wrote: I've just bumped into the same problem - a RedHat 6.1 server that ran for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and the server just died and is having identical behaviour to that describe - hangs on creating tables, mysqladmin stalls.. Any help would be much appreciated! Lauren Matheson - 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 - 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
RE: It stoped working, and won't work anymore
I've just bumped into the same problem - a RedHat 6.1 server that ran for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and the server just died and is having identical behaviour to that describe - hangs on creating tables, mysqladmin stalls.. Any help would be much appreciated! Lauren Matheson - 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
RE: It stoped working, and won't work anymore
Our site has been turfed b/c of an identical problem, and despite many people reporting the same problem, no useful advice has yet surfaced. Our site has been running for over a year (non-stop) with no incident. Yesterday I logged on and noticed that mysqld was not accepting connections. After trying to restart the server, reboot the machine, checking permissions, etc, I decided to try an reinstall. Every type of install results in the process hanging at: Installing all prepared tables I have tried various RPMS and building from source. After killing the process there are no tables in the mysql folder. I have tried: - checking hostname - checking freespace - making sure there is a mysql user - making sure there is a mysql group - chowning all files in /var/lib/mysql to mysql:mysql (including /var/lib/mysql) - chmoding all files 777 (and everything below) - running mysql_install_db --user=mysql - running mysql_install_db --user=root - erasing all pids, socks and locks - creating a /etc/my.cnf file with user=mysql but I can not get beyond mysql_install_db Despite this I have copied in backed up tables into the mysql folder and have tried to start mysql (even as root). Error log says: 011230 13:52:55 mysqld started Yet I can not connect through the client, or use mysqladmin status, etc. Everything just hangs. Any advice would be appreciated, our (live) site has been down for 2 days and it seems like the only solution is to go to our co-location center and upgrade to 7.1 (or format). Although having sifted through the last 2 years worth of messages and seeing this problem reported several times with no solution, it doesn't look good.. Thanks! -mark I've decided to ask for help after 8 hours, two reinstalls, and searching the mail archives...ARGH!! System 586, RedHat 6.2, MySQL 3.22.32 Anyway, installed mysql 5 days ago, every thing went smooth with the RPM install. No problems. I made a couple of little databases, added some users, all was smooth. Then today, I couldn't connect to the database from command line 'mysql -u myname'. The mysql client would just hang and sit there, no verbose, no warnings, nothing. - 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
RE: It stoped working, and won't work anymore
On Sun, 2001-12-30 at 14:12, mark priatel wrote: Our site has been turfed b/c of an identical problem, and despite many people reporting the same problem, no useful advice has yet surfaced. I've decided to ask for help after 8 hours, two reinstalls, and searching the mail archives...ARGH!! System 586, RedHat 6.2, MySQL 3.22.32 It sounds like there is a vendor-specific (RedHat) problem, as I've been using prebuilt mysql daemons for a year now (Debian) and haven't experienced this. Perhaps check again to see if there is a newer version available - mine reports 3.23.46 as the version. Billy - 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