elliotchance / mbzdb

🎵 Port of the MusicBrainz database to run on other RDBMSs with replication (previously named MB_MySQL.)
88 stars 33 forks source link

Init results in massive amount of errors #60

Open Enverex opened 11 years ago

Enverex commented 11 years ago

I'm not sure if these can be ignored, but I have the user and DB created, but running the init script (and selecting yes) results in the following (using Postgres):

Ready to proceed? (it may take over 24 hours for this script to fully complete) (y/n): y NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "kv_pkey" for table "kv" Downloading schema... Done Table annotation NOTICE: ALTER TABLE will create implicit sequence "annotation_id_seq" for serial column "annotation.id" Table artist NOTICE: ALTER TABLE will create implicit sequence "artist_id_seq" for serial column "artist.id" DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "artist" ADD "(" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NOT NULL OR ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "artist" ADD ")" OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "AND" LINE 1: ALTER TABLE "artist" ADD "(end_date_year" IS NULL AND ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "artist" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "artist" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table artist_alias_type NOTICE: ALTER TABLE will create implicit sequence "artist_alias_type_id_seq" for serial column "artist_alias_type.id" Table artist_alias NOTICE: ALTER TABLE will create implicit sequence "artist_alias_id_seq" for serial column "artist_alias.id" DBD::Pg::db do failed: ERROR: syntax error at or near "<>" LINE 1: ALTER TABLE "artist_alias" ADD "(type" <> 3) OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "artist_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "artist_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table artist_annotation Table artist_ipi Table artist_meta Table artist_tag Table artist_rating_raw Table artist_tag_raw Table artist_credit NOTICE: ALTER TABLE will create implicit sequence "artist_credit_id_seq" for serial column "artist_credit.id" Table artist_credit_name Table artist_gid_redirect Table artist_name NOTICE: ALTER TABLE will create implicit sequence "artist_name_id_seq" for serial column "artist_name.id" Table artist_type NOTICE: ALTER TABLE will create implicit sequence "artist_type_id_seq" for serial column "artist_type.id" Table autoeditor_election NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_id_seq" for serial column "autoeditor_election.id" Table autoeditor_election_vote NOTICE: ALTER TABLE will create implicit sequence "autoeditor_election_vote_id_seq" for serial column "autoeditor_election_vote.id" Table cdtoc NOTICE: ALTER TABLE will create implicit sequence "cdtoc_id_seq" for serial column "cdtoc.id" Table cdtoc_raw NOTICE: ALTER TABLE will create implicit sequence "cdtoc_raw_id_seq" for serial column "cdtoc_raw.id" Table clientversion NOTICE: ALTER TABLE will create implicit sequence "clientversion_id_seq" for serial column "clientversion.id" Table country NOTICE: ALTER TABLE will create implicit sequence "country_id_seq" for serial column "country.id" Table edit NOTICE: ALTER TABLE will create implicit sequence "edit_id_seq" for serial column "edit.id" Table edit_note NOTICE: ALTER TABLE will create implicit sequence "edit_note_id_seq" for serial column "edit_note.id" Table edit_artist Table edit_label Table edit_release Table edit_release_group Table edit_recording Table edit_work Table edit_url Table editor NOTICE: ALTER TABLE will create implicit sequence "editor_id_seq" for serial column "editor.id" Table editor_language DBD::Pg::db do failed: ERROR: type "fluency" does not exist LINE 1: ALTER TABLE "editor_language" ADD "fluency" FLUENCY NOT NULL ^ at backend/postgresql.pl line 184, line 1410. Table editor_preference NOTICE: ALTER TABLE will create implicit sequence "editor_preference_id_seq" for serial column "editor_preference.id" Table editor_subscribe_artist NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_artist_id_seq" for serial column "editor_subscribe_artist.id" Table editor_subscribe_label NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_label_id_seq" for serial column "editor_subscribe_label.id" Table editor_subscribe_editor NOTICE: ALTER TABLE will create implicit sequence "editor_subscribe_editor_id_seq" for serial column "editor_subscribe_editor.id" Table gender NOTICE: ALTER TABLE will create implicit sequence "gender_id_seq" for serial column "gender.id" Table isrc NOTICE: ALTER TABLE will create implicit sequence "isrc_id_seq" for serial column "isrc.id" Table iswc NOTICE: ALTER TABLE will create implicit sequence "iswc_id_seq" for serial column "iswc.id" Table l_artist_artist NOTICE: ALTER TABLE will create implicit sequence "l_artist_artist_id_seq" for serial column "l_artist_artist.id" Table l_artist_label NOTICE: ALTER TABLE will create implicit sequence "l_artist_label_id_seq" for serial column "l_artist_label.id" Table l_artist_recording NOTICE: ALTER TABLE will create implicit sequence "l_artist_recording_id_seq" for serial column "l_artist_recording.id" Table l_artist_release NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_id_seq" for serial column "l_artist_release.id" Table l_artist_release_group NOTICE: ALTER TABLE will create implicit sequence "l_artist_release_group_id_seq" for serial column "l_artist_release_group.id" Table l_artist_url NOTICE: ALTER TABLE will create implicit sequence "l_artist_url_id_seq" for serial column "l_artist_url.id" Table l_artist_work NOTICE: ALTER TABLE will create implicit sequence "l_artist_work_id_seq" for serial column "l_artist_work.id" Table l_label_label NOTICE: ALTER TABLE will create implicit sequence "l_label_label_id_seq" for serial column "l_label_label.id" Table l_label_recording NOTICE: ALTER TABLE will create implicit sequence "l_label_recording_id_seq" for serial column "l_label_recording.id" Table l_label_release NOTICE: ALTER TABLE will create implicit sequence "l_label_release_id_seq" for serial column "l_label_release.id" Table l_label_release_group NOTICE: ALTER TABLE will create implicit sequence "l_label_release_group_id_seq" for serial column "l_label_release_group.id" Table l_label_url NOTICE: ALTER TABLE will create implicit sequence "l_label_url_id_seq" for serial column "l_label_url.id" Table l_label_work NOTICE: ALTER TABLE will create implicit sequence "l_label_work_id_seq" for serial column "l_label_work.id" Table l_recording_recording NOTICE: ALTER TABLE will create implicit sequence "l_recording_recording_id_seq" for serial column "l_recording_recording.id" Table l_recording_release NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_id_seq" for serial column "l_recording_release.id" Table l_recording_release_group NOTICE: ALTER TABLE will create implicit sequence "l_recording_release_group_id_seq" for serial column "l_recording_release_group.id" Table l_recording_url NOTICE: ALTER TABLE will create implicit sequence "l_recording_url_id_seq" for serial column "l_recording_url.id" Table l_recording_work NOTICE: ALTER TABLE will create implicit sequence "l_recording_work_id_seq" for serial column "l_recording_work.id" Table l_release_release NOTICE: ALTER TABLE will create implicit sequence "l_release_release_id_seq" for serial column "l_release_release.id" Table l_release_release_group NOTICE: ALTER TABLE will create implicit sequence "l_release_release_group_id_seq" for serial column "l_release_release_group.id" Table l_release_url NOTICE: ALTER TABLE will create implicit sequence "l_release_url_id_seq" for serial column "l_release_url.id" Table l_release_work NOTICE: ALTER TABLE will create implicit sequence "l_release_work_id_seq" for serial column "l_release_work.id" Table l_release_group_release_group NOTICE: ALTER TABLE will create implicit sequence "l_release_group_release_group_id_seq" for serial column "l_release_group_release_group.id" Table l_release_group_url NOTICE: ALTER TABLE will create implicit sequence "l_release_group_url_id_seq" for serial column "l_release_group_url.id" Table l_release_group_work NOTICE: ALTER TABLE will create implicit sequence "l_release_group_work_id_seq" for serial column "l_release_group_work.id" Table l_url_url NOTICE: ALTER TABLE will create implicit sequence "l_url_url_id_seq" for serial column "l_url_url.id" Table l_url_work NOTICE: ALTER TABLE will create implicit sequence "l_url_work_id_seq" for serial column "l_url_work.id" Table l_work_work NOTICE: ALTER TABLE will create implicit sequence "l_work_work_id_seq" for serial column "l_work_work.id" Table label NOTICE: ALTER TABLE will create implicit sequence "label_id_seq" for serial column "label.id" DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "label" ADD "(" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NOT NULL OR ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "label" ADD ")" OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "AND" LINE 1: ALTER TABLE "label" ADD "(end_date_year" IS NULL AND ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "label" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "label" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table label_rating_raw Table label_tag_raw Table label_alias_type NOTICE: ALTER TABLE will create implicit sequence "label_alias_type_id_seq" for serial column "label_alias_type.id" Table label_alias NOTICE: ALTER TABLE will create implicit sequence "label_alias_id_seq" for serial column "label_alias.id" DBD::Pg::db do failed: ERROR: syntax error at or near "<>" LINE 1: ALTER TABLE "label_alias" ADD "(type" <> 2) OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "label_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "label_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table label_annotation Table label_ipi Table label_meta Table label_gid_redirect Table label_name NOTICE: ALTER TABLE will create implicit sequence "label_name_id_seq" for serial column "label_name.id" Table label_tag Table label_type NOTICE: ALTER TABLE will create implicit sequence "label_type_id_seq" for serial column "label_type.id" Table language NOTICE: ALTER TABLE will create implicit sequence "language_id_seq" for serial column "language.id" DBD::Pg::db do failed: ERROR: syntax error at or near "CONSTRAINT" LINE 1: ALTER TABLE "language" ADD "ADD" CONSTRAINT iso_code_check ^ at backend/postgresql.pl line 184, line 1410. Table link NOTICE: ALTER TABLE will create implicit sequence "link_id_seq" for serial column "link.id" DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "link" ADD "(" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NOT NULL OR ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "OR" LINE 1: ALTER TABLE "link" ADD ")" OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at or near "AND" LINE 1: ALTER TABLE "link" ADD "(end_date_year" IS NULL AND ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "link" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "link" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table link_attribute Table link_attribute_type NOTICE: ALTER TABLE will create implicit sequence "link_attribute_type_id_seq" for serial column "link_attribute_type.id" Table link_type NOTICE: ALTER TABLE will create implicit sequence "link_type_id_seq" for serial column "link_type.id" Table link_type_attribute_type Table editor_collection NOTICE: ALTER TABLE will create implicit sequence "editor_collection_id_seq" for serial column "editor_collection.id" Table editor_collection_release Table editor_watch_preferences Table editor_watch_artist Table editor_watch_release_group_type Table editor_watch_release_status Table medium NOTICE: ALTER TABLE will create implicit sequence "medium_id_seq" for serial column "medium.id" Table medium_cdtoc NOTICE: ALTER TABLE will create implicit sequence "medium_cdtoc_id_seq" for serial column "medium_cdtoc.id" Table medium_format NOTICE: ALTER TABLE will create implicit sequence "medium_format_id_seq" for serial column "medium_format.id" Table puid NOTICE: ALTER TABLE will create implicit sequence "puid_id_seq" for serial column "puid.id" Table replication_control NOTICE: ALTER TABLE will create implicit sequence "replication_control_id_seq" for serial column "replication_control.id" Table recording NOTICE: ALTER TABLE will create implicit sequence "recording_id_seq" for serial column "recording.id" Table recording_rating_raw Table recording_tag_raw Table recording_annotation Table recording_meta Table recording_gid_redirect Table recording_puid NOTICE: ALTER TABLE will create implicit sequence "recording_puid_id_seq" for serial column "recording_puid.id" Table recording_tag Table release NOTICE: ALTER TABLE will create implicit sequence "release_id_seq" for serial column "release.id" Table release_raw NOTICE: ALTER TABLE will create implicit sequence "release_raw_id_seq" for serial column "release_raw.id" Table release_tag_raw Table release_annotation Table release_gid_redirect Table release_meta DBD::Pg::db do failed: ERROR: type "cover_art_presence" does not exist LINE 1: ...TER TABLE "release_meta" ADD "cover_art_presence" coverart... ^ at backend/postgresql.pl line 184, line 1410. Table release_coverart Table release_label NOTICE: ALTER TABLE will create implicit sequence "release_label_id_seq" for serial column "release_label.id" Table release_packaging NOTICE: ALTER TABLE will create implicit sequence "release_packaging_id_seq" for serial column "release_packaging.id" Table release_status NOTICE: ALTER TABLE will create implicit sequence "release_status_id_seq" for serial column "release_status.id" Table release_tag Table release_group NOTICE: ALTER TABLE will create implicit sequence "release_group_id_seq" for serial column "release_group.id" Table release_group_rating_raw Table release_group_tag_raw Table release_group_annotation Table release_group_gid_redirect Table release_group_meta Table release_group_tag Table release_group_primary_type NOTICE: ALTER TABLE will create implicit sequence "release_group_primary_type_id_seq" for serial column "release_group_primary_type.id" Table release_group_secondary_type NOTICE: ALTER TABLE will create implicit sequence "release_group_secondary_type_id_seq" for serial column "release_group_secondary_type.id" Table release_group_secondary_type_join Table release_name NOTICE: ALTER TABLE will create implicit sequence "release_name_id_seq" for serial column "release_name.id" Table script NOTICE: ALTER TABLE will create implicit sequence "script_id_seq" for serial column "script.id" Table script_language NOTICE: ALTER TABLE will create implicit sequence "script_language_id_seq" for serial column "script_language.id" Table tag NOTICE: ALTER TABLE will create implicit sequence "tag_id_seq" for serial column "tag.id" Table tag_relation Table track NOTICE: ALTER TABLE will create implicit sequence "track_id_seq" for serial column "track.id" Table track_raw NOTICE: ALTER TABLE will create implicit sequence "track_raw_id_seq" for serial column "track_raw.id" Table track_name NOTICE: ALTER TABLE will create implicit sequence "track_name_id_seq" for serial column "track_name.id" Table tracklist NOTICE: ALTER TABLE will create implicit sequence "tracklist_id_seq" for serial column "tracklist.id" Table tracklist_index Table url NOTICE: ALTER TABLE will create implicit sequence "url_id_seq" for serial column "url.id" Table url_gid_redirect Table vote NOTICE: ALTER TABLE will create implicit sequence "vote_id_seq" for serial column "vote.id" Table work NOTICE: ALTER TABLE will create implicit sequence "work_id_seq" for serial column "work.id" Table work_rating_raw Table work_tag_raw Table work_alias_type NOTICE: ALTER TABLE will create implicit sequence "work_alias_type_id_seq" for serial column "work_alias_type.id" Table work_alias NOTICE: ALTER TABLE will create implicit sequence "work_alias_id_seq" for serial column "work_alias.id" DBD::Pg::db do failed: ERROR: syntax error at or near "<>" LINE 1: ALTER TABLE "work_alias" ADD "(type" <> 2) OR ( ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "work_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. DBD::Pg::db do failed: ERROR: syntax error at end of input LINE 1: ALTER TABLE "work_alias" ADD ")" ^ at backend/postgresql.pl line 184, line 1410. Table work_annotation Table work_gid_redirect Table work_meta Table work_name NOTICE: ALTER TABLE will create implicit sequence "work_name_id_seq" for serial column "work_name.id" Table work_tag Table work_type NOTICE: ALTER TABLE will create implicit sequence "work_type_id_seq" for serial column "work_type.id" Table dbmirror_Pending NOTICE: ALTER TABLE will create implicit sequence "dbmirror_Pending_SeqId_seq" for serial column "dbmirror_Pending.SeqId" Table dbmirror_PendingData Logging into MusicBrainz FTP (ftp.musicbrainz.org)...