terrymanu commented on issue #28965:
URL:
https://github.com/apache/shardingsphere/issues/28965#issuecomment-3621597085
### Problem Understanding
- In 5.4.2-SNAPSHOT (built in 2022-12, dirty), using ShardingSphere-Proxy
with ZooKeeper governance, a batch of CREATE TABLE statements succeeds in the
physical DB, but ZooKeeper does not show table metadata and queries return
“Table or view table_type_002 does not
exist.”
### Root Cause
- Likely the new single-table metadata was not persisted to the governance
center, commonly because the DDL did not go through Proxy or only refresh …
from governance center was used without syncing from the source database.
### Analysis
- Per official usage, all DDL should be executed through Proxy so metadata
is written to the registry; if tables are created directly on the backend, you
need DistSQL REFRESH TABLE METADATA FROM SOURCE to sync metadata (doc:
https://shardingsphere.apache.org/document/
current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-table-metadata/
(https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-table-metadata/)).
### Conclusion
- Could you confirm whether the CREATE TABLE statements were executed via
ShardingSphere-Proxy or directly on the backend database? This will help
determine if it’s a usage gap or needs deeper investigation.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
