runaway process eating all cpu-time?
Hi there, after a system-crash I got the following problem. Some seconds after starting mysql (v4.0.20) a process will stay there taking all cpu-time it can get (99.9% ;)) ... and it can't be terminated, just killed completely. mysqlcheck ran through without any problems, the logs tell nothing. I just did a strace on the last process doing that: --- time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 sched_yield() = 0 time(NULL) = 1093348120 rt_sigprocmask(SIG_SETMASK, NULL, [HUP INT QUIT PIPE TERM TSTP 32], 8) = 0 rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] unfinished ... --- SIGRT_0 (Real-time signal 0) --- --- Any idea where to look at that problem further? The system is a linux - redhat-7.2 with dual athlon-mp, 2 GB ram, running kernel-2.4.26. Using the official mysql.com-binaries (rpm-install). TIA, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: runaway process eating all cpu-time?
Hi Victor, thanks for your reply. Victor Pendleton wrote: Do you have anything in the show processlist? Are you using innodb table types and a rollback is occurring? mysql show processlist; +---+-+---+---++--++--+ | Id| User| Host | db| Command| Time | State | Info | +---+-+---+---++--++--+ | 810 | DELAYED | | phpadsnew | Delayed_insert | 3| Waiting for INSERT | | | 10125 | root| localhost | NULL | Sleep | 70 || NULL | | 12020 | root| localhost | NULL | Query | 0| NULL | show processlist | +---+-+---+---++--++--+ Could it be the delayed_insert thread? I checked its tables extended already. Any way to see a connection-id - process-id relation? I'm using innodb just for one table at the moment. but its idle too. Any ideas? Thanks, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with mysql-crashes
Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x5e13a478 is invalid pointer thd-thread_id=2223573 ) The server is the standalone db-server for one accessing webserver, its running RedHat-Linux 7.2 with all their latest patches. Kernel 2.4.19-XFS with MySQL running on an XFS-filesystem. No replication but query-cache enabled. Ok but now the worse thing started for 2 times I already got this problem in the logs: Number of processes running now: 16 mysqld-max process hanging, pid 17193 - killed mysqld-max process hanging, pid 17191 - killed mysqld-max process hanging, pid 17190 - killed mysqld-max process hanging, pid 17145 - killed mysqld-max process hanging, pid 17144 - killed mysqld-max process hanging, pid 17098 - killed mysqld-max process hanging, pid 17025 - killed mysqld-max process hanging, pid 16987 - killed mysqld-max process hanging, pid 28393 - killed mysqld-max process hanging, pid 28392 - killed mysqld-max process hanging, pid 28391 - killed mysqld-max process hanging, pid 28389 - killed mysqld-max process hanging, pid 28388 - killed mysqld-max process hanging, pid 28387 - killed mysqld-max process hanging, pid 28386 - killed mysqld-max process hanging, pid 28385 - killed 030722 20:46:26 mysqld restarted Afterwards there is a init-process taking 99% from one CPU. The first time I tried to reboot the machine, which didn't work as the shutdown process was hanging then. Any ideas whats wrong and how to fix it? Didn't see a mention of a fix for that problem in the 4.0.14-changelog, will it still fix it? Thanks in advance, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]