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

DXP upgrade - DLServiceVerifyProcess#updateFileEntryAssets process fails due to a database query timeout

    Details

      Description

      6.2 to 7.0 de-12 upgrade - DLServiceVerifyProcess#updateFileEntryAssets process fails due to a database query timeout.

      19:04:26,128 INFO  [localhost-startStop-1][LoggingTimer:70] Starting com.liferay.document.library.verify.DLServiceVerifyProcess#updateFileEntryAssets
      INFO - Starting com.liferay.document.library.verify.DLServiceVerifyProcess#updateFileEntryAssets
      21:04:26,197 WARN  [localhost-startStop-1][ProxyConnection:155] HikariPool-2 - Connection com.mysql.jdbc.JDBC4Connection@2d4e319f marked as broken because of SQLSTATE(08S01), ErrorCode(0)
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 7,200,041 milliseconds ago.  The last packet sent successfully to the server was 7,200,040 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              patricia.perez Patricia Perez
              Reporter:
              istvan.dezsi Istvan Dezsi
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 34 weeks, 2 days ago

                  Packages

                  Version Package
                  Master