Table is full

[Jason Dixon]

I'm trying to do an update to one of my tables, but I'm getting the 
"table <name> is full" error.  I've reviewed the manual 
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems 
to apply.  I looked at the output of myisamchk, and everything looks 
fine.  The table file is only ~100M, and the partition has almost 4G of 
free space.  The proposed update would only add approx 1byte per row, 
so I just don't see how this query can cause a full table.  Can someone 
clue me in here?

[EMAIL PROTECTED] root]# myisamchk -dv /var/db/mysql/pflabel/statstest.MYI
MyISAM file:         /var/db/mysql/pflabel/statstest.MYI
Record format:       Packed
Character set:       latin1 (8)
File-version:        1
Creation time:       2005-04-19 12:00:51
Recover time:        2005-04-19 12:03:44
Status:              checked,analyzed
Auto increment key:              1  Last value:               2022514
Data records:              1911283  Deleted blocks:                 0
Datafile parts:            1911283  Deleted data:                   0
Datafile pointer (bytes):        4  Keyfile pointer (bytes):        4
Datafile length:         104946052  Keyfile length:          74199040
Max datafile length:    4294967294  Max keyfile length: 4398046510079
Recordlength:                  550
table description:
Key Start Len Index   Type                     Rec/key         Root  
Blocksize
1   1     4   unique  unsigned long                  1      5110784     
  1024
2   260   255 multip. char packed stripped       12574     27400192     
  2048
3   535   8   multip. ulonglong                     16     50799616     
  1024
4   543   8   multip. ulonglong                    186     74198016     
  1024

Thanks,
--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]