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/10/14 10:51:24 UTC

[GitHub] [shardingsphere] ulwfcyvi commented on issue #13022: springboot + mybatis + shardingsphere agent. After starting springbStarting from the sixth query, only the total number of records can be queried, but the record content cannot be queried.

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org