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

[15 Oct 2008 12:55] Chris Calender
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
[15 Oct 2008 17:22] Vladislav Vaintroub
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?
[15 Oct 2008 17:44] Ann Harrison
The error suggests that a file called falcon_master.fts exists, but was
not created by falcon.
[15 Oct 2008 18:28] Chris Calender
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
[15 Oct 2008 19:49] Vladislav Vaintroub
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
[15 Oct 2008 20:17] Kevin Lewis
Danny,  There are some corrupted files in the Windows no-install package for 6.0.7.
[15 Oct 2008 22:33] Vladislav Vaintroub
the corrupted file seems to be a Falcon tablespace made on a big-endian machine.
[25 Mar 2009 19:01] Chris Calender
I downloaded a no-install version of 6.0.10.  No extraneous files existed and mysqld started up fine.
[14 Apr 2009 12:30] Daniel Fischer
Closing as the bug no longer exists per above feedback.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.060 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.