Re: [I] A single table is successfully created.However,the ZK registration center doesn't contain the table information. [shardingsphere]

["terrymanu (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org