#13507: Cloudera Impala- Expanding Schema tree database throws NPE for keeping ADS idle for some time

anilkalshetti reported 2015-07-15T10:20:33Z · last modified 2015-08-17T19:10:45Z

Cloudera Impala- Expanding Schema tree database throws NPE for keeping ADS idle for some time

Dev	anilkalshetti
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	17.0

Aqua Data Studio 17.0.0-dev-80
Build #: 44727
Built on: 2015-Jul-14 06:13:21 PM

OS: Ubuntu 14.04 LTE
Linux (3.13.0-55-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=4,433,379,328; Total=1,329,070,080; Free=986,494,304; CPUs=8

Database: Cloudera CDH 5.4.0 - Impala 2.2.0

Driver: Type: JDBC41- CDH5.4.0_Impala_JDBC41_v2.5.22-1040-GA
JDBC4- CDH5.4.0_Impala_JDBC4_V-2-5-22-1040-GA

Drivers downloaded from-Link

Distribution : Cloudera

Connection Type: Impala

Issue: Cloudera Impala- Expanding Schema tree database throws NPE for keeping ADS idle for some time

Steps to reproduce issue:
1. Copy the drivers JDBC41- in ADS- /datastudio/lib/drivers directory.
2. Launch ADSv17, Open Register Server Window, Select Apache Hive, Enter below credentials
Name: CDH540Impala220
Authentication block
Type: No Authentication

Connection Type: Impala
Host: 10.171.0.99
Port: 21050
Database: default

Save the connection. In ADS, Expand Schema Server node. Right click and open Open Query Analyzer.

3. Keep ADS idle for 15 minutes and then expand ADS schema tree node 'Database'.
It throws NPE.

Observation:
1. This issue is also observed for Cloudera Hive connection. [CDH5.4.0- Hive 1.1.0]
2. Issue also observed on build ADSv17-dev35

Stacktrace:

java.lang.NullPointerException

at \\.\\.\\हिñçêČάй語简�?한\\.Oꋉᡞꊄᡧenum.isClosed(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.jꁄꎙꃉꉥ.establishConnection(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.jꁄꎙꃉꉥ.createStatement(Unknown Source)

at com.common.ui.tree.A⠄⡆ᚭꑑswitch.yx(Unknown Source)

at com.common.ui.tree.A⠄⡆ᚭꑑswitch$1.process(Unknown Source)

at com.common.ui.util.BackgroundThread.run(Unknown Source)

4 attachments

ADSv17-Dev80.png

2015-07-15T10:20:33Z

122 KB
ADSv17-Dev35.png

2015-07-15T10:20:33Z

204 KB
S3ADSv17-dev82-OpenERD.png

2015-07-17T08:12:13Z

183 KB
ADSv17-dev-88.png

2015-07-23T12:31:51Z

109 KB

All Comments (5) Change History

tariqrahiman 2015-07-16T23:03:42Z

@anil: Can you reproduce this in ADS v16 ?

anilkalshetti 2015-07-17T08:12:02Z

@Tariq:

To reproduce, I kept my machine idle for 20 minutes, but it's not reproduced in ADS v16.

- But checking ADS v17-dev-82, NPE was thrown, Opening ERD.
-In Schema tree node, Right click on Table and select ER Diagram. NPE is thrown.
The NPE is related to above connection issue.
Please refer screenshot: S3ADSv17-dev82-OpenERD.png

- The issue is not reproducible consistently.

Stacktrace:

java.lang.NullPointerException

at \\.\\.\\हिñçêČάй語简�?한\\.u⢜ᚸꃾͅforswitch.isClosed(Unknown Source)

at com.aquafold.aquacore.open.rdbms.drivers.hive.Zꁫ⣵ꊭꏭpublicthrows.createStatement(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.u⢜ᚸꃾͅforswitch.createStatement(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Q⢷ꆑꅈ⠊8.h(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Q⢷ꆑꅈ⠊8.aO(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.vꂁᛇꉿᠦ.refresh(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.vꂁᛇꉿᠦ.<init>(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Yꂩᢁꀴꄊ.y(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Yꂩᢁꀴꄊ.<init>(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.o⣹̎ꂎꊳprotected.<init>(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.o⣹̎ꂎꊳprotected.a(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\._ᛅꉀꍢ⢛interface.a(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.Y⠩ꀇꊃꌹinstanceof.a(Unknown Source)

at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

at javax.swing.AbstractButton.doClick(AbstractButton.java:376)

at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

at java.awt.Component.processMouseEvent(Component.java:6525)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

at java.awt.Component.processEvent(Component.java:6290)

at java.awt.Container.processEvent(Container.java:2234)

at java.awt.Component.dispatchEventImpl(Component.java:4881)

at java.awt.Container.dispatchEventImpl(Container.java:2292)

at java.awt.Component.dispatchEvent(Component.java:4703)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)

at java.awt.Container.dispatchEventImpl(Container.java:2278)

at java.awt.Window.dispatchEventImpl(Window.java:2750)

at java.awt.Component.dispatchEvent(Component.java:4703)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:751)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:702)

at java.awt.EventQueue$3.run(EventQueue.java:696)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)

at java.awt.EventQueue$4.run(EventQueue.java:724)

at java.awt.EventQueue$4.run(EventQueue.java:722)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:721)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)