DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=kGOI9q4TdJ/TlC0T67szPcMCs/hXgaFX8N00VUFpoKtrcFHj26CRVkBMwyndIJuLroIffQCnhA7aJN7mU2kDIEHLk4h7VGCVSEBj78C7oQ8V7zoEe0OW5DtQb4bG/HjAMe4gWQm5N1n0owhLcDm15MzsMZZvuL1WlRGZgmby9ss=;
Message-ID: <1376626396.99046.YahooMailNeo@web193502.mail.sg3.yahoo.com>
Date: Fri, 16 Aug 2013 12:13:16 +0800 (SGT)
From: amul sul <sul_amul@yahoo.co.in>
Reply-To: amul sul <sul_amul@yahoo.co.in>
Subject: DBT5 execution failed due to  undefined symbol: PQescapeLiteral
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>,
 "osdldbt-general@lists.sourceforge.net"
 <osdldbt-general@lists.sourceforge.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hello ,

I am trying to run DBT5 to test performance of PG9.2.4,

But execution failed due to=A0undefined symbol: PQescapeLiteral error in <o=
utput_dir>/bh/bh.out

Full error as follow:=A0
----------------------------------------------------------------------
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: =A0Query CPF2_1 should return 10-30 rows.
NOTICE: =A0CPF2: INPUTS START
NOTICE: =A0CPF2: acct_id 0
NOTICE: =A0CPF2: INPUTS END
WARNING: =A0UNEXPECTED EXECUTION RESULT: customer_position.c 456
SELECT =A0 t_id,
=A0 =A0 =A0 =A0 =A0t_s_symb,
=A0 =A0 =A0 =A0 =A0t_qty,
=A0 =A0 =A0 =A0 =A0st_name,
=A0 =A0 =A0 =A0 =A0th_dts
FROM =A0 =A0 (SELECT =A0 t_id AS id
=A0 =A0 =A0 =A0 =A0 FROM =A0 =A0 trade
=A0 =A0 =A0 =A0 =A0 WHERE =A0 =A0t_ca_id =3D 0
=A0 =A0 =A0 =A0 =A0 ORDER BY t_dts DESC
=A0 =A0 =A0 =A0 =A0 LIMIT 10) AS t,
=A0 =A0 =A0 =A0 =A0trade,
=A0 =A0 =A0 =A0 =A0trade_history,
=A0 =A0 =A0 =A0 =A0status_type
WHERE =A0 =A0t_id =3D id
=A0 =A0 =A0 =A0 =A0AND th_t_id =3D t_id
=A0 =A0 =A0 =A0 =A0AND st_id =3D th_st_id
ORDER BY th_dts DESC
LIMIT 30
BrokerageHouseMain: symbol lookup error: BrokerageHouseMain: undefined symb=
ol: PQescapeLiteral
--------------------------------------------------------------------------

Environment :
=A0
CentOS 6.4(Final)
PG installed using source code

DBT5 is cloned from=A0http://github.com/petergeoghegan/dbt5.git
also tried with=A0http://git.code.sf.net/p/osdldbt/dbt=A0repo with pg9.0=A0

same error occur when used with PG9.0,PG9.1 PG9.3beta2

Execution:=A0

1. Database loading :
=A0dbt5-pgsql-build-db -c 1000 -s 500 -w 300 -r


2. Test=A0
dbt5-run-workload -a pgsql -c 1000 -d 300 -u 5 -n dbt5 -t 5000 -w 200 -o /t=
mp/result


Do I missing something?
Is there anything more need to do? =A0

Thank you !!

Regards,
Amul Sul


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance