Time
S
Nick
Message
02:01 larsks left #dataverse
11:35 donsizemore joined #dataverse
11:37 donsizemore
@poikilotherm are your ears burning? someone here at UNC is having PG trouble in dataverse-k8s; I told them to come here and find you
11:39 poikilotherm
I have no idea why my ears should be burning about what you guys are doing :-)
11:39 poikilotherm
But feel free to send them here
11:39 poikilotherm
I'll do my best, although I'm at construction site.
11:41 poikilotherm
What did I do that you folks talked about so I need a fire extinguisher for my ears?
11:50 donsizemore
dataverse deploys and they can log in, but when they try to browse, dataverse gets "Connection has been closed" from the PG container
11:50 donsizemore
that's all I have in the e-mail. I asked for more info and recommended you as the master
13:17 pameyer joined #dataverse
13:20 pameyer
@poikilotherm - did you hear about the dockerhub image retention changes?
13:21 poikilotherm
Retention? I heard about the boundary of image layer pulls only so far
13:22 pameyer
https://www.docker.com/pricing/retentionfaq
13:22 pameyer
short version looks to be that "inactive" free images get deleted
13:22 poikilotherm
https://github.com/testcontainers/testcontainers-java/issues/3099
13:24 pameyer
not sure if that'll matter for dataverse-k8s or not
13:25 pameyer
I hadn't picked up on the unauthenticated pull limits :(
13:27 poikilotherm
Well the supported images, which is the latest tag, receive updates every day. Older images will be prone to be deleted. Seems fair. Anyone really using those can rebuild and push to their own registry.
13:28 poikilotherm
Latest tag: I meant the latest got tag, not the docker tag called latest
13:38 pameyer
sounds reasonable
13:43 renci-dataverse- joined #dataverse
13:43 renci-dataverse- left #dataverse
13:44 ismagilani joined #dataverse
13:47 donsizemore
hello ismagilani!
13:49 ismagilani
hi donsizemore! thanks for introducing me to this!
13:52 donsizemore
did you see my note about the JDBC PG driver
13:54 ismagilani
yes I am trying to figure out how to update that in the image
13:54 ismagilani
I could just go in the container and manually copy it and then try it?
13:55 donsizemore
yes, that would be a quick test
13:56 donsizemore
depending on the path it would be something like /usr/local/payara5/glassfish/lib
14:23 ismagilani
found postgresql.jar in /opt/dataverse/appserver/glassfish/lib
14:24 donsizemore
perfect
14:27 pameyer
can the app server jar's get reloaded without stopping the container? (I'm not sure how the entrypoint for those is setup)
14:29 donsizemore
i'm pretty sure you'll have to stop the container
14:30 pameyer
so it might need a container rebuild, rather than a file copy inside a running one
14:30 pameyer
I know solr will pick up a new schema with the right signal, but sure about gf/payara
14:31 donsizemore
i suspect the packaged jdbc pg driver is too old.
14:32 pameyer
that's unfortunately plausible
14:33 donsizemore
i dropped an update into develop but it's two point releases behind already
14:40 poikilotherm
Hey guys
14:41 ismagilani
Hi
14:41 poikilotherm
For my curiosity... What server are you using? The packaged driver is relatively new and I'm using pg server 9.6
14:42 poikilotherm
Oh and what flavor are you using? Payara? glass fish?
14:43 poikilotherm
I haven't looked much into the images lately, to busy with coding
14:43 ismagilani
I installed postgres using a bitnami postgres helm chart with a tag of 11.8.0-debian-10-r61.
14:43 poikilotherm
Ah!
14:43 poikilotherm
That is most likely a problem.
14:43 ismagilani
glassfish
14:43 poikilotherm
Upstream supports Postgres 9.6 only
14:44 ismagilani
ah ok, let me grab that one then
14:44 poikilotherm
So please make sure that your helm chart deploys that version of PostgreSQL
14:44 ismagilani
yes got it
14:44 poikilotherm
I dunno if this is supported by that helm chart
14:45 ismagilani
looking
14:45 poikilotherm
But there should be some operators around for this. Or you just use kustomize. An example can be found in dv-k8s demo persona.
14:45 poikilotherm
Not sure what you're up to... ;-)
14:46 ismagilani
9.6.19-debian-10-r0
14:47 donsizemore
@poikilotherm by "upstream" do you mean Dataverse itself? all testing happens on 10 and it's been known to run in 11 and 12
14:48 poikilotherm
Oh. But that's not official yet, is it?
14:48 ismagilani
I used kustomize for every other install, for postgres I used a helm chart
14:49 donsizemore
what is truly official, anyway? ;)
14:49 donsizemore
@ismagilani sorry for sending you down the wrong path. but I'm eager to see Dataverse move off PG 9.n
14:49 poikilotherm
It's what the docs say :-D
14:49 poikilotherm
And this is 4.19 when you're not building your own
14:50 poikilotherm
Not sure if it was supported back then already. Even unofficially
14:50 poikilotherm
I'm sorry I'm not up to date with releases...
14:51 donsizemore
they required a minimum of 9.6 back in 4.13, 4.14 or so
14:52 ismagilani joined #dataverse
14:54 poikilotherm
ismagilani I hope this fixed it for you. If not, please mention me here, so I will receive a notification. Back to construction work...
14:54 ismagilani
not sure what I did, but I lost all chat history with @donsizemore and @poikilotherm :(
14:54 ismagilani
I will give this a try and update
14:54 ismagilani
thanks
15:28 pameyer
ismagilani: http://irclog.iq.harvard.edu/dataverse/today usually has chat history for this room
17:50 mateolan joined #dataverse
19:41 ismagilani joined #dataverse
19:58 ismagilani
@poikilotherm I am not using the postgresql deployment in dataverse/demo...however it didn't help with the SQL exceptions. My deployment goes smoothly and then something breaks and a slew of SQL exceptions of the sort:
19:59 ismagilani
Call: SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW", "INTERVALDURATION", "LASTEXPIRATIONRAW", "OWNERID", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE ("TIMERID" = ?) bind => [1 parameter bound] Query: ReadObjectQuery(name="readTimerState" referenceClass=TimerState sql ="SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW
20:00 ismagilani
or this:
20:00 ismagilani
Call: SELECT ID, CONTENT, LANG, NAME FROM SETTING WHERE ((NAME = ?) AND (LANG IS NULL)) bind => [1 parameter bound] Query: ReadAllQuery(name="Setting.findByName" referenceClass=Setting sql ="SELECT ID, CONTENT, LANG, NAME FROM SETTING WHERE ((NAME = ?) AND (LANG IS NULL))") at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:378) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryI
20:02 ismagilani
first statement should say " I am NOW using the postgresql deployment in dataverse..."
22:08 Gerrick joined #dataverse
22:09 Gerrick left #dataverse
22:56 mateolan_ joined #dataverse
