TeslaCN opened a new issue #10153:
URL: https://github.com/apache/shardingsphere/issues/10153


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   master branch
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Actual behavior
   
   ```
   Breakpoint reached at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.BinaryStatementRegistry.register(BinaryStatementRegistry.java:51)
   2
   [DEBUG] 14:18:51.459 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 00 00 00 77 00 03 00 00 75 73 65 72 00 72 6f 6f |...w....user.roo|
   |00000010| 74 00 64 61 74 61 62 61 73 65 00 73 68 61 72 64 |t.database.shard|
   |00000020| 69 6e 67 5f 64 62 00 63 6c 69 65 6e 74 5f 65 6e |ing_db.client_en|
   |00000030| 63 6f 64 69 6e 67 00 55 54 46 38 00 44 61 74 65 |coding.UTF8.Date|
   |00000040| 53 74 79 6c 65 00 49 53 4f 00 65 78 74 72 61 5f |Style.ISO.extra_|
   |00000050| 66 6c 6f 61 74 5f 64 69 67 69 74 73 00 32 00 54 |float_digits.2.T|
   |00000060| 69 6d 65 5a 6f 6e 65 00 41 73 69 61 2f 53 68 61 |imeZone.Asia/Sha|
   |00000070| 6e 67 68 61 69 00 00                            |nghai..         |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.460 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 52 00 00 00 0c 00 00 00 05 17 26 25 78          |R.........&%x   |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.465 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 70 00 00 00 28 6d 64 35 63 30 35 66 33 63 37 30 |p...(md5c05f3c70|
   |00000010| 64 61 34 34 63 66 30 66 30 36 65 35 61 38 64 31 |da44cf0f06e5a8d1|
   |00000020| 64 66 34 63 65 31 36 65 00                      |df4ce16e.       |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.466 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 52 00 00 00 08 00 00 00 00                      |R........       |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.466 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 53 00 00 00 18 73 65 72 76 65 72 5f 76 65 72 73 |S....server_vers|
   |00000010| 69 6f 6e 00 31 32 2e 33 00                      |ion.12.3.       |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.466 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 53 00 00 00 19 63 6c 69 65 6e 74 5f 65 6e 63 6f |S....client_enco|
   |00000010| 64 69 6e 67 00 55 54 46 38 00                   |ding.UTF8.      |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.466 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 53 00 00 00 19 73 65 72 76 65 72 5f 65 6e 63 6f |S....server_enco|
   |00000010| 64 69 6e 67 00 55 54 46 38 00                   |ding.UTF8.      |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.466 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 5a 00 00 00 05 49                               |Z....I          |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.492 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 50 00 00 00 0d 00 42 45 47 49 4e 00 00 00 42 00 |P.....BEGIN...B.|
   |00000010| 00 00 0c 00 00 00 00 00 00 00 00 45 00 00 00 09 |...........E....|
   |00000020| 00 00 00 00 00 50 00 00 00 50 00 49 4e 53 45 52 |.....P...P.INSER|
   |00000030| 54 20 49 4e 54 4f 20 62 6d 73 71 6c 5f 63 6f 6e |T INTO bmsql_con|
   |00000040| 66 69 67 20 28 20 20 63 66 67 5f 6e 61 6d 65 2c |fig (  cfg_name,|
   |00000050| 20 63 66 67 5f 76 61 6c 75 65 29 20 56 41 4c 55 | cfg_value) VALU|
   |00000060| 45 53 20 28 24 31 2c 20 24 32 29 00 00 02 00 00 |ES ($1, $2).....|
   |00000070| 04 13 00 00 04 13 42 00 00 00 23 00 00 00 02 00 |......B...#.....|
   |00000080| 00 00 00 00 02 00 00 00 0a 77 61 72 65 68 6f 75 |.........warehou|
   |00000090| 73 65 73 00 00 00 01 31 00 00 44 00 00 00 06 50 |ses....1..D....P|
   |000000a0| 00 45 00 00 00 09 00 00 00 00 00 53 00 00 00 04 |.E.........S....|
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.498 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 42 00 00 00 0c 00 00 00 00 00 00 00 00 45 00 00 |B............E..|
   |00000010| 00 09 00 00 00 00 00 50 00 00 00 50 00 49 4e 53 |.......P...P.INS|
   |00000020| 45 52 54 20 49 4e 54 4f 20 62 6d 73 71 6c 5f 63 |ERT INTO bmsql_c|
   |00000030| 6f 6e 66 69 67 20 28 20 20 63 66 67 5f 6e 61 6d |onfig (  cfg_nam|
   |00000040| 65 2c 20 63 66 67 5f 76 61 6c 75 65 29 20 56 41 |e, cfg_value) VA|
   |00000050| 4c 55 45 53 20 28 24 31 2c 20 24 32 29 00 00 02 |LUES ($1, $2)...|
   |00000060| 00 00 04 13 00 00 04 13 42 00 00 00 23 00 00 00 |........B...#...|
   |00000070| 02 00 00 00 00 00 02 00 00 00 0a 77 61 72 65 68 |...........wareh|
   |00000080| 6f 75 73 65 73 00 00 00 01 31 00 00 44 00 00 00 |ouses....1..D...|
   |00000090| 06 50 00 45 00 00 00 09 00 00 00 00 00 53 00 00 |.P.E.........S..|
   |000000a0| 00 04                                           |..              |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.499 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
PARSE_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.parse.PostgreSQLComParsePacket@6e915c9a
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.500 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 45 00 00 00 09 00 00 00 00 00 50 00 00 00 50 00 |E.........P...P.|
   |00000010| 49 4e 53 45 52 54 20 49 4e 54 4f 20 62 6d 73 71 |INSERT INTO bmsq|
   |00000020| 6c 5f 63 6f 6e 66 69 67 20 28 20 20 63 66 67 5f |l_config (  cfg_|
   |00000030| 6e 61 6d 65 2c 20 63 66 67 5f 76 61 6c 75 65 29 |name, cfg_value)|
   |00000040| 20 56 41 4c 55 45 53 20 28 24 31 2c 20 24 32 29 | VALUES ($1, $2)|
   |00000050| 00 00 02 00 00 04 13 00 00 04 13 42 00 00 00 23 |...........B...#|
   |00000060| 00 00 00 02 00 00 00 00 00 02 00 00 00 0a 77 61 |..............wa|
   |00000070| 72 65 68 6f 75 73 65 73 00 00 00 01 31 00 00 44 |rehouses....1..D|
   |00000080| 00 00 00 06 50 00 45 00 00 00 09 00 00 00 00 00 |....P.E.........|
   |00000090| 53 00 00 00 04                                  |S....           |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.502 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 50 00 00 00 50 00 49 4e 53 45 52 54 20 49 4e 54 |P...P.INSERT INT|
   |00000010| 4f 20 62 6d 73 71 6c 5f 63 6f 6e 66 69 67 20 28 |O bmsql_config (|
   |00000020| 20 20 63 66 67 5f 6e 61 6d 65 2c 20 63 66 67 5f |  cfg_name, cfg_|
   |00000030| 76 61 6c 75 65 29 20 56 41 4c 55 45 53 20 28 24 |value) VALUES ($|
   |00000040| 31 2c 20 24 32 29 00 00 02 00 00 04 13 00 00 04 |1, $2)..........|
   |00000050| 13 42 00 00 00 23 00 00 00 02 00 00 00 00 00 02 |.B...#..........|
   |00000060| 00 00 00 0a 77 61 72 65 68 6f 75 73 65 73 00 00 |....warehouses..|
   |00000070| 00 01 31 00 00 44 00 00 00 06 50 00 45 00 00 00 |..1..D....P.E...|
   |00000080| 09 00 00 00 00 00 53 00 00 00 04                |......S....     |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.507 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 42 00 00 00 23 00 00 00 02 00 00 00 00 00 02 00 |B...#...........|
   |00000010| 00 00 0a 77 61 72 65 68 6f 75 73 65 73 00 00 00 |...warehouses...|
   |00000020| 01 31 00 00 44 00 00 00 06 50 00 45 00 00 00 09 |.1..D....P.E....|
   |00000030| 00 00 00 00 00 53 00 00 00 04                   |.....S....      |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.509 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 44 00 00 00 06 50 00 45 00 00 00 09 00 00 00 00 |D....P.E........|
   |00000010| 00 53 00 00 00 04                               |.S....          |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLComBindPacket.<init>(PostgreSQLComBindPacket.java:57)
   2
   [DEBUG] 14:18:51.510 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
BIND_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLComBindPacket@42fa7dc9
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.512 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 45 00 00 00 09 00 00 00 00 00 53 00 00 00 04    |E.........S.... |
   +--------+-------------------------------------------------+----------------+
   [INFO ] 14:18:51.512 [pool-8-thread-1] ShardingSphere-SQL - Logic SQL: BEGIN
   [INFO ] 14:18:51.512 [pool-8-thread-1] ShardingSphere-SQL - SQLStatement: 
PostgreSQLBeginTransactionStatement()
   [INFO ] 14:18:51.512 [pool-8-thread-1] ShardingSphere-SQL - Actual SQL: 
test_0 ::: BEGIN
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.525 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Read from client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 53 00 00 00 04                                  |S....           |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.544 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
EXECUTE_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.execute.PostgreSQLComExecutePacket@3185a061
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.state.impl.OKProxyState.execute(OKProxyState.java:42)
   2
   [DEBUG] 14:18:51.545 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 31 00 00 00 04                                  |1....           |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.545 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 32 00 00 00 04                                  |2....           |
   +--------+-------------------------------------------------+----------------+
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.546 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 43 00 00 00 07 20 30 00                         |C.... 0.        |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.546 [epollEventLoopGroup-3-2] 
o.a.s.db.protocol.codec.PacketCodec - Write to client a50c6f34 : 
             +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 5a 00 00 00 05 49                               |Z....I          |
   +--------+-------------------------------------------------+----------------+
   [DEBUG] 14:18:51.547 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
PARSE_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.parse.PostgreSQLComParsePacket@11bc9a7b
   Breakpoint reached at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.BinaryStatementRegistry.unregister(BinaryStatementRegistry.java:60)
   2
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   Breakpoint reached at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLComBindPacket.<init>(PostgreSQLComBindPacket.java:57)
   2
   [ERROR] 14:18:51.612 [pool-8-thread-1] o.a.s.p.f.c.CommandExecutorTask - 
Exception occur: 
   java.lang.NullPointerException: null
        at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.bind.PostgreSQLComBindPacket.<init>(PostgreSQLComBindPacket.java:57)
        at 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.PostgreSQLCommandPacketFactory.newInstance(PostgreSQLCommandPacketFactory.java:53)
        at 
org.apache.shardingsphere.proxy.frontend.postgresql.command.PostgreSQLCommandExecuteEngine.getCommandPacket(PostgreSQLCommandExecuteEngine.java:56)
        at 
org.apache.shardingsphere.proxy.frontend.postgresql.command.PostgreSQLCommandExecuteEngine.getCommandPacket(PostgreSQLCommandExecuteEngine.java:47)
        at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:91)
        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)
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.618 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
DESCRIBE_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.describe.PostgreSQLComDescribePacket@2f083f13
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.619 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
EXECUTE_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.execute.PostgreSQLComExecutePacket@359f888f
   Breakpoint reached at 
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:64)
   2
   [DEBUG] 14:18:51.621 [pool-8-thread-1] 
o.a.s.p.f.p.c.PostgreSQLCommandExecutorFactory - Execute packet type: 
SYNC_COMMAND, value: 
org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.binary.sync.PostgreSQLComSyncPacket@4c1b0739
   ```
   
   ### Reason analyze (If you can)
   
   The connection was terminated and the method 
`BinaryStatementRegistry#unregister` was invoked. But there were some 
`CommandExecutorTask` still in the ExecutorService. After those tasks ran and 
tried to get `ConnectionScopeBinaryStatementRegistry` with an unregistered 
connectionId, the NPE occueed.
   
   The connection had already been terminated and the method 
`BinaryStatementRegistry#unregister` had been invoked. But there were still 
some `CommandExecutorTask` in the ExecutorService. Those tasks started running 
after the connectionId unregistering and tried to get 
`ConnectionScopeBinaryStatementRegistry` with an unregistered connectionId, 
which caused the NPE.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   
   Follow the `How-to-Use` of benchmarkSQL 5.0.
   ```bash
   ./runDatabaseBuild.sh ss_proxy_pg.properties
   ```
   
   ```
   schemaName: sharding_db
   
   dataSources:
     test_0:
       url: 
jdbc:postgresql://pg.local.wwj.icu:5432/test_0?serverTimezone=UTC&useSSL=false
       username: postgres
       password: postgres
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
       maintenanceIntervalMilliseconds: 30000
   
   rules:
     - !SHARDING
       tables:
         bmsql_config:
           actualDataNodes: test_0.bmsql_config_0
         bmsql_customer:
           actualDataNodes: test_0.bmsql_customer_0
         bmsql_district:
           actualDataNodes: test_0.bmsql_district_0
         bmsql_hist_id_seq:
           actualDataNodes: test_0.bmsql_hist_id_seq_0
         bmsql_history:
           actualDataNodes: test_0.bmsql_history_0
         bmsql_item:
           actualDataNodes: test_0.bmsql_item_0
         bmsql_new_order:
           actualDataNodes: test_0.bmsql_new_order_0
         bmsql_oorder:
           actualDataNodes: test_0.bmsql_oorder_0
         bmsql_order_line:
           actualDataNodes: test_0.bmsql_order_line_0
         bmsql_stock:
           actualDataNodes: test_0.bmsql_stock_0
         bmsql_warehouse:
           actualDataNodes: test_0.bmsql_warehouse_0
       defaultDatabaseStrategy:
         none:
       defaultTableStrategy:
         none:
   ```
   


-- 
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]


Reply via email to