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

RU - Unable to begin RU due to MySQL "Error preallocating sequence numbers"

    XMLWordPrintableJSON

    Details

      Description

      Tried to make an RU,

      • Deployed clustered, enabled Namenode HA, distributed bits
      • Attempt to begin an RU (through both UI and curl call)
        curl -X POST -u admin:admin -H 'X-Requested-By:1' http://server:8080/api/v1/clusters/cl1/upgrades -d '{"Upgrade": {"repository_version": "2.2.3.0-2610"}}'
        {
          "status": 500,
          "message": "\nException Description: Error preallocating sequence numbers.  The sequence table information is not complete."
        }
        
      Exception Description: Error preallocating sequence numbers.  The sequence table information is not complete.
      

      Saw this on two clusters (Ubuntu and SP3) with MySQL Ambari DB that I deployed to EC2.
      Ambari version, 2.0.0-137
      Database: MySQL

      mysql> select * from ambari_sequences;
      +--------------------------+----------------+
      | sequence_name            | sequence_value |
      +--------------------------+----------------+
      | alert_current_id_seq     |            132 |
      | alert_definition_id_seq  |             64 |
      | alert_group_id_seq       |             20 |
      | alert_history_id_seq     |            456 |
      | alert_notice_id_seq      |              0 |
      | alert_target_id_seq      |              0 |
      | cluster_id_seq           |              2 |
      | cluster_version_id_seq   |              2 |
      | configgroup_id_seq       |              1 |
      | config_id_seq            |             95 |
      | group_id_seq             |              1 |
      | host_role_command_id_seq |           1001 |
      | host_version_id_seq      |             12 |
      | member_id_seq            |              1 |
      | operation_level_id_seq   |              5 |
      | permission_id_seq        |              5 |
      | principal_id_seq         |              2 |
      | principal_type_id_seq    |              3 |
      | privilege_id_seq         |              1 |
      | repo_version_id_seq      |              2 |
      | requestschedule_id_seq   |              1 |
      | resourcefilter_id_seq    |             20 |
      | resource_id_seq          |              4 |
      | resource_type_id_seq     |              8 |
      | service_config_id_seq    |             31 |
      | upgrade_id_seq           |              2 |
      | upgrade_item_id_seq      |              0 |
      | user_id_seq              |              2 |
      | viewentity_id_seq        |              0 |
      | view_instance_id_seq     |              2 |
      +--------------------------+----------------+
      30 rows in set (0.00 sec)
      

        Attachments

        1. AMBARI-10098.patch
          2 kB
          Alejandro Fernandez

          Issue Links

            Activity

              People

              • Assignee:
                afernandez Alejandro Fernandez
                Reporter:
                afernandez Alejandro Fernandez
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: