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

MaxScale crashes while loading database names for readconnroute service

    XMLWordPrintable

    Details

      Description

      MaxScale 2.0.5 crashes like this:

      2017-10-08 01:32:25 error : Loading database names for service Write Service encountered error when querying database privileges: Lost connection to MySQL server during query.
      2017-10-08 01:32:25 error : Fatal: MaxScale 2.0.5 received fatal signal 11. Attempting backtrace.
      2017-10-08 01:32:25 error : Commit ID: 60c69d0f7f461a1773a4e848e87fa3fcc7b0e421 System name: Linux Release string: Red Hat Enterprise Linux Server release 6.9 (Santiago)
      2017-10-08 01:32:25 error : /usr/bin/maxscale() [0x403b9c]
      2017-10-08 01:32:25 error : /lib64/libpthread.so.0() [0x394360f7e0]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(hashtable_fetch+0x88) [0x3946a3fae2]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libMySQLAuth.so.1.0.0(check_db_name_after_auth+0x68) [0x7fbd3ccf2f27]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libMySQLAuth.so.1.0.0(+0x1fe0) [0x7fbd3ccf2fe0]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libMySQLAuth.so.1.0.0(+0x1261) [0x7fbd3ccf2261]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libMySQLClient.so(+0x254a) [0x7fbd3cef654a]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libMySQLClient.so(+0x248c) [0x7fbd3cef648c]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libmaxscale-common.so.1.0.0() [0x3946a4ceff]
      2017-10-08 01:32:25 error : /usr/lib64/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x5fc) [0x3946a4c7a4]
      2017-10-08 01:32:25 error : /usr/bin/maxscale(worker_thread_main+0x2a) [0x404a5f]
      2017-10-08 01:32:25 error : /lib64/libpthread.so.0() [0x3943607aa1]
      2017-10-08 01:32:25 error : /lib64/libc.so.6(clone+0x6d) [0x39432e8bcd]
      

      It crashes way too often with this same backtrace.

      Simplified configuration file content is:

      [maxscale]
      threads=auto
      maxlog=1
      logdir=/opt/hd/db/var/
      datadir=/opt/hd/db/datadir1
      cachedir=/opt/hd/db/tmp/maxscale_cache
       
      [e47]
      type=server
      address=XXX.XX.XXX.25
      port=3306
      protocol=MySQLBackend
       
      [e48]
      type=server
      address=XXX.XX.XXX.26
      port=3306
      protocol=MySQLBackend
       
      [e49]
      type=server
      address=XXX.XX.XXX.27
      port=3306
      protocol=MySQLBackend
       
      [MySQL Monitor]
      type=monitor
      module=mysqlmon
      servers=e47,e48,e49
      user=maxscale
      passwd=YYY
      #monitor_interval=10000
      monitor_interval=1000
      backend_connect_timeout=9
      detect_stale_master=true
       
      [Write Service]
      type=service
      router=readconnroute
      router_options=master
      servers=e47,e48,e49
      user=maxscale
      passwd=YYY
      enable_root_user=true
       
      [Read Service]
      type=service
      router=readconnroute
      servers=e47,e48,e49
      user=maxscale
      passwd=YYY
      enable_root_user=true
       
      [MaxAdmin Service]
      type=service
      router=cli
       
      [MaxInfo Service]
      type=service
      router=maxinfo
      user=maxscale
      passwd=YYY
       
      [MaxInfo Listener]
      type=listener
      service=MaxInfo Service
      protocol=MySQLClient
      port=9003
       
      [Write Listener]
      type=listener
      service=Write Service
      protocol=MySQLClient
      port=3306
       
      [Read Listener]
      type=listener
      service=Read Service
      protocol=MySQLClient
      port=4307
       
      [MaxAdmin Unix Listener]
      type=listener
      service=MaxAdmin Service
      protocol=maxscaled
      socket=default
       
      [MaxAdmin TCP Listener]
      address=0.0.0.0
      type=listener
      service=MaxAdmin Service
      protocol=maxscaled
      port=6603
      

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: