LordSputnik, whoops. That may be an artifact of my local database. I'll fix that.
2016-04-07 09850, 2016
Leftmost
By introducing sets, I'm fixing the long-term problem we'll have with those properties, the ugly hacks we're using to fetch data out of them currently, and the uglier hacks we're using to set them.
2016-04-07 09815, 2016
Leftmost
It's more work, but it's work we'd have to do eventually anyhow and putting it off serves no purpose.
2016-04-07 09827, 2016
chrisskye
ruaok: I need to coordinate with the seller of the purple sofa... How do you want to arrange it?
2016-04-07 09857, 2016
ruaok
this is for the 10th?
2016-04-07 09847, 2016
ruaok
I was thinking we should make a lower offer on the fancy table you found, but the price went from 400 -> 435.
2016-04-07 09852, 2016
ruaok
this doesn
2016-04-07 09806, 2016
ruaok
doesnt seem second hand. seems like someone making them is selling them.
2016-04-07 09842, 2016
Lotheric joined the channel
2016-04-07 09852, 2016
ariZon_a has quit
2016-04-07 09841, 2016
diana_olhovyk_ has quit
2016-04-07 09846, 2016
ariZon_a joined the channel
2016-04-07 09851, 2016
LordSputnik
Leftmost: could you do the set work in branches so I can do the short term fixes in the meantime?
2016-04-07 09812, 2016
LordSputnik
Also, any opposition to merging direct-db into master?
2016-04-07 09848, 2016
jesus2099 has quit
2016-04-07 09834, 2016
Leftmost
Yes and no, respectively.
2016-04-07 09854, 2016
JesseW joined the channel
2016-04-07 09837, 2016
Quora has quit
2016-04-07 09838, 2016
regagain joined the channel
2016-04-07 09821, 2016
yeeeargh joined the channel
2016-04-07 09824, 2016
fqtw_ is now known as fqtw
2016-04-07 09837, 2016
JesseW has quit
2016-04-07 09822, 2016
clee joined the channel
2016-04-07 09840, 2016
chirlu
Hi clee. We were wondering which project you referred to earlier regarding the installation instructions: MusicBrainz server, Picard, AcousticBrainz, …?
2016-04-07 09805, 2016
clee
chirlu: the MusicBrainz server!
2016-04-07 09812, 2016
clee
although I have an issue now that it's all set up and running
2016-04-07 09817, 2016
chirlu
Ah, good to know. :)
2016-04-07 09822, 2016
chirlu
What’s the issue?
2016-04-07 09823, 2016
clee
some of the pages load perfectly for me, but the release page is throwing this error
2016-04-07 09836, 2016
clee
DBD::Pg::st execute failed: ERROR: relation "cover_art_archive.index_listing" does not exist
2016-04-07 09818, 2016
clee
I imported the latest mbdump-derived, mbdump-editor, and mbdump
2016-04-07 09834, 2016
clee
(after realizing that importing just mbdump wasn't good enough, because I did not read said excellent instructions carefully enough)
2016-04-07 09845, 2016
chirlu
Hm, the view should have been created from caa/CreateViews.sql, which in turn InitDb.pl should have run.
2016-04-07 09828, 2016
clee
does InitDb keep a log on-disk?
2016-04-07 09837, 2016
chirlu
I don’t think so.
2016-04-07 09839, 2016
clee
I'm pretty sure it completed without any errors... but it was like 2AM
2016-04-07 09845, 2016
clee shrugs
2016-04-07 09849, 2016
clee
I'll just wipe the db and reimport
2016-04-07 09801, 2016
clee
then I can post the log here if this is the right place to ask for help
2016-04-07 09808, 2016
clee
otherwise I can head off to #musicbrainz or wherever
2016-04-07 09810, 2016
chirlu
If that’s the only part that is missing, you could try running that single script only.
2016-04-07 09828, 2016
chirlu
No, this channel is right for development and server issues.
2016-04-07 09849, 2016
clee
awesome.
2016-04-07 09847, 2016
clee
hmmm
2016-04-07 09850, 2016
chirlu
You could run admin/psql then from its prompt run the script via “\i admin/sql/caa/CreateView.sql”.
2016-04-07 09855, 2016
clee
'\dv' in psql shows no views at all
2016-04-07 09804, 2016
chirlu
Strange.
2016-04-07 09818, 2016
clee
I used './admin/InitDb.pl --createdb --import mbdump*'
2016-04-07 09822, 2016
clee
when I did the import
2016-04-07 09849, 2016
chirlu
Yes, that _should_ have done it.
2016-04-07 09814, 2016
clee
'\i admin/sql/caa/CreateView.sql' seems to have created the view, though!
2016-04-07 09835, 2016
clee
now it's a new error.
2016-04-07 09836, 2016
clee
DBD::Pg::st execute failed: ERROR: relation "release_event" does not exist
2016-04-07 09806, 2016
chirlu
Yeah, that’s another view from admin/sql/CreateViews.sql
The error is a bit strange. Is it possible that you had two InitDb instances running at the same time?
2016-04-07 09812, 2016
clee
but I think I pasted the relevant part
2016-04-07 09816, 2016
clee
I don't think so?
2016-04-07 09833, 2016
diana_olhovyk joined the channel
2016-04-07 09810, 2016
chirlu
Really strange.
2016-04-07 09851, 2016
chirlu
You can now either run the other scripts that were left out or start over (drop DB, rerun InitDb.pl).
2016-04-07 09803, 2016
chirlu
The latter is safer, the former faster. ;-)
2016-04-07 09811, 2016
chirlu
The missing scripts are CreateConstraints.sql, SetSequences.sql, statistics/SetSequences,sql, CreateTriggers.sql, caa/CreateTriggers.sql, and CreateSearchIndexes.sql
2016-04-07 09852, 2016
chirlu
The last thing InitDb would have done is running “VACUUM ANALYZE”.
2016-04-07 09812, 2016
diana_olhovyk has quit
2016-04-07 09802, 2016
clee
... you know what I bet caused the issue?
2016-04-07 09812, 2016
clee
I think I may have run plackup -Ilib before the InitDb was finished
2016-04-07 09835, 2016
clee
(like I said, it was 2AM and I wasn't thinking clearly) :)
2016-04-07 09811, 2016
clee
how is 43:56.54 for DbImport time? is it supposed to be faster?
2016-04-07 09838, 2016
chirlu
No, import is relatively slow.
2016-04-07 09848, 2016
chirlu
In particular the final vacuuming …
2016-04-07 09844, 2016
chirlu
Though in your case, the deadlock alone took nine minutes apparently.
2016-04-07 09827, 2016
maShisma joined the channel
2016-04-07 09827, 2016
ariZon_a has quit
2016-04-07 09825, 2016
ariZon_a joined the channel
2016-04-07 09848, 2016
maShisma has quit
2016-04-07 09806, 2016
reosarevok
"This summit will take a C-suite approach to tackling your marketing challenges, focusing on key areas of business culture, brand relevance, cross-company collaboration & brand experience"
clee: Like chirlu said, this is indeed the right channel for both your previous comment and for discussing the issue you had, it's just that the channel is also host to a bunch of other projects: https://metabrainz.org/projects - so without specifying which, it can be hard to know which project you're commenting on. :)
2016-04-07 09824, 2016
clee
Freso: /me nods
2016-04-07 09825, 2016
clee
er.
2016-04-07 09826, 2016
clee nods
2016-04-07 09827, 2016
bitmap
and if you change the name to just 'Sergei', ko.bindingHandlers.artistCreditEditor.initialArtistText should be Sergei
2016-04-07 09828, 2016
clee
:)
2016-04-07 09845, 2016
maShisma joined the channel
2016-04-07 09845, 2016
bitmap
er, no
2016-04-07 09855, 2016
clee
Freso: yeah, I didn't initially see that I was redirected... I had attempted to join #musicbrainz-devel, so I figured it was musicbrainz-specific and not for all the other related projects
2016-04-07 09859, 2016
bitmap
it should stay 'Sergei Prokofiev'
2016-04-07 09804, 2016
Freso
reosarevok: Wait, are you quoting the MB Summit 16 notes? D:
2016-04-07 09811, 2016
clee
something went wrong while I was trying to manually import each of the extra SQL files, btw
2016-04-07 09814, 2016
reosarevok
bitmap: does that
2016-04-07 09819, 2016
clee
so I dropped the db and now am re-running InitDb.pl
2016-04-07 09837, 2016
clee
and this time I think I'll wait until it's really done before I run plackup
2016-04-07 09852, 2016
Freso
clee: Oh? Where did you see a reference to #musicbrainz-devel?
the main reason I'm installing a local MusicBrainz server is so that I can speed up 'beet import'
2016-04-07 09818, 2016
clee
(yes, overkill, I know)
2016-04-07 09827, 2016
bitmap
reosarevok: so after it's changed to Sergei and you run ko.bindingHandlers.artistCreditEditor.doneCallback(), then close the bubble, does it update the rest?
2016-04-07 09830, 2016
clee
will the local mb server handle AcoustID fingerprinting?
