PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-3586

SocialActivityPersistence throws duplicate key when dates are too close

    Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 5.1.2, 5.2.3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed
    • Liferay Contributor's Agreement:
      Accept
    • Similar Issues:
      Show 5 results 

      Description

      Problem occurs when you save/update a file in document library within 1 sec of the last save. SocialActivityPersistence throws a duplicate key exteption:

      19:10:40,539 ERROR [JDBCExceptionReporter:101] Duplicate entry '10141-10149-2009-06-03 19:10:40-10059-10531-2-0' for key 'IX_8F32DEC9'

        Activity

        Hide
        Alexander Chow added a comment -

        Fix checked in.

        Show
        Alexander Chow added a comment - Fix checked in.
        Hide
        Brian Chan added a comment - - edited

        We should consider swapping createDate to a long. It only breaks because MySQL timestamps don't support ms. The interfaces can stay the same. We just wrap long with a date.

        Show
        Brian Chan added a comment - - edited We should consider swapping createDate to a long. It only breaks because MySQL timestamps don't support ms. The interfaces can stay the same. We just wrap long with a date.

          People

          • Assignee:
            Alexander Chow
            Reporter:
            Alexander Chow
            Recent user:
            Randy Zhu
            Participants of an Issue:
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              6 years, 8 weeks, 5 days ago

              Development

                Structure Helper Panel