MySQL Bugs: #40046: Falcon fails to Load / register on Windows

Bug #40046	Falcon fails to Load / register on Windows - MySQL 6.0.7
Submitted:	15 Oct 2008 12:55	Modified:	14 Apr 2009 12:30
Reporter:	Chris Calender	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S2 (Serious)
Version:	6.0.7	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	6.0.7, disk structure version 512.768, F_PLATFORM, fails to load, falcon

Description:
In MySQL 6.0.7, Falcon throws an exception, and because of this exception, the Falcon storage engine fails to load.

Exception:

[ERROR] Falcon: Exception 'Falcon on disk structure version 512.768 is not supported by version 2.3 server' during initialization

Subsequent errors:

[ERROR] Plugin 'Falcon' init function returned error.
[ERROR] Plugin 'Falcon' registration as a STORAGE ENGINE failed.

How to repeat:
Just try to start MySQL 6.0.7 on Windows normally.  Then check the error log.

You will see something similar to the following:

081015  8:40:30  InnoDB: Started; log sequence number 0 46409
081015  8:40:30 [ERROR] Falcon: Exception 'Falcon on disk structure version 512.768 is not supported by version 2.3 server' during initialization
081015  8:40:30 [ERROR] Plugin 'Falcon' init function returned error.
081015  8:40:30 [ERROR] Plugin 'Falcon' registration as a STORAGE ENGINE failed.
081015  8:40:31 [Note] Event Scheduler: Loaded 0 events
081015  8:40:31 [Note] mysqld: ready for connections.
Version: '6.0.7-alpha-community'  socket: ''  port: 3388  MySQL Community Server (GPL)

Suggested fix:
N/A

Chris, I just tried this on XP , works ok for me.

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.7-alpha-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use test;
Database changed
mysql> create table t( i int) engine falcon;
Query OK, 0 rows affected (0.01 sec)

mysql> show create table t;
+-------+-----------------------------------------------------------------
---------------+
| Table | Create Table
               |
+-------+-----------------------------------------------------------------
---------------+
| t     | CREATE TABLE `t` (
  `i` int(11) DEFAULT NULL
) ENGINE=Falcon DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------
---------------+
1 row in set (0.01 sec)

Maybe something specific about your setup you can share? Older Falcon version was already installed?

The error suggests that a file called falcon_master.fts exists, but was
not created by falcon.

I installed a fresh (no-install) version on Windows Vista (32-bit).

I simply unzipped the files, moved them to their new location (created my.ini only setting --port, --basedir, and --datadir.

There is a falcon_master.fts, but I can assure you I did not create it, nor could it have come from a previous version, as paths are totally separate.

There are a number of these falcon files in the datadir though:

falcon_master.fl1
falcon_master.fl2
falcon_master.fts
falcon_temporary.fts
falcon_user.fts

Thanks for clarification.I can repro with noinstall distribution. MSI does not have this problem, but in noinstall-zip at least falcon_master.fts is corrupt.

Workaround for you would be to delete all *.fts, falcon.fl1, falcon.fl2 files from data directory and start mysqld again - these files are created by falcon during the first load

Danny,  There are some corrupted files in the Windows no-install package for 6.0.7.

the corrupted file seems to be a Falcon tablespace made on a big-endian machine.

I downloaded a no-install version of 6.0.10.  No extraneous files existed and mysqld started up fine.

Closing as the bug no longer exists per above feedback.