[OPEN-ILS-DEV] Error when creating items

Mike Rylander mrylander at gmail.com
Thu Mar 13 20:32:30 EDT 2008 

On Thu, Mar 13, 2008 at 3:47 PM, Robert Nix <glibrarysystem at gmail.com> wrote:
> 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?
>

This is surely not what is stalling the client for 1-2 minutes.
There's something else going on, and I suspect the osrfsys.log file
would give us a hint if the logging level is turned up high enough.
Could you change all <loglevel> elements in opensrf_core.xml to 4,
restart the perl and C services, reproduce the stalling failure and
send us that log file?

--miker

>
>
>
> 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
> >
>
>



-- 
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

More information about the Open-ils-dev mailing list