[
https://issues.apache.org/jira/browse/MADLIB-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15522635#comment-15522635
]
Martin Jensen edited comment on MADLIB-1024 at 9/26/16 10:38 AM:
-----------------------------------------------------------------
I can successfully build form source and install
I can reproduce the error with pgxn. This is my docker file that can reproduce
---Dockerfile start----
FROM postgres:9.5
RUN apt-get update && apt-get install -y wget \
build-essential \
postgresql-common \
postgresql-server-dev-9.5 \
postgresql-plpython-9.5 \
openssl \
libssl-dev \
libboost-all-dev \
m4 \
wget \
pgxnclient
# Build custom CMake eith SSQL support
RUN wget https://cmake.org/files/v3.5/cmake-3.5.2.tar.gz && \
tar -zxvf cmake-3.5.2.tar.gz && \
cd cmake-3.5.2 && \
sed -i 's/-DCMAKE_BOOTSTRAP=1/-DCMAKE_BOOTSTRAP=1
-DCMAKE_USE_OPENSSL=ON/g' bootstrap && \
./configure && \
make -j2 && \
make install
## THIS METHOD IS WORKING:
#RUN wget
https://dist.apache.org/repos/dist/release/incubator/madlib/1.9.1-incubating/apache-madlib-1.9.1-incubating-source.tar.gz
&& \
# tar -xvf apache-madlib-1.9.1-incubating-source.tar.gz && \
# cd incubator-madlib-e1c99c1 && \
# mkdir build && \
# cd build && \
# cmake .. && \
# make && \
# make install && \
# /incubator-madlib-e1c99c1/build/src/bin/madpack -p postgres -c
postgres/postgres@localhost:5432/postgres install
## THIS IS NOT WORKING:
RUN pgxn install madlib
# When container is up, connect to connect to cotainer with psql:
# psql -h localhost -U postres -c "CREATE EXTENSION plpythonu;CREATE EXTENSION
madlib"
---Dockerfile end----
Build
docker build -t madlib .
Run
docker run -d --name madlib madlib
# execute command in container
docker exec -it madlib psql -U postgres -c "CREATE EXTENSION plpythonu;CREATE
EXTENSION madlib"
ERROR: aggregate cannot accept shell type public.svec
was (Author: martinjensen):
I can successfully build form source and install
I can reproduce the error with pgxn. This is my docker file that can reproduce
---Dockerfile start----
FROM postgres:9.5
RUN apt-get update && apt-get install -y wget \
build-essential \
postgresql-common \
postgresql-server-dev-9.5 \
postgresql-plpython-9.5 \
openssl \
libssl-dev \
libboost-all-dev \
m4 \
wget \
pgxnclient
# Build custom CMake eith SSQL support
RUN wget https://cmake.org/files/v3.5/cmake-3.5.2.tar.gz && \
tar -zxvf cmake-3.5.2.tar.gz && \
cd cmake-3.5.2 && \
sed -i 's/-DCMAKE_BOOTSTRAP=1/-DCMAKE_BOOTSTRAP=1
-DCMAKE_USE_OPENSSL=ON/g' bootstrap && \
./configure && \
make -j2 && \
make install
## THIS METHID IS WORKING:
#RUN wget
https://dist.apache.org/repos/dist/release/incubator/madlib/1.9.1-incubating/apache-madlib-1.9.1-incubating-source.tar.gz
&& \
# tar -xvf apache-madlib-1.9.1-incubating-source.tar.gz && \
# cd incubator-madlib-e1c99c1 && \
# mkdir build && \
# cd build && \
# cmake .. && \
# make && \
# make install && \
# /incubator-madlib-e1c99c1/build/src/bin/madpack -p postgres -c
postgres/postgres@localhost:5432/postgres install
## THIS IS NOT WORKING:
RUN pgxn install madlib
# When container is up, connect to connect to cotainer with psql:
# psql -h localhost -U postres -c "CREATE EXTENSION plpythonu;CREATE EXTENSION
madlib"
---Dockerfile end----
Build
docker build -t madlib .
Run
docker run -d --name madlib madlib
# execute command in container
docker exec -it madlib psql -U postgres -c "CREATE EXTENSION plpythonu;CREATE
EXTENSION madlib"
ERROR: aggregate cannot accept shell type public.svec
> CREATE EXTENSION madlib fails
> -----------------------------
>
> Key: MADLIB-1024
> URL: https://issues.apache.org/jira/browse/MADLIB-1024
> Project: Apache MADlib
> Issue Type: Bug
> Reporter: Martin Jensen
> Assignee: Orhan Kislal
> Fix For: v1.10
>
>
> When installing madlib with PGXN on PG 9.5.4, Ubuntu 16.04 I get the
> following error when trying to create the extension:
> ERROR: aggregate cannot accept shell type public.svec
> ********** Error **********
> ERROR: aggregate cannot accept shell type public.svec
> SQL state: 42P13
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
