[ 
https://issues.apache.org/jira/browse/HIVE-13605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15266624#comment-15266624
 ] 

Zoltan Haindrich commented on HIVE-13605:
-----------------------------------------

this "already exists problem" can be easily addressed by adding cleanup prior 
to create...but thats a bit ugly -- it might not solve the issue; but might 
make the view a bit more cleaner

i think when the testdbtxnmanager fails...the following test also fails...and 
it flaps more frequently

http://ec2-54-177-240-2.us-west-1.compute.amazonaws.com/job/PreCommit-HIVE-MASTER-Build/125/testReport/org.apache.hadoop.hive.ql.security/TestStorageBasedMetastoreAuthorizationReads/history/#

i'm not sure how ptest executes the tests...i've seen connection refused 
messages earlier; and it was caused by some bad xml inside the common module; 
which ended up earlier in the classpath by mistake...without the stderr/stdout 
i can't tell its connected or not


> TestDbTxnManager failing intermittently
> ---------------------------------------
>
>                 Key: HIVE-13605
>                 URL: https://issues.apache.org/jira/browse/HIVE-13605
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Rajat Khandelwal
>
> A quick google search on "hive qa TestDbTxnManager fail" comes up with the 
> following links:
> http://mail-archives.apache.org/mod_mbox/hive-issues/201604.mbox/%3cjira.12955359.1459531017000.134177.1459824865...@atlassian.jira%3E
> http://mail-archives.apache.org/mod_mbox/hive-issues/201604.mbox/%3cjira.12823187.1429740172000.123748.1459755385...@atlassian.jira%3E
> http://mail-archives.apache.org/mod_mbox/hive-issues/201604.mbox/%3cjira.12957774.1460395463000.231973.1460652445...@atlassian.jira%3E
> https://www.mail-archive.com/issues@hive.apache.org/msg36448.html
> https://www.mail-archive.com/issues@hive.apache.org/msg35865.html
> Seeing the following stack trace:
> {noformat}
> java.sql.SQLException: Table/View 'TXNS' already exists in Schema 'APP'.
>       at org.apache.derby.iapi.error.StandardException.newException(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown
>  Source)
>       at 
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown 
> Source)
>       at 
> org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown
>  Source)
>       at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
>       at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
>       at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>       at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>       at 
> org.apache.hadoop.hive.metastore.txn.TxnDbUtil.prepDb(TxnDbUtil.java:73)
>       at 
> org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager.setUp(TestDbTxnManager.java:448)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to