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

Maxscale does not startup properly and crashes after trying to login to database

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.4.3, 2.0.0
    • Fix Version/s: 2.1.0
    • Component/s: Core
    • Labels:
      None
    • Environment:
      Ubuntu 14.04

      Description

      After a server restart. Maxcale wont start properly and crash when trying to connect to database:

      MariaDB Corporation MaxScale /var/log/maxscale/maxscale1.log Wed May 4 13:08:37 2016
      -----------------------------------------------------------------------
      2016-05-04 13:08:37 notice : Configuration file: /etc/maxscale.cnf
      2016-05-04 13:08:37 notice : Log directory: /var/log/maxscale
      2016-05-04 13:08:37 notice : Data directory: /var/lib/maxscale
      2016-05-04 13:08:37 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale
      2016-05-04 13:08:37 notice : Service cache: /var/cache/maxscale
      2016-05-04 13:08:37 notice : Initialise CLI router module V1.0.0.
      2016-05-04 13:08:37 notice : Loaded module cli: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libcli.so
      2016-05-04 13:08:37 notice : Initialise readconnroute router module V1.1.0.
      2016-05-04 13:08:37 notice : Loaded module readconnroute: V1.1.0 from /usr/lib/x86_64-linux-gnu/maxscale/libreadconnroute.so
      2016-05-04 13:08:37 notice : Initialise the MySQL Galera Monitor module V2.0.0.
      2016-05-04 13:08:37 notice : Loaded module galeramon: V2.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libgaleramon.so
      2016-05-04 13:08:37 warning: Monitor 'Galera Monitor' is missing the 'monitor_interval' parameter, using default value of 10000 milliseconds.
      2016-05-04 13:08:37 notice : Encrypted password file /var/lib/maxscale/.secrets can't be accessed (No such file or directory). Password encryption is not used.
      2016-05-04 13:08:37 notice : No query classifier specified, using default 'qc_mysqlembedded'.
      2016-05-04 13:08:37 notice : Loaded module qc_mysqlembedded: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libqc_mysqlembedded.so
      2016-05-04 13:08:37 notice : qc_mysqlembedded loaded.
      2016-05-04 13:08:37 notice : Query classifier initialized.
      2016-05-04 13:08:37 notice : MariaDB Corporation MaxScale 1.4.3 (C) MariaDB Corporation Ab 2013-2015
      2016-05-04 13:08:37 notice : MaxScale is running in process 2681
      2016-05-04 13:08:37 warning: Galera Service: User 'maxscale' is missing SELECT privileges on mysql.tables_priv table. Database name will be ignored in authentication. MySQL error message: SELECT command denied to user 'maxscale'@'10.8.0.1' for table 'tables_priv'
      2016-05-04 13:08:37 error : Failed to retrieve users: SELECT command denied to user 'maxscale'@'10.8.0.1' for table 'tables_priv'
      2016-05-04 13:08:37 error : Galera Service: Unable to load database grant information, MaxScale authentication will proceed without including database permissions. See earlier error messages for user 'maxscale' for more information.
      2016-05-04 13:08:37 notice : Loading users from [mysql.user] without access to [mysql.db] for service [Galera Service]. MaxScale Authentication with DBname on connect will not consider database grants.
      2016-05-04 13:08:37 error : Failed to obtain address for host ::1, Address family for hostname not supported
      2016-05-04 13:08:37 warning: Failed to add user root@::1 for service [Galera Service]. This user will be unavailable via MaxScale.
      2016-05-04 13:08:37 warning: Duplicate MySQL user found for service [Galera Service]: root@127.0.0.1
      2016-05-04 13:08:37 notice : Loaded 6 MySQL Users for service [Galera Service].
      2016-05-04 13:08:37 notice : Loaded module MySQLClient: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so
      2016-05-04 13:08:37 notice : Listening MySQL connections at 0.0.0.0:3306
      2016-05-04 13:08:37 error : Failed to bind to UNIX Domain socket '/var/run/mysqld/mysqld.sock': 2, No such file or directory
      2016-05-04 13:08:37 error : Unable to start to listen port 0 for MySQLClient Galera Service.
      2016-05-04 13:08:37 notice : Loaded module maxscaled: V1.0.0 from /usr/lib/x86_64-linux-gnu/maxscale/libmaxscaled.so
      2016-05-04 13:08:37 notice : Listening maxscale connections at localhost:6603
      2016-05-04 13:08:37 notice : Started MaxScale log flusher.
      2016-05-04 13:08:37 notice : MaxScale started with 4 server threads.
      2016-05-04 13:08:37 notice : Server changed state: server1[10.8.0.2:3306]: new_slave
      2016-05-04 13:08:37 notice : Server changed state: server2[10.8.0.3:3306]: new_slave
      2016-05-04 13:08:37 notice : Server changed state: server3[10.8.0.4:3306]: new_master
      2016-05-04 13:08:37 notice : Server changed state: server4[10.8.0.5:3306]: new_slave
      2016-05-04 13:10:41 error : Fatal: MaxScale 1.4.3 received fatal signal 11. Attempting backtrace.
      2016-05-04 13:10:41 error : Commit ID: c2706bab69d1f3b5f1f3ec70f78b1a4803788fec System name: Linux Release string: Ubuntu 14.04.4 LTS Embedded library version: (null)
      2016-05-04 13:10:41 error : /usr/bin/maxscale() [0x403c20]
      2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340) [0x7fb0da08b340]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(atomic_add+0x12) [0x7fb0da51c7f3]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(mysql_users_fetch+0x33) [0x7fb0da526944]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(gw_find_mysql_user_password_sha1+0x1b7) [0x7fb0d0192535]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(gw_check_mysql_scramble_data+0x15b) [0x7fb0d0193ed9]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(+0x9132) [0x7fb0d0194132]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(mysql_auth_authenticate+0x139) [0x7fb0d0193834]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libMySQLClient.so(+0x32fe) [0x7fb0d018e2fe]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(+0x45c31) [0x7fb0da53dc31]
      2016-05-04 13:10:41 error : /usr/lib/x86_64-linux-gnu/maxscale/libmaxscale-common.so.1.0.0(poll_waitevents+0x69c) [0x7fb0da53d415]
      2016-05-04 13:10:41 error : /usr/bin/maxscale(worker_thread_main+0x2a) [0x404ea7]
      2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7fb0da083182]
      2016-05-04 13:10:41 error : /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fb0d99d447d]

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                markus makela markus makela
                Reporter:
                Christian87 Christian Schmidt
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: