Details

      Description

      This thread:

      "main" prio=10 tid=0x00007ff164013800 nid=0x148a runnable [0x00007ff16a1f5000]
         java.lang.Thread.State: RUNNABLE
      	at java.net.SocketInputStream.socketRead0(Native Method)
      	at java.net.SocketInputStream.read(SocketInputStream.java:152)
      	at java.net.SocketInputStream.read(SocketInputStream.java:122)
      	at java.io.DataInputStream.readFully(DataInputStream.java:195)
      	at java.io.DataInputStream.readFully(DataInputStream.java:169)
      	at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:846)
      	at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)
      	- locked <0x00000000f74c7338> (a java.util.ArrayList)
      	at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
      	at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
      	at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
      	at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3932)
      	at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1046)
      	- locked <0x00000000f74c9df8> (a net.sourceforge.jtds.jdbc.TdsCore)
      	at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:536)
      	at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
      	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
      	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
      	- locked <0x00000000f74c6e28> (a net.sourceforge.jtds.jdbc.ConnectionJDBC3)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
      	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedPreparedStatementHandler.executeQuery(UpgradeOptimizedPreparedStatementHandler.java:62)
      	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedPreparedStatementHandler.invoke(UpgradeOptimizedPreparedStatementHandler.java:47)
      	at com.sun.proxy.$Proxy317.executeQuery(Unknown Source)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.getCompanyGroupId(UpgradeJournal.java:244)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateAssetEntryClassTypeId(UpgradeJournal.java:368)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:224)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:83)
      	at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:76)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:184)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:152)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:134)
      	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
      	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
      	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:145)
      	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:67)
      

      Has now been running non stop for 8 hours. We have 1848409 AssetEntries. I ran SQL Server Profiler, and see TONS of these:

      update AssetEntry set classTypeId = 226890627 where classPK = 134711462
      update AssetEntry set classTypeId = 226890641 where classPK = 409627

      obviously with different classPks. I haven't yet figured out the pattern to tell how far along this is, but Minhchau says:

      A database query to retrieve the same value over and over again (groupId for a companyId) and we're iterating by article instead of by structure.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 43 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 Beta 7