XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.3.20, 2.4.13
    • N/A
    • N/A
    • None
    • Centos 7.6.181
    • MXS-SPRINT-111, MXS-SPRINT-112, MXS-SPRINT-113, MXS-SPRINT-114, MXS-SPRINT-115, MXS-SPRINT-116, MXS-SPRINT-117, MXS-SPRINT-118, MXS-SPRINT-120, MXS-SPRINT-121, MXS-SPRINT-122, MXS-SPRINT-123

    Description

      we are facing memory leak by maxscale

      here is the conf:

      cat /etc/maxscale.cnf
      # Globals
      [maxscale]
      threads=auto
      log_augmentation=1
      ms_timestamp=1
      syslog=1
      admin_host=0.0.0.0
      admin_port=8989
      writeq_high_water=32M
      writeq_low_water=512K
      # Servers
      [te-db01]
      type=server
      address=10.5.0.11
      port=3306
      protocol=mariadbbackend
      persistpoolmax=10000
      persistmaxtime=3600
      [te-db02]
      type=server
      address=10.5.0.12
      port=3306
      protocol=mariadbbackend
      persistpoolmax=10000
      persistmaxtime=3600
      [te-db03]
      type=server
      address=10.5.0.13
      port=3306
      protocol=mariadbbackend
      persistpoolmax=10000
      persistmaxtime=3600
      # Monitoring for the servers
      [Galera-Monitor]
      type=monitor
      module=galeramon
      servers=te-db01,te-db02,te-db03
      user=maxscale
      password=**
      monitor_interval=1000
      available_when_donor=true
      disable_master_failback=true
      # Galera router service
      [Galera-Service]
      type=service
      router=readwritesplit
      servers=te-db01,te-db02,te-db03
      user=maxscale
      password=**
      master_failure_mode=fail_on_write
      #disable_sescmd_history=true
      master_reconnection=true
      max_sescmd_history=1000
      prune_sescmd_history=true
      # Galera cluster listener
      [Galera-Listener]
      type=listener
      service=Galera-Service
      protocol=mariadbclient
      port=3306
      

      and:

      cat global-options.cnf
      [maxscale]
      auth_connect_timeout=3
      auth_read_timeout=1
      auth_write_timeout=2
      admin_auth=true
      passive=0
      

      and

      cat Galera-Service.cnf
      [Galera-Service]
      type=service
      servers=te-db01,te-db02,te-db03
      router=readwritesplit
      user=maxscale
      password=**
      master_failure_mode=fail_on_write
      master_reconnection=true
      max_sescmd_history=500
      prune_sescmd_history=true
      enable_root_user=false
      max_retry_interval=3600
      max_connections=0
      connection_timeout=500
      auth_all_servers=false
      strip_db_esc=true
      localhost_match_wildcard_host=true
      log_auth_warnings=true
      retry_on_failure=true
      session_track_trx_state=false
      retain_last_statements=-1
      use_sql_variables_in=all
      slave_selection_criteria=LEAST_CURRENT_OPERATIONS
      max_slave_replication_lag=-1
      max_slave_connections=255
      retry_failed_reads=true
      disable_sescmd_history=false
      strict_multi_stmt=false
      strict_sp_calls=false
      master_accept_reads=false
      connection_keepalive=250
      causal_reads=false
      causal_reads_timeout=10
      delayed_retry=false
      delayed_retry_timeout=10
      transaction_replay=false
      transaction_replay_max_size=1Mi
      optimistic_trx=false
      session_trace=0
      

      and

      cat global-options.cnf
      [maxscale]
      auth_connect_timeout=3
      auth_read_timeout=1
      auth_write_timeout=2
      admin_auth=true
      passive=0
      

      and

      [te-db01]
      type=server
      persistpoolmax=13000
      priority=200
      address=10.5.0.11
      port=3306
      protocol=mariadbbackend
      persistmaxtime=3600
      extra_port=0
      proxy_protocol=false
      ssl=false
      ssl_version=MAX
      ssl_cert_verify_depth=9
      ssl_verify_peer_certificate=true
      priority=200
      [te-db02]
      type=server
      persistpoolmax=13000
      priority=100
      address=10.5.0.12
      port=3306
      protocol=mariadbbackend
      persistmaxtime=3600
      extra_port=0
      proxy_protocol=false
      ssl=false
      ssl_version=MAX
      ssl_cert_verify_depth=9
      ssl_verify_peer_certificate=true
      priority=100
      [te-db03]
      type=server
      persistpoolmax=13000
      priority=300
      address=10.5.0.13
      port=3306
      protocol=mariadbbackend
      persistmaxtime=3600
      extra_port=0
      proxy_protocol=false
      ssl=false
      ssl_version=MAX
      ssl_cert_verify_depth=9
      ssl_verify_peer_certificate=true
      priority=300
      

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              massimo.disaro Massimo
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.