"Pushafix" sounds like an Astérix et Obélix character.
2020-11-20 32513, 2020
ruaok
srsly
2020-11-20 32539, 2020
ruaok
zas: tested the fixes with an incremental dump. all is well. should be good to go now.
2020-11-20 32507, 2020
ruaok
pristine___: iliekcomputers : We've fixed the dump issues and generated a full new dump. I've triggered an import into spark just to make sure we have fresh data.
2020-11-20 32544, 2020
ruaok
meh. no more interest to fuck with dump code now. I'll just forget it about it for the time being.
2020-11-20 32510, 2020
iliekcomputers
Isn't that what we all do, forget about dump code? 🙈
2020-11-20 32531, 2020
zas
ruaok: I approved the PR, I don't want to be too picky ;) but you have at least to fix PEP8 before merging
2020-11-20 32544, 2020
ruaok
pretty much. I'm just miffed that it stole a day from me this week.
I'll get back to it late next week when I think I might have time next
2020-11-20 32513, 2020
michaelqm joined the channel
2020-11-20 32541, 2020
michaelqm
I'm having an issue setting up a mirror server on digitalocean. I'm using the docker image, and the import fails when postgres dies at this query:
2020-11-20 32507, 2020
michaelqm
SELECT musicbrainz.recording_alias.recording AS musicbrainz_recording_alias_recording, musicbrainz.recording_alias.type AS musicbrainz_recording_alias_type, musicbrainz.recording_alias.id AS musicbrainz_recording_alias_id, musicbrainz.recording_alias.name AS musicbrainz_recording_alias_name, anon_1.musicbrainz_recording_id
2020-11-20 32508, 2020
michaelqm
AS anon_1_musicbrainz_recording_id FROM (SELECT musicbrainz.recording.id AS musicbrainz_recording_id FROM musicbrainz.recording WHERE musicbrainz.recording.id >= 233449 AND musicbrainz.recording.id < 249336) AS anon_1 JOIN musicbrainz.recording_alias ON anon_1.musicbrainz_recording_id = musicbrainz.recording_alias.recording ORDER BY
2020-11-20 32508, 2020
michaelqm
anon_1.musicbrainz_recording_id
2020-11-20 32527, 2020
michaelqm
Which results in the error:
2020-11-20 32534, 2020
michaelqm
Failed to import recording with id in bounds (149699, 159990)2020-11-20 21:13:32,859: (psycopg2.OperationalError) server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
2020-11-20 32537, 2020
ruaok
how much ram does your VM have?
2020-11-20 32540, 2020
michaelqm
16GB
2020-11-20 32559, 2020
michaelqm
I've increased postgres and SOLR to use 4GB each (over the 2GB initial value)
2020-11-20 32522, 2020
michaelqm
That should be enough, no?
2020-11-20 32538, 2020
ruaok
yes. did you modify the postgres config and restart postgres?
2020-11-20 32513, 2020
michaelqm
Yeah, I created local/compose/memory-settings.yml and then added it to the .env
