can't build a docker image

[journeytosilius]

Trying to build with postgres 17 in a ubuntu 22 image, I get this :

7.049 Found ninja-1.11.1 at /usr/bin/ninja
7.634 ninja: Entering directory `/apache-arrow-flight-sql-postgresql-0.1.0.build'
14.53 [1/2] Compiling C++ object arrow_flight_sql.so.p/src_afs.cc.o
14.53 FAILED: arrow_flight_sql.so.p/src_afs.cc.o 
14.53 c++ -Iarrow_flight_sql.so.p -I. -I../apache-arrow-flight-sql-postgresql-0.1.0 -I/usr/include -fdiagnostics-color=always -D_FILE_OFFSET_BITS=64 -Wall -Winvalid-pch -std=c++17 -O0 -g -fPIC -fPIC -isystem/usr/include/postgresql/17/server -MD -MQ arrow_flight_sql.so.p/src_afs.cc.o -MF arrow_flight_sql.so.p/src_afs.cc.o.d -o arrow_flight_sql.so.p/src_afs.cc.o -c ../apache-arrow-flight-sql-postgresql-0.1.0/src/afs.cc
14.53 ../apache-arrow-flight-sql-postgresql-0.1.0/src/afs.cc: In member function ‘virtual arrow::Result<std::unique_ptr<arrow::flight::FlightInfo> > {anonymous}::FlightSQLServer::GetFlightInfoStatement(const arrow::flight::ServerCallContext&, const arrow::flight::sql::StatementQuery&, const arrow::flight::FlightDescriptor&)’:
14.53 ../apache-arrow-flight-sql-postgresql-0.1.0/src/afs.cc:2673:99: error: no matching function for call to ‘arrow::flight::FlightEndpoint::FlightEndpoint(<brace-enclosed initializer list>)’
14.53  2673 |                         arrow::flight::FlightEndpoint{arrow::flight::Ticket{std::move(ticket)}, {}}};
14.53       |                                                                                                   ^

Do you know why could this happen ?

dependencies :

RUN set -ex; \
    apt-get update && apt-get install -y -V \
    ca-certificates \
    lsb-release \
    wget \
    gnupg \
    postgresql-common \
    apt-transport-https \
    meson \
    ninja-build \
    cmake \
    build-essential \
    libkrb5-dev \
    libpq-dev \
    && wget https://apache.jfrog.io/artifactory/arrow/$(lsb_release --id --short | tr 'A-Z' 'a-z')/apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb \
    && apt-get install -y -V ./apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb \
    && apt-get clean

RUN set -ex; \
    apt-get update && apt-get install -y -V \
    libarrow-dev \
    libarrow-glib-dev \
    libarrow-dataset-dev \
    libarrow-dataset-glib-dev \
    libarrow-acero-dev \
    libarrow-flight-dev \
    libarrow-flight-glib-dev \
    libarrow-flight-sql-dev \
    libarrow-flight-sql-glib-dev \
    libgandiva-dev \
    libgandiva-glib-dev \
    libparquet-dev \
    libparquet-glib-dev \
    && apt-get clean

maybe a compiler version ?

[kou]

Ah, Apache Arrow C++ API is changed.
We need to follow the change.

[journeytosilius]

what is the last version that worked with 0.1.0 ?

[kou]

Apache Arrow C++ 17.0.0 or 16.1.0 will work.

[journeytosilius]

thanks

[kou]

Ah, sorry. Apache Arrow C++ 13.0.0 or later may not work...

[journeytosilius]

How can I do this step 👍

    && wget https://apache.jfrog.io/artifactory/arrow/$(lsb_release --id --short | tr 'A-Z' 'a-z')/apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb \
    && apt-get install -y -V ./apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb \
    && apt-get clean

To select the version that works ? I am not familiar with this repository format ! Thanks

[kou]

Could you try this?

    apt-get update && apt-get install -y -V \
    libarrow-dev=12.0.1-1 \
    libarrow-flight-dev=12.0.1-1 \
    libarrow-flight-sql-dev=12.0.1-1 \

[journeytosilius]

1.630 Reading package lists...
3.321 + apt-get install -y -V libarrow-dev=12.0.1-1 libarrow-glib-dev=12.0.1-1 libarrow-dataset-dev=12.0.1-1 libarrow-dataset-glib-dev=12.0.1-1 libarrow-acero-dev=12.0.1-1 libarrow-flight-dev=12.0.1-1 libarrow-flight-glib-dev=12.0.1-1 libarrow-flight-sql-dev=12.0.1-1 libarrow-flight-sql-glib-dev=12.0.1-1 libgandiva-dev=12.0.1-1 libgandiva-glib-dev=12.0.1-1 libparquet-dev=12.0.1-1 libparquet-glib-dev=12.0.1-1
3.337 Reading package lists...
5.066 Building dependency tree...
5.453 Reading state information...
5.494 Package libarrow-acero-dev is not available, but is referred to by another package.
5.494 This may mean that the package is missing, has been obsoleted, or
5.494 is only available from another source
5.494 
5.494 Package libparquet-dev is not available, but is referred to by another package.
5.494 This may mean that the package is missing, has been obsoleted, or
5.494 is only available from another source
5.494 
5.494 Package libarrow-dev is not available, but is referred to by another package.
5.494 This may mean that the package is missing, has been obsoleted, or
5.494 is only available from another source
5.494 
5.494 Package libarrow-glib-dev is not available, but is referred to by another package.
5.494 This may mean that the package is missing, has been obsoleted, or
5.494 is only available from another source

No chance this way, will see if I can find a proper way to do it

[kou]

Could you share full Dockerfile?

[kou]

We need #196 to use this with PostgreSQL 17...