[jira] [Created] (MADLIB-1014) SVM: Install-check fails in PG 9.5 due to CV

["Rahul Iyer (JIRA)" <ji...@apache.org>]

Rahul Iyer created MADLIB-1014:
----------------------------------

             Summary: SVM: Install-check fails in PG 9.5 due to CV
                 Key: MADLIB-1014
                 URL: https://issues.apache.org/jira/browse/MADLIB-1014
             Project: Apache MADlib
          Issue Type: Bug
          Components: Module: Support Vector Machines
            Reporter: Rahul Iyer


Cross validation in SVM leads to failures in PG 9.5

{code}
madpack.py : INFO : Detected PostgreSQL version 9.5.
madpack.py : ERROR : Failed executing /tmp/madlib.MHNKQS/svm/test/svm.sql_in.tmp
madpack.py : ERROR : Check the log at /tmp/madlib.MHNKQS/svm/test/svm.sql_in.log
TEST CASE RESULT|Module: svm|svm.sql_in|FAIL|Time: 4251 milliseconds
madpack.py : ERROR : SQL command failed:
SQL: DROP SCHEMA IF EXISTS madlib_installcheck_svm CASCADE;
psql: FATAL:  the database system is in recovery mode

Traceback (most recent call last):
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 1365, in <module>
    main(sys.argv[1:])
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 1352, in main
    _internal_run_query("DROP SCHEMA IF EXISTS %s CASCADE;" % (test_schema), True)
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 176, in _internal_run_query
    return run_query(sql, show_error, con_args)
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 141, in run_query
    raise Exception
Exception
{code}
The install-check fails in PG 9.4 as well but the database does not go into recovery mode. Rather the error occurs when the install-check schema is getting cleaned. 
{code}
madpack.py : INFO : Detected PostgreSQL version 9.4.
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 5591 milliseconds
madpack.py : ERROR : SQL command failed:
SQL: DROP OWNED BY madlib_191dev_installcheck CASCADE;
ERROR:  could not open relation with OID 860224

Traceback (most recent call last):
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 1365, in <module>
    main(sys.argv[1:])
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 1355, in main
    _internal_run_query("DROP OWNED BY %s CASCADE;" % (test_user), True)
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 176, in _internal_run_query
    return run_query(sql, show_error, con_args)
  File "/Users/riyer/Work/MADlib/madlib_builds/build_pg_2/src/bin/../madpack/madpack.py", line 141, in run_query
    raise Exception
Exception
{code}

Commenting out the cross validation function calls leads to successful install-check
{code}
madpack.py : INFO : Detected PostgreSQL version 9.4.
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 2887 milliseconds
{code}
{code}
madpack.py : INFO : Detected PostgreSQL version 9.5.
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 3056 milliseconds
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)