[
http://opencast.jira.com/browse/MH-8335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=28778#comment-28778
]
Hank Magnuski commented on MH-8335:
-----------------------------------
I tried the sample sql file under MySQL5 on Centos using the mysql tool. First
I had to add trailing semicolons to all the commands. After that there were
many errors:
mysql> source /opt/matterhorn/MySQL5-MH-8335.txt
Query OK, 0 rows affected (0.05 sec)
Query OK, 0 rows affected (0.07 sec)
Query OK, 1 row affected (0.00 sec)
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Query OK, 0 rows affected (0.03 sec)
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.02 sec)
ERROR 1050 (42S01): Table 'SEQUENCE' already exists
ERROR 1062 (23000): Duplicate entry 'SEQ_GEN' for key 1
Query OK, 0 rows affected (0.02 sec)
ERROR 1170 (42000): BLOB/TEXT column 'service_type' used in key specification
without a key length
Query OK, 0 rows affected (0.02 sec)
ERROR 1170 (42000): BLOB/TEXT column 'host' used in key specification without a
key length
Query OK, 0 rows affected (0.02 sec)
ERROR 1072 (42000): Key column 'list_index' doesn't exist in table
Query OK, 0 rows affected (0.01 sec)
ERROR 1170 (42000): BLOB/TEXT column 'service_type' used in key specification
without a key length
ERROR 1170 (42000): BLOB/TEXT column 'host' used in key specification without a
key length
ERROR 1072 (42000): Key column 'list_index' doesn't exist in table
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1050 (42S01): Table 'SEQUENCE' already exists
ERROR 1062 (23000): Duplicate entry 'SEQ_GEN' for key 1
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.04 sec)
ERROR 1050 (42S01): Table 'SEQUENCE' already exists
ERROR 1062 (23000): Duplicate entry 'SEQ_GEN' for key 1
mysql>
> Refactor MH DB tables
> ---------------------
>
> Key: MH-8335
> URL: http://opencast.jira.com/browse/MH-8335
> Project: Matterhorn Project
> Issue Type: Task
> Components: Architecture & Services
> Affects Versions: 1.3, Trunk
> Reporter: Greg Logan
> Assignee: Greg Logan
> Priority: Critical
> Fix For: 1.3
>
> Attachments: example.sql, MH-8335-withoutIngest.diff
>
>
> We have a pair of proposals which need to be implemented into the database.
> This should be done as part of 1.3, however if they can be slipped back to
> 1.4 if necessary.
> Proposal #1:
> http://opencast.3480289.n2.nabble.com/Database-naming-scheme-proposal-td6857022.html
> Proposal #2:
> http://opencast.3480289.n2.nabble.com/DB-Nighmares-proposal-td6934468.html
--
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]
_______________________________________________
