Barracuda page compression fails to back up.

[robzor]

MariaDB 10.1.22

# xtrabackup --version
xtrabackup version 2.4.6 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 8ec05b7)

The table is not corrupt as far as I can see. Queries work as usual. But xtrabackup crasher every time on this table.

xtrabackup --user=xxx --password=xxx --backup --target-dir=/xxx
....
170405 19:14:42 [01] Copying ./xxx/crawler_shop_settings.ibd to /xxx/xxx/crawler_shop_settings.ibd
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
170405 19:14:43 >> log scanned up to (7413012351299)
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./xxx/crawler_shop_settings.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.

SHOW CREATE TABLE crawler_shop_settings:

CREATE TABLE `crawler_shop_settings` (
 `merchant_id` int(11) NOT NULL DEFAULT '0',
 `status` enum('new','active','inactive','testing') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
 `shop_system` enum('unknown','igetweb','readyplanet','tarad','weloveshopping','weloveshopping2','weloveshopping3','lnwshop','shopup','ran4u') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown',
 `shop_system_default` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `use_shop_system_default` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `shop_speed` enum('fast','slow') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'slow',
 `update_crawl` enum('off','daily','weekly') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
 `deep_crawl` enum('off','daily','weekly') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
 `last_update` datetime DEFAULT NULL,
 `comment` text COLLATE utf8_unicode_ci,
 `encoding` enum('utf8','tis') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'tis',
 `force_encoding_to` enum('none','tis_to_utf8') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
 `accept_cookies` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `extended_crawl_timeout` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `prices_include_vat` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT 'yes',
 `base_urls` text COLLATE utf8_unicode_ci,
 `add_base_url_as_it_is` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `cut_endless_urls` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
 `deep_crawl_type` enum('website','sitemap_google') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'website',
 `start_urls` text COLLATE utf8_unicode_ci,
 `test_product_urls` text COLLATE utf8_unicode_ci,
 `strip_urls_after_last_slash` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `pattern_error_urls` text COLLATE utf8_unicode_ci,
 `pattern_next_urls` text COLLATE utf8_unicode_ci,
 `pattern_next_urls_ignore` text COLLATE utf8_unicode_ci,
 `pattern_next_urls_follow` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `start_urls_running_number` int(11) DEFAULT NULL,
 `start_urls_running_number_steps` int(11) NOT NULL DEFAULT '1',
 `pattern_product_url` text COLLATE utf8_unicode_ci,
 `pattern_product_url_ignore` text COLLATE utf8_unicode_ci,
 `pattern_product_url_by_dom` text COLLATE utf8_unicode_ci,
 `pattern_product_url_by_dom_source` enum('href','onclick') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'href',
 `pattern_product_url_follow` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
 `pattern_product_id` text COLLATE utf8_unicode_ci,
 `pattern_name` text COLLATE utf8_unicode_ci,
 `pattern_description` text COLLATE utf8_unicode_ci,
 `pattern_url` text COLLATE utf8_unicode_ci,
 `pattern_price` text COLLATE utf8_unicode_ci,
 `pattern_old_price` text COLLATE utf8_unicode_ci,
 `pattern_category_path` text COLLATE utf8_unicode_ci,
 `pattern_shipping` text COLLATE utf8_unicode_ci,
 `pattern_availability` text COLLATE utf8_unicode_ci,
 `pattern_brand` text COLLATE utf8_unicode_ci,
 `pattern_img` text COLLATE utf8_unicode_ci,
 `pattern_img2` text COLLATE utf8_unicode_ci,
 `pattern_img3` text COLLATE utf8_unicode_ci,
 `pattern_img4` text COLLATE utf8_unicode_ci,
 `pattern_img5` text COLLATE utf8_unicode_ci,
 `pattern_img6` text COLLATE utf8_unicode_ci,
 `pattern_img7` text COLLATE utf8_unicode_ci,
 `pattern_img8` text COLLATE utf8_unicode_ci,
 `pattern_img9` text COLLATE utf8_unicode_ci,
 `timestamp_deep_crawl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `timestamp_update_crawl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`merchant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci `page_compressed`=1

SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like '%crawler_shop%'

TABLE_ID NAME FLAG N_COLS SPACE FILE_FORMAT ROW_FORMAT ZIP_PAGE_SIZE
3930 xxx/crawler_shop_settings 1697 57 3916 Barracuda Dynamic 0
2398 xxx_old/crawler_shop_settings 1697 57 2384 Barracuda Dynamic 0

Note: I have this same table in two databases. xxx and xxx_old.
Strangely the problem started happening when i created the table in xxx. Backing up was fine when the table was only in xxx_old.
The table in xxx_old has page_compression=1 and barracuda as well. Literally copy pasted the same show create table statement... Strange.

[Jericho Rivera (jericho-rivera)]

Marking as confirmed.

170511 07:20:58 >> log scanned up to (1624417)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0
170511 07:20:58 [01] Copying ./ibdata1 to /root/backup/ibdata1
[01] xtrabackup: Page 68 is a doublewrite buffer page, skipping.
[01] xtrabackup: Page 76 is a doublewrite buffer page, skipping.
170511 07:20:58 [01] ...done
170511 07:20:58 [01] Copying ./mysql/innodb_table_stats.ibd to /root/backup/mysql/innodb_table_stats.ibd
170511 07:20:58 [01] ...done
170511 07:20:58 [01] Copying ./mysql/innodb_index_stats.ibd to /root/backup/mysql/innodb_index_stats.ibd
170511 07:20:58 [01] ...done
170511 07:20:58 [01] Copying ./mysql/gtid_slave_pos.ibd to /root/backup/mysql/gtid_slave_pos.ibd
170511 07:20:58 [01] ...done
170511 07:20:58 [01] Copying ./test/t1.ibd to /root/backup/test/t1.ibd
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
170511 07:20:59 >> log scanned up to (1624417)
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Database page corruption detected at page 1, retrying...
[01] xtrabackup: Error: failed to read page after 10 retries. File ./test/t1.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1437