[MADLIB-810] SVM regression out of memory in PG 9.2

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Unresolved
• Assignee: Xixuan (Aaron) Feng
• Reporter: Xixuan (Aaron) Feng
• Created: 09/Mar/14 05:16
• Updated: 27/Jun/14 20:06

Description

-- @description This is for output tests of svm regression
-- @madlib-param output_table = "svm_output"
-- @madlib-param kernel_func = "madlib.svm_dot"
-- @madlib-param verbose = "false"
-- @madlib-param eta = "0.1"
-- @madlib-param label_col = "label"
-- @madlib-param id_col = "id"
-- @madlib-param parallel = "false"
-- @madlib-param data_col = "ind"
-- @madlib-param slambda = "0.05"
-- @madlib-param nu = "0.005"
-- @madlib-param data_random = "data_random"
-- @madlib-param model_table = "svm_model"
        DROP TABLE IF EXISTS svm_model CASCADE;
DROP TABLE
        DROP TABLE IF EXISTS svm_output CASCADE;
psql:/data/pulse2-data/agents/agent1/work/MADlib%20TINC%20Feature%20Test%20on%20PG9.2/rhel5_x86_64/tests/SVM/sql_SVMRegressionOutputTestCase/test_output_svm_regression_1.sql:17: NOTICE:  table "svm_output" does not exist, skipping
DROP TABLE
        DROP TABLE IF EXISTS svm_model_param CASCADE;
DROP TABLE
        SELECT madlib.svm_regression
        ( 'madlibtestdata.data_random'     --data_random
        , 'svm_model'
        , false
        , 'madlib.svm_dot'    --kernel_func
        , false
        , 0.1
        , 0.005
        , 0.05
        );
psql:/data/pulse2-data/agents/agent1/work/MADlib%20TINC%20Feature%20Test%20on%20PG9.2/rhel5_x86_64/tests/SVM/sql_SVMRegressionOutputTestCase/test_output_svm_regression_1.sql:28: ERROR:  spiexceptions.OutOfMemory: out of memory
DETAIL:  Failed on request of size 8192.
CONTEXT:  Traceback (most recent call last):
  PL/Python function "svm_regression", line 30, in <module>
    slambda, kernel_param);
  PL/Python function "svm_regression", line 137, in svm_regression
PL/Python function "svm_regression"
SQL function "svm_regression" statement 1
        
    SELECT madlib.svm_predict_batch
        ('madlibtestdata.data_random'
        , 'ind'
        , 'id'
        , 'svm_model'
        , 'svm_output'
        , 'false'
        );
psql:/data/pulse2-data/agents/agent1/work/MADlib%20TINC%20Feature%20Test%20on%20PG9.2/rhel5_x86_64/tests/SVM/sql_SVMRegressionOutputTestCase/test_output_svm_regression_1.sql:37: ERROR:  plpy.Error: SVM error: Input table 'svm_model' does not exist
CONTEXT:  Traceback (most recent call last):
  PL/Python function "svm_predict_batch", line 28, in <module>
    return online_sv.svm_predict_batch( input_table, data_col, id_col, model_table, output_table, parallel);
  PL/Python function "svm_predict_batch", line 387, in svm_predict_batch
  PL/Python function "svm_predict_batch", line 59, in __svm_predict_validate_parameters
  PL/Python function "svm_predict_batch", line 513, in input_tbl_valid
PL/Python function "svm_predict_batch"
    
    SELECT sum((label = sign(prediction))::integer) / count(*)::float8 AS accuracy FROM
        svm_output s1 JOIN madlibtestdata.data_random s2
        ON s1.id = s2.id;
psql:/data/pulse2-data/agents/agent1/work/MADlib%20TINC%20Feature%20Test%20on%20PG9.2/rhel5_x86_64/tests/SVM/sql_SVMRegressionOutputTestCase/test_output_svm_regression_1.sql:41: ERROR:  relation "svm_output" does not exist
LINE 2:         svm_output s1 JOIN madlibtestdata.data_random s2
                ^