nonodev Posted May 31, 2017 Share Posted May 31, 2017 (edited) Hi, With linuxserver/musicbrainz latest 5c848a812bc2 5 days ago 404 MB Same error as @Stuke00 during init with postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory Wich seems to be solved after restart container but I see something more disturbing when using headphones : Jun 1 00:59:21 dockerd/musicbrainz[2245]: ERROR: relation "release_event" does not exist at character 513 Jun 1 00:59:21 dockerd/musicbrainz[2245]: STATEMENT: Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 WITH x AS ( Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT * Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM ( Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT DISTINCT ON (release.id) release.id, release.gid, release.name, release.artist_credit AS artist_credit_id, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.release_group, release.status, release.packaging, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.comment, release.edits_pending, release.barcode, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.script, release.language, release.quality, release.last_updated, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 date_year, date_month, date_day, area.name AS country_name Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM release Jun 1 00:59:21 dockerd/musicbrainz[2245]: Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LEFT JOIN release_event ON release_event.release = release.id Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LEFT JOIN area ON area.id = release_event.country Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 WHERE status IN ('1') AND release_group IN ('475299') Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ORDER BY release.id, date_year, date_month, date_day, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 country_name, barcode Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ) s Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ORDER BY date_year, date_month, date_day, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 country_name, barcode Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 OFFSET '0') Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT x.*, c.count AS total_row_count Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM x, (SELECT count(*) from x) c Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LIMIT '100' Any idea ? Cheers Edited May 31, 2017 by nonodev Link to comment
sparklyballs Posted June 1, 2017 Share Posted June 1, 2017 1 hour ago, nonodev said: Hi, With linuxserver/musicbrainz latest 5c848a812bc2 5 days ago 404 MB Same error as @Stuke00 during init with postgres: could not access the server configuration file "/config/postgresql.conf": No such file or directory Wich seems to be solved after restart container but I see something more disturbing when using headphones : Jun 1 00:59:21 dockerd/musicbrainz[2245]: ERROR: relation "release_event" does not exist at character 513 Jun 1 00:59:21 dockerd/musicbrainz[2245]: STATEMENT: Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 WITH x AS ( Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT * Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM ( Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT DISTINCT ON (release.id) release.id, release.gid, release.name, release.artist_credit AS artist_credit_id, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.release_group, release.status, release.packaging, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.comment, release.edits_pending, release.barcode, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 release.script, release.language, release.quality, release.last_updated, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 date_year, date_month, date_day, area.name AS country_name Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM release Jun 1 00:59:21 dockerd/musicbrainz[2245]: Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LEFT JOIN release_event ON release_event.release = release.id Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LEFT JOIN area ON area.id = release_event.country Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 WHERE status IN ('1') AND release_group IN ('475299') Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ORDER BY release.id, date_year, date_month, date_day, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 country_name, barcode Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ) s Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 ORDER BY date_year, date_month, date_day, Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 country_name, barcode Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 OFFSET '0') Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 SELECT x.*, c.count AS total_row_count Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 FROM x, (SELECT count(*) from x) c Jun 1 00:59:21 dockerd/musicbrainz[2245]: #011 LIMIT '100' Any idea ? Cheers the database import can't complete due to a bug that was fixed in a new version of a perl dependency which conversely broke the import process. so in lieu of the next release of musicbrainz hopefully containing an update, i've pinned the dependency by sed'ing their cpanfile when building the image. the PR is in , will have to wait for another team member to merge it though. 1 Link to comment
nonodev Posted June 1, 2017 Share Posted June 1, 2017 Thanks for your answer. Do you have any idea how long it's gonna take? Thank you Link to comment
sparklyballs Posted June 1, 2017 Share Posted June 1, 2017 44 minutes ago, nonodev said: Thanks for your answer. Do you have any idea how long it's gonna take? Thank you it was done earlier. 1 Link to comment
nonodev Posted June 2, 2017 Share Posted June 2, 2017 Indeed it's working well now, thank you Link to comment
Endda Posted June 6, 2017 Share Posted June 6, 2017 I get a 'Caught exception in MusicBrainz::Server::Controller::Root->begin "Replication info missing on a slave server at lib/MusicBrainz/Server/Controller/Root.pm line 348."' error when visiting the html page for this docker image, and then a bunch of code underneath it Link to comment
grandprix Posted June 15, 2017 Share Posted June 15, 2017 On 6/6/2017 at 9:28 AM, Endda said: I get a 'Caught exception in MusicBrainz::Server::Controller::Root->begin "Replication info missing on a slave server at lib/MusicBrainz/Server/Controller/Root.pm line 348."' error when visiting the html page for this docker image, and then a bunch of code underneath it Ditto. Same error/issue on this end as well. Link to comment
tjb_altf4 Posted June 15, 2017 Share Posted June 15, 2017 I got that error too, wasn't sure if pebkac or issue with update. Ended up doing a clean install and re-downloading data and all was good after that. Link to comment
grandprix Posted June 15, 2017 Share Posted June 15, 2017 6 hours ago, tjb_altf4 said: I got that error too, wasn't sure if pebkac or issue with update. Ended up doing a clean install and re-downloading data and all was good after that. Could you explain the steps you took. While seeming easy/obvious, I've tried removing the docker, then reinstalling three times (more-less to try my "luck"). Doing this any more than I have would be the definition of insanity. Unless of course, I'm uninstalling/installing incorrectly. Link to comment
tjb_altf4 Posted June 16, 2017 Share Posted June 16, 2017 Uninstalled the docker and manually wiped all the related appdata (from both paths), not just the folders stated on last release notes. Normally an uninstall doesn't wipe this data. Link to comment
grandprix Posted June 16, 2017 Share Posted June 16, 2017 Alright. Did all that. /data/import seemed to download the DB (rar'ed), it then populated /data/dbase, then things seemed to just sit idle. Accessing the WebUI resulted in a timeout. With file timedate stamps seemingly having gone stale, I stopped the docker, then started it. Then /data/redis was created, along with /nginx and ./postgresql.conf and ./redis.conf and I could then get -something- via WebUI port (5000), but, same error message. <shrug> Not sure what else I can do. Endda, any success? Link to comment
Endda Posted June 18, 2017 Share Posted June 18, 2017 On 6/16/2017 at 1:40 AM, grandprix said: Alright. Did all that. /data/import seemed to download the DB (rar'ed), it then populated /data/dbase, then things seemed to just sit idle. Accessing the WebUI resulted in a timeout. With file timedate stamps seemingly having gone stale, I stopped the docker, then started it. Then /data/redis was created, along with /nginx and ./postgresql.conf and ./redis.conf and I could then get -something- via WebUI port (5000), but, same error message. <shrug> Not sure what else I can do. Endda, any success? Negative, but I gave up trying sadly. I just don't have the time to troubleshoot stuff like that. I'm hoping it will be fixed in a future update Link to comment
kakmoster Posted June 30, 2017 Share Posted June 30, 2017 Many errors... Quote root@DeusVult:~# docker logs musicbrainz [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 10-adduser: executing... ------------------------------------- _ _ _ | |___| (_) ___ | / __| | |/ _ \ | \__ \ | | (_) | |_|___/ |_|\___/ |_| Brought to you by linuxserver.io We gratefully accept donations at:https://www.linuxserver.io/donations/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-brainzcode: executing... [cont-init.d] 20-brainzcode: exited 0. [cont-init.d] 30-initialise-database: executing... fetching latest dump from musicbrainz, if this section fails try again later as musicbrainz dump may not be fully uploaded to their site % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 65.8M 100 65.8M 0 0 202k 0 0:05:33 0:05:33 --:--:-- 523k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 28.0M 100 28.0M 0 0 472k 0 0:01:00 0:01:00 --:--:-- 499k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 134M 100 134M 0 0 479k 0 0:04:46 0:04:46 --:--:-- 508k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 79.8M 100 79.8M 0 0 473k 0 0:02:52 0:02:52 --:--:-- 469k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 35.8M 100 35.8M 0 0 482k 0 0:01:15 0:01:15 --:--:-- 494k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 2360M 100 2360M 0 0 494k 0 1:21:25 1:21:25 --:--:-- 492k % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 7094 100 7094 0 0 1387 0 0:00:05 0:00:05 --:--:-- 2084 initialising empty databases completed postgres initialise waiting for server to start....LOG: could not create IPv6 socket: Address family not supported by protocol LOG: could not create socket for statistics collector: Address family not supported by protocol LOG: trying another address for the statistics collector LOG: database system was shut down at 2017-06-30 06:17:43 CEST LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections done server started BEGINNING INITIAL DATABASE IMPORT ROUTINE, THIS COULD TAKE SEVERAL HOURS AND THE DOCKER MAY LOOK UNRESPONSIVE DO NOT STOP DOCKER UNTIL IT IS COMPLETED Fri Jun 30 06:17:50 2017 : InitDb.pl starting Fri Jun 30 06:17:50 2017 : Creating database 'musicbrainz_db' CREATE SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE SCHEMA CREATE SCHEMA Fri Jun 30 06:17:51 2017 : Installing extensions (Extensions.sql) Fri Jun 30 06:17:51 2017 : Creating tables ... (CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating tables ... (caa/CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating documentation tables ... (documentation/CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating tables ... (report/CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating sitemaps tables ... (sitemaps/CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating statistics tables ... (statistics/CreateTables.sql) Fri Jun 30 06:17:52 2017 : Creating wikidocs tables ... (wikidocs/CreateTables.sql) Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-cdstubs.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-cover-art-archive.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-derived.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-editor.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-stats.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump-wikidocs.tar.bz2 Fri Jun 30 06:17:53 2017 : Pre-checking /data/import/20170628-001505/mbdump.tar.bz2 Fri Jun 30 06:17:53 2017 : tar -C /data/import/20170628-001505/MBImport-9uLJbfrj --bzip2 -xvf /data/import/20170628-001505/mbdump-cdstubs.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/cdtoc_raw mbdump/release_raw mbdump/track_raw Fri Jun 30 06:18:04 2017 : tar -C /data/import/20170628-001505/MBImport-tlspX_PR --bzip2 -xvf /data/import/20170628-001505/mbdump-cover-art-archive TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/cover_art_archive.art_type mbdump/cover_art_archive.cover_art mbdump/cover_art_archive.cover_art_type mbdump/cover_art_archive.image_type mbdump/cover_art_archive.release_group_cover_art Fri Jun 30 06:18:09 2017 : tar -C /data/import/20170628-001505/MBImport-FnDJFq8n --bzip2 -xvf /data/import/20170628-001505/mbdump-derived.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/annotation mbdump/area_annotation mbdump/area_tag mbdump/artist_annotation mbdump/artist_meta mbdump/artist_tag mbdump/event_annotation mbdump/event_meta mbdump/event_tag mbdump/instrument_annotation mbdump/instrument_tag mbdump/label_annotation mbdump/label_meta mbdump/label_tag mbdump/medium_index mbdump/place_annotation mbdump/place_tag mbdump/recording_annotation mbdump/recording_meta mbdump/recording_tag mbdump/release_annotation mbdump/release_group_annotation mbdump/release_group_meta mbdump/release_group_tag mbdump/release_meta mbdump/release_tag mbdump/series_annotation mbdump/series_tag mbdump/tag mbdump/tag_relation mbdump/work_annotation mbdump/work_meta mbdump/work_tag Fri Jun 30 06:18:36 2017 : tar -C /data/import/20170628-001505/MBImport-U81nMmlx --bzip2 -xvf /data/import/20170628-001505/mbdump-editor.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/editor_sanitised Fri Jun 30 06:18:52 2017 : tar -C /data/import/20170628-001505/MBImport-37tufP69 --bzip2 -xvf /data/import/20170628-001505/mbdump-stats.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/statistics.statistic mbdump/statistics.statistic_event Fri Jun 30 06:19:02 2017 : tar -C /data/import/20170628-001505/MBImport-K1GhB08n --bzip2 -xvf /data/import/20170628-001505/mbdump-wikidocs.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/wikidocs.wikidocs_index Fri Jun 30 06:19:02 2017 : tar -C /data/import/20170628-001505/MBImport-kxBbRuWZ --bzip2 -xvf /data/import/20170628-001505/mbdump.tar.bz2 TIMESTAMP COPYING README REPLICATION_SEQUENCE SCHEMA_SEQUENCE mbdump/alternative_release_type mbdump/area mbdump/area_alias mbdump/area_alias_type mbdump/area_gid_redirect mbdump/area_type mbdump/artist mbdump/artist_alias mbdump/artist_alias_type mbdump/artist_credit mbdump/artist_credit_name mbdump/artist_gid_redirect mbdump/artist_ipi mbdump/artist_isni mbdump/artist_type mbdump/cdtoc mbdump/country_area mbdump/editor_collection_type mbdump/event mbdump/event_alias mbdump/event_alias_type mbdump/event_gid_redirect mbdump/event_type mbdump/gender mbdump/instrument mbdump/instrument_alias mbdump/instrument_alias_type mbdump/instrument_gid_redirect mbdump/instrument_type mbdump/iso_3166_1 mbdump/iso_3166_2 mbdump/iso_3166_3 mbdump/isrc mbdump/iswc mbdump/l_area_area mbdump/l_area_event mbdump/l_area_instrument mbdump/l_area_recording mbdump/l_area_release mbdump/l_area_url mbdump/l_area_work mbdump/l_artist_artist mbdump/l_artist_event mbdump/l_artist_instrument mbdump/l_artist_label mbdump/l_artist_place mbdump/l_artist_recording mbdump/l_artist_release mbdump/l_artist_release_group mbdump/l_artist_series mbdump/l_artist_url mbdump/l_artist_work mbdump/l_event_event mbdump/l_event_place mbdump/l_event_recording mbdump/l_event_release mbdump/l_event_release_group mbdump/l_event_series mbdump/l_event_url mbdump/l_event_work mbdump/l_instrument_instrument mbdump/l_instrument_label mbdump/l_instrument_url mbdump/l_label_label mbdump/l_label_recording mbdump/l_label_release mbdump/l_label_url mbdump/l_label_work mbdump/l_place_place mbdump/l_place_recording mbdump/l_place_release mbdump/l_place_url mbdump/l_place_work mbdump/l_recording_recording mbdump/l_recording_release mbdump/l_recording_series mbdump/l_recording_url mbdump/l_recording_work mbdump/l_release_group_release_group mbdump/l_release_group_series mbdump/l_release_group_url mbdump/l_release_release mbdump/l_release_series mbdump/l_release_url mbdump/l_series_series mbdump/l_series_url mbdump/l_series_work mbdump/l_url_work mbdump/l_work_work mbdump/label mbdump/label_alias mbdump/label_alias_type mbdump/label_gid_redirect mbdump/label_ipi mbdump/label_isni mbdump/label_type mbdump/language mbdump/link mbdump/link_attribute mbdump/link_attribute_credit mbdump/link_attribute_text_value mbdump/link_attribute_type mbdump/link_creditable_attribute_type mbdump/link_text_attribute_type mbdump/link_type mbdump/link_type_attribute_type mbdump/medium mbdump/medium_cdtoc mbdump/medium_format mbdump/orderable_link_type mbdump/place mbdump/place_alias mbdump/place_alias_type mbdump/place_gid_redirect mbdump/place_type mbdump/recording mbdump/recording_alias mbdump/recording_alias_type mbdump/recording_gid_redirect mbdump/release mbdump/release_alias mbdump/release_alias_type mbdump/release_country mbdump/release_gid_redirect mbdump/release_group mbdump/release_group_alias mbdump/release_group_alias_type mbdump/release_group_gid_redirect mbdump/release_group_primary_type mbdump/release_group_secondary_type mbdump/release_group_secondary_type_join mbdump/release_label mbdump/release_packaging mbdump/release_status mbdump/release_unknown_country mbdump/replication_control mbdump/script mbdump/series mbdump/series_alias mbdump/series_alias_type mbdump/series_gid_redirect mbdump/series_ordering_type mbdump/series_type mbdump/track mbdump/track_gid_redirect mbdump/url mbdump/url_gid_redirect mbdump/work mbdump/work_alias mbdump/work_alias_type mbdump/work_attribute mbdump/work_attribute_type mbdump/work_attribute_type_allowed_value mbdump/work_gid_redirect mbdump/work_language mbdump/work_type Fri Jun 30 06:25:28 2017 : Validating snapshot Fri Jun 30 06:25:28 2017 : Snapshot timestamp is 2017-06-28 00:15:05.822658+00 Fri Jun 30 06:25:28 2017 : This snapshot corresponds to replication sequence #105533 Fri Jun 30 06:25:28 2017 : starting import Table Rows est% rows/sec No data file found for 'alternative_medium', skipping No data file found for 'alternative_medium_track', skipping No data file found for 'alternative_release', skipping Fri Jun 30 06:25:28 2017 : load alternative_release_type alternative_release_type 3 100% 748 0.00 sec No data file found for 'alternative_track', skipping Fri Jun 30 06:25:28 2017 : load area area 116759 100% 172688 0.68 sec Fri Jun 30 06:25:29 2017 : load area_alias area_alias 66225 100% 202547 0.33 sec Fri Jun 30 06:25:30 2017 : load area_alias_type area_alias_type 3 100% 3337 0.00 sec No data file found for 'area_attribute', skipping No data file found for 'area_attribute_type', skipping No data file found for 'area_attribute_type_allowed_value', skipping Fri Jun 30 06:25:30 2017 : load area_gid_redirect area_gid_redirect 180 100% 111317 0.00 sec Fri Jun 30 06:25:30 2017 : load area_type area_type 7 100% 10852 0.00 sec Fri Jun 30 06:25:30 2017 : load artist artist 1224471 100% 135168 9.06 sec Fri Jun 30 06:25:39 2017 : load artist_alias artist_alias 176076 100% 159226 1.11 sec Fri Jun 30 06:25:40 2017 : load artist_alias_type artist_alias_type 3 100% 975 0.00 sec No data file found for 'artist_attribute', skipping No data file found for 'artist_attribute_type', skipping No data file found for 'artist_attribute_type_allowed_value', skipping Fri Jun 30 06:25:40 2017 : load artist_credit artist_credit 1281848 100% 271029 4.73 sec Fri Jun 30 06:25:44 2017 : load artist_credit_name artist_credit_name 2058547 100% 492519 4.18 sec Fri Jun 30 06:25:49 2017 : load artist_gid_redirect artist_gid_redirect 39214 100% 256156 0.15 sec Fri Jun 30 06:25:49 2017 : load artist_ipi artist_ipi 27899 100% 183112 0.15 sec Fri Jun 30 06:25:49 2017 : load artist_isni artist_isni 28873 100% 155315 0.19 sec Fri Jun 30 06:25:49 2017 : load artist_type artist_type 6 100% 7177 0.00 sec Fri Jun 30 06:25:49 2017 : load cdtoc cdtoc 702265 100% 105680 6.65 sec Fri Jun 30 06:25:56 2017 : load country_area country_area 257 100% 108119 0.00 sec Fri Jun 30 06:25:56 2017 : load editor_collection_type editor_collection_type 15 100% 12155 0.00 sec Fri Jun 30 06:25:56 2017 : load event event 24902 100% 44281 0.56 sec Fri Jun 30 06:25:57 2017 : load event_alias event_alias 868 100% 136908 0.01 sec Fri Jun 30 06:25:57 2017 : load event_alias_type event_alias_type 2 100% 3378 0.00 sec No data file found for 'event_attribute', skipping No data file found for 'event_attribute_type', skipping No data file found for 'event_attribute_type_allowed_value', skipping Fri Jun 30 06:25:57 2017 : load event_gid_redirect event_gid_redirect 359 100% 163926 0.00 sec Fri Jun 30 06:25:57 2017 : load event_type event_type 5 100% 7987 0.00 sec Fri Jun 30 06:25:57 2017 : load gender gender 3 100% 4484 0.00 sec Fri Jun 30 06:25:57 2017 : load instrument instrument 857 100% 100669 0.01 sec Fri Jun 30 06:25:57 2017 : load instrument_alias instrument_alias 6240 100% 189983 0.03 sec Fri Jun 30 06:25:57 2017 : load instrument_alias_type instrument_alias_type 2 100% 3072 0.00 sec No data file found for 'instrument_attribute', skipping No data file found for 'instrument_attribute_type', skipping No data file found for 'instrument_attribute_type_allowed_value', skipping Fri Jun 30 06:25:57 2017 : load instrument_gid_redirect instrument_gid_redirect 8 100% 11747 0.00 sec Fri Jun 30 06:25:57 2017 : load instrument_type instrument_type 5 100% 7564 0.00 sec Fri Jun 30 06:25:57 2017 : load iso_3166_1 iso_3166_1 258 100% 201562 0.00 sec Fri Jun 30 06:25:57 2017 : load iso_3166_2 iso_3166_2 4839 100% 777724 0.01 sec Fri Jun 30 06:25:57 2017 : load iso_3166_3 iso_3166_3 9 100% 13452 0.00 sec Fri Jun 30 06:25:57 2017 : load isrc isrc 673170 100% 161585 4.17 sec Fri Jun 30 06:26:01 2017 : load iswc iswc 131899 100% 149636 0.88 sec Fri Jun 30 06:26:02 2017 : load l_area_area l_area_area 116643 100% 279959 0.42 sec No data file found for 'l_area_artist', skipping Fri Jun 30 06:26:02 2017 : load l_area_event l_area_event 1646 100% 135763 0.01 sec Fri Jun 30 06:26:02 2017 : load l_area_instrument l_area_instrument 396 100% 102883 0.00 sec No data file found for 'l_area_label', skipping No data file found for 'l_area_place', skipping Fri Jun 30 06:26:02 2017 : load l_area_recording l_area_recording 40669 100% 254440 0.16 sec Fri Jun 30 06:26:03 2017 : load l_area_release l_area_release 4053 100% 226627 0.02 sec No data file found for 'l_area_release_group', skipping No data file found for 'l_area_series', skipping Fri Jun 30 06:26:03 2017 : load l_area_url l_area_url 376638 100% 254302 1.48 sec Fri Jun 30 06:26:04 2017 : load l_area_work l_area_work 2766 100% 209481 0.01 sec Fri Jun 30 06:26:04 2017 : load l_artist_artist l_artist_artist 293840 100% 266756 1.10 sec Fri Jun 30 06:26:05 2017 : load l_artist_event l_artist_event 68856 100% 263335 0.26 sec Fri Jun 30 06:26:06 2017 : load l_artist_instrument l_artist_instrument 43 100% 38256 0.00 sec Fri Jun 30 06:26:06 2017 : load l_artist_label l_artist_label 14436 100% 276790 0.05 sec Fri Jun 30 06:26:06 2017 : load l_artist_place l_artist_place 3185 100% 188350 0.02 sec Fri Jun 30 06:26:06 2017 : load l_artist_recording l_artist_recording 5500937 100% 247810 22.20 sec Fri Jun 30 06:26:28 2017 : load l_artist_release l_artist_release 495049 100% 247811 2.00 sec Fri Jun 30 06:26:30 2017 : load l_artist_release_group l_artist_release_group 5358 100% 269707 0.02 sec Fri Jun 30 06:26:30 2017 : load l_artist_series l_artist_series 1000 100% 143822 0.01 sec Fri Jun 30 06:26:30 2017 : load l_artist_url l_artist_url 1566254 100% 251238 6.23 sec Fri Jun 30 06:26:36 2017 : load l_artist_work l_artist_work 1429700 100% 246208 5.81 sec Fri Jun 30 06:26:42 2017 : load l_event_event l_event_event 6108 100% 273166 0.02 sec No data file found for 'l_event_instrument', skipping No data file found for 'l_event_label', skipping Fri Jun 30 06:26:42 2017 : load l_event_place l_event_place 22020 100% 284543 0.08 sec Fri Jun 30 06:26:42 2017 : load l_event_recording l_event_recording 26518 100% 277911 0.10 sec Fri Jun 30 06:26:42 2017 : load l_event_release l_event_release 3440 100% 253855 0.01 sec Fri Jun 30 06:26:42 2017 : load l_event_release_group l_event_release_group 293 100% 64198 0.00 sec Fri Jun 30 06:26:42 2017 : load l_event_series l_event_series 12577 100% 274217 0.05 sec Fri Jun 30 06:26:42 2017 : load l_event_url l_event_url 21155 100% 276247 0.08 sec Fri Jun 30 06:26:42 2017 : load l_event_work l_event_work 1351 100% 213799 0.01 sec Fri Jun 30 06:26:42 2017 : load l_instrument_instrument l_instrument_instrument 995 100% 215507 0.00 sec Fri Jun 30 06:26:42 2017 : load l_instrument_label l_instrument_label 4 100% 6259 0.00 sec No data file found for 'l_instrument_place', skipping No data file found for 'l_instrument_recording', skipping No data file found for 'l_instrument_release', skipping No data file found for 'l_instrument_release_group', skipping No data file found for 'l_instrument_series', skipping Fri Jun 30 06:26:42 2017 : load l_instrument_url l_instrument_url 923 100% 216361 0.00 sec No data file found for 'l_instrument_work', skipping Fri Jun 30 06:26:42 2017 : load l_label_label l_label_label 12615 100% 281509 0.04 sec No data file found for 'l_label_place', skipping Fri Jun 30 06:26:43 2017 : load l_label_recording l_label_recording 66492 100% 275307 0.24 sec Fri Jun 30 06:26:43 2017 : load l_label_release l_label_release 48751 100% 282393 0.17 sec No data file found for 'l_label_release_group', skipping No data file found for 'l_label_series', skipping Fri Jun 30 06:26:43 2017 : load l_label_url l_label_url 118179 100% 286189 0.41 sec Fri Jun 30 06:26:43 2017 : load l_label_work l_label_work 120160 100% 261950 0.46 sec Fri Jun 30 06:26:44 2017 : load l_place_place l_place_place 1424 100% 129702 0.01 sec Fri Jun 30 06:26:44 2017 : load l_place_recording l_place_recording 597821 100% 262436 2.28 sec Fri Jun 30 06:26:46 2017 : load l_place_release l_place_release 20557 100% 280588 0.07 sec No data file found for 'l_place_release_group', skipping No data file found for 'l_place_series', skipping Fri Jun 30 06:26:46 2017 : load l_place_url l_place_url 31906 100% 275398 0.12 sec Fri Jun 30 06:26:47 2017 : load l_place_work l_place_work 1475 100% 221172 0.01 sec Fri Jun 30 06:26:47 2017 : load l_recording_recording l_recording_recording 67318 100% 283549 0.24 sec Fri Jun 30 06:26:47 2017 : load l_recording_release l_recording_release 296 100% 76703 0.00 sec No data file found for 'l_recording_release_group', skipping Fri Jun 30 06:26:47 2017 : load l_recording_series l_recording_series 5584 100% 175503 0.03 sec Fri Jun 30 06:26:47 2017 : load l_recording_url l_recording_url 59647 100% 271019 0.22 sec Fri Jun 30 06:26:47 2017 : load l_recording_work l_recording_work 2344488 100% 257488 9.11 sec Fri Jun 30 06:26:56 2017 : load l_release_group_release_group l_release_group_release_group 19925 100% 279225 0.07 sec Fri Jun 30 06:26:56 2017 : load l_release_group_series l_release_group_series 39352 100% 279151 0.14 sec Fri Jun 30 06:26:57 2017 : load l_release_group_url l_release_group_url 434274 100% 267904 1.62 sec No data file found for 'l_release_group_work', skipping Fri Jun 30 06:26:58 2017 : load l_release_release l_release_release 16302 100% 259247 0.06 sec No data file found for 'l_release_release_group', skipping Fri Jun 30 06:26:58 2017 : load l_release_series l_release_series 8896 100% 269706 0.03 sec Fri Jun 30 06:26:58 2017 : load l_release_url l_release_url 1578686 100% 266088 5.93 sec No data file found for 'l_release_work', skipping Fri Jun 30 06:27:04 2017 : load l_series_series l_series_series 328 100% 99635 0.00 sec Fri Jun 30 06:27:04 2017 : load l_series_url l_series_url 3987 100% 230129 0.02 sec Fri Jun 30 06:27:04 2017 : load l_series_work l_series_work 23604 100% 266678 0.09 sec No data file found for 'l_url_url', skipping Fri Jun 30 06:27:04 2017 : load l_url_work l_url_work 103461 100% 267547 0.39 sec Fri Jun 30 06:27:05 2017 : load l_work_work l_work_work 185772 100% 267380 0.69 sec Fri Jun 30 06:27:06 2017 : load label label 125812 100% 162787 0.77 sec Fri Jun 30 06:27:06 2017 : load label_alias label_alias 13416 100% 176917 0.08 sec Fri Jun 30 06:27:06 2017 : load label_alias_type label_alias_type 2 100% 1831 0.00 sec No data file found for 'label_attribute', skipping No data file found for 'label_attribute_type', skipping No data file found for 'label_attribute_type_allowed_value', skipping Fri Jun 30 06:27:06 2017 : load label_gid_redirect label_gid_redirect 3583 100% 205624 0.02 sec Fri Jun 30 06:27:06 2017 : load label_ipi label_ipi 5305 100% 179526 0.03 sec Fri Jun 30 06:27:06 2017 : load label_isni label_isni 24 100% 20442 0.00 sec Fri Jun 30 06:27:07 2017 : load label_type label_type 9 100% 5395 0.00 sec Fri Jun 30 06:27:07 2017 : load language language 7843 100% 435093 0.02 sec Fri Jun 30 06:27:07 2017 : load link link 319261 100% 267237 1.19 sec Fri Jun 30 06:27:08 2017 : load link_attribute link_attribute 249196 100% 415906 0.60 sec Fri Jun 30 06:27:08 2017 : load link_attribute_credit link_attribute_credit 21000 100% 712734 0.03 sec Fri Jun 30 06:27:08 2017 : load link_attribute_text_value link_attribute_text_value 23835 100% 850733 0.03 sec Fri Jun 30 06:27:08 2017 : load link_attribute_type link_attribute_type 910 100% 118551 0.01 sec Fri Jun 30 06:27:08 2017 : load link_creditable_attribute_type link_creditable_attribute_type 874 100% 381993 0.00 sec Fri Jun 30 06:27:08 2017 : load link_text_attribute_type link_text_attribute_type 2 100% 3215 0.00 sec Fri Jun 30 06:27:08 2017 : load link_type link_type 465 100% 87984 0.01 sec Fri Jun 30 06:27:09 2017 : load link_type_attribute_type link_type_attribute_type 235 100% 118328 0.00 sec Fri Jun 30 06:27:09 2017 : load medium medium 2045734 100% 275844 7.42 sec No data file found for 'medium_attribute', skipping No data file found for 'medium_attribute_type', skipping No data file found for 'medium_attribute_type_allowed_format', skipping No data file found for 'medium_attribute_type_allowed_value', skipping No data file found for 'medium_attribute_type_allowed_value_allowed_format', skipping Fri Jun 30 06:27:16 2017 : load medium_cdtoc medium_cdtoc 844426 100% 331759 2.55 sec Fri Jun 30 06:27:19 2017 : load medium_format medium_format 71 100% 43531 0.00 sec Fri Jun 30 06:27:19 2017 : load orderable_link_type orderable_link_type 8 100% 10781 0.00 sec Fri Jun 30 06:27:19 2017 : load place place 25875 100% 139419 0.19 sec Fri Jun 30 06:27:19 2017 : load place_alias place_alias 5302 100% 175359 0.03 sec Fri Jun 30 06:27:19 2017 : load place_alias_type place_alias_type 2 100% 633 0.00 sec No data file found for 'place_attribute', skipping No data file found for 'place_attribute_type', skipping No data file found for 'place_attribute_type_allowed_value', skipping Fri Jun 30 06:27:19 2017 : load place_gid_redirect place_gid_redirect 306 100% 147540 0.00 sec Fri Jun 30 06:27:19 2017 : load place_type place_type 6 100% 4750 0.00 sec Fri Jun 30 06:27:19 2017 : load recording LOG: checkpoints are occurring too frequently (29 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". LOG: checkpoints are occurring too frequently (27 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". LOG: checkpoints are occurring too frequently (28 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". recording 17514189 100% 189926 92.22 sec Fri Jun 30 06:28:51 2017 : load recording_alias recording_alias 147799 100% 167548 0.88 sec Fri Jun 30 06:28:52 2017 : load recording_alias_type recording_alias_type 2 100% 2066 0.00 sec No data file found for 'recording_attribute', skipping No data file found for 'recording_attribute_type', skipping No data file found for 'recording_attribute_type_allowed_value', skipping Fri Jun 30 06:28:52 2017 : load recording_gid_redirect recording_gid_redirect 1845232 100% 251439 7.34 sec Fri Jun 30 06:28:59 2017 : load release release 1819255 100% 145140 12.53 sec Fri Jun 30 06:29:12 2017 : load release_alias release_alias 7602 100% 182991 0.04 sec Fri Jun 30 06:29:12 2017 : load release_alias_type release_alias_type 2 100% 2673 0.00 sec No data file found for 'release_attribute', skipping No data file found for 'release_attribute_type', skipping No data file found for 'release_attribute_type_allowed_value', skipping Fri Jun 30 06:29:12 2017 : load release_country release_country 1565218 100% 703815 2.22 sec Fri Jun 30 06:29:14 2017 : load release_gid_redirect release_gid_redirect 125247 100% 260042 0.48 sec Fri Jun 30 06:29:15 2017 : load release_group release_group 1455048 100% 181301 8.03 sec Fri Jun 30 06:29:23 2017 : load release_group_alias release_group_alias 7597 100% 179717 0.04 sec Fri Jun 30 06:29:23 2017 : load release_group_alias_type release_group_alias_type 2 100% 2656 0.00 sec No data file found for 'release_group_attribute', skipping No data file found for 'release_group_attribute_type', skipping No data file found for 'release_group_attribute_type_allowed_value', skipping Fri Jun 30 06:29:23 2017 : load release_group_gid_redirect release_group_gid_redirect 139410 100% 257935 0.54 sec Fri Jun 30 06:29:23 2017 : load release_group_primary_type release_group_primary_type 5 100% 3431 0.00 sec Fri Jun 30 06:29:23 2017 : load release_group_secondary_type release_group_secondary_type 10 100% 12547 0.00 sec Fri Jun 30 06:29:23 2017 : load release_group_secondary_type_join release_group_secondary_type_j 378520 100% 486100 0.78 sec Fri Jun 30 06:29:24 2017 : load release_label release_label 1422270 100% 323129 4.40 sec Fri Jun 30 06:29:29 2017 : load release_packaging release_packaging 15 100% 5490 0.00 sec Fri Jun 30 06:29:29 2017 : load release_status release_status 4 100% 2749 0.00 sec Fri Jun 30 06:29:29 2017 : load release_unknown_country release_unknown_country 103547 100% 682019 0.15 sec Fri Jun 30 06:29:29 2017 : load replication_control replication_control 1 100% 1497 0.00 sec Fri Jun 30 06:29:29 2017 : load script script 159 100% 38648 0.00 sec Fri Jun 30 06:29:29 2017 : load series series 6285 100% 132455 0.05 sec Fri Jun 30 06:29:29 2017 : load series_alias series_alias 549 100% 62301 0.01 sec Fri Jun 30 06:29:29 2017 : load series_alias_type series_alias_type 2 100% 1858 0.00 sec No data file found for 'series_attribute', skipping No data file found for 'series_attribute_type', skipping No data file found for 'series_attribute_type_allowed_value', skipping Fri Jun 30 06:29:29 2017 : load series_gid_redirect series_gid_redirect 34 100% 25241 0.00 sec Fri Jun 30 06:29:29 2017 : load series_ordering_type series_ordering_type 2 100% 1910 0.00 sec Fri Jun 30 06:29:29 2017 : load series_type series_type 9 100% 7860 0.00 sec Fri Jun 30 06:29:29 2017 : load track track 22674197 100% 153054 148.15 sec Fri Jun 30 06:31:57 2017 : load track_gid_redirect track_gid_redirect 133236 100% 253465 0.53 sec Fri Jun 30 06:31:58 2017 : load url LOG: checkpoints are occurring too frequently (29 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". url 4147673 100% 183501 22.60 sec Fri Jun 30 06:32:20 2017 : load url_gid_redirect url_gid_redirect 4511 100% 206434 0.02 sec Fri Jun 30 06:32:20 2017 : load work work 866653 100% 190503 4.55 sec Fri Jun 30 06:32:25 2017 : load work_alias work_alias 94341 100% 142374 0.66 sec Fri Jun 30 06:32:26 2017 : load work_alias_type work_alias_type 2 100% 1294 0.00 sec Fri Jun 30 06:32:26 2017 : load work_attribute work_attribute 109166 100% 681720 0.16 sec Fri Jun 30 06:32:26 2017 : load work_attribute_type work_attribute_type 25 100% 8028 0.00 sec Fri Jun 30 06:32:26 2017 : load work_attribute_type_allowed_value work_attribute_type_allowed_va 799 100% 202278 0.00 sec Fri Jun 30 06:32:26 2017 : load work_gid_redirect work_gid_redirect 125839 100% 259864 0.48 sec Fri Jun 30 06:32:26 2017 : load work_language work_language 514771 100% 364066 1.41 sec Fri Jun 30 06:32:28 2017 : load work_type work_type 29 100% 23558 0.00 sec Fri Jun 30 06:32:28 2017 : load annotation LOG: checkpoints are occurring too frequently (25 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". annotation 487018 100% 129534 3.76 sec Fri Jun 30 06:32:31 2017 : load area_annotation area_annotation 8 100% 9661 0.00 sec Fri Jun 30 06:32:31 2017 : load area_tag area_tag 754 100% 254729 0.00 sec Fri Jun 30 06:32:31 2017 : load artist_annotation artist_annotation 28925 100% 933094 0.03 sec Fri Jun 30 06:32:32 2017 : load artist_meta artist_meta 1224471 100% 905680 1.35 sec Fri Jun 30 06:32:33 2017 : load artist_tag artist_tag 211571 100% 395063 0.54 sec Fri Jun 30 06:32:33 2017 : load event_annotation event_annotation 1931 100% 540442 0.00 sec Fri Jun 30 06:32:33 2017 : load event_meta event_meta 24902 100% 915077 0.03 sec Fri Jun 30 06:32:33 2017 : load event_tag event_tag 3875 100% 198047 0.02 sec Fri Jun 30 06:32:34 2017 : load instrument_annotation instrument_annotation 23 100% 18683 0.00 sec Fri Jun 30 06:32:34 2017 : load instrument_tag instrument_tag 867 100% 228338 0.00 sec Fri Jun 30 06:32:34 2017 : load label_annotation label_annotation 6447 100% 725768 0.01 sec Fri Jun 30 06:32:34 2017 : load label_meta label_meta 125812 100% 940566 0.13 sec Fri Jun 30 06:32:34 2017 : load label_tag label_tag 8880 100% 350461 0.03 sec Fri Jun 30 06:32:34 2017 : load medium_index medium_index 1766073 100% 250363 7.05 sec Fri Jun 30 06:32:41 2017 : load place_annotation place_annotation 387 100% 185700 0.00 sec Fri Jun 30 06:32:41 2017 : load place_tag place_tag 728 100% 258982 0.00 sec Fri Jun 30 06:32:41 2017 : load recording_annotation recording_annotation 32757 100% 914897 0.04 sec Fri Jun 30 06:32:41 2017 : load recording_meta recording_meta 17514189 100% 853184 20.53 sec Fri Jun 30 06:33:01 2017 : load recording_tag recording_tag 1344737 100% 351933 3.82 sec Fri Jun 30 06:33:05 2017 : load release_annotation release_annotation 369787 100% 827626 0.45 sec Fri Jun 30 06:33:06 2017 : load release_group_annotation release_group_annotation 5028 100% 559350 0.01 sec Fri Jun 30 06:33:06 2017 : load release_group_meta release_group_meta 1455048 100% 632163 2.30 sec Fri Jun 30 06:33:08 2017 : load release_group_tag release_group_tag 437942 100% 379284 1.15 sec Fri Jun 30 06:33:09 2017 : load release_meta release_meta 1819255 100% 276493 6.58 sec Fri Jun 30 06:33:16 2017 : load release_tag release_tag 142125 100% 382531 0.37 sec Fri Jun 30 06:33:16 2017 : load series_annotation series_annotation 628 100% 238783 0.00 sec Fri Jun 30 06:33:16 2017 : load series_tag series_tag 512 100% 105155 0.00 sec Fri Jun 30 06:33:16 2017 : load tag tag 71796 100% 836910 0.09 sec Fri Jun 30 06:33:16 2017 : load tag_relation tag_relation 125772 100% 356300 0.35 sec Fri Jun 30 06:33:17 2017 : load work_annotation work_annotation 40865 100% 852206 0.05 sec Fri Jun 30 06:33:17 2017 : load work_meta work_meta 866653 100% 886978 0.98 sec Fri Jun 30 06:33:18 2017 : load work_tag work_tag 27043 100% 384008 0.07 sec Fri Jun 30 06:33:18 2017 : load statistics.statistic LOG: checkpoints are occurring too frequently (26 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". statistics.statistic 7054902 100% 406723 17.35 sec Fri Jun 30 06:33:35 2017 : load statistics.statistic_event statistics.statistic_event 67 100% 17972 0.00 sec Fri Jun 30 06:33:35 2017 : loading /data/import/20170628-001505/MBImport-U81nMmlx/mbdump/editor_sanitised into editor Fri Jun 30 06:33:35 2017 : load editor editor 1858526 100% 106544 17.44 sec No data file found for 'edit', skipping No data file found for 'edit_area', skipping No data file found for 'edit_artist', skipping No data file found for 'edit_data', skipping No data file found for 'edit_event', skipping No data file found for 'edit_instrument', skipping No data file found for 'edit_label', skipping No data file found for 'edit_note', skipping No data file found for 'edit_note_recipient', skipping No data file found for 'edit_place', skipping No data file found for 'edit_recording', skipping No data file found for 'edit_release', skipping No data file found for 'edit_release_group', skipping No data file found for 'edit_series', skipping No data file found for 'edit_url', skipping No data file found for 'edit_work', skipping No data file found for 'vote', skipping No data file found for 'application', skipping No data file found for 'area_tag_raw', skipping No data file found for 'artist_rating_raw', skipping No data file found for 'artist_tag_raw', skipping No data file found for 'autoeditor_election', skipping No data file found for 'autoeditor_election_vote', skipping No data file found for 'editor', skipping No data file found for 'editor_collection', skipping No data file found for 'editor_collection_area', skipping No data file found for 'editor_collection_artist', skipping No data file found for 'editor_collection_event', skipping No data file found for 'editor_collection_instrument', skipping No data file found for 'editor_collection_label', skipping No data file found for 'editor_collection_place', skipping No data file found for 'editor_collection_recording', skipping No data file found for 'editor_collection_release', skipping No data file found for 'editor_collection_release_group', skipping No data file found for 'editor_collection_series', skipping No data file found for 'editor_collection_work', skipping No data file found for 'editor_language', skipping No data file found for 'editor_oauth_token', skipping No data file found for 'editor_preference', skipping No data file found for 'editor_subscribe_artist', skipping No data file found for 'editor_subscribe_collection', skipping No data file found for 'editor_subscribe_editor', skipping No data file found for 'editor_subscribe_label', skipping No data file found for 'editor_subscribe_series', skipping No data file found for 'editor_watch_artist', skipping No data file found for 'editor_watch_preferences', skipping No data file found for 'editor_watch_release_group_type', skipping No data file found for 'editor_watch_release_status', skipping No data file found for 'event_rating_raw', skipping No data file found for 'event_tag_raw', skipping No data file found for 'instrument_tag_raw', skipping No data file found for 'label_rating_raw', skipping No data file found for 'label_tag_raw', skipping No data file found for 'old_editor_name', skipping No data file found for 'place_tag_raw', skipping No data file found for 'recording_rating_raw', skipping No data file found for 'recording_tag_raw', skipping No data file found for 'release_coverart', skipping No data file found for 'release_group_rating_raw', skipping No data file found for 'release_group_tag_raw', skipping No data file found for 'release_tag_raw', skipping No data file found for 'series_tag_raw', skipping No data file found for 'work_rating_raw', skipping No data file found for 'work_tag_raw', skipping Fri Jun 30 06:33:53 2017 : load cdtoc_raw cdtoc_raw 288376 100% 165480 1.74 sec Fri Jun 30 06:33:55 2017 : load release_raw release_raw 288376 100% 158998 1.81 sec Fri Jun 30 06:33:56 2017 : load track_raw LOG: checkpoints are occurring too frequently (27 seconds apart) HINT: Consider increasing the configuration parameter "max_wal_size". track_raw 3460085 100% 546440 6.33 sec Fri Jun 30 06:34:03 2017 : load cover_art_archive.art_type cover_art_archive.art_type 13 100% 8150 0.00 sec Fri Jun 30 06:34:03 2017 : load cover_art_archive.cover_art cover_art_archive.cover_art 1309395 100% 245191 5.34 sec Fri Jun 30 06:34:08 2017 : load cover_art_archive.cover_art_type cover_art_archive.cover_art_ty 1399373 100% 855195 1.64 sec Fri Jun 30 06:34:10 2017 : load cover_art_archive.image_type cover_art_archive.image_type 4 100% 2564 0.00 sec Fri Jun 30 06:34:10 2017 : load cover_art_archive.release_group_cover_art cover_art_archive.release_grou 3713 100% 603445 0.01 sec Fri Jun 30 06:34:10 2017 : load wikidocs.wikidocs_index wikidocs.wikidocs_index 161 100% 89444 0.00 sec No data file found for 'documentation.l_area_area_example', skipping No data file found for 'documentation.l_area_artist_example', skipping No data file found for 'documentation.l_area_event_example', skipping No data file found for 'documentation.l_area_instrument_example', skipping No data file found for 'documentation.l_area_label_example', skipping No data file found for 'documentation.l_area_place_example', skipping No data file found for 'documentation.l_area_recording_example', skipping No data file found for 'documentation.l_area_release_example', skipping No data file found for 'documentation.l_area_release_group_example', skipping No data file found for 'documentation.l_area_series_example', skipping No data file found for 'documentation.l_area_url_example', skipping No data file found for 'documentation.l_area_work_example', skipping No data file found for 'documentation.l_artist_artist_example', skipping No data file found for 'documentation.l_artist_event_example', skipping No data file found for 'documentation.l_artist_instrument_example', skipping No data file found for 'documentation.l_artist_label_example', skipping No data file found for 'documentation.l_artist_place_example', skipping No data file found for 'documentation.l_artist_recording_example', skipping No data file found for 'documentation.l_artist_release_example', skipping No data file found for 'documentation.l_artist_release_group_example', skipping No data file found for 'documentation.l_artist_series_example', skipping No data file found for 'documentation.l_artist_url_example', skipping No data file found for 'documentation.l_artist_work_example', skipping No data file found for 'documentation.l_event_event_example', skipping No data file found for 'documentation.l_event_instrument_example', skipping No data file found for 'documentation.l_event_label_example', skipping No data file found for 'documentation.l_event_place_example', skipping No data file found for 'documentation.l_event_recording_example', skipping No data file found for 'documentation.l_event_release_example', skipping No data file found for 'documentation.l_event_release_group_example', skipping No data file found for 'documentation.l_event_series_example', skipping No data file found for 'documentation.l_event_url_example', skipping No data file found for 'documentation.l_event_work_example', skipping No data file found for 'documentation.l_instrument_instrument_example', skipping No data file found for 'documentation.l_instrument_label_example', skipping No data file found for 'documentation.l_instrument_place_example', skipping No data file found for 'documentation.l_instrument_recording_example', skipping No data file found for 'documentation.l_instrument_release_example', skipping No data file found for 'documentation.l_instrument_release_group_example', skipping No data file found for 'documentation.l_instrument_series_example', skipping No data file found for 'documentation.l_instrument_url_example', skipping No data file found for 'documentation.l_instrument_work_example', skipping No data file found for 'documentation.l_label_label_example', skipping No data file found for 'documentation.l_label_place_example', skipping No data file found for 'documentation.l_label_recording_example', skipping No data file found for 'documentation.l_label_release_example', skipping No data file found for 'documentation.l_label_release_group_example', skipping No data file found for 'documentation.l_label_series_example', skipping No data file found for 'documentation.l_label_url_example', skipping No data file found for 'documentation.l_label_work_example', skipping No data file found for 'documentation.l_place_place_example', skipping No data file found for 'documentation.l_place_recording_example', skipping No data file found for 'documentation.l_place_release_example', skipping No data file found for 'documentation.l_place_release_group_example', skipping No data file found for 'documentation.l_place_series_example', skipping No data file found for 'documentation.l_place_url_example', skipping No data file found for 'documentation.l_place_work_example', skipping No data file found for 'documentation.l_recording_recording_example', skipping No data file found for 'documentation.l_recording_release_example', skipping No data file found for 'documentation.l_recording_release_group_example', skipping No data file found for 'documentation.l_recording_series_example', skipping No data file found for 'documentation.l_recording_url_example', skipping No data file found for 'documentation.l_recording_work_example', skipping No data file found for 'documentation.l_release_group_release_group_example', skipping No data file found for 'documentation.l_release_group_series_example', skipping No data file found for 'documentation.l_release_group_url_example', skipping No data file found for 'documentation.l_release_group_work_example', skipping No data file found for 'documentation.l_release_release_example', skipping No data file found for 'documentation.l_release_release_group_example', skipping No data file found for 'documentation.l_release_series_example', skipping No data file found for 'documentation.l_release_url_example', skipping No data file found for 'documentation.l_release_work_example', skipping No data file found for 'documentation.l_series_series_example', skipping No data file found for 'documentation.l_series_url_example', skipping No data file found for 'documentation.l_series_work_example', skipping No data file found for 'documentation.l_url_url_example', skipping No data file found for 'documentation.l_url_work_example', skipping No data file found for 'documentation.l_work_work_example', skipping No data file found for 'documentation.link_type_documentation', skipping No data file found for 'sitemaps.artist_lastmod', skipping No data file found for 'sitemaps.control', skipping No data file found for 'sitemaps.label_lastmod', skipping No data file found for 'sitemaps.place_lastmod', skipping No data file found for 'sitemaps.recording_lastmod', skipping No data file found for 'sitemaps.release_group_lastmod', skipping No data file found for 'sitemaps.release_lastmod', skipping No data file found for 'sitemaps.work_lastmod', skipping Fri Jun 30 06:34:10 2017 : ensuring editor information is present Fri Jun 30 06:34:12 2017 : import finished Loaded 201 tables (125206789 rows) in 523 seconds Fri Jun 30 06:34:12 2017 : Creating primary keys ... (CreatePrimaryKeys.sql) Fri Jun 30 06:37:24 2017 : Creating CAA primary keys ... (caa/CreatePrimaryKeys.sql) Fri Jun 30 06:37:28 2017 : Creating documentation primary keys ... (documentation/CreatePrimaryKeys.sql) Fri Jun 30 06:37:29 2017 : Creating statistics primary keys ... (statistics/CreatePrimaryKeys.sql) Fri Jun 30 06:37:39 2017 : Creating wikidocs primary keys ... (wikidocs/CreatePrimaryKeys.sql) Fri Jun 30 06:37:39 2017 : Creating search configuration ... (CreateSearchConfiguration.sql) Fri Jun 30 06:37:39 2017 : Creating functions ... (CreateFunctions.sql) Fri Jun 30 06:37:39 2017 : Creating CAA functions ... (caa/CreateFunctions.sql) Fri Jun 30 06:37:39 2017 : Creating indexes ... (CreateIndexes.sql) Fri Jun 30 06:50:18 2017 : Creating CAA indexes ... (caa/CreateIndexes.sql) Fri Jun 30 06:50:20 2017 : Creating sitemaps indexes ... (sitemaps/CreateIndexes.sql) Fri Jun 30 06:50:20 2017 : Creating statistics indexes ... (statistics/CreateIndexes.sql) Fri Jun 30 06:51:01 2017 : Creating slave-only indexes ... (CreateSlaveIndexes.sql) Fri Jun 30 06:51:36 2017 : Setting raw initial sequence values ... (SetSequences.sql) Fri Jun 30 06:51:37 2017 : Setting raw initial statistics sequence values ... (statistics/SetSequences.sql) Fri Jun 30 06:51:37 2017 : Creating views ... (CreateViews.sql) Fri Jun 30 06:51:37 2017 : Creating CAA views ... (caa/CreateViews.sql) Fri Jun 30 06:51:37 2017 : Creating search indexes ... (CreateSearchIndexes.sql) Fri Jun 30 06:59:12 2017 : Setting up replication ... (ReplicationSetup.sql) Fri Jun 30 06:59:12 2017 : Optimizing database ... VACUUM Fri Jun 30 07:01:21 2017 : Initialized and imported data into the database. Fri Jun 30 07:01:21 2017 : InitDb.pl succeeded INITIAL IMPORT IS COMPLETE, MOVING TO NEXT PHASE waiting for server to shut down....LOG: received fast shutdown request LOG: aborting any active transactions LOG: shutting down LOG: database system is shut down done server stopped [cont-init.d] 30-initialise-database: exited 0. [cont-init.d] 35-generate_css: executing... fatal: Not a git repository (or any of the parent directories): .git fatal: Not a git repository (or any of the parent directories): .git [05:01:27] Using gulpfile /app/musicbrainz/gulpfile.js [05:01:27] Starting 'default'... [05:01:54] Finished 'default' after 28 s [cont-init.d] 35-generate_css: exited 0. [cont-init.d] 40-config: executing... [cont-init.d] 40-config: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. LOG: could not create IPv6 socket: Address family not supported by protocol LOG: could not create socket for statistics collector: Address family not supported by protocol LOG: trying another address for the statistics collector LOG: database system was shut down at 2017-06-30 07:01:22 CEST LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "musicbrainz_db.musicbrainz.dbmirror_pendingdata" ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "musicbrainz_db.musicbrainz.dbmirror_pending" ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks ERROR: constraint "dbmirror_pendingdata_SeqId" of relation "dbmirror_pendingdata" does not exist STATEMENT: ALTER TABLE dbmirror_pendingdata DROP CONSTRAINT "dbmirror_pendingdata_SeqId" CASCADE WARNING: SET TRANSACTION can only be used in transaction blocks WARNING: SET CONSTRAINTS can only be used in transaction blocks 74 Link to comment
ContainerN00b Posted August 2, 2017 Share Posted August 2, 2017 Thank you for this container. I hoped, that this will work better then the official provided (outdated) Virtual Machine. After following all the steps in https://hub.docker.com/r/linuxserver/musicbrainz/ I can't access the running container, I get only a Unable to connect Firefox can’t establish a connection to the server at 192.168.1.37:5000. I see this lines in the logfile: Quote ------------------------------------- _ _ _ | |___| (_) ___ | / __| | |/ _ \ | \__ \ | | (_) | |_|___/ |_|\___/ |_| Brought to you by linuxserver.io We gratefully accept donations at:https://www.linuxserver.io/donations/ ------------------------------------- GID/UID ------------------------------------- User uid: 1000 User gid: 1000 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 20-brainzcode: executing... [cont-init.d] 20-brainzcode: exited 0. [cont-init.d] 30-initialise-database: executing... [cont-init.d] 30-initialise-database: exited 0. [cont-init.d] 35-generate_css: executing... fatal: Not a git repository (or any of the parent directories): .git fatal: Not a git repository (or any of the parent directories): .git [13:24:44] Using gulpfile /app/musicbrainz/gulpfile.js [13:24:44] Starting 'default'... [13:25:14] Finished 'default' after 30 s [cont-init.d] 35-generate_css: exited 0. [cont-init.d] 40-config: executing... [cont-init.d] 40-config: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. LOG: database system was shut down at 2017-08-02 14:08:44 CEST LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started The container version number is: Linuxserver.io version:- 71 Build-date:- July-21-2017-11:27:46-UTC I'm sure the IP address and the port are correct. The used create-command was: sudo docker create --name=musicbrainz -p 5000:80 -e PGID=1000 -e PUID=1000 -e BRAINZCODE=longblabla -e WEBADDRESS=192.168.1.37 -e TZ="Europe/London" linuxserver/musicbrainz What do I have to change to access this local webserver? Link to comment
Hallmarc Posted August 3, 2017 Share Posted August 3, 2017 @ContainerN00b I cannot get it to work either. So frustrating...I have almost the same setup on Windows docker, with almost the exact same log file as you, down to the last line. It's unbelievable how hard it is to get this thing working and to stay working. Link to comment
sparklyballs Posted August 3, 2017 Share Posted August 3, 2017 1 hour ago, Hallmarc said: @ContainerN00b I cannot get it to work either. So frustrating...I have almost the same setup on Windows docker, with almost the exact same log file as you, down to the last line. It's unbelievable how hard it is to get this thing working and to stay working. as part of testing each new version i've installed this docker from scratch in excess of 30 times Link to comment
Hallmarc Posted August 3, 2017 Share Posted August 3, 2017 @sparklyballs I understand and I'm assuming you've been in computing for some time, just like me. As such, you know how many variables can make a system go south. I've now wiped and recreated the container with all the latest guidance and I'm waiting to see what happens. I did notice one thing that seems off in @ContainerN00b's creation parameters. Isn't the web server inside the container bound to port 5000? It seems that "-p 5000:80" would direct requests from localhost:5000 to the container's port 80. If I'm not able to get it working, I'm hoping my log files will help us troubleshoot. I'll ping again tomorrow. Thanks! Link to comment
sparklyballs Posted August 3, 2017 Share Posted August 3, 2017 3 minutes ago, Hallmarc said: @sparklyballs I understand and I'm assuming you've been in computing for some time, just like me. As such, you know how many variables can make a system go south. I've now wiped and recreated the container with all the latest guidance and I'm waiting to see what happens. I did notice one thing that seems off in @ContainerN00b's creation parameters. Isn't the web server inside the container bound to port 5000? It seems that "-p 5000:80" would direct requests from localhost:5000 to the container's port 80. If I'm not able to get it working, I'm hoping my log files will help us troubleshoot. I'll ping again tomorrow. Thanks! indeed it would as it would also appear he's not using unraid which does beg the question why he is asking for support in the unraid forum Link to comment
ContainerN00b Posted August 3, 2017 Share Posted August 3, 2017 1 hour ago, sparklyballs said: indeed it would as it would also appear he's not using unraid which does beg the question why he is asking for support in the unraid forum "...not using unraid"? I'm running VMware with ubuntu 64bit, docker and this container. Anything wrong with this configuration? Link to comment
JonathanM Posted August 3, 2017 Share Posted August 3, 2017 On 12/10/2015 at 6:39 PM, linuxserver.io said: If you are not using Unraid (and you should be!) then please do not post here, rather use the linuxserver.io forum for support. Link to comment
ContainerN00b Posted August 3, 2017 Share Posted August 3, 2017 (edited) What do you mean with "not using Unraid"? I think, I've found it: https://lime-technology.com/what-is-unraid/ I'm completely wrong here, sorry. I thought, docker containers could be used everywhere, are not bound to a specifc environment. Sorry again, my fault! Edited August 3, 2017 by ContainerN00b Link to comment
sparklyballs Posted August 3, 2017 Share Posted August 3, 2017 41 minutes ago, ContainerN00b said: What do you mean with "not using Unraid"? I think, I've found it: https://lime-technology.com/what-is-unraid/ I'm completely wrong here, sorry. I thought, docker containers could be used everywhere, are not bound to a specifc environment. Sorry again, my fault! they can but the issue is you're asking for support on a forum specifically for unraid and you're not using unraid Link to comment
Keanu Posted August 5, 2017 Share Posted August 5, 2017 Hi there, Having an issue with Musicbrainz and Headphones - I've set the musicbrainz settings under "Advanced Settings" in headphones, but whenever I search, I get this error: Quote 2017-08-05 21:53:30 WARNING Attempt to query MusicBrainz for linkin park failed (caused by: ) Any help would be appreciated! Thanks, -Keanu Link to comment
CHBMB Posted August 5, 2017 Share Posted August 5, 2017 @Keanu You're going to need to post more details for these issues buddy. Need to know how headphones is setup, how musicbrainz is setup etc etc. Otherwise we're only ever going to be shooting in the dark. Unless we know exactly what you've done setup wise, both with the docker container and then the app itself it's very difficult to pinpoint issues. Link to comment
Keanu Posted August 5, 2017 Share Posted August 5, 2017 (edited) 7 minutes ago, CHBMB said: @Keanu You're going to need to post more details for these issues buddy. Need to know how headphones is setup, how musicbrainz is setup etc etc. Otherwise we're only ever going to be shooting in the dark. Unless we know exactly what you've done setup wise, both with the docker container and then the app itself it's very difficult to pinpoint issues. Hi Again CHBMB, Apologies! Didn't think! Both the Headphones container and Musicbrainz container are located on the same server, however headphones is using it's own IP rather than bridging (For routing through VPN on PFSense) - Guide found here: So Headphones uses 192.168.1.130:8181, musicbrainz uses 192.168.1.100:5000. Headphones currently uses the musicbrainz.org site, but want to swap it over to local for speed. Hopefully that covers everything, let me know if there's any other info you might need and i'll get it to ya! Thanks, -Keanu Edited August 5, 2017 by Keanu Link to comment
Recommended Posts