[OPEN-ILS-DEV] Error when creating items
Robert Nix
glibrarysystem at gmail.com
Thu Mar 13 09:55:44 EDT 2008
Hi Mike,
Ok I tried to check out an item and this is the postgresql log that I got
from the error:
2008-03-13 13:22:22 UTC ERROR: relation "reporter.legacy_cat1" does not
exist
2008-03-13 13:22:23 UTC ERROR: relation "reporter.legacy_cat2" does not
exist
2008-03-13 13:22:23 UTC ERROR: relation "reporter.classic_current_circ"
does not exist
2008-03-13 13:22:23 UTC ERROR: relation "
reporter.classic_current_billing_summary" does not exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.legacy_cat1" does not
exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.legacy_cat1" does not
exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.legacy_cat2" does not
exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.classic_current_circ"
does not exist
2008-03-13 13:22:24 UTC ERROR: relation "
reporter.classic_current_billing_summary" does not exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.legacy_cat2" does not
exist
2008-03-13 13:22:24 UTC ERROR: relation "reporter.classic_current_circ"
does not exist
2008-03-13 13:22:24 UTC ERROR: relation "
reporter.classic_current_billing_summary" does not exist
2008-03-13 13:22:25 UTC ERROR: relation "reporter.legacy_cat1" does not
exist
2008-03-13 13:22:25 UTC ERROR: relation "reporter.legacy_cat2" does not
exist
2008-03-13 13:22:25 UTC ERROR: relation "reporter.classic_current_circ"
does not exist
2008-03-13 13:22:25 UTC ERROR: relation "
reporter.classic_current_billing_summary" does not exist
Is this an issue due to an incomplete database? Should I just reload
evergreen and start over?
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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080313/58b3e71e/attachment-0001.html
More information about the Open-ils-dev
mailing list