[OPEN-ILS-DEV] Error when creating items

[Robert Nix]

Bill,

    I was able to locate the postgresql log and this is the error that I
found:

2008-03-12 14:22:10 UTC LOG:  autovacuum: processing database "postgres"
2008-03-12 14:22:56 UTC WARNING:  there is no transaction in progress
2008-03-12 14:23:01 UTC ERROR:  insert or update on table "copy" violates
foreign key constraint "copy_location_fkey"
2008-03-12 14:23:01 UTC DETAIL:  Key (location)=(1) is not present in table
"copy_location".
2008-03-12 14:23:07 UTC WARNING:  there is no transaction in progress

It looks like it doesn't want us to copy from the table but I can't be sure.
What would be the next step?

On Tue, Mar 11, 2008 at 5:48 PM, Bill Erickson <erickson at esilibrary.com>
wrote:

> Robert Nix wrote:
> > Bill,
> >
> >   I have looked at the log and it seems to show that there is an error
> > committing transactions with multiple modules. This could be from the
> > initial module that fails to commit the transaction. I am attaching a
> > copy of the osrfsys.log file. I took a sample from initial logon to exit
> > so the actual error is at the bottom of the file but I just wanted to
> > show that it was up and running and is able to interact with the client.
> > Any help on the subject would be greatly appreciated.
>
> So, you were able to create the copy OK:
>
> -> editor[1|1] created a new asset.copy object with ID 32
>
> but the database commit failed:
>
> -> open-ils.cstore: Error committing transaction
>
> My next stop would be the Postgres logs.  It should provide some
> SQL-level error message that sheds light on the commit failure.  I don't
> recall offhand, however, where those logs are by default.
>
> -bill
>
>
> --
> Bill Erickson
> | VP, Software Development & Integration
> | Equinox Software, Inc. / The Evergreen Experts
> | phone: 877-OPEN-ILS (673-6457)
> | email: erickson at esilibrary.com
> | web: http://esilibrary.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080312/98915ff5/attachment-0001.html