[GeoNetwork-users] Frequent errors on adding metadata

Hello,

After creating an automated install for GeoNetwork on my company's system, I
am seeing this issue intermittently when adding the sample metadata. I'm
not sure if this is related to your metadata editing problem. However, it
does produce an HTTP 500 error upon adding metadata after some successive
quick form requests.

It does not happen every time, however, I can reproduce it approximately 1-2
times out of every 5. I managed to get an error log for when it fails. It
appears to be an exception with the mckoi database:

(C) Exc : com.mckoi.database.jdbc.MSQLException: Deferred primary Key
constraint violation (_ANONYMOUS_CONSTRAINT_42) Columns = ( id ) Table = (
APP.Metadata )

Please see the full logfile here: http://pastebin.com/g6m8nftr

James Cuzella
Junior Systems Administrator
Standing Cloud, Inc.
(303) 747-3844 x 907
(720) 663-9731
james.cuzella@anonymised.com
http://www.standingcloud.com/

Hi James,

Could be that you adding a metadata record with same 'id' (uuid)
<fileIdentifier> as before. The database would complain as the
uuid is a primary key.

Andrew
----- Original Message ----- From: "James Cuzella" <james.cuzella@anonymised.com>
To: <geonetwork-users@lists.sourceforge.net>
Sent: Thursday, May 05, 2011 2:46 AM
Subject: Re: [GeoNetwork-users] Frequent errors on adding metadata

Hello,

After creating an automated install for GeoNetwork on my company's system, I
am seeing this issue intermittently when adding the sample metadata. I'm
not sure if this is related to your metadata editing problem. However, it
does produce an HTTP 500 error upon adding metadata after some successive
quick form requests.

It does not happen every time, however, I can reproduce it approximately 1-2
times out of every 5. I managed to get an error log for when it fails. It
appears to be an exception with the mckoi database:

(C) Exc : com.mckoi.database.jdbc.MSQLException: Deferred primary Key
constraint violation (_ANONYMOUS_CONSTRAINT_42) Columns = ( id ) Table = (
APP.Metadata )

Please see the full logfile here: http://pastebin.com/g6m8nftr

James Cuzella
Junior Systems Administrator
Standing Cloud, Inc.
(303) 747-3844 x 907
(720) 663-9731
james.cuzella@anonymised.com
http://www.standingcloud.com/
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Hi James,

Copying your response back onto the users list
so others may be able to help with this issue.

Andrew
  ----- Original Message -----
  From: James Cuzella
  To: andrew walsh
  Sent: Thursday, May 05, 2011 12:28 PM
  Subject: Re: [GeoNetwork-users] Frequent errors on adding metadata

  This happens on a clean install, when simulating a click on the 'Add sample metadata' button from the Administration page. This is only done once, and I'm assuming that a fresh install would ensure that there are no used uuid's already in the database.

  I thought it may be due to making requests in quick succession, so I also tried adding a 10 second wait before adding the sample data. However, it still sometimes fails with that error.

  James Cuzella
  Junior Systems Administrator
  Standing Cloud, Inc.
  (303) 747-3844 x 907

  (720) 663-9731
  james.cuzella@anonymised.com
  http://www.standingcloud.com/

  On Wed, May 4, 2011 at 7:02 PM, andrew walsh <awalsh@anonymised.com> wrote:

    Hi James,

    Could be that you adding a metadata record with same 'id' (uuid)
    <fileIdentifier> as before. The database would complain as the
    uuid is a primary key.

    Andrew
    ----- Original Message ----- From: "James Cuzella" <james.cuzella@anonymised.com4...>
    To: <geonetwork-users@lists.sourceforge.net>
    Sent: Thursday, May 05, 2011 2:46 AM
    Subject: Re: [GeoNetwork-users] Frequent errors on adding metadata

      Hello,

      After creating an automated install for GeoNetwork on my company's system, I
      am seeing this issue intermittently when adding the sample metadata. I'm
      not sure if this is related to your metadata editing problem. However, it
      does produce an HTTP 500 error upon adding metadata after some successive
      quick form requests.

      It does not happen every time, however, I can reproduce it approximately 1-2
      times out of every 5. I managed to get an error log for when it fails. It
      appears to be an exception with the mckoi database:

      (C) Exc : com.mckoi.database.jdbc.MSQLException: Deferred primary Key
      constraint violation (_ANONYMOUS_CONSTRAINT_42) Columns = ( id ) Table = (
      APP.Metadata )

      Please see the full logfile here: http://pastebin.com/g6m8nftr

      James Cuzella
      Junior Systems Administrator
      Standing Cloud, Inc.
      (303) 747-3844 x 907
      (720) 663-9731
      james.cuzella@anonymised.com
      http://www.standingcloud.com/

      ------------------------------------------------------------------------------
      WhatsUp Gold - Download Free Network Management Software
      The most intuitive, comprehensive, and cost-effective network
      management toolset available today. Delivers lowest initial
      acquisition cost and overall TCO of any competing solution.
      http://p.sf.net/sfu/whatsupgold-sd
      _______________________________________________
      GeoNetwork-users mailing list
      GeoNetwork-users@lists.sourceforge.net
      https://lists.sourceforge.net/lists/listinfo/geonetwork-users
      GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork