Re: [osdldbt-general] dbt3 Docs?

[Mark W. <ma...@os...>]

Hi John,

Clearly the docs need updating. ;)  I'll inline updates below.

Thanks,
Mark

On Thu, 23 Jun 2005 08:50:50 -0700
"Mickelson, JohnX K" <joh...@in...> wrote:

> Mark,
> 	It may be that there are other things missing as well. I decided
> to use the tarball I d/l'ed from you, instead of dbt3-1.7. 
> 
> 	In section 2.2 of the user manual it states that environmental
> variables are set by running dbt3/scripts/pgsql/set_run_env.sh. That
> script is missing. 

Yeah, this has changed.  You can source scripts/dbt3_profile now.  There
are more environment variables that are database specific in
scripts/pgsql/pgsql_profile.

> 	The user manual in section 2.5.3 talks about a shell script
> called build_db.sh in the /dbt3/scripts/pgsql directory. I gather that
> this script will slice and dice and setup the database for you according
> to variables set elsewhere. This file does not exist. I was trying to
> follow
> along with the manual as sections 2.5.3.1 details the steps that
> build_db.sh

scripts/pgsql/build_db.sh only creates the database instance, where
scripts/pgsql/load_test.sh will call build_db.sh and will also load
the database.

> would do. However, after I successfully created input data files with 
> a ./dbgen -s 1, I attempted a database creation using create_db.sh. I
> got
> the following results:
> [pgsql@EdenPark pgsql]$ ./create_db.sh
> initializing database cluster...
> The files belonging to this database system will be owned by user
> "pgsql".
> This user must also own the server process.
> 
> The database cluster will be initialized with locale en_US.UTF-8.
> The default database encoding has accordingly been set to UNICODE.
> 
> creating directory /opt/OBT3/database ... ok
> creating directory /opt/OBT3/database/global ... ok
> creating directory /opt/OBT3/database/pg_xlog ... ok
> creating directory /opt/OBT3/database/pg_xlog/archive_status ... ok
> creating directory /opt/OBT3/database/pg_clog ... ok
> creating directory /opt/OBT3/database/pg_subtrans ... ok
> creating directory /opt/OBT3/database/base ... ok
> creating directory /opt/OBT3/database/base/1 ... ok
> creating directory /opt/OBT3/database/pg_tblspc ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 1000
> creating configuration files ... ok
> creating template1 database in /opt/OBT3/database/base/1 ... FATAL:
> relnatts disagrees with indnatts for index 16678
> child process exited with exit code 1
> initdb: removing data directory "/opt/OBT3/database"
> 
> I'm not a DBA so I'm not familiar with the error. Can you help me here?

This is curious.  If I recall correctly, you said you were using
PostgreSQL v8.0.3?  I'm actually not familiar with this error.  Can you
reproduce it even after removing the /opt/OBT3/database directory?
  
> So far I can tell you that there is at least one section in the
> user manual that can be deleted or replaced: 2.3 Preparing DataGen. It
> seems
> that datagen is included in the tarball I downloaded from you yesterday.
> Something will have to take the sections's place as you must either go
> in
> and run a make in the dbt3/src/dbgen directory, or include making
> it in the top level make file. There is no more downloading datagen from
> the tpc.org site. Or I'm completely wrong and you do have to D/L from
> the tpc site and use that instead of what's in the tarball. Or maybe
> you don't intend to include the datagen stuff in the new version of
> dbt3?

Oops, yeah there's been a few changes to the makefiles and this whole
process.  So no patching required anymore, but a manual 'make' in the
src/dbgen is still required.  I'm not skilled enough with automake yet
to make put it all together. :(

> I understand that the user manual is a preliminary version. All I want
> to do is help make it better and the whole of the db testing suite.
> Please
> don't take this as criticism. You are doing the world a service, I'd
> like
> to help you.

That's great, I appreciate it.