large .arn file filling up whole hard drive

[Florian Enzinger]

Hello,

I recently ran into an issue whit an archive table of about 1gb. When I try to get data from this table a large .arn file with up to 800gb is created on the server, using almost all space available.
This happens running mysql5.5.4 on ubuntu. I also have the same setup on another server (mysql5.0.38 on ubuntu) where I don't have this issue (thoug the archive there is ~8gb). On mysql5.0.38 there is no .arn but a .arm file that has only 19kb.

This is what the table looks like:

CREATE TABLE `importsuccess` (
`backup_id` int(10) unsigned NOT NULL,
`serial` varchar(36) NOT NULL,
`identifier` varchar(14) NOT NULL,
`sn_id` int(10) unsigned NOT NULL,
`sn` longtext NOT NULL,
`parsetime` bigint(20) unsigned NOT NULL DEFAULT '0',
`ts_import` datetime NOT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 PACK_KEYS=0;

Thanks for any help,
Flo