[OPEN-ILS-DEV] Getting closer... psql load errors
Dan Scott
denials at gmail.com
Thu May 31 13:09:54 EDT 2007
On 31/05/07, Don Hamilton <dhamilton at wlu.ca> 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>
> > >
> > > 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
>
>
Very nice, Don!
But I didn't know the Georgia Public Library had a branch in Waterloo
:) Now, for a fun exercise -- are you going to try updating to the EG
1.1.x branch so that you can get the generic "Evergreen" branding
instead of PINES (along with all of the other goodies in the 1.1.x
code branch)?
Congrats again, it's great to see that you made it this far!
--
Dan Scott
Laurentian University
More information about the Open-ils-dev
mailing list