[OPEN-ILS-DEV] ***SPAM*** RE: error while adding items.

[Mike Rylander]

On Wed, Oct 14, 2009 at 11:38 AM, Steve Wills <steve.wills at lyrasis.org> wrote:
> Progress.  The error coming out of postgreSQL is "insert or update on table "copy" violates foreigh key constraint "copy_location_fkey"   the detail is (location)-(1) is not present in table "copy_location".
>
> I'm wondering now if my batch import of bib data and item info from my migration sub-contrator crashed against my ou data?  Is this a reasonable path to start down?

Ahh, you've removed (or, somehow it was removed) the special Stacks
shelving location.  That's needed as a default.  You can put it back
in using:

INSERT INTO asset.copy_location (id, name,owning_lib) VALUES (1, 'Stacks',1);

Based on that, I'd suggest checking that the (also special) entries in
both biblio.record_entry and asset.call_number with an id of -1 are
still there.

--miker

>
> Stev3
>
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Sharp, Chris
> Sent: Wednesday, October 14, 2009 10:49 AM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] error while adding items.
>
> Steve,
>
>> Also, I cannot find an
>> osrferror.log on my system.  I assume that is supposed to get written
>> to the /openils/var/log area?
>
> I did some digging and found that the logs I'm referring to are in PINES' specific implementation, but the file with everything that is in those logs (which are created in PINES syslog-ng.conf files on each server in the cluster)  seems to be drawn from /openils/var/log/osrfsys.log.  In our case, we have an error log, a warning log, and a osrfsys.log by hour (among others).  Messages in the logs contain tags that allow log filtering (WARN, ERR, etc.).  The PINES implementation was set up the original Evergreen developers, so I'll defer to them for corrections or additional details :-).
>
>> I did find a thread on the list that
>> talked about this being memory related which is why I went after
>> configuring the memcache process.
>
> I'll also mention that PINES has two (redundant) dedicated memcache servers.  I don't know what the tipping point is regarding the amount of system use that would require clustering out that function, but PINES has tens of thousands of simultaneous users needing to log in and memcache allows user sessions to be persistent.  I'm not an expert in that area, either, so again, if others have a different understanding, please correct me.
>
> Chris
>
> Chris Sharp
> PINES Program Manager
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
>
> ----- "Steve Wills" <steve.wills at lyrasis.org> wrote:
>
>> Hi Chris,
>>
>> This is happening consistently.  Both your great suggestions have
>> given me some other things to work on. Notably, postgreSQL is not
>> configured to write logs at present.  Also, I cannot find an
>> osrferror.log on my system.  I assume that is supposed to get written
>> to the /openils/var/log area?  I did find a thread on the list that
>> talked about this being memory related which is why I went after
>> configuring the memcache process.
>>
>> Stev3
>>
>> -----Original Message-----
>> From: open-ils-dev-bounces at list.georgialibraries.org
>> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of
>> Sharp, Chris
>> Sent: Tuesday, October 13, 2009 5:13 PM
>> To: Evergreen Development Discussion List
>> Subject: Re: [OPEN-ILS-DEV] error while adding items.
>>
>> Steve,
>>
>> Is this happening consistently or sporadically?  If consistently,
>> tailing the osrferror.log should give you a little more - you might
>> also tail the postgres logs as it happens, since you're trying to
>> write to the database.  Just a thought...
>>
>> Chris Sharp
>> PINES Program Manager
>> Georgia Public Library Service
>> 1800 Century Place, Suite 150
>> Atlanta, Georgia 30345
>> (404) 235-7147
>> csharp at georgialibraries.org
>> http://pines.georgialibraries.org/
>>
>> ----- "Steve Wills" <steve.wills at lyrasis.org> wrote:
>>
>> > I'm sure this will turn out to be a server config error, but where
>> to
>> > look?
>> >
>> > In holding maintenance I am getting the following error when I
>> attempt
>> > to create holding record:
>> >
>> > method=open-ils.cat.asset.copy.fleshed.batch.update
>> >
>> params=["5573fbf61399401f49cdc652e56daa15",[{"__c":"acp","__p":["1","1",null,null,null,null,"54365476","139004",null,"116",null,"t",null,null,null,null,0,0,null,null,null,null,2,"t",-1,2,1,"t",0,"f",5]}],true]
>> > THROWN:
>> > {"payload":[],"debug":"osrfMethodException :  *** Call to
>> > [open-ils.cat.asset.copy.fleshed.batch.update] failed for session
>> > [1255466438.898063.12554664384704], thread trace [1]:\nException:
>> > OpenSRF::DomainObject::oilsMethodException 2009-10-13T16:40:39
>> > OpenSRF::Application
>> > /usr/local/share/perl/5.10.0/OpenSRF/Application.pm:202 <500>
>> Error
>> > committing transaction\n\n","status":500}
>> > STATUS:
>> >
>> > And ideas?
>> > Thanks
>> > Stev3
>



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