Hi! MySQL AB and Innobase Oy entry-level support contract costs 3770 euros annually (3250 USD).
For corporations with requirements for high availability we have more expensive telephone support options. These are extremely low priced compared against your costs for proprietary database products, and are low even when compared to rates charged by other open-source vendors. So please consider investing in a MySQL/InnoDB support contract. You will be served not by a help desk, but directly by the developers who author MySQL/InnoDB's source code. Information: http://www.mysql.com/support/index.html To Purchase: https://order.mysql.com/ About the buffer pool error: a similar bug in recovery was fixed in 3.23.45: ... November 17, 2001: In recovery InnoDB may go into an infinite loop constantly printing a warning message that it cannot find free blocks from the buffer pool. Fixed in 3.23.45. ... I have also a faint recollection that I then also fixed some additional error in the buffer pool flush algorithm which could cause the error messages to be printed in normal operation, not just recovery. Regards, Heikki Tuuri Innobase Oy ----- Original Message ----- From: "JW" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 07, 2002 5:04 AM Subject: Re: VERY URGENT, possible bug. More on: What does this error message mean: InnoDB: Warning: difficult to find free blocks from the buffer pool.. > > 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
