[
https://issues.apache.org/jira/browse/MADLIB-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15863831#comment-15863831
]
Satoshi Nagayasu commented on MADLIB-1068:
------------------------------------------
Do you always get failed with the same test cases?
Or you fail a few test cases randomly each time?
IMHO, if you get random failure, it could be caused not by madlib.
If you get the same error on the same test cases repeatedly,
it could be caused by madlib or postgresql, and you can find something
from the log files.
In my box, I just found my PostgreSQL 9.6 and MADlib 1.10.0-dev can pass
install-check on CentOS 6.7.
{noformat}
madpack.py : INFO : Detected PostgreSQL version 9.6.
TEST CASE RESULT|Module: array_ops|array_ops.sql_in|PASS|Time: 62 milliseconds
TEST CASE RESULT|Module: bayes|gaussian_naive_bayes.sql_in|PASS|Time: 172
milliseconds
TEST CASE RESULT|Module: bayes|bayes.sql_in|PASS|Time: 338 milliseconds
TEST CASE RESULT|Module: crf|crf_train_small.sql_in|PASS|Time: 319 milliseconds
TEST CASE RESULT|Module: crf|crf_train_large.sql_in|PASS|Time: 876 milliseconds
TEST CASE RESULT|Module: crf|crf_test_small.sql_in|PASS|Time: 247 milliseconds
TEST CASE RESULT|Module: crf|crf_test_large.sql_in|PASS|Time: 286 milliseconds
TEST CASE RESULT|Module:
elastic_net|elastic_net_install_check.sql_in|PASS|Time: 22750 milliseconds
TEST CASE RESULT|Module: graph|sssp.sql_in|PASS|Time: 154 milliseconds
TEST CASE RESULT|Module: linalg|svd.sql_in|PASS|Time: 532 milliseconds
TEST CASE RESULT|Module: linalg|matrix_ops.sql_in|PASS|Time: 517 milliseconds
TEST CASE RESULT|Module: linalg|linalg.sql_in|PASS|Time: 85 milliseconds
TEST CASE RESULT|Module: pmml|table_to_pmml.sql_in|PASS|Time: 2558 milliseconds
TEST CASE RESULT|Module: pmml|pmml_rf.sql_in|PASS|Time: 2138 milliseconds
TEST CASE RESULT|Module: pmml|pmml_ordinal.sql_in|PASS|Time: 1458 milliseconds
TEST CASE RESULT|Module: pmml|pmml_multinom.sql_in|PASS|Time: 1409 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_poisson.sql_in|PASS|Time: 1303
milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_normal.sql_in|PASS|Time: 1332
milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_ig.sql_in|PASS|Time: 1317 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_gamma.sql_in|PASS|Time: 1985 milliseconds
TEST CASE RESULT|Module: pmml|pmml_glm_binomial.sql_in|PASS|Time: 1438
milliseconds
TEST CASE RESULT|Module: pmml|pmml_dt.sql_in|PASS|Time: 1484 milliseconds
TEST CASE RESULT|Module: prob|prob.sql_in|PASS|Time: 218 milliseconds
TEST CASE RESULT|Module: sketch|support.sql_in|PASS|Time: 55 milliseconds
TEST CASE RESULT|Module: sketch|mfv.sql_in|PASS|Time: 736 milliseconds
TEST CASE RESULT|Module: sketch|fm.sql_in|PASS|Time: 2797 milliseconds
TEST CASE RESULT|Module: sketch|cm.sql_in|PASS|Time: 6597 milliseconds
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 3323 milliseconds
TEST CASE RESULT|Module: tsa|arima_train.sql_in|PASS|Time: 385 milliseconds
TEST CASE RESULT|Module: tsa|arima.sql_in|PASS|Time: 393 milliseconds
TEST CASE RESULT|Module: conjugate_gradient|conj_grad.sql_in|PASS|Time: 75
milliseconds
TEST CASE RESULT|Module: knn|knn.sql_in|PASS|Time: 168 milliseconds
TEST CASE RESULT|Module: lda|lda.sql_in|PASS|Time: 286 milliseconds
TEST CASE RESULT|Module: stats|wsr_test.sql_in|PASS|Time: 64 milliseconds
TEST CASE RESULT|Module: stats|t_test.sql_in|PASS|Time: 65 milliseconds
TEST CASE RESULT|Module:
stats|robust_and_clustered_variance_coxph.sql_in|PASS|Time: 270 milliseconds
TEST CASE RESULT|Module: stats|pred_metrics.sql_in|PASS|Time: 209 milliseconds
TEST CASE RESULT|Module: stats|mw_test.sql_in|PASS|Time: 56 milliseconds
TEST CASE RESULT|Module: stats|ks_test.sql_in|PASS|Time: 63 milliseconds
TEST CASE RESULT|Module: stats|f_test.sql_in|PASS|Time: 56 milliseconds
TEST CASE RESULT|Module: stats|cox_prop_hazards.sql_in|PASS|Time: 380
milliseconds
TEST CASE RESULT|Module: stats|correlation.sql_in|PASS|Time: 216 milliseconds
TEST CASE RESULT|Module: stats|chi2_test.sql_in|PASS|Time: 67 milliseconds
TEST CASE RESULT|Module: stats|anova_test.sql_in|PASS|Time: 58 milliseconds
TEST CASE RESULT|Module: svec_util|svec_test.sql_in|PASS|Time: 1617 milliseconds
TEST CASE RESULT|Module: svec_util|gp_sfv_sort_order.sql_in|PASS|Time: 59
milliseconds
TEST CASE RESULT|Module: utilities|text_utilities.sql_in|PASS|Time: 117
milliseconds
TEST CASE RESULT|Module: utilities|sessionize.sql_in|PASS|Time: 135 milliseconds
TEST CASE RESULT|Module: utilities|pivot.sql_in|PASS|Time: 279 milliseconds
TEST CASE RESULT|Module: utilities|path.sql_in|PASS|Time: 164 milliseconds
TEST CASE RESULT|Module: utilities|encode_categorical.sql_in|PASS|Time: 193
milliseconds
TEST CASE RESULT|Module: utilities|drop_madlib_temp.sql_in|PASS|Time: 110
milliseconds
TEST CASE RESULT|Module: assoc_rules|assoc_rules.sql_in|PASS|Time: 225
milliseconds
TEST CASE RESULT|Module: convex|lmf.sql_in|PASS|Time: 1773 milliseconds
TEST CASE RESULT|Module: glm|poisson.sql_in|PASS|Time: 299 milliseconds
TEST CASE RESULT|Module: glm|ordinal.sql_in|PASS|Time: 276 milliseconds
TEST CASE RESULT|Module: glm|multinom.sql_in|PASS|Time: 299 milliseconds
TEST CASE RESULT|Module: glm|inverse_gaussian.sql_in|PASS|Time: 380 milliseconds
TEST CASE RESULT|Module: glm|gaussian.sql_in|PASS|Time: 347 milliseconds
TEST CASE RESULT|Module: glm|gamma.sql_in|PASS|Time: 727 milliseconds
TEST CASE RESULT|Module: glm|binomial.sql_in|PASS|Time: 445 milliseconds
TEST CASE RESULT|Module: linear_systems|sparse_linear_sytems.sql_in|PASS|Time:
159 milliseconds
TEST CASE RESULT|Module: linear_systems|dense_linear_sytems.sql_in|PASS|Time:
149 milliseconds
TEST CASE RESULT|Module: recursive_partitioning|random_forest.sql_in|PASS|Time:
2607 milliseconds
TEST CASE RESULT|Module: recursive_partitioning|decision_tree.sql_in|PASS|Time:
932 milliseconds
TEST CASE RESULT|Module: regress|robust.sql_in|PASS|Time: 609 milliseconds
TEST CASE RESULT|Module: regress|multilogistic.sql_in|PASS|Time: 299
milliseconds
TEST CASE RESULT|Module: regress|marginal.sql_in|PASS|Time: 708 milliseconds
TEST CASE RESULT|Module: regress|logistic.sql_in|PASS|Time: 644 milliseconds
TEST CASE RESULT|Module: regress|linear.sql_in|PASS|Time: 166 milliseconds
TEST CASE RESULT|Module: regress|clustered.sql_in|PASS|Time: 497 milliseconds
TEST CASE RESULT|Module: sample|sample.sql_in|PASS|Time: 382 milliseconds
TEST CASE RESULT|Module: summary|summary.sql_in|PASS|Time: 229 milliseconds
TEST CASE RESULT|Module: kmeans|kmeans.sql_in|PASS|Time: 2323 milliseconds
TEST CASE RESULT|Module: pca|pca_project.sql_in|PASS|Time: 1428 milliseconds
TEST CASE RESULT|Module: pca|pca.sql_in|PASS|Time: 3003 milliseconds
TEST CASE RESULT|Module: validation|cross_validation.sql_in|PASS|Time: 3443
milliseconds
{noformat}
> 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)
