Thread: Can't locate Test/Parser/Dbt2.pm in DBT2 tests

Can't locate Test/Parser/Dbt2.pm in DBT2 tests

From

Rohan Pethkar

Date:

06 February 2009, 10:37:38

Hi All,

I am conductingDBT2 tests on PostgreSQL. After completing the test while analyzing and creating the results I am getting following error:

./dbt2-run-workload: line 514: 731 Terminated dbt2-client ${CLIENT_COMMAND_ARGS} -p ${PORT} -o ${CDIR} > ${CLIENT_OUTPUT_DIR}/`hostname`/client-${SEG}.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/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-post-process line 13.
BEGIN failed--compilation aborted at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-post-process line 13.
The authenticity of host 'localhost (127.0.0.1)' can't be established.
RSA key fingerprint is 87:1e:a0:e0:4f:b7:32:42:3d:5c:85:10:f3:25:63:8d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'localhost' (RSA) to the list of known hosts.
Write failed: Broken pipe
Creating chart for Index Scans...
Creating chart for Index Blocks Read...
Creating chart for Index Blocks Hit...
Creating chart for Table Blocks Read...
Creating chart for Table Blocks Hit...
Creating chart for Sequential Scans...
Creating chart for Rows Inserted...
Creating chart for Rows Updated...
Creating chart for Row Deleted...
Creating chart for HOT Rows Updated...
Creating chart for Dead Tuples...
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Can't exec "gnuplot": No such file or directory at /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line 113.
Test completed.
Results are in: OUTPUT

I ma not sure why it doesn't find Test/Parser/Dbt2.pm even if I have installed DBT2 completely. Did I miss any steps? Do I need to install some extra packages? If any then please let me know.

Thanks in advance for your help.

Thanks,
Rohan

Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests

From

Richard Huxton

Date:

06 February 2009, 10:47:07

Rohan Pethkar wrote:
> Hi All,
>
> I am conductingDBT2 tests on PostgreSQL. After completing the test while
> analyzing and creating the results I am getting following error:
>
> ./dbt2-run-workload: line 514:   731 Terminated              dbt2-client
> ${CLIENT_COMMAND_ARGS} -p ${PORT} -o ${CDIR} >
> ${CLIENT_OUTPUT_DIR}/`hostname`/client-${SEG}.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/site_perl/5.8.8/x86_64-linux-thread-multi
> /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi
> /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi
> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
> /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
> /usr/lib/perl5/site_perl
> /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
> /usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux-thread-multi
> /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi
> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
> /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
> /usr/lib/perl5/5.8.8 .) at
> /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-post-process line 13.

Well, if Test::Parser::Dbt2 isn't in somewhere in that list of
directories, you'll need to tell perl where to look. Simplest is
probably just to:
  export PERL5LIB="/path/to/extra/libs"
before running your tests.

> Can't exec "gnuplot": No such file or directory at
> /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line
> 113.

It also looks like you're missing gnuplot for your charts.

> I ma not sure why it doesn't find Test/Parser/Dbt2.pm even if I have
> installed DBT2 completely. Did I miss any steps? Do I need to install some
> extra packages? If any then please let me know.

You can always "perldoc perlrun" for more info (google it if you don't
have docs installed locally).

--
  Richard Huxton
  Archonet Ltd

Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests

From

Mark Wong

Date:

07 February 2009, 04:46:50

On Fri, Feb 6, 2009 at 3:46 AM, Richard Huxton <dev@archonet.com> wrote:
> Rohan Pethkar wrote:
>> Hi All,
>>
>> I am conductingDBT2 tests on PostgreSQL. After completing the test while
>> analyzing and creating the results I am getting following error:
>>
>> ./dbt2-run-workload: line 514:   731 Terminated              dbt2-client
>> ${CLIENT_COMMAND_ARGS} -p ${PORT} -o ${CDIR} >
>> ${CLIENT_OUTPUT_DIR}/`hostname`/client-${SEG}.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/site_perl/5.8.8/x86_64-linux-thread-multi
>> /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi
>> /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi
>> /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi
>> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
>> /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
>> /usr/lib/perl5/site_perl
>> /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
>> /usr/lib64/perl5/vendor_perl/5.8.7/x86_64-linux-thread-multi
>> /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi
>> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi
>> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
>> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
>> /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
>> /usr/lib/perl5/5.8.8 .) at
>> /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-post-process line 13.
>
> Well, if Test::Parser::Dbt2 isn't in somewhere in that list of
> directories, you'll need to tell perl where to look. Simplest is
> probably just to:
>  export PERL5LIB="/path/to/extra/libs"
> before running your tests.
>
>> Can't exec "gnuplot": No such file or directory at
>> /home/rohan/NEW_DBT2/Installer/DBT2_SETUP/bin/dbt2-pgsql-analyze-stats line
>> 113.
>
> It also looks like you're missing gnuplot for your charts.
>
>> I ma not sure why it doesn't find Test/Parser/Dbt2.pm even if I have
>> installed DBT2 completely. Did I miss any steps? Do I need to install some
>> extra packages? If any then please let me know.
>
> You can always "perldoc perlrun" for more info (google it if you don't
> have docs installed locally).

Hi Rohan,

In addition to what Richard said, I'm guessing you don't have those
perl modules installed.  In the main README file lists the perl
modules required for the post processing of the data colelcted, which
is what failed here:

"The data analysis scripts requires two additional Perl packages to be
installed,
which are not checked by configure.  They are Statistics::Descriptive and
Test::Parser.  To generate HTML reports, Test::Reporter is required."

Sorry, it's still a work in progress., as slow as that may be.

Regards,
Mark