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
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.
unlocking this bug, no private info here.
Guessing this is obsolete with bugzilla having changed homes.