You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Atif (JIRA)" <ji...@apache.org> on 2016/09/24 10:48:21 UTC
[jira] [Updated] (MADLIB-1026) Support for Greenplum 4.30RCA
[ https://issues.apache.org/jira/browse/MADLIB-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atif updated MADLIB-1026:
-------------------------
Description:
Hi there,
Lately I have setup a 02 node cluster for Greenplum 4.3RC, however cannot setup madlib. Following is the error that I get when i try to install madlib
gppkg installation was successful.
[gpadmin@GPDB2-M1 ~]$ gppkg -i GPDB_4.3/madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
20160924:18:10:58:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Starting gppkg with args: -i GPDB_4.3/madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
20160924:18:10:59:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing package madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
20160924:18:10:59:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix /home/gpadmin/GPDB/install'
20160924:18:11:02:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg locally
20160924:18:11:03:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix /home/gpadmin/GPDB/install'
20160924:18:11:03:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing rpms cmdStr='rpm -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix=/home/gpadmin/GPDB/install'
20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Completed local installation of madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg.
20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Please run the following command to deploy MADlib
usage: madpack install [-s schema_name] -p greenplum -c user@host:port/database
Example:
$ $GPHOME/madlib/bin/madpack install -s madlib -p greenplum -c gpadmin@mdw:5432/testdb
This will install MADlib objects into a Greenplum database named "testdb"
running on server "mdw" on port 5432. Installer will try to login as "gpadmin"
and will prompt for password. The target schema will be "madlib".
To upgrade to a new version of MADlib from version v1.0 or later, use option "upgrade",
instead of "install"
For additional options run:
$ madpack --help
Release notes and additional documentation can be found at http://madlib.net
20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg successfully installed.
but madlib installation has failed.
[gpadmin@GPDB2-M1 ~]$ /home/gpadmin/GPDB/greenplum-db/madlib/bin/madpack -p 'greenplum' -s mdo -c gpadmin@GPDB2-M1:5432/mdo install
madpack.py : INFO : Detected Greenplum DB version 4.3ORCA.
madpack.py : INFO : *** Installing MADlib ***
madpack.py : INFO : MADlib tools version = 1.7.1 (/home/gpadmin/GPDB/install/madlib/Versions/1.7.1/bin/../madpack/madpack.py)
madpack.py : INFO : MADlib database version = None (host=GPDB2-M1:5432, db=mdo, schema=mdo)
madpack.py : INFO : Testing PL/Python environment...
madpack.py : INFO : > PL/Python environment OK (version: 2.6.2)
madpack.py : INFO : Installing MADlib into MDO schema...
madpack.py : INFO : > Creating MDO schema
madpack.py : INFO : > Creating MDO.MigrationHistory table
madpack.py : INFO : > Writing version info in MigrationHistory table
madpack.py : INFO : > Creating objects for modules:
madpack.py : INFO : > - array_ops
madpack.py : ERROR : Failed executing m4 on /home/gpadmin/GPDB/install/madlib/Versions/1.7.1/ports/greenplum/modules/array_ops/array_ops.sql_in
madpack.py : INFO : Rolling back the installation...
madpack.py : INFO : Rollback finished successfully.
madpack.py : ERROR : MADlib installation failed.
Underlying platform in this case is CentOS 7.
[gpadmin@GPDB2-M1 ~]$ psql -c 'select version()'
version
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------
PostgreSQL 8.2.15 (Greenplum Database 4.3.9.1 build commit:095e92e4ecbbbb6764897ca98b1cb7705ad0c805) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Aug
24 2016 06:30:45
(1 row)
Please note that I have tried to work with 1.7 / 1.8 and 1.9 all version break at the same point. Can you please guide me as what might be wrong.
was:
Regular platform support work associated with 9.5 release
http://www.postgresql.org/docs/devel/static/release-9-5.html
Also put in code to support 9.6 since it is due out in Sept 2016 and we want to do a PostgreSQL event in the fall so good to be up to date. Postgres folks tell us that there are no changes coming between now and Sept in 9.6 that would affect MADlib so could just use the latest beta for testing.
> Support for Greenplum 4.30RCA
> -----------------------------
>
> Key: MADLIB-1026
> URL: https://issues.apache.org/jira/browse/MADLIB-1026
> Project: Apache MADlib
> Issue Type: Task
> Components: All Modules
> Reporter: Atif
> Priority: Minor
> Fix For: v1.9.1
>
>
> Hi there,
> Lately I have setup a 02 node cluster for Greenplum 4.3RC, however cannot setup madlib. Following is the error that I get when i try to install madlib
> gppkg installation was successful.
> [gpadmin@GPDB2-M1 ~]$ gppkg -i GPDB_4.3/madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
> 20160924:18:10:58:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Starting gppkg with args: -i GPDB_4.3/madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
> 20160924:18:10:59:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing package madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg
> 20160924:18:10:59:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix /home/gpadmin/GPDB/install'
> 20160924:18:11:02:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg locally
> 20160924:18:11:03:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Validating rpm installation cmdStr='rpm --test -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix /home/gpadmin/GPDB/install'
> 20160924:18:11:03:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Installing rpms cmdStr='rpm -i /home/gpadmin/GPDB/install/.tmp/madlib-1.7.1-1.x86_64.rpm --dbpath /home/gpadmin/GPDB/install/share/packages/database --prefix=/home/gpadmin/GPDB/install'
> 20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Completed local installation of madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg.
> 20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-Please run the following command to deploy MADlib
> usage: madpack install [-s schema_name] -p greenplum -c user@host:port/database
> Example:
> $ $GPHOME/madlib/bin/madpack install -s madlib -p greenplum -c gpadmin@mdw:5432/testdb
> This will install MADlib objects into a Greenplum database named "testdb"
> running on server "mdw" on port 5432. Installer will try to login as "gpadmin"
> and will prompt for password. The target schema will be "madlib".
> To upgrade to a new version of MADlib from version v1.0 or later, use option "upgrade",
> instead of "install"
> For additional options run:
> $ madpack --help
> Release notes and additional documentation can be found at http://madlib.net
> 20160924:18:11:04:005508 gppkg:GPDB2-M1:gpadmin-[INFO]:-madlib-ossv1.7.1_pv1.9.3_gpdb4.3orca-rhel5-x86_64.gppkg successfully installed.
> but madlib installation has failed.
> [gpadmin@GPDB2-M1 ~]$ /home/gpadmin/GPDB/greenplum-db/madlib/bin/madpack -p 'greenplum' -s mdo -c gpadmin@GPDB2-M1:5432/mdo install
> madpack.py : INFO : Detected Greenplum DB version 4.3ORCA.
> madpack.py : INFO : *** Installing MADlib ***
> madpack.py : INFO : MADlib tools version = 1.7.1 (/home/gpadmin/GPDB/install/madlib/Versions/1.7.1/bin/../madpack/madpack.py)
> madpack.py : INFO : MADlib database version = None (host=GPDB2-M1:5432, db=mdo, schema=mdo)
> madpack.py : INFO : Testing PL/Python environment...
> madpack.py : INFO : > PL/Python environment OK (version: 2.6.2)
> madpack.py : INFO : Installing MADlib into MDO schema...
> madpack.py : INFO : > Creating MDO schema
> madpack.py : INFO : > Creating MDO.MigrationHistory table
> madpack.py : INFO : > Writing version info in MigrationHistory table
> madpack.py : INFO : > Creating objects for modules:
> madpack.py : INFO : > - array_ops
> madpack.py : ERROR : Failed executing m4 on /home/gpadmin/GPDB/install/madlib/Versions/1.7.1/ports/greenplum/modules/array_ops/array_ops.sql_in
> madpack.py : INFO : Rolling back the installation...
> madpack.py : INFO : Rollback finished successfully.
> madpack.py : ERROR : MADlib installation failed.
> Underlying platform in this case is CentOS 7.
> [gpadmin@GPDB2-M1 ~]$ psql -c 'select version()'
> version
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> ------------------
> PostgreSQL 8.2.15 (Greenplum Database 4.3.9.1 build commit:095e92e4ecbbbb6764897ca98b1cb7705ad0c805) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Aug
> 24 2016 06:30:45
> (1 row)
> Please note that I have tried to work with 1.7 / 1.8 and 1.9 all version break at the same point. Can you please guide me as what might be wrong.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)