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 2021/09/26 10:08:33 UTC
[GitHub] [shardingsphere] dyplus opened a new issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
dyplus opened a new issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771
![image](https://user-images.githubusercontent.com/54160389/129017482-f9fa98a0-5dc8-4446-b93e-5e1d4b6d84cc.png)
implementation('org.apache.shardingsphere:shardingsphere-jdbc-core-spring-boot-starter:5.0.0-beta')
--
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] terrymanu removed a comment on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu removed a comment on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-927276053
Closed because of no response anymore.
--
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] coolbeevip commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
coolbeevip commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909184424
Same issue
```
select VARIABLE_VALUE from performance_schema.global_variables where variable_name = 'pxc_strict_mode'
```
--
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] terrymanu commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-937475691
No response anymore, I just close the issue.
--
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] jinkun2014 commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
jinkun2014 commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-927092529
Caused by: org.apache.shardingsphere.infra.exception.ShardingSphereException: `global_variables` single table does not exist.
at org.apache.shardingsphere.sharding.route.engine.type.single.SingleTablesRoutingEngine.fillRouteContext(SingleTablesRoutingEngine.java:80)
at org.apache.shardingsphere.sharding.route.engine.type.single.SingleTablesRoutingEngine.route(SingleTablesRoutingEngine.java:59)
at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:61)
at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:47)
at org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:62)
at org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:52)
at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.route(KernelProcessor.java:54)
at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:46)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.createExecutionContext(ShardingSpherePreparedStatement.java:363)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeQuery(ShardingSpherePreparedStatement.java:178)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForString(JdbcTemplate.java:197)
at org.flywaydb.core.internal.database.mysql.MySQLDatabase.isRunningInPerconaXtraDBClusterWithStrictMode(MySQLDatabase.java:79)
at org.flywaydb.core.internal.database.mysql.MySQLDatabase.<init>(MySQLDatabase.java:61)
at org.flywaydb.core.internal.database.mysql.MySQLDatabaseType.createDatabase(MySQLDatabaseType.java:109)
at org.flywaydb.core.internal.database.base.BaseDatabaseType.createDatabase(BaseDatabaseType.java:141)
at org.flywaydb.core.Flyway.execute(Flyway.java:545)
at org.flywaydb.core.Flyway.migrate(Flyway.java:172)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1845)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782)
... 19 common frames omitted
--
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] terrymanu closed issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771
--
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] terrymanu commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-937475691
No response anymore, I just close the issue.
--
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] tristaZero edited a comment on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
@coolbeevip Thanks for feedback.
--
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] tristaZero edited a comment on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
@coolbeevip Thanks for feedback.
--
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] terrymanu closed issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771
--
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] tristaZero commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-899021577
Hi @dyplus Thanks for your issue. could you provide your SQL triggering this issue?
--
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] strongduanmu commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-927109361
@jinkun2014 Can you try the master branch? We support `performance_schema` query when using Proxy in the master branch.
--
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] tristaZero commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
--
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] tristaZero commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
--
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] lanchengx commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-927607804
@jinkun2014 Sorry for not replying in time, `performance_schema` is not supported yet, we will improve it as soon as possible.
--
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] coolbeevip commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
coolbeevip commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909184424
Same issue
```
select VARIABLE_VALUE from performance_schema.global_variables where variable_name = 'pxc_strict_mode'
```
--
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] terrymanu closed issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771
--
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] coolbeevip commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
coolbeevip commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909184424
Same issue
```
select VARIABLE_VALUE from performance_schema.global_variables where variable_name = 'pxc_strict_mode'
```
--
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] tristaZero edited a comment on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
@coolbeevip Thanks for feedback.
--
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] tristaZero commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-909196155
@lanchengx Hi could you look at this sql for our client's adapting work?
--
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] terrymanu commented on issue #11771: springboot project Used shardingsphere-jdbc and Flyway: throw ShardingSphereException `global_variables` single table does not exist
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #11771:
URL: https://github.com/apache/shardingsphere/issues/11771#issuecomment-927276053
Closed because of no response anymore.
--
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