gvSIG bugs #2160

gvSIG freezes creating the fifth DB table document

Added by Jose Manuel Vivó Arnal over 10 years ago. Updated over 10 years ago.

Status:Closed% Done:

0%

Priority:UrgentSpent 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:2215 Add-on resolve version:
Operative System:Linux Add-on resolve build:
Keywords: Proyecto:
Has patch:No Hito:
Add-on name:Unknown

Description

I've tried to add 5 table document from a Postgres source gvSIG freezes. After a while, console shows this message:

Caused by: org.gvsig.fmap.dal.resource.exception.AccessResourceException: Error while atemp to access resource 'PostgreSQLResource(jdbc:postgresql://localhost:5432/reconecdb,reconec)'.
    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.JDBCHelper$3.run(JDBCHelper.java:248)
    at org.gvsig.fmap.dal.resource.spi.AbstractResource.performExecution(AbstractResource.java:316)
    at org.gvsig.fmap.dal.resource.spi.AbstractNonBlockingResource.execute(AbstractNonBlockingResource.java:57)
    ... 72 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)
    ... 77 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)
    ... 78 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)
    ... 80 more

I think that this problem is caused due a missing dispose-call of a DB resource

gvSIG.log.tar.gz (35.2 KB) Jose Manuel Vivó Arnal, 12/19/2013 04:57 PM

History

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

  • Assignee set to Juan Lucas Domínguez

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

  • Status changed from New to Fixed

Closing connection after short use and improving GUI events management.

gvsig-desktop:r40999

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

  • Target version set to 2.1.0-2217-devel

#4 Updated by Álvaro Anguix over 10 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF