Re: mysql deadlock situation - possible bug
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote: good day - i have found cases in which the daemon blocks waiting on a select() and just plain refuses to process certain queries. since i am reading in a 60 meg file, meaning about 3.5 million queries, this consistently happens somewhere in the middle. i am using 3.23.41. restarting the server or rebooting the machine don't seem to affect the problem. i don't know what the daemon is waiting for - can i do some useful analysis with strace and lsof? if this is a bug, i would love to contribute a report of it. any suggestion is welcome; i'm really puzzled! Report the bug using the instructions in the manual: http://www.mysql.com/doc/B/u/Bug_reports.html and it'll get fixed if it's a repeatable bug. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 1 days, processed 16,673,032 queries (176/sec. avg) - 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 deadlock situation - possible bug
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Aaron Brick writes: good day - i have found cases in which the daemon blocks waiting on a select() and just plain refuses to process certain queries. since i am reading in a 60 meg file, meaning about 3.5 million queries, this consistently happens somewhere in the middle. i am using 3.23.41. cut What does 'mysqladmin proc' say when this happens ? If it says 'system lock' then this is a bug in the lockd daemon and you should start mysqld with '--skip-locking' or remove 'enable-locking' from your my.cnf file. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
mysql deadlock situation - possible bug
good day - i have found cases in which the daemon blocks waiting on a select() and just plain refuses to process certain queries. since i am reading in a 60 meg file, meaning about 3.5 million queries, this consistently happens somewhere in the middle. i am using 3.23.41. restarting the server or rebooting the machine don't seem to affect the problem. i don't know what the daemon is waiting for - can i do some useful analysis with strace and lsof? if this is a bug, i would love to contribute a report of it. any suggestion is welcome; i'm really puzzled! thanks, aaron brick. ps - i include the word database so the filter lets me post this. _ | | | Aaron Brick (415) 902 - 7209 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - 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