Windchill PDMLink 中发出了大量 WfProcess 和 WfSynchRobot 数据库查询

• 发出了大量WfProcess和WfSynchRobot数据库查询
• ScheduleQueue 被阻塞，许多条目占用很长时间
• 通过检查性能表可以发现，很多进程被下面的sql语句阻塞了：

 SELECT idA2A2 FROM WfSynchRobot WHERE idA2A2=? FOR UPDATE

• 这些数据库查询在所有从属节点和主节点上的许多事务中发出
• 示例 SQL 和堆栈跟踪如下

O-count=804:SELECT 'wt.workflow.robots.WfSynchRobot',A0.adSQEN,A0.idA3containerReference, ..... FROM WfSynchRobot A0 WHERE ((A0.idA2A2 = ?)):cost=954
                 O-count=804:wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:687):cost=954
                   O-count=804:wt.pom.PersistentObjectManager.refresh(PersistentObjectManager.java:1542):cost=954
                     O-count=804:wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1315):cost=954
                       O-count=804:wt.fc.StandardPersistenceManager.restore(StandardPersistenceManager.java:1768):cost=954
                         O-count=804:wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:1010):cost=954
                           O-count=804:wt.fc.StandardPersistenceManager.refresh(StandardPersistenceManager.java:537):cost=954
                             O-count=804:sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source):cost=954
                               O-count=804:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25):cost=954
                                 O-count=804:java.lang.reflect.Method.invoke(Method.java:597):cost=954
                                   O-count=804:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):cost=954
                                     O-count=804:$Proxy8.refresh(Unknown Source):cost=954
                                       O-count=804:wt.workflow.engine.StandardWfEngineService.synchRobotToEvent(StandardWfEngineService.java:9047):cost=954
                                         O-count=804:wt.workflow.engine.StandardWfEngineService$SynchEventListener.notifyVetoableEvent(StandardWfEngineService.java:433):cost=954
                                           O-count=804:wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:320):cost=954
                                             O-count=537:wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:245):cost=672
                                             |  O-count=537:wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:288):cost=672
                                             |    O-count=537:wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent(StandardKeyedEventDispatcher.java:231):cost=672
                                             |      O-count=537:wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:408):cost=672
                                             |        O-count=537:wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent(StandardManagerService.java:313):cost=672
                                             |          O-count=537:wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2806):cost=672
                                             |            O-count=537:wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2789):cost=672
                                             |              O-count=537:wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:734):cost=672
                                             |                O-count=537:wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1018):cost=672
                                             |                  O-count=448:sun.reflect.GeneratedMethodAccessor1926.invoke(Unknown Source):cost=565
                                             |                  |  O-count=448:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25):cost=565
                                             |                  |    O-count=448:java.lang.reflect.Method.invoke(Method.java:597):cost=565
                                             |                  |      O-count=448:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):cost=565
                                             |                  |        O-count=448:$Proxy8.store(Unknown Source):cost=565
                                             |                  |          O-count=270:wt.team.StandardTeamService.createTeams(StandardTeamService.java:936):cost=251
                                             |                  |          O-count=89:wt.fv.uploadtocache.StandardUploadToCacheService.createFvItems(StandardUploadToCacheService.java:736):cost=141
                                             |                  |          O-count=89:wt.team.StandardTeamService.createTeams(StandardTeamService.java:935):cost=173
                                             |                  O-count=89:wt.fc.StandardPersistenceManager.save(StandardPersistenceManager.java:948):cost=107
                                             |                    O-count=89:sun.reflect.GeneratedMethodAccessor1339.invoke(Unknown Source):cost=107
                                             |                      O-count=89:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25):cost=107
                                             |                        O-count=89:java.lang.reflect.Method.invoke(Method.java:597):cost=107
                                             |                          O-count=89:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):cost=107
                                             |                            O-count=89:$Proxy8.save(Unknown Source):cost=107
                                             |                              O-count=89:wt.recent.StandardRecentlyVisitedService.addMCToDBList(StandardRecentlyVisitedService.java:1673):cost=107
                                             |                                O-count=89:wt.recent.StandardRecentlyVisitedService.addToRecentDBLists(StandardRecentlyVisitedService.java:1548):cost=107
                                             |                                  O-count=89:wt.recent.StandardRecentlyVisitedService.access$1200(StandardRecentlyVisitedService.java:161):cost=107
                                             O-count=267:wt.events.StandardKeyedEventBranch.dispatchVetoableEvent(StandardKeyedEventBranch.java:229):cost=282
                                               O-count=267:wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:286):cost=282
                                                 O-count=267:wt.events.StandardKeyedEventDispatcher.dispatchVetoableEvent(StandardKeyedEventDispatcher.java:215):cost=282
                                                   O-count=267:wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:406):cost=282
                                                     O-count=267:wt.services.StandardManagerService.dispatchVetoableEvent(StandardManagerService.java:302):cost=282
                                                       O-count=267:wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2802):cost=282
                                                         O-count=267:wt.fc.StandardPersistenceManager.dispatchVetoableEvent(StandardPersistenceManager.java:2782):cost=282
                                                           O-count=267:wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1339):cost=282
                                                             O-count=267:wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:554):cost=282
                                                               O-count=178:sun.reflect.GeneratedMethodAccessor1390.invoke(Unknown Source):cost=156
                                                               |  O-count=178:sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25):cost=156
                                                               |    O-count=178:java.lang.reflect.Method.invoke(Method.java:597):cost=156
                                                               |      O-count=178:wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399):cost=156
                                                               |        O-count=178:$Proxy8.store(Unknown Source):cost=156
                                                               |          O-count=178:com.ptc.core.htmlcomp.collection.engine.CollectorCacheServerHelper.createCollectorCache(CollectorCacheServerHelper.java:323):cost=156
                                                               |            O-count=178:com.ptc.core.htmlcomp.collection.engine.StandardUICollecti