Re: [ovirt-devel] [ OST Failure Report ] [ oVirt 4.2 (ovirt-hosted-engine-setup) ] [ 08-03-2018 ] [ 004_basic_sanity.run_vms ]

2018-03-08 Thread Yaniv Kaul
On Thu, Mar 8, 2018 at 1:53 PM, Dafna Ron  wrote:

> Hi,
>
> We have a failed test on ovirt-hosted-engine-setup basic suite.
> We failed to run a vm with internal engine error.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *Link and headline of suspected patches: Add engine fqdn to inventory and
> allow dynamic inventory scripts - https://gerrit.ovirt.org/#/c/88622/
> Link to
> Job:http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/
> Link to
> all
> logs:http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/artifact/
> (Relevant)
> error snippet from the log: 2018-03-07 17:03:38,374-05 INFO
> [org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
> [a514da44-d44f-46b9-8bdf-08ba2d513929] Running command: RunVmOnceCommand
> internal: false. Entities affected :  ID:
> 634c6a46-d057-4509-be3b-710716cbd56d Type: VMAction group RUN_VM with role
> type USER,  ID: 634c6a46-d057-4509-be3b-710716cbd56d Type: VMAction group
> EDIT_ADMIN_VM_PROPERTIES with role type ADMIN2018-03-07 17:03:38,379-05
> DEBUG [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getVmManager, params: [634c6a46-d057-4509-be3b-710716cbd56d], timeElapsed:
> 5ms2018-03-07 17:03:38,391-05 DEBUG
> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getAllForClusterWithStatus, params: [14cad400-49a0-44e0-ab15-9da778f08082,
> Up], timeElapsed: 7ms2018-03-07 17:03:38,408-05 DEBUG
> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getVdsManager, params: [8ef2f490-1b76-46e0-b9fe-f3412a36e03b], timeElapsed:
> 0ms2018-03-07 17:03:38,419-05 DEBUG
> [org.ovirt.engine.core.dal.dbbroker.CustomSQLErrorCodeSQLExceptionTranslator]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] Translating
> SQLException with SQL state '23505', error code '0', message [ERROR:
> duplicate key value violates unique constraint "name_server_pkey"*
>

A quick Google search on the above seems to point to
https://bugzilla.redhat.com/show_bug.cgi?id=1547070 , which says:
Steps to Reproduce:
1. Refresh caps during start VM operation

So might be relevant, I think.
Y.


>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *  Detail: Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.  Where: SQL statement "INSERT INTOname_server(
> address,  position,  dns_resolver_configuration_id)VALUES
> (  v_address,  v_position,
> v_dns_resolver_configuration_id)"PL/pgSQL function
> insertnameserver(uuid,character varying,smallint) line 3 at SQL statement];
> SQL was [{call insertnameserver(?, ?, ?)}] for task
> [CallableStatementCallback]2018-03-07 17:03:38,420-05 ERROR
> [org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
> [a514da44-d44f-46b9-8bdf-08ba2d513929] Command
> 'org.ovirt.engine.core.bll.RunVmOnceCommand' failed:
> CallableStatementCallback; SQL [{call insertnameserver(?, ?, ?)}]; ERROR:
> duplicate key value violates unique constraint "name_server_pkey"  Detail:
> Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.  Where: SQL statement "INSERT INTOname_server(
> address,  position,  dns_resolver_configuration_id)VALUES
> (  v_address,  v_position,
> v_dns_resolver_configuration_id)"PL/pgSQL function
> insertnameserver(uuid,character varying,smallint) line 3 at SQL statement;
> nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key
> value violates unique constraint "name_server_pkey"  Detail: Key
> (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.  Where: SQL statement "INSERT INTOname_server(
> address,  position,  dns_resolver_configuration_id)VALUES
> (  v_address,  v_position,
> v_dns_resolver_configuration_id)"PL/pgSQL function
> insertnameserver(uuid,character varying,smallint) line 3 at SQL
> 

Re: [ovirt-devel] [ OST Failure Report ] [ oVirt 4.2 (ovirt-hosted-engine-setup) ] [ 08-03-2018 ] [ 004_basic_sanity.run_vms ]

2018-03-08 Thread Martin Sivak
Does not seem to be hosted engine related.. there is no way we could
cause internal engine error by using the API alone.

Martin

On Thu, Mar 8, 2018 at 12:53 PM, Dafna Ron  wrote:
> Hi,
>
> We have a failed test on ovirt-hosted-engine-setup basic suite.
> We failed to run a vm with internal engine error.
>
> Link and headline of suspected patches:
>
> Add engine fqdn to inventory and allow dynamic inventory scripts -
> https://gerrit.ovirt.org/#/c/88622/
>
> Link to Job:
>
> http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/
>
> Link to all logs:
>
> http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/artifact/
>
> (Relevant) error snippet from the log:
>
> 
>
>
> 2018-03-07 17:03:38,374-05 INFO
> [org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
> [a514da44-d44f-46b9-8bdf-08ba2d513929] Running command: RunVmOnceCommand
> internal: false. Entities affected :  ID: 634c6a46-d057-4509-be3b-710
> 716cbd56d Type: VMAction group RUN_VM with role type USER,  ID:
> 634c6a46-d057-4509-be3b-710716cbd56d Type: VMAction group
> EDIT_ADMIN_VM_PROPERTIES with role type ADMIN
> 2018-03-07 17:03:38,379-05 DEBUG
> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getVmManager, params: [634c6a46-d057-4509-be3b-710716cbd56d], timeElap
> sed: 5ms
> 2018-03-07 17:03:38,391-05 DEBUG
> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getAllForClusterWithStatus, params: [14cad400-49a0-44e0-ab15-9da778f08
> 082, Up], timeElapsed: 7ms
> 2018-03-07 17:03:38,408-05 DEBUG
> [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
> getVdsManager, params: [8ef2f490-1b76-46e0-b9fe-f3412a36e03b], timeEla
> psed: 0ms
> 2018-03-07 17:03:38,419-05 DEBUG
> [org.ovirt.engine.core.dal.dbbroker.CustomSQLErrorCodeSQLExceptionTranslator]
> (default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] Translating
> SQLException with SQL state '23505', error code '0', messa
> ge [ERROR: duplicate key value violates unique constraint "name_server_pkey"
>   Detail: Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.
>   Where: SQL statement "INSERT INTO
> name_server(
>   address,
>   position,
>   dns_resolver_configuration_id)
> VALUES (
>   v_address,
>   v_position,
>   v_dns_resolver_configuration_id)"
> PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3
> at SQL statement]; SQL was [{call insertnameserver(?, ?, ?)}] for task
> [CallableStatementCallback]
> 2018-03-07 17:03:38,420-05 ERROR
> [org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
> [a514da44-d44f-46b9-8bdf-08ba2d513929] Command
> 'org.ovirt.engine.core.bll.RunVmOnceCommand' failed:
> CallableStatementCallback; SQL [{call inse
> rtnameserver(?, ?, ?)}]; ERROR: duplicate key value violates unique
> constraint "name_server_pkey"
>   Detail: Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.
>   Where: SQL statement "INSERT INTO
> name_server(
>   address,
>   position,
>   dns_resolver_configuration_id)
> VALUES (
>   v_address,
>   v_position,
>   v_dns_resolver_configuration_id)"
> PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3
> at SQL statement; nested exception is org.postgresql.util.PSQLException:
> ERROR: duplicate key value violates unique constraint "name_server_pkey"
>   Detail: Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.
>   Where: SQL statement "INSERT INTO
> name_server(
>   address,
>   position,
>   dns_resolver_configuration_id)
> VALUES (
>   v_address,
>   v_position,
>   v_dns_resolver_configuration_id)"
> PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3
> at SQL statement
> 2018-03-07 17:03:38,420-05 ERROR
> [org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
> [a514da44-d44f-46b9-8bdf-08ba2d513929] Exception:
> org.springframework.dao.DuplicateKeyException: CallableStatementCallback;
> SQL [{call insertn
> ameserver(?, ?, ?)}]; ERROR: duplicate key value violates unique constraint
> "name_server_pkey"
>   Detail: Key (dns_resolver_configuration_id,
> address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
> exists.
>   Where: SQL statement "INSERT INTO
> name_server(
>   address,
>   position,
>   dns_resolver_configuration_id)
> VALUES (
> :
>v_address,
>   v_position,
>   v_dns_resolver_configuration_id)"
> PL/pgSQL function insertnameserver(uuid,character varying,smallint) line 3
> at SQL statement; nested 

[ovirt-devel] [ OST Failure Report ] [ oVirt 4.2 (ovirt-hosted-engine-setup) ] [ 08-03-2018 ] [ 004_basic_sanity.run_vms ]

2018-03-08 Thread Dafna Ron
Hi,

We have a failed test on ovirt-hosted-engine-setup basic suite.
We failed to run a vm with internal engine error.




























































































































































































































































































































































*Link and headline of suspected patches: Add engine fqdn to inventory and
allow dynamic inventory scripts - https://gerrit.ovirt.org/#/c/88622/
Link to
Job:http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/
Link to
all
logs:http://jenkins.ovirt.org/job/ovirt-4.2_change-queue-tester/1064/artifact/
(Relevant)
error snippet from the log: 2018-03-07 17:03:38,374-05 INFO
[org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
[a514da44-d44f-46b9-8bdf-08ba2d513929] Running command: RunVmOnceCommand
internal: false. Entities affected :  ID:
634c6a46-d057-4509-be3b-710716cbd56d Type: VMAction group RUN_VM with role
type USER,  ID: 634c6a46-d057-4509-be3b-710716cbd56d Type: VMAction group
EDIT_ADMIN_VM_PROPERTIES with role type ADMIN2018-03-07 17:03:38,379-05
DEBUG [org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
(default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
getVmManager, params: [634c6a46-d057-4509-be3b-710716cbd56d], timeElapsed:
5ms2018-03-07 17:03:38,391-05 DEBUG
[org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
(default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
getAllForClusterWithStatus, params: [14cad400-49a0-44e0-ab15-9da778f08082,
Up], timeElapsed: 7ms2018-03-07 17:03:38,408-05 DEBUG
[org.ovirt.engine.core.common.di.interceptor.DebugLoggingInterceptor]
(default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] method:
getVdsManager, params: [8ef2f490-1b76-46e0-b9fe-f3412a36e03b], timeElapsed:
0ms2018-03-07 17:03:38,419-05 DEBUG
[org.ovirt.engine.core.dal.dbbroker.CustomSQLErrorCodeSQLExceptionTranslator]
(default task-21) [a514da44-d44f-46b9-8bdf-08ba2d513929] Translating
SQLException with SQL state '23505', error code '0', message [ERROR:
duplicate key value violates unique constraint "name_server_pkey"  Detail:
Key (dns_resolver_configuration_id,
address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
exists.  Where: SQL statement "INSERT INTOname_server(
address,  position,  dns_resolver_configuration_id)VALUES
(  v_address,  v_position,
v_dns_resolver_configuration_id)"PL/pgSQL function
insertnameserver(uuid,character varying,smallint) line 3 at SQL statement];
SQL was [{call insertnameserver(?, ?, ?)}] for task
[CallableStatementCallback]2018-03-07 17:03:38,420-05 ERROR
[org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
[a514da44-d44f-46b9-8bdf-08ba2d513929] Command
'org.ovirt.engine.core.bll.RunVmOnceCommand' failed:
CallableStatementCallback; SQL [{call insertnameserver(?, ?, ?)}]; ERROR:
duplicate key value violates unique constraint "name_server_pkey"  Detail:
Key (dns_resolver_configuration_id,
address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
exists.  Where: SQL statement "INSERT INTOname_server(
address,  position,  dns_resolver_configuration_id)VALUES
(  v_address,  v_position,
v_dns_resolver_configuration_id)"PL/pgSQL function
insertnameserver(uuid,character varying,smallint) line 3 at SQL statement;
nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key
value violates unique constraint "name_server_pkey"  Detail: Key
(dns_resolver_configuration_id,
address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
exists.  Where: SQL statement "INSERT INTOname_server(
address,  position,  dns_resolver_configuration_id)VALUES
(  v_address,  v_position,
v_dns_resolver_configuration_id)"PL/pgSQL function
insertnameserver(uuid,character varying,smallint) line 3 at SQL
statement2018-03-07 17:03:38,420-05 ERROR
[org.ovirt.engine.core.bll.RunVmOnceCommand] (default task-21)
[a514da44-d44f-46b9-8bdf-08ba2d513929] Exception:
org.springframework.dao.DuplicateKeyException: CallableStatementCallback;
SQL [{call insertnameserver(?, ?, ?)}]; ERROR: duplicate key value violates
unique constraint "name_server_pkey"  Detail: Key
(dns_resolver_configuration_id,
address)=(8a941b6a-83aa-44de-9800-2a1ea6e8e029, 192.168.200.1) already
exists.  Where: SQL statement "INSERT INTOname_server(
address,  position,  dns_resolver_configuration_id)VALUES (:
v_address,  v_position,  v_dns_resolver_configuration_id)"PL/pgSQL
function insertnameserver(uuid,character varying,smallint) line 3 at SQL
statement; nested exception is