Thread: DBT5 execution failed due to undefined symbol: PQescapeLiteral

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

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

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-PQescapeLiteral-tp5767580p5767992.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.