Hi Jonas
Apparently there is a quite new bug open about this issue
(https://bugzilla.redhat.com/1057147).
CC-ing Juan and Yair - perhaps the'll know what's the source of the issue, as I
think they were the last ones to make changes in it.
Oved
- Original Message -
> From: "Jonas Israelsson"
> To: users@ovirt.org
> Sent: Tuesday, January 28, 2014 11:34:50 AM
> Subject: [Users] Ovirt 3.4 - Fail to set permissions to VM
>
> Greetings.
>
> I have set up oVirt to use Openldap for its users store. I managed to
> make two users SuperUser but now when trying to add a third as a normal
> user and give him permission to a VM it fails. From the log I see it
> complains about duplicate key violations.
>
> No matter what user I try to add to this vm I get the same error. Maybe
> it's beyond me but I really do not understand why It wants to add
> something to the users table (since the user is already there), sounds
> like a bug to me..
>
> Anyone else have the same setup as me, and have this working ?
>
> [root@dashboard ovirt-engine]# tail -100 engine.log
> 2014-01-28 10:19:14,655 INFO
> [org.ovirt.engine.core.bll.AddPermissionCommand]
> (org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Running command:
> AddPermissionCommand internal: false. Entities affected : ID:
> 18bcf10a-6f63-44ea-8a9b-70f423476473 Type: StoragePool, ID:
> aaa0----123456789aaa Type: System
> 2014-01-28 10:19:14,658 ERROR
> [org.ovirt.engine.core.bll.AddPermissionCommand]
> (org.ovirt.thread.pool-6-thread-26) [5c95fa5a] Command
> org.ovirt.engine.core.bll.AddPermissionCommand throw exception:
> org.springframework.dao.DuplicateKeyException:
> CallableStatementCallback; SQL [{call insertuser(?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint
> "users_domain_external_id_unique"
>Where: SQL statement "INSERT INTO users(department, domain, email,
> groups, name, note, role, active, surname, user_id, username, group_ids,
> external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
> , $10 , $11 , $12 , $13 )"
> PL/pgSQL function "insertuser" line 2 at SQL statement; nested exception
> is org.postgresql.util.PSQLException: ERROR: duplicate key value
> violates unique constraint "users_domain_external_id_unique"
>Where: SQL statement "INSERT INTO users(department, domain, email,
> groups, name, note, role, active, surname, user_id, username, group_ids,
> external_id) VALUES( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9
> , $10 , $11 , $12 , $13 )"
> PL/pgSQL function "insertuser" line 2 at SQL statement
> at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181)
> [spring-jdbc.jar:3.1.1.RELEASE]
> at
> org.ovirt.engine.core.dao.DbUserDAODbFacadeImpl.save(DbUserDAODbFacadeImpl.java:119)
> [dal.jar:]
> at
> org.ovirt.engine.core.bll.AddPermissionCommand.executeCommand(AddPermissionCommand.java:94)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1114)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1199)
> [bll.jar:]
> at
> org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1875)
> [bll.jar:]
> at
> org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210)
> [utils.jar:]
> at
> org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInRequired(TransactionSupport.java:149)
> [utils.jar:]
> at
> org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:118)
> [u
