Mysql错误导致业务无法应用

oulinhl

mysql错误日志如下：
120508  1:00:17 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117137 limit 500
120508  1:00:17 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117138 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117139 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117140 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117141 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117142 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117143 limit 500
120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117149 limit 500
120508  2:00:18 [Warning] Aborted connection 37 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 18 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 46 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 25 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 52 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 11 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 17 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 36 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 34 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 16 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 9 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 33 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 28 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 39 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
120508  2:00:18 [Warning] Aborted connection 5 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)


这个时候前台应用（LAMP环境）无法登录，我只能重启数据库后恢复正常，请问大家，这两错误类型那种影响数据库的运行状态导致前台应用无法使用？？

cenalulu

120508  1:00:18 [Warning] Statement may not be safe to log in statement format. Statement: delete from history where itemid=117149 limit 500
第一种warning，没啥影响，就是提示你delete+limit的方式用statement 复制是可能会导致主从不一致的。

120508  2:00:18 [Warning] Aborted connection 5 to db: 'n_hist' user: 'slave' host: 'localhost' (Got an error reading communication packets)
第二种warning，没有遇到过，字面意思上是网络丢包，不过从报错来看host= localhost 应该不是根本原因

oulinhl

回复 2# cenalulu


第一种情况，我将binlog_format修改成mixed后，主从同步就报错，错误代码为：1032


第二种情况，它如果出现过多会影响前台业务访问，这是最要命的

devilkin0312

第一个，如果不解决，你的主从会变得没有意义。
第二个，和用户权限有关，奇怪的是你的slave是从本地连接的？

cenalulu

回复 3# oulinhl


    Q1： 那说明你的主从极有可能已经不同步了，在业务低峰时用pt-table-checksum做个主从比较，或者手工比较。
    Q2： 查看下那个时段的/var/log/message确认系统是否有报错，或者看看网络是否有抖动，亦或者client有主动的强制kill thread