LuManager1.1.9 bind 运行一直出现错误日志的问题

ZeLL

LuManager1.1.9 版本的bind 的有点问题，在使用bind 的过程中，只要一启动，然后去看bind 的错误日志就发现有错误日志，而且错误日志会一直增加，运行一段时间后，bind就无法使用，查看服务器进程，bind进程还在，必须要重启下bind 才能重启开始解析，洞洞，你看下 bind 吧，在3台服务器测试均是这种错误。查阅相关资料，怀疑是 mysql timeout 的问题，洞洞这个问题增加解决。{:soso_e100:}

服务器 bind 出现错误   
vi /var/log/bind.log  【请用bind 的朋友 vi下这个文件，看下是不是也一直报错】

22-Aug-2011 11:08:05.257 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:05.351 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.352 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.356 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.438 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.454 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.551 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.570 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.667 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.676 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.764 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.777 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.868 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.883 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.977 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:14.996 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:15.095 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:15.097 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.342 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.345 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.428 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.432 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.435 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.518 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.530 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.617 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.632 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.725 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.736 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.826 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.840 database: mysql driver unable to return result set for authority query 22-Aug-2011 11:08:21.934 database: mysql driver unable to return result set for authority query

报错：


                     产生了 3.2G的错误日志

  
                   错误信息

ZeLL

测试服务器  截图。。配置是没的说{:soso_e100:}

爱洞特漏

是的
在my.cnf中设置超时时间为两天172800

方法如下：
修改my.cnf，在[mysqld]段增加

1. set-variable = wait_timeout=172800
   
2. set-variable = interactive_timeout=172800
   

复制代码

ZeLL

爱洞特漏 发表于 2011-8-22 11:22
是的
在my.cnf中设置超时时间为两天172800

我已经在mysqlld 里面 增加了
set-variable = wait_timeout=172800
set-variable = interactive_timeout=172800

并且重启了，mysql 和 bind 再次运行bind后，发现，日志还是一直报错。
以下是最新的报错内容

1. 22-Aug-2011 11:25:02.264 database: mysql driver unable to return result set for authority query
   
2. 22-Aug-2011 11:25:02.283 database: mysql driver unable to return result set for authority query
   
3. 22-Aug-2011 11:25:02.382 database: mysql driver unable to return result set for authority query
   
4. 22-Aug-2011 11:25:02.396 database: mysql driver unable to return result set for authority query
   
5. 22-Aug-2011 11:25:02.489 database: mysql driver unable to return result set for authority query
   
6. 22-Aug-2011 11:25:11.490 database: mysql driver unable to return result set for authority query
   
7. 22-Aug-2011 11:25:11.494 database: mysql driver unable to return result set for authority query
   
8. 22-Aug-2011 11:25:11.578 database: mysql driver unable to return result set for authority query
   
9. 22-Aug-2011 11:25:11.593 database: mysql driver unable to return result set for authority query
   
10. 22-Aug-2011 11:25:11.691 database: mysql driver unable to return result set for authority query
    
11. 22-Aug-2011 11:25:11.710 database: mysql driver unable to return result set for authority query
    
12. 22-Aug-2011 11:25:11.804 database: mysql driver unable to return result set for authority query
    
13. 22-Aug-2011 11:25:11.813 database: mysql driver unable to return result set for authority query
    
14. 22-Aug-2011 11:25:11.901 database: mysql driver unable to return result set for authority query
    
15. 22-Aug-2011 11:25:11.914 database: mysql driver unable to return result set for authority query
    
16. 22-Aug-2011 11:25:12.007 database: mysql driver unable to return result set for authority query
    
17. 22-Aug-2011 11:25:12.022 database: mysql driver unable to return result set for authority query
    
18. 22-Aug-2011 11:25:12.116 database: mysql driver unable to return result set for authority query
    
19. 22-Aug-2011 11:25:12.136 database: mysql driver unable to return result set for authority query
    
20. 22-Aug-2011 11:25:12.235 database: mysql driver unable to return result set for authority query
    
21. 22-Aug-2011 11:25:12.237 database: mysql driver unable to return result set for authority query
    

复制代码

爱洞特漏

能用bind了吧？能用就行了

cnmt

呵呵。

爱洞特漏

将/usr/local/bind/etc/view.conf中的dns_records改成lu_dnss（有多处）
然后重启bind