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

About Presistent Connection Mysql Gone away

    XMLWordPrintable

    Details

      Description

      When I Started Persistent Connections. I got a lot of feedback from phper about
      MySQL server has gone away, and I Try persistmaxtime bigger or a smaller one , But
      Same situation . and I was think , When a connection is found, the connection in the pool has not timed out,next second,The backend connection has freed this connection cause this situation ??? and When I close Persistent Connections is ok ~

      About php log

      2017/09/14 10:37:17 192.168.37.146 seller.juanpi.com/goods/needClick02/sa_id/137
      ERR: 2006:MySQL server has gone away
       [ SQL语句 ] : SELECT u_uid as uid,u_username as username,u_email as email,u_mobile as mobile,u_password as password,u_status as isrank,u_avatar as pic,u_regtime as addtime,u_token as token FROM js_member.js_users_10 WHERE ( u_uid = 23800579 ) LIMIT 1  
      ERR: 2006:MySQL server has gone away
       [ SQL语句 ] : SELECT sum(sd_trade_money) as money FROM js_settlement_old.js_settlementpop_detail WHERE ( sd_uid = '23800579' ) AND ( sd_trade_status IN (2,3) ) AND ( sd_trade_type IN (9,12,16) ) AND ( sd_trade_money > 0 ) LIMIT 1  
      ERR: 2006:MySQL server has gone away
       [ SQL语句 ] : SELECT `bi_is_overseas` FROM js_business.js_business_info WHERE ( `uid` = '23800579' ) LIMIT 1  
      ERR: 2006:MySQL server has gone away
       [ SQL语句 ] : SELECT * FROM js_scm.js_storage_agreement WHERE ( `sa_id` = 137 ) AND ( `sa_company_id` = '23800579' ) LIMIT 1  
      ERR: 2006:MySQL server has gone away
       [ SQL语句 ] : SELECT `bc_addtime`,`ba_endtime` FROM js_business.js_business_accept WHERE ( `ba_uid` = '23800579' ) AND ( `ba_type` = 2 ) AND ( `ba_sa_id` = null ) AND ( `ba_endtime` > 1505356414 ) LIMIT 1  
      

      part of maxscale.cnf

      [server1]
      type=server
      address=192.168.143.233
      port=3310
      protocol=MySQLBackend
      #persistpoolmax=100
      #persistmaxtime=28800
      serv_weight=2
       
      [server2]
      type=server
      address=192.168.143.233
      port=3309
      protocol=MySQLBackend
      serv_weight=1
      #persistpoolmax=100
      #persistmaxtime=28800
       
      [LoadBlance Service]
      type=service
      router=readconnroute
      servers=server2,server1
      user=maxopt
      passwd=06B65119699B323CEAC99134D694B4CE
      router_options=slave
      #filters=DBfirewall
       
       
      [RW test]
      type=service
      router=readwritesplit
      servers=server1,server2
      user=maxopt
      passwd=06B65119699B323CEAC99134D694B4CE
      max_slave_connections=100%
      max_slave_replication_lag= 100
      router_options=slave_selection_criteria=LEAST_ROUTER_CONNECTIONS
      router_options=master_failure_mode=fail_on_write,retry_failed_reads=false
      filters=Hint
       
      [Read-Only Listener]
      type=listener
      service=LoadBlance Service
      address=0.0.0.0  
      protocol=MySQLClient
      port=4008
       
      [Read-Write Listener]
      type=listener
      service=RW test
      address=0.0.0.0 
      protocol=MySQLClient
      port=4006
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              makeyuan make Yuan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: