Uploaded image for project: 'Opencast'
  1. Opencast
  2. MH-11889

Row size too large

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 2.3.0
    • Fix versions: 2.3.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Non Functioning
    • Steps to reproduce:
      Hide
      2016-11-18 21:49:22,779 | WARN | (JavaLog:289) -
      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check
      the manual. You have to change some columns to TEXT or BLOBs
      Error Code: 1118
      Call: CREATE TABLE mh_organization_property (organization VARCHAR(128), value VARCHAR(65535), name VARCHAR(255))
      Query: DataModifyQuery(sql="CREATE TABLE mh_organization_property (organization VARCHAR(128), value VARCHAR(65535), name VARCHAR(255))")
              at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
      Show
      2016-11-18 21:49:22,779 | WARN | (JavaLog:289) - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs Error Code: 1118 Call: CREATE TABLE mh_organization_property (organization VARCHAR(128), value VARCHAR(65535), name VARCHAR(255)) Query: DataModifyQuery(sql="CREATE TABLE mh_organization_property (organization VARCHAR(128), value VARCHAR(65535), name VARCHAR(255))")         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              lkiesow Lars Kiesow
              Reporter:
              lkiesow Lars Kiesow
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                TestRail: Cases