Uploaded image for project: 'ProxySQL Admin Scripts'
  1. ProxySQL Admin Scripts
  2. PSQLADM-40

ProxySQL scheduler generates many proxysql_(galera_checker|node_monitor) processes with wrong proxysql credentials

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      ProxySQL scheduler generates many proxysql_(galera_checker|node_monitor) processes if we have wrong proxysql credentials in proxysql-admin.cnf file. 

      [root@pxc57-1 ~]# ps aux | grep -E 'proxysql_(galera_checker|node_monitor)' | head -n10
      proxysql 331 0.0 0.0 11640 1360 ? S 21:10 0:00 /bin/bash /bin/proxysql_galera_checker 10 11 1 1 /var/lib/proxysql/proxysql_galera_check.log
      proxysql 333 0.0 0.0 11768 1604 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 334 0.0 0.0 11768 908 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 337 0.0 0.0 11640 1360 ? S 21:10 0:00 /bin/bash /bin/proxysql_galera_checker 10 11 1 1 /var/lib/proxysql/proxysql_galera_check.log
      proxysql 339 0.0 0.0 11768 1608 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 340 0.0 0.0 11768 908 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 343 0.0 0.0 11640 1360 ? S 21:10 0:00 /bin/bash /bin/proxysql_galera_checker 10 11 1 1 /var/lib/proxysql/proxysql_galera_check.log
      proxysql 345 0.0 0.0 11768 1608 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 346 0.0 0.0 11768 908 ? S 21:10 0:00 /bin/bash /usr/bin/proxysql_node_monitor 10 11 /var/lib/proxysql/proxysql_node_monitor.log
      proxysql 356 0.0 0.0 11640 1364 ? S 21:10 0:00 /bin/bash /bin/proxysql_galera_checker 10 11 1 1 /var/lib/proxysql/proxysql_galera_check.log
      [root@pxc57-1 ~]# ps aux | grep -E 'proxysql_(galera_checker|node_monitor)' | wc
      2065 32351 323516

      Node monitor log

      Tue Mar 13 21:37:01 CET 2018 WARNING: Could not retrieve cluster login info from ProxySQL. Please check cluster login credentials.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                ramesh.sivaraman Ramesh Sivaraman
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour, 1 minute
                  1h 1m