gvSIG bugs #2186

Colgado tras realizar info by point en capa postGIS

Added by José Vicente Higón over 10 years ago. Updated over 10 years ago.

Status:Closed% Done:

0%

Priority:NormalSpent time:-
Assignee:Juan Lucas Domínguez
Category:Database
Target version:2.1.0-2217-devel
Severity: Add-on version:
gvSIG version:2.1.0 Add-on build:
gvSIG build:2216 Add-on resolve version:
Operative System:Linux Add-on resolve build:
Keywords: Proyecto:
Has patch:No Hito:
Add-on name:Unknown

Description

Al hacer varias consultas con la herramienta "info by point" en una capa Postgis gvSIG se queda colgado y aparece la siguiente excepción:

ERROR [AWT-EventQueue-1] (NotificationManager.java:90) - Info by Point
Error while executing an action in resource 'org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource@124f5b7'.
    at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:59)
    at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createResultSet(JDBCStoreProvider.java:255)
    at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createResultSet(JDBCStoreProvider.java:246)
    at org.gvsig.fmap.dal.store.jdbc.JDBCSetProvider.createFastIterator(JDBCSetProvider.java:352)
    at org.gvsig.fmap.dal.store.jdbc.JDBCSetProvider.createFastIterator(JDBCSetProvider.java:51)
    at org.gvsig.fmap.dal.feature.spi.AbstractFeatureSetProvider.fastIterator(AbstractFeatureSetProvider.java:98)
    at org.gvsig.fmap.dal.feature.spi.AbstractFeatureSetProvider.fastIterator(AbstractFeatureSetProvider.java:93)
    at org.gvsig.fmap.dal.feature.impl.featureset.FastDefaultIterator.<init>(FastDefaultIterator.java:52)
    at org.gvsig.fmap.dal.feature.impl.featureset.DefaultFeatureSet.fastIterator(DefaultFeatureSet.java:364)
    at org.gvsig.fmap.dal.feature.impl.featureset.DefaultFeatureSet.fastIterator(DefaultFeatureSet.java:352)
    at org.gvsig.fmap.dal.feature.impl.featureset.DynObjectSetFeatureSetFacade.iterator(DynObjectSetFeatureSetFacade.java:142)
    at org.gvsig.fmap.mapcontrol.swing.dynobject.impl.DefaultLayersDynObjectSetComponent.createTreeModel(DefaultLayersDynObjectSetComponent.java:163)
    at org.gvsig.fmap.mapcontrol.swing.dynobject.impl.DefaultLayersDynObjectSetComponent.addLayerTree(DefaultLayersDynObjectSetComponent.java:126)
    at org.gvsig.fmap.mapcontrol.swing.dynobject.impl.DefaultLayersDynObjectSetComponent.initializeUI(DefaultLayersDynObjectSetComponent.java:115)
    at org.gvsig.fmap.mapcontrol.swing.dynobject.impl.DefaultLayersDynObjectSetComponent.<init>(DefaultLayersDynObjectSetComponent.java:111)
    at org.gvsig.fmap.mapcontrol.impl.DefaultMapControlManager.createLayersDynObjectSetComponent(DefaultMapControlManager.java:340)
    at org.gvsig.app.project.documents.view.toolListeners.InfoListener$DefaultInfoByPointRenderer.getPanel(InfoListener.java:205)
    at org.gvsig.app.project.documents.view.toolListeners.InfoListener.point(InfoListener.java:145)
    at org.gvsig.fmap.mapcontrol.tools.Behavior.PointBehavior.mouseReleased(PointBehavior.java:83)
    at org.gvsig.fmap.mapcontrol.tools.CompoundBehavior.mouseReleased(CompoundBehavior.java:290)
    at org.gvsig.fmap.mapcontrol.MapControl$MapToolListener.mouseReleased(MapControl.java:1736)
    at java.awt.Component.processMouseEvent(Component.java:6389)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3268)
    at java.awt.Component.processEvent(Component.java:6154)
    at java.awt.Container.processEvent(Container.java:2045)
    at java.awt.Component.dispatchEventImpl(Component.java:4750)
    at java.awt.Container.dispatchEventImpl(Container.java:2103)
    at java.awt.Component.dispatchEvent(Component.java:4576)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4633)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4297)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4227)
    at java.awt.Container.dispatchEventImpl(Container.java:2089)
    at java.awt.Window.dispatchEventImpl(Window.java:2518)
    at java.awt.Component.dispatchEvent(Component.java:4576)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:672)
    at java.awt.EventQueue.access$400(EventQueue.java:96)
    at java.awt.EventQueue$2.run(EventQueue.java:631)
    at java.awt.EventQueue$2.run(EventQueue.java:629)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:116)
    at java.awt.EventQueue$3.run(EventQueue.java:645)
    at java.awt.EventQueue$3.run(EventQueue.java:643)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:642)
    at org.gvsig.andami.ui.AndamiEventQueue.dispatchEvent(AndamiEventQueue.java:50)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
Caused by: Error while executing an action in resource 'org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource@124f5b7'.
    at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:59)
    at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider.createNewResultSet(JDBCStoreProvider.java:610)
    at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider$2.run(JDBCStoreProvider.java:257)
    at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:316)
    at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57)
    ... 52 more
Caused by: org.gvsig.fmap.dal.resource.exception.AccessResourceException: Error while atemp to access resource 'PostgreSQLResource(jdbc:postgresql://10.172.253.237:5432/bdeas_pdvsa,mapserver)'.
    at org.gvsig.fmap.dal.resource.db.AbstractDBResourceNoBlocker.get(AbstractDBResourceNoBlocker.java:76)
    at org.gvsig.fmap.dal.store.jdbc.JDBCResource.getJDBCConnection(JDBCResource.java:99)
    at org.gvsig.fmap.dal.store.jdbc.JDBCHelper.getConnection(JDBCHelper.java:212)
    at org.gvsig.fmap.dal.store.jdbc.JDBCStoreProvider$8.run(JDBCStoreProvider.java:617)
    at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:316)
    at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57)
    ... 56 more
Caused by: org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException: An JDBC driver exception was throw
    at org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource.getTheConnection(PostgreSQLResource.java:190)
    at org.gvsig.fmap.dal.resource.db.AbstractDBResourceNoBlocker.get(AbstractDBResourceNoBlocker.java:74)
    ... 61 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at org.gvsig.fmap.dal.store.postgresql.PostgreSQLResource.getTheConnection(PostgreSQLResource.java:186)
    ... 62 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
    at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1174)
    at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    ... 64 more

History

#1 Updated by Juan Lucas Domínguez over 10 years ago

  • Status changed from New to Fixed
  • Assignee set to Juan Lucas Domínguez

Disposing iterator to prevent leaving resultset and connection opened.

gvsig-tools:r988

#2 Updated by Joaquín del Cerro Murciano over 10 years ago

  • Target version set to 2.1.0-2217-devel

#3 Updated by Álvaro Anguix over 10 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF