Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3428

columnstoreBackup fails on first time ssh logins

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.1.5
    • Icebox
    • None
    • None

    Description

      Running columnstoreBackup on a root install. It failed the first time I ran it wil ssh login failed.
      I then logged into the PM1 with ssh-keys and got the prompt for first time login.
      Then columnstoreBackup worked after that.

      root@ip-172-31-38-221:~# ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
      [2019-08-14 15:29:44] [root] ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
      [2019-08-14 15:29:44] ERROR: Cannot connect to root@172.31.38.221
      [2019-08-14 15:29:44] Check that ssh and passwordless login are available.
      [2019-08-14 15:29:44] Backup Status: Failed
      [2019-08-14 15:29:44] Runtime: 00:00:00
      root@ip-172-31-38-221:~# ssh root@172.31.38.221
      The authenticity of host '172.31.38.221 (172.31.38.221)' can't be established.
      ECDSA key fingerprint is SHA256:7zNh5Q6ZWOnqNU3VxlsiSqIPPeGZBxUUOvrUoTEocvU.
      Are you sure you want to continue connecting (yes/no)? yes
      Warning: Permanently added '172.31.38.221' (ECDSA) to the list of known hosts.
      Welcome to Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-1044-aws x86_64)

      • Reduce system reboots and improve kernel security. Activate at:
        https://ubuntu.com/livepatch
        152 packages can be updated.
        0 updates are security updates.
          • System restart required ***
            Last login: Wed Aug 14 15:18:57 2019 from 47.186.101.176
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~# exit
            logout
            Connection to 172.31.38.221 closed.
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~#
            root@ip-172-31-38-221:~# ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
            [2019-08-14 15:30:07] [root] ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
            [2019-08-14 15:30:08] rsync -a -z --delete --link-dest=./backup.1 root@172.31.38.221:/usr/local/mariadb/columnstore/etc/Columnstore.xml columnstoreBackupData
            [2019-08-14 15:30:08] rsync -a -z --delete --link-dest=./backup.1 root@172.31.38.221:/usr/local/mariadb/columnstore/releasenum columnstoreBackupData
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] Configuration:
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] Server PM1 address = 172.31.38.221
            [2019-08-14 15:30:12] Backup Server location = columnstoreBackupData
            [2019-08-14 15:30:12] SystemName: columnstore-1
            [2019-08-14 15:30:12] SingleServerInstall: n
            [2019-08-14 15:30:12] serverTypeInstall: 1
            [2019-08-14 15:30:12] PMwithUM: y
            [2019-08-14 15:30:12] DBRootStorageType: internal
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] UMs: 2
            [2019-08-14 15:30:12] PMs: 2
            [2019-08-14 15:30:12] um1 ip 172.31.43.170
            [2019-08-14 15:30:12] um1 host 172.31.43.170
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] um2 ip 172.31.34.20
            [2019-08-14 15:30:12] um2 host 172.31.34.20
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] pm1 ip 172.31.38.221
            [2019-08-14 15:30:12] pm1 host ip-172-31-38-221
            [2019-08-14 15:30:12] pm1 DBRootCount: 1
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] pm2 ip 172.31.35.18
            [2019-08-14 15:30:12] pm2 host 172.31.35.18
            [2019-08-14 15:30:12] pm2 DBRootCount: 1
            [2019-08-14 15:30:12]
            [2019-08-14 15:30:12] DBRootCount: 2
            [2019-08-14 15:30:12] DBRoot1: /usr/local/mariadb/columnstore/data1
            [2019-08-14 15:30:12] DBRoot2: /usr/local/mariadb/columnstore/data2
            [2019-08-14 15:30:12] WARNING: Disk Space NOT verified for backup system.
            [2019-08-14 15:30:12] Run with -d option to collect disk space requirement information via rsync.
            [2019-08-14 15:30:12] ssh root@172.31.38.221 du -s -b /usr/local/mariadb/columnstore/data1
            [2019-08-14 15:30:13] ssh root@172.31.38.221 du -s -b /usr/local/mariadb/columnstore/mysql/db
            [2019-08-14 15:30:14] ssh root@172.31.35.18 du -s -b /usr/local/mariadb/columnstore/data2
            [2019-08-14 15:30:14] ssh root@172.31.35.18 du -s -b /usr/local/mariadb/columnstore/mysql/db
            [2019-08-14 15:30:21] rsync -a -z --delete --link-dest=../backup.1/cnf root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/my.cnf columnstoreBackupData/cnf/
            [2019-08-14 15:30:21] rsync -a -z --delete --link-dest=../backup.1/cnf root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/my.cnf.d columnstoreBackupData/cnf/
            [2019-08-14 15:30:22] Backing up PMs
            [2019-08-14 15:30:22] Backing up pm1dbroot1
            [2019-08-14 15:30:22] rsync -a -z --delete --copy-links --link-dest=../backup.1/pm1dbroot1 root@172.31.38.221:/usr/local/mariadb/columnstore/data1 columnstoreBackupData/pm1dbroot1
            [2019-08-14 15:30:22] Backing up pm1dbroot1 local query data
            [2019-08-14 15:30:22] rsync -a -z --delete --link-dest=../backup.1/pm1DB root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/pm1DB
            [2019-08-14 15:30:24] Backing up pm2dbroot1
            [2019-08-14 15:30:24] rsync -a -z --delete --copy-links --link-dest=../backup.1/pm2dbroot1 root@172.31.35.18:/usr/local/mariadb/columnstore/data2 columnstoreBackupData/pm2dbroot1
            [2019-08-14 15:30:24] Backing up pm2dbroot1 local query data
            [2019-08-14 15:30:24] rsync -a -z --delete --link-dest=../backup.1/pm2DB root@172.31.35.18:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/pm2DB
            [2019-08-14 15:30:26] Waiting for backups to complete...
            Progress [=========================>] (100%) 13 Mbps 00:00:25 Approx Time Remaining
            [2019-08-14 15:30:36] DONE
            [2019-08-14 15:30:36] Backing up UMs
            [2019-08-14 15:30:36] Backing up um1
            [2019-08-14 15:30:36] rsync -a -z --delete --link-dest=../backup.1/um1 root@172.31.43.170:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/um1
            [2019-08-14 15:30:38] Backing up um2
            [2019-08-14 15:30:38] rsync -a -z --delete --link-dest=../backup.1/um2 root@172.31.34.20:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/um2
            [2019-08-14 15:30:40] DONE
            [2019-08-14 15:30:40] Backup Status: Success
            [2019-08-14 15:30:40] Runtime: 00:00:33
            root@ip-172-31-38-221:~#

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.