DBT-2 Error - Mailing list pgsql-general

Can someone help me to install DBT-2 ?

I did set up environment variables. But still I am getting errors

I installed it and run_workload. I am getting these errors:


[postgres@asnl dbt2-0.40]$ scripts/run_workload.sh -d 200 -w 1 -c 5
server starting



*           Results can be found in output/9 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                                            *
*                                                                      *
************************************************************************

DATABASE SYSTEM: localhost
DATABASE NAME: dbt2
DATABASE PORT: 5432
DATABASE CONNECTIONS: 5
TERMINAL THREADS: 10
TERMINALS PER WAREHOUSE: 10
SCALE FACTOR(WAREHOUSES): 1
DURATION OF TEST (in sec): 200
1 client stared every 1000 millisecond(s)

Stage 1. Starting up client...
Sleeping 6 seconds


Stage 3. Processing of results...
Killing client...
scripts/run_workload.sh: line 498: 21719 Terminated              ${abs_top_srcdir}/src/driver ${DRIVER_COMMAND_ARGS} >
${OUTPUT_DIR}/driver.out2>&1 
scripts/run_workload.sh: line 461: 21704 Terminated              ${abs_top_srcdir}/src/client ${CLIENT_COMMAND_ARGS} >
${OUTPUT_DIR}/client.out2>&1 
waiting for server to shut down.... done
server stopped


ERRORS: Client/error.log
"index_info.input", line 10: warning: Skipping data file with no valid
points plot "index_info.data" using 1:2 title "i_customer" with lines,
 "index_info.data" using 1:3 title "i_orders" with lines, "index_info.data"
using 1:4 title "pk_customer" with lines, "index_info.data" using 1:5 title
 "pk_district" with lines, "index_info.data" using 1:6 title "pk_item" with
 lines, "index_info.data" using 1:7 title "pk_new_order" with lines,
"index_info.data" using 1:8 title "pk_order_line" with lines, "index_info.dat
a" using 1:9 title "pk_orders" with lines, "index_info.data" using 1:10
title "pk_stock" with lines, "index_info.data" using 1:11 title "pk_warehouse"
 with lines




                                                                                                                ^ 
"index_info.input", line 10: x range is invalid

Warning: empty y range [0:0], adjusting to [-1:1]
Failed to initialize wxWidgets.
"table_info.input", line 9: warning: Too many axis ticks (>4)
"table_info.input", line 9: warning: Too many axis ticks (>4)
"table_info.input", line 9: warning: Too many axis ticks (>6)
Warning: empty y range [0:0], adjusting to [0:1]
Test completed.
Results are in: /home/megha/tmp/dbt2-0.40/scripts/output/9


I also check the error.log in output 8/client. I didnt understand this error .


%%%%%%Error.log in scripts/8/client

Sun Mar 14 13:36:08 2010
tid:-1216715072 client.c:129
5 DB worker threads have started
Sun Mar 14 13:36:13 2010
tid:-1229304976 libpq/dbc_payment.c:37
SELECT payment(1, 4, 2030, 1, 4, '', 4402.350000)
ERROR:  function payment(integer, integer, integer, integer, integer, unknown, numeric) does not exist
LINE 1: SELECT payment(1, 4, 2030, 1, 4, '', 4402.350000)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Sun Mar 14 13:36:14 2010
tid:-1227207824 libpq/dbc_payment.c:37
SELECT payment(1, 2, 0, 1, 2, 'PRESCALLYPRES', 2940.280000)
ERROR:  function payment(integer, integer, integer, integer, integer, unknown, numeric) does not exist
LINE 1: SELECT payment(1, 2, 0, 1, 2, 'PRESCALLYPRES', 2940.280000)
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


What is next?


Thanks,

On Sun, Mar 14, 2010 at 6:50 AM, John Chandy <chandy@engr.uconn.edu<mailto:chandy@engr.uconn.edu>> wrote:
Megha,

You need to look closely at the output of those files.  Look at the dbstats.out file and you'll see that dbt2 cannot
connectto the pgsql server.  It might be because the database name is different.  You start up postgres with the
databaseat /home/megha/dbt2/pgdata but dbt2 is looking at /home/mega/DATABASE/dbt2 

John.

On Mar 13, 2010, at 8:57 PM, Megha wrote:

Hi


here is the status :
I installed dbt2 successfully. Thoght in last I got msg that "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." cp: cannot stat `scripts/pgsql/pg_hba.conf': No such file or directory"

Started postgres with
/usr/local/pgsql/bin/pg_ctl -D /home/megha/dbt2/pgdata -l logfile start

then I start script run-workload.
[postgres@asnl megha]$ tmp/dbt2-0.40/scripts/run_workload.sh -d 300 -w 1 -c 5
server starting
************************************************************************
*              DBT-2 test for pgsql started
*                                                                      *
*           Results can be found in output/7 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                                            *
*                                                                      *
************************************************************************

DATABASE SYSTEM: localhost
DATABASE NAME: /home/megha/DATABASE/dbt2
DATABASE PORT: 5432
DATABASE CONNECTIONS: 5
TERMINAL THREADS: 10
TERMINALS PER WAREHOUSE: 10
SCALE FACTOR(WAREHOUSES): 1
DURATION OF TEST (in sec): 300
1 client stared every 1000 millisecond(s)

Stage 1. Starting up client...
Sleeping 6 seconds

Stage 2. Starting up driver...
1000 threads started per millisecond
estimated rampup time: Sleeping 20 seconds
estimated rampup time has elapsed
estimated steady state time: Sleeping 300 seconds

Then it generated files in dbt2/scritps/output/6  folder.

[megha@asnl 6]$ ls
client      db           driver      iostat.out   proc.out    stats.out
client.out  dbstats.out  driver.out  iostatx.out  readme.txt  vmstat.out

Let me know what should I do now?
What should I analyze?

Thanks,


On Sat, Mar 13, 2010 at 1:21 PM, John Chandy <chandy@engr.uconn.edu<mailto:chandy@engr.uconn.edu>> wrote:
I'm not sure what that error is.  It looks like dbt2-0.40 does not have that problem.  So, just use 0.40 instead of
0.39.

John.

On Mar 13, 2010, at 1:01 PM, Megha wrote:

> Hi Professor,
>
> When I do configure with
>
> ./configure --with-postgresql=/usr/local/pgsql/ --with-obdc
>
> I get error "configure: error: libpq libs required "
>
> And When i do configure with  ./configure --with-postgresql=/usr/local/pgsql/ --with-obdc --without-sapdb
> I dont get libpq error.
>
> Which command should I use to configure?
>
>
> Thanks
>
>
>
> --
> Megha




--
Megha




--
Megha