Skip to content

tableStructureCheckTask does not work properly #1098

@sunsun314

Description

@sunsun314
  • dble version: 2.19.01.0/rel
  • preconditions :
    1.server.xml:
<property name="checkTableConsistency">1</property>
<property name="checkTableConsistencyPeriod">10000</property>
  1. prepare table
create table test1(id int,name char(20));
  • configs:
    schema.xml
    <schema name="TESTDB" sqlMaxLimit="100" dataNode="dn1">
    	  <table name="testxxx" dataNode="dn3"/>
        <table name="test1" dataNode="dn1,dn2,dn3,dn4" rule="hash-four"/>
    </schema>
  • steps:
  1. start dble with config

2.change test1 in one of the backend node in mysql

alter table test1 drop name;
  1. check dble.log
  • expect result:
    dble.log contain:
     + Table [" + tableName + "] structure are not consistent in different data node!
     + Table [" + tableMeta.getTableName() + "] are modified by other,Please Check IT!
  • real result:
    dble.log contain:
    + Table [" + tableMeta.getTableName() + "] are modified by other,Please Check IT!

/label ~BUG

Metadata

Metadata

Assignees

Labels

metadataresolveproblem has been fixed by developer

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions