Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-25227

Unable to move Hive metastore from one node to another

    XMLWordPrintableJSON

    Details

      Description

      While moving Hive Metastore from one node to another, it is failing at test DB connection step in configure Component page.Seeing following error in ambari-agent logs:

      19-03-22 11:15:38,527 - DB connection check started.
      2019-03-22 11:15:38,527 - There was an unknown error while checking database connectivity: Configuration parameter 'db_name' was not found in configurations dictionary!
      Traceback (most recent call last):
        File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 145, in actionexecute
          db_connection_check_structured_output = self.execute_db_connection_check(config, tmp_dir)
        File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 281, in execute_db_connection_check
          if db_name == DB_MYSQL:
        File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/config_dictionary.py", line 73, in __getattr__
          raise Fail("Configuration parameter '" + self.name + "' was not found in configurations dictionary!")
      Fail: Configuration parameter 'db_name' was not found in configurations dictionary!
      2019-03-22 11:15:38,528 - Host checks completed.
      2019-03-22 11:15:38,529 - Check db_connection_check was unsuccessful. Exit code: 1. Message: Configuration parameter 'db_name' was not found in configurations dictionary!
      
      Command failed after 1 tries
      

      Reproduce steps:

      1. Goto Hive Service.
      2. Click on Actions tab and select Move Hive Metastore.
      3. Fill appropriate values in Move Wizard.
      4. Before going to configure component page from Review page, please run following ambari-server command on ambari server host:
        ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
      5. Click next on review page, it will fail at test DB connection step in Configure component page.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ababiichuk Andriy Babiichuk
                Reporter:
                ababiichuk Andriy Babiichuk
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h