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/01/13 06:53:03 UTC

[GitHub] [shardingsphere] xsong123 opened a new issue #14732: how to refreshTableMetaData

xsong123 opened a new issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732


   version:
   shardingsphere5.0.0
   mysql5.7
   
   procedure:
   two app link to the same db, one create table in the db, another query included the table from the db .
   
   error:
   java.lang.NullPointerException
   at org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.getOrderValuesCaseSensitiveFromTables(OrderByValue.java:74)
   at org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.getOrderValuesCaseSensitive(OrderByValue.java:64)
   at org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.(OrderByValue.java:58)
   at org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByStreamMergedResult.orderResultSetsToQueue(OrderByStreamMergedResult.java:56)
   at org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByStreamMergedResult.(OrderByStreamMergedResult.java:50)
   at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByStreamMergedResult.(GroupByStreamMergedResult.java:52)
   at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.getGroupByMergedResult(ShardingDQLResultMerger.java:108)
   at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.build(ShardingDQLResultMerger.java:78)
   at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.merge(ShardingDQLResultMerger.java:63)
   at org.apache.shardingsphere.infra.merge.MergeEngine.executeMerge(MergeEngine.java:90)
   at org.apache.shardingsphere.infra.merge.MergeEngine.merge(MergeEngine.java:80)
   at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.mergeQuery(ShardingSpherePreparedStatement.java:393)
   at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeQuery(ShardingSpherePreparedStatement.java:182)


-- 
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 edited a comment on issue #14732: how to refreshMetaData

Posted by GitBox <gi...@apache.org>.
lanchengx edited a comment on issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732#issuecomment-1011856769


   For the refresh table metadata statement, please refer to [RAL]( https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/#%E5%85%B6%E4%BB%96) , currently only Proxy supports using DistSQL,the relevant metadata on zk will be updated


-- 
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 #14732: how to refreshMetaData

Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732#issuecomment-1011856769


   For the refresh table metadata statement, please refer to [RAL]( https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/#%E5%85%B6%E4%BB%96) , currently only Proxy supports using DistSQL.


-- 
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] menghaoranss commented on issue #14732: how to refreshMetaData

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732#issuecomment-1011888553


   which mode did you use, `Cluster` or `Standalone`?


-- 
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] xsong123 commented on issue #14732: how to refreshTableMetaData

Posted by GitBox <gi...@apache.org>.
xsong123 commented on issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732#issuecomment-1011847162


   old issue #13853


-- 
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] xsong123 commented on issue #14732: how to refreshMetaData

Posted by GitBox <gi...@apache.org>.
xsong123 commented on issue #14732:
URL: https://github.com/apache/shardingsphere/issues/14732#issuecomment-1012148865


   > which mode did you use, `Cluster` or `Standalone`?
   
   it's Cluster.
   different apps access to the same db, when one app create a table ,another app cannot get the table's metadata.


-- 
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