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)
