Startup error in version 8.1.0
- Dominant language
- Go
- Stars
- 13.3k
- Forks
- 1.8k
- Avg merge
- 1d 18h
- Merged PRs (30d)
- 26
Description
### Question and Steps to reproduce
全新安装启动alert_rule表出现缺少字段 总共三个字段prod ,disabled还有update_at,请修复一下创建的sql脚本
### Relevant logs and configurations
```text
2025-07-24 10:25:21.310245 ERROR ormx/ormx.go:68 /home/runner/work/nightingale/nightingale/models/alert_rule.go:1131 Error 1054: Unknown column 'prod' in 'where clause'
[0.072ms] [rows:0] SELECT * FROM `alert_rule` WHERE prod in ('host') AND disabled = 0
2025/07/24 10:25:21 host_alert_rule_targets.go:72: failed to sync targets: Error 1054: Unknown column 'prod' in 'where clause'
```
### Version
8.1.0版本 系统版本RHEL 8 X86
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with models/alert_rule.go:1131 and the failing query shown in the report, then trace the fresh-install SQL creation script for alert_rule. Verify the schema includes prod, disabled, and update_at, and run a clean installation on MySQL to confirm the startup query and target synchronization no longer fail.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, mysql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100