Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1854

monitor backend database' mysql connect is closed by mxs once in a while

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.2
    • N/A
    • readwritesplit
    • None
    • linux + make debug + mysql 5.6.16

    Description

      monitor config like:

      [maxscale]
      threads=1
      log_info=1
      log_debug=1
       
      [RWMySQLMonitor]
      type=monitor
      module=mysqlmon
      servers=server_m,server_s
      monitor_interval=10000
       
      [server_m]
      type=server
      address=10.125.198.61
      port=3009
      protocol=MySQLBackend
      [server_s]
      type=server
      address=10.125.194.99
      port=3009
      protocol=MySQLBackend
      

      we add log find closed connect always server_s connect

      My title

      warning: [mariadbmon] (do_show_slave_status): exec query failed:SHOW SLAVE STATUS, mysql:0x1fc4260
      error : (mon_report_query_error): Failed to execute query on server 'server_s' ([10.125.194.99]:3009): Lost connection to MySQL server during query
      notice : (mon_log_state_change): Server changed state: server_s[10.125.194.99:3009]: lost_slave. [Slave, Running] -> [Running]

      we add the first line log in do_show_slave_status

          else
          {
              MXS_WARNING("exec query failed:%s, mysql:%p", query, database->con);
              mon_report_query_error(database);
          }
      

      bt

      My title

      (gdb) bt
      #0 mon_report_query_error (db=0x1fc23c0) at /home/xiangzhong.wxd/gitlab/MaxScale/server/core/monitor.cc:1680
      #1 0x00007f038a953934 in do_show_slave_status (mon=0x1fc3280, serv_info=0x1fc49e0, database=0x1fc23c0)
      at /home/xiangzhong.wxd/gitlab/MaxScale/server/modules/monitor/mariadbmon/mariadbmon.cc:1530
      #2 0x00007f038a953b3f in monitor_mysql_db (mon=0x1fc3280, database=0x1fc23c0, serv_info=0x1fc49e0)
      at /home/xiangzhong.wxd/gitlab/MaxScale/server/modules/monitor/mariadbmon/mariadbmon.cc:1578
      #3 0x00007f038a95433c in monitorDatabase (mon=0x1fc0e60, database=0x1fc23c0) at /home/xiangzhong.wxd/gitlab/MaxScale/server/modules/monitor/mariadbmon/mariadbmon.cc:1798
      #4 0x00007f038a95524e in monitorMain (arg=0x1fc3280) at /home/xiangzhong.wxd/gitlab/MaxScale/server/modules/monitor/mariadbmon/mariadbmon.cc:2216
      #5 0x00007f038f2c1aa1 in start_thread () from /lib64/libpthread.so.0
      #6 0x00007f038d48c93d in clone () from /lib64/libc.so.6

      we cap packet find, the connect is closed by mxs:

      maxscale IP: 10.101.161.10.40112
      server_s IP:10.125.194.99.3009

      Attachments

        Activity

          People

            Unassigned Unassigned
            xzh xiangzhong
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.