I found the reason of the failure, and it is due to these 2 upgrades executed in order:
mysql/upgrade-1.2.0-to-1.3.0.mysql.sql mysql/upgrade-1.2.0-to-2.0.0.mysql.sql Both sql files have the same commands, so 1.2.0 -> 2.0.0 fails with repeated columns. The HMS upgrade script will need to handle this special situation. Back to +1 On Thu, Feb 11, 2016 at 2:04 PM, Sergio Pena <sergio.p...@cloudera.com> wrote: > While running some HMS upgrade tests, I found an issue while upgrading > Mysql metastore from 1.2.0 to 2.0.0 > > http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/110/consoleFull > > Executing sql test: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql > ++ dirname > /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql > + cd /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql > Executing script: > /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql > + echo 'Executing script: > /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql' > + mysql hive_hms_testing > ERROR 1060 (42S21) > Upgrading MetaStore schema from 1.2.0 to 2.0.0 > > < HIVE-7018 Remove Table and Partition tables column LINK_TARGET_ID from > Mysql for other DBs do not have it > > Completed remove LINK_TARGET_ID > Completed remove LINK_TARGET_ID > at line 1 in file: '023-HIVE-12807.mysql.sql': Duplicate column name > 'CQ_HIGHEST_TXN_ID' > Test failed: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql > Error: Cannot execute SQL file: > /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql > > > > I think we should identify and fix the issue. > I am -1 > > - Sergio > > > On Thu, Feb 11, 2016 at 1:40 PM, Alan Gates <alanfga...@gmail.com> wrote: > >> +1, checks sigs, build with fresh maven repo, and did a quick smoke test. >> >> Does the PMC member who votes on the most RC's get a prize? >> >> Alan. >> >> Sergey Shelukhin <ser...@apache.org> >> February 9, 2016 at 18:52 >> Another day, another release candidate... this time fixing the logging >> issue. >> >> Apache Hive 2.0.0 Release Candidate 3 is available here: >> >> http://people.apache.org/~sershe/hive-2.0.0-rc3/ >> >> Maven artifacts are at >> >> https://repository.apache.org/content/repositories/orgapachehive-1046/ >> >> >> Source tag for RC3 (github mirror) is: >> https://github.com/apache/hive/releases/tag/release-2.0.0-rc3 >> >> >> Voting will conclude in 72 hours. >> >> Hive PMC Members: Please test and vote. >> >> >> Thanks. >> >> >> >