ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-19055) Removing Tasks From host_role_command Causes Upgrades To Show As PENDING
Date Fri, 02 Dec 2016 17:17:58 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-19055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15715705#comment-15715705
] 

Hadoop QA commented on AMBARI-19055:
------------------------------------

{color:red}-1 overall{color}.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12841491/AMBARI-19055.patch
  against trunk revision .

    {color:red}-1 patch{color}.  The patch command could not apply the patch.

Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/9509//console

This message is automatically generated.

> Removing Tasks From host_role_command Causes Upgrades To Show As PENDING
> ------------------------------------------------------------------------
>
>                 Key: AMBARI-19055
>                 URL: https://issues.apache.org/jira/browse/AMBARI-19055
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.2.0
>            Reporter: Jonathan Hurley
>            Assignee: Jonathan Hurley
>            Priority: Critical
>             Fix For: 2.5.0
>
>         Attachments: AMBARI-19055.patch
>
>
> It may be necessary to remove entries from the {{host_role_command}} table if the size
of the table has grown excessively large in order to reduce the query times for "IN_PROGRESS"
requests.
> However, if you remove all tasks for an upgrade, but you leave the stages, request, and
upgrade items, the upgrade will appear as though it is now {{PENDING}}.
> {noformat:title=Before Removal}
> {
>   "href": "http://localhost:8080/api/v1/clusters/c1/upgrades/12",
>   "Upgrade": {
>     "cluster_name": "c1",
>     "create_time": 1480517560897,
>     "direction": "UPGRADE",
>     "downgrade_allowed": true,
>     "end_time": 1480517643350,
>     "exclusive": false,
>     "from_version": "2.5.0.0-1237",
>     "pack": "nonrolling-upgrade-2.5",
>     "progress_percent": 0,
>     "request_context": "Upgrading to 2.5.2.0-67",
>     "request_id": 12,
>     "request_status": "COMPLETED",
>     "skip_failures": false,
>     "skip_service_check_failures": false,
>     "start_time": 1480517560950,
>     "suspended": false,
>     "to_version": "2.5.2.0-67",
>     "type": "INTERNAL_REQUEST",
>     "upgrade_type": "NON_ROLLING"
>   },
>   "upgrade_groups": [
>   ...
> {noformat}
> {noformat:title=After Removal}
> {
>   "href": "http://localhost:8080/api/v1/clusters/c1/upgrades/12",
>   "Upgrade": {
>     "cluster_name": "c1",
>     "create_time": 1480517560897,
>     "direction": "UPGRADE",
>     "downgrade_allowed": true,
>     "end_time": 1480517643350,
>     "exclusive": false,
>     "from_version": "2.5.0.0-1237",
>     "pack": "nonrolling-upgrade-2.5",
>     "progress_percent": 0,
>     "request_context": "Upgrading to 2.5.2.0-67",
>     "request_id": 12,
>     "request_status": "PENDING",
>     "skip_failures": false,
>     "skip_service_check_failures": false,
>     "start_time": 1480517560950,
>     "suspended": false,
>     "to_version": "2.5.2.0-67",
>     "type": "INTERNAL_REQUEST",
>     "upgrade_type": "NON_ROLLING"
>   },
>   "upgrade_groups": [
>   ...
> {noformat}
> The actual request is showing as {{COMPLETED}} correctly:
> {noformat}
> {
>   "href": "http://localhost:8080/api/v1/clusters/c1/requests/12",
>   "Requests": {
>     "aborted_task_count": 0,
>     "cluster_name": "c1",
>     "completed_task_count": 0,
>     "create_time": 1480517560897,
>     "end_time": 1480517643350,
>     "exclusive": false,
>     "failed_task_count": 0,
>     "id": 12,
>     "inputs": null,
>     "operation_level": null,
>     "progress_percent": 100,
>     "queued_task_count": 0,
>     "request_context": "Upgrading to 2.5.2.0-67",
>     "request_schedule": null,
>     "request_status": "COMPLETED",
>     "resource_filters": [],
>     "start_time": 1480517560950,
>     "task_count": 0,
>     "timed_out_task_count": 0,
>     "type": "INTERNAL_REQUEST"
>   },
>   "tasks": [],
>   ...
> {noformat}
> STR:
> - Perform a simple upgrade of a ZK-only cluster
> - Find out the ID of the upgrade request (say its 12)
> - Remove tasks
> {code}
> DELETE FROM execution_command WHERE task_id IN (SELECT task_id FROM host_role_command
WHERE request_id = 12)
> DELETE FROM host_role_command WHERE request_id = 12
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message