[Err] 1030 - Got error 139 from storage engine
Posted: Tue Nov 30, 2010 9:36 am
Hello,
I am getting this error when updating my database:
[Err] 1030 - Got error 139 from storage engine
For the type of application I have, it make sense to have everything in just one table. I have over 60 columns. There are all pieces of information of one thing. So there is no sense on separating the information into different tables. In 2006 someone in this forum had the same problem. He fix it by separating the data in multiple tables. I cant believe 4 years later mysql has done nothing to fix this.
It only happens using innodb , not myisam
How to duplicate
create a test table
id int
d1 blob(o longblob)
d2 blob(o longblob)
...
d15 blob(o longblob)
update UPDATE test set d1 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
update UPDATE test set d2 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
update UPDATE test set d3 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
continue updating until getting error( at about d12)
I would like to know if anyone has better options than to separate in tables, using myisam (which I dont want to do because the way mysql lock the full table), or switching databases (maybe postgre)
Thank you
I am getting this error when updating my database:
[Err] 1030 - Got error 139 from storage engine
For the type of application I have, it make sense to have everything in just one table. I have over 60 columns. There are all pieces of information of one thing. So there is no sense on separating the information into different tables. In 2006 someone in this forum had the same problem. He fix it by separating the data in multiple tables. I cant believe 4 years later mysql has done nothing to fix this.
It only happens using innodb , not myisam
How to duplicate
create a test table
id int
d1 blob(o longblob)
d2 blob(o longblob)
...
d15 blob(o longblob)
update UPDATE test set d1 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
update UPDATE test set d2 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
update UPDATE test set d3 = AES_ENCRYPT('STRING WITH 1000 characters','somekey') WHERE id=1
continue updating until getting error( at about d12)
I would like to know if anyone has better options than to separate in tables, using myisam (which I dont want to do because the way mysql lock the full table), or switching databases (maybe postgre)
Thank you