MySQL告警： [Warning] IP address '10.176.246.53' could not be resolved: Temporary fail

最新推荐文章于 2023-11-30 09:17:53 发布
最新推荐文章于 2023-11-30 09:17:53 发布
阅读量3k 收藏 2
点赞数
分类专栏： mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhouchang3/article/details/53382133
版权

新接手四套MySQL库。检查相关的配置和日志，发现以下大量告警：

2016-11-28 18:50:15 30464 [Warning] IP address '10.176.246.55' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:15 30464 [Warning] IP address '10.176.246.55' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:15 30464 [Warning] IP address '10.176.246.53' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:15 30464 [Warning] IP address '10.176.246.53' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:15 30464 [Warning] IP address '10.176.246.56' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:18 30464 [Warning] IP address '10.180.211.39' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:18 30464 [Warning] IP address '10.180.211.27' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:23 30464 [Warning] IP address '10.176.246.54' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.55' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.53' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.53' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.53' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.56' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.56' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.56' could not be resolved: Temporary failure in name resolution
2016-11-28 18:50:25 30464 [Warning] IP address '10.176.246.56' could not be resolved: Temporary failure in name resolution


数据库业务不是很繁忙， 但是有大量的告警产生，日志文件被撑到3G左右。


出现错误的原因是MYSQL Server在本地内存中维护了一个非本地的Client TCP cache，这个cache中包含了远程Client的登录信息，比如IP地址，hostname等信息。
如果Client连接到服务器后，Mysql首先会在本地TCP池中根据IP地址解析客户端的hostname或者反解析，如果解析不到，就会去DNS中进行解析，如果还是解析失败
就是在error log中写入这样的警告信息。


可以通过两个参数来disable这个功能，在MYSQL的配置文件中[mysqld]中加入下面的参数:
[mysqld]
--skip-host-cache
--skip-name-resolve


重启数据库，该告警消失！

Vovis
关注
专栏目录
Multiple annotations found at this line: - javax.servlet.jsp.PageContext cannot be resolved to a
qq_45066969的博客
11-30 1274
jsp页面的如下报错： ${pageContext.servletContext.contextPath } 但是程序仍然可以运行 pom.xml配置如下： <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schem...
mysql could not be resolved: Name or service not known
12-15
问题： mysql DNS反解：skip-name-resolve 错误日志有类似警告： 1.120119 16:26:04 [Warning] IP address ‘192.168.1.10’ could not be resolved: Name or service not known 2.120119 16:26:04 [Warning] IP address ‘192.168.1.14’ could not be resolved: Name or service not known 3.120119 16:26:04 [Warning] IP address ‘192.168.
mysql出现：could not be resolved: Name or service not known
qq_39677803的博客
05-31 9926
mysql错误日志出现这样的警告： 2021-05-31 21:31:59 15546 [Warning] IP address '192.168.232.179' could not be resolved: Name or service not known 是因为没有添加：skip-name-resolve 参数 skip-name-resolve : 不再进行反解析（ip不反解成域名） vim /etc/my.cnf #添加即可 skip-name-resolve :wq 重启数据库： /et
[转]mysql显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known错误解决
seowen的开发 小本子
12-10 2172
mysql日志显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known，那是因为mysql默认会反向解析DNS，对于访问者Mysql不会判断是hosts还是ip都会进行dns反向解析，频繁地查询数据库和权限检查，这大大增加了数据库的压力，导致数据库连接缓慢，严重的时候甚至死机，出现“连接数据库时出错...
mysql显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known错误解决
帅气的可乐
08-26 4万+
mysql日志显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known，那是因为mysql默认会反向解析DNS，对于访问者Mysql不会判断是hosts还是ip都会进行dns反向解析，频繁地查询数据库和权限检查，这大大增加了数据库的压力，导致数据库连接缓慢，严重的时候甚至死机，出现“连接数据库时出错
Missing artifact com.oracle:ojdbc6:jar:11.2.0.1.0问题解决 ojdbc包pom.xml出错
11-23
<!-- oracle数据库驱动 --> ... <artifactId>ojdbc6  <version>11.2.0.1.0 ...1.首先确定你是否有安装oracle，如果有安装的话，找到ojdbc6.jar包 ...D:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6...
ORA-29541: class SYS.oracle/jpub/runtime/dbws/DbwsProxy could not be resolved
05-26
NULL 博文链接：https://lyh7609.iteye.com/blog/516672
mysql name or service not known_MySQL反解析出现could not be resolved: Name or service not known解决办法...
weixin_33532301的博客
02-06 2430
错误日志有类似警告120119 16:26:04 [Warning] IP address '192.168.1.10' could not be resolved: Name or service not known120119 16:26:04 [Warning] IP address '192.168.1.14' could not be resolved: Name or service ...
mysql显示错误日志 [Warning] IP address ‘xxxx‘ could not be resolved: Name or service not known错误解决
jacklin_01的博客
04-20 6508
mysql日志显示[Warning] IP address 'xxxx' could not be resolved: Name or service not known，那是因为mysql默认会反向解析DNS，对于访问者Mysql不会判断是hosts还是ip都会进行dns反向解析，频繁地查询数据库和权限检查，这大大增加了数据库的压力，导致数据库连接缓慢，严重的时候甚至死机，出现“连接数据库时出错”等字样。 解决办法：禁用dns反查即可 进入/etc 找到mysql的配置文件my.cnf（linux环境
关于mysql的 [Warning] IP address 'XXX' could not be resolved: Temporary failure in name resol
江西看见你科技有限公司
07-21 4792
最近排查mysql执行效率的时候，查看mysql的实时日志大量一直显示190526 8:05:55 [Warning] IP address ‘XXXXXX’ could not be resolved: Name or service not known，后面查log文件，每天包含该句日志达到几千万条，严重的浪费了log日志空间和效率。 下面我一起来看看其中的原因： mysql日志显示[War...
MySQL 8.x重新初始化报错[MY-010069] [Server] Failed to set up SSL because of the following SSL library error
最新发布
一个标题
11-30 1257
MySQL 8.x重新初始化报错[MY-010069] [Server] Failed to set up SSL because of the following SSL library error
IP address could not be resolved: Temporary failure in name resolution
乐乐的博客
09-15 2474
在自己的mysql日志中发现了如下的错误信息 2017-09-15T01:07:10.373535Z 5 [Warning] IP address '192.168.33.1' could not be resolved: Temporary failure in name resolution 2017-09-15T01:07:28.445920Z 6 [Warning] IP address '
【Centeros7中 发现 ip addr 无ip地址】——不踩坑指南
weixin_40416851的博客
02-15 370
使用Centeros7中 发现 ip addr 无ip地址（已解决）原因：在CentOS系统上，目前有NetworkManager和network两种网络管理工具。如果两种都配置会引起冲突，而且NetworkManager在网络断开的时候，会清理路由，如果一些自定义的路由，没有加入到NetworkManager的配置文件中，路由就被清理掉，网络连接后需要自定义添加上去。1.将networkmanager服务停了2.重启网卡，就ok了#查看所有已安装服务。
mysql ip 日志_mysql错误日志报IP address '' could not be resolved: Nam
weixin_32875295的博客
01-19 1006
在工作中出现这样的问题，研发和测试同事在连接mysql的时候，突然mysql连接断开，每天都会出现1-2次错误日志内容2014-04-08 17:58:11 24636 [Warning] IP address '192.168.1.116' could not be resolved: Name or service not known2014-04-08 17:58:24 24636 [War...
[MySQL]IP address '192.168.31.110' could not be resolved: Temporary failure in name resolution
怀揣梦想，努力前行
08-01 1万+
在服务器的/etc/hosts文件中添加上本机的地址信息或者在启动时附带参数--skip-name-resolve，忽略主机名解析
Hadoopb 设置时间同步报错：name server cannot be used, reason: Temporary failure in name resolution
dingyiye2649的博客
07-23 4120
当我在Hadoop2.6.4集群上设置时间同步是，发生了以下错误： 输入为： # /usr/sbin/ntpdate cn.pool.ntp.org 错误为： name server cannot be used, reason: Temporary failure in name resolution 解决办法： # sudo vi /etc/resolv.conf ...
Temporary failure in name resolution 错误解决方法
Open source of memory
11-12 6714
是centos5，想使用wget下载一个文件出现了如下问题："Resolving www.xxxx-xxxx.com... failed: Temporary failure in name resolution."从字面上理解意思是，在解析这个URL的时候发生了失败；首先我从另外一个windows的IE里访问了那个URL，发现是可到达的猜测可能是该机器的网络配置有问题，检查了eth0的配置，无误...
Temporary failure in name resolution错误解决方法
热门推荐
程序员的笔记
09-10 16万+
今天迁移服务器之后原本正常运行的程序报"Temporary failure in name resolution"错误，意思是域名解析失败，但是DNS什么的设置没有问题，其实是主机名解析失败，在hosts里配置一下即可解决: 1.打开/etc/hosts #vi /etc/hosts 2.增加主机名映射 按 i 键进入编辑模式，在wenj最后增加： 127.0.0.1 hostname ...
[Server] IP address '101.66.246.242' could not be resolved: Name or service not known什么意思，怎么办
05-10
这个错误信息表示无法解析指定的IP地址。可能是因为该IP地址不存在或无法连接到DNS服务器。 您可以尝试以下步骤来解决这个问题： 1. 检查IP地址是否正确，并确保您拥有正确的IP地址。 2. 检查您的网络连接是否正常...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值