[
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 -s
madlib -p greenplum -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.
Following is the log output that i get:
## ****************************
2016-09-24 19:55:49.411167
MYT,"gpadmin","mdo",p10815,th-741669056,"172.20.100.96","30637",2016-09-24
19:55:49 MYT,4416,con97,cmd1,seg-1,,dx93,x4416,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP TABLE IF EXISTS
madlib.migrationhistory;",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP TABLE IF
EXISTS madlib.migrationhistory;",0,,"postgres.c",1620,
2016-09-24 19:55:49.463288
MYT,"gpadmin","mdo",p10823,th-741669056,"172.20.100.96","30643",2016-09-24
19:55:49 MYT,4418,con98,cmd1,seg-1,,dx94,x4418,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
(id serial, version varchar(255),
applied timestamp default current_timestamp);",,,,,,"set
CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
(id serial, version varchar(255),
applied timestamp default
current_timestamp);",0,,"postgres.c",1620,
2016-09-24 19:55:49.566297
MYT,"gpadmin","mdo",p10837,th-741669056,"172.20.100.96","30649",2016-09-24
19:55:49 MYT,4420,con99,cmd1,seg-1,,dx95,x4420,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; INSERT INTO madlib.migrationhistory(version)
VALUES('1.9.1')",,,,,,"set CLIENT_MIN_MESSAGES=error; INSERT INTO
madlib.migrationhistory(version) VALUES('1.9.1')",0,,"postgres.c",1620,
2016-09-24 19:55:49.771303
MYT,"gpadmin","mdo",p10870,th-741669056,"172.20.100.96","30663",2016-09-24
19:55:49 MYT,4422,con100,cmd1,seg-1,,dx96,x4422,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",,,,,,"set
CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",0,,"postgres.c",1620,
2016-09-24 19:56:19.427966
MYT,"gpadmin","mdo",p10902,th-741669056,"172.20.100.96","30673",2016-09-24
19:56:19 MYT,4424,con101,cmd1,seg-1,,dx97,x4424,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT 1",,,,,,"set CLIENT_MIN_MESSAGES=error;
SELECT 1",0,,"postgres.c",1620,
2016-09-24 19:56:19.468237
MYT,"gpadmin","mdo",p10910,th-741669056,"172.20.100.96","30679",2016-09-24
19:56:19 MYT,4426,con102,cmd1,seg-1,,dx98,x4426,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT pg_catalog.version()",,,,,,"set
CLIENT_MIN_MESSAGES=error; SELECT pg_catalog.version()",0,,"postgres.c",1620,
2016-09-24 19:56:19.507181
MYT,"gpadmin","mdo",p10918,th-741669056,"172.20.100.96","30685",2016-09-24
19:56:19 MYT,4428,con103,cmd1,seg-1,,dx99,x4428,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT count(*) AS cnt FROM pg_tables WHERE
schemaname='madlib' AND tablename='migrationhistory'",,,,,,"set
CLIENT_MIN_MESSAGES=error; SELECT count(*) AS cnt FROM pg_tables WHERE
schemaname='madlib' AND tablename='migrationhistory'",0,,"postgres.c",1620,
2016-09-24 19:56:19.551223
MYT,"gpadmin","mdo",p10926,th-741669056,"172.20.100.96","30691",2016-09-24
19:56:19 MYT,4430,con104,cmd1,seg-1,,dx100,x4430,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT version() AS version",,,,,,"set
CLIENT_MIN_MESSAGES=error; SELECT version() AS version",0,,"postgres.c",1620,
2016-09-24 19:56:19.613250
MYT,"gpadmin","mdo",p10934,th-741669056,"172.20.100.96","30697",2016-09-24
19:56:19 MYT,4432,con105,cmd1,seg-1,,dx101,x4432,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT count(*) AS CNT FROM pg_language WHERE
lanname = 'plpythonu'",,,,,,"set CLIENT_MIN_MESSAGES=error; SELECT count(*) AS
CNT FROM pg_language WHERE lanname = 'plpythonu'",0,,"postgres.c",1620,
2016-09-24 19:56:19.654229
MYT,"gpadmin","mdo",p10942,th-741669056,"172.20.100.96","30703",2016-09-24
19:56:19 MYT,4434,con106,cmd1,seg-1,,dx102,x4434,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP FUNCTION IF EXISTS
plpy_version_for_madlib();",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP FUNCTION
IF EXISTS plpy_version_for_madlib();",0,,"postgres.c",1620,
2016-09-24 19:56:19.695231
MYT,"gpadmin","mdo",p10950,th-741669056,"172.20.100.96","30709",2016-09-24
19:56:19 MYT,4436,con107,cmd1,seg-1,,dx103,x4436,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error;
CREATE OR REPLACE FUNCTION plpy_version_for_madlib()
RETURNS TEXT AS
$$
import sys
# return '.'.join(str(item) for item in sys.version_info[:3])
return str(sys.version_info[:3]).replace(',','.').replace('
','').replace(')','').replace('(','')
$$
LANGUAGE plpythonu;",,,,,,"set CLIENT_MIN_MESSAGES=error;
CREATE OR REPLACE FUNCTION plpy_version_for_madlib()
RETURNS TEXT AS
$$
import sys
# return '.'.join(str(item) for item in sys.version_info[:3])
return str(sys.version_info[:3]).replace(',','.').replace('
','').replace(')','').replace('(','')
$$
LANGUAGE plpythonu;
",0,,"postgres.c",1620,
2016-09-24 19:56:19.766835
MYT,"gpadmin","mdo",p10961,th-741669056,"172.20.100.96","30715",2016-09-24
19:56:19 MYT,4438,con108,cmd1,seg-1,,dx104,x4438,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; SELECT plpy_version_for_madlib() AS
ver;",,,,,,"set CLIENT_MIN_MESSAGES=error; SELECT plpy_version_for_madlib() AS
ver;",0,,"postgres.c",1620,
2016-09-24 19:56:19.820213
MYT,"gpadmin","mdo",p10969,th-741669056,"172.20.100.96","30721",2016-09-24
19:56:19 MYT,4440,con109,cmd1,seg-1,,dx105,x4440,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP FUNCTION IF EXISTS
plpy_version_for_madlib();",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP FUNCTION
IF EXISTS plpy_version_for_madlib();",0,,"postgres.c",1620,
2016-09-24 19:56:19.870327
MYT,"gpadmin","mdo",p10980,th-741669056,"172.20.100.96","30727",2016-09-24
19:56:19 MYT,4442,con110,cmd1,seg-1,,dx106,x4442,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.__madlib_test_table (A
INT);",,,,,,"set CLIENT_MIN_MESSAGES=error; CREATE TABLE
madlib.__madlib_test_table (A INT);",0,,"postgres.c",1620,
2016-09-24 19:56:19.896295
MYT,"gpadmin","mdo",p10980,th-741669056,"172.20.100.96","30727",2016-09-24
19:56:19 MYT,4442,con110,cmd1,seg-1,,dx106,x4442,sx1,"ERROR","3F000","schema
""madlib"" does not exist",,,,,,"set CLIENT_MIN_MESSAGES=error; CREATE TABLE
madlib.__madlib_test_table (A INT);",0,,"namespace.c",477,
2016-09-24 19:56:19.911351
MYT,"gpadmin","mdo",p10988,th-741669056,"172.20.100.96","30733",2016-09-24
19:56:19 MYT,4444,con111,cmd1,seg-1,,dx107,x4444,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; CREATE SCHEMA madlib;",,,,,,"set
CLIENT_MIN_MESSAGES=error; CREATE SCHEMA madlib;",0,,"postgres.c",1620,
2016-09-24 19:56:19.971440
MYT,"gpadmin","mdo",p10999,th-741669056,"172.20.100.96","30739",2016-09-24
19:56:19 MYT,4446,con112,cmd1,seg-1,,dx108,x4446,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP TABLE IF EXISTS
madlib.migrationhistory;",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP TABLE IF
EXISTS madlib.migrationhistory;",0,,"postgres.c",1620,
2016-09-24 19:56:20.011259
MYT,"gpadmin","mdo",p11007,th-741669056,"172.20.100.96","30745",2016-09-24
19:56:20 MYT,4448,con113,cmd1,seg-1,,dx109,x4448,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
(id serial, version varchar(255),
applied timestamp default current_timestamp);",,,,,,"set
CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
(id serial, version varchar(255),
applied timestamp default
current_timestamp);",0,,"postgres.c",1620,
2016-09-24 19:56:20.097290
MYT,"gpadmin","mdo",p11021,th-741669056,"172.20.100.96","30751",2016-09-24
19:56:20 MYT,4450,con114,cmd1,seg-1,,dx110,x4450,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; INSERT INTO madlib.migrationhistory(version)
VALUES('1.9.1')",,,,,,"set CLIENT_MIN_MESSAGES=error; INSERT INTO
madlib.migrationhistory(version) VALUES('1.9.1')",0,,"postgres.c",1620,
2016-09-24 19:56:20.287206
MYT,"gpadmin","mdo",p11054,th-741669056,"172.20.100.96","30765",2016-09-24
19:56:20 MYT,4452,con115,cmd1,seg-1,,dx111,x4452,sx1,"LOG","00000","statement:
set CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",,,,,,"set
CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",0,,"postgres.c",1620,
## ****************************
was:
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 -s
madlib -p greenplum -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.
> 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 -s
> madlib -p greenplum -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.
> Following is the log output that i get:
> ## ****************************
> 2016-09-24 19:55:49.411167
> MYT,"gpadmin","mdo",p10815,th-741669056,"172.20.100.96","30637",2016-09-24
> 19:55:49 MYT,4416,con97,cmd1,seg-1,,dx93,x4416,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; DROP TABLE IF EXISTS
> madlib.migrationhistory;",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP TABLE IF
> EXISTS madlib.migrationhistory;",0,,"postgres.c",1620,
> 2016-09-24 19:55:49.463288
> MYT,"gpadmin","mdo",p10823,th-741669056,"172.20.100.96","30643",2016-09-24
> 19:55:49 MYT,4418,con98,cmd1,seg-1,,dx94,x4418,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
> (id serial, version varchar(255),
> applied timestamp default current_timestamp);",,,,,,"set
> CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
> (id serial, version varchar(255),
> applied timestamp default
> current_timestamp);",0,,"postgres.c",1620,
> 2016-09-24 19:55:49.566297
> MYT,"gpadmin","mdo",p10837,th-741669056,"172.20.100.96","30649",2016-09-24
> 19:55:49 MYT,4420,con99,cmd1,seg-1,,dx95,x4420,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; INSERT INTO madlib.migrationhistory(version)
> VALUES('1.9.1')",,,,,,"set CLIENT_MIN_MESSAGES=error; INSERT INTO
> madlib.migrationhistory(version) VALUES('1.9.1')",0,,"postgres.c",1620,
> 2016-09-24 19:55:49.771303
> MYT,"gpadmin","mdo",p10870,th-741669056,"172.20.100.96","30663",2016-09-24
> 19:55:49 MYT,4422,con100,cmd1,seg-1,,dx96,x4422,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",,,,,,"set
> CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.427966
> MYT,"gpadmin","mdo",p10902,th-741669056,"172.20.100.96","30673",2016-09-24
> 19:56:19 MYT,4424,con101,cmd1,seg-1,,dx97,x4424,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; SELECT 1",,,,,,"set CLIENT_MIN_MESSAGES=error;
> SELECT 1",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.468237
> MYT,"gpadmin","mdo",p10910,th-741669056,"172.20.100.96","30679",2016-09-24
> 19:56:19 MYT,4426,con102,cmd1,seg-1,,dx98,x4426,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; SELECT pg_catalog.version()",,,,,,"set
> CLIENT_MIN_MESSAGES=error; SELECT pg_catalog.version()",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.507181
> MYT,"gpadmin","mdo",p10918,th-741669056,"172.20.100.96","30685",2016-09-24
> 19:56:19 MYT,4428,con103,cmd1,seg-1,,dx99,x4428,sx1,"LOG","00000","statement:
> set CLIENT_MIN_MESSAGES=error; SELECT count(*) AS cnt FROM pg_tables WHERE
> schemaname='madlib' AND tablename='migrationhistory'",,,,,,"set
> CLIENT_MIN_MESSAGES=error; SELECT count(*) AS cnt FROM pg_tables WHERE
> schemaname='madlib' AND tablename='migrationhistory'",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.551223
> MYT,"gpadmin","mdo",p10926,th-741669056,"172.20.100.96","30691",2016-09-24
> 19:56:19
> MYT,4430,con104,cmd1,seg-1,,dx100,x4430,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; SELECT version() AS version",,,,,,"set
> CLIENT_MIN_MESSAGES=error; SELECT version() AS version",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.613250
> MYT,"gpadmin","mdo",p10934,th-741669056,"172.20.100.96","30697",2016-09-24
> 19:56:19
> MYT,4432,con105,cmd1,seg-1,,dx101,x4432,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; SELECT count(*) AS CNT FROM pg_language WHERE
> lanname = 'plpythonu'",,,,,,"set CLIENT_MIN_MESSAGES=error; SELECT count(*)
> AS CNT FROM pg_language WHERE lanname = 'plpythonu'",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.654229
> MYT,"gpadmin","mdo",p10942,th-741669056,"172.20.100.96","30703",2016-09-24
> 19:56:19
> MYT,4434,con106,cmd1,seg-1,,dx102,x4434,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; DROP FUNCTION IF EXISTS
> plpy_version_for_madlib();",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP
> FUNCTION IF EXISTS plpy_version_for_madlib();",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.695231
> MYT,"gpadmin","mdo",p10950,th-741669056,"172.20.100.96","30709",2016-09-24
> 19:56:19
> MYT,4436,con107,cmd1,seg-1,,dx103,x4436,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error;
> CREATE OR REPLACE FUNCTION plpy_version_for_madlib()
> RETURNS TEXT AS
> $$
> import sys
> # return '.'.join(str(item) for item in sys.version_info[:3])
> return str(sys.version_info[:3]).replace(',','.').replace('
> ','').replace(')','').replace('(','')
> $$
> LANGUAGE plpythonu;",,,,,,"set CLIENT_MIN_MESSAGES=error;
> CREATE OR REPLACE FUNCTION plpy_version_for_madlib()
> RETURNS TEXT AS
> $$
> import sys
> # return '.'.join(str(item) for item in sys.version_info[:3])
> return str(sys.version_info[:3]).replace(',','.').replace('
> ','').replace(')','').replace('(','')
> $$
> LANGUAGE plpythonu;
> ",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.766835
> MYT,"gpadmin","mdo",p10961,th-741669056,"172.20.100.96","30715",2016-09-24
> 19:56:19
> MYT,4438,con108,cmd1,seg-1,,dx104,x4438,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; SELECT plpy_version_for_madlib() AS
> ver;",,,,,,"set CLIENT_MIN_MESSAGES=error; SELECT plpy_version_for_madlib()
> AS ver;",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.820213
> MYT,"gpadmin","mdo",p10969,th-741669056,"172.20.100.96","30721",2016-09-24
> 19:56:19
> MYT,4440,con109,cmd1,seg-1,,dx105,x4440,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; DROP FUNCTION IF EXISTS
> plpy_version_for_madlib();",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP
> FUNCTION IF EXISTS plpy_version_for_madlib();",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.870327
> MYT,"gpadmin","mdo",p10980,th-741669056,"172.20.100.96","30727",2016-09-24
> 19:56:19
> MYT,4442,con110,cmd1,seg-1,,dx106,x4442,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.__madlib_test_table (A
> INT);",,,,,,"set CLIENT_MIN_MESSAGES=error; CREATE TABLE
> madlib.__madlib_test_table (A INT);",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.896295
> MYT,"gpadmin","mdo",p10980,th-741669056,"172.20.100.96","30727",2016-09-24
> 19:56:19 MYT,4442,con110,cmd1,seg-1,,dx106,x4442,sx1,"ERROR","3F000","schema
> ""madlib"" does not exist",,,,,,"set CLIENT_MIN_MESSAGES=error; CREATE TABLE
> madlib.__madlib_test_table (A INT);",0,,"namespace.c",477,
> 2016-09-24 19:56:19.911351
> MYT,"gpadmin","mdo",p10988,th-741669056,"172.20.100.96","30733",2016-09-24
> 19:56:19
> MYT,4444,con111,cmd1,seg-1,,dx107,x4444,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; CREATE SCHEMA madlib;",,,,,,"set
> CLIENT_MIN_MESSAGES=error; CREATE SCHEMA madlib;",0,,"postgres.c",1620,
> 2016-09-24 19:56:19.971440
> MYT,"gpadmin","mdo",p10999,th-741669056,"172.20.100.96","30739",2016-09-24
> 19:56:19
> MYT,4446,con112,cmd1,seg-1,,dx108,x4446,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; DROP TABLE IF EXISTS
> madlib.migrationhistory;",,,,,,"set CLIENT_MIN_MESSAGES=error; DROP TABLE IF
> EXISTS madlib.migrationhistory;",0,,"postgres.c",1620,
> 2016-09-24 19:56:20.011259
> MYT,"gpadmin","mdo",p11007,th-741669056,"172.20.100.96","30745",2016-09-24
> 19:56:20
> MYT,4448,con113,cmd1,seg-1,,dx109,x4448,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
> (id serial, version varchar(255),
> applied timestamp default current_timestamp);",,,,,,"set
> CLIENT_MIN_MESSAGES=error; CREATE TABLE madlib.migrationhistory
> (id serial, version varchar(255),
> applied timestamp default
> current_timestamp);",0,,"postgres.c",1620,
> 2016-09-24 19:56:20.097290
> MYT,"gpadmin","mdo",p11021,th-741669056,"172.20.100.96","30751",2016-09-24
> 19:56:20
> MYT,4450,con114,cmd1,seg-1,,dx110,x4450,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; INSERT INTO madlib.migrationhistory(version)
> VALUES('1.9.1')",,,,,,"set CLIENT_MIN_MESSAGES=error; INSERT INTO
> madlib.migrationhistory(version) VALUES('1.9.1')",0,,"postgres.c",1620,
> 2016-09-24 19:56:20.287206
> MYT,"gpadmin","mdo",p11054,th-741669056,"172.20.100.96","30765",2016-09-24
> 19:56:20
> MYT,4452,con115,cmd1,seg-1,,dx111,x4452,sx1,"LOG","00000","statement: set
> CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",,,,,,"set
> CLIENT_MIN_MESSAGES=error; DROP SCHEMA madlib CASCADE;",0,,"postgres.c",1620,
> ## ****************************
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
