From: amul sul <sul_amul@yahoo.co.in>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
To: osdldbt-general@lists.sourceforge.net <osdldbt-general@lists.sourceforge.net>
Subject: DBT5 execution failed due to undefined symbol: PQescapeLiteral
Date: Fri, 16 Aug 2013 12:13:16 +0800 (SGT)
Message-ID: <1376626396.99046.YahooMailNeo@web193502.mail.sg3.yahoo.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hello ,
I am trying to run DBT5 to test performance of PG9.2.4,
But execution failed due to undefined symbol: PQescapeLiteral error in <output_dir>/bh/bh.out
Full error as follow:
----------------------------------------------------------------------
dbt5 - Brokerage House
Listening on port: 30000
Using the following database settings:
Host:
Database port:
Database name: dbt5
Brokerage House opened for business, waiting traders...
WARNING: Query CPF2_1 should return 10-30 rows.
NOTICE: CPF2: INPUTS START
NOTICE: CPF2: acct_id 0
NOTICE: CPF2: INPUTS END
WARNING: UNEXPECTED EXECUTION RESULT: customer_position.c 456
SELECT t_id,
t_s_symb,
t_qty,
st_name,
th_dts
FROM (SELECT t_id AS id
FROM trade
WHERE t_ca_id = 0
ORDER BY t_dts DESC
LIMIT 10) AS t,
trade,
trade_history,
status_type
WHERE t_id = id
AND th_t_id = t_id
AND st_id = th_st_id
ORDER BY th_dts DESC
LIMIT 30
BrokerageHouseMain: symbol lookup error: BrokerageHouseMain: undefined symbol: PQescapeLiteral
--------------------------------------------------------------------------
Environment :
CentOS 6.4(Final)
PG installed using source code
DBT5 is cloned from http://github.com/petergeoghegan/dbt5.git
also tried with http://git.code.sf.net/p/osdldbt/dbt repo with pg9.0
same error occur when used with PG9.0,PG9.1 PG9.3beta2
Execution:
1. Database loading :
dbt5-pgsql-build-db -c 1000 -s 500 -w 300 -r
2. Test
dbt5-run-workload -a pgsql -c 1000 -d 300 -u 5 -n dbt5 -t 5000 -w 200 -o /tmp/result
Do I missing something?
Is there anything more need to do?
Thank you !!
Regards,
Amul Sul
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sul_amul@yahoo.co.in, osdldbt-general@lists.sourceforge.net
Subject: Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral
In-Reply-To: <1376626396.99046.YahooMailNeo@web193502.mail.sg3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox