MySQL Forums
Forum List  »  InnoDB

Operating system error 4 on rollback...
Posted by: John Selson
Date: June 10, 2005 02:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Operating system error 4 on rollback...
3182
June 10, 2005 02:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.