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.
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
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
