[
https://issues.apache.org/jira/browse/MADLIB-1041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frank McQuillan updated MADLIB-1041:
------------------------------------
Description:
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.
Also, can you please attach the workaround to this JIRA and I will put it on
the wiki.
was:
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.
> Upgrade from 1.7.1->1.9 fails
> -----------------------------
>
> Key: MADLIB-1041
> URL: https://issues.apache.org/jira/browse/MADLIB-1041
> Project: Apache MADlib
> Issue Type: Bug
> Components: Madpack
> Reporter: Frank McQuillan
> Assignee: Orhan Kislal
> 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.
> Also, can you please attach the workaround to this JIRA and I will put it on
> the wiki.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
