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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v1.10
• Component/s: Module: Support Vector Machines
• Assignee: Nandish Jayaram
• Reporter: Rahul Iyer
• Created: 15/Aug/16 19:17
• Updated: 06/Aug/18 22:36
• Resolved: 02/Feb/17 13:28

Description

Cross validation in SVM leads to failures in PG 9.5

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

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.

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

Commenting out the cross validation function calls leads to successful install-check

madpack.py : INFO : Detected PostgreSQL version 9.4.
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 2887 milliseconds

madpack.py : INFO : Detected PostgreSQL version 9.5.
TEST CASE RESULT|Module: svm|svm.sql_in|PASS|Time: 3056 milliseconds

Issue Links

• links to: GitHub Pull Request #307