[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13710621#comment-13710621 ] Sergey Shelukhin commented on HIVE-4807: Can you guys also change the config template? Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Fix For: 0.12.0 Attachments: Hive-4807.0.patch, Hive-4807.1.patch, Hive-4807.2.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13708710#comment-13708710 ] Hudson commented on HIVE-4807: -- FAILURE: Integrated in Hive-trunk-hadoop2-ptest #14 (See [https://builds.apache.org/job/Hive-trunk-hadoop2-ptest/14/]) HIVE-4807 : Hive metastore hangs (Sarvesh Sakalanaga via Ashutosh Chauhan) (hashutosh: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1501675) * /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java * /hive/trunk/ivy/libraries.properties * /hive/trunk/jdbc/build.xml * /hive/trunk/metastore/ivy.xml Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Fix For: 0.12.0 Attachments: Hive-4807.0.patch, Hive-4807.1.patch, Hive-4807.2.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13705678#comment-13705678 ] Hudson commented on HIVE-4807: -- Integrated in Hive-trunk-hadoop2 #282 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/282/]) HIVE-4807 : Hive metastore hangs (Sarvesh Sakalanaga via Ashutosh Chauhan) (Revision 1501675) Result = ABORTED hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1501675 Files : * /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java * /hive/trunk/ivy/libraries.properties * /hive/trunk/jdbc/build.xml * /hive/trunk/metastore/ivy.xml Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Fix For: 0.12.0 Attachments: Hive-4807.0.patch, Hive-4807.1.patch, Hive-4807.2.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13704339#comment-13704339 ] Hudson commented on HIVE-4807: -- Integrated in Hive-trunk-h0.21 #2190 (See [https://builds.apache.org/job/Hive-trunk-h0.21/2190/]) HIVE-4807 : Hive metastore hangs (Sarvesh Sakalanaga via Ashutosh Chauhan) (Revision 1501675) Result = FAILURE hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1501675 Files : * /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java * /hive/trunk/ivy/libraries.properties * /hive/trunk/jdbc/build.xml * /hive/trunk/metastore/ivy.xml Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Fix For: 0.12.0 Attachments: Hive-4807.0.patch, Hive-4807.1.patch, Hive-4807.2.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13704466#comment-13704466 ] Hudson commented on HIVE-4807: -- Integrated in Hive-trunk-hadoop1-ptest #61 (See [https://builds.apache.org/job/Hive-trunk-hadoop1-ptest/61/]) HIVE-4807 : Hive metastore hangs (Sarvesh Sakalanaga via Ashutosh Chauhan) (Revision 1501675) Result = FAILURE hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1501675 Files : * /hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java * /hive/trunk/ivy/libraries.properties * /hive/trunk/jdbc/build.xml * /hive/trunk/metastore/ivy.xml Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Fix For: 0.12.0 Attachments: Hive-4807.0.patch, Hive-4807.1.patch, Hive-4807.2.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13702243#comment-13702243 ] Sarvesh Sakalanaga commented on HIVE-4807: -- Looks like a class path issue to me. Will take a look. Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Attachments: Hive-4807.0.patch, Hive-4807.1.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13698097#comment-13698097 ] Sarvesh Sakalanaga commented on HIVE-4807: -- The change currently just pulls down BoneCp artifact and does not change the default value to BoneCP. To enable BoneCp, the setting “datanucleus.connectionPoolingType” in hive-site.xml should be set to “BoneCP”. All the hive systems test pass with this setting. Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Attachments: Hive-4807.0.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13698181#comment-13698181 ] Ashutosh Chauhan commented on HIVE-4807: Couple of questions: * Could there be a performance implication of this? I know perf is irrelevant if functionality doesn't work, but it will be comforting to know that BoneCP is not 10x (randomly picked number) than DBCP. * If we find (hopefully) that earlier statement is true, than we should just rip off DBCP and only use BoneCP as default. Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Attachments: Hive-4807.0.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13698289#comment-13698289 ] Sarvesh Sakalanaga commented on HIVE-4807: -- BoneCP is faster that DBCP so we should be good here. BoneCP claims that they are upto 25X faster then DBCP and C3P0. Online resources also claim the same. Agree that we could make BoneCP as default. Let me submit a new patch for this. Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Attachments: Hive-4807.0.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4807) Hive metastore hangs
[ https://issues.apache.org/jira/browse/HIVE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13698491#comment-13698491 ] Ashutosh Chauhan commented on HIVE-4807: +1 Hive metastore hangs Key: HIVE-4807 URL: https://issues.apache.org/jira/browse/HIVE-4807 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 Reporter: Sarvesh Sakalanaga Assignee: Sarvesh Sakalanaga Attachments: Hive-4807.0.patch, Hive-4807.1.patch Hive metastore hangs (does not accept any new connections) due to a bug in DBCP. The root cause analysis is here https://issues.apache.org/jira/browse/DBCP-398. The fix is to change Hive connection pool to BoneCP which is natively supported by DataNucleus. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
