Netstat
Can anyone confirm that this is correct from a query of netstat? Should the sock be 'connected' instead of 'connecting'? I ask because although mysql is running in the proc list, it is not responding to any commands. unix 0 [ ACC ] STREAM LISTENING 87380 /var/lib/mysql/mysql.sock unix 0 [ ] STREAM CONNECTING0 /var/lib/mysql/mysql.sock Thanks, Jeff - 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: Reinstallation HANG
I've gathered more data on my problem here. We have recently made a few DNS changes that I think have hosed mysql. See the error message below: DBI-connect failed: Unknown MySQL Server Host 'myserver.com' (2) at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28 Can't call method "prepare" on an undefined value at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32. The 'myserver.com' is no longer a viable domain, so is there anything in the installation or starting of mysql that needs this domain? I have the same 'hanging' error on start and stop of mysql. And if so, where can I change it so it uses our new domain? Or do I have to do a complete reinstall with a newly compiled installation app? Thanks, Jeff -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 4:19 PM To: Weber, Jeff Cc: [EMAIL PROTECTED] Subject: Re: Reinstallation HANG "Weber, Jeff" wrote: Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff You should have run mysql_install_db --user=mysql Now the database directory and all the files are probably owned by root, and mysqld can't read the directory. chown -R mysql /var/mysql/data replacing "/var/mysql/data" with actual mysql database directory. - 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: Reinstallation HANG
If I pull the hostname, I don't get 'myserver.com', but this server never was called 'myserver.com' to begin with. The 'myserver.com' domain was expired for the last year or so, but I never removed it from the DNS records until recently. So really, for the last year, 'myserver.com' never refered to anything. I don't want to revert back to the old DNS records, because there were other problems. Do you think that the problem is somewhere else in the server config or is it isolated to mysql? I don't have any other problems with software on this box, which makes me think it's mysql. -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:56 AM To: Weber, Jeff Cc: [EMAIL PROTECTED] Subject: Re: Reinstallation HANG when you enter the unix command hostname what do you get ? This had better be resolvable with your DNS. Maybe you forgot to fix your hostname when the domain was changed. "Weber, Jeff" wrote: I've gathered more data on my problem here. We have recently made a few DNS changes that I think have hosed mysql. See the error message below: DBI-connect failed: Unknown MySQL Server Host 'myserver.com' (2) at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28 Can't call method "prepare" on an undefined value at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32. The 'myserver.com' is no longer a viable domain, so is there anything in the installation or starting of mysql that needs this domain? I have the same 'hanging' error on start and stop of mysql. And if so, where can I change it so it uses our new domain? Or do I have to do a complete reinstall with a newly compiled installation app? Thanks, Jeff -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 4:19 PM To: Weber, Jeff Cc: [EMAIL PROTECTED] Subject: Re: Reinstallation HANG "Weber, Jeff" wrote: Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff You should have run mysql_install_db --user=mysql Now the database directory and all the files are probably owned by root, and mysqld can't read the directory. chown -R mysql /var/mysql/data replacing "/var/mysql/data" with actual mysql database directory. - 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
Table Limit Crashing Machine?
Mysql recently crashed my Linux box during a cron. Mysql quit responding and then the cron keep opening mysql until it cooked the memory. I rebooted, and now I can't restart mysql, I can't use mysqldump or mysqladmin either. They all just hang. Could it be possible that the table locked up because it exceeded size limits? I have been able to run myisamchk and it says it fixed some errors, but still mysql will not start. The error logs are really of no help in determining what happened as far as I can tell. My system info: Linux 2.2.14-5.0 #1 i686 Mysql: mysql Ver 10.8 Distrib 3.23.21-beta, for pc-linux-gnu (i686) My error log tells me this: [Thu Feb 15 20:26:33 2001] [info] [client 209.196.110.9] (32)Broken pipe: client stopped connection before rflush completed [Fri Feb 16 06:03:48 2001] [error] (23)Too many open files in system: accept: (client socket) The mysql error log says this: mysqld ended on Sun Feb 25 22:16:34 EST 2001 mysqld started on Sun Feb 25 22:16:41 EST 2001 /usr/sbin/mysqld: Can't change dir to '/host/' (Errcode: 2) 010225 22:16:41 Aborting mysqld ended on Sun Feb 25 22:16:41 EST 2001 mysqld started on Sun Feb 25 22:17:06 EST 2001 Please read "Security" section of the manual to find out how to run mysqld as ro ot! 010225 22:17:06 Aborting Any help is appreciated. Thanks, Jeff - 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
Mysql PID Problem?
Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql, mysql should start up and it does --somewhat. Here's the message I get: [root@myserver mysql]# /etc/rc.d/init.d/mysql start [root@myserver mysql]# Starting mysqld daemon with databases from /usr/var/mysql And it shows up in the process list below... root 5340 0.0 0.3 1668 828 pts/0S21:23 0:00 sh /usr/bin/safe_ mysql 5365 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5366 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5367 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld And it logs it to my /usr/var/mysql/server.log as: /usr/sbin/mysqld, Version: 3.23.21-beta-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument But any commands I send to mysql or mysqladmin hangup and nothing ever happens. I then have to kill -9 to force it to stop. So now I manually go in and start it, as root with safe_mysqld. Here's what I get: [root@myserver mysql]# safe_mysqld kill 4212: No such process Starting mysqld daemon with databases from /usr/var/mysql mysqld daemon ended It tries to kill a process, but there is no process in the list! This seems to start it, but then, any commands I send to it just hang the app. If I just try to run mysql from command line I get this: [root@myserver mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) One thing I have to consider is some recent DNS work I did. Is it possible DNS could cause these problems? I'm really at a loss here. Any help is greatly appreciated. Thanks, Jeff - 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
Newbie Starting MySql
Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql, mysql should start up and it does --somewhat. Here's the message I get: [root@myserver mysql]# /etc/rc.d/init.d/mysql start [root@myserver mysql]# Starting mysqld daemon with databases from /usr/var/mysql And it shows up in the process list below... root 5340 0.0 0.3 1668 828 pts/0S21:23 0:00 sh /usr/bin/safe_ mysql 5365 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5366 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld mysql 5367 0.0 0.4 3308 1176 pts/0S21:23 0:00 /usr/sbin/mysqld And it logs it to my /usr/var/mysql/server.log as: /usr/sbin/mysqld, Version: 3.23.21-beta-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument But any commands I send to mysql or mysqladmin hangup and nothing ever happens. I then have to kill -9 to force it to stop. So now I manually go in and start it, as root with safe_mysqld. Here's what I get: [root@myserver mysql]# safe_mysqld kill 4212: No such process Starting mysqld daemon with databases from /usr/var/mysql mysqld daemon ended It tries to kill a process, but there is no process in the list! This seems to start it, but then, any commands I send to it just hang the app. I know that the socket is being created (I've seen the zero K file). If I just try to run mysql from command line I get this: [root@myserver mysql]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) One thing I have to consider is some recent DNS work I did. Is it possible DNS could cause these problems? I'm really at a loss here. Any help is greatly appreciated. Thanks, Jeff - 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