[
http://opencast.jira.com/browse/MH-8506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=29147#comment-29147
]
Greg Logan commented on MH-8506:
--------------------------------
It seems like this could be potentially solved by removing the indexes from a
few columns. The following tables are the issue:
capture_agent_state -> PRIMARY KEY(id, organization)
matterhorn_user -> PRIMARY KEY(id, organization)
dictionary -> PRIMARY KEY(text, language)
Removing one of the two primary keys from each table resolves the issue. Can
we live without organization being a PK? Same thing with language. I'm not
familiar with what's querying those specific columns, but if they don't need to
be PKs then we should demote them to regular columns and move on.
> MySQL ddl script fails
> ----------------------
>
> Key: MH-8506
> URL: http://opencast.jira.com/browse/MH-8506
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Architecture & Services
> Affects Versions: 1.3
> Reporter: Hank Magnuski
> Assignee: Greg Logan
> Priority: Release Blocker
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
