[Users] VM with stateless snapshot won't start

Thu Dec 5 11:23:10 UTC 2013

Hi,

> After maintenance on a host, I am trying to start a VM that has been
> running statelessly for a while. It refuses to start and Engine logs the
> following:
> 
> 2013-12-05 11:59:18,125 INFO
> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
> (pool-6-thread-48) Correlation ID: 43d49965, Job ID:
> 0d943a6d-9d65-4ac1-89b7-139d30b4813c, Call Stack: null, Custom Event ID:
> -1, Message: Failed to start VM WinXP, because exist snapshot for
> stateless state. Snapshot will be deleted.
> 
> Should I submit a bug report for the poor English in this log line? ;-)
> 
> The 'Snapshots' tab for the VM doesn't show anything, but repeated
> attempts to start the VM just show the same message in the log.
> 
> What can I do to start this VM?

It seems I missed some info in the log that may well indicate the root
cause of this issue. Please see attached log excerpt. A database query
is failing due to a foreign key constraint violation.

Please advise how to fix the database inconsistency.

Regards,
Martijn.

-------------- next part --------------
2013-12-05 12:16:18,463 INFO  [org.ovirt.engine.core.bll.RunVmCommand] (pool-6-thread-49) [7f341556] Running command: RunVmCommand internal: false. En
tities affected :  ID: de196133-0ccf-41c2-a91d-1760be442080 Type: VM
2013-12-05 12:16:18,475 ERROR [org.ovirt.engine.core.bll.RunVmCommand] (pool-6-thread-49) [7f341556] RunVmAsStateless - WinXP - found stateless snapsh
ots for this vm  - skipped creating snapshots.
2013-12-05 12:16:18,476 INFO  [org.ovirt.engine.core.bll.VmPoolHandler] (pool-6-thread-49) [7f341556] VdcBll.VmPoolHandler.ProcessVmPoolOnStopVm - Del
eting snapshot for stateless vm de196133-0ccf-41c2-a91d-1760be442080
2013-12-05 12:16:18,481 INFO  [org.ovirt.engine.core.bll.RestoreStatelessVmCommand] (pool-6-thread-49) Running command: RestoreStatelessVmCommand inte
rnal: true. Entities affected :  ID: de196133-0ccf-41c2-a91d-1760be442080 Type: VM
2013-12-05 12:16:18,487 INFO  [org.ovirt.engine.core.bll.RestoreAllSnapshotsCommand] (pool-6-thread-49) Running command: RestoreAllSnapshotsCommand in
ternal: true. Entities affected :  ID: de196133-0ccf-41c2-a91d-1760be442080 Type: VM
2013-12-05 12:16:18,488 INFO  [org.ovirt.engine.core.bll.RestoreAllSnapshotsCommand] (pool-6-thread-49) Locking VM(id = de196133-0ccf-41c2-a91d-1760be
442080) without compensation.
2013-12-05 12:16:18,489 INFO  [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (pool-6-thread-49) START, SetVmStatusVDSCommand( vmId = de196133
-0ccf-41c2-a91d-1760be442080, status = ImageLocked), log id: 7032f4da
2013-12-05 12:16:18,491 INFO  [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (pool-6-thread-49) FINISH, SetVmStatusVDSCommand, log id: 7032f4
da
2013-12-05 12:16:18,562 ERROR [org.ovirt.engine.core.bll.RestoreAllSnapshotsCommand] (pool-6-thread-49) Command org.ovirt.engine.core.bll.RestoreAllSn
apshotsCommand throw exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call updatevmstatic(?, ?, ?,
 ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: insert or
update on table "vm_static" violates foreign key constraint "fk_vm_static_quota"
  Detail: Key (quota_id)=(00000000-0000-0000-0000-000000000000) is not present in table "quota".
  Where: SQL statement "UPDATE vm_static SET description =  $1 , free_text_comment =  $2  ,mem_size_mb =  $3 ,os =  $4 ,vds_group_id =  $5 , VM_NAME =  $6 ,vmt_guid =  $7 , domain =  $8 ,creation_date =  $9 ,num_of_monitors =  $10 ,single_qxl_pci =  $11 , allow_console_reconnect =  $12 , is_initialized =  $13 , num_of_sockets =  $14 ,cpu_per_socket =  $15 , usb_policy =  $16 ,time_zone =  $17 ,auto_startup =  $18 , is_stateless =  $19 ,dedicated_vm_for_vds =  $20 , fail_back =  $21 ,vm_type =  $22 , nice_level =  $23 , cpu_shares =  $24 , _update_date = LOCALTIMESTAMP,default_boot_sequence =  $25 , default_display_type =  $26 , priority =  $27 ,iso_path =  $28 ,origin =  $29 , initrd_url =  $30 ,kernel_url =  $31 , kernel_params =  $32 ,migration_support =  $33 , predefined_properties =  $34 ,userdefined_properties =  $35 , min_allocated_mem =  $36 , quota_id =  $37 , cpu_pinning =  $38 , is_smartcard_enabled =  $39 , is_delete_protected =  $40 , host_cpu_flags =  $41 , tunnel_migration =  $42 , vnc_keyboard_layout =  $43 , is_run_and_pause =  $44 , created_by_user_id =  $45  WHERE vm_guid =  $46  AND entity_type = 'VM'"
PL/pgSQL function "updatevmstatic" line 2 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "vm_static" violates foreign key constraint "fk_vm_static_quota"
  Detail: Key (quota_id)=(00000000-0000-0000-0000-000000000000) is not present in table "quota".
  Where: SQL statement "UPDATE vm_static SET description =  $1 , free_text_comment =  $2  ,mem_size_mb =  $3 ,os =  $4 ,vds_group_id =  $5 , VM_NAME =  $6 ,vmt_guid =  $7 , domain =  $8 ,creation_date =  $9 ,num_of_monitors =  $10 ,single_qxl_pci =  $11 , allow_console_reconnect =  $12 , is_initialized =  $13 , num_of_sockets =  $14 ,cpu_per_socket =  $15 , usb_policy =  $16 ,time_zone =  $17 ,auto_startup =  $18 , is_stateless =  $19 ,dedicated_vm_for_vds =  $20 , fail_back =  $21 ,vm_type =  $22 , nice_level =  $23 , cpu_shares =  $24 , _update_date = LOCALTIMESTAMP,default_boot_sequence =  $25 , default_display_type =  $26 , priority =  $27 ,iso_path =  $28 ,origin =  $29 , initrd_url =  $30 ,kernel_url =  $31 , kernel_params =  $32 ,migration_support =  $33 , predefined_properties =  $34 ,userdefined_properties =  $35 , min_allocated_mem =  $36 , quota_id =  $37 , cpu_pinning =  $38 , is_smartcard_enabled =  $39 , is_delete_protected =  $40 , host_cpu_flags =  $41 , tunnel_migration =  $42 , vnc_keyboard_layout =  $43 , is_run_and_pause =  $44 , created_by_user_id =  $45  WHERE vm_guid =  $46  AND entity_type = 'VM'"
PL/pgSQL function "updatevmstatic" line 2 at SQL statement

Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "vm_static" violates foreign key constraint "fk_vm_static_quota"
  Detail: Key (quota_id)=(00000000-0000-0000-0000-000000000000) is not present in table "quota".
  Where: SQL statement "UPDATE vm_static SET description =  $1 , free_text_comment =  $2  ,mem_size_mb =  $3 ,os =  $4 ,vds_group_id =  $5 , VM_NAME =  $6 ,vmt_guid =  $7 , domain =  $8 ,creation_date =  $9 ,num_of_monitors =  $10 ,single_qxl_pci =  $11 , allow_console_reconnect =  $12 , is_initialized =  $13 , num_of_sockets =  $14 ,cpu_per_socket =  $15 , usb_policy =  $16 ,time_zone =  $17 ,auto_startup =  $18 , is_stateless =  $19 ,dedicated_vm_for_vds =  $20 , fail_back =  $21 ,vm_type =  $22 , nice_level =  $23 , cpu_shares =  $24 , _update_date = LOCALTIMESTAMP,default_boot_sequence =  $25 , default_display_type =  $26 , priority =  $27 ,iso_path =  $28 ,origin =  $29 , initrd_url =  $30 ,kernel_url =  $31 , kernel_params =  $32 ,migration_support =  $33 , predefined_properties =  $34 ,userdefined_properties =  $35 , min_allocated_mem =  $36 , quota_id =  $37 , cpu_pinning =  $38 , is_smartcard_enabled =  $39 , is_delete_protected =  $40 , host_cpu_flags =  $41 , tunnel_migration =  $42 , vnc_keyboard_layout =  $43 , is_run_and_pause =  $44 , created_by_user_id =  $45  WHERE vm_guid =  $46  AND entity_type = 'VM'"
PL/pgSQL function "updatevmstatic" line 2 at SQL statement