Pessoal, rodei de novo e nada ainda. No outro email que vou mandar vai ter
uma figura que mostra os arquivos gerados, se puderem abrir p/ ver. Com que
usuario que se roda o script run_workload.sh, pois quando rodo como root, da
erro que não consegue assessar o pg_ctl, etc. Quando rodo como usuario
POSTGRES ele da o erro que não é dono do arquivo: segue o erro
- Ocultar texto das mensagens anteriores -
====================
profile is dumping data: p4slc
Password:
postgres is not in the sudoers file. This incident will be reported.
====================
Outra, coisa, porque ele não gera os arquivos .data, por exemplo:
notpm.datapois acho que é este que precisa para plotar o grafico de
transações de
NEW-ORDER usando o GNUPLOT.
Segue abaixo o log da execução. Preciso saber porque não ta gerando os
arquivos .data que são essenciais para gerar os graficos. Vejam no final
que da um erro que não consegue abrir o GNUPLOT, embora eu tenha instalado
certinho. Obrigado!
*************************** MENSAGEM RETORNADA NO CONSOLE, APOS EXECUÇÃO
******************************
- Ocultar texto das mensagens anteriores -
**********
[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............................................................... failed
pg_ctl: server does not shut down
Database is already started.
************************************************************************
* DBT-2 test for pgsql started
* *
* Results can be found in output/12 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:
Sorry, try again.
Password:
postgres is not in the sudoers file. This incident will be reported.
postgres is not in the sudoers file. This incident will be reported.
postgres is not in the sudoers file. This incident will be reported.
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
postgres is not in the sudoers file. This incident will be reported.
estimated steady state time: Sleeping 300 seconds
oprofile is dumping data: p4slc
Password:
postgres is not in the sudoers file. This incident will be reported.
postgres is not in the sudoers file. This incident will be reported.
Stage 3. Processing of results...
Killing client...
waiting for server to shut
down............................................................... failed
pg_ctl: server does not shut down
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
postgres is not in the sudoers file. This incident will be reported.
stopping oprofile daemon: p4slc
postgres is not in the sudoers file. This incident will be reported.
chmod: cannot access `/root/projetos/osdldbt/scripts/output/12/db/log': No
such file or directory
plot "indexes_scan.data" using 1:2 title "i_customer" with lines,
"indexes_scan.data" using 1:3 title "i_orders" with lines,
"indexes_scan.data" using 1:4 title "pk_customer" with lines,
"indexes_scan.data" using 1:5 title "pk_district" with lines,
"indexes_scan.data" using 1:6 title "pk_item" with lines,
"indexes_scan.data" using 1:7 title "pk_new_order" with lines,
"indexes_scan.data" using 1:8 title "pk_order_line" with lines,
"indexes_scan.data" using 1:9 title "pk_orders" with lines,
"indexes_scan.data" using 1:10 title "pk_stock" with lines,
"indexes_scan.data" using 1:11 title "pk_warehouse" with lines
No protocol
specified
gnuplot: unable to open display ':0'
gnuplot: X11 aborted.
Test completed.
Results are in: /root/projetos/osdldbt/scripts/output/12
[EMAIL PROTECTED]:/root/projetos/osdldbt/scripts$ ]No protocol specified
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
