I belive I have found a bug here, possibly. The last known commands to be run on the DB that are "suspicious" were a join between 2 tables.
This is the info I got from the user who was workign on the DB: He was "joining between keyword and billing" select distinct(a.customerid) from cpcustomer.customerkeyword a left join cpbilling.billdetail b on a.customerid=b.customerid where b.customerid is null and active='y'; For some reason he hit ^c to exit (it didn't seem to be responding or somethign) He logged came back on to MySQL and ran: alter table add key bdetailcid (customerid); show create billdetail; It crashed (locked up) durning the last query mentioned above. I tried to shut down the server, but it wouldn't die so I ran the init-stop script a second time. It seems that the init start/stop script gets forceful on the second try. Started it back up, it took a _very_ long time recovering (InnoDB), then started in with the error message I first posted. Any ideas? I'm currently restoring from backups.... we'll see how it goes. Thanks. JW >I forgot to point out that this is InnoDB JW > JW >I've searched Google and found the following disquiteing thing: JW >http://www.innodb.com/oldbugs.html: JW > JW >"Closed or old bug reports: Almost all of these bugs have been fixed. There are some old bug reports where the cause of the bug was never found, but because there have been no bug reports for newer versions of InnoDB, these reports are not considered actual any more. " JW ><snip> JW >August 13, 2001: JW > The fsync problem which was fixed in 3.23.40b and .41 could cause the following warning message on some Unix flavors: JW > JW >Innobase: Warning: difficult to find free blocks from JW >Innobase: the buffer pool! Consider increasing the JW >Innobase: buffer pool size. JW > JW >If you encounter the above message, upgrade to 3.23.41." JW > JW >However, I'm already using a newer vresion than that: JW > JW >ccs012:~ # rpm -qa |grep mysql JW >mysql-shared-3.23.44-5 JW >mysql-Max-3.23.44-5 JW >mysql-devel-3.23.44-5 JW >mysql-navigator-1.2.3-106 JW >mysql-client-3.23.44-5 JW >mysql-3.23.44-5 JW >mysql-bench-3.23.44-5 JW >ccs012:~ # JW > JW >This is a mission critical DB. Am I the lucky un-fortunate to re-dicover this supposedly fixed bug? JW > JW >JW >I'm getting this error messge constantly in my error log: JW >JW > JW >JW >020406 18:02:50 *********************************************** JW >JW >InnoDB: Warning: difficult to find free blocks from JW >JW >InnoDB: the buffer pool (200 search iterations)! Consider JW >JW >InnoDB: increasing the buffer pool size. JW >JW >InnoDB: It is also possible that in your Unix version JW >JW >InnoDB: fsync is very slow, or completely frozen inside JW >JW >InnoDB: the OS kernel. Then upgrading to a newer version JW >JW >InnoDB: of your operating system may help. Look at the JW >JW >InnoDB: number of fsyncs in diagnostic info below. JW >JW >InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0 JW >JW >InnoDB: 5703 OS file reads, 502 OS file writes, 82 OS fsyncs JW >JW >InnoDB: Starting InnoDB Monitor to print further JW >JW >InnoDB: diagnostics to the standard output. JW >JW > JW >JW >Running SuSE Linux 7.3: JW >JW > JW >JW >ccs012:/var/lib/mysql # uname -a ; df -h ; free -m JW >JW >Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown JW >JW >Filesystem Size Used Avail Use% Mounted on JW >JW >/dev/sda7 67G 59G 8.2G 88% / JW >JW >/dev/sda5 63M 36M 26M 58% /boot JW >JW >shmfs 1007M 0 1006M 0% /dev/shm JW >JW > total used free shared buffers cached JW >JW >Mem: 2013 2008 4 0 10 657 JW >JW >-/+ buffers/cache: 1340 672 JW >JW >Swap: 1035 0 1035 JW >JW > JW >JW > JW >JW >TIA JW >JW > JW >JW >-- JW >JW > JW >JW >---------------------------------------------------- JW >JW >Jonathan Wilson JW >JW >System Administrator JW >JW >Clickpatrol.com JW >JW >Cedar Creek Software http://www.cedarcreeksoftware.com JW >JW > JW >JW > JW >JW > JW >JW >--------------------------------------------------------------------- JW >JW >Before posting, please check: JW >JW > http://www.mysql.com/manual.php (the manual) JW >JW > http://lists.mysql.com/ (the list archive) JW >JW > JW >JW >To request this thread, e-mail <[EMAIL PROTECTED]> JW >JW >To unsubscribe, e-mail <[EMAIL PROTECTED]> JW >JW >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JW >JW > JW >JW > JW >JW > JW > JW >-- JW > JW >---------------------------------------------------- JW >Jonathan Wilson JW >System Administrator JW >Clickpatrol.com JW >Cedar Creek Software http://www.cedarcreeksoftware.com JW > JW > JW > JW >--------------------------------------------------------------------- JW >Before posting, please check: JW > http://www.mysql.com/manual.php (the manual) JW > http://lists.mysql.com/ (the list archive) JW > JW >To request this thread, e-mail <[EMAIL PROTECTED]> JW >To unsubscribe, e-mail <[EMAIL PROTECTED]> JW >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JW > JW > JW > -- ---------------------------------------------------- Jonathan Wilson System Administrator Clickpatrol.com Cedar Creek Software http://www.cedarcreeksoftware.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
