tomsun28
commented
1 week ago hi, got it, we will try to reproduce this. Are you deploying a completely new version, or upgrading from an older version?
Open andyg2 opened 1 week ago
tomsun28
commented
1 week ago hi, got it, we will try to reproduce this. Are you deploying a completely new version, or upgrading from an older version?
andyg2
commented
1 week ago Are you deploying a completely new version, or upgrading from an older version?
Side note - possibly related - maybe expected: I've logged in to mysql and the hertzbeat database is empty (no tables)
sh-5.1# mysql -uroot -p123456;
Server version: 8.4.1 MySQL Community Server - GPL
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| hertzbeat |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+mysql> use hertzbeat;
Database changedmysql> show tables;
Empty set (0.00 sec)
gjjjj0101
commented
1 week ago 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.
andyg2
commented
1 week ago 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 yourapplication.ymlmiss theflywayconfiguration. So I deleted theflywayconfiguration in the latestapplication.ymland 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: example@qq.com
# 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)")
Yes, I find this problem in v1.6.0. The configuration file for starting heartzbeat via docker compose has problems. This problem has been fixed in the current master branch. You can cd to script/docker-compose/hertzbeat-mysql-victoria-metrics directory, configure conf/application.yml in this path and add external jar to ext-lib. Then execute docker compose up -d to start the service.
Is there an existing issue for this?
Current Behavior
Upon running
docker compose up -dI'm getting an error in 'compose-hertzbeat' stating there's multiple migration files.Despite my best efforts to locate these I haven't been able to find them or experiment with removing one of them.
Expected Behavior
Hertzbeat handles the multiple files gracefully, or improved documentation for remediation.
Steps To Reproduce
mysql-connector-java-8.0.25.jarinto ./ext-lib./ext-lib:/opt/hertzbeat/ext-libdocker compose up -dEnvironment
Debug logs
Anything else?