Hi there,
i want to use H2 as my default database (just for testing, because i want to build a portlet which should use h2 for later purposes).
I edited the DBUtil.java to import the hibernate H2Dialect (http://issues.liferay.com/browse/LPS-4313) - this was missing and build everything with ant -f build.xml all
works very good, everything compiles and ... i thought thats it but when i start the tomcat now i get the following message:
1
2Using CATALINA_BASE: /home/oli/tomcat6
3Using CATALINA_HOME: /home/oli/tomcat6
4Using CATALINA_TMPDIR: /home/oli/tomcat6/temp
5Using JAVA_OPTS: -Dhttp.nonProxyHosts=localhost|127.0.0.1|lucymobil -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms1024m -Xmx1024m -XX:MaxPermSize=256m -Dfile.encoding=UTF8 -Duser.timezone=GMT -Djava.security.auth.login.config=/home/oli/tomcat6/conf/jaas.config
6Using JRE_HOME: /usr/lib/jvm/java-6-sun
7Listening for transport dt_socket at address: 11550
821.08.2009 14:51:45 org.apache.catalina.core.AprLifecycleListener init
9INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/amd64/server:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/amd64:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/amd64:/usr/java/packages/lib/amd64:/lib:/usr/lib
1021.08.2009 14:51:45 org.apache.coyote.http11.Http11Protocol init
11INFO: Initializing Coyote HTTP/1.1 on http-8080
1221.08.2009 14:51:45 org.apache.catalina.startup.Catalina load
13INFO: Initialization processed in 1179 ms
1421.08.2009 14:51:45 org.apache.catalina.core.StandardService start
15INFO: Starting service Catalina
1621.08.2009 14:51:45 org.apache.catalina.core.StandardEngine start
17INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
1821.08.2009 14:51:45 org.apache.catalina.realm.JAASRealm setUseContextClassLoader
19INFO: Setting useContextClassLoader = false
20Loading jar:file:/home/oli/tomcat6/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
21Loading jar:file:/home/oli/tomcat6/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
22Loading file:/home/oli/tomcat6/webapps/ROOT/WEB-INF/classes/portal-ext.properties
2314:53:08,990 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@12452209 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
24org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
25IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
26 at org.h2.message.Message.getSQLException(Message.java:105)
27 at org.h2.message.Message.convertIOException(Message.java:292)
28 at org.h2.store.FileStore.<init>(FileStore.java:90)
29 at org.h2.store.FileStore.open(FileStore.java:135)
30 at org.h2.store.FileStore.open(FileStore.java:117)
31 at org.h2.engine.Database.openFile(Database.java:480)
32 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
33 at org.h2.engine.Database.openFileData(Database.java:505)
34 at org.h2.engine.Database.open(Database.java:592)
35 at org.h2.engine.Database.openDatabase(Database.java:220)
36 at org.h2.engine.Database.<init>(Database.java:215)
37 at org.h2.engine.Engine.openSession(Engine.java:58)
38 at org.h2.engine.Engine.openSession(Engine.java:140)
39 at org.h2.engine.Engine.getSession(Engine.java:120)
40 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
41 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
42 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
43 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
44 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
45 at org.h2.Driver.connect(Driver.java:58)
46 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
47 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
48 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
49 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
50 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
51 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
52 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
53 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
54Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
55 at java.io.RandomAccessFile.open(Native Method)
56 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
57 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
58 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
59 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
60 at org.h2.store.FileStore.<init>(FileStore.java:84)
61 ... 25 more
6214:53:16,693 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2c028bbe -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
63org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
64IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
65 at org.h2.message.Message.getSQLException(Message.java:105)
66 at org.h2.message.Message.convertIOException(Message.java:292)
67 at org.h2.store.FileStore.<init>(FileStore.java:90)
68 at org.h2.store.FileStore.open(FileStore.java:135)
69 at org.h2.store.FileStore.open(FileStore.java:117)
70 at org.h2.engine.Database.openFile(Database.java:480)
71 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
72 at org.h2.engine.Database.openFileData(Database.java:505)
73 at org.h2.engine.Database.open(Database.java:592)
74 at org.h2.engine.Database.openDatabase(Database.java:220)
75 at org.h2.engine.Database.<init>(Database.java:215)
76 at org.h2.engine.Engine.openSession(Engine.java:58)
77 at org.h2.engine.Engine.openSession(Engine.java:140)
78 at org.h2.engine.Engine.getSession(Engine.java:120)
79 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
80 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
81 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
82 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
83 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
84 at org.h2.Driver.connect(Driver.java:58)
85 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
86 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
87 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
88 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
89 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
90 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
91 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
92 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
93Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
94 at java.io.RandomAccessFile.open(Native Method)
95 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
96 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
97 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
98 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
99 at org.h2.store.FileStore.<init>(FileStore.java:84)
100 ... 25 more
10114:53:36,162 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@79e4f9af -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
102org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
103IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
104 at org.h2.message.Message.getSQLException(Message.java:105)
105 at org.h2.message.Message.convertIOException(Message.java:292)
106 at org.h2.store.FileStore.<init>(FileStore.java:90)
107 at org.h2.store.FileStore.open(FileStore.java:135)
108 at org.h2.store.FileStore.open(FileStore.java:117)
109 at org.h2.engine.Database.openFile(Database.java:480)
110 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
111 at org.h2.engine.Database.openFileData(Database.java:505)
112 at org.h2.engine.Database.open(Database.java:592)
113 at org.h2.engine.Database.openDatabase(Database.java:220)
114 at org.h2.engine.Database.<init>(Database.java:215)
115 at org.h2.engine.Engine.openSession(Engine.java:58)
116 at org.h2.engine.Engine.openSession(Engine.java:140)
117 at org.h2.engine.Engine.getSession(Engine.java:120)
118 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
119 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
120 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
121 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
122 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
123 at org.h2.Driver.connect(Driver.java:58)
124 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
125 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
126 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
127 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
128 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
129 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
130 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
131 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
132Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
133 at java.io.RandomAccessFile.open(Native Method)
134 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
135 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
136 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
137 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
138 at org.h2.store.FileStore.<init>(FileStore.java:84)
139 ... 25 more
14014:53:55,007 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f5ffded -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
141org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
142IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
143 at org.h2.message.Message.getSQLException(Message.java:105)
144 at org.h2.message.Message.convertIOException(Message.java:292)
145 at org.h2.store.FileStore.<init>(FileStore.java:90)
146 at org.h2.store.FileStore.open(FileStore.java:135)
147 at org.h2.store.FileStore.open(FileStore.java:117)
148 at org.h2.engine.Database.openFile(Database.java:480)
149 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
150 at org.h2.engine.Database.openFileData(Database.java:505)
151 at org.h2.engine.Database.open(Database.java:592)
152 at org.h2.engine.Database.openDatabase(Database.java:220)
153 at org.h2.engine.Database.<init>(Database.java:215)
154 at org.h2.engine.Engine.openSession(Engine.java:58)
155 at org.h2.engine.Engine.openSession(Engine.java:140)
156 at org.h2.engine.Engine.getSession(Engine.java:120)
157 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
158 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
159 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
160 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
161 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
162 at org.h2.Driver.connect(Driver.java:58)
163 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
164 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
165 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
166 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
167 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
168 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
169 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
170 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
171Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
172 at java.io.RandomAccessFile.open(Native Method)
173 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
174 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
175 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
176 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
177 at org.h2.store.FileStore.<init>(FileStore.java:84)
178 ... 25 more
17914:54:01,466 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7f02dfd9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
180org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
181IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
182 at org.h2.message.Message.getSQLException(Message.java:105)
183 at org.h2.message.Message.convertIOException(Message.java:292)
184 at org.h2.store.FileStore.<init>(FileStore.java:90)
185 at org.h2.store.FileStore.open(FileStore.java:135)
186 at org.h2.store.FileStore.open(FileStore.java:117)
187 at org.h2.engine.Database.openFile(Database.java:480)
188 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
189 at org.h2.engine.Database.openFileData(Database.java:505)
190 at org.h2.engine.Database.open(Database.java:592)
191 at org.h2.engine.Database.openDatabase(Database.java:220)
192 at org.h2.engine.Database.<init>(Database.java:215)
193 at org.h2.engine.Engine.openSession(Engine.java:58)
194 at org.h2.engine.Engine.openSession(Engine.java:140)
195 at org.h2.engine.Engine.getSession(Engine.java:120)
196 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
197 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
198 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
199 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
200 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
201 at org.h2.Driver.connect(Driver.java:58)
202 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
203 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
204 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
205 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
206 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
207 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
208 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
209 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
210Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
211 at java.io.RandomAccessFile.open(Native Method)
212 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
213 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
214 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
215 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
216 at org.h2.store.FileStore.<init>(FileStore.java:84)
217 ... 25 more
21814:54:11,307 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@28b2eca9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
219org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
220IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
221 at org.h2.message.Message.getSQLException(Message.java:105)
222 at org.h2.message.Message.convertIOException(Message.java:292)
223 at org.h2.store.FileStore.<init>(FileStore.java:90)
224 at org.h2.store.FileStore.open(FileStore.java:135)
225 at org.h2.store.FileStore.open(FileStore.java:117)
226 at org.h2.engine.Database.openFile(Database.java:480)
227 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
228 at org.h2.engine.Database.openFileData(Database.java:505)
229 at org.h2.engine.Database.open(Database.java:592)
230 at org.h2.engine.Database.openDatabase(Database.java:220)
231 at org.h2.engine.Database.<init>(Database.java:215)
232 at org.h2.engine.Engine.openSession(Engine.java:58)
233 at org.h2.engine.Engine.openSession(Engine.java:140)
234 at org.h2.engine.Engine.getSession(Engine.java:120)
235 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
236 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
237 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
238 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
239 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
240 at org.h2.Driver.connect(Driver.java:58)
241 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
242 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
243 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
244 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
245 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
246 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
247 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
248 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
249Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
250 at java.io.RandomAccessFile.open(Native Method)
251 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
252 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
253 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
254 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
255 at org.h2.store.FileStore.<init>(FileStore.java:84)
256 ... 25 more
25714:54:18,035 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1041dde0 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
258org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r
259IO Exception: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files); name: /home/oli/data/h2/lportal.data.db mode: r [90031-116]
260 at org.h2.message.Message.getSQLException(Message.java:105)
261 at org.h2.message.Message.convertIOException(Message.java:292)
262 at org.h2.store.FileStore.<init>(FileStore.java:90)
263 at org.h2.store.FileStore.open(FileStore.java:135)
264 at org.h2.store.FileStore.open(FileStore.java:117)
265 at org.h2.engine.Database.openFile(Database.java:480)
266 at org.h2.store.DiskFile.<init>(DiskFile.java:135)
267 at org.h2.engine.Database.openFileData(Database.java:505)
268 at org.h2.engine.Database.open(Database.java:592)
269 at org.h2.engine.Database.openDatabase(Database.java:220)
270 at org.h2.engine.Database.<init>(Database.java:215)
271 at org.h2.engine.Engine.openSession(Engine.java:58)
272 at org.h2.engine.Engine.openSession(Engine.java:140)
273 at org.h2.engine.Engine.getSession(Engine.java:120)
274 at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
275 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
276 at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
277 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
278 at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
279 at org.h2.Driver.connect(Driver.java:58)
280 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
281 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
282 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
283 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
284 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
285 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
286 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
287 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
288Caused by: java.io.FileNotFoundException: /home/oli/data/h2/lportal.data.db (Too many open files)
289 at java.io.RandomAccessFile.open(Native Method)
290 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
291 at java.io.RandomAccessFile.<init>(RandomAccessFile.java:98)
292 at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23)
293 at org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390)
294 at org.h2.store.FileStore.<init>(FileStore.java:84)
295 ... 25 more
29614:54:18,721 ERROR [DialectDetector:114] java.sql.SQLException: Connections could not be acquired from the underlying database!
297java.sql.SQLException: Connections could not be acquired from the underlying database!
and so on...
this is my portal-ext.properties:
1jdbc.default.driverClassName=org.h2.Driver
2jdbc.default.url=jdbc:h2:${liferay.home}/data/h2/lportal;DB_CLOSE_ON_EXIT=FALSE
3jdbc.default.username=sa
4jdbc.default.password=
Can someone please help me? The files exists and i have no idea why it complains about too many open files.
Do i have to change something in my system that it allows more opened files? I'm running Ubuntu 9.04
Please sign in to flag this as inappropriate.
