- How can I increase the Java heap space / memory for Bahmni ?
- Is the database pooling already configured ? Where do I check this ?
Also, I just stop and start the application using bahmni -i local stop then bahmni -i local start. However after the application is up, I tried to navigate in Bahmni to the clinical module and then the application become unresponsive.
This is the log
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2ebda417
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7542e948
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#2
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1f59c802
on thread: C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#1
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@d4cdbfa
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4e925b58
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@2c78f36b
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7db0273e
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@1648b079
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4adc6173
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@215430e8
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@5d217a2b
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@eb9c28e
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2747edd3
com.mchange.v2.resourcepool.BasicResourcePool$1RefurbishCheckinResourceTask@27944aa3
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@71329c58
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@315f8d42
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@296ec7cf
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#2,5,main]
com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:425)
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3245)
com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2413)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2836)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1651)
com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:751)
com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:4474)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2943)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764)
com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5588)
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3563)
com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2358)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#0,5,main]
com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:425)
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3245)
com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2413)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2836)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1651)
com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:751)
com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:4474)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2943)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764)
com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5588)
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3563)
com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2358)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->z8kflt9p3jqhvj2p59yn|671173bd]-HelperThread-#1,5,main]
com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:425)
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3245)
com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2413)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2836)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1651)
com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:751)
com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:4474)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2943)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842)
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764)
com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5588)
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3563)
com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2358)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2316)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
WARN - CommonsLoggingOutput.warn(67) |2017-07-05 17:27:35,434| Method execution failed:
java.lang.OutOfMemoryError: Java heap space
WARN - CommonsLoggingOutput.warn(59) |2017-07-05 17:27:40,562| --Erroring: batchId[3] message[java.lang.OutOfMemoryError: Java heap space]