mysql hangs on connection attempt
we are using php to connect to our mysql database and when we call the php function with this line: $dbh = mysql_connect(localhost, george_full, passwd) or die (formatSQLError()); george_full has full priveleges on localhost with his password. localhost resolves to 127.0.0.1 using the host command pinging localhost returns packets as expected the execution of the script terminates. from the command line i've done the following: 1. connected to the database with the same credentials as above 2. selected a database 3. querried the database with appropriate results. i work for a school district and the central office people have just built a new LAN that involved changing the addresses of our dns servers. the servers are behind a NAT, and only their external addresses changed. this is a really tough bug, so any help would be GREATLY appreciated. thanks, steve connec -- Steve Strong Math and Computer Science Washington High School 2205 Forest Dr. SE Cedar Rapids, IA 52403 http://crwash.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql hangs on connection attempt
On 7/18/06, Steve Strong [EMAIL PROTECTED] wrote: we are using php to connect to our mysql database and when we call the php function with this line: $dbh = mysql_connect(localhost, george_full, passwd) or die (formatSQLError()); That's the only line of your .php script? george_full has full priveleges on localhost with his password. localhost resolves to 127.0.0.1 using the host command pinging localhost returns packets as expected the execution of the script terminates. from the command line i've done As expected, if it did not error out, it only connects and returns, simply as that. the following: 1. connected to the database with the same credentials as above 2. selected a database 3. querried the database with appropriate results. If you issue those commands at PHP, would they return? i work for a school district and the central office people have just built a new LAN that involved changing the addresses of our dns servers. the servers are behind a NAT, and only their external addresses changed. this is a really tough bug, so any help would be GREATLY appreciated. Sorry if I did not quite get your question. PHP must connect, then issue a query of some sort, then deal with the resultset, else it will connect, and that's all. Maybe if you post the entire PHP code, along with any error messages... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql hangs on connection attempt
here is the entire function:
function readonlyConnect()
{
$dbh=mysql_connect (localhost, george_readonly, tiWhs!asAt!) or
die (formatSQLError());
mysql_select_db (george_crwash2);
return $dbh;
}
a die() statment before the first line of code in this function echos to
the page, but if the die(); statment is placed after the call to
mysql_connect(), there is nothing printed to the page.
thanks for the help,
steve
On 7/18/06, Steve Strong [EMAIL PROTECTED] wrote:
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect(localhost, george_full, passwd) or die
(formatSQLError());
That's the only line of your .php script?
george_full has full priveleges on localhost with his password.
localhost resolves to 127.0.0.1 using the host command
pinging localhost returns packets as expected
the execution of the script terminates. from the command line i've done
As expected, if it did not error out, it only connects and returns,
simply as that.
the following:
1. connected to the database with the same credentials as above
2. selected a database
3. querried the database with appropriate results.
If you issue those commands at PHP, would they return?
i work for a school district and the central office people have just
built a new LAN that involved changing the addresses of our dns servers.
the servers are behind a NAT, and only their external addresses
changed.
this is a really tough bug, so any help would be GREATLY appreciated.
Sorry if I did not quite get your question. PHP must connect, then
issue a query of some sort, then deal with the resultset, else it will
connect, and that's all. Maybe if you post the entire PHP code, along
with any error messages...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Steve Strong
Math and Computer Science
Washington High School
2205 Forest Dr. SE
Cedar Rapids, IA 52403
http://crwash.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql hangs on connection attempt
Steve Strong wrote: we are using php to connect to our mysql database and when we call the php function with this line: $dbh = mysql_connect(localhost, george_full, passwd) or die (formatSQLError()); george_full has full priveleges on localhost with his password. localhost resolves to 127.0.0.1 using the host command pinging localhost returns packets as expected localhost is for a socket connection. If you want 127.0.0.1 than use 127.0.0.1. the execution of the script terminates. from the command line i've done the following: 1. connected to the database with the same credentials as above 2. selected a database 3. querried the database with appropriate results. i work for a school district and the central office people have just built a new LAN that involved changing the addresses of our dns servers. the servers are behind a NAT, and only their external addresses changed. this is a really tough bug, so any help would be GREATLY appreciated. thanks, steve connec -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL hangs each relative poor time
Roberto Rodriguez Garrido wrote: MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: I don't use Linux myself but I read a post on the Postgres list a while back about the Linux Out-of-memory Process Killer. This needs to be not turned on when you run a database. No clue how to turn this off though, as I said...not using Linux. Johan
MySQL hangs each relative poor time
MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: +-+-+ | Variable_name | Value | +-+-+ | back_log| 50 | | basedir | /usr/ | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8| | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | concurrent_insert | ON | | connect_timeout | 10 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d| | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | expire_logs_days| 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -()~*:| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit| 20 | | ft_stopword_file| (built-in) | | group_concat_max_len| 1024| | have_archive| YES | | have_bdb| NO | | have_compress | YES | | have_crypt | YES | | have_csv| YES | | have_example_engine | NO | | have_geometry | YES | | have_innodb | YES | | have_isam | YES | | have_ndbcluster | DISABLED| | have_openssl| NO | | have_query_cache| YES | | have_raid | YES | | have_rtree_keys | YES | | have_symlink| YES | | init_connect| | | init_file | | | init_slave | | | innodb_additional_mem_pool_size | 1048576 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 8388608 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir| | | innodb_fast_shutdown| ON | | innodb_file_io_threads | 4 | | innodb_file_per_table | OFF | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout| 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 1048576 | | innodb_log_file_size| 5242880 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir
Re: MySQL hangs each relative poor time
Well Roberto, it could be anything... analyzing your my.cnf file and variables would be looking through spagetti (i like spagetti ... but not in this flavour). the time your database hangs, are the intervals random minutes/seconds/hours? or is there a constant interval like precise on 30 minutes the mysql database hangs. perhaps a trial and error method should do the trick? it could be your disk quota? perhaps a process which kills the database? perhaps first run the database using defaults. keep the my.cnf file as small as you can. build a new mysql-version; and run this one, see if it reacts the same as your database. can you tell me the mysql\s values? i am just giving you some hints, to analyse the problem using trial and error. i am sorry i can't give you the full solluton; because too many factors can cause the error. Danny Roberto Rodriguez Garrido wrote: MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: +-+-+ | Variable_name | Value | +-+-+ | back_log| 50 | | basedir | /usr/ | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8| | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | concurrent_insert | ON | | connect_timeout | 10 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d| | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | expire_logs_days| 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -()~*:| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit| 20 | | ft_stopword_file| (built-in) | | group_concat_max_len| 1024| | have_archive| YES | | have_bdb| NO | | have_compress | YES | | have_crypt | YES | | have_csv| YES | | have_example_engine | NO | | have_geometry | YES | | have_innodb | YES | | have_isam | YES | | have_ndbcluster | DISABLED| | have_openssl| NO | | have_query_cache| YES | | have_raid | YES | | have_rtree_keys | YES | | have_symlink| YES | | init_connect| | | init_file | | | init_slave | | | innodb_additional_mem_pool_size | 1048576 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 8388608 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir| | | innodb_fast_shutdown
Re: MySQL hangs each relative poor time
Hello. What system load do 'top' and 'free' show? Use 'SHOW PROCESSLIST' to determine what queries are running on the server if you're able to connect to it. Check that mysqld isn't swapping. Roberto Rodriguez Garrido wrote: MySQL hangs every 30 minutes, it start to make a big process and when I make a show variables I get that values: +-+-+ | Variable_name | Value | +-+-+ | back_log| 50 | | basedir | /usr/ | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8| | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | concurrent_insert | ON | | connect_timeout | 10 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d| | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000| | expire_logs_days| 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -()~*:| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit| 20 | | ft_stopword_file| (built-in) | | group_concat_max_len| 1024| | have_archive| YES | | have_bdb| NO | | have_compress | YES | | have_crypt | YES | | have_csv| YES | | have_example_engine | NO | | have_geometry | YES | | have_innodb | YES | | have_isam | YES | | have_ndbcluster | DISABLED| | have_openssl| NO | | have_query_cache| YES | | have_raid | YES | | have_rtree_keys | YES | | have_symlink| YES | | init_connect| | | init_file | | | init_slave | | | innodb_additional_mem_pool_size | 1048576 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 8388608 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir| | | innodb_fast_shutdown| ON | | innodb_file_io_threads | 4 | | innodb_file_per_table | OFF | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout| 50 | | innodb_locks_unsafe_for_binlog | OFF
Re: /etc/init.d/mysql hangs
On 12/3/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Check if you're able to start server manually using mysqld or mysqld_safe commands. Research error logs. See: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html Thanks. Running mysqld directly showed me the problem which is a full hard disk partition. Timothy
/etc/init.d/mysql hangs
Hi, I'm on Debian system. I tried to modify /etc/mysql/debian-log-rotate to set KEEP-BINARY-LOGS from 0 to 5. After doing so I attempted to let the change register by stopping and restarting the server by running /etc/init.d/mysql stop. However this command hanged. I rebooted the system and but the server wouldn't start (well at least it hangs when i tried /etc/init.d/mysql start) I suspect the problem has nothing to do with the change in KEEP_BINARY_LOGS. What could be the problem? The Mysql version is 4.1.14. Timothy
Re: /etc/init.d/mysql hangs
Hello. Check if you're able to start server manually using mysqld or mysqld_safe commands. Research error logs. See: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html Timothy Wu [EMAIL PROTECTED] wrote: Hi, I'm on Debian system. I tried to modify /etc/mysql/debian-log-rotate to set KEEP-BINARY-LOGS from 0 to 5. After doing so I attempted to let the change register by stopping and restarting the server by running /etc/init.d/mysql stop. However this command hanged. I rebooted the system and but the server wouldn't start (well at least it hangs when i tried /etc/init.d/mysql start) I suspect the problem has nothing to do with the change in KEEP_BINARY_LOGS. What could be the problem? The Mysql version is 4.1.14. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Hangs
Related: http://lists.mysql.com/mysql/44164 No solutions mentioned here. Slack 10.1 is booting and once the newly installed MySQL Standard 4.1.14 starts up with: Starting mysqld daemon with databases from /usr/local/mysql/data The system hangs and is dead to the world. I will need some time to prepare a disk for recovery to get past this inconvenience. Perhaps a hotkey workaround I am unaware of will allow init to skip this standstill? - velusip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Hangs
Velu Shk wrote: Related: http://lists.mysql.com/mysql/44164 No solutions mentioned here. Slack 10.1 is booting and once the newly installed MySQL Standard 4.1.14 starts up with: Starting mysqld daemon with databases from /usr/local/mysql/data The system hangs and is dead to the world. I will need some time to prepare a disk for recovery to get past this inconvenience. Perhaps a hotkey workaround I am unaware of will allow init to skip this standstill? - velusip Velu, If you boot the system into run level 1, you should be able to remove the symlink from the appropriate rc.x directory. Once you've done that, the machine will boot and maybe you can find something in the mysql error log. If you don't see anything there, adding strace to the mysql startup script might give some more info which would be helpful in solving your problem. walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL hangs
Marcin Lewandowski wrote: Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. That's it. phpbb2 is known to consume ressources, if I were you i wouldn't search further... not a mysql issue afaik -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL hangs
Hello. In your file you have lots of threads in Closing_tables state and only seven queries which make updates. Means that the thread is flushing the changed table data to disk and closing the used tables. This should be a fast operation. If not, then you should verify that you don't have a full disk and that the disk is not in very heavy use. Marcin Lewandowski [EMAIL PROTECTED] wrote: Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. Sometimes, server's system load rapidly grows, and mysql are locked. Normally, there are 7-10 mysql processes, at this strange situation, there are 30-40. I don't know what can make such big system load in time of 1 minute. Maybe this could help: http://saepia.net/temp/mysql.txt It's 'show processlist' when mysql is locked. Mysql load is about 50 queries per second. There are mostly myisam tables and they are stored on ide100 drive with dma enabled. Or maybe it's DoS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL hangs
Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. Sometimes, server's system load rapidly grows, and mysql are locked. Normally, there are 7-10 mysql processes, at this strange situation, there are 30-40. I don't know what can make such big system load in time of 1 minute. Maybe this could help: http://saepia.net/temp/mysql.txt It's 'show processlist' when mysql is locked. Mysql load is about 50 queries per second. There are mostly myisam tables and they are stored on ide100 drive with dma enabled. Or maybe it's DoS? -- m. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Hangs
Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. Sometimes, server's system load rapidly grows, and mysql are locked. Normally, there are 7-10 mysql processes, at this strange situation, there are 30-40. I don't know what can make such big system load in time of 1 minute. Maybe this could help: http://saepia.net/temp/mysql.txt It's 'show processlist' when mysql is locked. Mysql load is about 50 queries per second. There are mostly myisam tables and they are stored on ide100 drive with dma enabled. Or maybe it's DoS? -- m. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql Hangs
Hi We have been having problems with a MySql database that runs on Linux.It just occurred suddenly and was working fine before Details: MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma The filesystems which are accessed by MySql just hang.We cannot access any of the tables.All clients just hang.When we Shutdown the server, it hangs again.The Mysql deamons wont get killed even if I use the kill -9 command.After a reboot Everything works fine for sometime and then goes bad again.The problem seems to be that mysql seems to have a lock on all the tables and hence the use database,select,update hangs.All of the Mysql configuration is with default options. Has anyone encountered a similar problem with the 4.1.6-gamma version?? Thanks Ajay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Hangs
Ajay, Could you send the error messages (.err file in the mysql dir) and your my.cnf file? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Hangs
Are you data files on a local filesystem? When this issue occurs can you access any regular files on the drive? Ajay Kalambur wrote: Hi We have been having problems with a MySql database that runs on Linux.It just occurred suddenly and was working fine before Details: MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma The filesystems which are accessed by MySql just hang.We cannot access any of the tables.All clients just hang.When we Shutdown the server, it hangs again.The Mysql deamons wont get killed even if I use the kill -9 command.After a reboot Everything works fine for sometime and then goes bad again.The problem seems to be that mysql seems to have a lock on all the tables and hence the use database,select,update hangs.All of the Mysql configuration is with default options. Has anyone encountered a similar problem with the 4.1.6-gamma version?? Thanks Ajay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Hangs
Ajay Kalambur wrote: Hi We have been having problems with a MySql database that runs on Linux.It just occurred suddenly and was working fine before Details: MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma The filesystems which are accessed by MySql just hang.We cannot access any of the tables.All clients just hang.When we Shutdown the server, it hangs again.The Mysql deamons wont get killed even if I use the kill -9 command.After a reboot Everything works fine for sometime and then goes bad again.The problem seems to be that mysql seems to have a lock on all the tables and hence the use database,select,update hangs.All of the Mysql configuration is with default options. Has anyone encountered a similar problem with the 4.1.6-gamma version?? Thanks Ajay Next time it hangs, check your disk space, especially your tmp directory. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL hangs after some days
Hello, since I moved to another dedicated server 1-2 months ago I'm experiencing big problems with mysql. Normally the server works fine for a website under heavy load but after a week or so it hangs in a locked table forever and thus preventig other processes to access it. Then I have to shut down the (mysql-)server, kill -9 safe_mysql and another mysql process (probably the one with the table lock) and run myisamchk -r *.MYI, then restart the server. The biggest table has currently 1160768 rows in it - don't know if this matters. The mysql server is busy most of the time doing simple SELECTS and also does many INSERTs and UPDATEs. However the server hangs on a INSERT or UPDATE query. I also had running a query log for a while (also when the server crashed) but it's hard to find useful information in there. Some information about the system: Red Hat 9 (Shrike) Linux 2.4.20-28.9 #1 Thu Dec 18 13:46:42 EST 2003 i686 athlon i386 GNU/Linux mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) Athlon 1.5Ghz (or so), 512MB RAM HDD 28% used What should I do? I already tried to find an answer asking Google but couldn't find the solution... Thanks, Udo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL hangs after some days
[EMAIL PROTECTED] wrote: Hello, since I moved to another dedicated server 1-2 months ago I'm experiencing big problems with mysql. Normally the server works fine for a website under heavy load but after a week or so it hangs in a locked table forever and thus preventig other processes to access it. Then I have to shut down the (mysql-)server, kill -9 safe_mysql and another mysql process (probably the one with the table lock) and run myisamchk -r *.MYI, then restart the server. The biggest table has currently 1160768 rows in it - don't know if this matters. The mysql server is busy most of the time doing simple SELECTS and also does many INSERTs and UPDATEs. However the server hangs on a INSERT or UPDATE query. I also had running a query log for a while (also when the server crashed) but it's hard to find useful information in there. Some information about the system: Red Hat 9 (Shrike) Linux 2.4.20-28.9 #1 Thu Dec 18 13:46:42 EST 2003 i686 athlon i386 GNU/Linux mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) Athlon 1.5Ghz (or so), 512MB RAM HDD 28% used What should I do? I already tried to find an answer asking Google but couldn't find the solution... Try replacing the kernel with the one from kernel.org, replacing the binary with the one from mysql.com, and adding some RAM or swap. All three are good things to do, and one of them might fix the problem. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql hangs on multi table update on innodb table.
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat :
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT PRIMARY KEY, parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE
ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id=1;
insert into child set id=1, parent_id=1;
update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1;
Thank you for your time.
Scott Wong,
Meiko America, INC
Hi!
Thank you for your bug report.
It helped us fix a bug in multi-table updates with InnoDB. A fix will
come in 4.0.12, which should come out in a week.
This is a patch:
= sql/sql_class.h 1.141 vs edited =
*** /tmp/sql_class.h-1.141-18011Wed Mar 5 19:43:53 2003
--- edited/sql/sql_class.h Tue Mar 11 18:34:13 2003
***
*** 831,837
uint table_count;
Copy_field *copy_field;
enum enum_duplicates handle_duplicates;
! bool do_update, trans_safe, transactional_tables, log_delayed;
public:
multi_update(THD *thd_arg, TABLE_LIST *ut, ListItem *fields,
--- 831,837
uint table_count;
Copy_field *copy_field;
enum enum_duplicates handle_duplicates;
! bool do_update, trans_safe, transactional_tables, log_delayed, on_the_fly;
public:
multi_update(THD *thd_arg, TABLE_LIST *ut, ListItem *fields,
= sql/sql_update.cc 1.75 vs edited =
*** /tmp/sql_update.cc-1.75-18011 Wed Feb 19 16:08:27 2003
--- edited/sql/sql_update.ccTue Mar 11 18:59:11 2003
***
*** 413,419
:all_tables(table_list), update_tables(0), thd(thd_arg), tmp_tables(0),
updated(0), found(0), fields(field_list), values(value_list),
table_count(0), copy_field(0), handle_duplicates(handle_duplicates_arg),
!do_update(1), trans_safe(0)
{}
--- 413,419
:all_tables(table_list), update_tables(0), thd(thd_arg), tmp_tables(0),
updated(0), found(0), fields(field_list), values(value_list),
table_count(0), copy_field(0), handle_duplicates(handle_duplicates_arg),
!do_update(1), trans_safe(0), on_the_fly(1)
{}
***
*** 538,549
main_table=join-join_tab-table;
trans_safe= transactional_tables= main_table-file-has_transactions();
log_delayed= trans_safe || main_table-tmp_table != NO_TMP_TABLE;
!
/* Create a temporary table for all tables after except main table */
for (table_ref= update_tables; table_ref; table_ref=table_ref-next)
{
TABLE *table=table_ref-table;
! if (table != main_table)
{
uint cnt= table_ref-shared;
ORDER group;
--- 538,552
main_table=join-join_tab-table;
trans_safe= transactional_tables= main_table-file-has_transactions();
log_delayed= trans_safe || main_table-tmp_table != NO_TMP_TABLE;
! #ifdef HAVE_INNOBASE_DB
! if (main_table-db_type == DB_TYPE_INNODB)
! on_the_fly=0;
! #endif
/* Create a temporary table for all tables after except main table */
for (table_ref= update_tables; table_ref; table_ref=table_ref-next)
{
TABLE *table=table_ref-table;
! if (!on_the_fly || table != main_table)
{
uint cnt= table_ref-shared;
ORDER group;
***
*** 623,629
uint offset= cur_table-shared;
table-file-position(table-record[0]);
! if (table == main_table)
{
table-status|= STATUS_UPDATED;
store_record(table,1);
--- 626,632
uint offset= cur_table-shared;
table-file-position(table-record[0]);
! if (on_the_fly table == main_table)
{
table-status|= STATUS_UPDATED;
store_record(table,1);
***
*** 716,722
for (cur_table= update_tables; cur_table ; cur_table= cur_table-next)
{
table = cur_table-table;
! if (table == main_table)
continue; // Already updated
org_updated= updated;
--- 719,725
for (cur_table= update_tables; cur_table ; cur_table= cur_table-next)
{
table = cur_table-table;
! if (on_the_fly table == main_table)
continue; // Already updated
org_updated= updated;
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
RE: Mysql hangs on multi table update on innodb table.
Hi, I havent received any response on this so i'll send this again. I did check again with 4.0.11-gamma and the problem is still there. Regards, Scott Version: Mysql 4.0.10-gamma Description: Mysql hangs and possibly can not recover from a query on an innodb table. How to Repeat : drop table if exists parent; drop table if exists child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT PRIMARY KEY, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=INNODB; insert into parent set id=1; insert into child set id=1, parent_id=1; update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1; Thank you for your time. Scott Wong, Meiko America, INC - 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: Mysql hangs on multi table update on innodb table.
Scott Wong writes: Hi, I havent received any response on this so i'll send this again. I did check again with 4.0.11-gamma and the problem is still there. Regards, Scott Hi! This will require a major re-write in multi table update's and will not come up very soon. But should come up with the end of this month. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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 hangs on multi table update on innodb table.
Version: Mysql 4.0.10-gamma Description: Mysql hangs and possibly can not recover from a query on an innodb table. How to Repeat : drop table if exists parent; drop table if exists child; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT PRIMARY KEY, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=INNODB; insert into parent set id=1; insert into child set id=1, parent_id=1; update parent,child set parent.id=parent.id+1, child.parent_id=parent.id+1; Thank you for your time. Scott Wong, Meiko America, INC - 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 hangs on remote connections
I'm having a rather bizarre problem...at least, it seems bizarre to me. We have a small MySQL database that was running great for about a month. Last night, I rebooted the system it runs on. Now I can connect locally, but remote connections fail. The server disconnects during the query and I get the following in the error log: Number of processes running now: 1 mysqld process hanging, pid 17308 - killed 021127 08:58:51 mysqld restarted /usr/libexec/mysqld: ready for connections The MySQL version is 3.23.32, and the OS is RedHat Linux 7.0. The only change I can think of that's been made is the RedHat glibc update to fix the name resolver security hole was done, and mysql wasn't restarted until now, so it would have been running on the old glibc until the reboot. I checked all the tables with myisamchk and they're okay. Any ideas? -- David Brodbeck, System Administrator InterClean Equipment, Inc. Ypsilanti, Michigan [EMAIL PROTECTED] (734) 975-2967 x221 - 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: MySQL hangs on remote connections
Never mind, I found the answer to my own question when I got the archive search engine to respond. (It's *very* slow from here, for some reason -- about 10 minutes per query.) I installed a newer version of the glibc fix and all is well now. Sorry for wasting everyone's time. -Original Message- From: David Brodbeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 9:09 AM To: '[EMAIL PROTECTED]' Subject: MySQL hangs on remote connections I'm having a rather bizarre problem...at least, it seems bizarre to me. We have a small MySQL database that was running great for about a month. Last night, I rebooted the system it runs on. Now I can connect locally, but remote connections fail. - 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: mysql hangs, restarts on odbc connect
Sage, Wednesday, November 06, 2002, 3:31:21 PM, you wrote: S I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel S (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 S gHz. S MySQL works perfectly fine when connecting from the localhost. However, S I have another machine that needs to connect via ODBC. The ODBC client S can connect, but as soon as it does, the connection is suddenly closed. S The same thing happens if I try to telnet to port 3306 on the host S machine. S Every time this happens, I find the following entry in mysqld.log: S Number of processes running now: 1 S mysqld process hanging, pid 906 - killed S 021106 15:51:41 mysqld restarted S /usr/libexec/mysqld: ready for connections S I have no idea what is causing this. Does anyone have any suggestions as S to what might be the cause, or at least what I should double-check? Your problem is described here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 You can downgrade glibc or install the patched one or install MySQL server v3.23.53a -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: mysql hangs, restarts on odbc connect
Thank you, Egor! It looks like Red Hat released an update to its glibc libraries yesterday which fix this, so if anybody else is having problems, they should be able to fix it by updating. :) Sage On Thu, 2002-11-07 at 17:46, Egor Egorov wrote: Sage, Wednesday, November 06, 2002, 3:31:21 PM, you wrote: S I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel S (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 S gHz. S MySQL works perfectly fine when connecting from the localhost. However, S I have another machine that needs to connect via ODBC. The ODBC client S can connect, but as soon as it does, the connection is suddenly closed. S The same thing happens if I try to telnet to port 3306 on the host S machine. S Every time this happens, I find the following entry in mysqld.log: S Number of processes running now: 1 S mysqld process hanging, pid 906 - killed S 021106 15:51:41 mysqld restarted S /usr/libexec/mysqld: ready for connections S I have no idea what is causing this. Does anyone have any suggestions as S to what might be the cause, or at least what I should double-check? Your problem is described here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 You can downgrade glibc or install the patched one or install MySQL server v3.23.53a -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
mysql hangs, restarts on odbc connect
I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 gHz. MySQL works perfectly fine when connecting from the localhost. However, I have another machine that needs to connect via ODBC. The ODBC client can connect, but as soon as it does, the connection is suddenly closed. The same thing happens if I try to telnet to port 3306 on the host machine. Every time this happens, I find the following entry in mysqld.log: Number of processes running now: 1 mysqld process hanging, pid 906 - killed 021106 15:51:41 mysqld restarted /usr/libexec/mysqld: ready for connections I have no idea what is causing this. Does anyone have any suggestions as to what might be the cause, or at least what I should double-check? - 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 hangs unexpedtedly
Hi. These last days, after some months of running relatively smoothly, I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it just goes astray and virtually hangs. Load goes up to +200%, all connections are occupied and it just doesn't do anything. The only way to stop it is to killall -9 mysql because a mysqladmin shutdown won't do. Looking though the error file I get this: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, [...] key_buffer_size=402649088 record_buffer=8384512 sort_buffer=33554424 max_used_connections=352 max_connections=400 threads_connected=287 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4192696 K bytes of memory Hope that's ok, if not, decrease some variables in the equation (Is it ok? Box is a Dual 1Ghz, 1Gb ram, Linux 2.4.16 dedicated only to MySQL) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806ede4 0x8120148 0x814ba77 0x80a147f 0x807561a 0x8073f97 [...] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=1733 Everytime the box hangs I get the same stack backtrace, I have resolved it and it's: 0x806ede4 pack__12Field_stringPcPCcUi + 20 0x8120148 regatoi + 8 0x814ba6f __printf_fp + 5719 0x80a147f join_read_const__FP13st_join_table + 35 0x807561a push_front__t4List1Z3KeyP3Key + 18 0x8073f97 prepare__13select_exportRt4List1Z4Item + 443 ...but when I try to find the thread that caused it (1733 in this case) in the binary log it doesn't appear so I'm unable to determine what's causing the error. I thought at first that it could be a load peak issue, but this error is from today at 6am, and this isn't a busy hour. Everytime I get this i run myisamchk -r *.MYI. It seems that after some time (+30 minutes usually) mysql restarts and starts running again. Any thoughts on this? Anything I can do to resolve it? Thanks. -- L - 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: MySQL hangs unexpedtedly
Hardware? Operating System and version? MySql version? Precompiled, you compiled? Which compiler? [EMAIL PROTECTED] wrote: Hi. These last days, after some months of running relatively smoothly, I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it just goes astray and virtually hangs. Load goes up to +200%, all connections are occupied and it just doesn't do anything. The only way to stop it is to killall -9 mysql because a mysqladmin shutdown won't do. Looking though the error file I get this: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, [...] key_buffer_size=402649088 record_buffer=8384512 sort_buffer=33554424 max_used_connections=352 max_connections=400 threads_connected=287 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4192696 K bytes of memory Hope that's ok, if not, decrease some variables in the equation (Is it ok? Box is a Dual 1Ghz, 1Gb ram, Linux 2.4.16 dedicated only to MySQL) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806ede4 0x8120148 0x814ba77 0x80a147f 0x807561a 0x8073f97 [...] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=1733 Everytime the box hangs I get the same stack backtrace, I have resolved it and it's: 0x806ede4 pack__12Field_stringPcPCcUi + 20 0x8120148 regatoi + 8 0x814ba6f __printf_fp + 5719 0x80a147f join_read_const__FP13st_join_table + 35 0x807561a push_front__t4List1Z3KeyP3Key + 18 0x8073f97 prepare__13select_exportRt4List1Z4Item + 443 ...but when I try to find the thread that caused it (1733 in this case) in the binary log it doesn't appear so I'm unable to determine what's causing the error. I thought at first that it could be a load peak issue, but this error is from today at 6am, and this isn't a busy hour. Everytime I get this i run myisamchk -r *.MYI. It seems that after some time (+30 minutes usually) mysql restarts and starts running again. Any thoughts on this? Anything I can do to resolve it? Thanks. -- L - 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: MySQL hangs unexpedtedly
Hardware? Operating System and version? MySql version? Precompiled, you compiled? Which compiler? Intel Dual 1Ghz, 1Gb RAM, RedHat Linux 6.2, kernel 2.4.16, MySQL 3.23.52 from rpms (happened the same with 3.23.46). As I said before, this only happens the last few days, we were running for almost a year without much problems. Anyone can explain/understand the stack trace? Cheers -- L [EMAIL PROTECTED] wrote: Hi. These last days, after some months of running relatively smoothly, I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it just goes astray and virtually hangs. Load goes up to +200%, all connections are occupied and it just doesn't do anything. The only way to stop it is to killall -9 mysql because a mysqladmin shutdown won't do. Looking though the error file I get this: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, [...] key_buffer_size=402649088 record_buffer=8384512 sort_buffer=33554424 max_used_connections=352 max_connections=400 threads_connected=287 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 4192696 K bytes of memory Hope that's ok, if not, decrease some variables in the equation (Is it ok? Box is a Dual 1Ghz, 1Gb ram, Linux 2.4.16 dedicated only to MySQL) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x806ede4 0x8120148 0x814ba77 0x80a147f 0x807561a 0x8073f97 [...] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=1733 Everytime the box hangs I get the same stack backtrace, I have resolved it and it's: 0x806ede4 pack__12Field_stringPcPCcUi + 20 0x8120148 regatoi + 8 0x814ba6f __printf_fp + 5719 0x80a147f join_read_const__FP13st_join_table + 35 0x807561a push_front__t4List1Z3KeyP3Key + 18 0x8073f97 prepare__13select_exportRt4List1Z4Item + 443 ...but when I try to find the thread that caused it (1733 in this case) in the binary log it doesn't appear so I'm unable to determine what's causing the error. I thought at first that it could be a load peak issue, but this error is from today at 6am, and this isn't a busy hour. Everytime I get this i run myisamchk -r *.MYI. It seems that after some time (+30 minutes usually) mysql restarts and starts running again. - 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 hangs on HP-UX 11.00 under medium load
Here's my problem: I've just installed mysql version 3.23.51 (before this one I tried 3.23.49) compiled from scratch with: CFLAGS=-fomit-frame-pointer -O3 -fPIC ./configure --prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql --with-debug It compiles and runs fine, but fails as soon as I use a script to load it up a bit. The script itself just opens a database connection, than does a select * FROM $table1 s,$table2 t where the two tables are choosen randomly (some of the tables are quite big), then repeats this with another (not cached) connection. The script runs on another machine. If I leave the script running it hangs mysql db in , say, 20 minutes. If I launch simultaneously 20 such scripts 3 minutes are enough. By mysql hangs I mean that there's no way to connect to get a processlist or a debug, and the scripts remain blocked. If I stop the scripts and I wait some time (2 minutes) everything seems to come back to normality. Is there anyone who uses mysql on HP-UX under heavy load that can give me a hint? Thanks. -- - .a.c. - Andrea Carpani - [EMAIL PROTECTED] http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) ___ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. ___ - 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: Mysql hangs on HP-UX 11.00 under medium load
Pada 23 Jul 2002 12:11:18 +0200 Andrea Carpani [EMAIL PROTECTED] menulis : select * FROM $table1 s,$table2 t where the two tables are choosen randomly (some of the tables are quite big), then repeats this with another (not cached) connection. The script runs on another machine. If I leave the script running it hangs mysql db in , say, 20 minutes. If I launch simultaneously 20 such scripts 3 minutes are enough. By mysql hangs I mean that there's no way to connect to get a processlist or a debug, and the scripts remain blocked. If I stop the scripts and I wait some time (2 minutes) everything seems to come back to normality. Is there anyone who uses mysql on HP-UX under heavy load that can give me a hint? I think the proper word for your case is mysql busy not hang. you should check from your system (OS) side the cpu usage of mysql where the query is running and you should also use tools like mtop or mytop to monitor what happens during the query inside mysql server. My opinion is a matter of query or table design ... not mysql application / OS ;-) -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan Plaugher) MySQL 3.23.51 : up 32 days, Queries : 354.126 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - 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: Mysql hangs on HP-UX 11.00 under medium load
20 simultaneous cartesian products on large tables would be expected to make any sql server busy, not to mention use a lot of temporary disk space. Are you sure you are not running out of disk space? Andrea Carpani wrote: Here's my problem: I've just installed mysql version 3.23.51 (before this one I tried 3.23.49) compiled from scratch with: CFLAGS=-fomit-frame-pointer -O3 -fPIC ./configure --prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql --with-debug It compiles and runs fine, but fails as soon as I use a script to load it up a bit. The script itself just opens a database connection, than does a select * FROM $table1 s,$table2 t where the two tables are choosen randomly (some of the tables are quite big), then repeats this with another (not cached) connection. The script runs on another machine. If I leave the script running it hangs mysql db in , say, 20 minutes. If I launch simultaneously 20 such scripts 3 minutes are enough. By mysql hangs I mean that there's no way to connect to get a processlist or a debug, and the scripts remain blocked. If I stop the scripts and I wait some time (2 minutes) everything seems to come back to normality. Is there anyone who uses mysql on HP-UX under heavy load that can give me a hint? Thanks. - 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: Mysql hangs on HP-UX 11.00 under medium load
On Tue, 2002-07-23 at 15:27, Gerald Clark wrote: 20 simultaneous cartesian products on large tables would be expected to make any sql server busy, not to mention use a lot of temporary disk space. Are you sure you are not running out of disk space? No, there's enough disk space and memory, but I do agree that this slowdown can be acceptable. This stress testing came out as I had to debug another problem: a simple select made with a java program through jdbc repeated 20 + times (less than 30) gets me the following error: error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' At first I thought this was a thread problem so I decided to stress the db a little, but the java program is very simple. Anyone has ever seen this error ? -- - .a.c. - Andrea Carpani - [EMAIL PROTECTED] http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) ___ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. ___ - 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: Mysql hangs on HP-UX 11.00 under medium load
On Tue, 2002-07-23 at 12:28, Dicky Wahyu Purnomo wrote: I think the proper word for your case is mysql busy not hang. you should check from your system (OS) side the cpu usage of mysql where the query is running When the problem arises both cpu's (client and server) are 2% busy and there's no system activity. Sometimes, but not always (so I cannot know if it's related) the following error comes up when a client tries to connect: error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' When this happens the only way out is to reboot mysql. and you should also use tools like mtop or mytop to monitor what happens during the query inside mysql server. My opinion is a matter of query or table design ... not mysql application / OS ;-) -- - .a.c. - Andrea Carpani - [EMAIL PROTECTED] http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) ___ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. ___ Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - 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 -- - .a.c. - Andrea Carpani - [EMAIL PROTECTED] http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) ___ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. ___ - 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: Mysql hangs on HP-UX 11.00 under medium load
Pada 23 Jul 2002 15:40:17 +0200 Andrea Carpani [EMAIL PROTECTED] menulis : error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' well, if this the case try to run : mysqladmin -p processlist or mysqladmin -p status look at the number of thread and from processlist, you should find what queries to which tables that mostly you found during heavy load. it's the limitation of thread creation ... -- printk(??? No FDIV bug? Lucky you...\n); 2.2.16 /usr/src/linux/include/asm-i386/bugs.h MySQL 3.23.51 : up 32 days, Queries : 354.631 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone : +62 21 79199577 - Web : http://1rstwap.com - 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 hangs on HP-UX 11.00 if queried through jdbc (bug ?)
After a hard day of work I think I managed to isolate the problem which looks a lot like a bug: server: mysql-3.23.51 compiled with: CFLAGS=-fomit-frame-pointer -O3 -fPIC ./configure --prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql --with-debug os: HP-UX 11.00 I have a small java program that connects to the server and does a simple select on a table: the program uses the jdbc driver for mysql and poolman that provides a connection pool mechanism (the connection should be reused): after a variable number of connections (usually between 20 and 60) the server stops answering with the following error: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug at /usr/local/vscript/manu/test_conn_db.pl If I stop the script the resources become again available and everything seems fine. I've tested the same script with a linux bound server an everything works fine. -- - .a.c. - Andrea Carpani - [EMAIL PROTECTED] http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) ___ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. ___ - 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 hangs on reqular SQL-query
Hi all, I have a problem with a table in the database. I created it a while ago (a month maby) and then everything worked fine. Now however, every time I query the table the query hangs and I don't know why. I understand that it's difficult to tell me what the problem is based on that little information. But could someone tell me where I should start looking? Can I give some more information about the table, query or database that would help tracing the problem? My mysql version: Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) This is the table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); FOR_SALE has about 20 rows. These are the processes: mysql SHOW PROCESSLIST; +-+-+---+-+-+--+---+---+ | Id | User| Host | db | Command | Time | State | Info | +-+-+---+-+-+--+---+ ---+ | 5393322 | jacob | localhost | jacob | Query | 564 | Waiting for table | Select count(*) from FOR_SALE | | 5394177 | jacob | localhost | jacob | Query | 0| NULL | SHOW PROCESSLIST | +-+-+---+-+-+--+---+ ---+ 2 rows in set (0.00 sec) I've been using the mysql db for almost 2 years now and this thing has never happened before. Please help me finding the problem. Thanks, Jacob _ Chatta med vänner online, prova MSN Messenger: http://messenger.msn.se - 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 hangs on reqular SQL-query #2
Hi again, Little more information about the problem that I wrote about in my last email. As I said before, the database wont accept any query to that table. It just hangs. However I'm not sure of which query that is executed the first time the table hangs. I'm not sure if this matters. But if it do I might be able to find out. Thanks, Jacob _ MSN Photos är det enklaste sättet att dela ut och skriva ut foton: http://photos.msn.se/Support/WorldWide.aspx - 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 hangs on reqular SQL-query
Hi, I have this table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); When I execute this query: SELECT count(*) FROM FOR_SALE nothing happens. No error message and no promt. The query just hangs. The above query used to work fine. mysql SHOW PROCESSLIST; +-+-+---+-+-+--+---+---+ | Id | User| Host | db | Command | Time | State | Info | +-+-+---+-+-+--+---+ ---+ | 5393322 | jacob | localhost | jacob | Query | 564 | Waiting for table | Select count(*) from FOR_SALE | | 5394177 | jacob | localhost | jacob | Query | 0| NULL | SHOW PROCESSLIST | +-+-+---+-+-+--+---+ ---+ 2 rows in set (0.00 sec) If I create a new table the query works! It seems as if the table is corrupted in some way. I think the table maby have about 20 columns. Anyone have any ideas about this? Thanks, Jacob _ MSN Photos är det enklaste sättet att dela ut och skriva ut foton: http://photos.msn.se/Support/WorldWide.aspx - 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 hangs on ANALYZE, open
Description: mysqld still seems to hang when nightly table checks are running. Formerly, this seemed to be due to a race condition that was hopefully fixed in 3.23.46. Server is up, but all queries are stuck in opening tables. mysqld is taking 100% of one CPU. pstack and other debugging sent under additional cover. Database shutdown hung, and database was ultimately killed with kill -KILL. Tables were all marked as closed, though! How-To-Repeat: Run analyze table on all tables while other activity is occuring in database (particularly connect/disconnects). Fix: Analyze temporarily disabled. However, several large join tables which are updated nightly need to have analyze run as part of batch stream. Submitter-Id: Support #297 Originator:David Birnbaum Organization: MySQL support: extended Synopsis: mysql stuck on analyze Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Environment: System: SunOS fosters 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /opt/gcc/3.0.1/lib/gcc-lib/sparc-sun-solaris2.8/3.0.1/specs Configured with: ../3.0.1/configure --prefix=/opt/gcc/3.0.1 Thread model: posix gcc version 3.0.1 Compilation info: CC='/opt/gcc/2.95.2/bin/gcc' CFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa' CXX='/opt/gcc/2.95.2/bin/g++' CXXFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Mar 31 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Mar 31 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/opt/mysql/3.23.46 --with-berkeley-db --with-innobase --localstatedir=/export/DB/mysqldb --with-unix-socket-path=/var/tmp/mysql.sock - 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: mysql hangs on ANALYZE, open
David Birnbaum writes: Description: mysqld still seems to hang when nightly table checks are running. Formerly, this seemed to be due to a race condition that was hopefully fixed in 3.23.46. Server is up, but all queries are stuck in opening tables. mysqld is taking 100% of one CPU. pstack and other debugging sent under additional cover. Database shutdown hung, and database was ultimately killed with kill -KILL. Tables were all marked as closed, though! Hi! Yes, race condition in ANALYZE was fixed in 3.23.46. But then, you do not have to run ANALYZE more then once, so there is no need to run it in the nightly cron jobs. Please, try using our binary as building with GNU 3.0.* will always have libstdc++ linked in. We do not know yet of what problems this could incur, but it is better to be on the safe side. In MySQL 4.0.* we have found a way to circumvent linking in libstdc++, so that now we can set gcc both as CC and as CXX. Also, please check that you run MySQL with --skip-locking enabled. If --skip-locking is not enabled that could be a cause of described behaviour. Another cause of the behaviour could be a patch level of your 2.8. Please make sure that it has all Sun's suggested patches applied. A behaviour you described above looks most like some thread issue. It is known that C++ exceptions do not work well with multiple threads and it is also unfortunately true that with GNU 3.0.* some code from libsupc++ (part of libstdtc++), which contains C++ exceptions, gets linked in. That is why, once again, we ask you to try our binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
REPOST: mysql hangs on shutdown
Hi, I recently installed in MySql from binary distribution mysql- max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the database runs and performs fine but it refuses to shutdown short of a 'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and killing the safe_mysql and then the 'parent' (earliest started) mysql process but this only works with 'kill -9' on these processes. If I do a simple kill without forcing it (-9) then the processes hang -- will not respond to mysql, mysqladmin or telnet. I'm running on Red Hat Linux release 5.2 (Apollo), kernel 2.0.36. Formerly we ran mysql-3.22.20a.tar.gz (source distribution) on this same box without problems. Here is a sample of the latest err log: 010521 15:28:53 mysqld started 010521 15:28:53 Warning: setrlimit couldn't increase number of open files to more than 256 010521 15:28:53 Warning: Changed limits: max_connections: 100 table_cache: 73 Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/local/mysql/bin/mysqld: ready for connections 010521 15:41:15 Aborted connection 7 to db: 'test' user: 'root' host: `localhost' (Got an error reading communication packets) 010521 15:41:51 Aborted connection 10 to db: 'unconnected' user: 'root' host: `localhost' (Got an error writing communication packets) 010521 15:41:51 /usr/local/mysql/bin/mysqld: Normal shutdown The communication errors only appear on shutdowns. I am able to connect via mysqladmin and mysql and run SQL queries and create database schemas from SQL scripts, etc. thanks for any help. t [EMAIL PROTECTED] Synchronis LLC 4223 Glencoe Avenue, Suite B103 Marina del Rey, CA 90292-5694 www.synchronis.com direct 310.305.8900 fax 310.305.8860 - 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 hangs on shutdown
Hi, I recently installed in MySql from binary distribution mysql- max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the database runs and performs fine but it refuses to shutdown short of a 'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and killing the safe_mysql and then the 'parent' (earliest started) mysql process but this only works with 'kill -9' on these processes. If I do a simple kill without forcing it (-9) then the processes hang -- will not respond to mysql, mysqladmin or telnet. I'm running on Red Hat Linux release 5.2 (Apollo), kernel 2.0.36. Formerly we ran mysql-3.22.20a.tar.gz (source distribution) on this same box without problems. Here is a sample of the latest err log: 010521 15:28:53 mysqld started 010521 15:28:53 Warning: setrlimit couldn't increase number of open files to more than 256 010521 15:28:53 Warning: Changed limits: max_connections: 100 table_cache: 73 Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/local/mysql/bin/mysqld: ready for connections 010521 15:41:15 Aborted connection 7 to db: 'test' user: 'root' host: `localhost' (Got an error reading communication packets) 010521 15:41:51 Aborted connection 10 to db: 'unconnected' user: 'root' host: `localhost' (Got an error writing communication packets) 010521 15:41:51 /usr/local/mysql/bin/mysqld: Normal shutdown The communication errors only appear on shutdowns. I am able to connect via mysqladmin and mysql and run SQL queries and create database schemas from SQL scripts, etc. thanks for any help. t [EMAIL PROTECTED] Synchronis LLC 4223 Glencoe Avenue, Suite B103 Marina del Rey, CA 90292-5694 www.synchronis.com direct 310.305.8900 fax 310.305.8860 - 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 hangs on shutdown
Hi, I recently installed in MySql from binary distribution mysql- max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the database runs and performs fine but it refuses to shutdown short of a 'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and killing the safe_mysql and then the 'parent' (earliest started) mysql process but this only works with 'kill -9' on these processes. If I do a simple kill without forcing it (-9) then the processes hang -- will not respond to mysql, mysqladmin or telnet. I'm running on Red Hat Linux release 5.2 (Apollo), kernel 2.0.36. Formerly we ran mysql-3.22.20a.tar.gz (source distribution) on this same box without problems. Here is a sample of the latest err log: 010521 15:28:53 mysqld started 010521 15:28:53 Warning: setrlimit couldn't increase number of open files to more than 256 010521 15:28:53 Warning: Changed limits: max_connections: 100 table_cache: 73 Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/local/mysql/bin/mysqld: ready for connections 010521 15:41:15 Aborted connection 7 to db: 'test' user: 'root' host: `localhost' (Got an error reading communication packets) 010521 15:41:51 Aborted connection 10 to db: 'unconnected' user: 'root' host: `localhost' (Got an error writing communication packets) 010521 15:41:51 /usr/local/mysql/bin/mysqld: Normal shutdown The communication errors only appear on shutdowns. I am able to connect via mysqladmin and mysql and run SQL queries and create database schemas from SQL scripts, etc. thanks for any help. t [EMAIL PROTECTED] Synchronis LLC 4223 Glencoe Avenue, Suite B103 Marina del Rey, CA 90292-5694 www.synchronis.com direct 310.305.8900 fax 310.305.8860 - 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 Hangs with Status 'D'
I have been having repeated problems with mySQL 3.23.36 on Linux (Red Hat 6.0, 2.4.3 kernel). I think I've got traced the problem but I don't know how to fix it... At some point after being started one or more of the mySQL threads hang with the ps status of 'D' (my research suggests this can mean something disk related or not). At that point mySQL is totally hung. It won't respond to new connections, thus basically hanging all my Apache sites that use it. Trying to launch 'mysqladmin' just hangs forever trying to connect. The only solution is a restart. Processes with status 'D' cannot be killed. What can I do about this? I've had to restart this server twice today and it's a production Web server. Not fun. Any help is GREATLY appreciated. Hunter - 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: mySQL Hangs with Status 'D'
Upgrade to 2.4.4. 2.4.3 had some rwsem issues. -- Vibol Hou KhmerConnection http://khmer.cc -Original Message- From: Hunter Hillegas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 2:20 PM To: mySQL List Subject: mySQL Hangs with Status 'D' I have been having repeated problems with mySQL 3.23.36 on Linux (Red Hat 6.0, 2.4.3 kernel). I think I've got traced the problem but I don't know how to fix it... At some point after being started one or more of the mySQL threads hang with the ps status of 'D' (my research suggests this can mean something disk related or not). At that point mySQL is totally hung. It won't respond to new connections, thus basically hanging all my Apache sites that use it. Trying to launch 'mysqladmin' just hangs forever trying to connect. The only solution is a restart. Processes with status 'D' cannot be killed. What can I do about this? I've had to restart this server twice today and it's a production Web server. Not fun. Any help is GREATLY appreciated. Hunter - 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: mysql hangs on client start (and mysql_install_db)
Check permissions. The var directory anad all subdirectories and files must be accessible by the user under which MySQL runs. The directory containing the mysql.lock file must be readable and searchable by everyone. Drew Degentesh wrote: Description: mysql hangs. This is really frustrating. History: -had 3.23.27 running. Had to restart the machine. -on reboot, no clients would connect (command line , Perl or PHP) -tried to restart by rc.d/initd/mysql stop, that timed out -killed off processes with kill -9 -tried to restart, clients still hanging -downlaoded 3.23.32 binary. hung up in mysql_install_db after printing "installing all prepared tables" -killed those processes off..s.tarted with safe_mysqld ... -clients still hung -downloaded 3.23.32 source. compiled, hung up in mysql_install_db after printing "installing all prepared tables" -killed off those processes ,started with safe_mysqld ... , clients still hung -ran myisamchk and isamchk on all DB files.. still hangs -removed all my.cnf's ... still hangs Im SUPER FRUSTRATED...please help!!! How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Drew Degentesh Organization: MySQL support: none Synopsis: mysql clients hung (cannot start) Severity: critical Priority: high Category: mysql Class: Release: mysql-3.23.27-beta (Official MySQL binary) Environment: System: Linux 2.2.12-20RS #1 Mon Feb 14 16:39:25 CST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Mar 30 2000 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 4118683 Feb 23 2000 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20031726 Feb 23 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Feb 23 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
!!! Mysql hangs after some days on FreeBSD 4.0I
Hi,
I've mysql 3.23.32 running on FreeBSD 4.0.
It runs a site with heavy traffic and heavy
database interaction.
After starting mysql it hangs after some days.
Mysql server is still in the processlist, but
it is not possible to connect to the sql
server anymore. Therefor it is impossible
to stop the server and rerun it without killing.
Problem with threads??
I've found the following in the config.log generated
by ./configure:
- SNIP
configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm 15
/tmp/ccF77967.o: In function `main':
/tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create'
configure: failed program was:
#line 5641 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5662: checking for pthread_create in -lpthread
configure:5673: gcc -o conftest conftest.c -lz -lcrypt -lm -lpthread
15
/usr/libexec/elf/ld: cannot open -lpthread: No such file or directory
configure: failed program was:
#line 5666 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5688: checking for pthread_create in -lpthreads
configure:5697: gcc -o conftest
conftest.c-lz -lcrypt -lm -lpthreads 15
/usr/libexec/elf/ld: cannot open -lpthreads: No such file or directory
configure: failed program was:
#line 5690 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
- SNIP
I've no idea if this is important or not?
I've made a script which reboots the server if connection
to sql server fails. But this is not a solution :).
Thanks in advance.
Regards,
Patric de Waha
-
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: !!! Mysql hangs after some days on FreeBSD 4.0I
Hi Patric,
I believe you will have many problems of this kind with older
versions of FreeBSD. You should update, if you can, to
FreeBSD-stable. See this URL for easy instructions on how to update
if you don't know how.
http://www.mostgraveconcern.com/freebsd/ and look at the CVSUP
info.
The recompile MySQL and re-install it!
Bonne chance
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "pdewaha" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 11:21 AM
Subject: !!! Mysql hangs after some days on FreeBSD 4.0I
Hi,
I've mysql 3.23.32 running on FreeBSD 4.0.
It runs a site with heavy traffic and heavy
database interaction.
After starting mysql it hangs after some days.
Mysql server is still in the processlist, but
it is not possible to connect to the sql
server anymore. Therefor it is impossible
to stop the server and rerun it without killing.
Problem with threads??
I've found the following in the config.log generated
by ./configure:
- SNIP
configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm
15
/tmp/ccF77967.o: In function `main':
/tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create'
configure: failed program was:
#line 5641 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5662: checking for pthread_create in -lpthread
configure:5673: gcc -o conftest
conftest.c -lz -lcrypt -lm -lpthread
15
/usr/libexec/elf/ld: cannot open -lpthread: No such file or
directory
configure: failed program was:
#line 5666 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5688: checking for pthread_create in -lpthreads
configure:5697: gcc -o conftest
conftest.c-lz -lcrypt -lm -lpthreads 15
/usr/libexec/elf/ld: cannot open -lpthreads: No such file or
directory
configure: failed program was:
#line 5690 "configure"
#include "confdefs.h"
#include pthread.h
int main() {
pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
- SNIP
I've no idea if this is important or not?
I've made a script which reboots the server if connection
to sql server fails. But this is not a solution :).
Thanks in advance.
Regards,
Patric de Waha
-
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
