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'

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