Date: 12/08/05 (MySQL Communtiy)    Keywords: mysql, rss, software, database, sql, linux

Any ideas?

CREATE TABLE `LAD_RSSDB_FEEDSTER_CORE` (
`RSS_ID` int NOT NULL auto_increment,
`SITE` varchar(64) DEFAULT 'rssdb' NOT NULL,
`ACCOUNT_ID` int DEFAULT -2 NOT NULL,
`URL` varchar(900) NOT NULL,
`CHANGED` tinyint DEFAULT 1 NOT NULL,
`STATUS` tinyint DEFAULT 0 NOT NULL,
`LAST_PINGED` datetime DEFAULT '1970-01-01 00:00:00' NOT NULL,
`LAST_DOWNLOADED` datetime DEFAULT '1970-01-01 00:00:00' NOT NULL,
`TIMESTAMP` timestamp NOT NULL,
`PING_INTERVAL` bigint DEFAULT 144000 NOT NULL,
`CRC32` int DEFAULT 0 NOT NULL,
`STRIKES` int DEFAULT 0 NOT NULL,
`FIRST_CREATED` datetime NOT NULL,
`CREATED_BY` varchar(50) DEFAULT 'unknown' NOT NULL,
`NM_PROCESSED` int DEFAULT 0 NOT NULL,
`NM_CUMUL` int DEFAULT 0 NOT NULL,
UNIQUE KEY `RSSDB_FEEDSTER_CORE_IND1` USING BTREE (`RSS_ID`),
KEY `RSSDB_FEEDSTER_CORE_IND2` USING BTREE (`URL`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

and I got the following error message:

#HY000Can't create table './rss/LAD_RSSDB_FEEDSTER_CORE.frm' (errno: 139)

Machine is l00nix and build is:
root@mosdef [6:43pm]:86:/data# mysqladmin version -p
Enter password:
mysqladmin Ver 8.41 Distrib 5.0.16, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.16-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 5 days 1 hour 57 min 29 sec

Threads: 7 Questions: 11430901 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 34 Queries per second avg: 26.036

The production version of this will be on FreeBSD - is this a locale issue? Do I need to recreate databases and/or recompile?

Source: http://www.livejournal.com/community/mysql/75539.html