Operating system error 4 on rollback...
I recently attempted to add an index to an InnoDB table with about 5 million rows. Bad idea...as mySQL crashed in the middle and now won't reopen. Here's the error I get:
050610 04:26:58 mysqld started
050610 4:26:58 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 2730858260
InnoDB: Doing recovery: scanned up to log sequence number 2 2731426874
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1845699 row operations to undo
InnoDB: Trx id counter is 0 160241920
050610 4:26:58 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 050610 4:27:35 InnoDB: Operating system error number 4 in a file operation.
InnoDB: See
http://www.innodb.com/ibman.html for installation help.
InnoDB: Error number 4 means 'Interrupted system call'.
InnoDB: See also section 13.2 at
http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
050610 04:27:35 mysqld ended
The file itself is 5 GB now but this is on a filesystem with a max filesize of 16GB. Any ideas?
John