Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4719

MariaDB can't start while bootup but it can start by "service mysql start"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 5.5.29-galera
    • N/A
    • Galera
    • CentOS 6.4 running i ESXi 5.0

    Description

      A machine it can start MariaDB without problem by running "service mysql start". However it can't start while it is boot up.

      The MariaDB setting as :

      [mariadb]
      wsrep_provider = /usr/lib64/galera/libgalera_smm.so
      wsrep_retry_autocommit = 0
      wsrep_cluster_name = 'cluster_db'
      wsrep_sst_method = rsync
      wsrep_cluster_address = 'gcomm://172.17.113.84'
      wsrep_node_incoming_address = '172.17.113.239'
      wsrep_node_address = '172.17.113.239'

      The error log :

      130627 16:18:45 [Note] WSREP: (2f8de7d6-df02-11e2-0800-19a94e29eb0c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
      130627 16:33:26 [Note] WSREP: EVS version 0
      130627 16:33:26 [Note] WSREP: PC version 0
      130627 16:33:26 [Note] WSREP: gcomm: connecting to group 'cluster_db', peer '172.17.113.84:'
      130627 16:33:26 [ERROR] WSREP: Permission denied
      130627 16:33:26 [ERROR] WSREP: failed to open gcomm backend connection: 13: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'Permission denied': 13 (Permission denied)
               at gcomm/src/asio_tcp.cpp:listen():808
      130627 16:33:26 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -13 (Permission denied)
      130627 16:33:26 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1290: Failed to open channel 'cluster_db' at 'gcomm://172.17.113.84': -13 (Permission denied)
      130627 16:33:26 [ERROR] WSREP: gcs connect failed: Permission denied
      130627 16:33:26 [ERROR] WSREP: wsrep::connect() failed: 6
      130627 16:33:26 [ERROR] Aborting

      If running by "service mysql start", the logging is :

      130627 16:35:23 [Note] WSREP: (8288ae1a-df04-11e2-0800-2779113716ed, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
      130627 16:35:23 [Note] WSREP: EVS version 0
      130627 16:35:23 [Note] WSREP: PC version 0
      130627 16:35:23 [Note] WSREP: gcomm: connecting to group 'cluster_db', peer '172.17.113.84:'
      130627 16:35:23 [Note] WSREP: (8288ae1a-df04-11e2-0800-2779113716ed, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://172.17.113.226:4567
      130627 16:35:24 [Note] WSREP: (8288ae1a-df04-11e2-0800-2779113716ed, 'tcp://0.0.0.0:4567') turning message relay requesting off
      130627 16:35:24 [Note] WSREP: declaring 106ba418-def4-11e2-0800-d23b2dc3d420 stable
      130627 16:35:24 [Note] WSREP: declaring 942d9a32-df00-11e2-0800-4f8fb8ad9dcd stable

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            ak47fans Eddy Lai
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.