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

Error 500 on Puid Submission (Not Reproducible)

XMLWordPrintable

      I got a 500 error (SQL error later) when I sent this query, although a subsequent retry has worked okay.

      Posting to urlhttp://test.musicbrainz.org/ws/2/recording/?client=Jaikoz4.0.0
      Posting body<?xml version="1.0" encoding="UTF-8" standalone="yes"?><metadata xmlns:ns2="http://musicbrainz.org/ns/ext#-2.0" xmlns="http://musicbrainz.org/ns/mmd-2.0#"><recording-list><recording id="f15ba1ae-6c5c-43e2-9516-8b9679c915be"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="1486406f-733e-44b9-86c8-c4a333dfeadc"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="64175cb9-b223-4a84-8f27-84019acbf8fb"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="523515d2-0e06-43e1-9ca5-77dc62a99bdf"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="0c6ce490-0ce6-479a-ac73-00584c8df192"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="6d14b2c9-7322-4b2b-8e7f-30224726a007"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="46b70621-ed6f-4929-9d30-0ade52b4a958"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="e9778f58-d062-49e3-aa11-a79b1542f659"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording><recording id="b9ff9cfa-58ea-4113-bcbe-085ee7ade386"><puid-list><puid id="6d14b2c9-7322-4b2b-8e7f-30224726a007"/></puid-list></recording></recording-list></metadata>
      INFO [Thread-12] (AuthChallengeProcessor.java:100) - Digest authentication scheme selected
      Getting:500

      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
      <head>
      <meta http-equiv="Content-Language" content="en" />
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
      <title>MusicBrainz::Server on Catalyst 5.80029</title>
      <script type="text/javascript">
      <!--
      function toggleDump (dumpElement) {
      var e = document.getElementById( dumpElement );
      if (e.style.display == "none")

      { e.style.display = ""; }

      else

      { e.style.display = "none"; }

      }
      -->
      </script>
      <style type="text/css">
      body

      { font-family: "Bitstream Vera Sans", "Trebuchet MS", Verdana, Tahoma, Arial, helvetica, sans-serif; color: #333; background-color: #eee; margin: 0px; padding: 0px; }

      :link, :link:hover, :visited, :visited:hover

      { color: #000; }

      div.box

      { position: relative; background-color: #ccc; border: 1px solid #aaa; padding: 4px; margin: 10px; }

      div.error

      { background-color: #cce; border: 1px solid #755; padding: 8px; margin: 4px; margin-bottom: 10px; }

      div.infos

      { background-color: #eee; border: 1px solid #575; padding: 8px; margin: 4px; margin-bottom: 10px; }

      div.name

      { background-color: #cce; border: 1px solid #557; padding: 8px; margin: 4px; }

      code.error

      { display: block; margin: 1em 0; overflow: auto; }

      div.name h1, div.error p

      { margin: 0; }

      h2

      { margin-top: 0; margin-bottom: 10px; font-size: medium; font-weight: bold; text-decoration: underline; }

      h1

      { font-size: medium; font-weight: normal; }

      /* from http://users.tkk.fi/~tkarvine/linux/doc/pre-wrap/pre-wrap-css3-mozilla-opera-ie.html */
      /* Browser specific (not valid) styles to make preformatted text wrap */
      pre

      { white-space: pre-wrap; /* css-3 */ white-space: -moz-pre-wrap; /* Mozilla, since 1999 */ white-space: -pre-wrap; /* Opera 4-6 */ white-space: -o-pre-wrap; /* Opera 7 */ word-wrap: break-word; /* Internet Explorer 5.5+ */ }

      </style>
      </head>
      <body>
      <div class="box">
      <div class="error"><pre wrap=""><p><code class="error">Caught exception in MusicBrainz::Server::Controller::WS::2::Recording->recording_submit "Failed query:
      'UPDATE editor SET edits_failed = edits_failed + 1 WHERE id = ?'
      (395064)
      DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 103.

      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 109

            acid2 Oliver Charles
            ijabz Paul Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                NGS - Release Candidate 2