Paste number 60533: 1.2.2.0 unhappy at add record time

Index of paste annotations: 5 | 4 | 3 | 2 | 1

Paste number 60533: 1.2.2.0 unhappy at add record time
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As 
{
	"debug":"  * ! EXCEPTION ! * \nTYPE: OpenSRF::EX::ERROR\nMess: System ERROR \nMess:   * ! EXCEPTION ! * \nMess: TYPE: OpenSRF::DomainObject::oilsMethodException\nMess: Mess: <500>  INSERT error -- please see the error log for more details\nMess: Loc.: 996 OpenSRF::AppRequest \nMess: Loc.: /openils/lib/perl5/OpenSRF/AppSession.pm \nMess: Time: Fri May  9 22:23:41 2008\n\nLoc.: 540 OpenILS::Utils::CStoreEditor \nLoc.: /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm \nTime: Fri May  9 22:23:41 2008\n",
	"desc":"The attempt to query to the DB failed",
	"ilsevent":2002,
	"payload":/*--S bre --*/
	[
		null,
		null,
		null,
		null,
		null,
		null,
		"now",
		1,
		null,
		"now",
		1,
		null,
		null,
		null,
		"<marc:record xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns=\"http://www.loc.gov/MARC21/slim\" xmlns:marc=\"http://www.loc.gov/MARC21/slim\" xsi:schemaLocation=\"http://www.loc.gov/MARC21/slim http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd\">\n  <leader>01195cam  22003014a 4500</leader>\n  <controlfield tag=\"001\">14046695</controlfield>\n  <datafield tag=\"906\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">7</subfield>\n    <subfield code=\"b\">cbc</subfield>\n    <subfield code=\"c\">orignew</subfield>\n    <subfield code=\"d\">1</subfield>\n    <subfield code=\"e\">ecip</subfield>\n    <subfield code=\"f\">20</subfield>\n    <subfield code=\"g\">y-gencatlg</subfield>\n  </datafield>\n  <datafield tag=\"925\" ind1=\"0\" ind2=\" \">\n    <subfield code=\"a\">acquire</subfield>\n    <subfield code=\"b\">2 shelf copies</subfield>\n    <subfield code=\"x\">policy default</subfield>\n  </datafield>\n  <datafield tag=\"955\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">jf03 2005-07-21</subfield>\n    <subfield code=\"c\">jf03 2005-07-21 to Subj.;</subfield>\n    <subfield code=\"d\">jf04 2005-07-25 to S.L.</subfield>\n    <subfield code=\"e\">jf04 2005-07-25 to Dewey</subfield>\n    <subfield code=\"a\">aa24 2005-07-26</subfield>\n    <subfield code=\"a\">ps13 2005-12-19 1 copy rec'd.,
		 to CIP ver.</subfield>\n    <subfield code=\"a\">lg08 2006-06-13 copy 2 added</subfield>\n  </datafield>\n  <datafield tag=\"955\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">pv03 2005-12-21 z-processor</subfield>\n    <subfield code=\"f\">pv03 2005-12-21 CIP ver. to BCCD</subfield>\n  </datafield>\n  <controlfield tag=\"005\">20080510004625.0</controlfield>\n  <controlfield tag=\"008\">050721s2006    njua          001 0 eng</controlfield>\n  <datafield tag=\"010\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">2005020022</subfield>\n  </datafield>\n  <datafield tag=\"020\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">0131855255</subfield>\n  </datafield>\n  <datafield tag=\"035\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">(OCoLC)ocm61162064</subfield>\n  </datafield>\n  <datafield tag=\"040\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">DLC</subfield>\n    <subfield code=\"c\">DLC</subfield>\n    <subfield code=\"d\">YDX</subfield>\n    <subfield code=\"d\">BAKER</subfield>\n    <subfield code=\"d\">DLC</subfield>\n  </datafield>\n  <datafield tag=\"042\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">pcc</subfield>\n  </datafield>\n  <datafield tag=\"050\" ind1=\"0\" ind2=\"0\">\n    <subfield code=\"a\">QA76.76.S46</subfield>\n    <subfield code=\"b\">Z55 2006</subfield>\n  </datafield>\n  <datafield tag=\"082\" ind1=\"0\" ind2=\"0\">\n    <subfield code=\"a\">005.3</subfield>\n    <subfield code=\"2\">22</subfield>\n  </datafield>\n  <datafield tag=\"100\" ind1=\"1\" ind2=\" \">\n    <subfield code=\"a\">Zikopoulos,
		 Paul.</subfield>\n  </datafield>\n  <datafield tag=\"245\" ind1=\"1\" ind2=\"0\">\n    <subfield code=\"a\">Apache Derby :</subfield>\n    <subfield code=\"b\">off to the races : includes details of IBM Cloudscape /</subfield>\n    <subfield code=\"c\">Paul C. Zikopoulos,
		 George Baklarz,
		 Dan Scott.</subfield>\n  </datafield>\n  <datafield tag=\"260\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">Upper Saddle River,
		 NJ :</subfield>\n    <subfield code=\"b\">IBM Press/Pearson PLC,
		</subfield>\n    <subfield code=\"c\">c2006.</subfield>\n  </datafield>\n  <datafield tag=\"300\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">xxv,
		 567 p. :</subfield>\n    <subfield code=\"b\">ill. ;</subfield>\n    <subfield code=\"c\">25 cm.</subfield>\n  </datafield>\n  <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n    <subfield code=\"a\">Includes index.</subfield>\n  </datafield>\n  <datafield tag=\"650\" ind1=\" \" ind2=\"0\">\n    <subfield code=\"a\">Open source software.</subfield>\n  </datafield>\n  <datafield tag=\"610\" ind1=\"2\" ind2=\"0\">\n    <subfield code=\"a\">Apache Group.</subfield>\n  </datafield>\n  <datafield tag=\"700\" ind1=\"1\" ind2=\" \">\n    <subfield code=\"a\">Scott,
		 Dan,
		</subfield>\n    <subfield code=\"d\">1972-</subfield>\n  </datafield>\n  <datafield tag=\"700\" ind1=\"1\" ind2=\" \">\n    <subfield code=\"a\">Baklarz,
		 George.</subfield>\n  </datafield>\n</marc:record>",
		null,
		null,
		"System Local",
		14046695
	]
	/*--E bre --*/,
	"pid":3923,
	"servertime":"Fri May  9 22:23:41 2008",
	"stacktrace":"/openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:540 (eval 630):1 (eval 630):1",
	"textcode":"DATABASE_QUERY_FAILED"
}

Annotations for this paste:

Annotation number 5: and the answer, thanks be to miker
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH#5
Paste contents:
Raw Source | Display As 
issue the following statement against the database after a large import

select setval('biblio.record_entry_id_seq',max(id), true) from biblio.record_entry;

Annotation number 4: relevant postgresql log entry
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH#4
Paste contents:
Raw Source | Display As 
2008-05-09 22:23:41 ADT ERROR:  duplicate key violates unique constraint "record_entry_pkey"

Annotation number 3: relevant section of /openils/lib/perl5/OpenILS/Application/Cat.pm
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH#3
Paste contents:
Raw Source | Display As 
sub biblio_record_xml_import {
        my( $self, $client, $authtoken, $xml, $source, $auto_tcn) = @_;

        my $override = 1 if $self->api_name =~ /override/;
    my $e = new_editor(xact=>1, authtoken=>$authtoken);
    return $e->die_event unless $e->checkauth;
    return $e->die_event unless $e->allowed('IMPORT_MARC');

        my( $evt, $tcn, $tcn_source, $marcdoc );

        if( $auto_tcn ) {
                # auto_tcn forces a blank TCN value so the DB will have to generate one for us
                $marcdoc = __make_marc_doc($xml);
        } else {
                ( $tcn, $tcn_source, $marcdoc, $evt ) = _find_tcn_info($e, $xml, $override);
                return $evt if $evt;
        }

        $logger->info("user ".$e->requestor->id.
                " creating new biblio entry with tcn=$tcn and tcn_source $tcn_source");

Annotation number 2: osrfsys.log
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH#2
Paste contents:
Raw Source | Display As 
open-ils.cstore 2008-05-09 22:23:41 [ERR :3873:oils_cstore.c:846:1210363238411618] open-ils.cstore ERROR inserting biblio::record_entry object using query [INSERT INTO biblio.record_entry (create_date,creator,last_xact_id,tcn_source,editor,marc,active,id,source,deleted,fingerprint,tcn_value,quality,edit_date) VALUES ('now',1,'1210382604.259732442.77412566469','System Local',1,'<marc:record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim" xmlns:marc="http://www.loc.gov/MARC21/slim" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd">

blah blah marc blah

</marc:record>',DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,'14046695',DEFAULT,'now');]
open-ils.cstore 2008-05-09 22:23:41 [INFO:3873:osrf_app_session.c:522:1210363238411618] [open-ils.cstore] sent 237 bytes of data to opensrf@localhost/open-ils.cat_drone_at_osls.cs.upei.ca_3923
open-ils.cstore 2008-05-09 22:23:41 [INFO:3873:osrf_app_session.c:522:1210363238411618] [open-ils.cstore] sent 370 bytes of data to opensrf@localhost/open-ils.cat_drone_at_osls.cs.upei.ca_3923
open-ils.cstore 2008-05-09 22:23:41 [WARN:3873:osrf_application.c:358:1210363238411618] Returning method exception with message: An unknown server error occurred
open-ils.cstore 2008-05-09 22:23:41 [INFO:3873:osrf_app_session.c:522:1210363238411618] [open-ils.cstore] sent 212 bytes of data to opensrf@localhost/open-ils.cat_drone_at_osls.cs.upei.ca_3923
open-ils.cstore 2008-05-09 22:23:41 [INFO:3873:osrf_stack.c:103:1210363238411618] Message processing duration 0.060822
[2008-5-9 22:23:41] open-ils.cat [INFO:3923:Client.pm:275:1210363238411618] timed_read() read 635 bytes of data
[2008-5-9 22:23:41] open-ils.cat [INFO:3923:Client.pm:275:1210363238411618] timed_read() read 868 bytes of data
[2008-5-9 22:23:41] open-ils.cat [ERR :3923:EX.pm:66:1210363238411618]   * ! EXCEPTION ! *
TYPE: OpenSRF::EX::ERROR
Mess: System ERROR
Mess:   * ! EXCEPTION ! *
Mess: TYPE: OpenSRF::DomainObject::oilsMethodException
Mess: Mess: <500>  INSERT error -- please see the error log for more details
Mess: Loc.: 996 OpenSRF::AppRequest
Mess: Loc.: /openils/lib/perl5/OpenSRF/AppSession.pm
Mess: Time: Fri May  9 22:23:41 2008

Loc.: 996 OpenSRF::AppRequest
Loc.: /openils/lib/perl5/OpenSRF/AppSession.pm
Time: Fri May  9 22:23:41 2008

Annotation number 1: open-ils.cat log
Pasted by: dbs
When:1 year, 1 month ago
Share:Tweet this! | http://paste.lisp.org/+1APH#1
Paste contents:
Raw Source | Display As 
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Cat.pm line 288.
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Cat.pm line 288.

Colorize as:
Show Line Numbers
Index of paste annotations: 5 | 4 | 3 | 2 | 1

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.