Skip to content

Initialization data is randomly stuck #660

@sunsun314

Description

@sunsun314
  • dble version: 07.2
  • preconditions :
    no
  • configs:

server.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE dble:server SYSTEM "server.dtd"><dble:server xmlns:dble="http://dble.cloud/">
	<system>
                <property name="backendProcessorExecutor">2</property>
	</system>
	
	<user name="test">
		<property name="password">111111</property>
		<property name="schemas">mytest</property>
	</user>
	<user name="root">
		<property name="password">111111</property>
		<property name="manager">true</property>
	</user>

</dble:server>

rule.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE dble:rule SYSTEM "rule.dtd"><dble:rule xmlns:dble="http://dble.cloud/">
	<tableRule name="hash-two">
        <rule>
            <columns>id</columns>
            <algorithm>two-long</algorithm>
        </rule>
    </tableRule>
    <tableRule name="hash-three">
        <rule>
            <columns>id</columns>
            <algorithm>three-long</algorithm>
        </rule>
    </tableRule>
	<tableRule name="hash-four">
        <rule>
            <columns>id</columns>
            <algorithm>four-long</algorithm>
        </rule>
    </tableRule>
    <function class="Hash" name="two-long">
        <property name="partitionCount">2</property>
        <property name="partitionLength">1</property>
    </function>
    <function class="Hash" name="three-long">
        <property name="partitionCount">3</property>
        <property name="partitionLength">1</property>
    </function>
	<function class="Hash" name="four-long">
		<property name="partitionCount">4</property>
		<property name="partitionLength">1</property>
	</function>
</dble:rule>

schema.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE dble:schema SYSTEM "schema.dtd"><dble:schema xmlns:dble="http://dble.cloud/">
    <schema dataNode="dn1" name="mytest" sqlMaxLimit="100">
        <table dataNode="dn1,dn2,dn3,dn4" name="test_shard" rule="hash-four" />
    </schema>

    <dataNode dataHost="172.100.9.5" database="db1" name="dn1" />
    <dataNode dataHost="172.100.9.5" database="db2" name="dn2" />
    <dataNode dataHost="172.100.9.5" database="db3" name="dn3" />
    <dataNode dataHost="172.100.9.5" database="db4" name="dn4" />

    <dataHost balance="0" maxCon="1000" minCon="10" name="172.100.9.5" slaveThreshold="100" switchType="2">
        <heartbeat>show slave status</heartbeat>
        <writeHost host="hostM1" password="111111" url="172.100.9.5:3306" user="test">
        </writeHost>
    </dataHost>

    <dataHost balance="0" maxCon="1000" minCon="10" name="172.100.9.6" slaveThreshold="100" switchType="1">
        <heartbeat>select user()</heartbeat>
        <writeHost host="hostM2" password="111111" url="172.100.9.6:3306" user="test">
        </writeHost>
    </dataHost>
</dble:schema>


  • steps:
    restart or reload dble
  • expect result:
    Init meta success
  • real result:
    May stuck forever

/label ~BUG

Metadata

Metadata

Assignees

Labels

Priority/Highexpect fix as quickly as possiblemetadataresolveproblem has been fixed by developerverifiedissue's resolve was verified by tester

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions