[ 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)