… serious Innodb corruptions for a while, typically even if it happened it was some simple table related corruption which was easy to fix on… worry. If it is global bug it should have been Innodb recovery show stopper while it goes back so many releases…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… in start up errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Writing… result in a heap corruption. Bug fixed #1111226 (Laurynas Biveinis). XtraDB changed page tracking wasn’t compatible with innodb_force_recovery=6. When…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…in start up errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Time… the first one, would result in a heap corruption. Bug fixed #1111226 (Laurynas Biveinis). Fixed the upstream bug #67504 that caused spurious duplicate…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…the query cache enabled could crash with glibc detected memory corruption. Bug fixed #915814 (George Ormond Lorch III). If the tablespace has…skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB_…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…: 1. ibdata1 is erroneously removed 2. ibdata1 is heavily corrupted and innodb_force_recovery doesn’t help Chris Calender suggests two methods… error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to add tablespace 15 of name ‘./sakila/customer.ibd’ InnoDB: to…) page 11: new style: calculated = 0x E4189B9B; recorded = 0x C168689B fixing new checksum of page 11 # # ./innochecksum -f /var/lib/mysql…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
… change also fixed these bugs: #643724, #649408, and #649393. (Yasufumi Kinoshita) innodb_expand_import – Implemented more exact checking to avoid corruption of the ”.ibd” file using ”innodb_expand_export”. (Yasufumi Kinoshita…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… message for the fix as it’s interesting reading for those of us who are into InnoDB internals: The fix of Bug#12612184… log of the record update, the index tree would be corrupted. The correct solution is to make the freed clustered index… is also a likely culprit of InnoDB hangs that were observed when testing the Bug#12612184 fix. btr_mark_freed_leaves(): Mark…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID controller…, and RAID array does not recover You run into a InnoDB corruption bug that propagates via replication (not common, but does happen… a server running in a different timezone. We have a fix here. Details on how we dump schemas: loop through each…
Post: xtrabackup-0.8
July 1, 2009 By 8 Comments
… read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted, and we… To extend tablespace size, if needed after –prepare Data page corruption check is added to local backup mode innobackupex can pass… option Bug #389360: innobackupex-1.5.1 accepts scp options Fixed bugs: Bug #388062: Update to innobackupex to include incremental…
Post: Small things are better
October 8, 2006 By 15 Comments
… Innodb tables. They are designed to never crash, surviving power failures and even partial page writes but still they can get corrupted… bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table fixes it. Sometimes table needs to… certain cases you may need to reimport whole database – if corruption is happens to be in undo tablespace or log files…
