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

Database query / insert statement not working

XMLWordPrintable

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

      An error occurred: Failed query:
          'INSERT INTO edit_data (data,edit) VALUES (?,?)'
          ({"entity_id":6543210,"entity1":

      Unknown macro: {"id"}

      ,"link_type":{"link_phrase":"

      Unknown macro: {live}

      {medley:medley including a} {partial} {instrumental} {cover} {karaoke} recording of","reverse_link_phrase":"{live} {medley:medleys including} {partial} {instrumental} {cover} {karaoke} recordings","name":"performance","long_link_phrase":"is a {live} {medley:medley including a} {partial} {instrumental} {cover} {karaoke} recording of","id":278},"attributes":[{"type":{"root":

      Unknown macro: {"id"}

      ,"gid":"1e8536bd-6eda-3822-8e78-1c0f4d3d2113","name":"cover","id":567}}],"type0":"recording","type1":"work","ended":0,"entity0":{"id":36135145,"name":"DNA狂詩曲","gid":"19d11095-4d07-4f50-8959-0740f4652664"},"edit_version":2} 104353535)
      57014 DBD::Pg::st execute failed: ERROR:  canceling statement due to statement timeout [for Statement "INSERT INTO edit_data (data,edit) VALUES (?,?)" with ParamValues: 1='{"entity_id":6543210,"entity1":

      Unknown macro: {"id"}

      ,"link_type":{"link_phrase":"

      {medley:medley including a} {partial} {instrumental} {cover} {karaoke} recording of","reverse_link_phrase":"{live} {medley:medleys including} {partial} {instrumental} {cover} {karaoke} recordings","name":"performance","long_link_phrase":"is a {live} {medley:medley including a} {partial} {instrumental} {cover} {karaoke} recording of","id":278},"attributes":[{"type":{"root":

      Unknown macro: {"id"}

      ,"gid":"1e8536bd-6eda-3822-8e78-1c0f4d3d2113","name":"cover","id":567}}],"type0":"recording","type1":"work","ended":0,"entity0":{"id":36135145,"name":"DNA�.詩�.�","gid":"19d11095-4d07-4f50-8959-0740f4652664"},"edit_version":2}', 2='104353535']
       at lib/Sql.pm line 123.
          Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError::StatementTimedOut=HASH(0x559a0fcd7838)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123
          Try::Tiny::try(CODE(0x559a0fcd05a8), Try::Tiny::Catch=REF(0x559a0fcd8df8)) called at lib/Sql.pm line 124
          Sql::do(Sql=HASH(0x559a0f61cae0), "INSERT INTO edit_data (data,edit) VALUES (?,?)", "{\"entity_id\":6543210,\"entity1\":{\"id\":12482427,\"name\":\"DNA\x

      Unknown macro: {72c2}

      \x{8a69}\x{66f2}\""..., 104353535) called at lib/Sql.pm line 163
          Sql::insert_row(Sql=HASH(0x559a0f61cae0), "edit_data", HASH(0x559a0fcd0338)) called at lib/MusicBrainz/Server/Data/Edit.pm line 596
          MusicBrainz::Server::Data::Edit::create(MusicBrainz::Server::Data::Edit=HASH(0x559a03fa08d0), "entity0_credit", "", "begin_date", undef, "entity1_credit", "", "ended", ...) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 667
          MusicBrainz::Server::Controller::WS::js::Edit::try {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
          eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
          Try::Tiny::try(CODE(0x559a0fcc8530), Try::Tiny::Catch=REF(0x559a0fcd43c0)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 685
          MusicBrainz::Server::Controller::WS::js::Edit::create_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358), HASH(0x559a0e306b40)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 747
          MusicBrainz::Server::Controller::WS::js::Edit::_ANON_() called at lib/Sql.pm line 335
          Sql::try {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
          eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
          Try::Tiny::try(CODE(0x559a0e94ef60), Try::Tiny::Catch=REF(0x559a0f47e820)) called at lib/Sql.pm line 348
          Sql::_auto_transaction(CODE(0x559a0f519650), Sql=HASH(0x559a0f61cae0)) called at lib/Sql.pm line 353
          Sql::_run_in_transaction_one(CODE(0x559a0f519650), Sql=HASH(0x559a0f61cae0)) called at lib/Sql.pm line 368
          Sql::run_in_transaction(CODE(0x559a0f519650), Sql=HASH(0x559a0f61cae0)) called at lib/MusicBrainz/Server/Model/MB.pm line 20
          MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x559a03854c08), CODE(0x559a0f519650)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 758
          MusicBrainz::Server::Controller::WS::js::Edit::submit_edits(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358), HASH(0x559a0e306b40)) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 717
          MusicBrainz::Server::Controller::WS::js::Edit::create(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374
          Catalyst::Action::execute(Catalyst::Action=HASH(0x559a06521f40), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          Catalyst::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a06521f40)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
          Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a06521f40)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368
          Catalyst::Action::dispatch(Catalyst::Action=HASH(0x559a06521f40), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 46
          Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x559a0f463648), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170
          Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374
          Catalyst::Action::execute(Catalyst::Action=HASH(0x559a065215c8), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          Catalyst::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a065215c8)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
          Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a065215c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368
          Catalyst::Action::dispatch(Catalyst::Action=HASH(0x559a065215c8), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
          Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x5599f8bfc668), "forward", MusicBrainz::Server=HASH(0x559a0f33d358), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
          Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x5599f8bfc668), MusicBrainz::Server=HASH(0x559a0f33d358), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 489
          Catalyst::forward(MusicBrainz::Server=HASH(0x559a0f33d358), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134
          Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 374
          Catalyst::Action::execute(Catalyst::Action=HASH(0x559a0651d750), MusicBrainz::Server::Controller::WS::js::Edit=HASH(0x559a06050410), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          eval {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2067
          Catalyst::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a0651d750)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
          Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x559a0f33d358), "MusicBrainz::Server::Controller::WS::js::Edit", Catalyst::Action=HASH(0x559a0651d750)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 368
          Catalyst::Action::dispatch(Catalyst::Action=HASH(0x559a0651d750), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
          Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x5599f8bfc668), "forward", MusicBrainz::Server=HASH(0x559a0f33d358), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
          Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x5599f8bfc668), MusicBrainz::Server=HASH(0x559a0f33d358), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 489
          Catalyst::forward(MusicBrainz::Server=HASH(0x559a0f33d358), "/ws/js/edit/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107
          Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x5599f8bfc668), MusicBrainz::Server=HASH(0x559a0f33d358)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2013
          Catalyst::dispatch(MusicBrainz::Server=HASH(0x559a0f33d358)) called at lib/MusicBrainz/Server.pm line 391
          MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 356
          MusicBrainz::Server

            Unassigned Unassigned
            yindesu yindesu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package