Created attachment 680374 [details]
## Logs vdsm, rhevm

Description of problem:
Failed update DB in deleting Storage Domain on reusing LUN scenario

Version-Release number of selected component (if applicable):
RHEVM 3.1 - SI25.4 environment:

RHEVM: rhevm-3.1.0-40.el6ev.noarch
VDSM: vdsm-4.9.6-44.3.el6_3.x86_64
LIBVIRT: libvirt-0.9.10-21.el6_3.7.x86_64
QEMU & KVM: qemu-kvm-rhev-0.12.1.2-2.295.el6_3.10.x86_64
SANLOCK: sanlock-2.3-4.el6_3.x86_64

How reproducible:
100%

No error found in RHEVM 3.2 - SF03 environment

Steps to Reproduce:
1. Create a new FC DC environment
2. Create Storage Domain with new LUN (without Acivate actions.
3. Create Direct LUN with same LUN (from previous step)
4. Remove Storage Domain


  
Actual results:
Failed delete Storage Domain on reusing LUN scenario

Expected results:
Success delete Storage Domain on reusing LUN scenario
No exception should be found

Additional info:

/var/log/ovirt-engine/engine.log

2013-01-17 17:55:21,622 ERROR [org.ovirt.engine.core.bll.storage.RemoveStorageDomainCommand] (ajp-/127.0.0.1:8702-2) [4598cab5] Command org.ovirt.engine.core.bll.storage.RemoveStorageDomainCommand
 throw exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call deletelun(?)}]; ERROR: update or delete on table "luns" violates foreign key constr
aint "disk_lun_to_lun_fk" on table "disk_lun_map"
  Detail: Key (lun_id)=(3514f0c519e400290) is still referenced from table "disk_lun_map".
  Where: SQL statement "DELETE FROM LUNs WHERE LUN_id =  $1 "
PL/pgSQL function "deletelun" line 9 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: update or delete on table "luns" violates foreign key constraint "disk_lun_to_l
un_fk" on table "disk_lun_map"
  Detail: Key (lun_id)=(3514f0c519e400290) is still referenced from table "disk_lun_map".
  Where: SQL statement "DELETE FROM LUNs WHERE LUN_id =  $1 "
PL/pgSQL function "deletelun" line 9 at SQL statement
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:124) [engine-dal.jar:]
        at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:37) [engine-dal.jar:]
        at org.ovirt.engine.core.dao.LunDAODbFacadeImpl.remove(LunDAODbFacadeImpl.java:95) [engine-dal.jar:]
        at org.ovirt.engine.core.bll.storage.FCPStorageHelper.StorageDomainRemoved(FCPStorageHelper.java:42) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.storage.RemoveStorageDomainCommand$1.runInTransaction(RemoveStorageDomainCommand.java:65) [engine-bll.jar:]
        at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:204) [engine-utils.jar:]
        at org.ovirt.engine.core.bll.storage.StorageDomainCommandBase.executeInNewTransaction(StorageDomainCommandBase.java:370) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.storage.RemoveStorageDomainCommand.executeCommand(RemoveStorageDomainCommand.java:62) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:876) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:973) [engine-bll.jar:]

/var/log/vdsm/vdsm.log