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

        Alexander Chow created issue -
        Hide
        Alexander Chow added a comment -

        Fix checked in.

        Show
        Alexander Chow added a comment - Fix checked in.
        Alexander Chow made changes -
        Field Original Value New Value
        Status Open [ 1 ] Committed to Subversion [ 10000 ]
        Liferay Contributor's Agreement [Accept]
        Assignee SE Support [ support-lep@liferay.com ] Alexander Chow [ caorongjin ]
        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.
        Brian Chan made changes -
        Affects Version/s 5.1.2 [ 10346 ]
        Affects Version/s 5.2.3 [ 10367 ]
        Backport Version/s [5.1.x, 5.2.x]
        Backport Committed [Committed]
        Brian Chan made changes -
        Status Committed to Subversion [ 10000 ] Pending Backport to EE [ 10003 ]
        Resolution Fixed [ 1 ]
        Samuel Kong made changes -
        Link This issue relates LPE-1015 [ LPE-1015 ]
        Samuel Kong made changes -
        Status Pending Backport to EE [ 10003 ] Closed [ 6 ]
        Michael Han made changes -
        Workflow Liferay Workflow - version 1.8 [ 175326 ] Greenhopper [ 195060 ]
        Michael Han made changes -
        Workflow Greenhopper [ 195060 ] Liferay Workflow 2.2 [ 208998 ]
        Vicki Tsang made changes -
        Workflow Liferay Workflow 2.2 [ 208998 ] LPS Workflow [ 268841 ]
        Andrew Kim made changes -
        Workflow LPS Workflow [ 268841 ] Copy of LPS Workflow [ 411437 ]
        Andrew Kim made changes -
        Workflow Copy of LPS Workflow [ 411437 ] LPS Workflow [ 443057 ]
        Andrew Kim made changes -
        Workflow LPS Workflow [ 443057 ] Copy 2 of LPS Workflow [ 475406 ]
        Andrew Kim made changes -
        Workflow Copy 2 of LPS Workflow [ 475406 ] LPS Workflow [ 507304 ]
        Randy Zhu made changes -
        Workflow LPS Workflow [ 507304 ] PUBLIC - LPS Generic Workflow [ 559074 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS Generic Workflow [ 559074 ] Copy of PUBLIC - LPS Generic Workflow [ 593414 ]
        Randy Zhu made changes -
        Workflow Copy of PUBLIC - LPS Generic Workflow [ 593414 ] PUBLIC - LPS Generic Workflow [ 625343 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS Generic Workflow [ 625343 ] PUBLIC - LPS General Workflow [ 719323 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS General Workflow [ 719323 ] PUBLIC - LPS Bugs Workflow [ 817783 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Committed to SCM Committed to SCM
        31m 26s 1 Alexander Chow 03/Jun/09 12:55 PM
        Committed to SCM Committed to SCM Removed Status Removed Status
        1d 23h 24m 1 Brian Chan 05/Jun/09 12:20 PM
        Removed Status Removed Status Closed Closed
        3d 4h 38m 1 Samuel Kong 08/Jun/09 4:58 PM

          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, 5 weeks, 2 days ago

              Development

                Structure Helper Panel