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

mysqldump sst fails on maria-10.0-galera

    XMLWordPrintable

Details

    Description

      mysqldump SST fails with the following errors in respective
      donor and receiver logs.

      [Donor]
      140411 12:33:55 [Note] WSREP: Node 0.0 (nirbhay-VirtualBox) requested state transfer from 'any'. Selected 1.0 (nirbhay-VirtualBox)(SYNCED) as donor.
      140411 12:33:55 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
      140411 12:33:55 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      140411 12:33:55 [Note] WSREP: Running: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0''
      ~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
      WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:55.434)
      140411 12:33:55 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
      140411 12:33:55 [ERROR] WSREP: Try 1/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
      ~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
      WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:56.478)
      140411 12:33:56 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
      140411 12:33:56 [ERROR] WSREP: Try 2/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
      ~/project//maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~/project//maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (i686) using readline 5.2
      WSREP_SST: [ERROR] this operation requires MySQL client version 5.5.x (20140411 12:33:57.529)
      140411 12:33:57 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0': 22 (Invalid argument)
      140411 12:33:57 [ERROR] WSREP: Try 3/3: 'wsrep_sst_mysqldump --user 'root' --password '' --host '10.0.2.15' --port '16001' --local-port '16000' --socket '/tmp/my_node1.sock' --gtid 'd07480a7-c196-11e3-b1bc-ef79037e7fec:0'' failed: 22 (Invalid argument)
      140411 12:33:58 [Warning] WSREP: 1.0 (nirbhay-VirtualBox): State transfer to 0.0 (nirbhay-VirtualBox) failed: -22 (Invalid argument)
      140411 12:33:58 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)

      [Receiver]
      140411 12:33:55 [Note] WSREP: Node 0.0 (nirbhay-VirtualBox) requested state transfer from 'any'. Selected 1.0 (nirbhay-VirtualBox)(SYNCED) as donor.
      140411 12:33:55 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)
      140411 12:33:55 [Note] WSREP: Requesting state transfer: success, donor: 1
      140411 12:33:58 [Warning] WSREP: 1.0 (nirbhay-VirtualBox): State transfer to 0.0 (nirbhay-VirtualBox) failed: -22 (Invalid argument)
      140411 12:33:58 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():723: Will never receive state. Need to abort.

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            nirbhay_c Nirbhay Choubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.