Runing DBT2 on Postgresql

Started by Rohit Goyalover 11 years ago5 messages

rhtgyl.87@gmail.com

over 11 years ago

Hi All,

I am trying to install dbt2 on postgresql database.

cmake(configure) command work fine and but make command(build) give an
error given below. I have no idea about how to solve it

I have set
export LD_LIBRARY_PATH=home/abhi/project/lib:$LD_LIBRARY_PATH
dbt2pgdata = /home/abhi/project/pgsql/DemoDir/

export PATH=$HOME/project/bin:$PATH

CMakeFiles/bin/dbt2-client.dir/src/client.o: In function `startup':
/home/abhi/project/dbt2/src/client.c:344: undefined reference to
`pthread_create'
CMakeFiles/bin/dbt2-client.dir/src/listener.o: In function `init_listener':
/home/abhi/project/dbt2/src/listener.c:94: undefined reference to
`pthread_attr_setstacksize'
/home/abhi/project/dbt2/src/listener.c:99: undefined reference to
`pthread_create'
CMakeFiles/bin/dbt2-client.dir/src/db_threadpool.o: In function
`db_threadpool_init':
/home/abhi/project/dbt2/src/db_threadpool.c:226: undefined reference to
`pthread_attr_setstacksize'
/home/abhi/project/dbt2/src/db_threadpool.c:230: undefined reference to
`pthread_create'
CMakeFiles/bin/dbt2-client.dir/src/common.o: In function `get_think_time':
/home/abhi/project/dbt2/src/common.c:149: undefined reference to `log'
CMakeFiles/bin/dbt2-client.dir/src/libpq/dbc_common.o: In function
`commit_transaction':
/home/abhi/project/dbt2/src/libpq/dbc_common.c:25: undefined reference to
`PQexec'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:26: undefined reference to
`PQresultStatus'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:27: undefined reference to
`PQerrorMessage'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:29: undefined reference to
`PQclear'
CMakeFiles/bin/dbt2-client.dir/src/libpq/dbc_common.o: In function
`_connect_to_db':
/home/abhi/project/dbt2/src/libpq/dbc_common.c:44: undefined reference to
`PQconnectdb'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:45: undefined reference to
`PQstatus'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:48: undefined reference to
`PQerrorMessage'
/home/abhi/project/dbt2/src/libpq/dbc_common.c:49: undefined reference to
`PQfinish'
CMakeFiles/bin/dbt2-client.dir/src/libpq/dbc_common.o: In function
`_disconnect_from_db':
/home/abhi/project/dbt2/src/libpq/dbc_common.c:58: undefined reference to
`PQfinish'

Please guide me through !!

Regards,
Rohit Goyal

Peter Geoghegan

pg@heroku.com

over 11 years ago

In reply to: Rohit Goyal (#1)

Re: Runing DBT2 on Postgresql

On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

I am trying to install dbt2 on postgresql database.

cmake(configure) command work fine and but make command(build) give an error
given below. I have no idea about how to solve it

ld has become less tolerant of certain flag orderings over time in
certain distros. The following tweak may be used as a quick-and-dirty
work around:

diff --git a/CMakeLists.txt b/CMakeLists.txt
index 6a128e3..f6a796b 100644
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -11,6 +11,7 @@ SET(DBT2_CLIENT bin/dbt2-client)
 SET(DBT2_DATAGEN bin/dbt2-datagen)
 SET(DBT2_DRIVER bin/dbt2-driver)
 SET(DBT2_TXN_TEST bin/dbt2-transaction-test)
+set(CMAKE_EXE_LINKER_FLAGS "-Wl,--no-as-needed")

#
# Check for large file support by using 'getconf'.

--
Peter Geoghegan

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

Rohit Goyal

rhtgyl.87@gmail.com

over 11 years ago

In reply to: Peter Geoghegan (#2)

Re: Runing DBT2 on Postgresql

Hi Peter/All,

Can you please elaborate a bit in details the steps? where are how to run
these steps?

Regards,
Rohit Goyal

On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan <pg@heroku.com> wrote:

On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

I am trying to install dbt2 on postgresql database.

cmake(configure) command work fine and but make command(build) give an

error

given below. I have no idea about how to solve it

ld has become less tolerant of certain flag orderings over time in
certain distros. The following tweak may be used as a quick-and-dirty
work around:
diff --git a/CMakeLists.txt b/CMakeLists.txt
index 6a128e3..f6a796b 100644
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -11,6 +11,7 @@ SET(DBT2_CLIENT bin/dbt2-client)
SET(DBT2_DATAGEN bin/dbt2-datagen)
SET(DBT2_DRIVER bin/dbt2-driver)
SET(DBT2_TXN_TEST bin/dbt2-transaction-test)
+set(CMAKE_EXE_LINKER_FLAGS "-Wl,--no-as-needed")
#
# Check for large file support by using 'getconf'.

--
Peter Geoghegan

--
Regards,
Rohit Goyal

Rohit Goyal

rhtgyl.87@gmail.com

over 11 years ago

In reply to: Rohit Goyal (#3)

Re: Runing DBT2 on Postgresql

Hi Everyone,

Sorry, i got this now. :)

Regards,
Rohit Goyal

On Thu, Apr 24, 2014 at 4:24 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

Hi Peter/All,

Can you please elaborate a bit in details the steps? where are how to run
these steps?

Regards,
Rohit Goyal

On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan <pg@heroku.com> wrote:
On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

I am trying to install dbt2 on postgresql database.

cmake(configure) command work fine and but make command(build) give an

error

given below. I have no idea about how to solve it

ld has become less tolerant of certain flag orderings over time in
certain distros. The following tweak may be used as a quick-and-dirty
work around:
diff --git a/CMakeLists.txt b/CMakeLists.txt
index 6a128e3..f6a796b 100644
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -11,6 +11,7 @@ SET(DBT2_CLIENT bin/dbt2-client)
SET(DBT2_DATAGEN bin/dbt2-datagen)
SET(DBT2_DRIVER bin/dbt2-driver)
SET(DBT2_TXN_TEST bin/dbt2-transaction-test)
+set(CMAKE_EXE_LINKER_FLAGS "-Wl,--no-as-needed")
#
# Check for large file support by using 'getconf'.

--
Peter Geoghegan
--
Regards,
Rohit Goyal

--
Regards,
Rohit Goyal

Rohit Goyal

rhtgyl.87@gmail.com

over 11 years ago

In reply to: Peter Geoghegan (#2)

Re: Runing DBT2 on Postgresql

On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan <pg@heroku.com> wrote:

On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

I am trying to install dbt2 on postgresql database.

cmake(configure) command work fine and but make command(build) give an

error

given below. I have no idea about how to solve it

ld has become less tolerant of certain flag orderings over time in
certain distros. The following tweak may be used as a quick-and-dirty
work around:
diff --git a/CMakeLists.txt b/CMakeLists.txt
index 6a128e3..f6a796b 100644
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -11,6 +11,7 @@ SET(DBT2_CLIENT bin/dbt2-client)
SET(DBT2_DATAGEN bin/dbt2-datagen)
SET(DBT2_DRIVER bin/dbt2-driver)
SET(DBT2_TXN_TEST bin/dbt2-transaction-test)
+set(CMAKE_EXE_LINKER_FLAGS "-Wl,--no-as-needed")
#
# Check for large file support by using 'getconf'.

--
Peter Geoghegan

Hi Peter/All,

I installed the dbt-2 benchmark by implementing the change you mentioned.
Now, I am trying to follow the readme_postgresql for running test on
postgresql, but facing an error in understanding changes in dbt2_profile.
Can you explain my next step:

Could you tel me what to write in how to
set environment variables, see examples/dbt2_profile and proceed further.
Please help me and give me some link to run the test.

I cant find bin/pgsql/pgsql_profile.in file also and when i tried to "Create
a 1 warehouse database by running bin/pgsql/dbt2-pgsql-build-db

and put the data files in '/tmp/data':
dbt2-pgsql-build-db -w 1"

I got the error that dbt2-pgsql-build-db not found.

Please guide!!
--

Regards,
Rohit Goyal