Looking .... On Tue, Aug 7, 2018 at 2:42 PM, Dafna Ron <dron(a)redhat.com&gt; wrote: > Hi, > > We are failing ovirt 4.2 on project ovirt-engine on test > 004_basic_sanity.update_template_version. > > I believe the reported patch from CQ may have indeed caused the issue. > > Eli, can you please check this issue? > > *Link and headline of suspected patches: > https://gerrit.ovirt.org/#/c/93501/ <https://gerrit.ovirt.org/#/c/93501/> - > * > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > *core:make search string fields not null and emptyLink to > Job:https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800 > <https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800>Link to > all > logs:https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800/art... > <https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800/artifact... > error snippet from the log: <error><JsonRpcRequest id: > "0aec9ef2-5e1f-4cb6-bf75-f5826d2ae135", method: Volume.getInfo, params: > {storagepoolID=fe6f6819-4791-4624-aa56-c82e49b0eaf3, > storagedomainID=2a3af2d0-c00e-4ac7-a162-fa08d33c173f, > imageID=2d2f61d4-2347-4200-9c1f-0ee376104ef0, > volumeID=21ea717f-e3a1-4c36-8101-ba746bd78c40}>2018-08-07 06:12:46,522-04 > INFO [org.ovirt.engine.core.bll.AddVmTemplateCommand] (default task-4) > [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] Running command: > AddVmTemplateCommand internal: false. Entities affected : ID: > fe6f6819-4791-4624-aa56-c82e49b0eaf3 Type: StoragePoolAction group > CREATE_TEMPLATE with role type USER2018-08-07 06:12:46,525-04 INFO > [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (default task-4) > [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] START, SetVmStatusVDSCommand( > SetVmStatusVDSCommandParameters:{vmId='64293490-e128-48b7-9e23-0491b48d9a1f', > status='ImageLocked', exitStatus='Normal'}), log id: eca02a92018-08-07 > 06:12:46,527-04 INFO > [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (default task-4) > [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] FINISH, SetVmStatusVDSCommand, log > id: eca02a92018-08-07 06:12:46,527-04 DEBUG > [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor] > (default task-4) [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] method: > runVdsCommand, params: [SetVmStatus, > SetVmStatusVDSCommandParameters:{vmId='64293490-e128-48b7-9e23-0491b48d9a1f', > status='ImageLocked', exitStatus='Normal'}], timeElapsed: 3ms2018-08-07 > 06:12:46,537-04 DEBUG > [org.ovirt.engine.core.dal.dbbroker.CustomSQLErrorCodeSQLExceptionTranslator] > (default task-4) [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] Translating > SQLException with SQL state '23502', error code '0', message [ERROR: null > value in column "description" violates not-null constraint Detail: Failing > row contains (ce532690-2131-49a8-b2a0-183936727092, > CirrOS_0.4.0_for_x86_64_glance_template, 512, > 5b1f874d-dc92-43ed-86ef-a9c2d6bfc9a3, 0, null, > fe7292a4-c998-4f6c-897c-fa7525911a16, 2018-08-07 06:12:46.529-04, 1, null, > f, 1, 1, 1, Etc/GMT, t, f, 2018-08-07 06:12:46.530974-04, null, null, f, 1, > 0, 0, 1, 0, , 3, null, null, null, 0, , , 256, TEMPLATE, 0, 1, > 31a8e1fa-1fad-456c-8b8a-aa11551cae9d, f, null, f, f, 1, f, f, f, > d0d66980-9a26-11e8-b2f3-5452c0a8c802, null, , f, 0, null, null, null, > guest_agent, null, null, null, 2, null, 2, 12345678, f, interleave, t, t, > deb3f53e-13c5-4aea-bf90-0339eba39fed, null, null, null, null, > 22716173-2816-a109-1d2f-c44d945e92dd, 3b3f239c-d8bb-423f-a39c-e2b905473b83, > null, 1, LOCK_SCREEN, 2, null, null, 2048, null, AUTO_RESUME, t). Where: > SQL statement "INSERT INTO vm_static( child_count, > creation_date, description, free_text_comment, > mem_size_mb, max_memory_size_mb, num_of_io_threads, > vm_name, num_of_sockets, cpu_per_socket, > threads_per_cpu, os, vm_guid, cluster_id, > num_of_monitors, single_qxl_pci, > allow_console_reconnect, template_status, usb_policy, > time_zone, fail_back, vm_type, nice_level, > cpu_shares, default_boot_sequence, default_display_type,* > > > *</error>* >

On Wed, Aug 8, 2018 at 11:28 AM, Dafna Ron <dron(a)redhat.com&gt; wrote: > Eli, Any updates? > Below patch should fix the issue: https://gerrit.ovirt.org/#/c/93568/ > > On Tue, Aug 7, 2018 at 4:51 PM, Eli Mesika <emesika(a)redhat.com&gt; wrote: > >> Looking .... >> >> On Tue, Aug 7, 2018 at 2:42 PM, Dafna Ron <dron(a)redhat.com&gt; wrote: >> >>> Hi, >>> >>> We are failing ovirt 4.2 on project ovirt-engine on test >>> 004_basic_sanity.update_template_version. >>> >>> I believe the reported patch from CQ may have indeed caused the issue. >>> >>> Eli, can you please check this issue? >>> >>> *Link and headline of suspected patches: >>> https://gerrit.ovirt.org/#/c/93501/ <https://gerrit.ovirt.org/#/c/93501/> - >>> * >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> *core:make search string fields not null and emptyLink to >>> Job:https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800 >>> <https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800>Link to >>> all >>> logs:https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800/art... >>> <https://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/2800/artifact... >>> error snippet from the log: <error><JsonRpcRequest id: >>> "0aec9ef2-5e1f-4cb6-bf75-f5826d2ae135", method: Volume.getInfo, params: >>> {storagepoolID=fe6f6819-4791-4624-aa56-c82e49b0eaf3, >>> storagedomainID=2a3af2d0-c00e-4ac7-a162-fa08d33c173f, >>> imageID=2d2f61d4-2347-4200-9c1f-0ee376104ef0, >>> volumeID=21ea717f-e3a1-4c36-8101-ba746bd78c40}>2018-08-07 06:12:46,522-04 >>> INFO [org.ovirt.engine.core.bll.AddVmTemplateCommand] (default task-4) >>> [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] Running command: >>> AddVmTemplateCommand internal: false. Entities affected : ID: >>> fe6f6819-4791-4624-aa56-c82e49b0eaf3 Type: StoragePoolAction group >>> CREATE_TEMPLATE with role type USER2018-08-07 06:12:46,525-04 INFO >>> [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (default task-4) >>> [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] START, SetVmStatusVDSCommand( >>> SetVmStatusVDSCommandParameters:{vmId='64293490-e128-48b7-9e23-0491b48d9a1f', >>> status='ImageLocked', exitStatus='Normal'}), log id: eca02a92018-08-07 >>> 06:12:46,527-04 INFO >>> [org.ovirt.engine.core.vdsbroker.SetVmStatusVDSCommand] (default task-4) >>> [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] FINISH, SetVmStatusVDSCommand, log >>> id: eca02a92018-08-07 06:12:46,527-04 DEBUG >>> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor] >>> (default task-4) [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] method: >>> runVdsCommand, params: [SetVmStatus, >>> SetVmStatusVDSCommandParameters:{vmId='64293490-e128-48b7-9e23-0491b48d9a1f', >>> status='ImageLocked', exitStatus='Normal'}], timeElapsed: 3ms2018-08-07 >>> 06:12:46,537-04 DEBUG >>> [org.ovirt.engine.core.dal.dbbroker.CustomSQLErrorCodeSQLExceptionTranslator] >>> (default task-4) [6db41b0d-0d11-4b75-94f9-4a478e6fb3dc] Translating >>> SQLException with SQL state '23502', error code '0', message [ERROR: null >>> value in column "description" violates not-null constraint Detail: Failing >>> row contains (ce532690-2131-49a8-b2a0-183936727092, >>> CirrOS_0.4.0_for_x86_64_glance_template, 512, >>> 5b1f874d-dc92-43ed-86ef-a9c2d6bfc9a3, 0, null, >>> fe7292a4-c998-4f6c-897c-fa7525911a16, 2018-08-07 06:12:46.529-04, 1, null, >>> f, 1, 1, 1, Etc/GMT, t, f, 2018-08-07 06:12:46.530974-04, null, null, f, 1, >>> 0, 0, 1, 0, , 3, null, null, null, 0, , , 256, TEMPLATE, 0, 1, >>> 31a8e1fa-1fad-456c-8b8a-aa11551cae9d, f, null, f, f, 1, f, f, f, >>> d0d66980-9a26-11e8-b2f3-5452c0a8c802, null, , f, 0, null, null, null, >>> guest_agent, null, null, null, 2, null, 2, 12345678, f, interleave, t, t, >>> deb3f53e-13c5-4aea-bf90-0339eba39fed, null, null, null, null, >>> 22716173-2816-a109-1d2f-c44d945e92dd, 3b3f239c-d8bb-423f-a39c-e2b905473b83, >>> null, 1, LOCK_SCREEN, 2, null, null, 2048, null, AUTO_RESUME, t). Where: >>> SQL statement "INSERT INTO vm_static( child_count, >>> creation_date, description, free_text_comment, >>> mem_size_mb, max_memory_size_mb, num_of_io_threads, >>> vm_name, num_of_sockets, cpu_per_socket, >>> threads_per_cpu, os, vm_guid, cluster_id, >>> num_of_monitors, single_qxl_pci, >>> allow_console_reconnect, template_status, usb_policy, >>> time_zone, fail_back, vm_type, nice_level, >>> cpu_shares, default_boot_sequence, default_display_type,* >>> >>> >>> *</error>* >>> >> >> > > _______________________________________________ > Devel mailing list -- devel(a)ovirt.org > To unsubscribe send an email to devel-leave(a)ovirt.org > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: https://www.ovirt.org/communit > y/about/community-guidelines/ > List Archives: https://lists.ovirt.org/archiv > es/list/devel(a)ovirt.org/message/XYAH23EW3WPS4W2ZFUMUB5NQDLKRO52V/ > > -- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.