[GitHub] [shardingsphere] iamif3000 commented on issue #8218: “select * from t1” causes "ERROR 2027 (HY000): received malformed packet"

[GitBox <gi...@apache.org>]

iamif3000 commented on issue #8218:
URL: https://github.com/apache/shardingsphere/issues/8218#issuecomment-730181524


   > I can't reproduce it.
   > Can you show your config with proxy, and your mysql version(server/client)?
   
   server.yaml
   --------------------
   authentication:
     users:
       root:
         password: root
       sharding:
         password: sharding 
         authorizedSchemas: master_slave_db
   
   props:
     max.connections.size.per.query: 1
     acceptor.size: 4
     executor.size: 16
     proxy.frontend.flush.threshold: 128
     proxy.transaction.type: LOCAL
     proxy.opentracing.enabled: false
     proxy.hint.enabled: false
     query.with.cipher.column: true
     sql.show: true
     allow.range.query.with.inline.sharding: false
   
   config-master_slave.yaml
   -------------------------
   schemaName: master_slave_db
   
   dataSources:
     master_ds:
       url: jdbc:mysql://172.31.197.149:3306/proxy?serverTimezone=UTC&useSSL=false
       username: proxy
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
     slave_ds_0:
       url: jdbc:mysql://172.31.197.149:3307/proxy?serverTimezone=UTC&useSSL=false
       username: proxy
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
   
   masterSlaveRule:
     name: ms_ds
     masterDataSourceName: master_ds
     slaveDataSourceNames:
       - slave_ds_0
   
   client version
   -------------------------
   Ver 15.1 Distrib 10.5.8-MariaDB, for Linux (x86_64) using readline 5.1


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