You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/28 06:03:18 UTC
[GitHub] [shardingsphere] TeslaCN edited a comment on issue #10273: FATAL occurred while sysbenching PostgreSQL Proxy
TeslaCN edited a comment on issue #10273:
URL: https://github.com/apache/shardingsphere/issues/10273#issuecomment-850155521
I set `show-sql: true`, and found that the sysbench 2 threads tried inserting a same ID into the same table. By default, rollback operation is required if PostgreSQL transaction failed, otherwise the connection cannot be reused.
Excerpts:
```
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest1_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [65310, 7251, 93847948159-56520742220-70586357454-56911996478-12159943845-97322626570-06036943090-97656602887-48189845161-91542226453, 91966421261-48544767667-06177513291-76980956700-61058974819]
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest1_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [65310, 33233, 44807380510-54536505615-69866152668-30351469864-09534268897-54304069962-38597575385-98175037014-31378215658-44059277993, 78215202645-43165945497-43859810388-01105995155-63760357752]
[ERROR] 2021-05-28 13:29:06.206 [pool-33-thread-1] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sbtest1_0_pkey"
Detail: Key (id)=(65310) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.impl.ProxyPreparedStatementExecutorCallback.execute(ProxyPreparedStatementExecutorCallback.java:41)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:73)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:66)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:44)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:85)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:64)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:101)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.serialExecute(ExecutorEngine.java:87)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:81)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:65)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.ProxyJDBCExecutor.execute(ProxyJDBCExecutor.java:64)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.useDriverToExecute(ProxySQLExecutor.java:165)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:124)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:113)
at org.apache.shardingsphere.proxy.backend.communication.ProxyLockEngine.doExecute(ProxyLockEngine.java:103)
at org.apache.shardingsphere.proxy.backend.communication.ProxyLockEngine.execute(ProxyLockEngine.java:81)
at org.apache.shardingsphere.proxy.backend.communication.DatabaseCommunicationEngine.execute(DatabaseCommunicationEngine.java:98)
at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.binary.bind.PostgreSQLComBindExecutor.execute(PostgreSQLComBindExecutor.java:100)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:93)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:71)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
```
<details>
<summary>Click here for more logs</summary>
<pre><code>
[INFO ] 2021-05-28 13:29:06.181 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.181 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.181 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest2_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [16606, 97138, 86759648792-68298594882-78664686102-39466490337-44642722925-21868359667-85549716969-60517970344-16339816513-22988835563, 32949268025-16315688778-69461704351-49185812340-75115044941]
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.182 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest1_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [65310, 7251, 93847948159-56520742220-70586357454-56911996478-12159943845-97322626570-06036943090-97656602887-48189845161-91542226453, 91966421261-48544767667-06177513291-76980956700-61058974819]
[INFO ] 2021-05-28 13:29:06.182 [pool-40-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest5 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.182 [pool-40-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.182 [pool-40-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest5_4 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [6724, 57570, 18616942339-06859976247-06880969681-14336221845-63532316285-15689307591-82128084364-27145318733-44446944369-07969455180, 25997529260-16197962135-33362565314-86424774517-61678892088]
[INFO ] 2021-05-28 13:29:06.182 [pool-33-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest10 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.182 [pool-33-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.182 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.182 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.182 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest1_6 SET c=? WHERE id=? ::: [95639942715-48751513919-01421121247-59147350243-50333982921-10684806413-85242260173-01452095858-03012779233-61655642868, 39616]
[INFO ] 2021-05-28 13:29:06.182 [pool-31-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.182 [pool-31-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.182 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 13:29:06.182 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.182 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest2_6 WHERE id=? ::: [15686]
[INFO ] 2021-05-28 13:29:06.182 [pool-33-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest10_9 SET k=k+1 WHERE id=? ::: [44219]
[INFO ] 2021-05-28 13:29:06.182 [pool-31-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO sbtest2_1 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [28511, 68092, 34138205365-07456600761-99952629876-35050875317-53088192110-65548617648-24651325478-05311702786-61448719669-53819134701, 41387349827-56637048027-13974327902-78455906710-98574066360]
[INFO ] 2021-05-28 13:29:06.183 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.183 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.183 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest4_8 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [71238, 13439, 86480231335-71556277024-71325565737-36162800498-23345553064-75991584239-84913502578-73700425688-39379483991-65033843941, 06264931314-88597028364-89196720200-92963010372-19297660068]
[INFO ] 2021-05-28 13:29:06.184 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.184 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.184 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest6_8 SET c=? WHERE id=? ::: [68743159654-82197638372-31835828294-43626053320-28593876612-38177049658-36731803131-15989814819-30041670188-00167512754, 12518]
[INFO ] 2021-05-28 13:29:06.184 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.184 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.184 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest2_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [15686, 7887, 54429404737-93404309032-43465177831-25845252397-44138046705-25630340079-62367604764-53013888005-15489540996-10656776106, 76001549832-86830973220-54464199310-54364497992-49316946830]
[INFO ] 2021-05-28 13:29:06.184 [pool-32-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.184 [pool-32-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.184 [pool-32-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest6_3 SET c=? WHERE id=? ::: [70764103171-81435516687-25611574948-31617824427-44225974936-63112838900-92760539660-41439375086-46844457106-18565392263, 28433]
[INFO ] 2021-05-28 13:29:06.185 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest4 WHERE id=?
[INFO ] 2021-05-28 13:29:06.185 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.185 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest4_2 WHERE id=? ::: [67032]
[INFO ] 2021-05-28 13:29:06.185 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest7 WHERE id=?
[INFO ] 2021-05-28 13:29:06.186 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.186 [pool-33-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.186 [pool-33-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.186 [pool-33-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest6_2 SET c=? WHERE id=? ::: [53845738055-63404571271-63826259421-06305467519-17741575496-41927145800-61564445937-85808019877-24231570199-21045161256, 9602]
[INFO ] 2021-05-28 13:29:06.186 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest5 WHERE id=?
[INFO ] 2021-05-28 13:29:06.186 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.186 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: DELETE FROM sbtest5_5 WHERE id=? ::: [69375]
[INFO ] 2021-05-28 13:29:06.186 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest7_8 WHERE id=? ::: [69968]
[INFO ] 2021-05-28 13:29:06.186 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.186 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.186 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest4_7 SET k=k+1 WHERE id=? ::: [14667]
[INFO ] 2021-05-28 13:29:06.187 [pool-32-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 13:29:06.187 [pool-32-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.187 [pool-32-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest2_2 WHERE id=? ::: [96942]
[INFO ] 2021-05-28 13:29:06.188 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.188 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.188 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest4_2 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [67032, 88273, 50840935159-73053229551-54156604424-25328482148-31099928082-57048976085-76877697709-86945601891-19662941051-05088268090, 53709391195-51396320793-52408912142-99014090653-56829410964]
[INFO ] 2021-05-28 13:29:06.188 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest4 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.188 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.188 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest4_9 SET c=? WHERE id=? ::: [91738368239-57821867378-51833849237-01120147164-60171007065-42380532299-18785221950-37121427814-39678958845-60473964008, 42439]
[INFO ] 2021-05-28 13:29:06.188 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest8 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.188 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.188 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest8_6 SET k=k+1 WHERE id=? ::: [63366]
[INFO ] 2021-05-28 13:29:06.188 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest5 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.188 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.188 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO sbtest5_5 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [69375, 74985, 83170922148-36030457909-26074901997-67236359434-27922473799-96668145153-96241338196-05439043385-39756676651-68044898193, 62370387006-30979605493-93164668186-88760110893-18411190461]
[INFO ] 2021-05-28 13:29:06.189 [pool-33-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.189 [pool-33-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.189 [pool-33-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest1_0 WHERE id=? ::: [65310]
[INFO ] 2021-05-28 13:29:06.189 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.189 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.189 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest7_8 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [69968, 49883, 93645148444-30243844748-58540335020-87784593070-74440003150-32570222915-40199821637-04028568161-28748890834-46968198860, 65034345141-56035534122-94053918722-14796202722-64136824289]
[INFO ] 2021-05-28 13:29:06.189 [pool-32-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.189 [pool-32-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.189 [pool-32-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest2_2 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [96942, 6958, 69545761488-99591947428-03181575909-31945206695-72315262055-53802482540-18624164073-46927914567-97259240631-59354248235, 09285629428-84106212822-34130112531-11269662008-93023838753]
[INFO ] 2021-05-28 13:29:06.190 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 13:29:06.190 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.190 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest10_6 WHERE id=? ::: [59526]
[INFO ] 2021-05-28 13:29:06.190 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest3 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.190 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.191 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest3_8 SET c=? WHERE id=? ::: [29402330455-51306307665-03011513474-88100037408-36064162246-53865067127-47559881957-45695023050-80451419744-75765821443, 24238]
[INFO ] 2021-05-28 13:29:06.191 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.191 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.191 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest2_7 SET k=k+1 WHERE id=? ::: [23727]
[INFO ] 2021-05-28 13:29:06.192 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest10 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.192 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.192 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest10_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [59526, 57577, 73215719915-30937945847-86178696768-60214878991-88235455551-30928334588-86079398000-75079267144-59584736056-16176054866, 77297979041-67712796061-91445899211-17338830862-73243841298]
[INFO ] 2021-05-28 13:29:06.193 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 13:29:06.193 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.193 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest8_0 WHERE id=? ::: [28490]
[INFO ] 2021-05-28 13:29:06.193 [pool-31-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.193 [pool-31-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.193 [pool-31-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest6_0 SET k=k+1 WHERE id=? ::: [27830]
[INFO ] 2021-05-28 13:29:06.193 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest10 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.193 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.193 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest10_3 SET c=? WHERE id=? ::: [99887842246-30163262466-35223969048-73037702806-07463756021-08232106651-40691476022-74111889733-32638440137-22132395354, 96843]
[INFO ] 2021-05-28 13:29:06.193 [pool-40-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.193 [pool-40-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.193 [pool-40-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest4_8 SET k=k+1 WHERE id=? ::: [95298]
[INFO ] 2021-05-28 13:29:06.193 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.193 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.193 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest2_6 SET k=k+1 WHERE id=? ::: [14136]
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.194 [pool-33-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest1_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [65310, 33233, 44807380510-54536505615-69866152668-30351469864-09534268897-54304069962-38597575385-98175037014-31378215658-44059277993, 78215202645-43165945497-43859810388-01105995155-63760357752]
[INFO ] 2021-05-28 13:29:06.194 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest8 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.194 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.194 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest8_6 SET k=k+1 WHERE id=? ::: [53846]
[INFO ] 2021-05-28 13:29:06.195 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest7 WHERE id=?
[INFO ] 2021-05-28 13:29:06.195 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.195 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest7_8 WHERE id=? ::: [16408]
[INFO ] 2021-05-28 13:29:06.195 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.195 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.195 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest8_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [28490, 7082, 43653296786-73803196076-20910943896-16250701457-83089839609-59226072524-23787232730-40759008043-68381541573-45990247366, 52635322237-80233549808-74619301469-34179361818-98964354884]
[INFO ] 2021-05-28 13:29:06.195 [pool-40-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.195 [pool-40-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.195 [pool-40-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest6_9 SET c=? WHERE id=? ::: [73100929382-55942004528-21473894661-67669917259-98970919183-46946492738-87519010976-17968854036-52734915025-98652126594, 41899]
[INFO ] 2021-05-28 13:29:06.195 [pool-31-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.195 [pool-31-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.195 [pool-31-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest7_6 SET c=? WHERE id=? ::: [97821853623-56442873699-01272932594-23268765204-91413187209-13367707194-94336575254-60922040752-98188128743-96910395989, 12036]
[INFO ] 2021-05-28 13:29:06.196 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.196 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.196 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest2_9 SET c=? WHERE id=? ::: [14411326821-35190722553-99238678325-92340362747-11342136442-56981813563-05285942422-01053141853-16089760927-78735681839, 19819]
[INFO ] 2021-05-28 13:29:06.196 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest3 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.196 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.196 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest3_0 SET c=? WHERE id=? ::: [67164807930-57477732657-44260527919-46238493955-53282331321-76563118776-86823766543-85284728242-05324515230-26585038001, 84360]
[INFO ] 2021-05-28 13:29:06.197 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.197 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.197 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest2_9 SET k=k+1 WHERE id=? ::: [75429]
[INFO ] 2021-05-28 13:29:06.197 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest5 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.197 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.197 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest5_3 SET k=k+1 WHERE id=? ::: [68093]
[INFO ] 2021-05-28 13:29:06.197 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.197 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.197 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest7_8 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [16408, 4482, 08208940781-16610209833-02589063839-06102590504-21624516025-73136373054-83487542289-87721002904-22155801737-32840513085, 81428264588-28871718837-84947301426-66506848137-01749894810]
[INFO ] 2021-05-28 13:29:06.197 [pool-31-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.197 [pool-31-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.197 [pool-31-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest1_6 WHERE id=? ::: [55256]
[INFO ] 2021-05-28 13:29:06.198 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 13:29:06.198 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.198 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest10_6 WHERE id=? ::: [87776]
[INFO ] 2021-05-28 13:29:06.198 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 13:29:06.198 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.198 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: DELETE FROM sbtest2_7 WHERE id=? ::: [56257]
[INFO ] 2021-05-28 13:29:06.199 [pool-40-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 13:29:06.199 [pool-40-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.199 [pool-40-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: DELETE FROM sbtest8_5 WHERE id=? ::: [21645]
[INFO ] 2021-05-28 13:29:06.199 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest7 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.199 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.199 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest7_3 SET k=k+1 WHERE id=? ::: [69823]
[INFO ] 2021-05-28 13:29:06.199 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.199 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.199 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest1_8 SET c=? WHERE id=? ::: [41543000798-78484968287-32039775451-18806143815-18818837630-35865200680-58695270598-16673131618-67296552119-47177479004, 79508]
[INFO ] 2021-05-28 13:29:06.199 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.199 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.199 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest9_8 SET c=? WHERE id=? ::: [65393037698-70167226760-26234267399-22235241764-54371097028-58272196170-74088252004-83181701265-21728435523-26667346867, 65788]
[INFO ] 2021-05-28 13:29:06.199 [pool-32-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.199 [pool-32-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.199 [pool-32-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest2_8 SET k=k+1 WHERE id=? ::: [52698]
[INFO ] 2021-05-28 13:29:06.200 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.200 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.200 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest4_4 SET k=k+1 WHERE id=? ::: [62204]
[INFO ] 2021-05-28 13:29:06.200 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.200 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.200 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest2_8 SET k=k+1 WHERE id=? ::: [15888]
[INFO ] 2021-05-28 13:29:06.200 [pool-35-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest10 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.200 [pool-35-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.200 [pool-35-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest10_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [87776, 28336, 05916993604-18828898413-89793446515-59113341079-17979475587-06560860040-95912764590-81182237527-60001031284-89474291963, 27149329917-86927600024-72839933049-84057922809-09102689906]
[INFO ] 2021-05-28 13:29:06.200 [pool-31-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.201 [pool-31-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.201 [pool-31-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest1_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [55256, 50511, 58886623217-78504659816-35296460415-66512184029-68088955001-76359813730-30897841477-28965208368-75547933715-62392671023, 94522849902-29065601531-41779047767-80813414664-70106600522]
[INFO ] 2021-05-28 13:29:06.201 [pool-37-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.201 [pool-37-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.201 [pool-37-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO sbtest2_7 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [56257, 40255, 88129100153-55725963057-13544151841-75041975699-40635117070-36283866954-61322512027-76024956844-64222901084-84484314537, 67708661815-97414064948-65743072502-15934726184-84033370655]
[INFO ] 2021-05-28 13:29:06.201 [pool-40-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.201 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest3 WHERE id=?
[INFO ] 2021-05-28 13:29:06.201 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.201 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest3_0 WHERE id=? ::: [68970]
[INFO ] 2021-05-28 13:29:06.201 [pool-40-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.201 [pool-40-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO sbtest8_5 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [21645, 96948, 26190790375-94773263512-31942409693-24677197168-60102684963-08012101953-09539730256-43718460659-93021263916-44359927610, 68403196210-71228776147-82167769054-25567325568-50070942578]
[INFO ] 2021-05-28 13:29:06.201 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.201 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.201 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: UPDATE sbtest7_7 SET c=? WHERE id=? ::: [81558521057-88246748749-05879598456-91736551904-50647561622-92584400572-31813199195-91146441777-89876463674-74543500994, 67697]
[INFO ] 2021-05-28 13:29:06.202 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.202 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.202 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest6_2 SET c=? WHERE id=? ::: [49494002915-33094111432-18703659115-37289085403-10458386688-07502870807-50064140650-91714901964-68861415968-13888487906, 52102]
[INFO ] 2021-05-28 13:29:06.202 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.202 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.202 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest1_6 SET c=? WHERE id=? ::: [67371655805-09989566054-45643157998-28874665799-53756627129-33378980106-39085780572-02579599359-81206086405-83283930082, 4596]
[INFO ] 2021-05-28 13:29:06.203 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 13:29:06.203 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.203 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest8_4 WHERE id=? ::: [44434]
[INFO ] 2021-05-28 13:29:06.203 [pool-38-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest3 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.203 [pool-38-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.204 [pool-38-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest3_0 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [68970, 71962, 98859009814-07278960425-57446387737-17671575240-91427518106-02391297962-25947973564-80901287378-41124099668-34795657624, 98758765308-10371901913-31056925188-80162654396-68005988481]
[INFO ] 2021-05-28 13:29:06.204 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest6 WHERE id=?
[INFO ] 2021-05-28 13:29:06.204 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.204 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: DELETE FROM sbtest6_6 WHERE id=? ::: [156]
[INFO ] 2021-05-28 13:29:06.204 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 13:29:06.204 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: DELETE FROM sbtest7 WHERE id=?
[INFO ] 2021-05-28 13:29:06.204 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.204 [pool-34-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: DELETE FROM sbtest7_3 WHERE id=? ::: [3913]
[INFO ] 2021-05-28 13:29:06.204 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 13:29:06.204 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: DELETE FROM sbtest8_1 WHERE id=? ::: [94511]
[INFO ] 2021-05-28 13:29:06.206 [pool-29-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.206 [pool-29-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.206 [pool-29-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest8_4 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [44434, 51204, 82617878328-74490983812-28017853190-20586027141-77348970247-38285541912-40653594361-65160696128-42910772635-17071780189, 03226864630-25136991195-93213129910-90533942624-09787694145]
[INFO ] 2021-05-28 13:29:06.206 [pool-30-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.206 [pool-30-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.206 [pool-39-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest5 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 13:29:06.206 [pool-39-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.206 [pool-39-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: UPDATE sbtest5_2 SET k=k+1 WHERE id=? ::: [20562]
[INFO ] 2021-05-28 13:29:06.206 [pool-34-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.207 [pool-36-thread-1] ShardingSphere-SQL - Logic SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 13:29:06.207 [pool-36-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 13:29:06.207 [pool-36-thread-1] ShardingSphere-SQL - Actual SQL: ds_0 ::: INSERT INTO sbtest6_6 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [156, 20152, 32289101863-40919582052-22946245146-79333004127-28917610903-42097857166-44488205219-64653732060-51465200450-90269476567, 20966136457-78360529433-34984661357-67543193463-12670687026]
[INFO ] 2021-05-28 13:29:06.206 [pool-32-thread-1] ShardingSphere-SQL - Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 13:29:06.207 [pool-32-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 13:29:06.206 [pool-30-thread-1] ShardingSphere-SQL - Actual SQL: ds_1 ::: INSERT INTO sbtest8_1 (id, k, c, pad) VALUES (?, ?, ?, ?) ::: [94511, 74282, 42755143823-12311466480-09652529567-98477211285-59342624427-44485077299-06893504570-27555979344-65253488566-52258315790, 53560715164-83879752059-79809992483-00470563057-83072154744]
[INFO ] 2021-05-28 13:29:06.207 [pool-34-thread-1] ShardingSphere-SQL - SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[ERROR] 2021-05-28 13:29:06.206 [pool-33-thread-1] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sbtest1_0_pkey"
Detail: Key (id)=(65310) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.impl.ProxyPreparedStatementExecutorCallback.execute(ProxyPreparedStatementExecutorCallback.java:41)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:73)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:66)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:44)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:85)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:64)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:101)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.serialExecute(ExecutorEngine.java:87)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:81)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:65)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.ProxyJDBCExecutor.execute(ProxyJDBCExecutor.java:64)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.useDriverToExecute(ProxySQLExecutor.java:165)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:124)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:113)
at org.apache.shardingsphere.proxy.backend.communication.ProxyLockEngine.doExecute(ProxyLockEngine.java:103)
at org.apache.shardingsphere.proxy.backend.communication.ProxyLockEngine.execute(ProxyLockEngine.java:81)
at org.apache.shardingsphere.proxy.backend.communication.DatabaseCommunicationEngine.execute(DatabaseCommunicationEngine.java:98)
at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.binary.bind.PostgreSQLComBindExecutor.execute(PostgreSQLComBindExecutor.java:100)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:93)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:71)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
</code></pre>
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org