[check_postgres] same_schema check is failing on 2.15.4, but worked fine on 2.14.3

Aleksey Tsalolikhin atsaloli.tech at gmail.com
Tue Jan 4 20:43:06 UTC 2011


I have a couple of Slony replication sets, and use same_schema action
to check against corruption on the slave.

My Slony replication sets have "_cluster" in the name, so I filter out
the Slony bits as follows:

/usr/bin/check_postgres.pl-2.14.3 --verbose --action same_schema
-dbhost=db1 --dbhost2=db2 --dbname=mydbname --warning='noposition
noschema=_cluster notrigger=_cluster nofunction=_cluster'

POSTGRES_SAME_SCHEMA OK: DB "mydbname" (host:db1 => db22) Both
databases have identical items | time=0.01


However, 2.15.4 reports the same_schema check as CRITICAL:


POSTGRES_SAME_SCHEMA CRITICAL: DB "mydbname" (host:db1 => db2)
Databases were different. Items not matched: 21 | time=0.01
Index on 1 but not 2:
"_mydbname_app00_cluster"."PartInd_mydbname_app00_cluster_sl_log_1-node-1"
ON
 Index on 1 but not 2:
"_mydbname_app00_cluster"."PartInd_mydbname_app00_cluster_sl_log_2-node-1"
ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_event-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_listen-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_node-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_nodelock-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_path-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_sequence-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_set-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_setsync-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_subscribe-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_table-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster"."sl_trigger-pkey" ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_confirm_idx1 ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_confirm_idx2 ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_log_1_idx1 ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_log_2_idx1 ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_registry_pkey ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_seqlog_idx ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_sequence_seq_reloid_key ON
 Index on 1 but not 2: "_mydbname_app00_cluster".sl_table_tab_reloid_key ON

I've tried adding "noindex=_cluster" to the warning but I still get
the same output.

I've had to fall back on 2.14.3 for the same_schema check for now, but
could you please
help me get this working with 2.15.4?

Best,
-at


More information about the Check_postgres mailing list