[OPEN-ILS-DEV] Getting closer... psql load errors
Don Hamilton
dhamilton at wlu.ca
Thu May 31 13:03:02 EDT 2007
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>
> >
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20070531/f1d2af47/attachment-0001.html
More information about the Open-ils-dev
mailing list