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/11/19 07:33:14 UTC
[GitHub] [shardingsphere] TianJieYouYue opened a new issue, #22276: Unknown system variable 'query_cache_size'
TianJieYouYue opened a new issue, #22276:
URL: https://github.com/apache/shardingsphere/issues/22276
## Bug Report
Unknown system variable 'query_cache_size'
Caused by: java.sql.SQLException: Unknown system variable 'query_cache_size'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-j-8.0.31.jar:8.0.31]
### Which version of ShardingSphere did you use?
apache-shardingsphere-5.2.1-shardingsphere-proxy-bin
mysql-connector-j-8.0.31
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
### Actual behavior
java.sql.SQLException: Unknown system variable 'query_cache_size'
### Reason analyze (If you can)
I don't know
--
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] TianJieYouYue closed issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue closed issue #22276: Unknown system variable 'query_cache_size'
URL: https://github.com/apache/shardingsphere/issues/22276
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320825516
plugins {
id("org.springframework.boot") version "2.7.5"
id("io.spring.dependency-management") version "1.0.15.RELEASE"
kotlin("jvm") version "1.6.21"
kotlin("plugin.spring") version "1.6.21"
kotlin("plugin.jpa") version "1.6.21"
}
implementation("org.springframework.boot:spring-boot-starter-web")
implementation("org.springframework.boot:spring-boot-starter-data-jpa")
implementation("org.jetbrains.kotlin:kotlin-reflect")
implementation("org.jetbrains.kotlin:kotlin-stdlib-jdk8")
implementation("org.jsoup:jsoup:1.10.2")
implementation("com.mysql:mysql-connector-j")
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320828905
Thanks for using Atomikos! This installation is not registered yet.
REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
- tips & advice
- working demos
- access to the full documentation
- special exclusive bonus offers not available to others
- everything you need to get the most out of using Atomikos!
--
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] zhaojinchao95 commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
zhaojinchao95 commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320888886
```
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: localhost:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
authority:
users:
- user: root@%
password: root
- user: sharding
password: sharding
privilege:
type: ALL_PERMITTED
#
#rules:
#- !TRANSACTION
# defaultType: XA
# providerType: Atomikos
#- !SQL_PARSER
# sqlCommentParseEnabled: true
# sqlStatementCache:
# initialCapacity: 2000
# maximumSize: 65535
# parseTreeCache:
# initialCapacity: 128
# maximumSize: 1024
props:
proxy-mysql-default-version: 5.7.22 # In the absence of schema name, the default version will be used.
```
Set `proxy-mysql-default-version:` paramater to your mysql version.
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320898464
> ```
> mode:
> type: Cluster
> repository:
> type: ZooKeeper
> props:
> namespace: governance_ds
> server-lists: localhost:2181
> retryIntervalMilliseconds: 500
> timeToLiveSeconds: 60
> maxRetries: 3
> operationTimeoutMilliseconds: 500
>
> authority:
> users:
> - user: root@%
> password: root
> - user: sharding
> password: sharding
> privilege:
> type: ALL_PERMITTED
> #
> #rules:
> #- !TRANSACTION
> # defaultType: XA
> # providerType: Atomikos
> #- !SQL_PARSER
> # sqlCommentParseEnabled: true
> # sqlStatementCache:
> # initialCapacity: 2000
> # maximumSize: 65535
> # parseTreeCache:
> # initialCapacity: 128
> # maximumSize: 1024
>
> props:
> proxy-mysql-default-version: 5.7.22 # In the absence of schema name, the default version will be used.
> ```
>
> Set `proxy-mysql-default-version:` paramater to your mysql version.
This works.
Thanks.
--
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] Qianyi951015 commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
Qianyi951015 commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320864752
Hi, @TianJieYouYue would you mind explaining how to reproduce the problem?
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320825686
[ERROR] 2022-11-19 15:35:26.808 [ShardingSphere-Command-0] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLException: Unknown system variable 'query_cache_size'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:780)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:103)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.impl.ProxyStatementExecutorCallback.execute(ProxyStatementExecutorCallback.java:41)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:74)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:67)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:44)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:95)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:75)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:135)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.parallelExecute(ExecutorEngine.java:131)
at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:116)
at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:65)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.executor.ProxyJDBCExecutor.execute(ProxyJDBCExecutor.java:74)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.useDriverToExecute(ProxySQLExecutor.java:199)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:157)
at org.apache.shardingsphere.proxy.backend.communication.ProxySQLExecutor.execute(ProxySQLExecutor.java:151)
at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:130)
at org.apache.shardingsphere.proxy.backend.handler.data.impl.UnicastDatabaseBackendHandler.execute(UnicastDatabaseBackendHandler.java:76)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:94)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:111)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320899058
@zhaojinchao95 batch insert very slow, when show sql, i found my batch insert change to one by one on ShardingSphere-Proxy.
How to fix?
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320825349
ShardingSphereProxyVersion - Database name is `MySQL`, version is `8.0.19`
ShardingSphere-Proxy Standalone mode started successfully
--
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] TianJieYouYue commented on issue #22276: Unknown system variable 'query_cache_size'
Posted by GitBox <gi...@apache.org>.
TianJieYouYue commented on issue #22276:
URL: https://github.com/apache/shardingsphere/issues/22276#issuecomment-1320825185
java8, full_version=1.8.0_312
--
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