大きいファイルをファイル管理にアップロードした時などに何も動作しなくなり、Tomcatの再起動が必要になることがあります。ユーザー数が増える可能性があるのですが、その場合にはこの現象が頻発する可能性があるのでしょうか?また、その場合には設定を変更するなどして対策はできるのでしょうか?よろしくお願いいたします。
システム情報 Version 4.0.1 (4.0.1) ・OS Linux i386 2.6.18-8.el5PAE ・J2EEコンテナ Apache Tomcat/6.0.35 ・Java 1.6.0_24 Sun Microsystems Inc. ・メモリ使用 899,121KB (96.5%) ・メモリ最大 932,096KB ・現在の空きディスク容量 94658MBTomcat単体での動作 動作するログのエラー出力 あり
2012-01-17 14:04:24,693 FATAL jp.co.sjts.util.jdbc.JDBCUtil:466 - コネクションの取得に失敗(3回目)org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (データベースが使用中です: "Locked by another process". 可能な解決策: 他の接続を全て閉じる; サーバモードを使うDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-159]) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at jp.co.sjts.util.jdbc.JDBCUtil.getConnection(JDBCUtil.java:458) at jp.co.sjts.util.jdbc.JDBCUtil.getConnection(JDBCUtil.java:401) at jp.groupsession.v2.cmn.GroupSession.getConnection(GroupSession.java:609) at jp.groupsession.v2.cmn.GroupSession.destroy(GroupSession.java:560) at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1436) at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1784) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4872) at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:936) at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1359) at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1330) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:326) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1098) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1110) at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) at org.apache.catalina.core.StandardService.stop(StandardService.java:604)
at org.apache.catalina.core.StandardServer.stop(StandardServer.java:788) at org.apache.catalina.startup.Catalina.stop(Catalina.java:662) at org.apache.catalina.startup.Catalina.start(Catalina.java:629) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: org.h2.jdbc.JdbcSQLException: データベースが使用中です: "Locked by another process". 可能な解決策: 他の接続を全て閉じる; サーバモードを使うDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-159] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:441) at org.h2.store.FileLock.lockFile(FileLock.java:338) at org.h2.store.FileLock.lock(FileLock.java:134) at org.h2.engine.Database.open(Database.java:541) at org.h2.engine.Database.openDatabase(Database.java:220) at org.h2.engine.Database.<init>(Database.java:215) at org.h2.engine.Engine.openSession(Engine.java:56) at org.h2.engine.Engine.openSession(Engine.java:159) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) at org.h2.engine.Engine.createSession(Engine.java:121) at org.h2.engine.Engine.createSession(Engine.java:28) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:285) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 27 more2012-01-17 14:04:24,695 ERROR jp.groupsession.v2.cmn.GroupSession:571 - 終了処理に失敗org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (データベースが使用中です: "Locked by another process". 可能な解決策: 他の接続を全て閉じる; サーバモードを使うDatabase may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-159]) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at jp.co.sjts.util.jdbc.JDBCUtil.getConnection(JDBCUtil.java:458) at jp.co.sjts.util.jdbc.JDBCUtil.getConnection(JDBCUtil.java:401) at jp.groupsession.v2.cmn.GroupSession.getConnection(GroupSession.java:609) at jp.groupsession.v2.cmn.GroupSession.destroy(GroupSession.java:560) at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1436) at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1784) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4872) at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:936) at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1359) at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1330)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:326) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1098) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1110) at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) at org.apache.catalina.core.StandardService.stop(StandardService.java:604) at org.apache.catalina.core.StandardServer.stop(StandardServer.java:788) at org.apache.catalina.startup.Catalina.stop(Catalina.java:662) at org.apache.catalina.startup.Catalina.start(Catalina.java:629) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
vertical_align_top