java - C3P0 connection pool stall with Heroku Postgres -

-

this relates unsolved post: here c3p0 seems enter deadlock after initializing connection pool on heroku. problem not occur on local postgres.

here's connection configuration hibernate.hbm.xml

 <property name="hibernate.dialect">org.hibernate.dialect.postgresqldialect</property>        <!-- enable hibernate's automatic session context management -->     <property name="current_session_context_class">thread</property>       <property name="hibernate.connection.url">jdbc:postgresql://myurl:5432/mydb?user=myusername&amp;password=myoassword&amp;sslfactory=org.postgresql.ssl.nonvalidatingfactory&amp;ssl=true</property>     <property name="hibernate.connection.driver_class">org.postgresql.driver</property>     <property name="hibernate.connection.username">myusername</property>     <property name="hibernate.connection.password">mypassword</property>     <property name="hibernate.archive.autodetection">class</property>     <property name="hibernate.show_sql">true</property>     <property name="hibernate.format_sql">true</property>     <property name="hbm2ddl.auto">create</property>      <!-- c3p0 connection pool settings -->     <property name="hibernate.connection.provider_class">org.hibernate.service.jdbc.connections.internal.c3p0connectionprovider</property>     <property name="hibernate.c3p0.min_size">1</property>     <property name="hibernate.c3p0.max_size">2</property>     <property name="hibernate.c3p0.timeout">1800</property>

here's log. note hang 1 minute 10 second cycles of "running deadlockdetector." note invocation exception follows:

[debug] "com.mchange.v2.c3p0.impl.c3p0pooledconnectionpoolmanager" 2015-07-05 07:12:57,851: created new pool auth, username (masked): 'sp******'.

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:57,851: acquire test -- pool size: 0; target_pool_size: 1; desired target? 1

...deleted lines sake of parsimony

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:59,132: acquisition series terminated successfully. decremented pending_acquires 1, attempts_remaining: 30

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:59,132: trace com.mchange.v2.resourcepool.basicresourcepool@6293abcc [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.newpooledconnection@576ddf03)

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:59,132: decremented pending_acquires: 0

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:59,132: acquisition series terminated successfully. decremented pending_acquires [0], attempts_remaining: 30

[debug] "com.mchange.v2.resourcepool.basicresourcepool" 2015-07-05 07:12:59,132: trace com.mchange.v2.resourcepool.basicresourcepool@6293abcc [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.newpooledconnection@576ddf03)

[debug] "com.mchange.v2.async.threadpoolasynchronousrunner" 2015-07-05 07:13:07,841: com.mchange.v2.async.threadpoolasynchronousrunner$deadlockdetector@45912fb9 -- running deadlockdetector[exiting. no pending tasks.]

...repeats every ten seconds

[debug] "com.mchange.v2.async.threadpoolasynchronousrunner" 2015-07-05 07:13:47,859: com.mchange.v2.async.threadpoolasynchronousrunner$deadlockdetector@45912fb9 -- running deadlockdetector[exiting. no pending tasks.]

[info] "org.hibernate.dialect.dialect" 2015-07-05 07:13:55,467: hhh000400: using dialect: org.hibernate.dialect.postgresqldialect

[info] "org.hibernate.engine.jdbc.internal.lobcreatorbuilder" 2015-07-05 07:13:55,472: hhh000424: disabling contextual lob creation createclob() method threw error : java.lang.reflect.invocationtargetexception

[debug] "com.mchange.v2.async.threadpoolasynchronousrunner" 2015-07-05 07:13:55,576: com.mchange.v2.async.threadpoolasynchronousrunner@6a01e23: adding task queue -- com.mchange.v2.resourcepool.basicresourcepool$1refurbishcheckinresourcetask@55b699ef

the answer is, in fact, posted , explained here:

i added following hibernate.hbm.xml

<property name="temp.use_jdbc_metadata_defaults">false</property>


Comments

Post a Comment

Popular posts from this blog

c# - Better 64-bit byte array hash -

-
i need hash algorithm produces 64-bit hash code ( long ) fewer collisions string.gethashcode() , fast (no expensive calls cryptographic functions). here's implementation of fnv still shows 3% of collisions after testing 2 million random strings. need number way lower. void main() { const string chars = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz!#@$%^&*()_+}{\":?><,./;'[]0123456789\\"; const int n = 2000000; var random = new random(); var hashes = new hashset<long>(); int collisions = 0; for(int = 0; < n; i++) { var len = random.next(chars.length); var str = new char[len]; (int j = 0; j < len; j++) { str[j] = chars[random.next(chars.length)]; } var s = new string(str); if(!hashes.add(get64bithash( s ))) collisions++; } console.writeline("collision percentage after " + n + " random strings: " + ((doubl
Read more

webrtc - Which ICE candidate am I using and why? -

-
[questions in bold below] i have setup kurento media server 5.1.3 in datacenter behind firewall running os ubuntu 14.04. has 2 network cards: 222.222.222.222 (eth0 - private ip) 111.111.111.111 (eth1 - public ip) attached below sdp (setremotedescription) when browser connected kurento media server type: answer, sdp: v=0 o=- 5487318114793304426 0 in ip4 0.0.0.0 s=kurento media server c=in ip4 0.0.0.0 t=0 0 a=group:bundle audio video m=audio 59068 rtp/savpf 111 0 c=in ip4 111.111.111.111 a=rtpmap:111 opus/48000/2 a=rtpmap:0 pcmu/8000 a=sendrecv a=rtcp:59068 in ip4 111.111.111.111 a=rtcp-mux a=ssrc:669011897 cname:user39019747@host-6e83e4c2 a=extmap:3 http://www.webrtc.org/experiments/rtp-hdrext/abs-send-time a=mid:audio b=as:20 a=ice-ufrag:ymdk a=ice-pwd:lylifk5ueqzpwm91ddj37e a=fingerprint:sha-256 ff:0f:81:8c:41:4e:b4:b6:c6:d8:36:f3:d6:5f:09:fd:5f:af:13:b3:9d:fc:12:66:ac:f3:56:d6:5b:0a:73:5d a=candidate:1 1 udp 2013266431 111.111.111.111 55239 typ host a=candidate:2 1 udp
Read more

php - Zend Framework / Skeleton-Application / Composer install issue -

-
i trying create zend framework application using skeleton in netbeans. when run composer install, following error message: "c:\php\php.exe" "c:\composer\composer.phar" "--ansi" "--no-interaction" "update" "--dev" using deprecated option "dev". dev packages installed default now. loading composer repositories package information updating dependencies (including require-dev) requirements not resolved installable set of packages. problem 1 - package requires php >=5.5 php version (5.4.42) not satisfy requirement. problem 2 - installation request zendframework/zendframework 2.5.1 -> satisfiable zendframework/zendframework[2.5.1]. - zendframework/zendframework 2.5.1 requires php >=5.5 -> php version (5.4.42) not satisfy requirement. done. apparently, zend framework only needs php 5.3+ contradicts above. need use php 5.4. my composer.json following: { "name": "
Read more