[LENS-421] New query getting launched for resultsetmetadata retrieval

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1
• Assignee: SushilMohanty
• Reporter: Arshad Matin
• Created: 19/Mar/15 11:49
• Updated: 05/May/15 17:44
• Resolved: 20/Mar/15 11:41

Description

01 Mar 2015 08:37:51,934 [event_processor_thread] ERROR org.apache.lens.driver.jdbc.JDBCResultSet - Error getting JDBC type information: Streaming result set com.mysql.jdbc.RowDataDynamic@308bcfc is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@308bcfc is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:914)
at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2181)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1542)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
at com.mysql.jdbc.Connection.getMaxBytesPerChar(Connection.java:3673)
at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:482)
at com.mysql.jdbc.ResultSetMetaData.getColumnDisplaySize(ResultSetMetaData.java:214)
at org.apache.lens.driver.jdbc.JDBCResultSet.getHiveTypeForSQLType(JDBCResultSet.java:173)
at org.apache.lens.driver.jdbc.JDBCResultSet$1.getColumns(JDBCResultSet.java:111)
at org.apache.lens.lib.query.AbstractOutputFormatter.initColumnFields(AbstractOutputFormatter.java:140)
at org.apache.lens.lib.query.AbstractOutputFormatter.init(AbstractOutputFormatter.java:123)
at org.apache.lens.lib.query.WrappedFileFormatter.init(WrappedFileFormatter.java:54)
at org.apache.lens.lib.query.FileSerdeFormatter.init(FileSerdeFormatter.java:72)
at org.apache.lens.server.query.ResultFormatter.formatOutput(ResultFormatter.java:104)
at org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:65)
at org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:41)
at org.apache.lens.server.api.events.AsyncEventListener$2.run(AsyncEventListener.java:101)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
01 Mar 2015 08:37:51,935 [event_processor_thread] WARN org.apache.lens.server.query.ResultFormatter - Exception while formatting result for 48609723-6b91-401a-84d4-8bd1dc93d161
java.lang.NullPointerException
at org.apache.lens.lib.query.AbstractOutputFormatter.initColumnFields(AbstractOutputFormatter.java:140)
at org.apache.lens.lib.query.AbstractOutputFormatter.init(AbstractOutputFormatter.java:123)
at org.apache.lens.lib.query.WrappedFileFormatter.init(WrappedFileFormatter.java:54)
at org.apache.lens.lib.query.FileSerdeFormatter.init(FileSerdeFormatter.java:72)
at org.apache.lens.server.query.ResultFormatter.formatOutput(ResultFormatter.java:104)
at org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:65)
at org.apache.lens.server.query.ResultFormatter.process(ResultFormatter.java:41)
at org.apache.lens.server.api.events.AsyncEventListener$2.run(AsyncEventListener.java:101)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)