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

[Jason Zou]

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