search

danielcheng007 / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 0 forks source link

xtrabackup fails if MySQL is running 5.1 with built-in innodb #671

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

1. install Tungsten using MySQL 5.1.70, and xtrabackup as default backup agent
2.  run a backup

What is the expected output?

backup succeeds

What do you see instead?

xtrabackup fails with this error:

"Error: Support for MySQL 5.1 with builtin InnoDB (not the plugin) was removed 
in Percona XtraBackup 2.1. The last version to support MySQL 5.1 with builtin 
InnoDB was Percona XtraBackup 2.0. at /usr/bin/innobackupex-1.5.1 line 389."

What is the possible cause?

there is no check for the above failure cause

What is the proposed solution?

the installer should check if xtrabackup  and innodb versions are compatible

show variables like 'innodb_version';

This query returns an empty set in MySQL without innodb plugin, and a valid 
plugin version otherwise.

Original issue reported on code.google.com by g.maxia on 16 Aug 2013 at 5:07

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 26 Aug 2013 at 1:54

GoogleCodeExporter commented 9 years ago

Original comment by jeff.m...@continuent.com on 13 Sep 2013 at 7:22

GoogleCodeExporter commented 9 years ago 
There won't be a 2.1.3.

Original comment by linas.vi...@continuent.com on 17 Sep 2013 at 10:13

GoogleCodeExporter commented 9 years ago 
Tested OK. Now prevents validation for 5.1 without the InnoDB plugin.

Original comment by eric.st...@continuent.com on 2 Dec 2013 at 2:40

GoogleCodeExporter commented 9 years ago

Original comment by g.maxia on 6 Dec 2013 at 10:55

GoogleCodeExporter commented 9 years ago 
An entry has been added to the 2.2.0 release notes: 

 During installation, tpm would fail to check the version for Percona Xtrabackup when working with built-in InnoDB support in MySQL. The check has now been updated and validation will fail if Xtrabackup 2.1 or later is used with a MySQL 5.1 and builtin InnoDB support.

Original comment by mc.br...@continuent.com on 16 Dec 2013 at 12:01