[ https://issues.apache.org/jira/browse/HIVE-8850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hari Sankar Sivarama Subramaniyan updated HIVE-8850: ---------------------------------------------------- Description: We can run into issues as described below: Hive script adds 2800 partitions to a table and during this it can get a SQLState 08S01 [Communication Link Error] and bonecp kill all the connections in the pool. The partitions are added and a create table statement executes (Metering_IngestedData_Compressed). The map job finishes successfully and while moving the table to the hive warehouse the ObjectStore.java commitTransaction() raises the error: commitTransaction was called but openTransactionCalls = 0. This probably indicates that there are unbalanced calls to openTransaction/commitTransaction was: We can run into issues as described below: Hive script adds 2800 partitions to a table and during this it can get a SQLState 08S01 [Communication Link Error] and bonecp kill all the connections in the pool. The partitions are added and a create table statement executes (Metering_IngestedData_Compressed). The map job finishes successfully and while moving the table to the hive warehouse the ObjectStore.java commitTransaction() raises the error: commitTransaction was called but openTransactionCalls = 0. This probably indicates that there are unbalanced calls to openTransaction/commitTransaction {code} > ObjectStore:: rollbackTransaction() should set the transaction status to > TXN_STATUS.ROLLBACK irrespective of whether it is active or not > ---------------------------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-8850 > URL: https://issues.apache.org/jira/browse/HIVE-8850 > Project: Hive > Issue Type: Bug > Reporter: Hari Sankar Sivarama Subramaniyan > Assignee: Hari Sankar Sivarama Subramaniyan > > We can run into issues as described below: > Hive script adds 2800 partitions to a table and during this it can get a > SQLState 08S01 [Communication Link Error] and bonecp kill all the connections > in the pool. The partitions are added and a create table statement executes > (Metering_IngestedData_Compressed). The map job finishes successfully and > while moving the table to the hive warehouse the ObjectStore.java > commitTransaction() raises the error: commitTransaction was called but > openTransactionCalls = 0. This probably indicates that there are unbalanced > calls to openTransaction/commitTransaction -- This message was sent by Atlassian JIRA (v6.3.4#6332)