Dear Alberto, Some users will delete the INNODB files and re-create them again in order to avoid the error, but I don't believe this is the proper solution.
This is how to handle such error code: http://dev.mysql.com/doc/refman/5.1/en/innodb-error-handling.html In the same time, please stop and anti-virus scanning during the operation. The way I see it is to increase the size of InnoDB. To do that you have to follow the 5.1 manual which is here? http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html Please advise the above statements are helpful. Regards ...Amrow Hijazi... --- In [email protected], "Corrales, Alberto" <[EMAIL PROTECTED]> wrote: > > Hello All, > > I´ll appreciate your help to understand and resolve the follwoing problem. > > I have a Windows Xp running MySql, one of the tables is aprox. 800.000 registers. In random way the MySql service is stopped, when i checked the logs the folowing message appears: > > 060201 20:36:20 InnoDB: Operating system error number 995 in a file operation. > InnoDB: See http://www.innodb.com/ibman.html for installation help. > InnoDB: Look from section 13.2 at http://www.innodb.com/ibman.html > InnoDB: what the error number means. > InnoDB: File name .\ibdata1 > InnoDB: Cannot continue operation. > MySql: ready for connections. > Version: '4.0.12-nt' socket: '' port: 3306 > 060202 8:52:46 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 0 1075636473 > InnoDB: Doing recovery: scanned up to log sequence number 0 1075637458 > 060202 8:52:46 InnoDB: Starting an apply batch of log records to the database... > InnoDB: Progress in percents: 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 > InnoDB: Apply batch completed > 060202 8:52:46 InnoDB: Flushing modified pages from the buffer pool... > 060202 8:52:47 InnoDB: Started > > > > Does anybody know about this problem?? > > Thanks > > Alberto > > > > [Non-text portions of this message have been removed] > ----------------------------- Visit www.tsolver.net Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/tsolver/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
