[
https://issues.apache.org/jira/browse/MADLIB-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15863802#comment-15863802
]
John Grant commented on MADLIB-1068:
------------------------------------
Installing on a fresh Ubuntu 14.04 & default PostgreSQL 9.3 instance, the
MADlib tests finish with only a few errors:
{code}
madpack -s madlib -c postgres@localhost -p postgres install-check
Password for user postgres:
madpack.py : INFO : Detected PostgreSQL version 9.3.
TEST CASE RESULT|Module: array_ops|array_ops.sql_in|PASS|Time: 235 milliseconds
TEST CASE RESULT|Module: bayes|gaussian_naive_bayes.sql_in|PASS|Time: 756
milliseconds
TEST CASE RESULT|Module: bayes|bayes.sql_in|PASS|Time: 2253 milliseconds
TEST CASE RESULT|Module: crf|crf_train_small.sql_in|PASS|Time: 1323 milliseconds
TEST CASE RESULT|Module: crf|crf_train_large.sql_in|PASS|Time: 1386 milliseconds
TEST CASE RESULT|Module: crf|crf_test_small.sql_in|PASS|Time: 1105 milliseconds
TEST CASE RESULT|Module: crf|crf_test_large.sql_in|PASS|Time: 1249 milliseconds
TEST CASE RESULT|Module:
elastic_net|elastic_net_install_check.sql_in|PASS|Time: 1895 milliseconds
TEST CASE RESULT|Module: linalg|svd.sql_in|PASS|Time: 1767 milliseconds
TEST CASE RESULT|Module: linalg|matrix_ops.sql_in|PASS|Time: 3989 milliseconds
TEST CASE RESULT|Module: linalg|linalg.sql_in|PASS|Time: 401 milliseconds
TEST CASE RESULT|Module: pmml|table_to_pmml.sql_in|PASS|Time: 3077 milliseconds
TEST CASE RESULT|Module: pmml|pmml_rf.sql_in|PASS|Time: 2299 milliseconds
TEST CASE RESULT|Module: pmml|pmml_ordinal.sql_in|PASS|Time: 1494 milliseconds
TEST CASE RESULT|Module: pmml|pmml_multinom.sql_in|PASS|Time: 1181 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_poisson.sql_in|PASS|Time: 1018
milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_normal.sql_in|PASS|Time: 978 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_ig.sql_in|PASS|Time: 1041 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_gamma.sql_in|PASS|Time: 2150 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_binomial.sql_in|PASS|Time: 1270
milliseconds
TEST CASE RESULT|Module: pmml|pmml_dt.sql_in|PASS|Time: 1454 milliseconds
TEST CASE RESULT|Module: prob|prob.sql_in|PASS|Time: 212 milliseconds
TEST CASE RESULT|Module: sketch|support.sql_in|PASS|Time: 52 milliseconds
TEST CASE RESULT|Module: sketch|mfv.sql_in|PASS|Time: 854 milliseconds
TEST CASE RESULT|Module: sketch|fm.sql_in|PASS|Time: 1372 milliseconds
TEST CASE RESULT|Module: sketch|cm.sql_in|PASS|Time: 4772 milliseconds
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 15123 milliseconds
TEST CASE RESULT|Module: tsa|arima_train.sql_in|PASS|Time: 1844 milliseconds
TEST CASE RESULT|Module: tsa|arima.sql_in|PASS|Time: 1564 milliseconds
TEST CASE RESULT|Module: conjugate_gradient|conj_grad.sql_in|PASS|Time: 257
milliseconds
TEST CASE RESULT|Module: lda|lda.sql_in|PASS|Time: 2234 milliseconds
TEST CASE RESULT|Module: stats|wsr_test.sql_in|PASS|Time: 944 milliseconds
TEST CASE RESULT|Module: stats|t_test.sql_in|PASS|Time: 547 milliseconds
TEST CASE RESULT|Module:
stats|robust_and_clustered_variance_coxph.sql_in|PASS|Time: 1335 milliseconds
TEST CASE RESULT|Module: stats|pred_metrics.sql_in|PASS|Time: 2298 milliseconds
TEST CASE RESULT|Module: stats|mw_test.sql_in|PASS|Time: 166 milliseconds
TEST CASE RESULT|Module: stats|ks_test.sql_in|PASS|Time: 465 milliseconds
TEST CASE RESULT|Module: stats|f_test.sql_in|PASS|Time: 176 milliseconds
TEST CASE RESULT|Module: stats|cox_prop_hazards.sql_in|PASS|Time: 2642
milliseconds
TEST CASE RESULT|Module: stats|correlation.sql_in|PASS|Time: 1479 milliseconds
TEST CASE RESULT|Module: stats|chi2_test.sql_in|PASS|Time: 433 milliseconds
TEST CASE RESULT|Module: stats|anova_test.sql_in|PASS|Time: 209 milliseconds
TEST CASE RESULT|Module: svec_util|svec_test.sql_in|PASS|Time: 2651 milliseconds
TEST CASE RESULT|Module: svec_util|gp_sfv_sort_order.sql_in|PASS|Time: 103
milliseconds
TEST CASE RESULT|Module: utilities|text_utilities.sql_in|PASS|Time: 450
milliseconds
madpack.py : ERROR : Failed executing
/tmp/madlib.h1tLYT/utilities/test/sessionize.sql_in.tmp
madpack.py : ERROR : Check the log at
/tmp/madlib.h1tLYT/utilities/test/sessionize.sql_in.log
TEST CASE RESULT|Module: utilities|sessionize.sql_in|FAIL|Time: 125 milliseconds
madpack.py : ERROR : Failed executing
/tmp/madlib.h1tLYT/utilities/test/pivot.sql_in.tmp
madpack.py : ERROR : Check the log at
/tmp/madlib.h1tLYT/utilities/test/pivot.sql_in.log
TEST CASE RESULT|Module: utilities|pivot.sql_in|FAIL|Time: 133 milliseconds
madpack.py : ERROR : Failed executing
/tmp/madlib.h1tLYT/utilities/test/path.sql_in.tmp
madpack.py : ERROR : Check the log at
/tmp/madlib.h1tLYT/utilities/test/path.sql_in.log
TEST CASE RESULT|Module: utilities|path.sql_in|FAIL|Time: 149 milliseconds
TEST CASE RESULT|Module: utilities|drop_madlib_temp.sql_in|PASS|Time: 317
milliseconds
TEST CASE RESULT|Module: assoc_rules|assoc_rules.sql_in|PASS|Time: 428
milliseconds
TEST CASE RESULT|Module: convex|lmf.sql_in|PASS|Time: 2267 milliseconds
TEST CASE RESULT|Module: glm|poisson.sql_in|PASS|Time: 1575 milliseconds
TEST CASE RESULT|Module: glm|ordinal.sql_in|PASS|Time: 1198 milliseconds
TEST CASE RESULT|Module: glm|multinom.sql_in|PASS|Time: 1400 milliseconds
TEST CASE RESULT|Module: glm|inverse_gaussian.sql_in|PASS|Time: 1133
milliseconds
TEST CASE RESULT|Module: glm|gaussian.sql_in|PASS|Time: 1607 milliseconds
TEST CASE RESULT|Module: glm|gamma.sql_in|PASS|Time: 2649 milliseconds
TEST CASE RESULT|Module: glm|binomial.sql_in|PASS|Time: 2323 milliseconds
TEST CASE RESULT|Module: linear_systems|sparse_linear_sytems.sql_in|PASS|Time:
500 milliseconds
TEST CASE RESULT|Module: linear_systems|dense_linear_sytems.sql_in|PASS|Time:
574 milliseconds
TEST CASE RESULT|Module: recursive_partitioning|random_forest.sql_in|PASS|Time:
5326 milliseconds
TEST CASE RESULT|Module: recursive_partitioning|decision_tree.sql_in|PASS|Time:
2161 milliseconds
TEST CASE RESULT|Module: regress|robust.sql_in|PASS|Time: 3524 milliseconds
TEST CASE RESULT|Module: regress|multilogistic.sql_in|PASS|Time: 1699
milliseconds
TEST CASE RESULT|Module: regress|marginal.sql_in|PASS|Time: 4017 milliseconds
TEST CASE RESULT|Module: regress|logistic.sql_in|PASS|Time: 2724 milliseconds
TEST CASE RESULT|Module: regress|linear.sql_in|PASS|Time: 605 milliseconds
TEST CASE RESULT|Module: regress|clustered.sql_in|PASS|Time: 3310 milliseconds
TEST CASE RESULT|Module: sample|sample.sql_in|PASS|Time: 288 milliseconds
TEST CASE RESULT|Module: summary|summary.sql_in|PASS|Time: 1381 milliseconds
TEST CASE RESULT|Module: kmeans|kmeans.sql_in|PASS|Time: 1776 milliseconds
TEST CASE RESULT|Module: pca|pca_project.sql_in|PASS|Time: 3276 milliseconds
TEST CASE RESULT|Module: pca|pca.sql_in|PASS|Time: 9891 milliseconds
TEST CASE RESULT|Module: validation|cross_validation.sql_in|PASS|Time: 1930
milliseconds
INFO: Log files saved in /tmp/madlib.h1tLYT
{code}
I'll go back to Ubuntu 16.04 and have a deeper at look at why *madpack ...
install-check* is failing. If no one has any further comments I'll close this
issue.
> madpack install-check fails on PostgreSQL 9.6.2 & Ubuntu 16.04.2
> ----------------------------------------------------------------
>
> Key: MADLIB-1068
> URL: https://issues.apache.org/jira/browse/MADLIB-1068
> Project: Apache MADlib
> Issue Type: Question
> Components: Madpack
> Reporter: John Grant
> Attachments: elastic_net_install_check.sql_in.log
>
>
> I am installing MADlib from source and concerned about the errors *madpack
> ... install-check* reports. Here are the commands used:
> {code}
> apt install postgresql-server-dev-9.6
> apt install postgresql-plpython-9.6
> apt install cmake g++ libkrb5-dev m4 libboost-dev
> git clone https://github.com/apache/incubator-madlib
> cd incubator-madlib
> ./configure
> cd build/
> make
> make install
> src/bin/madpack -s madlib -c postgres/*@localhost/revit -p postgres install
> ...
> ...
> ...
> madpack.py : INFO : MADlib 1.10.0 installed successfully in MADLIB schema.
> {code}
> Next I run *madpack ... install-check* but it fails. Should I be concerned or
> is this possibly a bug? See attached log file:
> {code}
> root@pg203:/home/john/incubator-madlib/build# src/bin/madpack -s madlib -c
> postgres/*@localhost/revit -p postgres install-check
> madpack.py : INFO : Detected PostgreSQL version 9.6.
> TEST CASE RESULT|Module: array_ops|array_ops.sql_in|PASS|Time: 303
> milliseconds
> TEST CASE RESULT|Module: bayes|gaussian_naive_bayes.sql_in|PASS|Time: 862
> milliseconds
> TEST CASE RESULT|Module: bayes|bayes.sql_in|PASS|Time: 2674 milliseconds
> TEST CASE RESULT|Module: crf|crf_train_small.sql_in|PASS|Time: 1725
> milliseconds
> TEST CASE RESULT|Module: crf|crf_train_large.sql_in|PASS|Time: 2920
> milliseconds
> TEST CASE RESULT|Module: crf|crf_test_small.sql_in|PASS|Time: 1377
> milliseconds
> TEST CASE RESULT|Module: crf|crf_test_large.sql_in|PASS|Time: 1470
> milliseconds
> madpack.py : ERROR : Failed executing
> /tmp/madlib.erAH0G/elastic_net/test/elastic_net_install_check.sql_in.tmp
> madpack.py : ERROR : Check the log at
> /tmp/madlib.erAH0G/elastic_net/test/elastic_net_install_check.sql_in.log
> TEST CASE RESULT|Module:
> elastic_net|elastic_net_install_check.sql_in|FAIL|Time: 522 milliseconds
> madpack.py : ERROR : SQL command failed:
> SQL: DROP SCHEMA IF EXISTS madlib_installcheck_elastic_net CASCADE;
> psql: could not connect to server: Connection refused
> Is the server running on host "localhost" (::1) and accepting
> TCP/IP connections on port 5432?
> FATAL: the database system is in recovery mode
> FATAL: the database system is in recovery mode
> Traceback (most recent call last):
> File "/home/john/incubator-madlib/build/src/bin/../madpack/madpack.py",
> line 1574, in <module>
> main(sys.argv[1:])
> File "/home/john/incubator-madlib/build/src/bin/../madpack/madpack.py",
> line 1505, in main
> _internal_run_query("DROP SCHEMA IF EXISTS %s CASCADE;" % (test_schema),
> True)
> File "/home/john/incubator-madlib/build/src/bin/../madpack/madpack.py",
> line 182, in _internal_run_query
> return run_query(sql, show_error, con_args)
> File "/home/john/incubator-madlib/build/src/bin/../madpack/madpack.py",
> line 147, in run_query
> raise Exception
> Exception
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
