YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

YMatrix FAQ for monitoring alarms

This document describes common problems, causes and solutions when monitoring YMatrix clusters.


1 Can Grafana monitoring be installed offline?

Yes, [click to download the Grafana repository dependency package] (https://matrixdb-public.oss-cn-beijing.aliyuncs.com/package/grafana_repo.zip), and then install it after creating the local repository.

# ls
create_repo.sh  grafana-7.3.6-1.x86_64.rpm  grafana_repo

# sh create_repo.sh
Create ymatrix-grafana repo successfully!

#  yum install --disablerepo=* --enablerepo=ymatrix_grafana grafana-7.3.6-1.x86_64.rpm


2 Grafana Error Annotation Query Failed No message available

Solution

Find Grafana's Settings --> Annotations --> Annotations & Alerts Remove Enabled


3 Grafana sends an email error smtp; 554 Reject by behaviour spam at Rcpt State(Connection IP address:***) ANTISPAM_BAT[01201311R106a,ay29a033002195086]: spfcheck failedCONTINUE

Problem Analysis

The problem is that host is not configured correctly in SMTP

Solution

If you are using a corporate mailbox, host needs to configure the enterprise domain name, for example, the following configuration:

############################################ SMTP / Emailing #####################################
[smtp]
enabled = true
host = smtp.ymatrix.cn:25
user = [email protected]
# If the password contains # or ; you have to wrap it with triple quotes. Ex """#password;"""
password = *****
;cert_file =
;key_file =
skip_verify = true
from_address = [email protected]
from_name = MatrixDBGrafana
# EHLO identity in SMTP dialog (defaults to instance_name)
;ehlo_identity = dashboard.example.com
# SMTP startTLS policy (defaults to 'OpportunisticStartTLS')
;startTLS_policy = NoStartTLS

[emails]
welcome_email_on_sign_up = false
templates_pattern = emails/*.html

4 MXUI mailbox configuration error

Error message

Error 1:

send email error. test auth error: create smtp client error: establish TLS connection error: tis: first record does not look like a TLS handshake

Error 2:

send email error: test auth error: account name or password error

Problem Analysis

  1. The server cannot connect to the SMTP server.
  2. Email configuration is incorrect.

Solution

  1. Please check whether the SMTP server is connected according to the following method.

Install telnet.

$ sudo yum install telnetd  -y

Perform a test.

telnet smtp.qiye.aliyun.com 465
  1. The correct configuration example of MXUI is as follows:
    
-- SMTP server address
smtp.qiye.aliyun.com:465

-- username [email protected]

-- Password (password of user email) xxxxx

-- From [email protected]

-- recipient [email protected],[email protected]