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/04/29 02:15:29 UTC
[GitHub] [shardingsphere] RaigorJiang opened a new issue, #17191: Preparing failure in scaling because getting primary key failed
RaigorJiang opened a new issue, #17191:
URL: https://github.com/apache/shardingsphere/issues/17191
## Bug Report
### Which version of ShardingSphere did you use?
5.1.1 #5b117204
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
Scaling task started successfully.
### Actual behavior
The scaling task failed to start because the primary key of the table could not be found, but the table actually has a primary key.
<img width="1261" alt="image" src="https://user-images.githubusercontent.com/5668787/165874660-f218a1d9-5d1e-4f9e-86ee-47f5094bab78.png">
### Reason analyze (If you can)
```java
private static final String FETCH_PRIMARY_KEY_TEMPLATE = "SELECT constraint_name,column_name FROM information_schema"
+ ".key_column_usage WHERE table_name = '%s' AND table_schema='public'";
```
Because we only get the table information from the public schema, but the user is currently using another schema.
--
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] RaigorJiang commented on issue #17191: Preparing failure in scaling because getting primary key failed
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #17191:
URL: https://github.com/apache/shardingsphere/issues/17191#issuecomment-1127152353
Thank you! @sandynz
--
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] sandynz closed issue #17191: Preparing failure in scaling because getting primary key failed
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #17191: Preparing failure in scaling because getting primary key failed
URL: https://github.com/apache/shardingsphere/issues/17191
--
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] sandynz commented on issue #17191: Preparing failure in scaling because getting primary key failed
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #17191:
URL: https://github.com/apache/shardingsphere/issues/17191#issuecomment-1127129954
Customized schema of getting create table for PostgreSQL and openGauss has been supportted in #17379.
--
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