You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@rocketmq.apache.org by "Aias00 (via GitHub)" <gi...@apache.org> on 2026/08/09 05:13:40 UTC
[I] fix: align MySQL instance schema with persisted instance fields [rocketmq-dashboard]
Aias00 opened a new issue, #1289:
URL: https://github.com/apache/rocketmq-dashboard/issues/1289
## Problem
A fresh MySQL database initialized with `server/src/main/resources/db/schema.sql` cannot serve `GET /api/instances`.
`RmqInstance` and `MybatisPlusInstanceRepository` persist and select these columns:
- `vendor`
- `cloud_instance_id`
- `credential_id`
- `region_id`
However, the `rmq_instance` DDL currently defines none of them. MyBatis-Plus therefore generates a query that references missing columns and the endpoint returns HTTP 500.
## Reproduction
1. Create an empty MySQL database.
2. Import `server/src/main/resources/db/schema.sql`.
3. Start Studio with that database.
4. Call `GET /api/instances`.
Expected: `200` with an empty list.
Actual: `500` due to missing `rmq_instance` columns.
## Scope
Track 1 / control-plane persistence baseline. Update the authoritative DDL and add a regression test that validates the schema supports instance repository reads/writes.
--
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: commits-unsubscribe@rocketmq.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] fix: align MySQL instance schema with persisted instance fields [rocketmq-dashboard]
Posted by "Aias00 (via GitHub)" <gi...@apache.org>.
Aias00 closed issue #1289: fix: align MySQL instance schema with persisted instance fields
URL: https://github.com/apache/rocketmq-dashboard/issues/1289
--
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: commits-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] fix: align MySQL instance schema with persisted instance fields [rocketmq-dashboard]
Posted by "Aias00 (via GitHub)" <gi...@apache.org>.
Aias00 commented on issue #1289:
URL: https://github.com/apache/rocketmq-dashboard/issues/1289#issuecomment-5230030095
Resolved by #1293, which supersedes the prior schema-only PR and validates the default H2 development startup path.
--
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: commits-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org