Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-33975

Long chat messages not delivered due to SQLServer's indexing mechanism

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 6.0.6 GA, 6.0.12 EE, 6.1.1 CE GA2, 6.1.20 EE GA2
    • Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M5
    • Component/s: Chat, Collaboration
    • Labels:
    • Environment:
      SQL Server 2008 R2
    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Story Points:
      3

      Description

      Steps to reproduce:

      Open 2 browsers, with 2 persons logged in (test1 and test2)
      Send the message "some very large comment" from test1 to test2: OK
      Send the message "some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment some very large comment"
      -from test1 to test2: NOT OK, the message never arrives.
      In the server log we have:
      java.sql.BatchUpdateException: Operation failed. The index entry of length 926 bytes for the index 'IX_2A17A23F' exceeds the maximum length
      of 900 bytes.

      The reason of this error is this:
      http://msdn.microsoft.com/en-us/library/ms191241(v=sql.105).aspx

      We have IX_2A17A23F on Chat_Entry (fromUserId, toUserId, content). The issue occurs when we insert a string with more than 442 characters in the content field.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pani.gui Pani Gui (Inactive)
                Reporter:
                gabor.pusoma Gabor Pusoma (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  4 years, 20 weeks ago