[mb-devel] Codebase & DB snapshot

[Cory Hubert]

Whelp.  After checking out the head.  I realized their was nothing in
cvs that matched the the snapshot 3.   So I jumped into the DBDefs.pm
and just changed the
sub DB_SCHEMA_SEQUENCE { 2 } from 2 to 3 then crossed my fingers.  Did
the import and it worked.

So is there a codebase 3 that matches the snapshot?  Or did I just do
a naughty hack?


On Wed, 20 Oct 2004 12:23:08 -0400, Cory Hubert <clhubert at gmail.com> wrote:
> At this point I am just documenting my progress in the forum for
> whoever else encounters these problems.  Seems like the crew is busy.
> But if you able to help me out, please chime in.
> 
> pg_settings table does not exist in the template1 db for postgresql 7.3.7-21
> 
> I upgraded to postgresql74 - 7.4.5-21 to be precise.
> 
> Perhaps the INSTALL documentation should change to say postgres74 or
> specify the exact version of 73 you can use.
> 
> Now I am having issues syncing up the codebase with the datadumps.....
> 
> Current errors when I run InitDB
> 
> Wed Oct 20 11:24:31 2004 : Validating snapshot
> Wed Oct 20 11:24:32 2004 : Snapshot timestamp is 2004-10-16 07:52:44.30401+00
> Wed Oct 20 11:24:32 2004 : Schema sequence mismatch - codebase is 2,
> snapshot files are 3
> 
> Failed to import dataset.
> Wed Oct 20 11:24:32 2004 : InitDb.pl failed
> 
> Currently trying to match up the timestamp of the data with correct
> cvs tagged codebase
> 
> I currently have RELEASE_2004109-BRANCH and I just downloaded the
> latest dumps and got the error message above.
> 
> 
> 
> 
> On Tue, 19 Oct 2004 17:50:44 -0400, Cory Hubert <clhubert at gmail.com> wrote:
> > Still having some issues but I did some tracing into InitDB and found this
> >
> > select setting from pg_settings where name = 'lc_collate'
> >
> > on like 116.  It seems like it tries to run a sql query on a table
> > that doesn't exist so it returns blank.  That's why it can't pick up
> > the correct locale setting.
> >
> > Any ideas?   It seems like it might be something trivial.
> >
> >
> >
> > On Tue, 19 Oct 2004 11:51:12 -0400, Cory Hubert <clhubert at gmail.com> wrote:
> > > So I ran fink to get postgresql and installed the necessary Perl
> > > Modules from perl -MCPAN -e shell
> > > .
> > > I create /home/httpd/musicbrains and checked out mb_server into there.
> > > I created the symbolic link to perl in the
> > > /home/httpd/musicbrainz/mb_server/cgi-bin directory.
> > >
> > > I also created the postgres user and gave it a password.
> > >
> > > here is what happened.
> > >
> > > Step 1:
> > > initialize db: (As postgres user)
> > > initdb --locale=C -D /usr/local/pgsql/data/
> > >
> > > Note:
> > > creating template1 database in /usr/local/pgsql/data//base/1... ok
> > > It used to say this step failed (but still built the template1 db)
> > > saying it couldn't locate something with LC_MESSAGES I set some perl
> > > locale environment variables to equal "C" in my .profile and it works
> > > now.
> > >
> > > Step 2:
> > > Starting postgres: (As postgres user)
> > > /sw/bin/pg_ctl-7.3 -D /usr/local/pgsql/data/ -l
> > > /sw/var/postgresql/pgsql.log start
> > >
> > > Note;
> > > Never any problems here.
> > >
> > > Step 3:
> > > Trying to import (as root)
> > > :/home/httpd/musicbrainz/mb_server root# ./admin/InitDb.pl --echo
> > > --createdb --import --with-replication
> > > --with-pending=/sw/lib/postgresql/pending.so
> > > ~clhubert/MusicBrianz/mbdump*.tar.bz2
> > >
> > > Tue Oct 19 11:30:11 2004 : InitDb.pl starting
> > > Use of uninitialized value in string eq at ./admin/InitDb.pl line 119.
> > > Use of uninitialized value in concatenation (.) or string at
> > > ./admin/InitDb.pl line 121.
> > > It looks like your Postgres database cluster was created with locale ''.
> > > MusicBrainz needs the "C" locale instead.  To rectify this, re-run "initdb"
> > > with the option "--locale=C".
> > > Tue Oct 19 11:30:11 2004 : InitDb.pl failed
> > >
> > > Bottom of postgresql.conf
> > > LC_MESSAGES = 'C'
> > > LC_MONETARY = 'C'
> > > LC_NUMERIC = 'C'
> > > LC_TIME = 'C'
> > >
> > > It's quite odd that the InitDb.pl script says locale isn't set but it
> > > clearly is.  any ideas?
> > >
> >
>