List:General Discussion« Previous MessageNext Message »
From:Rafał Radecki Date:September 23 2013 10:14pm
Subject:pt-table-checksum: --ignore-tables-regex does not work properly?
View as plain text  
Hi All.

I use:
percona-toolkit-2.2.4-1.noarch
Percona-Server-server-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-shared-compat-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-client-55-5.5.28-rel29.1.335.rhel6.x86_64
Percona-Server-shared-55-5.5.28-rel29.1.335.rhel6.x86_64
on
Centos 6.3 2.6.32-279.14.1.el6.x86_64

I have created checksum table and tried to use --ignore-tables-regex to
remove some tables from checking.

pt-table-checksum --chunk-size-limit=9999 --nocheck-plan --replicate-check
--ignore-tables-regex=^test.s_.*_tmp$
--ignore-tables=test.catalogsearch_fulltext,test.catalogsearch_result,test.report_event,test.report_viewed_product_index,test.z_crawler_log,test.z_logger_debug_ajax,test.z_crawler_queue,test.catalog_category_anc_categs_index_tmp,test.catalog_category_anc_products_index_tmp,test.catalog_category_product_index_enbl_tmp,test.catalog_category_product_index_tmp,test.catalog_product_index_eav_decimal_tmp,test.catalog_product_index_eav_tmp,test.catalog_product_index_price_bundle_opt_tmp,test.catalog_product_index_price_bundle_sel_tmp,test.catalog_product_index_price_bundle_tmp,test.catalog_product_index_price_cfg_opt_agr_tmp,test.catalog_product_index_price_cfg_opt_tmp,test.catalog_product_index_price_downlod_tmp,test.catalog_product_index_price_final_tmp,test.catalog_product_index_price_opt_agr_tmp,test.catalog_product_index_price_opt_tmp,test.catalog_product_index_price_tmp,test.cataloginventory_stock_status_tmp,test.z_I04_data_for_crawler,test.z_import_prices_mdk,test.z_import_prices_sku,test.z_import_translations,test.z_import_translations_model
--recursion-method dsn=h=localhost,D=percona,t=dsns --user=percona
--password=percona --nocheck-replication-filters --databases=test,mysql
localhost

But it does not work, for example table test.s_xxx_tmp gives error message:

09-18T03:10:47 Skipping table test.s_xxx_tmp because it has problems on
these replicas:
Table test.s_xxx_tmp does not exist on replica server.local
This can break replication.  If you understand the risks, specify
--no-check-slave-tables to disable this check.
09-18T03:10:47 Error checksumming table test.s_xxx_tmp: DBD::mysql::db
selectrow_hashref failed: Tab
le 'test.s_xxx_tmp' doesn't exist [for Statement "EXPLAIN SELECT * FROM
`test`.`s_xxx_tmp` WHERE 1=1"] at /usr/bin/pt-table-checksum line 6528.

I've tried --ignore-tables-regex= multiple times:
^test.s_.*_tmp$
'^test.s_.*_tmp$'
^test.s_.\*_tmp$
^test.s_\.\*_tmp$
but without good result. What is the correct syntax in this case?

Best regards,
Rafal Radecki.

Thread
pt-table-checksum: --ignore-tables-regex does not work properly?Rafał Radecki23 Sep