From: Coyne, K. <Kat...@st...> - 2007-08-10 19:42:07
|
Hello, I have used an older version of DBt2 but just now am attempting to use the newest version. I created a small db via pgsql to test with(pgsql test worked fine and the run_workload looks like it is running) and get the error: Can't Locate Test/Parser/Dbt2.pm in @INC...... and complains about Line 13 in post-process perl script. I looked everywhere for these modules but could not find them (line 13 : use Test::Parser::Dbt2;), Am I just not finding it or is it not in the gz.tar file? Also just a note, I see that the mix_analyze.pl script is no longer there too...is this new for .40 version or missing? =20 The exact output is: =20 ./run_workload.sh -w 2 -d 60 -c 4 waiting for server to shut down.... done server stopped server starting ************************************************************************ * DBT-2 test for pgsql started * * * Results can be found in output/1 directory ************************************************************************ * * * Test consists of 3 stages: * * * * 1. Start of client to create pool of databases connections * * 2. Start of driver to emulate terminals and transactions generation * * 3. Processing of results * * * ************************************************************************ =20 DATABASE SYSTEM: localhost DATABASE NAME: dbt2 DATABASE PORT: 5432 DATABASE CONNECTIONS: 4 TERMINAL THREADS: 20 TERMINALS PER WAREHOUSE: 10 SCALE FACTOR(WAREHOUSES): 2 DURATION OF TEST (in sec): 60 1 client stared every 1000 millisecond(s) =20 Stage 1. Starting up client... Sleeping 5 seconds =20 Stage 2. Starting up driver... 1000 threads started per millisecond estimated rampup time: Sleeping 30 seconds estimated rampup time has elapsed estimated steady state time: Sleeping 60 seconds =20 Stage 3. Processing of results... Killing client... ./run_workload.sh: line 461: 6088 Terminated ${abs_top_srcdir}/src /client ${CLIENT_COMMAND_ARGS} >${OUTPUT_DIR}/client.out 2>&1 ./run_workload.sh: line 498: 6102 Terminated ${abs_top_srcdir}/src /driver ${DRIVER_COMMAND_ARGS} >${OUTPUT_DIR}/driver.out 2>&1 waiting for server to shut down.... done server stopped Can't locate Test/Parser/Dbt2.pm in @INC (@INC contains: /usr/lib64/perl5/5.8.5/ x86_64-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib64/perl5/site_perl/5.8.5/ x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.4/x86_64-linux-thread-m ulti /usr/lib64/perl5/site_perl/5.8.3/x86_64-linux-thread-multi /usr/lib64/perl5 /site_perl/5.8.2/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.1/x86_ 64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.0/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/si te_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr /lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl /5.8.5/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_perl/5.8.4/x86_64-linux -thread-multi /usr/lib64/perl5/vendor_perl/5.8.3/x86_64-linux-thread-multi /usr/ lib64/perl5/vendor_perl/5.8.2/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_ perl/5.8.1/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_perl/5.8.0/x86_64-l inux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5. 8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/p erl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_pe rl .) at /home/postgres/osdl-dbt2/dbt2-0.40/scripts/post-process line 13. BEGIN failed--compilation aborted at /home/postgres/osdl-dbt2/dbt2-0.40/scripts/ post-process line 13. chmod: cannot access `/home/postgres/osdl-dbt2/dbt2-0.40/scripts/output/1/db/log ': No such file or directory Warning: empty y range [0:0], adjusting to [-1:1] =20 gnuplot: unable to open display '' gnuplot: X11 aborted. =20 Warning: empty y range [0:0], adjusting to [0:1] Warning: empty y range [0:0], adjusting to [-1:1] gnuplot: unable to open display '' gnuplot: X11 aborted. =20 Warning: empty y range [0:0], adjusting to [0:1] Warning: empty y range [0:0], adjusting to [-1:1] =20 gnuplot: unable to open display '' gnuplot: X11 aborted. =20 Warning: empty y range [0:0], adjusting to [0:1] Test completed. Results are in: /home/postgres/osdl-dbt2/dbt2-0.40/scripts/output/1 Thanks!!! Kate |
From: Mark W. <ma...@gm...> - 2007-08-10 19:50:07
|
On 8/10/07, Coyne, Kate <Kat...@st...> wrote: > > > Hello, > I have used an older version of DBt2 but just now am attempting to use the > newest version. I created a small db via pgsql to test with(pgsql test > worked fine and the run_workload looks like it is running) and get the > error: Can't Locate Test/Parser/Dbt2.pm in @INC...... and complains about > Line 13 in post-process perl script. I looked everywhere for these modules > but could not find them (line 13 : use Test::Parser::Dbt2;), Am I just not > finding it or is it not in the gz.tar file? Also just a note, I see that > the mix_analyze.pl script is no longer there too...is this new for .40 > version or missing? Hi Kate, Yeah, I've moved all that functionality to a perl module called Test-Parser. It's available on cpan, if you know how to use it (http://search.cpan.org/~bryce/Test-Parser-1.5/). I did that in order to share the code better between other test kits. There is a 'post-process' script that does all the number crunching and a 'generate-report' script that'll create an html page and the charts. You'll need Test-Presenter for that (http://search.cpan.org/~bryce/Test-Presenter-0.2/). Regards, Mark |
From: Coyne, K. <Kat...@st...> - 2007-08-14 19:02:08
|
Hi=20 I am using build_db.sh and it seems to work fine(pgdata and pgsqldata are built) but the database dbt2 can not be found. The output from the build.sh, the pgdata/global/pg_database, and the pgsql_profile file are all below. I believe it is adding the database name as postgres(since this is in the pg_database file!) yet the DBNAME is dbt2! Did I miss something here? One other thing: At the end of the build the message: 'cp: cannot stat `./pg_hba.conf': No such file or directory' comes out and I'm not certain why we are attempting to copy the pg_hba.conf file when DIR is . or anywhere at this point..maynot matter but thought I would ask. FYI: I'm running on RHEL 4.5 using pgsql: 8.2.4.=20 Thanks, Kate [postgres@fusionpp pgsql]$ ./build_db.sh -g -w 5 top dir is /home/postgres/osdl-dbt2/dbt2-0.40 db is /mnt/postgresql/pgsqldata warehouses =3D 5 districts =3D 10 customers =3D 3000 items =3D 100000 orders =3D 3000 stock =3D 100000 new_orders =3D 900 =20 Output directory of data files: /mnt/postgresql/pgsqldata =20 Generating data files for 5 warehouse(s)... Generating item table data... Finished item table data... Generating warehouse table data... Finished warehouse table data... Generating stock table data... Finished stock table data... Generating district table data... Finished district table data... Generating customer table data... Finished customer table data... Generating history table data... Finished history table data... Generating order and order-line table data... Finished order and order-line table data... Generating new-order table data... Finished new-order table data... dir name is . Creating database... initdb pgdata /mnt/postgresql/pgdata The files belonging to this database system will be owned by user "postgres". This user must also own the server process. =20 The database cluster will be initialized with locale C. =20 creating directory /mnt/postgresql/pgdata ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers/max_fsm_pages ... 24MB/153600 creating configuration files ... ok creating template1 database in /mnt/postgresql/pgdata/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating conversions ... ok setting privileges on built-in objects ... ok creating information schema ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok =20 WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. =20 Success. You can now start the database server using: =20 /usr/local/pgsql/bin/postgres -D /mnt/postgresql/pgdata or /usr/local/pgsql/bin/pg_ctl -D /mnt/postgresql/pgdata -l logfile start =20 cp: cannot stat `./pg_hba.conf': No such file or directory [postgres@fusionpp pgsql]$ =20 =20 =20 =20 =20 --------------------- [postgres@fusionpp global]$ more pg_database "postgres" 10819 1663 524 "template1" 1 1663 524 "template0" 10818 1663 524 [postgres@fusionpp global]$ pwd /mnt/postgresql/pgdata/global [postgres@fusionpp global]$ =20 =20 =20 ----pgsql_profile file [postgres@fusionpp pgsql]$ more pgsql_profile #!/bin/sh # # This file is released under the terms of the Artistic License. # Please see the file LICENSE, included in this package, for details. # # Copyright (C) 2002-2006 Mark Wong & Open Source Development Labs, Inc. # =20 INITDB=3D/usr/local/pgsql/bin/initdb; export INITDB CREATEDB=3D/usr/local/pgsql/bin/createdb; export CREATEDB DROPDB=3D/usr/local/pgsql/bin/dropdb; export DROPDB CREATELANG=3D/usr/local/pgsql/bin/createlang; export CREATELANG PGRESTORE=3D/usr/local/pgsql/bin/pg_restore; export PGRESTORE PG_CTL=3D/usr/local/pgsql/bin/pg_ctl; export PG_CTL PSQL=3D/usr/local/pgsql/bin/psql; export PSQL VACUUMDB=3D/usr/local/pgsql/bin/vacuumdb; export VACUUMDB LIBDIR=3D@LIBDIR@; export LIBDIR =20 # Our database will be named dbt2 DBNAME=3Ddbt2; export DBNAME =20 # Data instance path. Storage location for this instance of the database # should be within the working directory. If you're going to mount a device, # do it at /mnt/postgresql. PGDATA=3D/mnt/postgresql/pgdata; export PGDATA DBDATA=3D/mnt/postgresql/pgsqldata; export DBDATA =20 # Directory with tablespace mount points, if using tablespaces. TSDIR=3D/mnt/postgresql/dbtt2 =20 # Flag to use PGPOOL. USE_PGPOOL=3D0 =20 =20 |
From: Mark W. <ma...@gm...> - 2007-08-14 19:13:59
|
On 8/14/07, Coyne, Kate <Kat...@st...> wrote: > > > > > Hi > > I am using build_db.sh and it seems to work fine(pgdata and pgsqldata are > built) but the database dbt2 can not be found. The output from the > build.sh, the pgdata/global/pg_database, and the pgsql_profile file are all > below. I believe it is adding the database name as postgres(since this is > in the pg_database file!) yet the DBNAME is dbt2! Did I miss something > here? One other thing: > > At the end of the build the message: 'cp: cannot stat `./pg_hba.conf': No > such file or directory' comes out and I'm not certain why we are attempting > to copy the pg_hba.conf file when DIR is . or anywhere at this > point..maynot matter but thought I would ask. > > FYI: I'm running on RHEL 4.5 using pgsql: 8.2.4. Hi Kate, My first guess is the script is stopping when the cp fails. I suggest commenting out the cp and trying again. If I recall correctly the pg_bha.conf file had settings so anyone from any remote system can connect to the database for multi-system testing. So if you are doing single system testing, you should be able to live without that custom file. Regards, Mark |