<p dir="auto">Sharding proxy version 5.1.0</p>
<p dir="auto">Using Python to import data, an error is reported when it reaches one million:<br>
Pymysql is used</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')"><pre class="notranslate"><code class="notranslate">OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')
</code></pre></div>
<p dir="auto">Props configuration information:</p>
<div class="highlight highlight-source-yaml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="proxy-frontend-executor-size: 0
proxy-frontend-flush-threshold: 128
allow.range.query.with.inline.sharding: true
proxy-frontend-max-connections: 0
check-duplicate-table-enabled: false
proxy-backend-query-fetch-size: -1
kernel-executor-size: 16
show-process-list-enabled: false
proxy-backend-executor-suitable: OLAP
proxy-hint-enabled: false
sql-show: true
proxy-opentracing-enabled: false
sql-federation-enabled: false
max-connections-size-per-query: 1
check-table-metadata-enabled: false"><pre class="notranslate"><span class="pl-ent">proxy-frontend-executor-size</span>: <span class="pl-c1">0</span>
<span class="pl-ent">proxy-frontend-flush-threshold</span>: <span class="pl-c1">128</span>
<span class="pl-ent">allow.range.query.with.inline.sharding</span>: <span class="pl-c1">true</span>
<span class="pl-ent">proxy-frontend-max-connections</span>: <span class="pl-c1">0</span>
<span class="pl-ent">check-duplicate-table-enabled</span>: <span class="pl-c1">false</span>
<span class="pl-ent">proxy-backend-query-fetch-size</span>: <span class="pl-c1">-1</span>
<span class="pl-ent">kernel-executor-size</span>: <span class="pl-c1">16</span>
<span class="pl-ent">show-process-list-enabled</span>: <span class="pl-c1">false</span>
<span class="pl-ent">proxy-backend-executor-suitable</span>: <span class="pl-s">OLAP</span>
<span class="pl-ent">proxy-hint-enabled</span>: <span class="pl-c1">false</span>
<span class="pl-ent">sql-show</span>: <span class="pl-c1">true</span>
<span class="pl-ent">proxy-opentracing-enabled</span>: <span class="pl-c1">false</span>
<span class="pl-ent">sql-federation-enabled</span>: <span class="pl-c1">false</span>
<span class="pl-ent">max-connections-size-per-query</span>: <span class="pl-c1">1</span>
<span class="pl-ent">check-table-metadata-enabled</span>: <span class="pl-c1">false</span></pre></div>
<p dir="auto">Rules configuration:</p>
<div class="highlight highlight-source-yaml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="- !SHARDING
  keyGenerators:
    csys_build_demand_sx61_snowflake:
      type: snowflake
    csys_company_demand_sx61_snowflake:
      type: snowflake
  tables:
    csys_build_demand_sx61:
      actualDataNodes: ds_0.csys_build_demand_sx61
      keyGenerateStrategy:
        column: id
        keyGeneratorName: csys_build_demand_sx61_snowflake
      logicTable: csys_build_demand_sx61
    csys_company_demand_sx61:
      actualDataNodes: ds_0.csys_company_demand_sx61
      keyGenerateStrategy:
        column: id
        keyGeneratorName: csys_company_demand_sx61_snowflake
      logicTable: csys_company_demand_sx61
"><pre class="notranslate">- <span class="pl-k">!SHARDING</span>
  <span class="pl-ent">keyGenerators</span>:
    <span class="pl-ent">csys_build_demand_sx61_snowflake</span>:
      <span class="pl-ent">type</span>: <span class="pl-s">snowflake</span>
    <span class="pl-ent">csys_company_demand_sx61_snowflake</span>:
      <span class="pl-ent">type</span>: <span class="pl-s">snowflake</span>
  <span class="pl-ent">tables</span>:
    <span class="pl-ent">csys_build_demand_sx61</span>:
      <span class="pl-ent">actualDataNodes</span>: <span class="pl-s">ds_0.csys_build_demand_sx61</span>
      <span class="pl-ent">keyGenerateStrategy</span>:
        <span class="pl-ent">column</span>: <span class="pl-s">id</span>
        <span class="pl-ent">keyGeneratorName</span>: <span class="pl-s">csys_build_demand_sx61_snowflake</span>
      <span class="pl-ent">logicTable</span>: <span class="pl-s">csys_build_demand_sx61</span>
    <span class="pl-ent">csys_company_demand_sx61</span>:
      <span class="pl-ent">actualDataNodes</span>: <span class="pl-s">ds_0.csys_company_demand_sx61</span>
      <span class="pl-ent">keyGenerateStrategy</span>:
        <span class="pl-ent">column</span>: <span class="pl-s">id</span>
        <span class="pl-ent">keyGeneratorName</span>: <span class="pl-s">csys_company_demand_sx61_snowflake</span>
      <span class="pl-ent">logicTable</span>: <span class="pl-s">csys_company_demand_sx61</span>
</pre></div>
<p dir="auto">TODO:</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Fix BaseIT.createTables:131 exception, support keyword table name for different databases (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="680804118" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/6912" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/6912/hovercard" href="https://github.com/apache/shardingsphere/issues/6912">#6912</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Fix BaseIT.createDatabases:121 exception, databases not cleaned by previous BaseIT (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="680804118" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/6912" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/6912/hovercard" href="https://github.com/apache/shardingsphere/issues/6912">#6912</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Current PostgreSQL login user's password is changed by DCL test (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="681902837" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/6943" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/6943/hovercard" href="https://github.com/apache/shardingsphere/issues/6943">#6943</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Remove duplicated test case (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="683321698" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/6962" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/6962/hovercard" href="https://github.com/apache/shardingsphere/pull/6962">#6962</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> DQL dataset select_count_tilde_concat.xml not found cause GeneralDQLIT.assertExecuteQuery failed (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="684185999" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7007" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7007/hovercard" href="https://github.com/apache/shardingsphere/issues/7007">#7007</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> PostgreSQL dedicated column missed in t_order cause GeneralDQLIT.assertExecuteQuery failed (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="684195259" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7010" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7010/hovercard" href="https://github.com/apache/shardingsphere/issues/7010">#7010</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Print exception context for engine (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="684122548" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7005" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7005/hovercard" href="https://github.com/apache/shardingsphere/pull/7005">#7005</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Integration test of PostgreSQL failed to drop database (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="689037866" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7174" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7174/hovercard" href="https://github.com/apache/shardingsphere/issues/7174">#7174</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> LockSegment absent of PostgreSQL parser (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690001325" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7200" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7200/hovercard" href="https://github.com/apache/shardingsphere/issues/7200">#7200</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Unexpected SELECT DISTINCT result (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690013368" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7201" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7201/hovercard" href="https://github.com/apache/shardingsphere/issues/7201">#7201</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> remove unexpected error log (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690259258" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7205" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7205/hovercard" href="https://github.com/apache/shardingsphere/pull/7205">#7205</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> assertRows failed in PostgreSQL DML integration test (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690234574" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7204" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7204/hovercard" href="https://github.com/apache/shardingsphere/issues/7204">#7204</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> INSERT...RETURING statement failed in PostgreSQL DML integration test (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690280403" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7207" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7207/hovercard" href="https://github.com/apache/shardingsphere/issues/7207">#7207</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> DROP ROLE/USER throws Exception for all database types (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690691433" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7215" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7215/hovercard" href="https://github.com/apache/shardingsphere/pull/7215">#7215</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Failure test cases of DCL for PostgreSQL (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="690797316" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7224" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7224/hovercard" href="https://github.com/apache/shardingsphere/pull/7224">#7224</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Failure test cases of DCL for PostgreSQL 1 (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="691043336" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7230" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7230/hovercard" href="https://github.com/apache/shardingsphere/pull/7230">#7230</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] remove unnecessary clear procedure (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="692995738" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7254" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7254/hovercard" href="https://github.com/apache/shardingsphere/pull/7254">#7254</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] concurrent truncate (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="695131112" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7300" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7300/hovercard" href="https://github.com/apache/shardingsphere/pull/7300">#7300</a> , <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="695272993" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7305" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7305/hovercard" href="https://github.com/apache/shardingsphere/pull/7305">#7305</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] do not close thread pool for each test (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="695673177" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7327" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7327/hovercard" href="https://github.com/apache/shardingsphere/pull/7327">#7327</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] use delete instead of truncate to improve performance (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="695857826" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7333" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7333/hovercard" href="https://github.com/apache/shardingsphere/pull/7333">#7333</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] remove connection test <code class="notranslate">SELECT 1</code> to improve performance (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="695892984" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7334" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7334/hovercard" href="https://github.com/apache/shardingsphere/pull/7334">#7334</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> [Improve Performance] concurrent insert (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="696672054" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7356" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7356/hovercard" href="https://github.com/apache/shardingsphere/pull/7356">#7356</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> add PostgreSQL default pwd (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="696812860" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7364" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7364/hovercard" href="https://github.com/apache/shardingsphere/pull/7364">#7364</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> add dataset (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="696832162" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7365" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7365/hovercard" href="https://github.com/apache/shardingsphere/pull/7365">#7365</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> add log for BatchIT (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="697640974" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7382" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/7382/hovercard" href="https://github.com/apache/shardingsphere/pull/7382">#7382</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> INSERT...RETURNING test cases failed of BatchDMLIT (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="698781421" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7398" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7398/hovercard" href="https://github.com/apache/shardingsphere/issues/7398">#7398</a>)</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Unexpected failed test cases of PostgreSQL DQL test cases (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="702582439" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/7481" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/7481/hovercard" href="https://github.com/apache/shardingsphere/issues/7481">#7481</a>)</li>
</ul>
<h2 dir="auto">Bug Report</h2>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">master branch, 5.0.0-RC1-SNAPSHOT</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Integration test using PostgreSQL instead of H2. Expect real test cases could run.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">BaseXyzIT @BeforeClass and <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/afterclass/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/afterclass">@afterclass</a> method thrown exception.</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<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, env.properties:<br>
databases=PostgreSQL<br>
postgresql.host=127.0.0.1 (suppose your PostgreSQL is on localhost)<br>
postgresql.password=test</p>
<p dir="auto">2, go to shardingsphere-test-suite module</p>
<p dir="auto">3, mvn clean install</p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="[INFO] Running org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT
[INFO ] 15:57:37.967 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:57:37.979 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 3760, Active: PostgreSQL(1664), Disabled: MySQL(416), Oracle(832), SQLServer(848)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 39.665 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dcl.GeneralDC
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT  Time elapsed: 39.664 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException:
org.postgresql.util.PSQLException: ERROR: syntax error at or near &quot;`&quot;
  位置：15
Caused by: org.postgresql.util.PSQLException:
ERROR: syntax error at or near &quot;`&quot;
  位置：15

[INFO] Running org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] Total: 0, Active: 0, Disabled: 0

[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 s - in org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 s - in org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 832, Active: PostgreSQL(144), Disabled: H2(152), MySQL(240), Oracle(160)
, SQLServer(136)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.144 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.BatchDMLI
T
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT  Time elapsed: 40.144 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 1936, Active: PostgreSQL(336), Disabled: H2(352), MySQL(560), Oracle(368
), SQLServer(320)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.279 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.GeneralDM
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT  Time elapsed: 40.279 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 s - in org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 6752, Active: PostgreSQL(1328), Disabled: H2(1312), MySQL(1664), Oracle(
1232), SQLServer(1216)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 42.819 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dql.GeneralDQ
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT  Time elapsed: 42.819 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database &quot;db_0&quot; already exists

[INFO]
[INFO] Results:
[INFO]
[ERROR] Errors: 
[ERROR]   GeneralDCLIT&gt;BaseDCLIT.initDatabasesAndTables:100-&gt;BaseIT.createDatabasesAndTables:109-&gt;BaseIT.createTables:131 ? Runtime
[ERROR]   BatchDMLIT&gt;BatchIT.initDatabasesAndTables:85-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[ERROR]   GeneralDMLIT&gt;BaseDMLIT.initDatabasesAndTables:68-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[ERROR]   GeneralDQLIT&gt;BaseDQLIT.insertData:68-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[INFO]
[ERROR] Tests run: 4, Failures: 0, Errors: 4, Skipped: 0"><pre class="notranslate"><code class="notranslate">[INFO] Running org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT
[INFO ] 15:57:37.967 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:57:37.979 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 3760, Active: PostgreSQL(1664), Disabled: MySQL(416), Oracle(832), SQLServer(848)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 39.665 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dcl.GeneralDC
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT  Time elapsed: 39.664 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
  位置：15
Caused by: org.postgresql.util.PSQLException:
ERROR: syntax error at or near "`"
  位置：15

[INFO] Running org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] Total: 0, Active: 0, Disabled: 0

[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 s - in org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 s - in org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 832, Active: PostgreSQL(144), Disabled: H2(152), MySQL(240), Oracle(160)
, SQLServer(136)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.144 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.BatchDMLI
T
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT  Time elapsed: 40.144 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 1936, Active: PostgreSQL(336), Disabled: H2(352), MySQL(560), Oracle(368
), SQLServer(320)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.279 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.GeneralDM
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT  Time elapsed: 40.279 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 s - in org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 6752, Active: PostgreSQL(1328), Disabled: H2(1312), MySQL(1664), Oracle(
1232), SQLServer(1216)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 42.819 s &lt;&lt;&lt; FAILURE! - in org.apache.shardingsphere.dbtest.engine.dql.GeneralDQ
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT  Time elapsed: 42.819 s  &lt;&lt;&lt; ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO]
[INFO] Results:
[INFO]
[ERROR] Errors: 
[ERROR]   GeneralDCLIT&gt;BaseDCLIT.initDatabasesAndTables:100-&gt;BaseIT.createDatabasesAndTables:109-&gt;BaseIT.createTables:131 ? Runtime
[ERROR]   BatchDMLIT&gt;BatchIT.initDatabasesAndTables:85-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[ERROR]   GeneralDMLIT&gt;BaseDMLIT.initDatabasesAndTables:68-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[ERROR]   GeneralDQLIT&gt;BaseDQLIT.insertData:68-&gt;BaseIT.createDatabasesAndTables:107-&gt;BaseIT.createDatabases:121 ? Runtime
[INFO]
[ERROR] Tests run: 4, Failures: 0, Errors: 4, Skipped: 0
</code></pre></div>