Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-12391

new row for relation "artist" violates check constraint "artist_comment_check"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • None
    • None
    • Edit system
    • None

      Imported a release from Bandcamp through import userscript.
      When creating a new artist via release editor it first didn't let me submit the edit (button deactivated) which I overcame by simply adding a space to the name. (this has happened before a couple times but no ISE ).

      The edit could not be created. Exception (MusicBrainz::Server::Exceptions::DatabaseError): 23514 DBD::Pg::st execute failed: ERROR:  new row for relation "artist" violates check constraint "artist_comment_check"
      DETAIL:  Failing row contains (2338794, 67430084-4c35-48ba-ae30-c411339fa30a, K4000, K4000, null, null, null, null, null, null, null, null, null,  , 0, 2022-05-18 23:06:12.251917+00, f, null, null). [for Statement "INSERT INTO artist (name,comment,gid,gender,end_area,end_date_day,end_date_month,type,begin_date_year,ended,begin_area,area,end_date_year,begin_date_day,sort_name,begin_date_month) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) RETURNING id" with ParamValues: 1='K4000', 2=' ', 3='67430084-4c35-48ba-ae30-c411339fa30a', 4=undef, 5=undef, 6=undef, 7=undef, 8=undef, 9=undef, 10='0', 11=undef, 12=undef, 13=undef, 14=undef, 15='K4000', 16=undef] at lib/MusicBrainz/Server/Controller.pm line 82. at lib/MusicBrainz/Server/Controller.pm line 80
      Try::Tiny::try(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 82
      MusicBrainz::Server::Controller::_insert_edit(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, undef, ?, undef, ?, undef, ?, undef, ?, undef, ?, ?, ?, ?, ?, undef, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller.pm line 172
      Sql::run_in_transaction(?, ?) called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 186
      MusicBrainz::Server::Controller::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 342
      MusicBrainz::Server::Controller::Artist::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/Create.pm line 82
      Catalyst::forward(?, ?, ?) called at lib/MusicBrainz/Server/Controller/Dialog.pm line 16
      Catalyst::dispatch(?) called at lib/MusicBrainz/Server.pm line 388
      MusicBrainz::Server::__ANON__ at lib/MusicBrainz/Server.pm line 353
      MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 389
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 403
      Class::MOP::Method::Wrapped::__ANON__(?) called at lib/MusicBrainz/Server.pm line 488
      Time: 2022-05-18T23:06:12.482Z
      
      Host: cc1cbe8a4223
      
      Interface language: en
      
      URL: https://musicbrainz.org/dialog?path=%2Fartist%2Fcreate
      
      Request data:
      
      {
        "body_parameters": {
          "edit-artist.period.begin_date.year": "",
          "edit-artist.begin_area.name": "",
          "edit-artist.url.0.period.ended": "0",
          "edit-artist.sort_name": "K4000",
          "edit-artist.area_id": "",
          "edit-artist.ipi_codes.0": "",
          "edit-artist.begin_area_id": "",
          "edit-artist.end_area_id": "",
          "edit-artist.area.gid": "",
          "edit-artist.period.begin_date.day": "",
          "edit-artist.period.end_date.year": "",
          "edit-artist.period.end_date.month": "",
          "edit-artist.isni_codes.0": "",
          "edit-artist.url.0.period.end_date.year": "",
          "edit-artist.period.end_date.day": "",
          "edit-artist.type_id": " ",
          "edit-artist.name": "K4000 ",
          "edit-artist.gender_id": " ",
          "edit-artist.comment": " ",
          "edit-artist.end_area.name": "",
          "edit-artist.end_area.gid": "",
          "edit-artist.url.0.period.end_date.month": "",
          "edit-artist.edit_note": " ",
          "edit-artist.period.begin_date.month": "",
          "edit-artist.url.0.period.begin_date.month": "",
          "edit-artist.area.name": "",
          "edit-artist.url.0.period.begin_date.day": "",
          "edit-artist.url.0.period.begin_date.year": "",
          "edit-artist.url.0.text": "https://soundcloud.com/k4000",
          "edit-artist.url.0.period.end_date.day": "",
          "edit-artist.begin_area.gid": "",
          "edit-artist.url.0.link_type_id": "291"
        },
        "query_parameters": {
          "path": "/artist/create"
        }
      }
      
      

            chaban chaban
            chaban chaban
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package