MySQL Forums
Forum List  »  InnoDB

#1030 - Got error 1 from storage engine
Posted by: Michail T
Date: January 15, 2009 04:49AM

hello ,

i have just restored a backup copy of all mysql files which includes both mysql and innodb tables mixed in each database .i have also restored ibdata1 file which is auto extended by 10M .

the problem is when i try to view them through PhpMyadmin i see the innodb tables of some db's are in use when i try to repair them i get the above error .

on backtrace i get this on every query on innodb tables which i see they are in use :


thd=0xb9e09a8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x5e0000, thread_stack=196608, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xbab3f78 = select * from general_vars
thd->thread_id=41
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
090113 16:48:12 mysqld restarted



is there a tool or some way that can help me repair those innodb tables ?

ps . i haven't got a dump file of the db because of the size of the db . it is about 6G . so when i tried to mysqldump it , mysqldump tool hang-died.


thank you in advance for your answers ,

MIchail T .

Options: ReplyQuote


Subject
Views
Written By
Posted
#1030 - Got error 1 from storage engine
18880
January 15, 2009 04:49AM


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.