[jira] [Created] (MADLIB-1041) Upgrade from 1.7.1->1.9 and 1.7.1->1.9.1 fails

["Frank McQuillan (JIRA)" <ji...@apache.org>]

Frank McQuillan created MADLIB-1041:
---------------------------------------

             Summary: Upgrade from 1.7.1->1.9 and 1.7.1->1.9.1 fails
                 Key: MADLIB-1041
                 URL: https://issues.apache.org/jira/browse/MADLIB-1041
             Project: Apache MADlib
          Issue Type: Bug
          Components: Madpack
            Reporter: Frank McQuillan
             Fix For: v1.10


madpack upgrade from 1.7.1->1.9 failed with the following message:

{code}
madpack.py : INFO : Testing PL/Python environment...
madpack.py : INFO : > PL/Python environment OK (version: 2.6.2)
madpack.py : INFO : Upgrading MADlib into MADLIB schema...
madpack.py : INFO :     Detecting dependencies...
madpack.py : INFO :     Loading change list...
madpack.py : INFO :     Detecting table dependencies...
madpack.py : INFO :     Detecting view dependencies...
madpack.py : INFO : No dependency problem found, continuing to upgrade ...
madpack.py : ERROR : SQL command failed:
SQL: DROP TYPE IF EXISTS madlib.svm_model_rec
ERROR:  cannot drop type madlib.svm_model_rec because other objects depend on it
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 
Exception:
(<type 'exceptions.Exception'>, Exception(), <traceback object at 0xe4c2d8>)
madpack.py : ERROR : MADlib upgrade failed.
{code}

I believe this error would happen on 1.7.1->1.9.1 and perhaps other cases as well.

Please investigate and fix this bug, and also determine what madpack changes are required in the future to avoid this problem.



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