<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<ul dir="auto">
<li>ShardingSphere-Proxy 5.1.1.</li>
<li>mysql 8.0.25</li>
</ul>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Execute all sql code</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Some of them will be ignored</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">Asynchronous problem</p>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<p dir="auto">1.write sharding rules (distsql) and save a file.<br>
2. login mysql.<br>
3. create database and use it.<br>
4. input command:</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="source [file path]"><pre class="notranslate">source [file <span class="pl-k">path</span>]</pre></div>
<p dir="auto">5.View the created sharding rules</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content=" show sharding table rules;"><pre class="notranslate"> show sharding table rules;</pre></div>
<p dir="auto">You will find that some rules are not created successfully.</p>
<p dir="auto">6.Add code between rules creation</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="The select sleep (0.1);"><pre class="notranslate">The <span class="pl-k">select</span> sleep (<span class="pl-c1">0</span>.<span class="pl-c1">1</span>);</pre></div>
<p dir="auto">Repeating the above process solves the problem</p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto">The files that need to be executed are as follows</p>
<div class="highlight highlight-source-sql notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="ADD RESOURCE test_0 (
    HOST=127.0.0.1,
    PORT=3306,
    DB=test_0,
    USER=root,
    PASSWORD=root
),test_1 (
    HOST=127.0.0.1,
    PORT=3306,
    DB=test_1,
    USER=root,
    PASSWORD=root
);

CREATE DEFAULT SINGLE TABLE RULE RESOURCE = test_0;

CREATE SHARDING TABLE RULE test1 (
DATANODES(&quot;test_${0..1}.test1&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);

CREATE SHARDING TABLE RULE test2 (
DATANODES(&quot;test_${0..1}.test2&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);

CREATE SHARDING TABLE RULE test3(
DATANODES(&quot;test_${0..1}.test3&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);

CREATE SHARDING TABLE RULE test4 (
DATANODES(&quot;test_${0..1}.test4&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);

CREATE SHARDING TABLE RULE test5 (
DATANODES(&quot;test_${0..1}.test5&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);

CREATE SHARDING TABLE RULE test6 (
DATANODES(&quot;test_${0..1}.test6&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);
CREATE SHARDING TABLE RULE test7 (
DATANODES(&quot;test_${0..1}.test7&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);
CREATE SHARDING TABLE RULE test8 (
DATANODES(&quot;test_${0..1}.test8&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);
CREATE SHARDING TABLE RULE test9 (
DATANODES(&quot;test_${0..1}.test9&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);
CREATE SHARDING TABLE RULE test10 (
DATANODES(&quot;test_${0..1}.test10&quot;),
DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES(&quot;sharding-ranges&quot;=20001))))
);"><pre class="notranslate">ADD RESOURCE test_0 (
    HOST<span class="pl-k">=</span><span class="pl-c1">127</span>.<span class="pl-c1">0</span>.<span class="pl-c1">0</span>.<span class="pl-c1">1</span>,
    PORT<span class="pl-k">=</span><span class="pl-c1">3306</span>,
    DB<span class="pl-k">=</span>test_0,
    USER<span class="pl-k">=</span>root,
    PASSWORD<span class="pl-k">=</span>root
),test_1 (
    HOST<span class="pl-k">=</span><span class="pl-c1">127</span>.<span class="pl-c1">0</span>.<span class="pl-c1">0</span>.<span class="pl-c1">1</span>,
    PORT<span class="pl-k">=</span><span class="pl-c1">3306</span>,
    DB<span class="pl-k">=</span>test_1,
    USER<span class="pl-k">=</span>root,
    PASSWORD<span class="pl-k">=</span>root
);

CREATE DEFAULT SINGLE TABLE RULE RESOURCE <span class="pl-k">=</span> test_0;

CREATE SHARDING TABLE RULE test1 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test1<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);

CREATE SHARDING TABLE RULE test2 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test2<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);

CREATE SHARDING TABLE RULE test3(
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test3<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);

CREATE SHARDING TABLE RULE test4 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test4<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);

CREATE SHARDING TABLE RULE test5 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test5<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);

CREATE SHARDING TABLE RULE test6 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test6<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);
CREATE SHARDING TABLE RULE test7 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test7<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);
CREATE SHARDING TABLE RULE test8 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test8<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);
CREATE SHARDING TABLE RULE test9 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test9<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);
CREATE SHARDING TABLE RULE test10 (
DATANODES(<span class="pl-s"><span class="pl-pds">"</span>test_${0..1}.test10<span class="pl-pds">"</span></span>),
DATABASE_STRATEGY(TYPE<span class="pl-k">=</span>standard,SHARDING_COLUMN<span class="pl-k">=</span>PlayerID,SHARDING_ALGORITHM(TYPE(NAME<span class="pl-k">=</span>BOUNDARY_RANGE,PROPERTIES(<span class="pl-s"><span class="pl-pds">"</span>sharding-ranges<span class="pl-pds">"</span></span><span class="pl-k">=</span><span class="pl-c1">20001</span>))))
);</pre></div>
<p dir="auto">There are 7000 tables in the test target library, and the default value will start slowly, and the high setting value will lead to the soaring cpu and iops of the database</p>