ccfos / ccfos/nightingale

Startup error in version 8.1.0

Open
#2,802 6 comments 0 reactions 0 assignees View on GitHub
user-error
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.