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 2022/08/11 07:22:22 UTC

[GitHub] [shardingsphere] Bingai077 opened a new issue, #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Bingai077 opened a new issue, #20075:
URL: https://github.com/apache/shardingsphere/issues/20075

   Which version of ShardingSphere did you use?
   ghcr.io/apache/shardingsphere-proxy:c9cc117c8f4b42c220f89c92851bf945c40c71b0  (helm cluster)
   
   Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   Expected behavior
   JDBC connection is normal.
   
   Actual behavior
   java.sql.SQLException: Unknown system variable 'query_cache_size'
   ![image](https://user-images.githubusercontent.com/51192624/184082438-f5cfd40b-d56b-4861-bd8e-892bfabe8133.png)
   
   Environment Configurations
   ```
   props:
     check-duplicate-table-enabled: false
     check-table-metadata-enabled: true
     kernel-executor-size: 16
     max-connections-size-per-query: 1
     proxy-backend-driver-type: JDBC
     proxy-backend-executor-suitable: OLAP
     proxy-backend-query-fetch-size: -1
     proxy-frontend-executor-size: 0
     proxy-frontend-flush-threshold: 128
     proxy-frontend-max-connections: 0
     proxy-hint-enabled: true
     proxy-opentracing-enabled: false
     show-process-list-enabled: false
     sql-federation-enabled: false
     sql-show: true
     proxy-mysql-default-version: 8.0.21
   ```
   My mysql cloud server version is `8.0.21-5` 
   
   I need a little help.
   


-- 
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.apache.org

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


[GitHub] [shardingsphere] Bingai077 commented on issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #20075:
URL: https://github.com/apache/shardingsphere/issues/20075#issuecomment-1211740092

   Well, thank you very much! This problem is solved.


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


[GitHub] [shardingsphere] TeslaCN closed issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'
URL: https://github.com/apache/shardingsphere/issues/20075


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


[GitHub] [shardingsphere] TeslaCN commented on issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20075:
URL: https://github.com/apache/shardingsphere/issues/20075#issuecomment-1211662628

   Did you set `overwrite: true`?
   
   This issue may duplicate with 
   - https://github.com/apache/shardingsphere/issues/18482
   - https://github.com/apache/shardingsphere/issues/19649


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


[GitHub] [shardingsphere] TeslaCN commented on issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20075:
URL: https://github.com/apache/shardingsphere/issues/20075#issuecomment-1211737015

   ShardingSphere-Proxy will retrieve configurations, rules and metadatas from ZooKeeper before listening on port.


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


[GitHub] [shardingsphere] Bingai077 commented on issue #20075: JDBC connection Exception: Unknown system variable 'query_cache_size'

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #20075:
URL: https://github.com/apache/shardingsphere/issues/20075#issuecomment-1211726249

   I set up `overwrite: true`,but,I have a question.How do ShardingSphere read data from ZooKeeper during reboot?


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