TeslaCN commented on issue #10273:
URL:
https://github.com/apache/shardingsphere/issues/10273#issuecomment-850307215
```
[INFO ] 2021-05-28 14:49:02.620 [pool-75-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest7 WHERE id=?
[INFO ] 2021-05-28 14:49:02.620 [pool-75-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.620 [pool-75-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest7_1 WHERE id=? ::: [78551]
[INFO ] 2021-05-28 14:49:02.620 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest7_3 SET k=k+1 WHERE id=? ::: [71153]
[INFO ] 2021-05-28 14:49:02.620 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.620 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.620 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest9_9 SET k=k+1 WHERE id=? ::: [75529]
[INFO ] 2021-05-28 14:49:02.621 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.621 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.621 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest1_6 SET c=? WHERE id=? :::
[20850658829-61568284014-89080101456-36074166378-21213480931-80347489986-83032915369-48401115044-77822457183-50947653233,
13906]
[INFO ] 2021-05-28 14:49:02.621 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.621 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.621 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest1_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [18711, 62360,
69158872811-61168479419-65189408457-82165194232-89204424633-34257938789-79220071070-34243270819-11775908168-25605782304,
99768140381-56410683614-47140262227-03591139364-05419256009]
[INFO ] 2021-05-28 14:49:02.622 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest7 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.622 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.622 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest7_8 SET k=k+1 WHERE id=? ::: [37398]
[INFO ] 2021-05-28 14:49:02.622 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest4 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.622 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.622 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest4_1 SET c=? WHERE id=? :::
[42492328606-62631696924-74450754308-66610176919-98829770073-63261785140-21770865491-88769307205-91754425777-72762495687,
7511]
[INFO ] 2021-05-28 14:49:02.623 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest5 WHERE id=?
[INFO ] 2021-05-28 14:49:02.623 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.623 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest5_7 WHERE id=? ::: [63657]
[INFO ] 2021-05-28 14:49:02.624 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.624 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.624 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.624 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.624 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_3 SET c=? WHERE id=? :::
[05848853013-43371122438-34991593578-53624309921-01684433653-00799975240-57453240853-05358667963-94047472973-75583696409,
56203]
[INFO ] 2021-05-28 14:49:02.624 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest2_1 WHERE id=? ::: [86671]
[INFO ] 2021-05-28 14:49:02.624 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.624 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.624 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest2_6 WHERE id=? ::: [45416]
[INFO ] 2021-05-28 14:49:02.624 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.624 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.624 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest6_0 SET k=k+1 WHERE id=? ::: [67760]
[INFO ] 2021-05-28 14:49:02.625 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.625 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.625 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest6_8 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [90798, 9653,
94024278736-31932785735-53690352119-22750604559-73278567052-05063025313-98297724702-24361953839-96331089451-99376795954,
93707505393-28411792248-50139264988-99330355501-25691610910]
[INFO ] 2021-05-28 14:49:02.625 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.625 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.625 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_1 SET k=k+1 WHERE id=? ::: [90601]
[INFO ] 2021-05-28 14:49:02.625 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest1 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.625 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.625 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest5 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.625 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.625 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest1_3 SET k=k+1 WHERE id=? ::: [60933]
[INFO ] 2021-05-28 14:49:02.625 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest5_7 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [63657, 71541,
32788148580-16951793451-73521755814-84823368355-50665828156-66049479065-05456986333-62615811378-41622000142-99558902447,
40802548950-83115135893-48719937433-67900843075-89586122337]
[INFO ] 2021-05-28 14:49:02.626 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.626 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.626 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_7 SET k=k+1 WHERE id=? ::: [90907]
[INFO ] 2021-05-28 14:49:02.626 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest3 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.626 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.626 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest3_5 SET c=? WHERE id=? :::
[98909598809-50733838959-95317708448-28433051390-33444244253-47824909207-72848334846-53721085053-98027624631-65369242118,
91935]
[INFO ] 2021-05-28 14:49:02.626 [pool-75-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.626 [pool-75-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.626 [pool-75-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest7_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [78551, 40238,
77511268057-70286789290-09373850343-43677020353-00829226367-58272777015-22584661378-12196629102-07230858184-36369928810,
03781863869-89925163999-70424915337-52180680074-44534302416]
[INFO ] 2021-05-28 14:49:02.626 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.626 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.626 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest2_6 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [45416, 43245,
81734679999-86138482704-30774683995-03295130761-97944828703-29515720711-71605129754-76477843691-29895697537-48492685189,
05121237931-44622644842-87362277825-70969228178-95880742733]
[INFO ] 2021-05-28 14:49:02.627 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.627 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.627 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest2_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [86671, 84670,
37076093202-56192313645-61575614708-68551679244-40508548612-67051561828-90289850690-96823620896-46531649151-66847422380,
29530863322-36873600071-70152135382-82227577329-62742498240]
[INFO ] 2021-05-28 14:49:02.627 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest9 WHERE id=?
[INFO ] 2021-05-28 14:49:02.627 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.627 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest9_1 WHERE id=? ::: [39481]
[INFO ] 2021-05-28 14:49:02.627 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.627 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.627 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_5 SET c=? WHERE id=? :::
[84795580787-70943833852-92913006908-25857438084-24132547309-37833301232-88071922542-41881989153-36112341830-74782261334,
46875]
[INFO ] 2021-05-28 14:49:02.628 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest3 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.628 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.628 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest3_7 SET c=? WHERE id=? :::
[93440223232-16459527961-07918236301-42333029248-86320280092-48296077703-39118905296-46519990358-30175702845-56950837588,
46007]
[INFO ] 2021-05-28 14:49:02.628 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.628 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.628 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_1 SET c=? WHERE id=? :::
[14700815718-16672677950-52683113140-07037908572-26430817133-10098348385-24183377496-02849903549-35651731966-93317729147,
39401]
[INFO ] 2021-05-28 14:49:02.628 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.628 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.628 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest9_7 SET c=? WHERE id=? :::
[49495060216-27512936305-28763348453-11041434767-48030627229-73080833333-22376963800-36339809659-14986149065-70860125843,
89027]
[INFO ] 2021-05-28 14:49:02.629 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest9 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.629 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.629 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest9_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [39481, 69066,
92143812199-67034693844-27578025182-49118532952-88040159703-36759893023-08365475337-75153673226-34567596959-53995054377,
62510622706-25161782936-82341604071-78027023938-57382911258]
[INFO ] 2021-05-28 14:49:02.630 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest5 WHERE id=?
[INFO ] 2021-05-28 14:49:02.630 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.630 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest4 WHERE id=?
[INFO ] 2021-05-28 14:49:02.630 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.630 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest4_4 WHERE id=? ::: [37814]
[INFO ] 2021-05-28 14:49:02.630 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest3 WHERE id=?
[INFO ] 2021-05-28 14:49:02.630 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.630 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest5_1 WHERE id=? ::: [68971]
[INFO ] 2021-05-28 14:49:02.630 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest3_8 WHERE id=? ::: [12078]
[INFO ] 2021-05-28 14:49:02.631 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest3 WHERE id=?
[INFO ] 2021-05-28 14:49:02.631 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.631 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest3_1 WHERE id=? ::: [44211]
[INFO ] 2021-05-28 14:49:02.632 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest5 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.632 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.632 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest5_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [68971, 17202,
98830342765-12969987806-07137923837-70140584262-23422358817-34609033560-52672700048-66040134077-13854904237-18967997392,
70285130388-46391021029-34424764476-05887243336-19610661604]
[INFO ] 2021-05-28 14:49:02.632 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest3 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.632 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.632 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.632 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.632 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest3_8 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [12078, 5985,
87110003749-22032728158-72739051043-83721627625-93994557686-78383158122-25138995733-28751494365-55247332064-04459733133,
24648009629-31400130952-22766496813-48706906931-33858600539]
[INFO ] 2021-05-28 14:49:02.632 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest4_4 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [37814, 27522,
56685930103-24235671287-15003282418-51876907110-25972924526-49805109134-24449922522-07598660256-64900419463-87100892656,
87201339274-26461706871-87794492469-52260196803-27029767675]
[INFO ] 2021-05-28 14:49:02.632 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.632 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.632 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest2_5 WHERE id=? ::: [52935]
[INFO ] 2021-05-28 14:49:02.632 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest3 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.632 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.632 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest3_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [44211, 47031,
29789272246-73325689692-67346372547-12617037371-88217690821-61848565245-65550827691-29419628849-10383708391-47581886118,
60288068442-77344316474-64642196965-79226836619-65267358663]
[INFO ] 2021-05-28 14:49:02.635 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.635 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.635 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest2_5 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [52935, 88150,
89348599723-13432072056-24558256072-82286439549-18141241258-12471013718-11066748215-03307778846-64333490898-35927825474,
43482648017-67173259229-52540614547-63555592395-01268607209]
[INFO ] 2021-05-28 14:49:02.638 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.638 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.638 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest4_2 SET k=k+1 WHERE id=? ::: [8642]
[INFO ] 2021-05-28 14:49:02.638 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.638 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.638 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest9_2 SET k=k+1 WHERE id=? ::: [20702]
[INFO ] 2021-05-28 14:49:02.640 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.640 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.640 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_7 SET k=k+1 WHERE id=? ::: [347]
[INFO ] 2021-05-28 14:49:02.640 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.640 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.640 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest7_6 SET c=? WHERE id=? :::
[55725519400-53360456904-59819663854-56672024619-13800851408-19521037512-56808304658-87579236450-50839150711-28190158855,
72426]
[INFO ] 2021-05-28 14:49:02.640 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.640 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.640 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_3 SET c=? WHERE id=? :::
[44757485285-09955576647-05250864986-94185092676-41616177189-93567162637-31097480178-90374940034-75757090954-51209769463,
56303]
[INFO ] 2021-05-28 14:49:02.641 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.641 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.641 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest4_3 SET k=k+1 WHERE id=? ::: [57013]
[INFO ] 2021-05-28 14:49:02.641 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.641 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.641 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest2_8 SET k=k+1 WHERE id=? ::: [31928]
[INFO ] 2021-05-28 14:49:02.641 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest5 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest5_6 SET k=k+1 WHERE id=? ::: [90946]
[INFO ] 2021-05-28 14:49:02.641 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest10 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest10_8 SET k=k+1 WHERE id=? ::: [39188]
[INFO ] 2021-05-28 14:49:02.642 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest4_6 SET k=k+1 WHERE id=? ::: [6456]
[INFO ] 2021-05-28 14:49:02.642 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest2_7 SET k=k+1 WHERE id=? ::: [28947]
[INFO ] 2021-05-28 14:49:02.642 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest6 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest6_4 WHERE id=? ::: [75614]
[INFO ] 2021-05-28 14:49:02.642 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest6 WHERE id=?
[INFO ] 2021-05-28 14:49:02.642 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.642 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest6_1 WHERE id=? ::: [20351]
[INFO ] 2021-05-28 14:49:02.643 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.643 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.643 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest7_0 SET c=? WHERE id=? :::
[81198563546-27369009151-91972436710-86242242696-29583079253-19134697149-53526619838-33174996017-77340649326-93874950131,
74900]
[INFO ] 2021-05-28 14:49:02.643 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.643 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.643 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest2_9 SET k=k+1 WHERE id=? ::: [17979]
[INFO ] 2021-05-28 14:49:02.643 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest3 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.643 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.643 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest3_8 SET k=k+1 WHERE id=? ::: [16108]
[INFO ] 2021-05-28 14:49:02.643 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.643 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.643 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest10 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.643 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.643 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest10_0 SET c=? WHERE id=? :::
[76130321376-84192313598-73341133828-65555540009-91938585783-02101426798-03978716347-61665439763-06401651486-81110987730,
5870]
[INFO ] 2021-05-28 14:49:02.643 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest1_8 SET c=? WHERE id=? :::
[58702832888-14088908024-24970624675-34994561345-91027869606-90989125293-35611923770-27198172117-32732088496-10418680923,
62618]
[INFO ] 2021-05-28 14:49:02.644 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.644 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.644 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest9_8 SET c=? WHERE id=? :::
[90980546551-68078625382-00535229942-29906082894-32234475589-14395532205-78535246198-40291110183-93222704691-45961946633,
62868]
[INFO ] 2021-05-28 14:49:02.644 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.644 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.644 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest9_1 SET c=? WHERE id=? :::
[31222412005-88368547921-11711158222-58804535065-18803708681-04875746338-90574628834-36244427362-59357648590-98049471905,
38411]
[INFO ] 2021-05-28 14:49:02.644 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.644 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.644 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_5 SET c=? WHERE id=? :::
[74789207444-96771580034-91601048210-32744925168-56420406880-05571691878-89837283910-10899347377-83446263993-87669339280,
1595]
[INFO ] 2021-05-28 14:49:02.644 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 14:49:02.644 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.644 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest10_9 WHERE id=? ::: [17949]
[INFO ] 2021-05-28 14:49:02.644 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.644 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.644 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.644 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.644 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_9 SET c=? WHERE id=? :::
[44603407182-94375841992-25390634917-49972216704-80536637025-78787190011-98749815587-69354339816-68590235354-85848474772,
64719]
[INFO ] 2021-05-28 14:49:02.645 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest6_4 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [75614, 77156,
94595546227-41323355441-91796260508-35890242779-93463209823-27310912173-85502312987-68179625723-80597712996-43235751535,
84313854959-87978573922-18728816949-65749897930-69135569269]
[INFO ] 2021-05-28 14:49:02.645 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.645 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.645 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest6_1 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [20351, 953,
90000745894-02242473554-88422427259-77855643308-50288625669-61986554573-72343365209-93284626714-89478636721-26362317169,
09380453708-91334489835-61045861149-00057572038-41580124560]
[INFO ] 2021-05-28 14:49:02.645 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.645 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.645 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_9 SET c=? WHERE id=? :::
[42073052407-46787652040-11557902497-90910773891-75133160126-40718999451-23076018747-08296545869-94951546607-39980356104,
17259]
[INFO ] 2021-05-28 14:49:02.646 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest9 WHERE id=?
[INFO ] 2021-05-28 14:49:02.646 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.646 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest9_5 WHERE id=? ::: [64825]
[INFO ] 2021-05-28 14:49:02.646 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 14:49:02.646 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.646 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest10_4 WHERE id=? ::: [26304]
[INFO ] 2021-05-28 14:49:02.646 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest9 WHERE id=?
[INFO ] 2021-05-28 14:49:02.646 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.646 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest9_0 WHERE id=? ::: [55180]
[INFO ] 2021-05-28 14:49:02.646 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest10 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.646 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.646 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest10_9 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [17949, 26010,
03487505165-21181840287-70663590284-37014401886-04398931498-09124003070-18093831468-00777623181-14888963509-29606164681,
16041939894-07040094495-02550820059-30363164652-95246349722]
[INFO ] 2021-05-28 14:49:02.647 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest4 WHERE id=?
[INFO ] 2021-05-28 14:49:02.647 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.647 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest4_0 WHERE id=? ::: [97020]
[INFO ] 2021-05-28 14:49:02.648 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest3 WHERE id=?
[INFO ] 2021-05-28 14:49:02.648 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.648 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest3_5 WHERE id=? ::: [3275]
[INFO ] 2021-05-28 14:49:02.648 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest9 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.648 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.648 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest9 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.648 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.648 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest9_0 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [55180, 36657,
00179670581-75728529501-25628242710-38652299208-60220167726-68570672588-93660551050-68609859377-00197284188-62019662678,
28779903487-76056834420-28822286329-32245255966-54994406684]
[INFO ] 2021-05-28 14:49:02.648 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest9_5 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [64825, 511,
78756414498-20439257078-90543965267-06494647979-74046033759-23265894325-80592796328-65254327625-35200449564-71980497658,
76657042356-82246556016-77155837633-63455359094-35514033856]
[INFO ] 2021-05-28 14:49:02.648 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest10 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.648 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.648 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest10_4 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [26304, 85077,
71819804994-22514925339-18744224383-94178614717-61408720817-80371230314-90941622636-97534105680-74993272720-64093377353,
61983379758-74177197262-87256066493-37568879743-78550450811]
[INFO ] 2021-05-28 14:49:02.648 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.648 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.648 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest2_9 WHERE id=? ::: [88329]
[INFO ] 2021-05-28 14:49:02.649 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.649 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.649 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_7 SET c=? WHERE id=? :::
[15312944677-59814799927-56586707013-48214659505-36835914133-97125876966-13384533115-52176412858-70150341616-59084423310,
2507]
[INFO ] 2021-05-28 14:49:02.649 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest6 WHERE id=?
[INFO ] 2021-05-28 14:49:02.649 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.649 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.649 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.649 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest4_0 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [97020, 16973,
79342097168-80594536631-49592334704-74545080873-72335652929-18395110538-39500491547-07353329833-88799082643-63944375125,
27859924351-18273942439-67279980210-69335817447-59306737252]
[INFO ] 2021-05-28 14:49:02.649 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest6_0 WHERE id=? ::: [51870]
[INFO ] 2021-05-28 14:49:02.649 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.649 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.649 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest2_9 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [88329, 87930,
39220647941-57983325768-69389569732-45431293102-96104288142-44526012554-99153796495-38012742471-43924702889-40614079474,
90739449733-17373392260-93448111552-03899936574-52509027944]
[INFO ] 2021-05-28 14:49:02.650 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest3 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.650 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.650 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest3_5 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [3275, 51632,
44296488045-31632663107-90796805336-57732861212-61165742884-51471004028-09334408636-48708408976-61762252642-41057436286,
73013420710-40975830509-09514455596-61891177693-49261891610]
[INFO ] 2021-05-28 14:49:02.651 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.651 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.651 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest6_0 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [51870, 97240,
40449631963-54529156709-68249353267-48820523140-98514658754-18002687473-36039354283-41416868556-13815740379-70575109215,
91906650582-36219803948-89605149729-79987377194-30165876397]
[INFO ] 2021-05-28 14:49:02.652 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.652 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.652 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest2_0 WHERE id=? ::: [28230]
[INFO ] 2021-05-28 14:49:02.654 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.654 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.654 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest2_0 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [28230, 10256,
38205452149-49858728368-23605347876-27147540906-40855009122-87756917711-71131499472-95136745497-94724623725-71190696869,
39907911410-84652299719-00210295419-81138967906-44639181934]
[INFO ] 2021-05-28 14:49:02.654 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest10 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.654 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.654 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest3 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.654 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.654 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.654 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest10_5 SET k=k+1 WHERE id=? ::: [68355]
[INFO ] 2021-05-28 14:49:02.654 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest3_4 SET k=k+1 WHERE id=? ::: [23214]
[INFO ] 2021-05-28 14:49:02.655 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.655 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest2_0 SET k=k+1 WHERE id=? ::: [37430]
[INFO ] 2021-05-28 14:49:02.655 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest3 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.655 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.655 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest3_1 SET k=k+1 WHERE id=? ::: [89401]
[INFO ] 2021-05-28 14:49:02.656 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.656 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.656 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest9_4 SET k=k+1 WHERE id=? ::: [70054]
[INFO ] 2021-05-28 14:49:02.656 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.656 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.656 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_9 SET k=k+1 WHERE id=? ::: [28439]
[INFO ] 2021-05-28 14:49:02.656 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.656 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.656 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest2_4 SET k=k+1 WHERE id=? ::: [68654]
[ERROR] 2021-05-28 14:49:02.656 [pool-75-thread-1]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "sbtest7_1_pkey"
Detail: Key (id)=(78551) 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)
[INFO ] 2021-05-28 14:49:02.657 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.657 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.657 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest1_9 SET c=? WHERE id=? :::
[67421881000-25151969237-16757967831-96777761894-84042260663-14750523514-09055019975-46903605979-54733490013-50951093400,
9249]
[INFO ] 2021-05-28 14:49:02.657 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.657 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.657 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_5 SET c=? WHERE id=? :::
[07756804048-30106068426-92615447559-48463956229-02484954607-60953753608-94486449274-31579524702-77430940926-56002342457,
30835]
[INFO ] 2021-05-28 14:49:02.658 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.658 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.658 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_7 SET c=? WHERE id=? :::
[36245831142-19100437782-53968505513-03603858486-04491601296-33926356302-70438531990-10221802089-37584577816-84789883158,
18537]
[INFO ] 2021-05-28 14:49:02.658 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest2 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.658 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.658 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest2_5 SET c=? WHERE id=? :::
[51560918830-69524888011-44692889895-21581782713-05123689097-33356015287-28363514153-81027697089-51273802348-69754631110,
12415]
[INFO ] 2021-05-28 14:49:02.658 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.658 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.658 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest9_7 SET c=? WHERE id=? :::
[77750485262-15546793241-27830560773-39690589267-46923386339-36601899592-91425165258-23059853436-45220261215-24901324684,
69757]
[INFO ] 2021-05-28 14:49:02.659 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.659 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.659 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_5 SET k=k+1 WHERE id=? ::: [52815]
[INFO ] 2021-05-28 14:49:02.659 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest7 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.659 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.659 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest7_2 SET c=? WHERE id=? :::
[62528456729-92074856137-58337489397-67444082901-47452298942-13136442948-60063409658-61714289098-41077300629-83564103083,
59302]
[INFO ] 2021-05-28 14:49:02.659 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.659 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.659 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_3 SET k=k+1 WHERE id=? ::: [47603]
[INFO ] 2021-05-28 14:49:02.660 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.660 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.660 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_7 SET c=? WHERE id=? :::
[67748368569-33265045056-10162572677-31386804464-51078408214-16052966157-09078729015-17435228813-61339225068-51281408549,
37177]
[INFO ] 2021-05-28 14:49:02.660 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest4 WHERE id=?
[INFO ] 2021-05-28 14:49:02.660 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.660 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 14:49:02.660 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.660 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest8_9 WHERE id=? ::: [1799]
[INFO ] 2021-05-28 14:49:02.660 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest4_2 WHERE id=? ::: [60412]
[INFO ] 2021-05-28 14:49:02.660 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest5 WHERE id=?
[INFO ] 2021-05-28 14:49:02.660 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.660 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest5_7 WHERE id=? ::: [44347]
[INFO ] 2021-05-28 14:49:02.660 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.660 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.660 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest1_3 WHERE id=? ::: [9093]
[INFO ] 2021-05-28 14:49:02.661 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest8 WHERE id=?
[INFO ] 2021-05-28 14:49:02.661 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.661 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest8_9 WHERE id=? ::: [45999]
[INFO ] 2021-05-28 14:49:02.661 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest4 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.661 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.661 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest4_0 SET k=k+1 WHERE id=? ::: [20820]
[INFO ] 2021-05-28 14:49:02.661 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest1 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.661 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 14:49:02.661 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.661 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.661 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.661 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_7 SET c=? WHERE id=? :::
[46150882643-49511104996-06088146422-70297284184-60096983924-97031839848-77798831382-49957924245-15948740844-82869793274,
45377]
[INFO ] 2021-05-28 14:49:02.661 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.661 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: UPDATE sbtest1_4 SET c=? WHERE id=? :::
[20568142375-83268428166-20069044803-42938836732-90024900227-01904138417-66113085537-55648739651-09604132608-25860123518,
51064]
[INFO ] 2021-05-28 14:49:02.661 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest10_6 WHERE id=? ::: [79756]
[INFO ] 2021-05-28 14:49:02.662 [pool-73-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.662 [pool-73-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.662 [pool-73-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest8_9 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [1799, 73810,
87243450130-35829199394-93531305142-31646743903-87838567593-92003186945-22812268468-53142191527-98843819049-29301726670,
00413597872-45091751946-28003486039-61759531305-78593330711]
[INFO ] 2021-05-28 14:49:02.662 [pool-76-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.662 [pool-76-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.662 [pool-76-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest4_2 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [60412, 18500,
57351229716-63857568203-10880544315-92480623118-73987523943-42817531874-07842691739-58135774565-11041153611-53421458899,
26072925104-34987420266-37622922333-06652264382-64446927515]
[INFO ] 2021-05-28 14:49:02.662 [pool-71-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest2 WHERE id=?
[INFO ] 2021-05-28 14:49:02.662 [pool-71-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.662 [pool-71-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: DELETE FROM sbtest2_6 WHERE id=? ::: [20706]
[INFO ] 2021-05-28 14:49:02.662 [pool-68-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest5 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.662 [pool-68-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.662 [pool-68-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest5_7 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [44347, 22329,
40432267688-41869346943-75704802432-65414908383-05826472412-97262776356-94748054503-07156388613-23903787431-81527066302,
49912111835-35244737008-49697246625-72927768176-32894066538]
[INFO ] 2021-05-28 14:49:02.663 [pool-69-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest1 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.663 [pool-69-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.663 [pool-69-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest1_3 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [9093, 1326,
15690481949-61212769513-54168403100-49744369220-84998660800-77019698823-27507270862-89560656180-86452860464-87652646144,
24953611571-77998467782-22718455308-36105411491-73539770576]
[INFO ] 2021-05-28 14:49:02.663 [pool-67-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.663 [pool-67-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.663 [pool-67-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: INSERT INTO sbtest8_9 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [45999, 76284,
41837229821-77695561271-38749562386-22545823606-30119823187-66484703623-64434025650-65297853471-91126422017-46569397739,
76808120722-42166758751-83291446158-93358983806-44809350056]
[INFO ] 2021-05-28 14:49:02.663 [pool-66-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest10 WHERE id=?
[INFO ] 2021-05-28 14:49:02.663 [pool-66-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.663 [pool-66-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest10_9 WHERE id=? ::: [94129]
[INFO ] 2021-05-28 14:49:02.663 [pool-70-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest9 SET c=? WHERE id=?
[INFO ] 2021-05-28 14:49:02.663 [pool-70-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.663 [pool-70-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest9_7 SET c=? WHERE id=? :::
[01926365687-76778392055-88707421510-41173174435-87534024688-89738412879-55324722472-56619901372-54357675427-59505054037,
72437]
[INFO ] 2021-05-28 14:49:02.664 [pool-74-thread-1] ShardingSphere-SQL -
Logic SQL: INSERT INTO sbtest10 (id, k, c, pad) VALUES (?, ?, ?, ?)
[INFO ] 2021-05-28 14:49:02.664 [pool-74-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLInsertStatement(withSegment=Optional.empty)
[INFO ] 2021-05-28 14:49:02.664 [pool-74-thread-1] ShardingSphere-SQL -
Actual SQL: ds_0 ::: INSERT INTO sbtest10_6 (id, k, c, pad) VALUES (?, ?, ?, ?)
::: [79756, 67073,
49001223503-72307630693-73100183599-93218329695-33475276311-78209495497-49531076538-54946282404-95981937285-92989008766,
52109063766-67920541878-62039663824-71400831905-47499351078]
[INFO ] 2021-05-28 14:49:02.664 [pool-65-thread-1] ShardingSphere-SQL -
Logic SQL: DELETE FROM sbtest6 WHERE id=?
[INFO ] 2021-05-28 14:49:02.664 [pool-65-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLDeleteStatement()
[INFO ] 2021-05-28 14:49:02.664 [pool-65-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: DELETE FROM sbtest6_5 WHERE id=? ::: [66345]
[INFO ] 2021-05-28 14:49:02.665 [pool-75-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest8 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.665 [pool-75-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.665 [pool-75-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest8_7 SET k=k+1 WHERE id=? ::: [47467]
[INFO ] 2021-05-28 14:49:02.665 [pool-72-thread-1] ShardingSphere-SQL -
Logic SQL: UPDATE sbtest6 SET k=k+1 WHERE id=?
[INFO ] 2021-05-28 14:49:02.665 [pool-72-thread-1] ShardingSphere-SQL -
SQLStatement: PostgreSQLUpdateStatement()
[INFO ] 2021-05-28 14:49:02.665 [pool-72-thread-1] ShardingSphere-SQL -
Actual SQL: ds_1 ::: UPDATE sbtest6_1 SET k=k+1 WHERE id=? ::: [17091]
[ERROR] 2021-05-28 14:49:02.672 [pool-72-thread-1]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.postgresql.util.PSQLException: This statement has been closed.
at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)
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)
[ERROR] 2021-05-28 14:49:02.672 [pool-75-thread-1]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.postgresql.util.PSQLException: This statement has been closed.
at org.postgresql.jdbc.PgStatement.checkClosed(PgStatement.java:694)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)
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)
```
--
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:
[email protected]
