???????????????μ?????
???????????? ???????[ 2012/10/22 10:35:17 ] ????????
?????????????????OA?????????????????????????????????????????????????????????????503????????????????
???????????????JBOSS?????????SQL Server 2005 64λ????檔
????????????????????????????JBOSS????????????????????????????JBOSS??????????
ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract xxxx xxx()?? causedBy:
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
at com.adobe.pof.ConnectionWrapper.getConnection(ConnectionWrapper.java:25)
at com.adobe.pof.ConnectionWrapper.getMetaData(ConnectionWrapper.java:101)
at com.adobe.pof.POFBean.getAdapter(POFBean.java:120)
at com.adobe.pof.omapi.POFObjectManagerRemoteBean.getObjectManagerImpl(POFObjectManagerRemoteBean.java:108)
at com.adobe.pof.omapi.POFObjectManagerRemoteBean.getEnvironment(POFObjectManagerRemoteBean.java:489)
at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
????????????????????????????????????????????????30????????Session???????????????503???????????????????????????????????????????????????????????????????????????????????ó?????????
???????????????????????????????????????????????????????T-SQL????????Щ????????
?????????????????????????????????????????????????????????????????????????????session????????
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT COUNT(*)??request_session_id FROM
(
SELECT DB_NAME(resource_database_id) AS DatabaseName
?? request_session_id
?? resource_type
?? CASE
WHEN resource_type = 'OBJECT'
THEN OBJECT_NAME(resource_associated_entity_id)
WHEN resource_type IN ('KEY'?? 'PAGE'?? 'RID')
THEN (SELECT OBJECT_NAME(OBJECT_ID)
FROM sys.partitions p
WHERE p.hobt_id = l.resource_associated_entity_id)
END AS resource_type_name
?? request_status
?? request_mode
FROM sys.dm_tran_locks l
) AS a
GROUP BY a.request_session_id
????????session id?150????????????4000+???????????sys.dm_tran_locks ????????????????Щ??????key????S??????????Page??????IS??????30??????????????Щ?????????????
??????????????????
????1?????????????????????????????????????????????????????????????????
????2?????4000+??????????????
?????????????????????Profiler?????Session ID????????????????????????????????T-SQL????????????????Select????????巵??????????????δ???????????????д?????????1900?????????????????????????е???????????????????????????????????????????????????????????????????????50????
????4000+?????????????????????????????????????
????????????????????????????????????????????????????????????????????????в??????????????????????????assignment???д???????????????????????????????????????????????
???????kill??Session 150???Drop????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11