[CONJ-403] Nullpointer-Exception in Select-Statement - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 1.5.6
Fix Version/s: 1.5.7
Component/s: Other
Labels:
None
Environment:
Windows 10 version 10.0 running on amd64; Cp1252; en_US (nb)
Java(TM) SE Runtime Environment (build 1.8.0_112-b15)
NetBeans IDE 8.2 (Build 201609300101)

Description

The following statement on a remote database throws the shown exception:

use s12db1;
select * from machines;

Exception shown in Netbeans Notifications:

java.lang.NullPointerException
at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483)
at org.netbeans.modules.db.dataview.util.DataViewUtils.closeResources(DataViewUtils.java:195)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.getForeignKeys(DBMetaDataFactory.java:179)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.checkForeignKeys(DBMetaDataFactory.java:408)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.postprocessTables(DBMetaDataFactory.java:320)
[catch] at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1Loader.run(SQLExecutionHelper.java:174)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1443)
at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:68)
at org.openide.util.lookup.Lookups.executeWith(Lookups.java:303)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2058)

Error does not occur in version 1.5.5.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

netbeans64_2016-12-27_09-38-42.png
35 kB
2016-12-27 08:39

Issue Links

causes

CONJ-408 Connector/J 1.5.6 throws HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

Closed

Activity

Ascending order - Click to sort in descending order

Andreas Gottardi created issue - 2016-12-27 08:39

Andreas Gottardi made changes - 2016-12-27 08:40

Field	Original Value	New Value
Description	The following statement on a remote database throws the shown exception: {{use s12db1; select * from machines;}} Exception shown in Netbeans Notifications: {{java.lang.NullPointerException at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483) at org.netbeans.modules.db.dataview.util.DataViewUtils.closeResources(DataViewUtils.java:195) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.getForeignKeys(DBMetaDataFactory.java:179) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.checkForeignKeys(DBMetaDataFactory.java:408) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.postprocessTables(DBMetaDataFactory.java:320) [catch] at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1Loader.run(SQLExecutionHelper.java:174) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1443) at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:68) at org.openide.util.lookup.Lookups.executeWith(Lookups.java:303) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2058)}} Error does not occur in version 1.5.5.	The following statement on a remote database throws the shown exception: use s12db1; select * from machines; Exception shown in Netbeans Notifications: java.lang.NullPointerException at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483) at org.netbeans.modules.db.dataview.util.DataViewUtils.closeResources(DataViewUtils.java:195) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.getForeignKeys(DBMetaDataFactory.java:179) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.checkForeignKeys(DBMetaDataFactory.java:408) at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.postprocessTables(DBMetaDataFactory.java:320) [catch] at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1Loader.run(SQLExecutionHelper.java:174) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1443) at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:68) at org.openide.util.lookup.Lookups.executeWith(Lookups.java:303) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2058) Error does not occur in version 1.5.5.

Andreas Gottardi made changes - 2016-12-27 08:40

Description

The following statement on a remote database throws the shown exception:

use s12db1;
select * from machines;

Exception shown in Netbeans Notifications:

java.lang.NullPointerException
at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483)
at org.netbeans.modules.db.dataview.util.DataViewUtils.closeResources(DataViewUtils.java:195)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.getForeignKeys(DBMetaDataFactory.java:179)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.checkForeignKeys(DBMetaDataFactory.java:408)
at org.netbeans.modules.db.dataview.meta.DBMetaDataFactory.postprocessTables(DBMetaDataFactory.java:320)
[catch] at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1Loader.run(SQLExecutionHelper.java:174)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1443)
at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:68)
at org.openide.util.lookup.Lookups.executeWith(Lookups.java:303)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2058)
Error does not occur in version 1.5.5.

Chris Kistner added a comment - 2017-01-10 10:31 - edited

We're getting the NullPointerException at the same line with our webapp, but our stacktrace is quite different:

java.lang.NullPointerException

        at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483)

        at org.hibernate.engine.jdbc.internal.TypeInfoExtracter.extractTypeInfo(TypeInfoExtracter.java:85)

        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:144)

        at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:85)

        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:184)

        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:156)

        at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1827)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1785)

        at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)

        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)

        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900)

        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59)

        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)

        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47)

        at com.google.inject.persist.jpa.JpaPersistService.start(JpaPersistService.java:94)

        at com.company.di.GuiceBootstrap.contextInitialized(GuiceBootstrap.java:48)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118)

        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634)

        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1092)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1984)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

        at java.util.concurrent.FutureTask.run(FutureTask.java:262)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

        at java.lang.Thread.run(Thread.java:745)

Our environment is as follow:

CentOS 6.6 x64
OpenJDK 1.7.0_75 (rhel-2.5.4.0.el6_6-x86_64 u75-b13)
Apache Tomcat 7.0.72
Webapp maven dependencies: guice-persist-3.0, hibernate-entitymanager-4.2.21.Final, hibernate-core-4.2.21.Final, hibernate-jpa-2.0-api-1.0.1.Final

Version 1.5.5 and 1.4.6 does not have this issue.

Chris Kistner added a comment - 2017-01-10 10:31 - edited We're getting the NullPointerException at the same line with our webapp, but our stacktrace is quite different: java.lang.NullPointerException at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483) at org.hibernate.engine.jdbc.internal.TypeInfoExtracter.extractTypeInfo(TypeInfoExtracter.java:85) at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:144) at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:85) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:184) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:156) at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1827) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1785) at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:47) at com.google.inject.persist.jpa.JpaPersistService.start(JpaPersistService.java:94) at com.company.di.GuiceBootstrap.contextInitialized(GuiceBootstrap.java:48) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1092) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1984) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Our environment is as follow: CentOS 6.6 x64 OpenJDK 1.7.0_75 (rhel-2.5.4.0.el6_6-x86_64 u75-b13) Apache Tomcat 7.0.72 Webapp maven dependencies: guice-persist-3.0, hibernate-entitymanager-4.2.21.Final, hibernate-core-4.2.21.Final, hibernate-jpa-2.0-api-1.0.1.Final Version 1.5.5 and 1.4.6 does not have this issue.

Diego Dupin made changes - 2017-01-11 12:58

Fix Version/s

1.5.7 [ 22500 ]

Richard Stanford added a comment - 2017-01-11 17:57 - edited

We are able to trigger this when using JDBI to return generated keys:

Caused by: java.lang.NullPointerException
at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483)
at org.skife.jdbi.v2.Cleanables$ResultSetCleanable.cleanup(Cleanables.java:65)
at org.skife.jdbi.v2.BaseStatement$StatementCleaningCustomizer.cleanup(BaseStatement.java:126)
at org.skife.jdbi.v2.BaseStatement.cleanup(BaseStatement.java:101)
at org.skife.jdbi.v2.GeneratedKeys.first(GeneratedKeys.java:84)
.....

Tracing through, it appears that the generated keys are returned successfully, no exceptions are thrown, but packetFetcher is indeed null in:

Buffer buffer = packetFetcher.getReusableBuffer();

I can also confirm that this issue does not appear in 1.5.5

The particular datatype of the incremented key is a BIGINT(20) in case that makes a difference. Once the row is inserted, SELECTing the row works as expected even in 1.5.6.

Richard Stanford added a comment - 2017-01-11 17:57 - edited We are able to trigger this when using JDBI to return generated keys: Caused by: java.lang.NullPointerException at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.close(MariaSelectResultSet.java:483) at org.skife.jdbi.v2.Cleanables$ResultSetCleanable.cleanup(Cleanables.java:65) at org.skife.jdbi.v2.BaseStatement$StatementCleaningCustomizer.cleanup(BaseStatement.java:126) at org.skife.jdbi.v2.BaseStatement.cleanup(BaseStatement.java:101) at org.skife.jdbi.v2.GeneratedKeys.first(GeneratedKeys.java:84) ..... Tracing through, it appears that the generated keys are returned successfully, no exceptions are thrown, but packetFetcher is indeed null in: Buffer buffer = packetFetcher.getReusableBuffer(); I can also confirm that this issue does not appear in 1.5.5 The particular datatype of the incremented key is a BIGINT(20) in case that makes a difference. Once the row is inserted, SELECTing the row works as expected even in 1.5.6.

Diego Dupin made changes - 2017-01-12 10:59

Status

Open [ 1 ]

In Progress [ 3 ]

Diego Dupin made changes - 2017-01-12 11:00

Priority

Minor [ 4 ]

Major [ 3 ]

Diego Dupin made changes - 2017-01-12 11:11

Link

This issue causes ~~CONJ-408~~ [ ~~CONJ-408~~ ]

Diego Dupin made changes - 2017-01-12 16:44

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:27

Workflow

MariaDB v3 [ 78910 ]

MariaDB v4 [ 134938 ]

People

Assignee:: Diego Dupin

Reporter:: Andreas Gottardi

Votes:: 3 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2016-12-27 08:39

Updated:: 2017-01-12 16:44

Resolved:: 2017-01-12 16:44

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Connector/J

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration