[OPEN-ILS-DEV] Getting closer... psql load errors

Jason Zou qzou at lakeheadu.ca
Thu May 31 14:06:25 EDT 2007 

Don Hamilton wrote:
> I wish I could type!
>  
> its http://tamarak.wlu.ca.
>  
> don
>
> >>> qzou at lakeheadu.ca 5/31/2007 12:56 PM >>>
> Don Hamilton wrote:
> > Got it, thanks!
> > 
> > I rebuilt the DB via a make, make install... is there a simpler reset?
> > 
> > don
> > 
> > btw... you can see project Gutenberg, running on evergreen on an old
> > p-iii with 512mb ram at http://tamatack.wlu.ca. Thanks for all the
> > help (so far!)...
> >
> > >>> mrylander at gmail.com 5/30/2007 9:52 PM >>>
> > On 5/30/07, Don Hamilton <dhamilton at wlu.ca> wrote:
> > >
> > >
> > > Next step...
> > >
> > > The newer marc2bre fixed the problem I have 14,486 records in
> > record_entry.
> > > Woo hoo!
> > >
> > > BUT (of course)... I also have the following:
> >
> > You'll need to issue the following command in psql:
> >
> > # select set_curcfg('default');
> >
> > The reason for this is that the locale that you've initialized the
> > Evergreen database into is not one of the default locales that
> > tsearch2 knows about.  Of course, it would be best to initialize the
> > DB in the C locale so that it is (more or less) locale-agnostic, but
> > the above command should get things running for you.
> >
> > A bigger issue is whether you have any entries in the metabib.full_rec
> > table (and other indexing tables, such as metabib.title_field_entry).
> > If not, I'd suggest just rebuilding the DB, as it will be a pain to
> > clean all of that up.  If you you do, though, then the above command
> > will avoid further warnings regarding the tsearch2 parser.
> >
> > Another way to avoid that issue is to wrap the import of the loader
> > SQL in a transaction by issuing a
> >
> > # BEGIN;
> >
> > command before the \i import and then
> >
> > # COMMIT;
> >
> > afterwards.
> >
> > --miker
> >
> > >
> > > psql:/home/don/gutenberg.sql:388994: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY full_rec, line 1: "\N    \N      2       \N      LDR
> > > 00531cam a22001813a 4500"
> > > psql:/home/don/gutenberg.sql:403482: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY title_field_entry, line 1: "5    2       five years of
> > > theosophy  [electronic resource"
> > > psql:/home/don/gutenberg.sql:416900: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY author_field_entry, line 1: "7   3       wolley, 
> hannah"
> > > psql:/home/don/gutenberg.sql:420892: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY subject_field_entry, line 1: "13 9       antarctica --
> > > discovery and exploration"
> > > psql:/home/don/gutenberg.sql:435380: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY keyword_field_entry, line 1: "14 2       five years of
> > > theosophy  [electronic resource] / text eng by various project 
> gutenberg
> > > freely a..."
> > > psql:/home/don/gutenberg.sql:449866: ERROR:  could not find
> > > tsearch config by locale
> > > CONTEXT:  COPY series_field_entry, line 1: "1   2       project
> > gutenberg
> > > 14378"
> > >
> > >
> > > so what is "tsearch config by locale", and how do I find it?
> > >
> > > don (where am I going, and what am I doing in this handcart?) hamilton
> > >
> > > >>> mrylander at gmail.com 5/30/2007 11:07 AM >>>
> > >
> > > On 5/30/07, Don Hamilton <dhamilton at wlu.ca> wrote:
> > > >
> > > >
> > > > Hi again...
> > > >
> > > > Here's the output from the psql. I *think* the main problem is
> > that the
> > > > creator column is supposed to be integer, but the data in the
> > insert is
> > > > character 'admin'. That may or may not kick off the rest of the
> > errors.
> > > >
> > > > Have I missed some earlier configuration (to, say, add 'admin' 
> to the
> > > users
> > > > table so that pg-loader could figure out the actual id number and
> > use it)?
> > > > or have a mismatched version of db-schema and loader code? or ???
> > > >
> > >
> > > Arg ... yeah, that's a bug in the marc2bre that lives in the 1.0
> > > branch.  I'd like you to grab the verion that lives in the HEAD of
> > > cvs, if you can.  It's available here directly:
> > >
> > >
> > 
> http://open-ils.org/cgi-bin/viewcvs.cgi/ILS/Open-ILS/src/extras/import/marc2bre.pl?rev=1.9&view=log 
> <http://open-ils.org/cgi-bin/viewcvs.cgi/ILS/Open-ILS/src/extras/import/marc2bre.pl?rev=1.9&view=log> 
>
> > 
> <http://open-ils.org/cgi-bin/viewcvs.cgi/ILS/Open-ILS/src/extras/import/marc2bre.pl?rev=1.9&view=log 
> <http://open-ils.org/cgi-bin/viewcvs.cgi/ILS/Open-ILS/src/extras/import/marc2bre.pl?rev=1.9&view=log>>
> > >
> > > Thanks in advance, Don.
> > >
> > > --miker
> > >
> > > >
> > > > don
> > > >
> > > >
> > > >
> > > > evergreen=# \i gutenberg.sql;
> > > > SET
> > > > psql:gutenberg.sql:14489: ERROR:  invalid input syntax for integer:
> > > "admin"
> > > > CONTEXT:  COPY record_entry, line 1, column creator: "admin"
> > > > psql:gutenberg.sql:14491: ERROR:  setval: value -1 is out of
> > bounds for
> > > > sequence "record_entry_id_seq" (1..9223372036854775807)
> > > > psql:gutenberg.sql:28979: ERROR:  insert or update on table
> > > "rec_descriptor"
> > > > violates foreign key constraint
> > > > "metabib_rec_descriptor_record_fkey"
> > > > DETAIL:  Key (record)=(1) is not present in table "record_entry".
> > > > psql:gutenberg.sql:388994: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY full_rec, line 1: "\N    \N      1       \N      LDR
> > > > 00531cam a22001813a 4500"
> > > > psql:gutenberg.sql:403482: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY title_field_entry, line 1: "5    1       five 
> years of
> > > > theosophy  [electronic resource"
> > > > psql:gutenberg.sql:416900: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY author_field_entry, line 1: "7   2       wolley,
> > hannah"
> > > > psql:gutenberg.sql:420892: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY subject_field_entry, line 1: "13 8       
> antarctica --
> > > > discovery and exploration"
> > > > psql:gutenberg.sql:435380: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY keyword_field_entry, line 1: "14 1       five 
> years of
> > > > theosophy  [electronic resource] / text eng by various project
> > gutenberg
> > > > freely a..."
> > > > psql:gutenberg.sql:449866: ERROR:  could not find tsearch config
> > by locale
> > > > CONTEXT:  COPY series_field_entry, line 1: "1   1       project
> > gutenberg
> > > > 14378"
> > > > evergreen=# SELECT COUNT(*) FROM biblio.record_entry
> > > > ;
> > > >  count
> > > > -------
> > > >      1
> > > > (1 row)
> > > >
> > > > evergreen=# \?
> > > >
> > >
> > >
> > > --
> > > Mike Rylander
> > >
> >
> >
> > --
> > Mike Rylander
>
> Don,
>
> Congras!
> It seems that http://tamatack.wlu.ca is not accessible.
>
> Jason
>
> Lakehead University Library
>
Cool. It works ... :-)
btw, my evergreen installation is at http://erl.lakeheadu.ca:8088

Jason
Lakehead University Library

More information about the Open-ils-dev mailing list