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/11/20 03:16:32 UTC
[GitHub] [shardingsphere] roodkcab opened a new issue #13711: how to refresh table metadata after add column?
roodkcab opened a new issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711
## Bug Report
### Which version of ShardingSphere did you use?
master branch
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
table metadata should be refreshed after alter table
### Actual behavior
when using serverside preparestatement, prepare statement return wrong number of columns after add column or drop column on a table, which leading to empty result or segment fault on PDO client.
### Reason analyze (If you can)
table metadata didn't refresh. The mode is memory, and I execute alter table statement directly on database.
--
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] roodkcab closed issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab closed issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711
--
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] roodkcab closed issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab closed issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711
--
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] roodkcab edited a comment on issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab edited a comment on issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711#issuecomment-974751384
should use cluster mode.
add flowing config in server.yaml
```
mode:
type: cluster
repository:
type: etcd
props:
namespace: shardingsphere/projectname
server-lists: etcd1:2379,etcd2:2379:etcd3:2379
```
solve 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] roodkcab commented on issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab commented on issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711#issuecomment-974751384
should use cluster mode.
add flowing config in server.yaml
```
mode:
type: cluster
repository:
type: etcd
props:
namespace: shardingsphere/ali_manager
server-lists: etcd1:2379,etcd2:2379:etcd3:2379
```
solve 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] roodkcab edited a comment on issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab edited a comment on issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711#issuecomment-974751384
should use cluster mode.
add flowing config in server.yaml
```
mode:
type: cluster
repository:
type: etcd
props:
namespace: shardingsphere/projectname
server-lists: etcd1:2379,etcd2:2379:etcd3:2379
```
solve 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] roodkcab commented on issue #13711: table metadata didn't refresh after add column or drop column on table
Posted by GitBox <gi...@apache.org>.
roodkcab commented on issue #13711:
URL: https://github.com/apache/shardingsphere/issues/13711#issuecomment-974751384
should use cluster mode.
add flowing config in server.yaml
```
mode:
type: cluster
repository:
type: etcd
props:
namespace: shardingsphere/ali_manager
server-lists: etcd1:2379,etcd2:2379:etcd3:2379
```
solve 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