Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 480902 - ibdata1 on yellowhammer is abnormally large, need to shrink it back down.
Summary: ibdata1 on yellowhammer is abnormally large, need to shrink it back down.
Status: RESOLVED OBSOLETE
Alias: None
Product: Gentoo Infrastructure
Classification: Unclassified
Component: Bugzilla (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Infrastructure
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-13 18:43 UTC by Alec Warner
Modified: 2014-09-01 08:49 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alec Warner (RETIRED) archtester gentoo-dev Security 2013-08-13 18:43:38 UTC
17:16 <@antarus> robbat2: hrm, yellowhammer-ro failed an aio write to disk, and mysql is slightly angry about it
17:17 <@antarus> I don't see anything in dmesg that is disk related, plenty of space, inodes, etc..
17:18 <@robbat2> 130813 17:18:14 [Warning] Slave: Unknown table engine 'InnoDB' Error_code: 1286
17:18 <@antarus> yeah
17:19 <@robbat2> InnoDB: Error: auto-extending data file /var/lib/mysql-ro/db/ibdata1 is of a different size
17:19 <@robbat2> InnoDB: 263360 pages (rounded down to MB) than specified in the .cnf file:
17:19 <@robbat2> did somebody change the settings?
17:20  * antarus didn't
17:20 <@antarus> my-ro.cnf is dated 2012
17:21 <@antarus> other stuff is dated 2011
17:21 <@antarus> log file size is 512
17:22 <@antarus> innodb_data_file_path = ibdata1:10M:autoextend:max:512M
17:22 <@antarus> innodb_data_file_path = ibdata1:10M:autoextend:max:5G
17:22 <@antarus> whaaaaaat
17:22 <@robbat2> the 5G i just added
17:22 <@robbat2> to try and fix
17:22 <@antarus> ahh
17:22 <@antarus> ok ;)
17:22 <@robbat2> -rw-rw---- 1 mysql mysql 4315052192 Aug 13 10:51 /var/lib/mysql-ro/db/ibdata1
17:23 <@robbat2> i'm not sure why it's so large
17:25 <@antarus> you mean why it grew over 512M in the first place?
17:25 <@robbat2> yes
17:57 <@antarus> robbat2: was that all that was needed to fix it?
18:05 <@robbat2> i wouldn't call that a proper fix
18:05 <@robbat2> we need to see about trimming that file back down in size
18:41  * antarus nods
Comment 1 Christian Ruppert (idl0r) gentoo-dev 2013-08-24 17:10:20 UTC
17:18 <@robbat2> 130813 17:18:14 [Warning] Slave: Unknown table engine 'InnoDB' Error_code: 1286

I noticed a similar error some weeks ago. It was due to a damaged FS. It was/is ReiserFS or XFS and a FS check fixed that.
Comment 2 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2013-08-24 20:04:04 UTC
unlocking this bug, no private info here.
Comment 3 Alex Legler (RETIRED) archtester gentoo-dev Security 2014-09-01 08:49:00 UTC
Guessing this is obsolete with bugzilla having changed homes.