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/06/04 08:41:54 UTC
[GitHub] [shardingsphere] TeslaCN opened a new issue #10656: PostgreSQL Proxy may return unexpected Row Description in prepared select statement
TeslaCN opened a new issue #10656:
URL: https://github.com/apache/shardingsphere/issues/10656
## Bug Report
### Which version of ShardingSphere did you use?
master
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
Proxy
### Expected behavior
### Actual behavior
Client sent:
```
PostgreSQL
Type: Bind
Length: 22
Portal:
Statement: S_1
Parameter formats: 1
Parameter values: 1
Result formats: 0
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: all rows
PostgreSQL
Type: Sync
Length: 4
```
Server response:
```
PostgreSQL
Type: Bind completion
Length: 4
PostgreSQL
Type: Row description
Length: 143
Field count: 5
PostgreSQL
Type: Data row
Length: 119
Field count: 5
PostgreSQL
Type: Command completion
Length: 7
Tag: 0
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
```java
try (PreparedStatement preparedStatement = connection.prepareStatement("select * from t_order limit ?")) {
for (int i = 0; i < 6; i++) {
preparedStatement.setInt(1, 1);
try (ResultSet resultSet = preparedStatement.executeQuery()) {
while (resultSet.next()) {
System.out.println(resultSet.getLong("order_id"));
}
}
}
}
```
### Example codes for reproduce this issue (such as a github link).
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #10656: PostgreSQL Proxy may return unexpected Row Description in prepared select statement
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #10656:
URL: https://github.com/apache/shardingsphere/issues/10656#issuecomment-855253410
# Refactored
```
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Initializing worker threads...
Creating table 'sbtest8'...
Creating table 'sbtest10'...
Creating table 'sbtest2'...
Creating table 'sbtest6'...
Creating table 'sbtest1'...
Creating table 'sbtest9'...
Creating table 'sbtest5'...
Creating table 'sbtest7'...
Creating table 'sbtest3'...
Creating table 'sbtest4'...
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest9'
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest2'
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest6'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1867.28 qps: 22424.58 (r/w/o: 18687.61/0.00/3736.96) lat (ms,99%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 2208.17 qps: 26489.38 (r/w/o: 22073.05/0.00/4416.33) lat (ms,99%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 2008.63 qps: 24106.98 (r/w/o: 20089.72/0.00/4017.26) lat (ms,99%): 13.46 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 326290
write: 0
other: 65258
total: 391548
transactions: 32629 (2038.37 per sec.)
queries: 391548 (24460.42 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2038.3681
time elapsed: 16.0074s
total number of events: 32629
Latency (ms):
min: 3.75
avg: 5.88
max: 155.63
99th percentile: 14.73
sum: 191978.40
Threads fairness:
events (avg/stddev): 2719.0833/13.93
execution time (avg/stddev): 15.9982/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 2048.57 qps: 24595.83 (r/w/o: 20496.49/0.00/4099.34) lat (ms,99%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1985.72 qps: 23830.19 (r/w/o: 19858.56/0.00/3971.63) lat (ms,99%): 12.08 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 2053.84 qps: 24644.23 (r/w/o: 20536.56/0.00/4107.67) lat (ms,99%): 13.46 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 322940
write: 0
other: 64588
total: 387528
transactions: 32294 (2017.37 per sec.)
queries: 387528 (24208.44 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2017.3698
time elapsed: 16.0080s
total number of events: 32294
Latency (ms):
min: 3.67
avg: 5.94
max: 144.93
99th percentile: 12.75
sum: 191982.54
Threads fairness:
events (avg/stddev): 2691.1667/12.77
execution time (avg/stddev): 15.9985/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 27257.42 qps: 27257.42 (r/w/o: 27257.42/0.00/0.00) lat (ms,99%): 0.90 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 26149.14 qps: 26149.14 (r/w/o: 26149.14/0.00/0.00) lat (ms,99%): 1.14 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 25211.49 qps: 25211.49 (r/w/o: 25211.49/0.00/0.00) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 422765
write: 0
other: 0
total: 422765
transactions: 422765 (26420.51 per sec.)
queries: 422765 (26420.51 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 26420.5073
time elapsed: 16.0014s
total number of events: 422765
Latency (ms):
min: 0.28
avg: 0.45
max: 115.42
99th percentile: 1.04
sum: 191697.24
Threads fairness:
events (avg/stddev): 35230.4167/142.86
execution time (avg/stddev): 15.9748/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1277.66 qps: 20459.83 (r/w/o: 12790.24/5111.86/2557.73) lat (ms,99%): 28.67 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1314.34 qps: 21034.64 (r/w/o: 13147.20/5258.76/2628.68) lat (ms,99%): 18.95 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1340.36 qps: 21449.03 (r/w/o: 13406.44/5362.06/2680.53) lat (ms,99%): 21.89 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 211640
write: 84656
other: 42328
total: 338624
transactions: 21164 (1321.99 per sec.)
queries: 338624 (21151.91 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1321.9942
time elapsed: 16.0091s
total number of events: 21164
Latency (ms):
min: 6.43
avg: 9.07
max: 132.58
99th percentile: 21.89
sum: 192004.80
Threads fairness:
events (avg/stddev): 1763.6667/9.70
execution time (avg/stddev): 16.0004/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 3860.03 qps: 23168.59 (r/w/o: 0.00/15446.13/7722.46) lat (ms,99%): 5.99 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 3835.67 qps: 23012.84 (r/w/o: 0.00/15341.49/7671.35) lat (ms,99%): 5.77 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 3648.59 qps: 21891.96 (r/w/o: 0.00/14594.97/7296.99) lat (ms,99%): 7.17 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 241624
other: 120812
total: 362436
transactions: 60406 (3774.06 per sec.)
queries: 362436 (22644.34 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 3774.0569
time elapsed: 16.0056s
total number of events: 60406
Latency (ms):
min: 1.86
avg: 3.18
max: 131.36
99th percentile: 6.43
sum: 191892.37
Threads fairness:
events (avg/stddev): 5033.8333/14.00
execution time (avg/stddev): 15.9910/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 14686.42 qps: 14686.42 (r/w/o: 0.00/14686.42/0.00) lat (ms,99%): 1.86 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14918.18 qps: 14918.18 (r/w/o: 0.00/14918.18/0.00) lat (ms,99%): 1.61 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15222.45 qps: 15222.45 (r/w/o: 0.00/15222.45/0.00) lat (ms,99%): 1.70 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 240254
other: 0
total: 240254
transactions: 240254 (15013.93 per sec.)
queries: 240254 (15013.93 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15013.9335
time elapsed: 16.0021s
total number of events: 240254
Latency (ms):
min: 0.30
avg: 0.80
max: 138.81
99th percentile: 1.67
sum: 191801.43
Threads fairness:
events (avg/stddev): 20021.1667/67.89
execution time (avg/stddev): 15.9835/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 16120.65 qps: 16120.65 (r/w/o: 0.00/16120.65/0.00) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14966.04 qps: 14966.04 (r/w/o: 0.00/14966.04/0.00) lat (ms,99%): 1.64 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15760.83 qps: 15760.83 (r/w/o: 0.00/15760.83/0.00) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 249979
other: 0
total: 249979
transactions: 249979 (15621.88 per sec.)
queries: 249979 (15621.88 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15621.8832
time elapsed: 16.0018s
total number of events: 249979
Latency (ms):
min: 0.36
avg: 0.77
max: 126.66
99th percentile: 1.47
sum: 191789.91
Threads fairness:
events (avg/stddev): 20831.5833/37.37
execution time (avg/stddev): 15.9825/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 16243.86 qps: 16243.86 (r/w/o: 0.00/15603.71/640.15) lat (ms,99%): 1.61 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 17837.18 qps: 17837.18 (r/w/o: 0.00/15706.42/2130.76) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 17461.29 qps: 17461.29 (r/w/o: 0.00/14076.52/3384.76) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 241276
other: 35284
total: 276560
transactions: 276560 (17283.62 per sec.)
queries: 276560 (17283.62 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 17283.6195
time elapsed: 16.0013s
total number of events: 276560
Latency (ms):
min: 0.25
avg: 0.69
max: 118.96
99th percentile: 1.37
sum: 191765.58
Threads fairness:
events (avg/stddev): 23046.6667/62.63
execution time (avg/stddev): 15.9805/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
```
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #10656: PostgreSQL Proxy may return unexpected Row Description in prepared select statement
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #10656:
URL: https://github.com/apache/shardingsphere/issues/10656#issuecomment-855254139
# Before Refactor
```
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Initializing worker threads...
Creating table 'sbtest2'...
Creating table 'sbtest8'...
Creating table 'sbtest7'...
Creating table 'sbtest10'...
Creating table 'sbtest6'...
Creating table 'sbtest3'...
Creating table 'sbtest4'...
Creating table 'sbtest9'...
Creating table 'sbtest5'...
Creating table 'sbtest1'...
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest9'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest2'
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest6'...
Creating a secondary index on 'sbtest5'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1089.73 qps: 13089.81 (r/w/o: 10907.94/0.00/2181.87) lat (ms,99%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1397.17 qps: 16765.89 (r/w/o: 13971.54/0.00/2794.35) lat (ms,99%): 16.12 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1878.88 qps: 22544.61 (r/w/o: 18787.04/0.00/3757.57) lat (ms,99%): 15.83 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 236790
write: 0
other: 47358
total: 284148
transactions: 23679 (1479.09 per sec.)
queries: 284148 (17749.10 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1479.0914
time elapsed: 16.0092s
total number of events: 23679
Latency (ms):
min: 3.65
avg: 8.11
max: 176.79
99th percentile: 21.89
sum: 191978.28
Threads fairness:
events (avg/stddev): 1973.2500/8.38
execution time (avg/stddev): 15.9982/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1455.25 qps: 17477.41 (r/w/o: 14564.71/0.00/2912.70) lat (ms,99%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1284.11 qps: 15411.57 (r/w/o: 12843.14/0.00/2568.43) lat (ms,99%): 46.63 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1597.11 qps: 19162.09 (r/w/o: 15967.88/0.00/3194.22) lat (ms,99%): 21.11 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 238760
write: 0
other: 47752
total: 286512
transactions: 23876 (1491.68 per sec.)
queries: 286512 (17900.13 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1491.6774
time elapsed: 16.0061s
total number of events: 23876
Latency (ms):
min: 3.42
avg: 8.04
max: 298.49
99th percentile: 27.17
sum: 191949.74
Threads fairness:
events (avg/stddev): 1989.6667/10.39
execution time (avg/stddev): 15.9958/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 26704.57 qps: 26704.57 (r/w/o: 26704.57/0.00/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 26752.39 qps: 26752.39 (r/w/o: 26752.39/0.00/0.00) lat (ms,99%): 1.01 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 25730.53 qps: 25730.53 (r/w/o: 25730.53/0.00/0.00) lat (ms,99%): 1.16 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 424317
write: 0
other: 0
total: 424317
transactions: 424317 (26517.32 per sec.)
queries: 424317 (26517.32 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 26517.3182
time elapsed: 16.0015s
total number of events: 424317
Latency (ms):
min: 0.24
avg: 0.45
max: 120.81
99th percentile: 1.10
sum: 191716.41
Threads fairness:
events (avg/stddev): 35359.7500/117.77
execution time (avg/stddev): 15.9764/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 647.84 qps: 10387.93 (r/w/o: 6496.32/2593.54/1298.07) lat (ms,99%): 95.81 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 593.64 qps: 9501.30 (r/w/o: 5938.24/2375.78/1187.29) lat (ms,99%): 94.10 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1087.97 qps: 17397.40 (r/w/o: 10872.55/4348.90/2175.95) lat (ms,99%): 28.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 130880
write: 52352
other: 26176
total: 209408
transactions: 13088 (817.52 per sec.)
queries: 209408 (13080.34 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 817.5210
time elapsed: 16.0094s
total number of events: 13088
Latency (ms):
min: 5.89
avg: 14.67
max: 590.32
99th percentile: 71.83
sum: 192001.94
Threads fairness:
events (avg/stddev): 1090.6667/3.90
execution time (avg/stddev): 16.0002/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 3021.36 qps: 18135.57 (r/w/o: 0.00/12090.64/6044.92) lat (ms,99%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 2690.41 qps: 16140.29 (r/w/o: 0.00/10759.46/5380.83) lat (ms,99%): 13.70 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 3624.36 qps: 21748.97 (r/w/o: 0.00/14499.64/7249.32) lat (ms,99%): 6.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 200470
other: 100238
total: 300708
transactions: 50118 (3131.38 per sec.)
queries: 300708 (18788.29 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 3131.3812
time elapsed: 16.0051s
total number of events: 50118
Latency (ms):
min: 1.59
avg: 3.83
max: 171.53
99th percentile: 10.09
sum: 191899.17
Threads fairness:
events (avg/stddev): 4176.5000/14.86
execution time (avg/stddev): 15.9916/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 14750.75 qps: 14750.75 (r/w/o: 0.00/14750.75/0.00) lat (ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14705.09 qps: 14705.09 (r/w/o: 0.00/14705.09/0.00) lat (ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15132.74 qps: 15132.74 (r/w/o: 0.00/15132.74/0.00) lat (ms,99%): 1.47 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 238012
other: 0
total: 238012
transactions: 238012 (14874.09 per sec.)
queries: 238012 (14874.09 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 14874.0934
time elapsed: 16.0018s
total number of events: 238012
Latency (ms):
min: 0.27
avg: 0.81
max: 98.57
99th percentile: 1.64
sum: 191804.57
Threads fairness:
events (avg/stddev): 19834.3333/51.36
execution time (avg/stddev): 15.9837/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 14860.12 qps: 14860.12 (r/w/o: 0.00/14860.12/0.00) lat (ms,99%): 1.67 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 15319.64 qps: 15319.64 (r/w/o: 0.00/15319.64/0.00) lat (ms,99%): 1.58 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15704.99 qps: 15704.99 (r/w/o: 0.00/15704.99/0.00) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 243112
other: 0
total: 243112
transactions: 243112 (15192.65 per sec.)
queries: 243112 (15192.65 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15192.6484
time elapsed: 16.0020s
total number of events: 243112
Latency (ms):
min: 0.34
avg: 0.79
max: 103.51
99th percentile: 1.61
sum: 191805.60
Threads fairness:
events (avg/stddev): 20259.3333/55.38
execution time (avg/stddev): 15.9838/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 16984.27 qps: 16984.27 (r/w/o: 0.00/16275.56/708.71) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 17731.31 qps: 17731.31 (r/w/o: 0.00/15577.57/2153.74) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 17737.07 qps: 17737.07 (r/w/o: 0.00/14272.27/3464.80) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 245262
other: 36204
total: 281466
transactions: 281466 (17589.46 per sec.)
queries: 281466 (17589.46 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 17589.4593
time elapsed: 16.0020s
total number of events: 281466
Latency (ms):
min: 0.23
avg: 0.68
max: 105.12
99th percentile: 1.30
sum: 191765.73
Threads fairness:
events (avg/stddev): 23455.5000/58.59
execution time (avg/stddev): 15.9805/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
```
--
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
[GitHub] [shardingsphere] terrymanu closed issue #10656: PostgreSQL Proxy may return unexpected Row Description in prepared select statement
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #10656:
URL: https://github.com/apache/shardingsphere/issues/10656
--
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