Description of problem:

During loading of VM OVF metadata which contain non-English characters DataIntegrityValidationException may occur.

This causes the hypervisor to release Spm lock as this happens during UpdateVdsRunTimeInfo call.


Version-Release number of selected component (if applicable):
3.4.2

How reproducible:
Only in localized environments

Steps to Reproduce:
1. Have VMs with localized SW
2. Start large batches of them (100 VMs per hypervisor)
3. Wait for UpdateVdsRunTimeInfo call

Actual results:
The call fails causing the SPM lock to flip

Expected results:
It should not fail - runtime info should be properly updated

Additional info:
2014-12-02 14:25:44,742 ERROR [org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo] (DefaultQuartzScheduler_Worker-88) DataIntegrityViolationException: ConnectionCallback; SQL []; Batch entry 0 select * from public.updatevmdynamic(CAST ('Renta 2013 1.30,Modulos 2013 1.00,gvSIG desktop,Renta 2012 1.21,Mathematica Extras 8.0 (2615434),Adobe AIR,Adobe Digital Editions 2.0,Adobe Flash Player 14 ActiveX,Adobe Flash Player 14 Plugin,Configurador AEAT 1.15,Firebird 1.5.2.4731,Firebird ODBC Driver 1.2.0.69,Fuentes_UV,GAMS win32 24.0.1,GanttProject,GeoGebra 4.2,GeoGebra 4.4,Google Chrome,GPL Ghostscript,gretl version 1.9.9cvs,Windows Internet Explorer 8,IHMC CmapTools v5.04,Inkscape 0.48.2,Windows Genuine Advantage Validation Tool (KB892130),K-Lite Codec Pack 3.8.5 Full,Wolfram Mathematica 8 (M-WIN-L 8.0.4 2615665),MATLAB R2013b,MATLAB R2010a,MAXQDA 11 (Release 11.0.8),Microsoft .NET Framework 3.5 SP1,MiKTeX 2.9,Mozilla Firefox 32.0 (x86 es-ES),Mozilla Maintenance Service,Microsoft Compression Client Pack 1.0 for Windows XP,NicoFTP3,Microsoft Project Professional 2010,Microsoft Office Professional Plus 2010,Gapminder Desktop,R for Windows 3.0.1,R for Windows 3.0.2,RStudio,Microsoft Office SharePoint Designer 2007,SMAC 1.7,TeXnicCenter Version 2.01 Stable,Tinn-R 3.0.3.5,TOM Micro  2.0,Microsoft Kernel-Mode Driver Framework Feature Pack 1.9,NSIS WeftQDA,Windows Media Format 11 runtime,Reproductor de Windows Media 11,GIMP 2.6.3,WinRAR 4.20 (32-bit),Windows Media Format 11 runtime,Windows Media Player 11,Microsoft User-Mode Driver Framework Feature Pack 1.0,RHEV-Tools 3.4.9,IBM SPSS Statistics 19,IHCM CMaptools versión 5.05,Java 7 Update 67,Gapminder Desktop,WebFldrs XP,RHEV-Agent 3.4.5,NominaSOL,Adobe AIR,Java Auto Updater,EViews 6,RHEV-Block 3.4.3,Windows Server 2003 Administration Tools Pack,Hipestat versión 4.4,FactuSOL,Microsoft Visual C++ 2005 Redistributable,Cliente de MetaFrame Presentation Server,RHEV-SSO 3.4.1,RHEV-USB 3.4.1,ATLAS.ti,Microsoft Software Update for Web Folders  (Spanish) 12,Microsoft Office SharePoint Designer 2007,Security Update for Microsoft Office 2007 suites (KB2687499) 32-Bit Edition ,Security Update for Microsoft Office 2007 suites (KB2596871) 32-Bit Edition,Microsoft Office SharePoint Designer 2007 Service Pack 3 (SP3),Security Update for Microsoft Office 2007 suites (KB2596672) 32-Bit Edition ,Update for Microsoft Office 2007 suites (KB2596660) 32-Bit Edition,Update for Microsoft Office 2007 suites (KB2596848) 32-Bit Edition,Update for Microsoft Office 2007 suites (KB2596620) 32-Bit Edition,Security Update for Microsoft Office 2007 suites (KB2596785) 32-Bit Edition,Security Update for Microsoft Office 2007 suites (KB2596754) 32-Bit Edition ,Update for 2007 Microsoft Office System (KB967642),Security Update for Microsoft Office 2007 suites (KB2596615) 32-Bit Edition ,Security Update for Microsoft Office 2007 suites (KB2760416) 32-Bit Edition ,Security Update for Microsoft Office 2007 suites (KB2596744) 32-Bit Edition ,Security Update for Microsoft Office 2007 suites (KB2596792) 32-Bit Edition,Update for Microsoft Office 2007 suites (KB2767916) 32-Bit Edition,Security Update for Microsoft Office 2007 suites (KB2687441) 32-Bit Edition ,Microsoft Office SharePoint Designer MUI (Spanish) 2007,Microsoft Office SharePoint Designer 2007 Service Pack 3 (SP3),Microsoft Office Proof (Catalan) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (English) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (French) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Portuguese (Brazil)) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Basque) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Galician) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Spanish) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proofing (Spanish) 2007,Microsoft Office Shared MUI (Spanish) 2007,Microsoft Office 2007 Service Pack 3 (SP3),Microsoft Software Update for Web Folders  (English) 14,Microsoft Software Update for Web Folders  (Spanish) 14,Microsoft Office Professional Plus 2010,Microsoft Office Access MUI (English) 2010,Microsoft Office Access MUI (Spanish) 2010,Microsoft Office Excel MUI (English) 2010,Microsoft Office Excel MUI (Spanish) 2010,Microsoft Office PowerPoint MUI (English) 2010,Microsoft Office PowerPoint MUI (Spanish) 2010,Microsoft Office Publisher MUI (English) 2010,Microsoft Office Publisher MUI (Spanish) 2010,Microsoft Office Outlook MUI (English) 2010,Microsoft Office Outlook MUI (Span
[..]
Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Basque) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Galician) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proof (Spanish) 2007,Microsoft Office Proofing Tools 2007 Service Pack 3 (SP3),Microsoft Office Proofing (Spanish) 2007,Microsoft Office Shared MUI (Spanish) 2007,Microsoft Office 2007 Service Pack 3 (SP3),Microsoft Software Update for Web Folders  (English) 14,Microsoft Software Update for Web Folders  (Spanish) 14,Microsoft Office Professional Plus 2010,Microsoft Office Access MUI (English) 2010,Microsoft Office Access MUI (Spanish) 2010,Microsoft Office Excel MUI (English) 2010,Microsoft Office Excel MUI (Spanish) 2010,Microsoft Office PowerPoint MUI (English) 2010,Microsoft Office PowerPoint MUI (Spanish) 2010,Microsoft Office Publisher MUI (English) 2010,Microsoft Office Publisher MUI (Spanish) 2010,Microsoft Office Outlook MUI (English) 2010,Microsoft Office Outlook MUI (Spanish) 2010,Microsoft Office Word MUI (English) 2010,Microsoft Office Word MUI (Spanish) 2010,Microsoft Office Proof (Catalan) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (English) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (French) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (Portuguese (Brazil)) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (Basque) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (Galician) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proof (Spanish) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Proofing (English) 2010,Microsoft Office Proofing (Spanish) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office Project Professional 2010,Microsoft Project 2010 Service Pack 1 (SP1),Microsoft Office InfoPath MUI (English) 2010,Microsoft Office InfoPath MUI (Spanish) 2010,Microsoft Office Shared MUI (English) 2010,Microsoft Office Shared MUI (Spanish) 2010,Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office 2010 Service Pack 1 (SP1),Microsoft Office OneNote MUI (English) 2010,Microsoft Office OneNote MUI (Spanish) 2010,Microsoft Office Project MUI (Spanish) 2010,Microsoft Project 2010 Service Pack 1 (SP1),Microsoft Office Groove MUI (English) 2010,Microsoft Office Groove MUI (Spanish) 2010,Microsoft Office Shared Setup Metadata MUI (English) 2010,Microsoft Office Access Setup Metadata MUI (English) 2010,Microsoft Office File Validation Add-In,IZArc 3.81,Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.17,Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.6161,Crystal Decisions,Microsoft .NET Framework 3.0 Service Pack 2,Google Update Helper,Adobe Reader XI (11.0.08) - Español,RHEV-Serial 3.4.3,RHEV-Spice-Agent 3.4.2,TurningPoint 2008,Ebrary Reader,Innovative Millenium,Microsoft .NET Framework 2.0 Service Pack 2,RHEV-Spice 3.4.1,RHEV-Network 3.4.3,ContaSOL,Microsoft .NET Framework 3.5 SP1' AS varchar),CAST ('taronla.es' AS varchar),CAST (NULL AS varchar),CAST (NULL AS timestamptz),CAST (NULL AS timestamptz),CAST ('6cc1abda-5bc0-4a28-8a75-e6e2d2de34aa' AS uuid),CAST ('Win XP' AS varchar),CAST (NULL AS uuid),CAST ('beb7eeda-2fb0-4ed6-824b-d7ee4bc0e652' AS uuid),CAST ('1' AS int4),CAST ('5053630f-87c1-46b8-8204-2f79e75be971' AS uuid),CAST ('34TASUR511-27' AS varchar),CAST ('10.10.13.30' AS varchar),CAST ('34TASUR511-27.VdiAules.uv.es' AS varchar),CAST ('2014-11-14 14:33:09.853000 +01:00:00' AS timestamptz),CAST ('2014-11-14 13:25:57.696000 +01:00:00' AS timestamptz),CAST (NULL AS int4),CAST ('6058' AS int4),CAST ('1' AS bool),CAST ('0' AS int4),CAST ('147.156.2.64' AS varchar),CAST ('1' AS int4),CAST ('1' AS bool),CAST ('0' AS int4),CAST ('6059' AS int4),CAST ('3601' AS int4),CAST (NULL AS uuid),CAST ('' AS varchar),CAST (NULL AS int4),CAST ('' AS varchar),CAST ('0' AS int4),CAST ('5' AS int4),CAST (NULL AS varchar),CAST ('-7990149104877099834' AS varchar),CAST ('-550441389' AS int4),CAST (NULL AS numeric),CAST (NULL AS varchar),CAST ('0' AS bool),CAST ('Intel Westmere Family' AS varchar),CAST (NULL AS varchar),CAST ('1' AS int4)) as result was aborted.  Call getNextException to see the cause.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) [spring-jdbc.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE] 
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:349) [spring-jdbc.jar:3.1.1.RELEASE]
        at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeStoredProcAsBatch(SimpleJdbcCallsHandler.java:52) [dal.jar:]
        at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeStoredProcAsBatch(SimpleJdbcCallsHandler.java:70) [dal.jar:]
        at org.ovirt.engine.core.dao.MassOperationsGenericDaoDbFacade.updateAllInBatch(MassOperationsGenericDaoDbFacade.java:60) [dal.jar:] 
        at org.ovirt.engine.core.dao.MassOperationsGenericDaoDbFacade.updateAllInBatch(MassOperationsGenericDaoDbFacade.java:95) [dal.jar:]
        at org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo.saveDataToDb(VdsUpdateRunTimeInfo.java:158) [vdsbroker.jar:]
        at org.ovirt.engine.core.vdsbroker.VdsUpdateRunTimeInfo.refresh(VdsUpdateRunTimeInfo.java:357) [vdsbroker.jar:]
        at org.ovirt.engine.core.vdsbroker.VdsManager.onTimer(VdsManager.java:231) [vdsbroker.jar:]
        at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source) [:1.7.0_65]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_65] 
        at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_65] 
        at org.ovirt.engine.core.utils.timer.JobWrapper.execute(JobWrapper.java:60) [scheduler.jar:]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz.jar:]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) [quartz.jar:]