[OPEN-ILS-DEV] Error when creating items

[Robert Nix]

The process of checking out the items is locking up the system for about 1
or 2 minutes while it tries to access the database. That makes it hard to
ignore the errors as the patrons are going to have to wait the 1 to 2 extra
minutes to check out items. Is there any way to stop the backend from
looking for those things in the database so we can cut down on our load
times for accessing the database?

On Thu, Mar 13, 2008 at 1:46 PM, Mike Rylander <mrylander at gmail.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080313/ac64ceb1/attachment-0001.html