Форум DL

My Profile

По пятницам 5 контрольных подряд - с 10.00 до 19.05
Сегодня это уже ВТОРОЕ такое сообщение об ошибке.
Первый раз пришлось перезапускать все службы DL. А затем останавливать перестроение таблиц.

500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Can't open connection
with full database pool (35)
at dl2.db.DBUtil.getConnection(DBUtil.java:175)
at dl2.db.DBUtil.<init>(DBUtil.java:85)
at dl2.db.DBUtil.getInstance(DBUtil.java:102)
at dl2.users.UserGroup.setPermissions(UserGroup.java:262)
at dl2.users.UserGroup.load(UserGroup.java:336)
at dl2.users.UserGroup.load(UserGroup.java:312)
at dl2.users.UserGroup.<init>(UserGroup.java:89)
at _restable__jsp._jspService(C:\Data\dl2\dl2\dl2-web\restable.jsp:136)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:135)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Can't open connection with full database
pool (35)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1340)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1198)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
at dl2.db.DBUtil.getConnection(DBUtil.java:157)
... 20 more

--------------------------------------------------------------------------------
Resin 2.1.7 (built Fri Feb 14 12:48:13 PST 2003)

My Profile

500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Can't open connection
with full database pool (50)
at dl2.db.DBUtil.getConnection(DBUtil.java:175)
at dl2.db.DBUtil.<init>(DBUtil.java:85)
at dl2.db.DBUtil.getInstance(DBUtil.java:102)
at dl2.users.User.CheckAdminFieldLoaded(User.java:137)
at dl2.users.User.isAdmin(User.java:35)
at dl2.Course.secureWhereClauseEditor(Course.java:576)
at dl2.Course.secureWhereClause(Course.java:552)
at dl2.Course.load(Course.java:527)
at dl2.Course.<init>(Course.java:263)
at _tasks._taskchoi__jsp._jspService(/tasks/taskchoi.jsp:18)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:149)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Can't open connection with full database
pool (50)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1340)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1198)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
at dl2.db.DBUtil.getConnection(DBUtil.java:157)
... 22 more

--------------------------------------------------------------------------------
Resin 2.1.7 (built Fri Feb 14 12:48:13 PST 2003)

My Profile

Вот еще раз
Причем предыстория такова
- были дикие тормоза, хотя Procexp показывала, что процессор загружен на 10%
У меня заняти - я перегрузил NewIT

Теперь опять тормоза, но procexp показывает 100% и большую часть этих процентов берет SQL-сервер

500 Servlet Exception
java.lang.RuntimeException: java.sql.SQLException: Can't open connection
with full database pool (35)
at dl2.db.DBUtil.getConnection(DBUtil.java:175)
at dl2.db.DBUtil.<init>(DBUtil.java:85)
at dl2.db.DBUtil.getInstance(DBUtil.java:102)
at dl2.users.User.CheckAdminFieldLoaded(User.java:137)
at dl2.users.User.isAdmin(User.java:35)
at dl2.Course.secureWhereClauseEditor(Course.java:576)
at dl2.Course.secureWhereClause(Course.java:552)
at dl2.Course.load(Course.java:527)
at dl2.Course.<init>(Course.java:263)
at dl2.task.Node.spGetTaskNodePermissions(Node.java:680)
at _taskview__jsp._jspService(C:\Data\dl2\dl2\dl2-web\taskview.jsp:25)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at dl2.webfilter.TimeLoad.doFilter(TimeLoad.java:55)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at dl2.webfilter.CheckerBan.doFilter(CheckerBan.java:149)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Can't open connection with full database
pool (35)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1340)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1198)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
at dl2.db.DBUtil.getConnection(DBUtil.java:157)
... 23 more