Percona XtraBackup moved to https://jira.percona.com/projects/PXB

  1. Bug #1535312
  2. Comment #4

Comment 4 for bug 1535312

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote : Re: Failed to prepare incremental backup if page size of general tablespace has changed between backups

Also tested with outside datadir using XB 3.3 and PS 5.6.28:
1.
CREATE TABLE `sbtest1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
)

2. Full backup
3. drop table
4.
CREATE TABLE `sbtest1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/var/lib/mysql_binary_logs/'
5. Incremental backup
6. Prepare:

InnoDB: Shutdown completed; log sequence number 4295293974
160127 11:29:06 completed OK!