Comment 41 for bug 1969247

Revision history for this message
Jay Lepore (amazon-compumatter) wrote :

Until such time the fix makes it into mainstream, this hack gets things going again for me.

I took a look at the contents of the directory /var/lib/mysql/#innodb_redo#
There was only a single file there which of course matched the filename identified in the /var/log/mysql/error.log and this was:

-rw-r----- 1 mysql mysql 0 Aug 1 19:10 '#ib_redo0'

I deleted it.

Mysql immediately restarted.

In addition, upon restarting generated these files within that same directory /var/lib/mysql/#innodb_redo#

-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo0'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo10_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo11_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo12_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo13_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo14_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo15_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo16_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo17_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo18_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo19_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo1_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo20_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo21_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo22_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo23_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo24_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo25_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo26_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo27_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo28_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo29_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo2_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo30_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo31_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo3_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo4_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo5_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo6_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo7_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo8_tmp'
-rw-r----- 1 mysql mysql 3276800 Aug 1 19:10 '#ib_redo9_tmp'