trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DaveBirdsall <>
Subject [GitHub] incubator-trafodion pull request #565: [TRAFODION-2037] Improve DDL concurre...
Date Wed, 29 Jun 2016 16:31:07 GMT
GitHub user DaveBirdsall opened a pull request:

    [TRAFODION-2037] Improve DDL concurrency + repository and metadata upgrades

    This change includes all the planned metadata changes for Trafodion release 2.1. The following
changes are included:
    1. Fix for JIRA TRAFODION-2037: This adds a new index, TABLE_CONSTRAINTS_IDX, to the metadata
TABLE_CONSTRAINTS table, along with a CONTROL QUERY SHAPE in one of the metadata code paths
to force its use. This change improves DDL concurrency.
    2. A FLAGS column (LARGEINT) for future use has been added to the DEFAULTS, ROUTINES,
LIBRARIES and LIBRARY_USAGES metadata tables. For now, the value of this column will always
be zero. On upgrade of existing metadata, these columns are set to zero.
    3. The repository tables have been upgraded. On upgrade of existing metadata, new columns
are set to NULL. Specifically:
    a. The following columns added to “_REPOS_”.METRIC_QUERY_AGGR_TABLE table:
    b. The following columns added to “_REPOS_”.METRIC_QUERY_TABLE table:
    c. The length of the EXPLAIN_PLAN column in METRIC_QUERY_TABLE was changed from 200000
to 1000000.
    d. The following columns added to “_REPOS_”.METRIC_SESSION_TABLE table:
    The version of the metadata changes from 1.0.1 to 2.1.0 with this change.
    When you include this patch in your Trafodion 2.1 development instance, if you have existing
metadata you will find that any SQL operation will fail with error 1395, which asks you to
upgrade your metadata. You may find it useful to perform a backup of your instance before
including this patch.
    To upgrade your metadata, perform the command "initialize trafodion, upgrade" in a fresh
sqlci session. After successful completion, exit that session, and start a new one. It would
be helpful if you could forward any experiences you have with this procedure to the Trafodion
dev list or to file JIRAs if the experience was negative.
    Users of older releases of Trafodion will need to perform these same steps when installing
Trafodion 2.1.

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

    $ git pull Trafodion2037

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

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

    This closes #565
commit 973bdcec14c35ad473bebee46caa302bbb5a49d2
Author: Anuradha Hegde <>
Date:   2016-05-12T17:44:19Z

    Merge branch 'master' of into wrkbrnch

commit 86d78805f38ecbcc83d9d936a89880df2b7901bb
Author: Anuradha Hegde <>
Date:   2016-05-13T16:27:25Z

    Merge branch 'master' of into wrkbrnch

commit afa1daa5942329ce58870f4126021ad23865a8eb
Author: Anuradha Hegde <>
Date:   2016-05-16T19:58:02Z

    Merge branch 'master' of into wrkbrnch

commit 2b111fdb1d867261a5305461f908d904b68f0be0
Author: Anuradha Hegde <>
Date:   2016-06-17T17:14:52Z

    Merge branch 'master' of into wrkbrnch

commit 0b7663e4051eeaa37ee8c58e9df8ac1df5a0cb04
Author: Anuradha Hegde <>
Date:   2016-06-24T17:33:53Z

    New columns for repository tables and related changes

commit 85783bfe445ca63aa089a901d8e407e6226cea7c
Author: Anuradha Hegde <>
Date:   2016-06-24T17:37:07Z

    Merge branch 'master' of into wrkbrnch

commit ee53fc30ff0e30ab704bf61f86261b04451ff26f
Author: Anuradha Hegde <>
Date:   2016-06-24T19:23:46Z

    cleaned up the commented code

commit 463a699de3a45ff56e0c5b176f248827cbb09a7e
Author: Anuradha Hegde <>
Date:   2016-06-24T21:42:57Z

    minor fix

commit 2605440bee754ff60192656f330d0851d8046f17
Author: Dave Birdsall <>
Date:   2016-06-27T18:32:44Z

    [TRAFODION-2037] Improve DDL concurrency

commit 548f72977195ac625246b4867c11a04f0e296de4
Author: Dave Birdsall <>
Date:   2016-06-27T18:32:49Z

    Merge remote branch 'hegdean/wrkbrnch' into Trafodion2037

commit ff89586c6ce2f4a769f56f439950a735c2556823
Author: Dave Birdsall <>
Date:   2016-06-28T20:36:25Z

    Upgrade repository code changes


If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at or file a JIRA ticket
with INFRA.

View raw message