Pessoal, estou tentando rodar o BENCHMARK OSDL-DBT-2 e identifiquei vários
problemas no meu ambiente.
Estou tentando resolver este primeiro:
Descrição: Depois de rodar o Benchmark, executando a linha abaixo, como
usuario Postgres:
$ sh run_workload.sh -c 20 -d 300 -w 1 -o -t
Da um aviso de erro envolvendo o módulo PEARL
=========================================================
Can't locate Test/Parser/Dbt2.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.8/i486-linux-thread-multi /usr/lib/perl5/5.8.8
/usr/lib/perl5/site_perl/5.8.8/i486-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl .) at
/root/projetos/osdldbt/scripts/post-process line 13.
BEGIN failed--compilation aborted at
/root/projetos/osdldbt/scripts/post-process line 13.
=========================================================
Verifiquei lá na pasta e existe a pasta /USR/LIB/PERL5/SITE_PERL, mas a
pasta /usr/lib/perl5/5.8.8/i486-linux-thread-mult não.
Não achei também o arquivo Dbt2.pm
Alguém saberia como corrigir esses erros?
Abaixo segue o log completo da execução:
================L O G C O M P L E T O
====================================
[EMAIL PROTECTED]:/root/projetos/osdldbt/scripts$ sh run_workload.sh -c 20 -d
300 -w 1 -o -t
run_workload.sh: option requires an argument -- t
waiting for server to shut down.... done
server stopped
server starting
************************************************************************
* DBT-2 test for pgsql started
* *
* Results can be found in output/17 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: 20
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 21 seconds
starting oprofile: p4slc
Password:
The specified file /usr/src/linux-2.6.21.5-smp/vmlinux does not seem to be
valid
Make sure you are using the non-compressed image file (e.g. vmlinux not
vmlinuz)
No vmlinux file specified. You must specify the correct vmlinux file, e.g.
opcontrol --vmlinux=/path/to/vmlinux
If you do not have a vmlinux file, use
opcontrol --no-vmlinux
Enter opcontrol --help for full options
No vmlinux file specified. You must specify the correct vmlinux file, e.g.
opcontrol --vmlinux=/path/to/vmlinux
If you do not have a vmlinux file, use
opcontrol --no-vmlinux
Enter opcontrol --help for full options
Stage 2. Starting up driver...
1000 threads started per millisecond
estimated rampup time: Sleeping 20 seconds
estimated rampup time has elapsed
reseting oprofile counters: p4slc
estimated steady state time: Sleeping 300 seconds
oprofile is dumping data: p4slc
Password:
Unable to complete dump of oprofile data: is the oprofile daemon running?
Daemon not running
Stage 3. Processing of results...
Killing client...
run_workload.sh: line 461: 3989 Terminated
${abs_top_srcdir}/src/client ${CLIENT_COMMAND_ARGS}
>${OUTPUT_DIR}/client.out 2>&1
waiting for server to shut down..... done
server stopped
Can't locate Test/Parser/Dbt2.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.8/i486-linux-thread-multi /usr/lib/perl5/5.8.8
/usr/lib/perl5/site_perl/5.8.8/i486-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl .) at
/root/projetos/osdldbt/scripts/post-process line 13.
BEGIN failed--compilation aborted at
/root/projetos/osdldbt/scripts/post-process line 13.
oprofile is annotating source: p4slc
opannotate error: No sample file found: try running opcontrol --dump
or specify a session containing sample files
stopping oprofile daemon: p4slc
Daemon not running
chmod: cannot access `/root/projetos/osdldbt/scripts/output/17/db/log': No
such file or directory
Test completed.
Results are in: /root/projetos/osdldbt/scripts/output/17
============================== F I M LOG
====================================================
Em 13/02/08, Euler Taveira de Oliveira <[EMAIL PROTECTED]> escreveu:
>
> [EMAIL PROTECTED] wrote:
>
> > dai ele gera varios dados de estatisticas, mas olhei todos e nenhum
> > informa as transações por minuto da operação NEW-ORDER.
> > Tem um arquivo chamado NOTPM.INPUT na raiz que eu acho que le um outro
> > arquivo, para gerar essas estatisticas de TPM mas não sei também como
> > usa-lo, segue o código que está dentro dele.
> >
>
> O NOTPM fica em scripts/output/XXX/driver/results.out. Onde XXX é um
> número sequencial de testes realizados.
>
>
>
> --
> Euler Taveira de Oliveira
> http://www.timbira.com/
>
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
