IQSS logo

IRC log for #dataverse, 2015-10-12

Connect via chat.dataverse.org to discuss Dataverse (dataverse.org, an open source web application for sharing, citing, analyzing, and preserving research data) with users and developers.

| Channels | #dataverse index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary

All times shown according to UTC.

Time S Nick Message
08:25 bencomp joined #dataverse
14:39 bencomp https://github.com/IQSS/dataverse/issues/2633 is an amazing bug report
16:46 bencomp pdurbin: is reuse of DB connections enabled in Glassfish?
17:01 axfelix joined #dataverse
17:16 cnk joined #dataverse
17:46 metamattj joined #dataverse
18:26 axfelix joined #dataverse
19:36 bencomp joined #dataverse
20:59 pdurbin bencomp: uh. I assume they are reused
20:59 pdurbin and yeah, that issue is hard to believe
21:02 bencomp pdurbin: I noticed in our acceptance environment that a refresh of the homepage with ~5 dataverses caused 700-1000 db connections to be used (without reuse)
21:06 pdurbin bencomp: are you getting that number from the postgres side?
21:07 bencomp Glassfish monitoring
21:08 pdurbin bencomp: is there an `asadmin` command for it?
21:08 bencomp pdurbin: I read some pages linked from https://github.com/IQSS/dataverse/issues/2595
21:08 bencomp eh, I didn't check
21:09 bencomp probably. I found the number under monitoring > resources > dvndbpool (or so)
21:09 bencomp in the web UI
21:12 pdurbin bencomp: ah ok. yeah, it's probably in that output somewhere. I'm going to set up periodic polling of some of those metrics on a test server
21:15 bencomp pdurbin: the output you posted shows 1000s of connections created and destroyed
21:17 pdurbin I see this: server.resources.dvnDbPool.numconncreated-count = 22
21:20 cnk left #dataverse
21:21 bencomp pdurbin: that's 22 over the minimum of 8; without connection reuse you should look at server.resources.dvnDbPool.da‚Äčtaverse.numconnacquired-count = 6216
21:22 bencomp if I understand connection pooling correctly :)
21:22 pdurbin bencomp: sounds like you've studied it more than I have, which is not at all :)
21:23 pdurbin I do know that if I try to delete my database with the app running postgres will stop me saying that 8 connections are in use by glassfish.
21:42 axfelix joined #dataverse
22:03 garnett joined #dataverse
22:23 LyndsySimon joined #dataverse
22:31 garnett joined #dataverse
22:32 garnett joined #dataverse
22:36 metamattj joined #dataverse
23:34 garnett joined #dataverse

| Channels | #dataverse index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary

Connect via chat.dataverse.org to discuss Dataverse (dataverse.org, an open source web application for sharing, citing, analyzing, and preserving research data) with users and developers.