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

File uploaded into document and media using Liferay's remote api takes long time

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.2.10 EE GA1, 6.2.X EE
    • Fix Version/s: 6.2.X EE
    • Component/s: DM
    • Labels:
      None

      Description

      Steps to reproduce

      1) Create a folder Test, look up its ID in the DB.
      2) Execute the following query in order to lock that row in the DB which represents folder Test.

      -- The first statement is for MySQL only
      START TRANSACTION;
      -- Lock that row
      SELECT * FROM DLFolder WHERE folderId = <ID> FOR UPDATE;
      

      3) Upload a document to folder Test.

      Checkpoint: You should see that the document has been uploaded instantly to that folder, which means that even though the corresponding row of folder Test is locked in the DB, updating its last post date isn't happening right at that time when you upload something to it; instead it takes place in the background.

      4) Take a thread dump and you'll see that one thread is hanging, because it isn't able to update that row, because you placed an explicit lock on it.

      This is the same issue as LPS-43399 however the fix cannot be backported to 6.2.x hence we have to create a fix for this branch individually.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.chan Brian Chan
                Reporter:
                istvan.dezsi Istvan Dezsi
                Participants of an Issue:
                Recent user:
                Brian Wulbern
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  6.2.X EE