zhusaidong opened a new issue, #4087:
URL: https://github.com/apache/hertzbeat/issues/4087
### Question
我怎么找不到表结构啊。只有一个flyway_schema_history,然后报错
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880750005+08:00 stdout F
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V180__update_column.sql failed
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880751628+08:00 stdout F
----------------------------------------
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880753211+08:00 stdout F
SQL State : 42S02
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880754764+08:00 stdout F
Error Code : 1146
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880756337+08:00 stdout F
Message : Table 'hertzbeat.hzb_monitor' doesn't exist
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.88075801+08:00 stdout F
Location : db/migration/mysql/V180__update_column.sql
(/opt/hertzbeat/file:/opt/hertzbeat/apache-hertzbeat-1.8.0.jar!/db/migration/mysql/V180__update_column.sql)
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880759643+08:00 stdout F
Line : 79
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880761206+08:00 stdout F
Statement : -- Update instance with port
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880762779+08:00 stdout F
UPDATE hzb_monitor m
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880765585+08:00 stdout F
INNER JOIN hzb_param p ON m.id = p.monitor_id AND p.field = 'port'
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880767288+08:00 stdout F
SET m.instance = CONCAT(m.instance, ':', p.param_value)
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880768891+08:00 stdout F
WHERE m.instance IS NOT NULL AND p.param_value IS NOT NULL AND p.param_value !=
''
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880770474+08:00 stdout F
AND m.instance NOT LIKE CONCAT('%:', p.param_value)
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880771936+08:00 stdout F
2026-03-24T15:47:06+08:00 2026-03-24T15:47:05.880773559+08:00 stdout F
--
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-unsubscr...@hertzbeat.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@hertzbeat.apache.org
For additional commands, e-mail: notifications-h...@hertzbeat.apache.org