did you restart postgresql after modifying pg_hba.conf, and did you actually set the password for the musicbrainz user to 'musicbrainz'? by default the password is empty, so if you didn't explicitly set it, probably not
2017-12-18 35252, 2017
naiveai
bitmap: did both of those things
2017-12-18 35200, 2017
bitmap
er sorry, user postgres. you set the password to 'admin'?
2017-12-18 35237, 2017
naiveai
yes
2017-12-18 35248, 2017
naiveai
using \password
2017-12-18 35200, 2017
naiveai
figured it's just a devserver, so....
2017-12-18 35210, 2017
naiveai
ok now it somehow works
2017-12-18 35221, 2017
naiveai
I exited the VM
2017-12-18 35224, 2017
naiveai
and halted
2017-12-18 35242, 2017
naiveai
and then restarted, and then tried again. and it worked. so ._.
2017-12-18 35248, 2017
naiveai
sorry bout that.
2017-12-18 35214, 2017
bitmap
np, maybe wasn't picking up the pg_hba.conf changes
2017-12-18 35232, 2017
naiveai
Well I did do a "sudo -u postgres pg_ctlcluster 9.6 main restart"
2017-12-18 35247, 2017
naiveai
maybe an explicit start/stop would've worked better, idk
2017-12-18 35251, 2017
naiveai
either way, heisenbug
2017-12-18 35259, 2017
naiveai
thanks a lot!
2017-12-18 35239, 2017
naiveai has left the channel
2017-12-18 35201, 2017
gcilou joined the channel
2017-12-18 35258, 2017
github joined the channel
2017-12-18 35258, 2017
github
[sir] samj1912 closed pull request #65: Use batched multiprocessing for live indexing in the handler (master...multiproc) https://git.io/vbV6T
2017-12-18 35258, 2017
github has left the channel
2017-12-18 35210, 2017
samj1912
finally \o/
2017-12-18 35204, 2017
KassOtsimine
hey GCI peeps, cna i get link t othe GCI hangout?
2017-12-18 35250, 2017
reosarevok
KassOtsimine: it should just show from your appropriate Gmail account (or is there a separate Hangouts site I can link to? I have no clue)
but I think we need to continue -- editing peaks and other "anomalies" are going to accasionally push mountains of edits (or yield mountains of updates) into sir.
2017-12-18 35220, 2017
ruaok
and it needs to be able to handle it.
2017-12-18 35247, 2017
samj1912
yeah, we should stress test it
2017-12-18 35202, 2017
samj1912
but I think if we have sir running on 2 nodes it can keep up pretty well
I need to get access to that console, so I can spy on the LB queues.
2017-12-18 35215, 2017
creature has quit
2017-12-18 35215, 2017
creature_ is now known as creature
2017-12-18 35216, 2017
creature has quit
2017-12-18 35216, 2017
creature joined the channel
2017-12-18 35216, 2017
samj1912
rmq?
2017-12-18 35221, 2017
ruaok
y
2017-12-18 35254, 2017
samj1912
you can enable the management plugin and then forward the port via ssh
2017-12-18 35240, 2017
samj1912
I think the new triggers really helped
2017-12-18 35206, 2017
samj1912
we are getting very conservative changes as compared to before( no more VA reindexes due to ref_count :P)
2017-12-18 35235, 2017
ruaok
here is something that might be worthwhile to check and should not be too much effort.
2017-12-18 35252, 2017
ruaok
get a data dump that is older, maybe a month old.
2017-12-18 35209, 2017
ruaok
setup everything up at glcoud or wherever.
2017-12-18 35238, 2017
ruaok
then replay all of the replication packets and see how many hours it takes to process 30 days of data.
2017-12-18 35209, 2017
samj1912
hmm, okay
2017-12-18 35211, 2017
ruaok
applying replication packets isn't very fast either.
2017-12-18 35222, 2017
samj1912
I will prolly need zas and bitmap to help me with the slave setup
2017-12-18 35232, 2017
ruaok
just load a VM.
2017-12-18 35240, 2017
ruaok
and point sir to it.
2017-12-18 35233, 2017
Leftmost
LordSputnik, what would you say to replacing the test.bb.o instance with the docker image so that we can iron out any potential issues with the image and config process?
2017-12-18 35226, 2017
creature_ joined the channel
2017-12-18 35216, 2017
creature has quit
2017-12-18 35216, 2017
creature_ is now known as creature
2017-12-18 35216, 2017
creature has quit
2017-12-18 35216, 2017
creature joined the channel
2017-12-18 35201, 2017
alastairp
reosarevok: I mean, it's not like super low inflation in the rest of europe is necessarily a spectacular thing either :)
2017-12-18 35247, 2017
reosarevok
alastairp: sure, but with my wage being stable, I know which one I'd pick :p
2017-12-18 35217, 2017
alastairp
I mean, your landlord is going to put your rent up each year anyway
2017-12-18 35232, 2017
alastairp
and the restaurant down the road is going to put up their prices
2017-12-18 35238, 2017
reosarevok
Oh, no, they don't - this isn't Barcelona :p
2017-12-18 35256, 2017
alastairp
hah
2017-12-18 35257, 2017
reosarevok
I haven't stayed in the same place for long, admittedly, but I'm yet to have someone put my rent up
2017-12-18 35205, 2017
reosarevok
Food prices do go up though
2017-12-18 35227, 2017
reosarevok
But yeah, rent in BCN is not inflation, it's airbnb :p
