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

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Story Points:
      3
    • Similar Issues:
      Show 3 results 

      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.

        Issue Links

          Activity

          Hide
          Pani Gui (Inactive) added a comment -

          PASSED Manual Testing following the steps in the description.

          Reproduced on:
          Tomcat 7.0 + SQL Server 2008. Portal 6.1.20 EE GA2.

          Long messages are not delivered through chat on SQL Server.

          Fixed on:
          Tomcat 7.0 + SQL Server 2008. Portal 6.1.x EE GIT ID: e7fac432761d0c2af926c3a08033f7638d6f7acd.
          Plugins 6.1.x EE GIT ID: bb9534cec135ee5707c5263a83c3902a74281060.
          Tomcat 7.0 + SQL Server 2008. Portal 6.2.x GIT ID: e420a07ce6d401515be9dea864e4dea53fb99f10.
          Plugins 6.2.x EE GIT ID: ef6b23a8d44d8acecc5f0c51eed1bb60c260db6c.

          Long messages are sent properly through chat.

          Show
          Pani Gui (Inactive) added a comment - PASSED Manual Testing following the steps in the description. Reproduced on: Tomcat 7.0 + SQL Server 2008. Portal 6.1.20 EE GA2. Long messages are not delivered through chat on SQL Server. Fixed on: Tomcat 7.0 + SQL Server 2008. Portal 6.1.x EE GIT ID: e7fac432761d0c2af926c3a08033f7638d6f7acd. Plugins 6.1.x EE GIT ID: bb9534cec135ee5707c5263a83c3902a74281060. Tomcat 7.0 + SQL Server 2008. Portal 6.2.x GIT ID: e420a07ce6d401515be9dea864e4dea53fb99f10. Plugins 6.2.x EE GIT ID: ef6b23a8d44d8acecc5f0c51eed1bb60c260db6c. Long messages are sent properly through chat.

            People

            • Assignee:
              Pani Gui (Inactive)
              Reporter:
              Gabor Pusoma (Inactive)
              Recent user:
              Tibor Lipusz
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 16 weeks, 4 days ago

                Development

                  Structure Helper Panel