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.

All times shown according to UTC.

Time	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.dataverse.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

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.