terrymanu commented on issue #25931:
URL:
https://github.com/apache/shardingsphere/issues/25931#issuecomment-3635205016
## Problem Understanding
- You reported “metadata in MySQL is overwritten after restart,” but it’s
unclear what exactly happens: is the repository table emptied, existing keys
reset to YAML/default values, or DistSQL-added rules/databases lost? We need to
know what “overwritten” means and which
key/value entries changed.
## Root Cause
- Without a clear definition of what was “overwritten,” we can’t pinpoint
the cause. In Standalone + JDBC repository, startup loads existing /metadata/*
nodes; if the repository is seen as empty, it rebuilds from local config and
writes back. Whether this is a logic
issue or a configuration/usage issue depends on the specific changes you
observed.
## Analysis
- Please provide:
1. What “overwritten” looks like: is the repository table cleared, or
are specific keys reset? Share before/after key/value examples for the same key.
2. Which rules/databases you added or modified via DistSQL before
restart, and which ones you expected to persist but disappeared.
3. The database name/table name used for the repository, row counts
before/after restart, and whether Proxy startup logs show errors/warnings
(driver, permission, connection).
## Conclusion
- Current information is insufficient. Once you clarify what “overwritten”
means and share the details above, we can determine whether it’s a
configuration/usage issue or a real code defect.
--
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]
