From: Heikki Tuuri
Date: January 14 2005 5:09pm
Subject: Re: Upgrade correpted InnoDB tables
List-Archive: http://lists.mysql.com/mysql/178492
Message-Id: <001801c4fa5b$cf86c360$bf22de50@koticompaq>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="Windows-1252";
	reply-type=response
Content-Transfer-Encoding: 7bit

Mattias,

was it so that you RECREATED those tables with 4.0.21, and you STILL got the 
error in 4.1.8?

Regards,

Heikki

----- Original Message ----- 
From: "Heikki Tuuri" <Heikki.Tuuri@stripped>
To: <mysql@stripped>
Sent: Friday, January 14, 2005 7:02 PM
Subject: Re: Upgrade correpted InnoDB tables


> Mattias,
>
> this is very strange. Have you used MySQL-5.0.x to create those tables? Or 
> which MySQL version did you use when you created those tables?
>
> Regards,
>
> Heikki
>
> ----- Original Message ----- 
> From: "Mattias J" <mjslask@stripped>
> Newsgroups: mailing.database.myodbc
> Sent: Friday, January 14, 2005 4:39 PM
> Subject: Re: Upgrade correpted InnoDB tables
>
>
>> Ok. This is what happened:
>> We removed MySQL from the server and re-installed 4.0(.21) then put back
>> some old data.
>> When trying to upgrade to 4.1.9 we encountered the same problem, with the
>> exact same tables being corrupted!
>>
>> For one of the tables, as an example, the innodb_table_monitor says
>>   050114 15:29:21  InnoDB: table DB000001/account_text is in the new
>> compact format
>>   InnoDB: of MySQL 5.0.3 or later
>>   InnoDB: Failed to load table DB000001/account_text
>> This occurs 51 times in total for 40+ databases with 130+ tables in each
>> (though different tables in each database).
>>
>> We have a copy of this data and could easily reproduce the error by
>> restoring the data and then upgrading from 4.0 to 4.1(.8 or .9).
>>
>>
>>
>> At 2005-01-14 11:35, you wrote:
>>>Mattias,
>>>
>>>please use
>>>
>>>innodb_table_monitor
>>>
>>>to print the contents of the InnoDB internal data dictionary.
>>>http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html
>>>
>>>Regards,
>>>
>>>Heikki
>>>
>>>----- Original Message ----- From: "Mattias J" <mjslask@stripped>
>>>Newsgroups: mailing.database.myodbc
>>>Sent: Thursday, January 13, 2005 6:57 PM
>>>Subject: Re: Upgrade correpted InnoDB tables
>>>
>>>
>>>>There are mostly just 2 or 3 corrupted tables out of about 100 in each
>>>>database/schema/namespace and if possible we would like to keep the
>>>>information in the other tables.
>>>>
>>>>At 2005-01-13 17:47, you wrote:
>>>>>If you don't have any data in innodb, delete and recreate the
>>>>>tablespace including the frm files. This will give you a fresh 4.1
>>>>>table space to import into.
>>>>>
>>>>>-Eric
>>>>>
>>>>>
>>>>>On Thu, 13 Jan 2005 16:37:39 +0100, Mattias J <mjslask@stripped>
>>>>>wrote:
>>>>> > Earlier today we tried upgrading one of our MySQL servers from
>>>>> 4.0.15 > to
>>>>> > 4.1.8 using RPMs. This resulted in corrupted InnoDB tables seemingly
>>>>> > randomly selected across the different databases (about 40
>>>>> databases > with
>>>>> > similar schemas plus an addition 5 with different tables).
>>>>> >
>>>>> > The error message when trying to access one of those tables is:
>>>>> >    Error: 1016 - Can't open file: 'account_text.ibd' (errno: 1)
>>>>> >
>>>>> > Since there were no important data on this particular server we 
>>>>> > tried
>>>>> > dropping and recreating the table. When trying to drop it, we 
>>>>> > receive
>>>>> >    Error: 1051 - Unknown table 'account_text'
>>>>> > So therefore we removed the .fmt file manually and then tried to >
>>>>> recreate
>>>>> > the table. Here is the result:
>>>>> >    Error: 1005 - Can't create table './DB000001/account_text.frm'
>>>>>(errno: 121)
>>>>> >
>>>>> > What is going on here...?
>>>>> > How would we go about recovering?
>>>>> > I found some bugs in the database (such as #3859, #3594, #3147)
>>>>> that > talk
>>>>> > about similar symptoms. Are these problems in any way related to
>>>>> any > bug?
>>>>> > Could we have done anything wrong during the upgrade (I did not
>>>>> perform > it
>>>>> > myself)? What could we do to prevent this from happening when
>>>>> upgrading > the
>>>>> > other servers?
>>>>> >
>>>>> > Thanks in advance,
>>>>> >    Mattias J
>>
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: 
>> http://lists.mysql.com/mysql?unsub=myodbc@stripped
>>
>