|
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
|
LPexportBug1006625.xml