Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2161

Metadata upgrade failed when there is user view on repository tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.1-incubating
    • sql-cmu
    • None
    • centos6.7 CDH5.4.8
      R2.2 0811 daily build

    Description

      [trafodion@centosqa-1 ~]$ sqlci
      EsgynDB Advanced Conversational Interface 2.2.0
      Copyright (c) 2015-2016 Esgyn Corporation
      >>get schemas;

          • ERROR[1395] Trafodion needs to be upgraded on this system due to metadata version mismatch. Do 'initialize trafodion, upgrade' to upgrade metadata. Or do 'initialize trafodion, drop' followed by 'initialize trafodion'. Be aware that the second option will delete all metadata and user objects from Trafodion database .
          • ERROR[8822] The statement was not prepared.

      >>initialize trafodion, upgrade;
      Metadata Upgrade: started

      Version Check: started
      Metadata needs to be upgraded from Version 1.0.1 to 2.1.0.
      Upgrade needed for Catalogs, Privileges, Repository.
      Version Check: done

      Drop Old Metadata: started
      Drop Old Metadata: done

      Backup Current Metadata: started
      Backup Current Metadata: done

      Drop Current Metadata: started
      Drop Current Metadata: done

      Initialize New Metadata: started
      Initialize New Metadata: done

      Copy Old Metadata: started
      Copy Old Metadata: done

      Validate Metadata Copy: started
      Validate Metadata Copy: done

      Delete Old Metadata Info: started
      Delete Old Metadata Info: done

      Upgrade Repository: Started
      Start: Drop Old Repository
      End: Drop Old Repository
      Start: Rename Current Repository
      Upgrade Repository: Restoring Old Repository
      Start: Rename Old Repository back to New
      End: Rename Old Repository back to New
      Upgrade Repository: Restore done

      Drop Old Metadata: started
      Drop Old Metadata: done

      Metadata Upgrade: failed

          • ERROR[1427] Table cannot be renamed. Reason: Operation not allowed if dependent views exist. Drop the views and recreate them after rename.
          • ERROR[8839] Transaction was aborted.

      — SQL operation failed with errors.

      Attachments

        Activity

          People

            rachelgao Gao, Rui-Xian
            rachelgao Gao, Rui-Xian
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: