[OPEN-ILS-DEV] Error when creating items

Thu Mar 13 13:46:55 EDT 2008

On Thu, Mar 13, 2008 at 9:55 AM, Robert Nix <glibrarysystem at gmail.com> wrote:
> Hi Mike,
>
>   Ok I tried to check out an item and this is the postgresql log that I got
> from the error:
>
[snip]
>
> Is this an issue due to an incomplete database? Should I just reload
> evergreen and start over?
>

These errors you /can/ ignore.  There are some example views that are
not created by default, but the definitions do exist in the IDL file,
so the storage backend is looking for them in the database.

--miker

>
>
> On Wed, Mar 12, 2008 at 3:04 PM, Mike Rylander <mrylander at gmail.com> wrote:
> >
> > On Wed, Mar 12, 2008 at 1:29 PM, Robert Nix <glibrarysystem at gmail.com>
> wrote:
> > > Mike,
> > >
> > > When I am entering in the new information for the copy it will not let
> me
> > > add a shelf location. The location has three question marks in it ???
> and
> > > when I click the box to change it there is no text box that comes up
> like
> > > the rest of the fields. Do I need to go into the postgresql and add the
> row
> > > back in there manually or is there another way to do it? Is there a file
> I
> > > can download like a sql file that can rebuild the database? I don't have
> any
> > > real information in it yet and I want to make sure that there are no
> other
> > > problems with the database itself before I continue so this would be the
> > > desireable direction to move in for me.
> > >
> >
> > >From the Admin menu there is a Local Administration option.  On that
> > interface there is a Copy Locations editor.  You can use that to add
> > shelving locations to any part of the hierarchy that you have access
> > to.
> >
> > However, it's disturbing that you have no shelving locations by
> > default.  Stacks is installed by default and is attached to the top of
> > the organizational hierarchy, and should be available to any staff
> > member account, so I'm wondering why this went away.  Did you see any
> > SQL errors other than SCHEMA DOES NOT EXIST during installation?
> >
> > --miker
> >
> >
> >
> >
> > >
> > >
> > > On Wed, Mar 12, 2008 at 12:52 PM, Mike Rylander <mrylander at gmail.com>
> wrote:
> > >
> > > >
> > > > On Wed, Mar 12, 2008 at 10:37 AM, Robert Nix
> <glibrarysystem at gmail.com>
> > > wrote:
> > > > > 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?
> > > > >
> > > >
> > > > It looks like the shelving location "Stacks", which is inserted by
> > > > default during installation, has been removed.  If you have added more
> > > > shelving locations and removed that one then you'll need to log out of
> > > > the staff client and log back in, as it caches those.  The expectation
> > > > is that shelving locations intended for use would not be removed
> > > > during normal operating hours.
> > > >
> > > > You'll need at least one shelving location in the database, and the
> > > > location field will default to 1 (the id for the Stack location) if
> > > > you do not provide one when creating the copies.
> > > >
> > > > Hope that gets you further.
> > > >
> > > > --miker
> > > >
> > > >
> > > >
> > > >
> > > > >
> > > > >
> > > > >  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
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Mike Rylander
> > > >  | VP, Research and Design
> > > >
> > > >  | Equinox Software, Inc. / The Evergreen Experts
> > > >  | phone: 1-877-OPEN-ILS (673-6457)
> > > >  | email: miker at esilibrary.com
> > > >  | web: http://www.esilibrary.com
> > > >
> > >
> > >
> >
> >
> >
> > --
> >
> >
> >
> > Mike Rylander
> >  | VP, Research and Design
> >  | Equinox Software, Inc. / The Evergreen Experts
> >  | phone: 1-877-OPEN-ILS (673-6457)
> >  | email: miker at esilibrary.com
> >  | web: http://www.esilibrary.com
> >
>
>

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: miker at esilibrary.com
 | web: http://www.esilibrary.com