[jira] [Commented] (HAWQ-55) System admin cannot set optimizer_release_mdcache (OFF) when gp_metadata_versioning is (OFF)

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

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

ASF GitHub Bot commented on HAWQ-55:
------------------------------------

GitHub user karthijrk reopened a pull request:

    https://github.com/apache/incubator-hawq/pull/41

    [HAWQ-55] Adding dependency between optimizer_release_mdcache and gp_metadata_version

    Adding dependency between optimizer_release_mdcache and gp_metadata_version guc. Error out when both guc are set to off which is invalid state

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gcaragea/incubator-hawq karthijrk-HAWQ-55

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/41.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #41
    
----
commit d89bc15c333394ecf85f498126c5d5746a131c63
Author: Karthikeyan Jambu Rajaraman <kr...@pivotal.io>
Date:   2015-10-26T18:56:03Z

    adding dependency between optimizer_release_mdcache and gp_metadata_versioning guc. Error out when both guc are set to off which is invalid state

----


> System admin cannot set optimizer_release_mdcache (OFF) when gp_metadata_versioning is (OFF)
> --------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-55
>                 URL: https://issues.apache.org/jira/browse/HAWQ-55
>             Project: Apache HAWQ
>          Issue Type: Improvement
>          Components: Metadata Versioning
>            Reporter: George Caragea
>            Assignee: George Caragea
>
> As a system admin, I should not be able to set optimizer_release_mdcache (OFF) when gp_metadata_versioning is (OFF) so that I cannot get into a incorrect state with unexpected behavior from the host system.
> *Acceptance Criteria*
> GIVEN I am a system
> AND gp_metadata_versioning is OFF
> WHEN I try to set optimizer_release_mdcache (OFF)
> THEN I should see a warning message stating that if optimizer_release_mdcache is to be turned OFF, set gp_metadata_versioning should be turned ON
> *Context*
> Default:
> optimizer_release_mdcache (ON)
> gp_metadata_versioning (OFF)
> Bad state: We don't want the user to be able to do this
> optimizer_release_mdcache (OFF)
> gp_metadata_versioning (OFF)
> If a user turns optimizer_release_mdcache (OFF), then gp_metadata_versioning should be turned (ON). Otherwise, the optimizer can end up using stale data in the metadata cache, generating unexpected behavior. 



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