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

mysqldump sst fails on maria-10.0-galera

    XMLWordPrintable

Details

    Description

      mysqldump sst fails with the following errors in the donor log :

      .. snip ..
      140414 23:00:49 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0''
      ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      140414 23:00:50 [Note] WSREP: 0.0 (nirbhay-VirtualBox): State transfer from 1.0 (nirbhay-VirtualBox) complete.
      140414 23:00:50 [Note] WSREP: Member 0 (nirbhay-VirtualBox) synced with group.
      140414 23:00:50 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0': 1 (Operation not permitted)
      140414 23:00:50 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0'' failed: 1 (Operation not permitted)
      ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      ERROR 1146 (42S02) at line 14: Table 'mysql.proc' doesn't exist
      mysqldump: Got errno 32 on write
      Warning: 32 bytes lost at 0x9938050, allocated by T@0 at addr2line: 'mysqldump': No such file
      0x80657d1, 0x80768b7, 0x8056fdb, 0x8059777, 0x8058e2f, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 112 bytes lost at 0x9937fa0, allocated by T@0 at 0x8065771, 0x80768b7, 0x8056fdb, 0x8059777, 0x8058e2f, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 8168 bytes lost at 0x9943610, allocated by T@0 at 0x80a20c3, 0x805f1cf, 0x80651c7, 0x80653dd, 0x806e817, 0x805126b, 0x8056fa1, 0x8059777
      Warning: 1024 bytes lost at 0x9937b60, allocated by T@0 at 0x8095b8a, 0x805c8bc, 0x8056ad1, 0x8059777, 0x8058e2f, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 8168 bytes lost at 0x993d598, allocated by T@0 at 0x80a20c3, 0x805f8e9, 0x8065554, 0x806eb5d, 0x80580e4, 0x805988a, 0x8058e2f, 0x805cdf1
      Warning: 56 bytes lost at 0x99376a8, allocated by T@0 at 0x805f80b, 0x8065554, 0x806eb5d, 0x80580e4, 0x805988a, 0x8058e2f, 0x805cdf1, 0xb73894d3
      Warning: 96 bytes lost at 0x9937608, allocated by T@0 at 0x80654bf, 0x806eb5d, 0x80580e4, 0x805988a, 0x8058e2f, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 8168 bytes lost at 0x993f5c0, allocated by T@0 at 0x80a20c3, 0x805f1cf, 0x80651c7, 0x80653dd, 0x806e817, 0x806eb18, 0x80580e4, 0x805988a
      Warning: 8168 bytes lost at 0x993b570, allocated by T@0 at 0x80a20c3, 0x805f8e9, 0x8065554, 0x8051280, 0x8058d8a, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 56 bytes lost at 0x9937548, allocated by T@0 at 0x805f80b, 0x8065554, 0x8051280, 0x8058d8a, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 96 bytes lost at 0x99374a8, allocated by T@0 at 0x80654bf, 0x8051280, 0x8058d8a, 0x805cdf1, 0xb73894d3, 0x804faf1
      Warning: 8168 bytes lost at 0x9939548, allocated by T@0 at 0x80a20c3, 0x805f1cf, 0x80651c7, 0x80653dd, 0x806e817, 0x805126b, 0x8058d8a, 0x805cdf1
      Memory lost: 42312 bytes in 12 chunks
      140414 23:00:51 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0': 1 (Operation not permitted)
      140414 23:00:51 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0'' failed: 1 (Operation not permitted)
      ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_mysqldump: 91: ~project/repo/maria/tmp/maria-10.0-galera/install//bin/wsrep_sst_common: WSREP_SST_OPT_CONF: parameter not set
      ERROR 2013 (HY000) at line 607: Lost connection to MySQL server during query
      140414 23:00:53 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0': 1 (Operation not permitted)
      140414 23:00:53 [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 'ef60a9fa-c449-11e3-925b-6227eedfe193:0'' failed: 1 (Operation not permitted)
      .. snip ..

      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.