pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
DBT5 execution failed due to undefined symbol: PQescapeLiteral 3+ messages / 3 participants [nested] [flat]
* DBT5 execution failed due to undefined symbol: PQescapeLiteral @ 2013-08-16 04:13 amul sul <sul_amul@yahoo.co.in> 2013-08-16 07:26 ` Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral Albe Laurenz <laurenz.albe@wien.gv.at> 0 siblings, 1 reply; 3+ messages in thread From: amul sul @ 2013-08-16 04:13 UTC (permalink / raw) To: pgsql-performance; osdldbt-general@lists.sourceforge.net <osdldbt-general@lists.sourceforge.net> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral 2013-08-16 04:13 DBT5 execution failed due to undefined symbol: PQescapeLiteral amul sul <sul_amul@yahoo.co.in> @ 2013-08-16 07:26 ` Albe Laurenz <laurenz.albe@wien.gv.at> 2013-08-20 07:13 ` Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral amulsul <sul_amul@yahoo.co.in> 0 siblings, 1 reply; 3+ messages in thread From: Albe Laurenz @ 2013-08-16 07:26 UTC (permalink / raw) To: amul sul <sul_amul@yahoo.co.in>; pgsql-performance; osdldbt-general@lists.sourceforge.net <osdldbt-general@lists.sourceforge.net> amul sul wrote: > 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: [...] > 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 That is a problem on the client side. I guess that your binary was built and linked with PostgreSQL client library (libpq) from version 9.0 or later, but you are trying to run it with a libpq.so from version 8.4 or earlier (where PQescapeLiteral was not defined). In that case you should upgrade the PostgreSQL client. Yours, Laurenz Albe -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral 2013-08-16 04:13 DBT5 execution failed due to undefined symbol: PQescapeLiteral amul sul <sul_amul@yahoo.co.in> 2013-08-16 07:26 ` Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral Albe Laurenz <laurenz.albe@wien.gv.at> @ 2013-08-20 07:13 ` amulsul <sul_amul@yahoo.co.in> 0 siblings, 0 replies; 3+ messages in thread From: amulsul @ 2013-08-20 07:13 UTC (permalink / raw) To: pgsql-performance Hi Laurenz Albe , Thanks for reply. Your guess was correct :). It worked for me exporting LD_LIBRARY_PATH to postgres9.2 lib directory. Thanks again for your help. Regards, Amul Sul -- View this message in context: http://postgresql.1045698.n5.nabble.com/DBT5-execution-failed-due-to-undefined-symbol-PQescapeLitera... Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-08-20 07:13 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2013-08-16 04:13 DBT5 execution failed due to undefined symbol: PQescapeLiteral amul sul <sul_amul@yahoo.co.in> 2013-08-16 07:26 ` Albe Laurenz <laurenz.albe@wien.gv.at> 2013-08-20 07:13 ` amulsul <sul_amul@yahoo.co.in>
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