Is there a pdf format of this ibman page ? OR is there a good book on Mysql+innodb out there ?
Thanks On Fri, 1 Aug 2003, Heikki Tuuri wrote: > Asif, > > ----- Original Message ----- > From: "Asif Iqbal" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Thursday, July 31, 2003 10:41 PM > Subject: Mysqld is keep crashing > > > > > > > > This is what I bumped into now > > > > 030731 15:39:50 mysqld started > > 030731 15:39:52 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 3491794745 > > InnoDB: Doing recovery: scanned up to log sequence number 0 3491800490 > > InnoDB: 1 transaction(s) which must be rolled back or cleaned up > > InnoDB: in total 32 row operations to undo > > InnoDB: Trx id counter is 0 3532544 > > 030731 15:39:53 InnoDB: Starting an apply batch of log records to the > > database... > > InnoDB: Progress in percents: 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 > > InnoDB: Apply batch completed > > InnoDB: Starting rollback of uncommitted transactions > > InnoDB: Rolling back trx with id 0 3532191, 32 rows to undoInnoDB: Error: > trying > > to access page number 2650767236 in space 0 > > InnoDB: which is outside the tablespace bounds. > > InnoDB: Byte offset 0, len 16384, i/o type 10 > > 030731 15:39:59 InnoDB: Assertion failure in thread 1 in file fil0fil.c > line > > 1176 > > InnoDB: Failing assertion: 0 > > InnoDB: We intentionally generate a memory trap. > > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > > mysqld got signal 11; > > This could be because you hit a bug. It is also possible that this binary > > or one of the libraries it was linked against is corrupt, improperly > built, > > or misconfigured. This error can also be caused by malfunctioning > hardware. > > We will try our best to scrape up some info that will hopefully help > diagnose > > the problem, but since we have already crashed, something is definitely > wrong > > and this may fail. > > > > key_buffer_size=402653184 > > read_buffer_size=2093056 > > 030731 15:39:59 mysqld ended > > > > > > Anyone would know how I can fix it > > your InnoDB database is now corrupt. That may be a result of mixing ibdata > files or ib_logfiles. I recall you were trying to modify my.cnf 2 days ago > and had some problems. > > You can try starting with http://www.innodb.com/ibman.html#Forcing_recovery: > > set-variable = innodb_force_recovery = 4 > > and dump your tables and recreate your ibdata files and ib_logfiles. > > > I am using my-huge.cnf . I have 4 450Mhz with 4 gig ram > > -- > > Asif Iqbal > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Transactions, foreign keys, and a hot backup tool for MySQL > Order MySQL technical support from https://order.mysql.com/ > > > > -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]