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