[MDEV-3215] LP:881454 - MariaDB is incompatible with MySQL system tables when changing EVENT_SCHEDULER Created: 2011-10-25  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Vladimir Cvetkov (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug881454.xml    

 Description   

Steps to reproduce:
1. Download MySQL 5.5.x tar.gz file and extract it somewhere
2. Use MySQL to install the database into some directory by using:
cd /path/to/MySQL
./scripts/mysql_install_db --datadir=/path/to/mysql_datadir
3. Download MariaDB 5.3.x tar.gz file and extract it somewhere
4. Start the MariaDB server with the datadir, that you installed MySQL in.
cd /path/to/MariaDB
./bin/mysqld_safe --datadir=/path/to/mysql_datadir &
5. Log into MariaDB
./bin/mysql --user=root
6. Try to execute the following command into SQL:
SET GLOBAL EVENT_SCHEDULER = ON;

Result:
You get the following error: "ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start".



 Comments   
Comment by Elena Stepanova [ 2012-03-26 ]

Re: MariaDB is incompatible with MySQL system tables when changing EVENT_SCHEDULER
While upgrading/crossgrading from MySQL to MariaDB, the usual upgrade instructions given in MySQL manual still apply.

This would resolve the problem with the event scheduler which is caused by the difference in table format between versions.

Comment by Rasmus Johansson (Inactive) [ 2012-03-26 ]

Launchpad bug id: 881454

Generated at Thu Feb 08 06:47:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.