Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15862

XWiki 10.9 fails to install on MSSQL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Invalid
    • Affects Version/s: 10.9
    • Fix Version/s: None
    • Component/s: Other
    • Labels:
    • Environment:
      Windows
      MSSQL JDBC 6.4.0
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      In prod we went from 10.8>10.8.1 (After custom fixing that bug) > 10.9. We are now doing our test environment install but are trying to go straight to 10.9 and install fails to create the stats tables due to column length varchar(8192) as 8000 is the limit in MSSQL.

      varchar(max) should be used which the hibernate dialect would map to 8000 and not 8192, I'm not sure what changed between 10.8 and 10.9?

      One of the table creation failures:

      Caused by: org.hibernate.HibernateException: Failed updating schema while executing query [create table xwikistatsreferer (XWR_ID numeric(19,0) not null, XWR_NUMBER int null, XWR_NAME varchar(255) not null, XWR_CLASSNAME varchar(255) null, XWR_REFERER varchar(8192) not null, XWR_PAGE_VIEWS int null, XWR_PERIOD int null, primary key (XWR_ID))]

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The size (8192) given to the column 'XWR_REFERER' exceeds the maximum allowed for any data type (8000).

      Curious if a Oracle fresh install has similar issues as I believe it is 4000 there.

        Attachments

          Activity

            People

            • Assignee:
              vmassol Vincent Massol
              Reporter:
              reighnman Jared O.
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Date of First Response: