06-04-2020 12:08 AM - edited 07-09-2021 04:37 PM
jdbc:postgresql://localhost:5432/std_xforms?currentSchema=std_xforms
[global] semanta.xf3.db.jdbc=jdbc:postgresql://localhost:5432/std_xforms?currentSchema=std_xforms semanta.xf3.db.user=std_xforms semanta.xf3.db.schema=std_xforms semanta.xf3.db.password=Conn3ct!! enable.configuration=true display.use.button=true
CREATE ROLE std_xforms WITH LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT NOREPLICATION CONNECTION LIMIT -1 PASSWORD 'Conn3ct!!'; COMMENT ON ROLE std_xforms IS 'Connect db user';
CREATE DATABASE std_xforms WITH OWNER = std_xforms ENCODING = 'UTF8' CONNECTION LIMIT = -1; COMMENT ON DATABASE std_xforms IS 'Connect database';
CREATE SCHEMA std_xforms AUTHORIZATION std_xforms;
13:36:43.756 [C3P0PooledConnectionPoolManager[identityToken->1hgekyma9c1iyyvy58u2w|7ff863f0]-HelperThread-#14] WARN c.m.v.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@71621d64 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:524) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:145) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:196) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:211) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.Driver.makeConnection(Driver.java:459) ~[postgresql-42.2.10.jar:42.2.10] at org.postgresql.Driver.connect(Driver.java:261) ~[postgresql-42.2.10.jar:42.2.10] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) ~[mchange-commons-java-0.2.11.jar:0.2.11] 13:36:43.757 [C3P0PooledConnectionPoolManager[identityToken->1hgekyma9c1iyyvy58u2w|7ff863f0]-HelperThread-#14] WARN c.m.v.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@33244563 is interrupting al
Hi @KaterinaR ,
Is this going to be a required conversion at some point for customers who are using H2 currently? Also if we are looking to use Postgres instead of H2 is there conversion procedures you have available?
Thank you for your help.
Hi @andrewdatakim ,