You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "8baba (via GitHub)" <gi...@apache.org> on 2023/10/30 15:37:33 UTC
[I] Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist , please help me！ [shardingsphere]
8baba opened a new issue, #28900:
URL: https://github.com/apache/shardingsphere/issues/28900
## Question
I want to use flyway to manage the database version, I want to use the data source of shardingjdbc, but I encounter various problems when I start, please help me look at this problem.
### dependencies version:
shardingsphere-jdbc-core-spring-boot-starter:5.1.1
flyway-core:8.5.13
flyway-mysql:8.5.13
mysql-connector-j:8.0.33
jdk8
### application.yaml
``` yaml
spring:
autoconfigure:
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
shardingsphere:
enabled: true
datasource:
schema:
name: store
names: store
store:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
username: root
password: root
url: jdbc:mysql://pigx-mysql:3306/store?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
props:
sql-show: true
rules:
sharding:
sharding-algorithms:
table-inline:
props:
algorithm-expression: store_$->{tenant_id}
type: INLINE
tables:
version:
actual-data-nodes: store.t_version
table-strategy:
none:
store:
actual-data-nodes: store.store_1716476137853374465, store.store_1717116448820633602
table-strategy:
standard:
sharding-algorithm-name: table-inline
sharding-column: tenant_id
## flyway ---------------------------------
flyway:
enabled: true
baseline-on-migrate: true
clean-disabled: false
out-of-order: true
```
### The following exception is displayed when the startup is displayed
``` java
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed;
nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: Unable to check whether schema `store` exists
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException: Unable to check whether schema `store` exists
Caused by: java.sql.SQLSyntaxErrorException: Table 'store.schemata' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-j-8.0.33.jar:8.0.33]
```
#### SQL execution logs
``` sql
Logic SQL: SELECT COUNT(1) FROM information_schema.schemata WHERE schema_name=? LIMIT 1
Actual SQL: store ::: SELECT COUNT(1) FROM schemata WHERE schema_name=? LIMIT 1 ::: [store]
```
shardingjdbc routes SQL statements to the `store` database
So I added the information_schema to the data source, and configured it as follows
```yaml
datasource:
names: store, information_schema
....
information_schema:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
username: root
password: root
url: jdbc:mysql://pigx-mysql:3306/information_schema
...
rules:
...
sharding:
tables:
schemata:
actual-data-nodes: information_schema.schemata
table-strategy:
none:
tables:
actual-data-nodes: information_schema.tables
table-strategy:
none:
...
```
### The following is the startup execution log
``` java
Sql log:
Logic SQL: SELECT COUNT(1) FROM information_schema.schemata WHERE schema_name=? LIMIT 1
Actual SQL: information_schema ::: SELECT COUNT(1) FROM schemata WHERE schema_name=? LIMIT 1 ::: [store]
Exception information：
2023-10-30 22:36:40.986 WARN 23832 --- [ main] s.c.a.AnnotationConfigApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.apache.shardingsphere.infra.exception.SchemaNotExistedException: Schema 'store' doesn't exist.
....
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.apache.shardingsphere.infra.exception.SchemaNotExistedException: Schema 'store' doesn't exist.
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.30.jar:5.3.30]
....
Caused by: org.apache.shardingsphere.infra.exception.SchemaNotExistedException: Schema 'store' doesn't exist.
at org.apache.shardingsphere.infra.binder.statement.dml.SelectStatementContext.getSchema(SelectStatementContext.java:138) ~[shardingsphere-infra-binder-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.infra.binder.statement.dml.SelectStatementContext.<init>(SelectStatementContext.java:111) ~[shardingsphere-infra-binder-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.infra.binder.SQLStatementContextFactory.getDMLStatementContext(SQLStatementContextFactory.java:146) ~[shardingsphere-infra-binder-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.infra.binder.SQLStatementContextFactory.newInstance(SQLStatementContextFactory.java:129) ~[shardingsphere-infra-binder-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.infra.binder.SQLStatementContextFactory.newInstance(SQLStatementContextFactory.java:114) ~[shardingsphere-infra-binder-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:181) ~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:149) ~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:80) ~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:300) ~[flyway-core-8.5.13.jar:na]
at org.flywaydb.core.internal.jdbc.JdbcTemplate.query(JdbcTemplate.java:339) ~[flyway-core-8.5.13.jar:na]
....
```
### shardingjdbc can't find the schema for the store, the break point is only the schema of the logic_db, please teach how to solve this problem
## The git address of the project
https://github.com/8baba/flyway-shardingjdbc-test
## How will I properly use Flyway to manage the database? Thank you
--
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] Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #28900:
URL: https://github.com/apache/shardingsphere/issues/28900#issuecomment-2212484868
`shardingsphere-jdbc-core-spring-boot-starter` is deprecated, please try new version and use ShardingSphere Driver.
--
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] Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #28900:
URL: https://github.com/apache/shardingsphere/issues/28900#issuecomment-1837585460
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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] Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist [shardingsphere]
Posted by "Dr-wgy (via GitHub)" <gi...@apache.org>.
Dr-wgy commented on issue #28900:
URL: https://github.com/apache/shardingsphere/issues/28900#issuecomment-3068198614
[information_schema.schemata](https://github.com/apache/shardingsphere/issues/16234)
use 5.5.2 version also have 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
Re: [I] Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #28900: Shardingsphere and Flyway integration startup error: Schema 'xxxx' doesn't exist
URL: https://github.com/apache/shardingsphere/issues/28900
--
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