List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:July 5 2010 5:45pm
Subject:Re: Got error 139 from storage engine (InnoDB)
View as plain text  
I think this is related to foreign key constraint data types don't match
up... so verify your CREATE TABLE structure or post the CREATE TABLE
statement for your table.

Or there is chance of data type size and the value you are inserting.. such
type of problem occurs if the data import ie source and restore ie target
are of different versions .

Thanks,

On Mon, Jul 5, 2010 at 9:36 PM, Rob Wultsch <wultsch@stripped> wrote:

> On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano <james@stripped>
> wrote:
> > Hi All,
> >
> > I have received error message "ERROR 1030 (HY000) at line 167: Got error
> 139
> > from storage engine" when importing dump database to MySQL server. The
> MySQL
> > server is using InnoDB. I have google it and it's something problem on
> > exceeding
> > a row-length limit in the InnoDB table.
> >
> > Any have idea how to fix this?
> >
> > Thanks.
> >
> > Regards,
> > James
> >
>
> I can not recall having seen that error before. I did a slight amount
> of googling and it sounds like it might be a innodb tuning issue.
> Please post:
> 1. Any relevant entries in your error log file.
> 2. Your my.cnf.
> 3. You servers specs and whether the server also runs other daemons.
>
>
> --
> Rob Wultsch
> wultsch@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

Thread
Got error 139 from storage engine (InnoDB)James Corteciano5 Jul
  • Re: Got error 139 from storage engine (InnoDB)Rob Wultsch5 Jul
    • Re: Got error 139 from storage engine (InnoDB)Prabhat Kumar5 Jul
    • Re: Got error 139 from storage engine (InnoDB)Rob Wultsch5 Jul
  • Re: Got error 139 from storage engine (InnoDB)Joerg Bruehe6 Jul
    • Re: Got error 139 from storage engine (InnoDB)James Corteciano6 Jul