Error when restarting tomcat6. Bad pool size config

Hi there,

I've got two ODK instances within one tomcat server. They both connect to a
postgresql db server. Today I was facing issues with one of the ODK
instances (form could'nt upload), the restart of the tomcat6 AND postgresql
solved it, but when I restarted tomcat6 at first, I noticed the following
error:

INFO: Executing: refreshReachableGrantedAuthorities
Sep 17, 2015 11:22:49 AM
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource info
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay ->
1000, autoCommitOnClose -> false, automaticTestTable -> c3po_alive,
breakAfterAcquireFailure -> false, checkoutTimeout -> 30000,
connectionCustomizerClassName -> null, connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource
-> caller, dataSourceName -> z8kfsx9b1ono2seqmlue1|3ed7988a,
debugUnreturnedConnectionStackTraces -> false, description -> null,
driverClass -> org.postgresql.Driver, extensions -> {},
factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false,
forceUseNamedDriverClass -> false, identityToken ->
z8kfsx9b1ono2seqmlue1|3ed7988a, idleConnectionTestPeriod -> 148,
initialPoolSize -> 3, jdbcUrl ->
jdbc:postgresql://192.168.2.140/odk_147?autoDeserialize=true,
maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 590,
maxIdleTimeExcessConnections -> 5, maxPoolSize -> 100, maxStatements -> 0,
maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3,
preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties ->
{user=, password=}, propertyCycle -> 0,
statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin ->
true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0,
userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
Sep 17, 2015 11:22:50 AM com.mchange.v2.resourcepool.BasicResourcePool warn
WARNING: Bad pool size config, start 3 < min 5. Using 5 as start.
Sep 17, 2015 11:22:50 AM
org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions

I'm trying to prevent such issues, but not sure if the above error was
related (since it is only WARNING). Any idea?

best
piqo

Piqo,

That warning suggests that things are fine. Make sure you have regular
backups of the data and you should be fine.

Yaw

ยทยทยท -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Sep 17, 2015 at 5:41 AM, piqo piqoni@gmail.com wrote:

Hi there,

I've got two ODK instances within one tomcat server. They both connect to a
postgresql db server. Today I was facing issues with one of the ODK
instances (form could'nt upload), the restart of the tomcat6 AND postgresql
solved it, but when I restarted tomcat6 at first, I noticed the following
error:

INFO: Executing: refreshReachableGrantedAuthorities
Sep 17, 2015 11:22:49 AM
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource info
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [
acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay ->
1000, autoCommitOnClose -> false, automaticTestTable -> c3po_alive,
breakAfterAcquireFailure -> false, checkoutTimeout -> 30000,
connectionCustomizerClassName -> null, connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource
-> caller, dataSourceName -> z8kfsx9b1ono2seqmlue1|3ed7988a,
debugUnreturnedConnectionStackTraces -> false, description -> null,
driverClass -> org.postgresql.Driver, extensions -> {}, factoryClassLocation
-> null, forceIgnoreUnresolvedTransactions -> false,
forceUseNamedDriverClass -> false, identityToken ->
z8kfsx9b1ono2seqmlue1|3ed7988a, idleConnectionTestPeriod -> 148,
initialPoolSize -> 3, jdbcUrl ->
jdbc:postgresql://192.168.2.140/odk_147?autoDeserialize=true,
maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 590,
maxIdleTimeExcessConnections -> 5, maxPoolSize -> 100, maxStatements -> 0,
maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3,
preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties ->
{user=, password=}, propertyCycle -> 0,
statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true,
testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0,
userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
Sep 17, 2015 11:22:50 AM com.mchange.v2.resourcepool.BasicResourcePool warn
WARNING: Bad pool size config, start 3 < min 5. Using 5 as start.
Sep 17, 2015 11:22:50 AM
org.opendatakit.common.security.spring.UserServiceImpl reloadPermissions

I'm trying to prevent such issues, but not sure if the above error was
related (since it is only WARNING). Any idea?

best
piqo

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.