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