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)
Chris Kistner
added a comment - - 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.
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:
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 - - 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.
People
Diego Dupin
Andreas Gottardi
Votes:
3Vote for this issue
Watchers:
4Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":851.6999999880791,"ttfb":273.10000002384186,"pageVisibility":"visible","entityId":59509,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"f5a27732-5413-4ad1-83c7-0492db1203e0","navigationType":0,"readyForUser":924,"redirectCount":0,"resourceLoadedEnd":598.6000000238419,"resourceLoadedStart":278.39999997615814,"resourceTiming":[{"duration":19.600000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":278.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":278.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":298,"responseStart":0,"secureConnectionStart":0},{"duration":19.600000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":278.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":278.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":298.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":198.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":278.80000001192093,"connectEnd":300.69999998807907,"connectStart":300.69999998807907,"domainLookupEnd":300.69999998807907,"domainLookupStart":300.69999998807907,"fetchStart":278.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":304.80000001192093,"responseEnd":477.19999998807907,"responseStart":319.60000002384186,"secureConnectionStart":300.69999998807907},{"duration":319.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":279.10000002384186,"connectEnd":279.10000002384186,"connectStart":279.10000002384186,"domainLookupEnd":279.10000002384186,"domainLookupStart":279.10000002384186,"fetchStart":279.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":305.19999998807907,"responseEnd":598.6000000238419,"responseStart":327.19999998807907,"secureConnectionStart":279.10000002384186},{"duration":48.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":279.30000001192093,"connectEnd":279.30000001192093,"connectStart":279.30000001192093,"domainLookupEnd":279.30000001192093,"domainLookupStart":279.30000001192093,"fetchStart":279.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":306.10000002384186,"responseEnd":328.10000002384186,"responseStart":326.5,"secureConnectionStart":279.30000001192093},{"duration":55.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":279.39999997615814,"connectEnd":279.39999997615814,"connectStart":279.39999997615814,"domainLookupEnd":279.39999997615814,"domainLookupStart":279.39999997615814,"fetchStart":279.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":306.30000001192093,"responseEnd":335.19999998807907,"responseStart":332.60000002384186,"secureConnectionStart":279.39999997615814},{"duration":48.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":279.60000002384186,"connectEnd":279.60000002384186,"connectStart":279.60000002384186,"domainLookupEnd":279.60000002384186,"domainLookupStart":279.60000002384186,"fetchStart":279.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":306.5,"responseEnd":328,"responseStart":324.89999997615814,"secureConnectionStart":279.60000002384186},{"duration":24.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":279.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":279.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":304,"responseStart":0,"secureConnectionStart":0},{"duration":48.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":280,"connectEnd":280,"connectStart":280,"domainLookupEnd":280,"domainLookupStart":280,"fetchStart":280,"redirectEnd":0,"redirectStart":0,"requestStart":307.10000002384186,"responseEnd":328.10000002384186,"responseStart":325.69999998807907,"secureConnectionStart":280},{"duration":25.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":280.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":280.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":305.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":60.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":280.30000001192093,"connectEnd":280.30000001192093,"connectStart":280.30000001192093,"domainLookupEnd":280.30000001192093,"domainLookupStart":280.30000001192093,"fetchStart":280.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":307.30000001192093,"responseEnd":340.80000001192093,"responseStart":333.5,"secureConnectionStart":280.30000001192093},{"duration":303.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":285.89999997615814,"connectEnd":285.89999997615814,"connectStart":285.89999997615814,"domainLookupEnd":285.89999997615814,"domainLookupStart":285.89999997615814,"fetchStart":285.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":362.30000001192093,"responseEnd":589.3999999761581,"responseStart":585.1999999880791,"secureConnectionStart":285.89999997615814},{"duration":303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":290.60000002384186,"connectEnd":290.60000002384186,"connectStart":290.60000002384186,"domainLookupEnd":290.60000002384186,"domainLookupStart":290.60000002384186,"fetchStart":290.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":385.69999998807907,"responseEnd":593.6000000238419,"responseStart":588.3000000119209,"secureConnectionStart":290.60000002384186},{"duration":242.30000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":601.6999999880791,"connectEnd":601.6999999880791,"connectStart":601.6999999880791,"domainLookupEnd":601.6999999880791,"domainLookupStart":601.6999999880791,"fetchStart":601.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":807.8000000119209,"responseEnd":844,"responseStart":843,"secureConnectionStart":601.6999999880791},{"duration":212.69999998807907,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":844.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":844.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1057.300000011921,"responseStart":0,"secureConnectionStart":0},{"duration":187.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":865.3999999761581,"connectEnd":865.3999999761581,"connectStart":865.3999999761581,"domainLookupEnd":865.3999999761581,"domainLookupStart":865.3999999761581,"fetchStart":865.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1012.6000000238419,"responseEnd":1052.5,"responseStart":1051.800000011921,"secureConnectionStart":865.3999999761581}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":103,"responseStart":273,"responseEnd":291,"domLoading":276,"domInteractive":999,"domContentLoadedEventStart":999,"domContentLoadedEventEnd":1048,"domComplete":1709,"loadEventStart":1709,"loadEventEnd":1710,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":973.5},{"name":"bigPipe.sidebar-id.end","time":974.1999999880791},{"name":"bigPipe.activity-panel-pipe-id.start","time":974.3000000119209},{"name":"bigPipe.activity-panel-pipe-id.end","time":976.1999999880791},{"name":"activityTabFullyLoaded","time":1106.8999999761581}],"measures":[],"correlationId":"91662f7c581a9e","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":105,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
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:
Version 1.5.5 and 1.4.6 does not have this issue.