ulwfcyvi commented on issue #13022:
URL:
https://github.com/apache/shardingsphere/issues/13022#issuecomment-943241809
> Hi @ulwfcyvi , could you submit issue with template? Much information is
needed for us
No DESCRIBE_COMMAND in the 6th query
[ERROR] 2021-10-14 18:43:35.564 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 42 00 00 00 5b 00 53 5f 32 00 00 01 00 01 00 01 |B...[.S_2.......|
|00000010| 00 00 00 04 00 00 00 06 00 21 00 01 00 01 00 01 |.........!......|
|00000020| 00 00 00 00 00 00 00 01 00 01 00 01 00 00 00 01 |................|
|00000030| 00 00 00 01 00 01 00 01 00 00 00 00 00 00 00 00 |................|
|00000040| 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
|00000050| 00 00 00 00 00 00 00 00 00 01 00 00 45 00 00 00 |............E...|
|00000060| 09 00 00 00 00 00 53 00 00 00 04 |......S.... |
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.564 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 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.... |
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.564 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 53 00 00 00 04 |S.... |
+--------+-------------------------------------------------+----------------+
[INFO ] 2021-10-14 18:43:35.565 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - Logic SQL: SELECT * FROM cf_trade_history WHERE
accountid=1 order by ordertimestamp desc LIMIT ?
[INFO ] 2021-10-14 18:43:35.565 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - SQLStatement:
PostgreSQLSelectStatement(limit=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment@5efd5fb6],
lock=Optional.empty, window=Optional.empty)
[INFO ] 2021-10-14 18:43:35.565 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT * FROM cf_trade_history_1
WHERE accountid=1 order by ordertimestamp desc LIMIT ? ::: [6]
The fifth query has DESCRIBE_COMMAND
[ERROR] 2021-10-14 18:43:35.551 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 50 00 00 00 66 53 5f 32 00 53 45 4c 45 43 54 20 |P...fS_2.SELECT |
|00000010| 2a 20 46 52 4f 4d 20 63 66 5f 74 72 61 64 65 5f |* FROM cf_trade_|
|00000020| 68 69 73 74 6f 72 79 20 57 48 45 52 45 20 61 63 |history WHERE ac|
|00000030| 63 6f 75 6e 74 69 64 3d 31 20 6f 72 64 65 72 20 |countid=1 order |
|00000040| 62 79 20 6f 72 64 65 72 74 69 6d 65 73 74 61 6d |by ordertimestam|
|00000050| 70 20 64 65 73 63 20 4c 49 4d 49 54 20 24 31 20 |p desc LIMIT $1 |
|00000060| 00 00 01 00 00 00 17 42 00 00 00 19 00 53 5f 32 |.......B.....S_2|
|00000070| 00 00 01 00 01 00 01 00 00 00 04 00 00 00 05 00 |................|
|00000080| 00 44 00 00 00 06 50 00 45 00 00 00 09 00 00 00 |.D....P.E.......|
|00000090| 00 00 53 00 00 00 04 |..S.... |
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.552 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 42 00 00 00 19 00 53 5f 32 00 00 01 00 01 00 01 |B.....S_2.......|
|00000010| 00 00 00 04 00 00 00 05 00 00 44 00 00 00 06 50 |..........D....P|
|00000020| 00 45 00 00 00 09 00 00 00 00 00 53 00 00 00 04 |.E.........S....|
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.552 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 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.... |
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.552 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 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.... |
+--------+-------------------------------------------------+----------------+
[ERROR] 2021-10-14 18:43:35.552 [nioEventLoopGroup-3-1]
o.a.s.db.protocol.codec.PacketCodec - Read from client 36d99ab3 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 53 00 00 00 04 |S.... |
+--------+-------------------------------------------------+----------------+
[INFO ] 2021-10-14 18:43:35.552 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - Logic SQL: SELECT * FROM cf_trade_history WHERE
accountid=1 order by ordertimestamp desc LIMIT ?
[INFO ] 2021-10-14 18:43:35.552 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - SQLStatement:
PostgreSQLSelectStatement(limit=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment@5efd5fb6],
lock=Optional.empty, window=Optional.empty)
[INFO ] 2021-10-14 18:43:35.552 [Connection-1-ThreadExecutor]
ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT * FROM cf_trade_history_1
WHERE accountid=1 order by ordertimestamp desc LIMIT ? ::: [5]
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
