Bug #13306 unspecific error on table full
Submitted: 18 Sep 2005 12:48 Modified: 29 Oct 2005 1:07
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.14/BK source OS:FreeBSD (freebsd/Suse 9.3)
Assigned to: Jim Winstead CPU Architecture:Any

[18 Sep 2005 12:48] Martin Friebe
Description:
if you try to insert data in a table that is "full" (variable row length, 4GB of data reached), you get the error:
ERROR 1105 (HY000): Unknown error 

You should get a specific error

How to repeat:
create 2 tables with the same format, having varchar and blob fields.
fill the 4st table to contain 4GB
have some entries in the 2nd table.

insert ignore into table1 select * from table2;
ERROR 1105 (HY000): Unknown error 

the table format should not matter, anyway some info on it:
+-----------+-----------------------+------+-----+---------+-------+
| Field     | Type                  | Null | Key | Default | Extra |
+-----------+-----------------------+------+-----+---------+-------+
| timestamp | int(11)               |      | MUL | 0       |       |
| msg_oid   | bigint(20) unsigned   |      | PRI | 0       |       |
| trn_oid   | bigint(20) unsigned   |      | MUL | 0       |       |
| trn_pos   | mediumint(8) unsigned |      |     | 0       |       |
| creator   | varchar(44)           | YES  |     | NULL    |       |
| msg_type  | smallint(5) unsigned  |      |     | 0       |       |
| dest_to   | tinyint(3) unsigned   |      |     | 0       |       |
| dest_from | tinyint(3) unsigned   |      |     | 0       |       |
| host      | varchar(100)          | YES  |     | NULL    |       |
| url       | varchar(100)          | YES  |     | NULL    |       |
| body      | blob                  | YES  |     | NULL    |       |
+-----------+-----------------------+------+-----+---------+-------+

show table status \G
*************************** 1. row ***************************
           Name: http
         Engine: MyISAM
        Version: 9
     Row_format: Dynamic
           Rows: 6274699
 Avg_row_length: 441
    Data_length: 4294967060
Max_data_length: 4294967295
   Index_length: 321212416
      Data_free: 1523833024
 Auto_increment: NULL
    Create_time: 2005-07-26 11:06:19
    Update_time: 2005-09-18 13:51:25
     Check_time: 2005-09-18 13:37:45
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:

Suggested fix:
-
[18 Sep 2005 14:21] MySQL Verification Team
Thank you for the bug report.

mysql> insert ignore into tb2 select * from tb1;
ERROR 1105 (HY000): Unknown error
mysql> select version();
+------------------+
| version()        |
+------------------+
| 4.1.15-debug-log |
+------------------+
1 row in set (0.02 sec)
[29 Oct 2005 1:07] Jim Winstead
The correct error is reported in 5.0.