expect select for global table send to the still available dataNode if some dataNodes could not be reached

[irene-coming]

[FlyingMao]

version
5.6.29-dble-9.9.9.9-98c4cdf-20180821012809
config
schema.xml

<!DOCTYPE dble:schema SYSTEM "schema.dtd">
<dble:schema xmlns:dble="http://dble.cloud/">
    <schema name="mytest" sqlMaxLimit="100" dataNode="dn1">
        <table name="test_shard" dataNode="dn1,dn2,dn3,dn4" rule="mod-long"/>
        <table name="sbtest2" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="a_test" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="a_order" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="a_manager" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="test_global" dataNode="dn1,dn2,dn3,dn4" type="global"/>
        <table name="global_table2" dataNode="dn1,dn2,dn3,dn4" type="global"/>
        <table name="global_table3" dataNode="dn1,dn2,dn3,dn4" type="global"/>
        <table name="mytest_auto_test1" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="R_REGIONKEY" autoIncrement="true"/>
        <table name="auto_table" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id" autoIncrement="true"/>
        <table name="sbtest1" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="aly_test" dataNode="dn1,dn2,dn3,dn4" rule="orderID"/>
        <table name="aly_test1" dataNode="dn1,dn2,dn3,dn4" rule="orderID"/>
        <table name="aly_order" dataNode="dn1,dn2,dn3,dn4" rule="orderID"/>
        <table name="aly_order1" dataNode="dn1,dn2,dn3,dn4" rule="orderID"/>
        <table name="a_two" dataNode="dn1,dn2" rule="hash-two" primaryKey="id"/>
        <table name="a_three" dataNode="dn1,dn2,dn3" rule="hash-three" primaryKey="id"/>
    </schema>
    <schema name="test" sqlMaxLimit="100" dataNode="dn1">
        <table name="test_db1" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
        <table name="test_db2" dataNode="dn1,dn2,dn3,dn4" rule="mod-long" primaryKey="id"/>
    </schema>
    <dataNode name="dn1" dataHost="10.186.24.45" database="db1"/>
    <dataNode name="dn2" dataHost="10.186.24.46" database="db1"/>
    <dataNode name="dn3" dataHost="10.186.24.45" database="db2"/>
    <dataNode name="dn4" dataHost="10.186.24.46" database="db2"/>
    <dataHost balance="0" maxCon="1000" minCon="10" name="10.186.24.45" switchType="2" slaveThreshold="100">
        <heartbeat>show slave status</heartbeat>
        <writeHost host="hostM1" url="10.186.24.45:3306" password="test" user="test">
<!--            <readHost host="hostS1" url="10.186.24.44:3306" password="test" user="test"/> -->
        </writeHost>
    </dataHost>
    <dataHost balance="0" maxCon="1000" minCon="10" name="10.186.24.46" switchType="2" slaveThreshold="100">
        <heartbeat>show slave status</heartbeat>
        <writeHost host="hostW1" url="10.186.24.46:3306" password="test" user="test"/>
    </dataHost>
</dble:schema>

rule.xml

<!DOCTYPE dble:rule SYSTEM "rule.dtd">
<dble:rule xmlns:dble="http://dble.cloud/">
    <tableRule name="mod-long">
        <rule>
            <columns>id</columns>
            <algorithm>sharding</algorithm>
        </rule>
    </tableRule>
    <tableRule name="orderID">
        <rule>
            <columns>id</columns>
            <algorithm>sharding</algorithm>
        </rule>
    </tableRule>
    <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>
    <function name="sharding" class="Hash">
        <property name="partitionCount">4</property>
        <property name="partitionLength">1</property>
    </function>
    <function name="two-long" class="Hash">
        <property name="partitionCount">2</property>
        <property name="partitionLength">1</property>
    </function>
    <function name="three-long" class="Hash">
        <property name="partitionCount">3</property>
        <property name="partitionLength">1</property>
    </function>
</dble:rule>

server.xml

<!DOCTYPE dble:server SYSTEM "server.dtd">
<dble:server xmlns:dble="http://dble.cloud/">
    <system>
        <property name="defaultSqlParser">druidparser</property>
        <property name="useGlobleTableCheck">1</property>
        <property name="dataNodeHeartbeatPeriod">1000</property>
        <property name="sqlExecuteTimeout">1000</property>
        <property name="recordTxn">1</property>
        <property name="xaRecoveryLogBaseDir">/opt/dble/tmlogs/</property>
        <property name="xaRecoveryLogBaseName">xalog</property>
        <property name="xaSessionCheckPeriod">2000</property>
        <property name="xaLogCleanPeriod">100000</property>
        <property name="processors">1</property>
        <property name="processorExecutor">1</property>
        <property name="sequnceHandlerType">2</property>
    </system>
    <firewall/>
    <user name="test">
        <property name="password">test</property>
        <property name="schemas">mytest,test</property>
         <property name="maxCon">0</property>
    </user>
    <user name="root">
        <property name="password">123456</property>
        <property name="manager">true</property>
    </user>
</dble:server>

steps
1.stop 10.186.24.46:3306 mysql server
2. execute select in dble

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.01 sec)

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.01 sec)

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.00 sec)

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.01 sec)

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.01 sec)

mysql>  select * from test_global;
+----+------------+---------------+
| id | name       | _dble_op_time |
+----+------------+---------------+
|  1 | actiontech | 1533526245718 |
+----+------------+---------------+
1 row in set (0.00 sec)

mysql>  select * from test_shard;
ERROR 3009 (HY000): java.io.IOException: the data source[10.186.24.46:3306] can't reached, please check the dataHost

[FlyingMao]

verified version: 5.6.29-dble-9.9.9.9-98c4cdf-20180821012809