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

mysqld --help --verbose initializes wsrep

    Details

      Description

      Running

      mysqld --help --verbose

      initializes wsrep. This can cause an SST; if you are running mysqld as root, the files created by SST will not be usable by the "mysql" user. Other problems are inevitable. This is obviously problematic.

      [root@db2 ~]# mysqld --help --verbose >/dev/null
      140828 14:00:22 [Note] WSREP: Setting wsrep_ready to 0
      140828 14:00:22 [Note] WSREP: Read nil XID from storage engines, skipping position init
      140828 14:00:22 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
      140828 14:00:22 [Note] WSREP: wsrep_load(): Galera 25.3.5(r178) by Codership Oy <info@codership.com> loaded successfully.
      140828 14:00:22 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
      140828 14:00:22 [Note] WSREP: Found saved state: fd705e64-8a1a-11e3-82de-93de4caa4c18:-1
      140828 14:00:22 [Note] WSREP: Passing config to GCS: base_host = 192.168.30.32; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT10S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M; evs.join_retrans_period = PT1S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT30S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim =
      140828 14:00:22 [Note] WSREP: Service thread queue flushed.
      140828 14:00:22 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
      140828 14:00:22 [Note] WSREP: wsrep_sst_grab()
      140828 14:00:22 [Note] WSREP: Start replication
      140828 14:00:22 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
      140828 14:00:22 [Note] WSREP: protonet asio version 0
      140828 14:00:22 [Note] WSREP: Using CRC-32C (optimized) for message checksums.
      140828 14:00:22 [Note] WSREP: backend: asio
      140828 14:00:22 [Note] WSREP: GMCast version 0
      140828 14:00:22 [Note] WSREP: (53502b93-2ef6-11e4-a63f-032836d802ee, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
      140828 14:00:22 [Note] WSREP: (53502b93-2ef6-11e4-a63f-032836d802ee, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
      140828 14:00:22 [Note] WSREP: EVS version 0
      140828 14:00:22 [Note] WSREP: PC version 0
      140828 14:00:22 [Note] WSREP: gcomm: connecting to group 'skycluster', peer '192.168.30.31:,192.168.30.32:,192.168.30.33:'
      140828 14:00:22 [ERROR] WSREP: Address already in use
      140828 14:00:22 [ERROR] WSREP: failed to open gcomm backend connection: 98: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'Address already in use': 98 (Address already in use)
               at gcomm/src/asio_tcp.cpp:listen():814
      140828 14:00:22 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():202: Failed to open backend connection: -98 (Address already in use)
      140828 14:00:22 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1291: Failed to open channel 'skycluster' at 'gcomm://192.168.30.31,192.168.30.32,192.168.30.33': -98 (Address already in use)
      140828 14:00:22 [ERROR] WSREP: gcs connect failed: Address already in use
      140828 14:00:22 [ERROR] WSREP: wsrep::connect() failed: 7
      140828 14:00:22 [ERROR] Aborting
       
      140828 14:00:22 [Note] WSREP: waiting for client connections to close: 0
      140828 14:00:22 [Note] WSREP: Service disconnected.
      140828 14:00:23 [Note] WSREP: Some threads may fail to exit.

        Attachments

          Activity

            People

            • Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              kolbe Kolbe Kegel (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: