andyg2 commented on issue #2206:
URL: https://github.com/apache/hertzbeat/issues/2206#issuecomment-2210556257
> Hi, Can you provide detail content of `./conf/application.yml`. I tried to
reproduce the bug in your steps, but failed to reproduce. I guess your
`application.yml` miss the `flyway` configuration. So I deleted the `flyway`
configuration in the latest `application.yml` and successfully reproduced the
bug you mentioned. I hope this helps you. You can provide more information so
we can help you solve this problem further.
Sure, it's was 100% untouched from the 1.6.0 release. I see in the master
branch there's numerous changes including flyway. Should I be cloning the
master branch instead of using the releases?
Currently though I've added the flyway config from the master branch and
HertzBeat seems to have started up ok and I can at least log in.
```
...
...
...
mail:
# Attention: this is mail server address.
# 请注意此为邮件服务器地址：qq邮箱为 smtp.qq.com qq企业邮箱为 smtp.exmail.qq.com
host: smtp.qq.com
username: [email protected]
# Attention: this is not email account password, this requires an email
authorization code
# 请注意此非邮箱账户密码 此需填写邮箱授权码
password: xxqzvuqbnqvbbdac
port: 465
default-encoding: UTF-8
properties:
mail:
smtp:
socketFactoryClass: javax.net.ssl.SSLSocketFactory
ssl:
enable: true
# - Added flyway config (from master)
flyway:
enabled: true
clean-disabled: true
baseline-on-migrate: true
baseline-version: 1
locations:
- classpath:db/migration/{vendor}
# // Added from master branch
warehouse:
store:
...
...
...
```
There were some warnings output by HertzBeat though (below) - are these
anything to be concerned about? If not feel free to close this issue, your
direction was very much appreciated.
```
_ _ _ ____ _
| | | | ___ _ __| |_ ___| __ ) ___ __ _| |_
| |_| |/ _ \ '__| __|_ / _ \ / _ \/ _` | __| Profile: prod
| _ | __/ | | |_ / /| |_) | __/ (_| | |_ Name: hertzbeat10
Port: 1157 Pid: 10
|_| |_|\___|_| \__/___|____/ \___|\__,_|\__|
https://hertzbeat.apache.org/
[EL Info]: 2024-07-05 17:26:22.513--ServerSession(1688861863)--EclipseLink,
version: Eclipse Persistence Services - 4.0.2.v202306161219
[EL Warning]: 2024-07-05 17:26:22.929--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Key column
'alertDefineId' doesn't exist in table
Error Code: 1072
Call: CREATE INDEX index_alert_define_monitor ON
hzb_alert_define_monitor_bind (alertDefineId)
Query: DataModifyQuery(sql="CREATE INDEX index_alert_define_monitor ON
hzb_alert_define_monitor_bind (alertDefineId)")
[EL Warning]: 2024-07-05 17:26:23.035--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Duplicate key name
'index_incident_component'
Error Code: 1061
Call: CREATE INDEX index_incident_component ON
hzb_status_page_incident_component_bind (component_id)
Query: DataModifyQuery(sql="CREATE INDEX index_incident_component ON
hzb_status_page_incident_component_bind (component_id)")
[EL Warning]: 2024-07-05 17:26:23.214--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Key column 'monitorId'
doesn't exist in table
Error Code: 1072
Call: CREATE INDEX INDEX_hzb_param_monitorId ON hzb_param (monitorId)
Query: DataModifyQuery(sql="CREATE INDEX INDEX_hzb_param_monitorId ON
hzb_param (monitorId)")
[EL Warning]: 2024-07-05 17:26:23.297--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Duplicate key name
'index_tag_monitor'
Error Code: 1061
Call: CREATE INDEX index_tag_monitor ON hzb_tag_monitor_bind (monitor_id)
Query: DataModifyQuery(sql="CREATE INDEX index_tag_monitor ON
hzb_tag_monitor_bind (monitor_id)")
[EL Warning]: 2024-07-05 17:26:23.389--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Duplicate key name
'index_collector_monitor'
Error Code: 1061
Call: CREATE INDEX index_collector_monitor ON hzb_collector_monitor_bind
(monitor_id)
Query: DataModifyQuery(sql="CREATE INDEX index_collector_monitor ON
hzb_collector_monitor_bind (monitor_id)")
[EL Warning]: 2024-07-05 17:26:23.549--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Duplicate key name
'monitor_query_index'
Error Code: 1061
Call: CREATE INDEX monitor_query_index ON hzb_monitor (host)
Query: DataModifyQuery(sql="CREATE INDEX monitor_query_index ON hzb_monitor
(host)")
[EL Warning]: 2024-07-05 17:26:23.755--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Key column 'monitorId'
doesn't exist in table
Error Code: 1072
Call: CREATE INDEX push_query_index ON hzb_push_metrics (monitorId)
Query: DataModifyQuery(sql="CREATE INDEX push_query_index ON
hzb_push_metrics (monitorId)")
[EL Warning]: 2024-07-05 17:26:23.796--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Key column 'monitorId'
doesn't exist in table
Error Code: 1072
Call: CREATE INDEX history_query_index ON hzb_history (monitorId)
Query: DataModifyQuery(sql="CREATE INDEX history_query_index ON hzb_history
(monitorId)")
[EL Warning]: 2024-07-05 17:26:23.825--ServerSession(1688861863)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 4.0.2.v202306161219):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Key column 'monitorId'
doesn't exist in table
Error Code: 1072
Call: ALTER TABLE hzb_param ADD CONSTRAINT UNQ_hzb_param_0 UNIQUE
(monitorId, field)
Query: DataModifyQuery(sql="ALTER TABLE hzb_param ADD CONSTRAINT
UNQ_hzb_param_0 UNIQUE (monitorId, field)")
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
