Gao, Rui-Xian created TRAFODION-2161: ----------------------------------------
Summary: Metadata upgrade failed when there is user view on repository tables Key: TRAFODION-2161 URL: https://issues.apache.org/jira/browse/TRAFODION-2161 Project: Apache Trafodion Issue Type: Bug Components: sql-cmu Environment: centos6.7 CDH5.4.8 esgynDB R2.2 0811 daily build Reporter: Gao, Rui-Xian Assignee: Roberta Marton [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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)