Bug 1024466
| Summary: | NullPointerException after creating a KPI | ||
|---|---|---|---|
| Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | altairpolar |
| Component: | BAM | Assignee: | David Gutierrez <dgutierr> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jan Hrcek <jhrcek> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 6.0.0 | CC: | kverlaen, pzapataf |
| Target Milestone: | ER5 | ||
| Target Release: | 6.0.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-08-06 20:08:13 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
altairpolar
2013-10-29 17:38:11 UTC
After deleting the dashboard page record from the database, I've tried to create a new SQL query and following exception has appeared. Seems not to be related with this problem, so perhaps is another bug, but not sure if it's just a consequence of previous exception/behavior: Thread id=ajp-localhost-127.0.0.1-28009-20 Thread begin date=Tue Oct 29 18:36:29 CET 2013 Thread group=main Request URL=/dashbuilder/Controller Request IP=95.39.227.236 Request date=Tue Oct 29 18:36:29 CET 2013 Request header:user-agent=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9) AppleWebKit/537.71 (KHTML, like Gecko) Version/7.0 Safari/537.71 Request header:referer=https://demo.gesconsultor.com/dashbuilder/Controller Request header:cookie=dashbuilderNavigationPoint=es-2ar-1; JSESSIONID=nZSBiUMrhaYzJ2Ch9qKvnqti.undefined; JSESSIONIDSSO=qs4Rv1IhHA+07qoMqM+Lj0ns; PHPSESSID=rs7p7lqs8or6doqj4d6v1idv61; region_left_web_2_0_cookie=1; __utma=43354106.1944028344.1357892229.1360058503.1363468774.4 Request param:idPanel=2986 Request param:dataSource=AlienVault 2 Request param:sqlQuery=SELECT inet6_ntoa( ip_src ) as sourceIP, inet6_ntoa( ip_dst ) as targetIP, alienvault_siem.acid_event.* FROM alienvault_siem.acid_event WHERE inet6_aton( '0.0.0.0' ) <> inet6_ntoa( ip_src ) Request param:factory://org.jboss.dashboard.ui.components.DataProviderHandler/currentProviderTypeChanged=false Request param:factory://org.jboss.dashboard.ui.components.DataProviderHandler/saveButtonPressed=false Request param:_fb=org.jboss.dashboard.ui.components.DataProviderHandler Request param:pAction=_factory Request param:_fp=editCreateNewDataProvider Request param:factory://org.jboss.dashboard.ui.components.DataProviderHandler/currentLangChanged=false Request param:factory://org.jboss.dashboard.ui.components.DataProviderHandler/currentLang=en Request param:factory://org.jboss.dashboard.ui.components.DataProviderHandler/providerName=Vulnerabilities by host Tx id=1898517733 Tx Isolation=2 Tx Auto commit=false Error id=1383068315331 Error date=Tue Oct 29 18:38:35 CET 2013 Error stack trace=java.lang.OutOfMemoryError: Java heap space at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1649) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1426) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2924) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:477) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2619) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1788) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2209) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:102) at org.jboss.dashboard.provider.sql.SQLDataLoader.load(SQLDataLoader.java:105) at org.jboss.dashboard.dataset.DataSetManagerImpl.loadDataSet(DataSetManagerImpl.java:101) at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSetHolder(DataSetManagerImpl.java:75) at org.jboss.dashboard.dataset.DataSetManagerImpl.getDataSet(DataSetManagerImpl.java:39) at org.jboss.dashboard.dataset.DataSetManagerImpl.refreshDataSet(DataSetManagerImpl.java:49) at org.jboss.dashboard.dataset.DataSetManagerImpl$Proxy$_$$_WeldClientProxy.refreshDataSet(DataSetManagerImpl$Proxy$_$$_WeldClientProxy.java) at org.jboss.dashboard.provider.DataProviderImpl.refreshDataSet(DataProviderImpl.java:228) at org.jboss.dashboard.ui.components.sql.SQLProviderEditor.actionSubmit(SQLProviderEditor.java:86) at org.jboss.dashboard.ui.components.DataProviderHandler.updateDataProvider(DataProviderHandler.java:374) at org.jboss.dashboard.ui.components.DataProviderHandler.actionEditCreateNewDataProvider(DataProviderHandler.java:426) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.dashboard.ui.components.HandlerFactoryElement.handle(HandlerFactoryElement.java:140) at org.jboss.dashboard.ui.components.FactoryRequestHandler.handle(FactoryRequestHandler.java:154) at org.jboss.dashboard.ui.components.FactoryRequestHandler.performRequestHandling(FactoryRequestHandler.java:145) at org.jboss.dashboard.ui.components.FactoryRequestHandler.handleRequest(FactoryRequestHandler.java:43) at org.jboss.dashboard.ui.panel.PanelDriver.panelActionFactory(PanelDriver.java:1225) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) Seems that the previous exception is a bug on MySQL driver. When executing the next query the application did not responded: SELECT inet6_ntoa( ip_src ) as sourceIP, inet6_ntoa( ip_dst ) as targetIP, alienvault_siem.acid_event.* FROM alienvault_siem.acid_event WHERE inet6_aton( '0.0.0.0' ) <> inet6_ntoa( ip_src ) we replace it by the same one, without the ", alienvault_siem.acid_event.*" string: SELECT inet6_ntoa( ip_src ) as sourceIP, inet6_ntoa( ip_dst ) as targetIP FROM alienvault_siem.acid_event WHERE inet6_aton( '0.0.0.0' ) <> inet6_ntoa( ip_src ) It works perfectly. On MySQLAdmin both queries work perfectly, so perhaps the MySQL driver must be updated (was using mysql-connector-java-5.1.17.jar). Tomorrow we will try with new 5.1.26 version. A timeout or a better exception handling could be a workaround for JDBC driver exceptions. But this is not connected with the originally posted NPE exception. The NullPointer issue has been fixed. Github commit (master): https://github.com/droolsjbpm/dashboard-builder/commit/6fca21a938d7096c709704d1dc47aac14aeaa695 Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/3db98820ee2c9cad5dedecc60a9dcbe4c1360944 This issue was not completely fixed and two additional commits were needed: Github commit (master): https://github.com/droolsjbpm/dashboard-builder/commit/124856b019eff8ef9d5807102d8e204252b297e9 https://github.com/droolsjbpm/dashboard-builder/commit/144cfd4da6ebfb7526c9d8a83a93e1a2b0131883 Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/571155ca49980de3d922ad68066dbc82a4e41179 https://github.com/droolsjbpm/dashboard-builder/commit/0d2131ea354c013e392b1a4f9fe3ac0b2e3ea4a9 Ok, all 3 commits from engineering are present in BPMS 6.0.0 ER5 build. Since the issue is hard to reproduce (we were not able to reproduce it) no automated tests for the issue will be created. |