grafana启动日志

本文记录了Grafana 4.6.3版本的启动过程及数据库迁移细节,包括了用户表、仪表板表、数据源表等关键组件的创建与更新过程。
[root@rdsp-dn-01 bin]# ./grafana-server start
INFO[01-13|16:16:48] Starting Grafana                         logger=server version=4.6.3 commit=7a06a47 compiled=2017-12-14T16:36:59+0800
INFO[01-13|16:16:48] Config loaded from                       logger=settings file=/opt/installSoftware/grafana-4.6.3/conf/defaults.ini
INFO[01-13|16:16:48] Path Home                                logger=settings path=/opt/installSoftware/grafana-4.6.3
INFO[01-13|16:16:48] Path Data                                logger=settings path=/opt/installSoftware/grafana-4.6.3/data
INFO[01-13|16:16:48] Path Logs                                logger=settings path=/opt/installSoftware/grafana-4.6.3/data/log
INFO[01-13|16:16:48] Path Plugins                             logger=settings path=/opt/installSoftware/grafana-4.6.3/data/plugins
INFO[01-13|16:16:48] App mode production                      logger=settings
INFO[01-13|16:16:48] Initializing DB                          logger=sqlstore dbtype=sqlite3
INFO[01-13|16:16:48] Starting DB migration                    logger=migrator
INFO[01-13|16:16:48] Executing migration                      logger=migrator id="create migration_log table"
INFO[01-13|16:16:55] Executing migration                      logger=migrator id="create user table"
INFO[01-13|16:16:55] Executing migration                      logger=migrator id="add unique index user.login"
INFO[01-13|16:16:55] Executing migration                      logger=migrator id="add unique index user.email"
INFO[01-13|16:16:55] Executing migration                      logger=migrator id="drop index UQE_user_login - v1"
INFO[01-13|16:16:56] Executing migration                      logger=migrator id="drop index UQE_user_email - v1"
INFO[01-13|16:16:56] Executing migration                      logger=migrator id="Rename table user to user_v1 - v1"
INFO[01-13|16:17:00] Executing migration                      logger=migrator id="create user table v2"
INFO[01-13|16:17:00] Executing migration                      logger=migrator id="create index UQE_user_login - v2"
INFO[01-13|16:17:01] Executing migration                      logger=migrator id="create index UQE_user_email - v2"
INFO[01-13|16:17:01] Executing migration                      logger=migrator id="copy data_source v1 to v2"
INFO[01-13|16:17:02] Executing migration                      logger=migrator id="Drop old table user_v1"
INFO[01-13|16:17:02] Executing migration                      logger=migrator id="Add column help_flags1 to user table"
INFO[01-13|16:17:02] Executing migration                      logger=migrator id="Update user table charset"
INFO[01-13|16:17:02] Executing migration                      logger=migrator id="Add last_seen_at column to user"
INFO[01-13|16:17:04] Executing migration                      logger=migrator id="create temp user table v1-7"
INFO[01-13|16:17:04] Executing migration                      logger=migrator id="create index IDX_temp_user_email - v1-7"
INFO[01-13|16:17:04] Executing migration                      logger=migrator id="create index IDX_temp_user_org_id - v1-7"
INFO[01-13|16:17:05] Executing migration                      logger=migrator id="create index IDX_temp_user_code - v1-7"
INFO[01-13|16:17:05] Executing migration                      logger=migrator id="create index IDX_temp_user_status - v1-7"
INFO[01-13|16:17:06] Executing migration                      logger=migrator id="Update temp_user table charset"
INFO[01-13|16:17:06] Executing migration                      logger=migrator id="create star table"
INFO[01-13|16:17:06] Executing migration                      logger=migrator id="add unique index star.user_id_dashboard_id"
INFO[01-13|16:17:06] Executing migration                      logger=migrator id="create org table v1"
INFO[01-13|16:17:07] Executing migration                      logger=migrator id="create index UQE_org_name - v1"
INFO[01-13|16:17:07] Executing migration                      logger=migrator id="create org_user table v1"
INFO[01-13|16:17:07] Executing migration                      logger=migrator id="create index IDX_org_user_org_id - v1"
INFO[01-13|16:17:09] Executing migration                      logger=migrator id="create index UQE_org_user_org_id_user_id - v1"
INFO[01-13|16:17:10] Executing migration                      logger=migrator id="copy data account to org"
INFO[01-13|16:17:10] Skipping migration condition not fulfilled logger=migrator id="copy data account to org"
INFO[01-13|16:17:10] Executing migration                      logger=migrator id="copy data account_user to org_user"
INFO[01-13|16:17:10] Skipping migration condition not fulfilled logger=migrator id="copy data account_user to org_user"
INFO[01-13|16:17:10] Executing migration                      logger=migrator id="Drop old table account"
INFO[01-13|16:17:10] Executing migration                      logger=migrator id="Drop old table account_user"
INFO[01-13|16:17:11] Executing migration                      logger=migrator id="Update org table charset"
INFO[01-13|16:17:12] Executing migration                      logger=migrator id="Update org_user table charset"
INFO[01-13|16:17:15] Executing migration                      logger=migrator id="create dashboard table"
INFO[01-13|16:17:15] Executing migration                      logger=migrator id="add index dashboard.account_id"
INFO[01-13|16:17:15] Executing migration                      logger=migrator id="add unique index dashboard_account_id_slug"
INFO[01-13|16:17:16] Executing migration                      logger=migrator id="create dashboard_tag table"
INFO[01-13|16:17:16] Executing migration                      logger=migrator id="add unique index dashboard_tag.dasboard_id_term"
INFO[01-13|16:17:16] Executing migration                      logger=migrator id="drop index UQE_dashboard_tag_dashboard_id_term - v1"
INFO[01-13|16:17:16] Executing migration                      logger=migrator id="Rename table dashboard to dashboard_v1 - v1"
INFO[01-13|16:17:17] Executing migration                      logger=migrator id="create dashboard v2"
INFO[01-13|16:17:17] Executing migration                      logger=migrator id="create index IDX_dashboard_org_id - v2"
INFO[01-13|16:17:17] Executing migration                      logger=migrator id="create index UQE_dashboard_org_id_slug - v2"
INFO[01-13|16:17:17] Executing migration                      logger=migrator id="copy dashboard v1 to v2"
INFO[01-13|16:17:18] Executing migration                      logger=migrator id="drop table dashboard_v1"
INFO[01-13|16:17:18] Executing migration                      logger=migrator id="alter dashboard.data to mediumtext v1"
INFO[01-13|16:17:18] Executing migration                      logger=migrator id="Add column updated_by in dashboard - v2"
INFO[01-13|16:17:18] Executing migration                      logger=migrator id="Add column created_by in dashboard - v2"
INFO[01-13|16:17:19] Executing migration                      logger=migrator id="Add column gnetId in dashboard"
INFO[01-13|16:17:19] Executing migration                      logger=migrator id="Add index for gnetId in dashboard"
INFO[01-13|16:17:20] Executing migration                      logger=migrator id="Add column plugin_id in dashboard"
INFO[01-13|16:17:20] Executing migration                      logger=migrator id="Add index for plugin_id in dashboard"
INFO[01-13|16:17:20] Executing migration                      logger=migrator id="Add index for dashboard_id in dashboard_tag"
INFO[01-13|16:17:20] Executing migration                      logger=migrator id="Update dashboard table charset"
INFO[01-13|16:17:20] Executing migration                      logger=migrator id="Update dashboard_tag table charset"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="create data_source table"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="add index data_source.account_id"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="add unique index data_source.account_id_name"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="drop index IDX_data_source_account_id - v1"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="drop index UQE_data_source_account_id_name - v1"
INFO[01-13|16:17:21] Executing migration                      logger=migrator id="Rename table data_source to data_source_v1 - v1"
INFO[01-13|16:17:22] Executing migration                      logger=migrator id="create data_source table v2"
INFO[01-13|16:17:22] Executing migration                      logger=migrator id="create index IDX_data_source_org_id - v2"
INFO[01-13|16:17:22] Executing migration                      logger=migrator id="create index UQE_data_source_org_id_name - v2"
INFO[01-13|16:17:23] Executing migration                      logger=migrator id="copy data_source v1 to v2"
INFO[01-13|16:17:23] Executing migration                      logger=migrator id="Drop old table data_source_v1 #2"
INFO[01-13|16:17:23] Executing migration                      logger=migrator id="Add column with_credentials"
INFO[01-13|16:17:23] Executing migration                      logger=migrator id="Add secure json data column"
INFO[01-13|16:17:25] Executing migration                      logger=migrator id="Update data_source table charset"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="create api_key table"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="add index api_key.account_id"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="add index api_key.key"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="add index api_key.account_id_name"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="drop index IDX_api_key_account_id - v1"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="drop index UQE_api_key_key - v1"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="drop index UQE_api_key_account_id_name - v1"
INFO[01-13|16:17:26] Executing migration                      logger=migrator id="Rename table api_key to api_key_v1 - v1"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="create api_key table v2"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="create index IDX_api_key_org_id - v2"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="create index UQE_api_key_key - v2"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="create index UQE_api_key_org_id_name - v2"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="copy api_key v1 to v2"
INFO[01-13|16:17:27] Executing migration                      logger=migrator id="Drop old table api_key_v1"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="Update api_key table charset"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="create dashboard_snapshot table v4"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="drop table dashboard_snapshot_v4 #1"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="create dashboard_snapshot table v5 #2"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="create index UQE_dashboard_snapshot_key - v5"
INFO[01-13|16:17:28] Executing migration                      logger=migrator id="create index UQE_dashboard_snapshot_delete_key - v5"
INFO[01-13|16:17:30] Executing migration                      logger=migrator id="create index IDX_dashboard_snapshot_user_id - v5"
INFO[01-13|16:17:31] Executing migration                      logger=migrator id="alter dashboard_snapshot to mediumtext v2"
INFO[01-13|16:17:31] Executing migration                      logger=migrator id="Update dashboard_snapshot table charset"
INFO[01-13|16:17:31] Executing migration                      logger=migrator id="create quota table v1"
INFO[01-13|16:17:31] Executing migration                      logger=migrator id="create index UQE_quota_org_id_user_id_target - v1"
INFO[01-13|16:17:32] Executing migration                      logger=migrator id="Update quota table charset"
INFO[01-13|16:17:32] Executing migration                      logger=migrator id="create plugin_setting table"
INFO[01-13|16:17:32] Executing migration                      logger=migrator id="create index UQE_plugin_setting_org_id_plugin_id - v1"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="Add column plugin_version to plugin_settings"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="Update plugin_setting table charset"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="create session table"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="Drop old table playlist table"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="Drop old table playlist_item table"
INFO[01-13|16:17:33] Executing migration                      logger=migrator id="create playlist table v2"
INFO[01-13|16:17:35] Executing migration                      logger=migrator id="create playlist item table v2"
INFO[01-13|16:17:35] Executing migration                      logger=migrator id="Update playlist table charset"
INFO[01-13|16:17:35] Executing migration                      logger=migrator id="Update playlist_item table charset"
INFO[01-13|16:17:35] Executing migration                      logger=migrator id="drop preferences table v2"
INFO[01-13|16:17:35] Executing migration                      logger=migrator id="drop preferences table v3"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="create preferences table v3"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="Update preferences table charset"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="create alert table v1"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="add index alert org_id & id "
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="add index alert state"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="add index alert dashboard_id"
INFO[01-13|16:17:36] Executing migration                      logger=migrator id="create alert_notification table v1"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="Add column is_default"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="add index alert_notification org_id & name"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="Update alert table charset"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="Update alert_notification table charset"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="Drop old annotation table v4"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="create annotation table v5"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="add index annotation 0 v3"
INFO[01-13|16:17:37] Executing migration                      logger=migrator id="add index annotation 1 v3"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="add index annotation 2 v3"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="add index annotation 3 v3"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="add index annotation 4 v3"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="Update annotation table charset"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="Add column region_id to annotation table"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="Drop category_id index"
INFO[01-13|16:17:38] Executing migration                      logger=migrator id="Add column tags to annotation table"
INFO[01-13|16:17:39] Executing migration                      logger=migrator id="Create annotation_tag table v2"
INFO[01-13|16:17:40] Executing migration                      logger=migrator id="Add unique index annotation_tag.annotation_id_tag_id"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="Update alert annotations and set TEXT to empty"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="create test_data table"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="create dashboard_version table v1"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="add index dashboard_version.dashboard_id"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="add unique index dashboard_version.dashboard_id and dashboard_version.version"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="Set dashboard version to 1 where 0"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="save existing dashboard data in dashboard_version table v1"
INFO[01-13|16:17:41] Executing migration                      logger=migrator id="alter dashboard_version.data to mediumtext v1"
INFO[01-13|16:17:42] Executing migration                      logger=migrator id="create tag table"
INFO[01-13|16:17:42] Executing migration                      logger=migrator id="add index tag.key_value"
INFO[01-13|16:17:43] Created default admin user: admin 
INFO[01-13|16:17:44] Starting plugin search                   logger=plugins
WARN[01-13|16:17:46] Plugin dir does not exist                logger=plugins dir=/opt/installSoftware/grafana-4.6.3/data/plugins
INFO[01-13|16:17:46] Plugin dir created                       logger=plugins dir=/opt/installSoftware/grafana-4.6.3/data/plugins
INFO[01-13|16:17:46] Initializing Alerting                    logger=alerting.engine
INFO[01-13|16:17:46] Initializing CleanUpService              logger=cleanup
INFO[01-13|16:17:47] Initializing Stream Manager 
INFO[01-13|16:17:47] Initializing HTTP Server                 logger=http.server address=0.0.0.0:3000 protocol=http subUrl= socket=
INFO[01-13|16:18:19] Request Completed                        logger=context userId=0 orgId=0 uname= method=GET path=/ status=302 remote_addr=192.168.199.203 time_ms=93 size=29 referer=
### 关于 Grafana 启动问题的原因分析 当遇到 Grafana 在关机后无法重新启动的情况时,可能涉及多个方面的问题。以下是可能导致该现象的一些常见原因以及对应的解决方法: #### 1. 配置文件损坏或不一致 如果 `grafana.ini` 文件被修改过或者存在语法错误,则可能会导致服务无法正常启动。可以尝试恢复默认配置文件来排查此问题。 ```bash cp /etc/grafana/grafana.ini.default /etc/grafana/grafana.ini ``` 此外,确认是否有其他环境变量覆盖了默认设置[^1]。 #### 2. 数据目录权限不足 Grafana 的数据目录通常位于 `/var/lib/grafana` 中。如果该路径下的文件夹权限发生变化(例如由于手动调整),则可能导致进程无权访问这些资源而崩溃。 可以通过以下命令修复权限: ```bash chown -R grafana:grafana /var/lib/grafana/ chmod -R u=rwX,g=rx,o= /var/lib/grafana/ ``` #### 3. 日志记录缺失 尽管提到未发现明显错误消息,但仍需仔细检查日志位置是否正确指定。默认情况下,Grafana 将其运行状态写入到 `/var/log/grafana/grafana.log` 文件里。如果没有找到任何异常提示,可能是日志级别设得太高所致。 降低日志等级以便获取更多细节信息: ```ini [log] level = debug mode = console,file ``` 记得重启服务使更改生效[^2]。 #### 4. 开机自启脚本冲突 有时操作系统自带的服务管理工具与实际部署方式之间会产生矛盾。比如通过 RPM 包形式安装的同时还利用 Docker 容器化技术加载实例的话,就容易引发竞争条件从而阻止其中一个成功激活。 如果是基于传统 Linux 发行版的方式执行的,请验证 systemctl 单元是否存在并处于活动状态;若是容器方案,则应确保镜像拉取及网络映射均按预期完成[^3]。 #### 5. 外部依赖项失效 对于某些特定场景而言,Grafana 可能会连接外部数据库(如 MySQL/PostgreSQL)作为持久层存储仪表板定义等内容。一旦目标主机不可达或是认证凭证已变更都会影响整体功能表现。 因此建议核查相关联接字符串参数准确性,并测试连通状况。 --- ### 提供一段简单的 Python 脚本来监控 Grafana 是否健康在线 下面是一个小型实用程序片段用来定时探测远程服务器上的 Grafana API 接口响应情况: ```python import requests from time import sleep def check_grafana_health(url="http://localhost:3000/api/health"): try: resp = requests.get(url, timeout=5) if resp.status_code == 200 and 'database' in resp.json(): print("Grafana is healthy.") return True else: raise Exception('Unexpected response format.') except Exception as e: print(f"Grafana health check failed: {e}") return False if __name__ == "__main__": while not check_grafana_health(): sleep(10) # Wait before retrying... ``` ---
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

盒马coding

你的支持是我最大的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值