• mysql 错误集锦


    Got fatal error 1236 from master when reading data from binary log: 'could not find next log; the first event '' at 4, the last event read from './mysql-bin.000005' at 304695, the last byte read from './mysql-bin.000005' at 304695.'

    root@012cabfabcf5:/# mysqlrpladmin --slaves=repluser:'repl.123'@192.168.9.113,repluser:'repl.123'@192.168.9.127 --candidates=repluser:'repl.123'@192.168.9.113,repluser:'repl.123'@192.168.9.127 --rpl-user=repluser:repl.123 failover
    WARNING: Using a password on the command line interface can be insecure.
    # Checking privileges.
    # Checking privileges on candidates.
    # Performing failover.
    # Candidate slave 192.168.9.113:3306 will become the new master.
    # Checking slaves status (before failover).
    # ERROR: Problem detected with SQL thread for slave '192.168.9.113'@'3306' that can result in an unstable topology.
    #  - SQL thread running: No
    #  - SQL error: None
    #  Tip: Check the slave server log to identify the problem and fix it. For more information, see: http://dev.mysql.com/doc/refman/5.6/en/replication-problems.html
    ERROR: Problem detected with SQL thread for slave '192.168.9.113'@'3306' that can result in an unstable topology. Note: To ignore this issue use the utility with the --force option.

    2018-01-18T06:42:34.157806406Z Logged from file tasks.py, line 147
    2018-01-18T06:42:34.15785599Z Traceback (most recent call last):
    2018-01-18T06:42:34.157887448Z   File "/usr/lib/python2.7/logging/__init__.py", line 883, in emit
    2018-01-18T06:42:34.157918948Z     self.flush()
    2018-01-18T06:42:34.15795049Z   File "/usr/lib/python2.7/logging/__init__.py", line 843, in flush
    2018-01-18T06:42:34.157982031Z     self.stream.flush()
    2018-01-18T06:42:34.158018031Z IOError: [Errno 32] Broken pipe
    2018-01-18T06:42:34.15805849Z Logged from file tasks.py, line 194
    2018-01-18T06:42:34.158085406Z Traceback (most recent call last):
    2018-01-18T06:42:34.158118198Z   File "/usr/lib/python2.7/logging/__init__.py", line 883, in emit
    2018-01-18T06:42:34.158163198Z     self.flush()
    2018-01-18T06:42:34.15821274Z   File "/usr/lib/python2.7/logging/__init__.py", line 843, in flush
    2018-01-18T06:42:34.15827124Z     self.stream.flush()
    2018-01-18T06:42:34.158356823Z IOError: [Errno 32] Broken pipe

  • 相关阅读:
    Java 中位移运算符 >>,>>>,<<
    HashMap 源码解读
    CentOS 配置防火墙操作实例(启、停、开、闭端口)
    CentOS 配置防火墙操作实例(启、停、开、闭端口)
    js实现页面重新加载
    js实现页面重新加载
    关于Ajax的技术组成与核心原理
    关于Ajax的技术组成与核心原理
    PHP水印制作
    PHP水印制作
  • 原文地址:https://www.cnblogs.com/mhc-fly/p/8327969.html
Copyright © 2020-2023  润新知