SQL Error

Steps to reproduce

Start Opencast with one job already processed (Adjust log level for external libs)

Activity

Show:
Christian Greweling
June 3, 2016, 10:43 PM

Can't Reproduce this in the actual 2.2.x.

Sven Stauber
July 27, 2016, 9:46 PM

Could reproduce this:

Internal Exception: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UNQ_MH_ACL_MANAGED_ACL_0_INDEX_9 ON PUBLIC.MH_ACL_MANAGED_ACL(NAME, ORGANIZATION_ID)"; SQL statement:
INSERT INTO mh_acl_managed_acl (pk, acl, name, organization_id) VALUES (?, ?, ?, ?) [23505-172]
Error Code: 23505
Call: INSERT INTO mh_acl_managed_acl (pk, acl, name, organization_id) VALUES (?, ?, ?, ?)
bind => [4 parameters bound]

Lars Kiesow
July 27, 2016, 9:53 PM

You just have to start Opencast twice but there is already a fix for this.

Sven Stauber
July 27, 2016, 10:09 PM

Hi Lars, yes, I know: I'm currently reviewing it

Fixed and reviewed

Assignee

Lars Kiesow

Reporter

Lars Kiesow

Severity

Non Functioning

Tags (folksonomy)

None

Components

Fix versions

Affects versions

Priority

Blocker