Deleting a host can throw an error

[wezell]

Trying to delete this host:

http://screencast.com/t/JwdSZxZUA

 size:1000, toDisk:false,Concurrency:32
[29/01/14 12:57:12:977 EST] ERROR business.HostAPIImpl: ERROR: update or delete on table "identifier" violates foreign key constraint "fk_link_ver_info_ident" on table "link_version_info"
  Detail: Key (id)=(dea2ec46-00fd-4eca-b090-7e371cffa615) is still referenced from table "link_version_info".
com.dotmarketing.exception.DotDataException: ERROR: update or delete on table "identifier" violates foreign key constraint "fk_link_ver_info_ident" on table "link_version_info"
  Detail: Key (id)=(dea2ec46-00fd-4eca-b090-7e371cffa615) is still referenced from table "link_version_info".
    at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:234)
    at com.dotmarketing.portlets.contentlet.business.HostAPIImpl$1DeleteHostThread.deleteHost(HostAPIImpl.java:518)
    at com.dotmarketing.portlets.contentlet.business.HostAPIImpl$1DeleteHostThread.run(HostAPIImpl.java:497)
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "identifier" violates foreign key constraint "fk_link_ver_info_ident" on table "link_version_info"
  Detail: Key (id)=(dea2ec46-00fd-4eca-b090-7e371cffa615) is still referenced from table "link_version_info".
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
    at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:564)
    at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:486)
    at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:232)
    ... 2 more

[dsilvam]

there are two cases here:

1. link asset with identifier.asset_type = 'file_asset' (the opposite of the other case we had before)
2. a container that is referenced from a template that lives in a different host (template_container complains)

the commits here fixes 1). You need to manually remove number 2. We will improve messaging for this, see #4805

[bryanboza]

Tested on master // H2 and works fine... Just to make, need test in other DB

[bryanboza]

Fixed, tested on master // MySQL