BUG #17214: HammerDB-v4.2-TPCH build schema error for virtual users.

Started by PG Bug reporting formover 4 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 17214
Logged by: hpc researcher
Email address: hpcresearch.mspk@gmail.com
PostgreSQL version: 13.3
Operating system: RHEL 8.4
Description:

Tried to build postgreSQL --with-llvm and LLVM_CONFIG=
llvm_path/bin/llvm_config options.
Used LLVM 12.0.1
Steps followed:
1. Built TPCH schema with HammerDB-v4.2
2. Observed following error:
--> Vuser 1:CREATING TPCH INDEXES
Error in Virtual User 1: ERROR: could not load library "
<path/to/postgresql/installation>/lib/postgresql/llvmjit.so":
libLLVMOrcJIT.so.12git: cannot open shared object file: No such file or
directory
--> After fixing the above error observed below error:
Vuser 1:CREATING TPCH INDEXES
Error in Virtual User 1: ERROR: could not load library
"/postgreSQLv13.3v-llvm-build/llvm-build-2/lib/postgresql/llvmjit.so":
<path/to/postgresql/installation>/lib/postgresql/llvmjit.so: undefined
symbol:
_ZN4llvm31install_bad_alloc_error_handlerEPFvPvRKNSt3__112basic_stringIcNS1_11char_traitsIcEENS1_9allocatorIcEEEEbES0_
--> The above API is present in library, even though it is giving error.
postgresql-13.3/src/backend/jit/llvm/llvmjit_error.cpp:62:
llvm::install_bad_alloc_error_handler(fatal_llvm_new_handler);
llvm/Support/ErrorHandling.h:96:void
install_bad_alloc_error_handler(fatal_error_handler_t handler, (llvm
compiler path)
Binary file postgresql-13.3/src/backend/jit/llvm/llvmjit_error.o matches
Binary file postgresql-13.3/src/backend/jit/llvm/llvmjit.so matches
Please do the needful.
Thanks.

#2hpc researcher_mspk
hpcresearch.mspk@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #17214: HammerDB-v4.2-TPCH build schema error for virtual users.

Is there any patch or fix available? Or do I need to install or configure
something?

On Tue, 5 Oct 2021 at 11:12, PG Bug reporting form <noreply@postgresql.org>
wrote:

Show quoted text

The following bug has been logged on the website:

Bug reference: 17214
Logged by: hpc researcher
Email address: hpcresearch.mspk@gmail.com
PostgreSQL version: 13.3
Operating system: RHEL 8.4
Description:

Tried to build postgreSQL --with-llvm and LLVM_CONFIG=
llvm_path/bin/llvm_config options.
Used LLVM 12.0.1
Steps followed:
1. Built TPCH schema with HammerDB-v4.2
2. Observed following error:
--> Vuser 1:CREATING TPCH INDEXES
Error in Virtual User 1: ERROR: could not load library "
<path/to/postgresql/installation>/lib/postgresql/llvmjit.so":
libLLVMOrcJIT.so.12git: cannot open shared object file: No such file or
directory
--> After fixing the above error observed below error:
Vuser 1:CREATING TPCH INDEXES
Error in Virtual User 1: ERROR: could not load library
"/postgreSQLv13.3v-llvm-build/llvm-build-2/lib/postgresql/llvmjit.so":
<path/to/postgresql/installation>/lib/postgresql/llvmjit.so: undefined
symbol:

_ZN4llvm31install_bad_alloc_error_handlerEPFvPvRKNSt3__112basic_stringIcNS1_11char_traitsIcEENS1_9allocatorIcEEEEbES0_
--> The above API is present in library, even though it is giving error.
postgresql-13.3/src/backend/jit/llvm/llvmjit_error.cpp:62:
llvm::install_bad_alloc_error_handler(fatal_llvm_new_handler);
llvm/Support/ErrorHandling.h:96:void
install_bad_alloc_error_handler(fatal_error_handler_t handler, (llvm
compiler path)
Binary file postgresql-13.3/src/backend/jit/llvm/llvmjit_error.o matches
Binary file postgresql-13.3/src/backend/jit/llvm/llvmjit.so matches
Please do the needful.
Thanks.