[MDEV-3460] LP:1006625 - FederatedX Engine unavailable in Windows build - JIRA

Details

Type: Bug
Status: Closed
Resolution: Not a Bug
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
- Launchpad

Description

Migrating from MySQL 5.5.8 to MariaDB 5.5.23 (mariadb-5.5.23-win32.zip), I encountered an error starting the database.

C:\m\logs>more mysql.log
120530 13:24:32 InnoDB: The InnoDB memory heap is disabled
120530 13:24:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120530 13:24:32 InnoDB: Compressed tables use zlib 1.2.3
120530 13:24:32 InnoDB: Initializing buffer pool, size = 128.0M
120530 13:24:32 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
120530 13:24:32 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120530 13:24:32 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
120530 13:24:34 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
120530 13:24:35 InnoDB: Waiting for the background threads to start
120530 13:24:36 Percona XtraDB (http://www.percona.com) 1.1.8-24.1 started; log
sequence number 0
120530 13:24:36 [Note] Plugin 'FEEDBACK' is disabled.
120530 13:24:37 [ERROR] C:\m\apps\mysql\bin\mysqld.exe: unknown option '--federated'
120530 13:24:37 [ERROR] Aborting

120530 13:24:37 InnoDB: Starting shutdown...
120530 13:24:37 InnoDB: Shutdown completed; log sequence number 1597945
120530 13:24:37 [Note] C:\m\apps\mysql\bin\mysqld.exe: Shutdown complete

I had to remove the "federated" line from the my.ini to start the database.

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.5.23-MariaDB-log mariadb.org binary distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show engines;
-------------------------------------------------------------------------------------------------------------------------------+

Engine

Support

Comment

Transactions

XA

Savepoints

-------------------------------------------------------------------------------------------------------------------------------+

CSV	YES	CSV storage engine	NO	NO	NO
InnoDB	DEFAULT	Percona-XtraDB, Supports transactions, row-level locking, and foreign keys	YES	YES	YES
MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
MyISAM	YES	MyISAM storage engine	NO	NO	NO
MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
PERFORMANCE_SCHEMA	YES	Performance Schema	NO	NO	NO
Aria	YES	Crash-safe tables with MyISAM heritage	NO	NO	NO

-------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)

MariaDB [(none)]> show plugins;
------------------------------------------------------------------------

Name

Status

Type

Library

License

------------------------------------------------------------------------

binlog	ACTIVE	STORAGE ENGINE	NULL	GPL
mysql_native_password	ACTIVE	AUTHENTICATION	NULL	GPL
mysql_old_password	ACTIVE	AUTHENTICATION	NULL	GPL
CSV	ACTIVE	STORAGE ENGINE	NULL	GPL
MEMORY	ACTIVE	STORAGE ENGINE	NULL	GPL
MyISAM	ACTIVE	STORAGE ENGINE	NULL	GPL
MRG_MYISAM	ACTIVE	STORAGE ENGINE	NULL	GPL
Aria	ACTIVE	STORAGE ENGINE	NULL	GPL
PERFORMANCE_SCHEMA	ACTIVE	STORAGE ENGINE	NULL	GPL
InnoDB	ACTIVE	STORAGE ENGINE	NULL	GPL
INNODB_RSEG	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_TRX	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_LOCKS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_LOCK_WAITS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_CMP	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_CMP_RESET	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_CMPMEM	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_CMPMEM_RESET	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_TABLES	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_TABLESTATS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_INDEXES	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_COLUMNS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_FIELDS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_FOREIGN	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_FOREIGN_COLS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_SYS_STATS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_TABLE_STATS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_INDEX_STATS	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_BUFFER_POOL_PAGES	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_BUFFER_POOL_PAGES_INDEX	ACTIVE	INFORMATION SCHEMA	NULL	GPL
INNODB_BUFFER_POOL_PAGES_BLOB	ACTIVE	INFORMATION SCHEMA	NULL	GPL
XTRADB_ADMIN_COMMAND	ACTIVE	INFORMATION SCHEMA	NULL	GPL
FEEDBACK	DISABLED	INFORMATION SCHEMA	NULL	GPL
partition	ACTIVE	STORAGE ENGINE	NULL	GPL

------------------------------------------------------------------------
34 rows in set (0.00 sec)

The plugin libraries exist in the installation.

C:\m\apps\mysql\lib\plugin>dir
Volume in drive C has no label.
Volume Serial Number is B4BE-3D7D

Directory of C:\m\apps\mysql\lib\plugin

05/30/2012 01:21 PM <DIR> .
05/30/2012 01:21 PM <DIR> ..
05/30/2012 01:21 PM 40,528 adt_null.dll
05/30/2012 01:21 PM 675,840 adt_null.pdb
05/30/2012 01:21 PM 67,152 authentication_windows_client.dll
05/30/2012 01:21 PM 1,298,432 authentication_windows_client.pdb
05/30/2012 01:21 PM 41,552 auth_test_plugin.dll
05/30/2012 01:21 PM 708,608 auth_test_plugin.pdb
05/30/2012 01:21 PM 227 daemon_example.ini
05/30/2012 01:21 PM <DIR> debug
05/30/2012 01:21 PM 56,400 dialog.dll
05/30/2012 01:21 PM 1,077,248 dialog.pdb
05/30/2012 01:21 PM 41,040 dialog_examples.dll
05/30/2012 01:21 PM 692,224 dialog_examples.pdb
05/30/2012 01:21 PM 120,400 ha_archive.dll
05/30/2012 01:21 PM 1,683,456 ha_archive.pdb
05/30/2012 01:21 PM 68,688 ha_blackhole.dll
05/30/2012 01:21 PM 2,060,288 ha_blackhole.pdb
05/30/2012 01:21 PM 69,712 ha_example.dll
05/30/2012 01:21 PM 1,552,384 ha_example.pdb
05/30/2012 01:21 PM 98,384 ha_federated.dll
05/30/2012 01:21 PM 2,363,392 ha_federated.pdb
05/30/2012 01:21 PM 110,160 ha_federatedx.dll
05/30/2012 01:21 PM 2,486,272 ha_federatedx.pdb
05/30/2012 01:21 PM 909,392 ha_innodb.dll
05/30/2012 01:21 PM 5,353,472 ha_innodb.pdb
05/30/2012 01:21 PM 127,568 ha_oqgraph.dll
05/30/2012 01:21 PM 4,239,360 ha_oqgraph.pdb
05/30/2012 01:21 PM 121,424 ha_sphinx.dll
05/30/2012 01:21 PM 2,535,424 ha_sphinx.pdb
05/30/2012 01:21 PM 56,400 libdaemon_example.dll
05/30/2012 01:21 PM 1,077,248 libdaemon_example.pdb
05/30/2012 01:21 PM 43,600 mypluglib.dll
05/30/2012 01:21 PM 806,912 mypluglib.pdb
05/30/2012 01:21 PM 40,528 mysql_clear_password.dll
05/30/2012 01:21 PM 692,224 mysql_clear_password.pdb
05/30/2012 01:21 PM 40,528 qa_auth_client.dll
05/30/2012 01:21 PM 708,608 qa_auth_client.pdb
05/30/2012 01:21 PM 42,064 qa_auth_interface.dll
05/30/2012 01:21 PM 708,608 qa_auth_interface.pdb
05/30/2012 01:21 PM 40,528 qa_auth_server.dll
05/30/2012 01:21 PM 700,416 qa_auth_server.pdb
05/30/2012 01:21 PM 88,656 semisync_master.dll
05/30/2012 01:21 PM 2,297,856 semisync_master.pdb
05/30/2012 01:21 PM 56,912 semisync_slave.dll
05/30/2012 01:21 PM 1,363,968 semisync_slave.pdb
05/30/2012 01:21 PM 66,128 sql_errlog.dll
05/30/2012 01:21 PM 1,257,472 sql_errlog.pdb
45 File(s) 38,687,683 bytes
3 Dir(s) 12,919,373,824 bytes free

Gliffy Diagrams

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

LPexportBug1006625.xml
13 kB
2012-10-03 11:32

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Elena Stepanova added a comment - 2012-05-30 22:33

Re: FederatedX Engine unavailable in Windows build
Hi,

As you have already noticed, FederatedX engine comes with the package as a separate plugin (dynamic library). In order to use it, you need to load the plugin. You can do it either on server startup, by adding plugin-load=ha_federatedx.dll to my.ini or the command line, or by executing INSTALL PLUGIN FEDERATED SONAME 'ha_federatedx.dll' at runtime (you will need to do it once).

See more about installing plugins here: http://kb.askmonty.org/en/install-plugin

Show

Elena Stepanova added a comment - 2012-05-30 22:33 Re: FederatedX Engine unavailable in Windows build Hi, As you have already noticed, FederatedX engine comes with the package as a separate plugin (dynamic library). In order to use it, you need to load the plugin. You can do it either on server startup, by adding plugin-load=ha_federatedx.dll to my.ini or the command line, or by executing INSTALL PLUGIN FEDERATED SONAME 'ha_federatedx.dll' at runtime (you will need to do it once). See more about installing plugins here: http://kb.askmonty.org/en/install-plugin

Hide

Permalink

Rasmus Johansson added a comment - 2012-05-30 22:34

Launchpad bug id: 1006625

Show

Rasmus Johansson added a comment - 2012-05-30 22:34 Launchpad bug id: 1006625

LP:1006625 - FederatedX Engine unavailable in Windows build

Details

Description

Gliffy Diagrams

Attachments

Attachments

Activity

People

Dates

Agile