Обсуждение: Cannot open connection while insert much data.

Поиск
Список
Период
Сортировка

Cannot open connection while insert much data.

От
BozhkoKA
Дата:
My application is using JBOSS 5.1.0.GA, hibernate for connection to
PostgreSQL 9.0 database. Application inserts into database rows regularly.
But when it attempts insert row with 11Mb (11511828 bytes) size body (into
text-datatype column), the following error appiared:

19:02:54,989 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
19:02:54,989 ERROR [JDBCExceptionReporter] Transaction is not active:
tx=TransactionImple < ac, BasicAction: -3f57a87f:ed11:4d933f5e:99 status:
ActionStatus.
ABORTED >; - nested throwable: (javax.resource.ResourceException:
Transaction is not active: tx=TransactionImple < ac, BasicAction:
-3f57a87f:ed11:4d933f5e:9
9 status: ActionStatus.ABORTED >)
19:02:55,142 ERROR [TxPolicy] javax.ejb.EJBTransactionRolledbackException:
Cannot open connection
19:02:55,142 ERROR [ServiceBean]
javax.ejb.EJBTransactionRolledbackException: Cannot open connection
19:02:55,223 INFO  [DBFacade] *** EntityManager.getFlushMode() = AUTO
19:02:55,225 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
19:02:55,225 ERROR [JDBCExceptionReporter] Transaction is not active:
tx=TransactionImple < ac, BasicAction: -3f57a87f:ed11:4d933f5e:99 status:
ActionStatus.
ABORTED >; - nested throwable: (javax.resource.ResourceException:
Transaction is not active: tx=TransactionImple < ac, BasicAction:
-3f57a87f:ed11:4d933f5e:9
9 status: ActionStatus.ABORTED >)
19:02:55,226 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
        at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
        at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
        at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
        at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
        at org.hibernate.loader.Loader.doQuery(Loader.java:696)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
.............

Database some parameters are:

effective_cache_size = 512MB
work_mem = 64MB
shared_buffers = 256MB
max_prepared_transactions = 200


Can anybody help me?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Cannot-open-connection-while-insert-much-data-tp4272825p4272825.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Re: Cannot open connection while insert much data.

От
Oliver Jowett
Дата:
On 31 March 2011 19:56, BozhkoKA <BozhkoKA@tower.ru> wrote:
> My application is using JBOSS 5.1.0.GA, hibernate for connection to
> PostgreSQL 9.0 database. Application inserts into database rows regularly.
> But when it attempts insert row with 11Mb (11511828 bytes) size body (into
> text-datatype column), the following error appiared:

Hard to help you here as none of the logging you provided actually
comes from the JDBC driver. If you can convince JBoss to report an
actual driver exception, we can look at that.

Oliver