アーティクル - CS378836
Windchill PDMLink 12.0.2.7 で TextTailoringEnumDelegateImpl.getCustomTextEntries が使用可能なデータベース接続を使い果たす
修正日: 12-Jan-2023
適用対象
- Windchill PDMLink 12.0.2.7 to 12.1.1.2
説明
- TextTailoringEnumDelegateImpl.getCustomTextEntries が使用可能なデータベース接続を使い果たしています
- 後続の MethodContexts は、JDBCCONNECTIONWAITTIMESECONDS で合計経過時間の 100% を表示します。
- wt.pom.maxDbConnections+wt.pom.dbConnectionsHardLimit を消費するスレッド「wt.fv.FileServersImpl.notifyVaultStatusTimer」(5000 行を超えるスタックを保持) で観察される問題
- ユーザー スレッドでも観察されます。
[email protected]/java.net.SocketInputStream.socketRead0(Native Method) [email protected]/java.net.SocketInputStream.socketRead(SocketInputStream.java:115) [email protected]/java.net.SocketInputStream.read(SocketInputStream.java:168) [email protected]/java.net.SocketInputStream.read(SocketInputStream.java:140) app//com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2023) app//com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6418) app//com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7579) app//com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:866) app//com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768) app//com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) app//com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979) app//com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) app//com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) app//com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:744) app//wt.pds.sqlServer.SQLServerStatementParameterFactory.initializeType(SQLServerStatementParameterFactory.java:90) app//wt.pds.sqlServer.SQLServerStatementParameterFactory.initializeStruct(SQLServerStatementParameterFactory.java:61) app//wt.pds.StatementParameterFactory.initializeTypes(StatementParameterFactory.java:224) app//wt.pds.SQLDatabasePds.initializeConnection(SQLDatabasePds.java:2191) app//wt.pom.WTConnection.connect(WTConnection.java:387) app//wt.pom.WTConnection.<init>(WTConnection.java:319) app//wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:296) app//wt.pom.POMHandler$LazyConnectionSource.getConnection(POMHandler.java:815) app//wt.pom.POMHandler.getConnection(POMHandler.java:234) app//wt.method.MethodContext.getConnection(MethodContext.java:2436) app//wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:304) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1070) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) app//wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) app//wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) jdk.internal.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy30.find(Unknown Source) app//com.ptc.core.lwc.server.cache.db.EnumerationDefinitionDBService.getEnumerationDefinition(EnumerationDefinitionDBService.java:644) app//com.ptc.core.lwc.server.StandardCustomTextModeledEnumService.getEnumPropsMapList(StandardCustomTextModeledEnumService.java:178) jdk.internal.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy26.getEnumPropsMapList(Unknown Source) app//com.ptc.windchill.fc.custom.textResource.TextTailoringEnumDelegateImpl.getCustomTextEntries(TextTailoringEnumDelegateImpl.java:51) app//wt.util.resource.WTListResourceBundle.getContents(WTListResourceBundle.java:322) [email protected]/java.util.ListResourceBundle.loadLookup(ListResourceBundle.java:195) [email protected]/java.util.ListResourceBundle.handleGetObject(ListResourceBundle.java:130) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:555) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getString(ResourceBundle.java:521) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:479) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:412) app//wt.fc.jmx.ConnectionPoolMonitor.buildSQLStatementNotificationInfo(ConnectionPoolMonitor.java:837) app//wt.fc.jmx.ConnectionInfoMBeanImpl.getNotificationInfo(ConnectionInfoMBeanImpl.java:186) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.findNotifications(MBeanIntrospector.java:447) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.getMBeanInfo(MBeanIntrospector.java:393) [email protected]/com.sun.jmx.mbeanserver.MBeanSupport.<init>(MBeanSupport.java:139) [email protected]/com.sun.jmx.mbeanserver.StandardMBeanSupport.<init>(StandardMBeanSupport.java:60) [email protected]/javax.management.StandardMBean.construct(StandardMBean.java:181) [email protected]/javax.management.StandardMBean.<init>(StandardMBean.java:232) app//wt.jmx.core.StandardMBean.<init>(StandardMBean.java:109) app//wt.jmx.core.SelfAwareMBean.<init>(SelfAwareMBean.java:68) app//wt.fc.jmx.ConnectionInfoMBeanImpl.<init>(ConnectionInfoMBeanImpl.java:56) app//wt.fc.jmx.ConnectionPoolMonitor.addConnection(ConnectionPoolMonitor.java:140) app//wt.pom.WTConnection.connect(WTConnection.java:385) app//wt.pom.WTConnection.<init>(WTConnection.java:319) app//wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:296) app//wt.pom.POMHandler$LazyConnectionSource.getConnection(POMHandler.java:815) app//wt.pom.POMHandler.getConnection(POMHandler.java:234) app//wt.method.MethodContext.getConnection(MethodContext.java:2436) app//wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:304) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1070) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) app//wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) app//wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) jdk.internal.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy30.find(Unknown Source) app//com.ptc.core.lwc.server.cache.db.EnumerationDefinitionDBService.getEnumerationDefinition(EnumerationDefinitionDBService.java:644) app//com.ptc.core.lwc.server.StandardCustomTextModeledEnumService.getEnumPropsMapList(StandardCustomTextModeledEnumService.java:178) jdk.internal.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy26.getEnumPropsMapList(Unknown Source) app//com.ptc.windchill.fc.custom.textResource.TextTailoringEnumDelegateImpl.getCustomTextEntries(TextTailoringEnumDelegateImpl.java:51) app//wt.util.resource.WTListResourceBundle.getContents(WTListResourceBundle.java:322) [email protected]/java.util.ListResourceBundle.loadLookup(ListResourceBundle.java:195) [email protected]/java.util.ListResourceBundle.handleGetObject(ListResourceBundle.java:130) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:555) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getString(ResourceBundle.java:521) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:479) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:412) app//wt.fc.jmx.ConnectionPoolMonitor.buildSQLStatementNotificationInfo(ConnectionPoolMonitor.java:837) app//wt.fc.jmx.ConnectionInfoMBeanImpl.getNotificationInfo(ConnectionInfoMBeanImpl.java:186) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.findNotifications(MBeanIntrospector.java:447) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.getMBeanInfo(MBeanIntrospector.java:393) [email protected]/com.sun.jmx.mbeanserver.MBeanSupport.<init>(MBeanSupport.java:139) [email protected]/com.sun.jmx.mbeanserver.StandardMBeanSupport.<init>(StandardMBeanSupport.java:60) [email protected]/javax.management.StandardMBean.construct(StandardMBean.java:181) [email protected]/javax.management.StandardMBean.<init>(StandardMBean.java:232) app//wt.jmx.core.StandardMBean.<init>(StandardMBean.java:109) app//wt.jmx.core.SelfAwareMBean.<init>(SelfAwareMBean.java:68) app//wt.fc.jmx.ConnectionInfoMBeanImpl.<init>(ConnectionInfoMBeanImpl.java:56) app//wt.fc.jmx.ConnectionPoolMonitor.addConnection(ConnectionPoolMonitor.java:140) app//wt.pom.WTConnection.connect(WTConnection.java:385) app//wt.pom.WTConnection.<init>(WTConnection.java:319) app//wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:296) app//wt.pom.POMHandler$LazyConnectionSource.getConnection(POMHandler.java:815) app//wt.pom.POMHandler.getConnection(POMHandler.java:234) app//wt.method.MethodContext.getConnection(MethodContext.java:2436) app//wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:304) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1070) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) app//wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) app//wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) jdk.internal.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy30.find(Unknown Source) app//com.ptc.core.lwc.server.cache.db.EnumerationDefinitionDBService.getEnumerationDefinition(EnumerationDefinitionDBService.java:644) app//com.ptc.core.lwc.server.StandardCustomTextModeledEnumService.getEnumPropsMapList(StandardCustomTextModeledEnumService.java:178) jdk.internal.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy26.getEnumPropsMapList(Unknown Source) app//com.ptc.windchill.fc.custom.textResource.TextTailoringEnumDelegateImpl.getCustomTextEntries(TextTailoringEnumDelegateImpl.java:51) app//wt.util.resource.WTListResourceBundle.getContents(WTListResourceBundle.java:322) [email protected]/java.util.ListResourceBundle.loadLookup(ListResourceBundle.java:195) [email protected]/java.util.ListResourceBundle.handleGetObject(ListResourceBundle.java:130) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:555) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getString(ResourceBundle.java:521) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:479) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:412) app//wt.fc.jmx.ConnectionPoolMonitor.buildSQLStatementNotificationInfo(ConnectionPoolMonitor.java:837) app//wt.fc.jmx.ConnectionInfoMBeanImpl.getNotificationInfo(ConnectionInfoMBeanImpl.java:186) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.findNotifications(MBeanIntrospector.java:447) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.getMBeanInfo(MBeanIntrospector.java:393) [email protected]/com.sun.jmx.mbeanserver.MBeanSupport.<init>(MBeanSupport.java:139) [email protected]/com.sun.jmx.mbeanserver.StandardMBeanSupport.<init>(StandardMBeanSupport.java:60) [email protected]/javax.management.StandardMBean.construct(StandardMBean.java:181) [email protected]/javax.management.StandardMBean.<init>(StandardMBean.java:232) app//wt.jmx.core.StandardMBean.<init>(StandardMBean.java:109) app//wt.jmx.core.SelfAwareMBean.<init>(SelfAwareMBean.java:68) app//wt.fc.jmx.ConnectionInfoMBeanImpl.<init>(ConnectionInfoMBeanImpl.java:56) app//wt.fc.jmx.ConnectionPoolMonitor.addConnection(ConnectionPoolMonitor.java:140) app//wt.pom.WTConnection.connect(WTConnection.java:385) app//wt.pom.WTConnection.<init>(WTConnection.java:319) app//wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:296) app//wt.pom.POMHandler$LazyConnectionSource.getConnection(POMHandler.java:815) app//wt.pom.POMHandler.getConnection(POMHandler.java:234) app//wt.method.MethodContext.getConnection(MethodContext.java:2436) app//wt.pom.PersistentObjectManager.getUserConnection(PersistentObjectManager.java:304) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1070) app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986) app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972) app//wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) app//wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655) jdk.internal.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy30.find(Unknown Source) app//com.ptc.core.lwc.server.cache.db.EnumerationDefinitionDBService.getEnumerationDefinition(EnumerationDefinitionDBService.java:644) app//com.ptc.core.lwc.server.StandardCustomTextModeledEnumService.getEnumPropsMapList(StandardCustomTextModeledEnumService.java:178) jdk.internal.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [email protected]/java.lang.reflect.Method.invoke(Method.java:566) app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) app//com.sun.proxy.$Proxy26.getEnumPropsMapList(Unknown Source) app//com.ptc.windchill.fc.custom.textResource.TextTailoringEnumDelegateImpl.getCustomTextEntries(TextTailoringEnumDelegateImpl.java:51) app//wt.util.resource.WTListResourceBundle.getContents(WTListResourceBundle.java:322) [email protected]/java.util.ListResourceBundle.loadLookup(ListResourceBundle.java:195) [email protected]/java.util.ListResourceBundle.handleGetObject(ListResourceBundle.java:130) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:555) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getObject(ResourceBundle.java:558) [email protected]/java.util.ResourceBundle.getString(ResourceBundle.java:521) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:479) app//wt.util.WTMessage.getLocalizedMessage(WTMessage.java:412) app//wt.fc.jmx.ConnectionPoolMonitor.buildSQLStatementNotificationInfo(ConnectionPoolMonitor.java:837) app//wt.fc.jmx.ConnectionInfoMBeanImpl.getNotificationInfo(ConnectionInfoMBeanImpl.java:186) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.findNotifications(MBeanIntrospector.java:447) [email protected]/com.sun.jmx.mbeanserver.MBeanIntrospector.getMBeanInfo(MBeanIntrospector.java:393) [email protected]/com.sun.jmx.mbeanserver.MBeanSupport.<init>(MBeanSupport.java:139) [email protected]/com.sun.jmx.mbeanserver.StandardMBeanSupport.<init>(StandardMBeanSupport.java:60) [email protected]/javax.management.StandardMBean.construct(StandardMBean.java:181) [email protected]/javax.management.StandardMBean.<init>(StandardMBean.java:232) app//wt.jmx.core.StandardMBean.<init>(StandardMBean.java:109) app//wt.jmx.core.SelfAwareMBean.<init>(SelfAwareMBean.java:68) app//wt.fc.jmx.ConnectionInfoMBeanImpl.<init>(ConnectionInfoMBeanImpl.java:56) app//wt.fc.jmx.ConnectionPoolMonitor.addConnection(ConnectionPoolMonitor.java:140) app//wt.pom.WTConnection.connect(WTConnection.java:385) app//wt.pom.WTConnection.<init>(WTConnection.java:319) app//wt.pom.PersistentObjectManager.connect(PersistentObjectManager.java:296) app//wt.pom.POMHandler$LazyConnectionSource.getConnection(POMHandler.java:815) app//wt.pom.POMHandler.getConnection(POMHandler.java:234) ... (truncated due to UI limitations)
最新バージョンはこちらを参照ください CS378836