You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "medivh666 (via GitHub)" <gi...@apache.org> on 2023/12/05 16:35:51 UTC
[I] Unknown system variable 'query_cache_size' [shardingsphere]
medivh666 opened a new issue, #29300:
URL: https://github.com/apache/shardingsphere/issues/29300
apt-get install mysql-server
mysql> SELECT VERSION();
+-------------------------+
| VERSION() |
+-------------------------+
| 8.0.35-0ubuntu0.22.04.1 |
+-------------------------+
I tried the following configuration,But an error is still reported
props:
proxy-mysql-default-version: 8.0.35
or
props:
proxy-mysql-default-version: 8.0.35-0ubuntu0.22.04.1
======error======
[ERROR] 16:30:48.824 [main] com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: Unknown system variable 'query_cache_size'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3766)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3229)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2238)
--
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
Re: [I] Unknown system variable 'query_cache_size' [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #29300:
URL: https://github.com/apache/shardingsphere/issues/29300#issuecomment-1842186653
@medivh666
What's the version of mysql-connector-java?
--
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
Re: [I] Unknown system variable 'query_cache_size' [shardingsphere]
Posted by "medivh666 (via GitHub)" <gi...@apache.org>.
medivh666 commented on issue #29300:
URL: https://github.com/apache/shardingsphere/issues/29300#issuecomment-1844409827
sorrry , I run it from an old document ，It ran successfully according to the latest documentation
--
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
Re: [I] Unknown system variable 'query_cache_size' [shardingsphere]
Posted by "medivh666 (via GitHub)" <gi...@apache.org>.
medivh666 closed issue #29300: Unknown system variable 'query_cache_size'
URL: https://github.com/apache/shardingsphere/issues/29300
--
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