Failed creating Archive table

[Jonas Nylund]

Hi,

Im trying to create this tabel with storage engine Archive. But it failes and i cant find any good information about why.

Its failing with this error message:
ERROR 1005 (HY000): Can't create table 'apricot.RPT_TR_JN' (errno: -1)
mysql>

This is my table definition. Im running Mysql 5.1.33 on CenOS.

mysql> CREATE TABLE `RPT_TR_JN` (
-> `TIME_STAMP` datetime DEFAULT NULL,
-> `RECORD_SOURCE` int(11) DEFAULT NULL,
-> `SUBSCRIBER_ID` varchar(64) DEFAULT NULL,
-> `PACKAGE_ID` smallint(6) DEFAULT NULL,
-> `SERVICE_ID` int(11) DEFAULT NULL,
-> `PROTOCOL_ID` smallint(6) DEFAULT NULL,
-> `SAMPLE_SIZE` int(11) DEFAULT NULL,
-> `PEER_IP` bigint(20) DEFAULT NULL,
-> `PEER_PORT` int(11) DEFAULT NULL,
-> `ACCESS_String` varchar(1024) DEFAULT NULL,
-> `INFO_String` varchar(1024) DEFAULT NULL,
-> `SOURCE_IP` bigint(20) DEFAULT NULL,
-> `SOURCE_PORT` int(11) DEFAULT NULL,
-> `INITIATING_SIDE` tinyint(4) DEFAULT NULL,
-> `END_TIME` int(11) NOT NULL,
-> `MILISEC_DURATION` bigint(20) DEFAULT NULL,
-> `TIME_FRAME` tinyint(4) DEFAULT NULL,
-> `UPSTREAM_VOLUME` bigint(20) DEFAULT NULL,
-> `DOWNSTREAM_VOLUME` bigint(20) DEFAULT NULL,
-> `SUBS_CNT_ID` int(11) DEFAULT NULL,
-> `GLBL_CNT_ID` int(11) DEFAULT NULL,
-> `PKG_USG_CNT_ID` int(11) DEFAULT NULL,
-> `IP_PROTOCOL` smallint(6) DEFAULT NULL,
-> `PROTOCOL_SIGNATURE` int(11) DEFAULT NULL,
-> `ZONE_ID` int(11) DEFAULT NULL,
-> `FLAVOR_ID` int(11) DEFAULT NULL,
-> `FLOW_CLOSE_MODE` smallint(6) DEFAULT NULL,
-> KEY `RPT_TR_I1` (`END_TIME`)
-> ) ENGINE=Archive DEFAULT CHARSET=latin1;