Compile install failed: make[2]: *** [CMakeFiles/duckdb_proj.dir/build.make:86: extra/duckdb/build/release/stamp/duckdb_proj-build] Error 2

[gilbertwu]

My Env:

PLATFORM_ID="platform:el8"
PRETTY_NAME="Oracle Linux Server 8.7"
gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28.0.1)
ldd (GNU libc) 2.28

Build from source but Failed many times:

cmd: -- Specify dir
sh build.sh -t release -d /u01/data/alisql_src/

Some error:

/u01/data/scripts/gilbert/AliSQL/mysys/hash.cc: In function ‘my_hash_value_type my_hash_sort(CHARSET_INFO*, const uchar*, size_t)’:
/u01/data/scripts/gilbert/AliSQL/mysys/hash.cc:48:32: warning: cast from type ‘const uchar*’ {aka ‘const unsigned char*’} to type ‘uchar
’ {aka ‘unsigned char’} casts away qualifiers [-Wcast-qual]
my_ci_hash_sort(cs, (uchar *)key, length, &nr1, &nr2);

Detail log:

compile_err.log

Please help check my error log, thanks.

[p1p1bear]

Hi, @gilbertwu From your log:

-- The C compiler identification is GNU 8.5.0
-- The CXX compiler identification is GNU 8.5.0

I noticed that building the DuckDB dependency failed. You may consider upgrading to GCC/G++ 11 or a later version and trying again.
:)

[gilbertwu]

@p1p1bear
i try to use gcc 12, but still failed, please help to check these log again, include warning message, thanks!

compile.log

warning.log

[p1p1bear]

It looks like the issue is still related to building DuckDB.

You may first try building DuckDB separately. Please run the following commands from the AliSQL source directory:

cd extra/duckdb
mkdir -p build && cd build
make -C .. release

This will help check whether DuckDB can be built successfully on its own.

[gilbertwu]

first, i try to building DuckDB separately, it end succ but with some warning.
then, i continue to building alisql from source, it end failed when "Built target icui18n"

is there some thing wrong in icu?

compile_alisql.log
compile_duckdb_warning.log
compile_duckdb.log

[p1p1bear]

From the compile_alisql.log file you provided, I don’t see any actual compilation error messages. It looks more like the build process was interrupted.

To make things simpler, you may want to use the prebuilt release artifact directly. It corresponds to the tag alisql-8.0.44-1.

[gilbertwu]

ok, thanks, i will try to use it, but my env's glibc version is 2.28, i will test it first.

[gilbertwu]

@p1p1bear
by use the alisql-8.0.44-1-linux-glibc2.17-x86_64.tar.xz directly, i have succ install in my env, thanks a lot.

[gilbertwu]

@p1p1bear
Two document errors were found when i setup to duckdb-node, which are :

1、this two parameters in document ""how-to-setup-duckdb-node-en.md"" should be prefixed with "duckdb_"
dml_in_batch=ON
update_modified_column_only=ON

2、params "update_modified_column_only" in document "duckdb_variables-zh.md" should be updated too.

[p1p1bear]

@p1p1bear Two document errors were found when i setup to duckdb-node, which are :

1、this two parameters in document ""how-to-setup-duckdb-node-en.md"" should be prefixed with "duckdb_" dml_in_batch=ON update_modified_column_only=ON

2、params "update_modified_column_only" in document "duckdb_variables-zh.md" should be updated too.

Fixed! thanks:)