BEFORE YOU UPGRADE TO VERTICA 9.1: Fix unsafe buddy projections

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser

As of Vertica 9.1, the SELECT and ORDER BY clauses of all projection buddies must specify columns in the same order. Before upgrading to Vertica 9.1 or higher, current users are strongly urged to run a pre-upgrade script that checks that all projection buddies in the current database comply with these new requirements.

Warning: If the upgrade encounters non-compliant projections, it regards them as unsafe and the upgrade will fail. You must then revert to the previous installation.

Solution: Download and run the pre-upgrade script.

The pre-upgrade script analyzes your current database and identifies unsafe projections. It then generates a DDL script that you can use before the upgrade to remedy these projections and ensure compliance with system K-safety.

You can run this script starting now. To get more information and download the pre-upgrade script, go to the 9.1 Pre-Upgrade Script page at my.vertica.com.

Comments

  • sreeblrsreeblr Employee, Registered User

    may need quite some effort to make changes and get change approval from client. Any workarounds to run as is post upgrade?

  • SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser

    Not at this time. It must be run before upgrading.

  • ScottLScottL Employee, Registered User

    Hi Sarah - Are there release notes for 9.1? I can only find the 9.0 release notes. Thanks

  • ScottLScottL Employee, Registered User

    Hi Sarah - when we run this script in a 3 node environment running Vertica 8.1.1.2 and Linux 7.4:

    sh identify_differently_sorted_buddies.sh -U dbadmin -w xxxxxx

    We get the follow error:

    identify_differently_sorted_buddies.sh: line 25: syntax error near unexpected token '$'do\4r''
    l identify_differently_sorted_buddies.sh: line 25: 'do

    Thanks
    Scott

  • ScottLScottL Employee, Registered User

    Downloaded a fresh copy of the script into another 3 node, Vertica 8.1.1.2 and Linux 7.4, created a 'tmp' directory and got the following:

    sh identify_differently_sorted_buddies.sh -U dbadmin -w xxxxx
    ': not a valid identifiered_buddies.sh: line 2: unset: OUTPUTDIR identify_differently_sorted_buddies.sh: line 3: $'\r': command not found identify_differently_sorted_buddies.sh: line 27: syntax error near unexpected token $'do\r''
    'dentify_differently_sorted_buddies.sh: line 27: `do

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file