Bug #64780 These is impossible
Submitted: 27 Mar 2012 20:33 Modified: 30 Apr 2012 6:20
Reporter: José Nazário Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.5.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: wrong error

[27 Mar 2012 20:33] José Nazário
CREATE TABLE `tipoveiculo` (
  `tipo_veiculo` varchar(20) NOT NULL,
  PRIMARY KEY (`tipo_veiculo`)

Values in the table 
'Automovel 2'

When i change Moto to Moto_Bla no problem

When i try to change 'Automovel 2' to 'Automovel 3' gives me these error

'the maximum row size for the used table type not counting blobs...'

"sometimes it work sometimes he doesn´t" also trying to force changes makes the mysql server to stop service

How to repeat:
I don´t know it just append sometimes....

Suggested fix:
Some sql code to check the entire database for inconsistences
[27 Mar 2012 23:55] MySQL Verification Team
Please try version 5.5.21. Thanks.

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use test
Database changed
mysql> CREATE TABLE `tipoveiculo` (
    ->   `tipo_veiculo` varchar(20) NOT NULL,
    ->   PRIMARY KEY (`tipo_veiculo`)
Query OK, 0 rows affected (0.17 sec)

mysql> insert into tipoveiculo values ("Automovel 2");
Query OK, 1 row affected (0.06 sec)

mysql> insert into tipoveiculo values ("Moto");
Query OK, 1 row affected (0.02 sec)

mysql> update tipoveiculo set tipo_veiculo = "Automovel 3" where tipo_veiculo = "Automovel 2";
Query OK, 1 row affected (0.06 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from tipoveiculo;
| tipo_veiculo |
| Automovel 3  |
| Moto         |
2 rows in set (0.01 sec)

[28 Mar 2012 23:30] José Nazário
You can see the garbage that goes into table when bug append

Attachment: MysqlUpdateBug.JPG (image/jpeg, text), 185.58 KiB.

[29 Mar 2012 5:34] MySQL Verification Team
please upload the entire mysql error log. innodb should print alot of error messages there.  compress it if it's large.

[29 Mar 2012 20:32] José Nazário
Where are the logs??
[30 Mar 2012 6:20] Valeriy Kravchuk
Error log is usually named <hostname>.err and is located in the datadir (see your my.cnf or my.ini file content). We need to know what OS do you run MySQL on to be more specific.
[1 May 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".