On Sat, Nov 13, 2021 at 9:47 PM Thomas Simmons <[email protected]> wrote:

> Hello,
> I exported all of the VMs on my 4.3.10 cluster to OVAs and while a few
> have imported into my new 4.4.9 cluster just fine, most are failing to
> import with the error below being logged in my engine.log.
>
> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
> table "vm_static" violates foreign key constraint
> "fk_vm_static_lease_sd_id_storage_domain_static_id"
>
> I haven't been able to find much about this error. Google only has a few
> hits, but it looks like there was a similar issue in 4.2.x that was
> resolved in one of the 4.3 RCs.
>
> https://bugzilla.redhat.com/show_bug.cgi?id=1641703
>
> Any advise to get these VMs imported is appreciated.
>
> More log output:
> PL/pgSQL function insertvmstatic(character
> varying,text,integer,integer,integer,integer,uuid,uuid,character
> varying,uuid,timestamp with time
> zone,integer,boolean,boolean,integer,integer,integer,integer,character
> varying,boolean,boolean,boolean,boolean,character
> varying,text,integer,integer,integer,integer,integer,integer,character
> varying,integer,character varying,character varying,character
> varying,integer,character varying,character varying,integer,uuid,character
> varying,boolean,boolean,character
> varying,boolean,uuid,uuid,uuid,uuid,character
> varying,integer,integer,smallint,character
> varying,boolean,boolean,boolean,uuid,boolean,boolean,boolean,character
> varying,integer,character varying,uuid,uuid,character varying,character
> varying,character varying,uuid,uuid,boolean,boolean,boolean,character
> varying,boolean) line 8 at SQL statement
>         at [email protected].
> RELEASE//org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
>         at [email protected].
> RELEASE//org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1402)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1065)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1104)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:414)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:374)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:198)
>         at
> org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:135)
>         at
> org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:130)
>         at
> org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:76)
>         at
> org.ovirt.engine.core.dal//org.ovirt.engine.core.dao.DefaultGenericDao.save(DefaultGenericDao.java:93)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmCommandBase.addVmStatic(ImportVmCommandBase.java:628)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmFromExternalProviderCommand.addVmStatic(ImportVmFromExternalProviderCommand.java:309)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmCommandBase.lambda$addVmToDb$8(ImportVmCommandBase.java:560)
>         at
> org.ovirt.engine.core.utils//org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:181)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmCommandBase.addVmToDb(ImportVmCommandBase.java:559)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmFromExternalProviderCommand.addVmToDb(ImportVmFromExternalProviderCommand.java:391)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.exportimport.ImportVmCommandBase.executeVmCommand(ImportVmCommandBase.java:511)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.VmCommand.executeCommand(VmCommand.java:178)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1174)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1332)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:2010)
>         at
> org.ovirt.engine.core.utils//org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:140)
>         at
> org.ovirt.engine.core.utils//org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:79)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1392)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:424)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.executeValidatedCommand(PrevalidatingMultipleActionsRunner.java:204)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.runCommands(PrevalidatingMultipleActionsRunner.java:176)
>         at
> deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.PrevalidatingMultipleActionsRunner.lambda$invokeCommands$3(PrevalidatingMultipleActionsRunner.java:182)
>         at
> org.ovirt.engine.core.utils//org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:96)
>         at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
>         at
> java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
>         at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>         at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>         at java.base/java.lang.Thread.run(Thread.java:829)
>         at
> org.glassfish.javax.enterprise.concurrent//org.glassfish.enterprise.concurrent.ManagedThreadFactoryImpl$ManagedThread.run(ManagedThreadFactoryImpl.java:227)
> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
> table "vm_static" violates foreign key constraint
> "fk_vm_static_lease_sd_id_storage_domain_static_id"
>   Detail: Key (lease_sd_id)=(2b7747b4-c55f-40ea-b619-37dfe273505b) is not
> present in table "storage_domain_static".
>   Where: SQL statement "INSERT INTO vm_static(description,
>                       free_text_comment,
>                       mem_size_mb,
>                       max_memory_size_mb,
>                       num_of_io_threads,
>                       os,
>                       cluster_id,
>                       vm_guid,
>                       vm_name,
>                       vmt_guid,
>                       creation_date,
>                       num_of_monitors,
>                       allow_console_reconnect,
>                       is_initialized,
>                       num_of_sockets,
>                       cpu_per_socket,
>                       threads_per_cpu,
>                       usb_policy,
>                       time_zone,
>                       auto_startup,
>                       is_stateless,
>                       default_boot_sequence,
>                       vm_type,
>                       nice_level,
>                       cpu_shares,
>                       default_display_type,
>                       priority,
>                       iso_path,
>                       origin,
>                       initrd_url,
>                       kernel_url,
>                       kernel_params,
>                       migration_support,
>                       predefined_properties,
>                       userdefined_properties,
>                       min_allocated_mem,
>                       entity_type,
>                       quota_id,
>                       cpu_pinning,
>                       is_smartcard_enabled,
>                       is_delete_protected,
>                       sso_method,
>                       host_cpu_flags,
>                       tunnel_migration,
>                       vnc_keyboard_layout,
>                       is_run_and_pause,
>                       created_by_user_id,
>                       instance_type_id,
>                       image_type_id,
>                       original_template_id,
>                       original_template_name,
>                       migration_downtime,
>                       template_version_number,
>                       serial_number_policy,
>                       custom_serial_number,
>                       is_boot_menu_enabled,
>                       is_spice_file_transfer_enabled,
>                       is_spice_copy_paste_enabled,
>                       cpu_profile_id,
>                       is_auto_converge,
>                       is_migrate_compressed,
>                       is_migrate_encrypted,
>                       custom_emulated_machine,
>                       bios_type,
>                       custom_cpu_name,
>                       small_icon_id,
>                       large_icon_id,
>                       console_disconnect_action,
>                       resume_behavior,
>                       custom_compatibility_version,
>                       migration_policy_id,
>                       lease_sd_id,
>                       multi_queues_enabled,
>                       virtio_scsi_multi_queues_enabled,
>                       use_tsc_frequency,
>                       namespace,
>                       balloon_enabled)
>     VALUES(v_description,
>            v_free_text_comment,
>            v_mem_size_mb,
>            v_max_memory_size_mb,
>            v_num_of_io_threads,
>            v_os,
>            v_cluster_id,
>            v_vm_guid,
>            v_vm_name,
>            v_vmt_guid,
>            v_creation_date,
>            v_num_of_monitors,
>            v_allow_console_reconnect,
>            v_is_initialized,
>            v_num_of_sockets,
>            v_cpu_per_socket,
>            v_threads_per_cpu,
>            v_usb_policy,
>            v_time_zone,
>            v_auto_startup,
>            v_is_stateless,
>            v_default_boot_sequence,
>            v_vm_type,
>            v_nice_level,
>            v_cpu_shares,
>            v_default_display_type,
>            v_priority,
>            v_iso_path,
>            v_origin,
>            v_initrd_url,
>            v_kernel_url,
>            v_kernel_params,
>            v_migration_support,
>            v_predefined_properties,
>            v_userdefined_properties,
>            v_min_allocated_mem,
>            'VM',
>            v_quota_id,
>            v_cpu_pinning,
>            v_is_smartcard_enabled,
>            v_is_delete_protected,
>            v_sso_method,
>            v_host_cpu_flags,
>            v_tunnel_migration,
>            v_vnc_keyboard_layout,
>            v_is_run_and_pause,
>            v_created_by_user_id,
>            v_instance_type_id,
>            v_image_type_id,
>            v_original_template_id,
>            v_original_template_name,
>            v_migration_downtime,
>            v_template_version_number,
>            v_serial_number_policy,
>            v_custom_serial_number,
>            v_is_boot_menu_enabled,
>            v_is_spice_file_transfer_enabled,
>            v_is_spice_copy_paste_enabled,
>            v_cpu_profile_id,
>            v_is_auto_converge,
>            v_is_migrate_compressed,
>            v_is_migrate_encrypted,
>            v_custom_emulated_machine,
>            v_bios_type,
>            v_custom_cpu_name,
>            v_small_icon_id,
>            v_large_icon_id,
>            v_console_disconnect_action,
>            v_resume_behavior,
>            v_custom_compatibility_version,
>            v_migration_policy_id,
>            v_lease_sd_id,
>            v_multi_queues_enabled,
>            v_virtio_scsi_multi_queues_enabled,
>            v_use_tsc_frequency,
>            v_namespace,
>            v_balloon_enabled)"
> PL/pgSQL function insertvmstatic(character
> varying,text,integer,integer,integer,integer,uuid,uuid,character
> varying,uuid,timestamp with time
> zone,integer,boolean,boolean,integer,integer,integer,integer,character
> varying,boolean,boolean,boolean,boolean,character
> varying,text,integer,integer,integer,integer,integer,integer,character
> varying,integer,character varying,character varying,character
> varying,integer,character varying,character varying,integer,uuid,character
> varying,boolean,boolean,character
> varying,boolean,uuid,uuid,uuid,uuid,character
> varying,integer,integer,smallint,character
> varying,boolean,boolean,boolean,uuid,boolean,boolean,boolean,character
> varying,integer,character varying,uuid,uuid,character varying,character
> varying,character varying,uuid,uuid,boolean,boolean,boolean,character
> varying,boolean) line 8 at SQL statement
>         at [email protected]
> //org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
>         at [email protected]
> //org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
>         at [email protected]
> //org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
>         at [email protected]
> //org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
>         at [email protected]
> //org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
>         at [email protected]
> //org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
>         at [email protected]
> //org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
>         at [email protected]
> //org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:139)
>         at [email protected]
> //org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:303)
>         at [email protected]
> //org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.JdbcTemplate.lambda$call$4(JdbcTemplate.java:1105)
>         at [email protected].
> RELEASE//org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1050)
>         ... 33 more
>
> 2021-11-13 14:20:28,037-05 ERROR
> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
> (EE-ManagedThreadFactory-engine-Thread-138751)
> [31ca7e84-c55d-4ba8-8653-399cea8c0be1] EVENT_ID:
> IMPORTEXPORT_IMPORT_VM_FAILED(1,153), Failed to import Vm lightning to Data
> Center DC, Cluster oVirt1
> 2021-11-13 14:20:28,050-05 INFO
> [org.ovirt.engine.core.bll.exportimport.ImportVmFromOvaCommand]
> (EE-ManagedThreadFactory-engine-Thread-138751)
> [31ca7e84-c55d-4ba8-8653-399cea8c0be1] Lock freed to object
> 'EngineLock:{exclusiveLocks='[lightning=VM_NAME,
> f94ee127-330c-4a76-893b-009d4d9166b2=VM]', sharedLocks=''}'
> 2021-11-13 14:20:28,670-05 INFO
> [org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-68)
> [31ca7e84-c55d-4ba8-8653-399cea8c0be1] Command 'ImportVmFromOva' id:
> '5c567c44-e3fb-4080-b2ac-0812c3668dc0' execution didn't complete, not
> proceeding to perform the next operation
> 2021-11-13 14:20:28,670-05 INFO
> [org.ovirt.engine.core.bll.SerialChildCommandsExecutionCallback]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-68)
> [31ca7e84-c55d-4ba8-8653-399cea8c0be1] Command 'ImportVmFromOva' id:
> '5c567c44-e3fb-4080-b2ac-0812c3668dc0' child commands '[]' executions were
> completed, status 'FAILED'
> 2021-11-13 14:20:29,695-05 ERROR
> [org.ovirt.engine.core.bll.exportimport.ImportVmFromOvaCommand]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [31ca7e84-c55d-4ba8-8653-399cea8c0be1] Ending command
> 'org.ovirt.engine.core.bll.exportimport.ImportVmFromOvaCommand' with
> failure.
> 2021-11-13 14:20:29,731-05 INFO
> [org.ovirt.engine.core.bll.storage.disk.image.RemoveAllVmImagesCommand]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [2728db3e] Running command: RemoveAllVmImagesCommand internal: true.
> Entities affected :  ID: f94ee127-330c-4a76-893b-009d4d9166b2 Type: VM
> 2021-11-13 14:20:29,733-05 WARN
> [org.ovirt.engine.core.bll.lock.InMemoryLockManager]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [2728db3e] Trying to release exclusive lock which does not exist, lock key:
> 'lightningVM_NAME'
> 2021-11-13 14:20:29,733-05 WARN
> [org.ovirt.engine.core.bll.lock.InMemoryLockManager]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [2728db3e] Trying to release exclusive lock which does not exist, lock key:
> 'f94ee127-330c-4a76-893b-009d4d9166b2VM'
> 2021-11-13 14:20:29,733-05 INFO
> [org.ovirt.engine.core.bll.exportimport.ImportVmFromOvaCommand]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [2728db3e] Lock freed to object
> 'EngineLock:{exclusiveLocks='[lightning=VM_NAME,
> f94ee127-330c-4a76-893b-009d4d9166b2=VM]', sharedLocks=''}'
> 2021-11-13 14:20:29,757-05 ERROR
> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
> (EE-ManagedScheduledExecutorService-engineScheduledThreadPool-Thread-60)
> [2728db3e] EVENT_ID: IMPORTEXPORT_IMPORT_VM_FAILED(1,153), Failed to import
> Vm lightning to Data Center DC, Cluster oVirt1
>

Hi Thomas,
Thanks for the report. I opened - Bug 2023368
<https://bugzilla.redhat.com/show_bug.cgi?id=2023368>.
For a workaround, it might work to modify manually the storage ID for the
lease in the OVF within the OVA file:
<LeaseDomainId>ID</LeaseDomainId>
Removing it might do or changing the ID to the ID of an existing storage
domain.

Regards,
Liran.

> _______________________________________________
> Users mailing list -- [email protected]
> To unsubscribe send an email to [email protected]
> Privacy Statement: https://www.ovirt.org/privacy-policy.html
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/[email protected]/message/CQHIP32K2KRWCBDPHZOC3YES4XWIMG6E/
>
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/[email protected]/message/5OC2CO5IRATXMLBWIOKLUYBVV5WIDEKM/

Reply via email to