Looking ....

On Tue, Aug 7, 2018 at 2:42 PM, Dafna Ron <dron@redhat.com> 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/ -
core:make search string fields not null and empty

Link to Job:

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/artifact/basic-suite.el7.x86_64/test_logs/basic-suite-4.2/post-004_basic_sanity.py/

(Relevant) 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-0ee3761
04ef0, 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-a
a56-c82e49b0eaf3 Type: StoragePoolAction group CREATE_TEMPLATE with role type USER
2018-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: eca02a9
2018-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: eca02a9
2018-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:{v
mId='64293490-e128-48b7-9e23-0491b48d9a1f', status='ImageLocked', exitStatus='Normal'}], timeElapsed: 3ms
2018-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', messag
e [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>