the virtual machine ran out of memory. Vinaya Kumar Thimmappa wrote: > Hey Thomas, > > here are contents of trace file > > 12-21 23:56:05 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: Table "STAGEDBAG" not found; SQL statement: > Select * from StagedBag [42102-162] > 12-22 00:08:31 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: > Insert into StagedBag values(?, ?, ?, ?, ?, ?, ?, ?, ?, > > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > [90108-162] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > at org.h2.message.DbException.get(DbException.java:158) > at org.h2.message.DbException.convert(DbException.java:275) > at org.h2.command.Command.executeUpdate(Command.java:230) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > Caused by: java.lang.OutOfMemoryError: Java heap space > at org.h2.value.Value.cache(Value.java:346) > at org.h2.value.ValueString.get(ValueString.java:127) > at org.h2.store.Data.readValue(Data.java:767) > at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:600) > at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:330) > at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) > at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) > at org.h2.index.IndexCursor.next(IndexCursor.java:238) > at org.h2.table.TableFilter.next(TableFilter.java:353) > at org.h2.command.dml.Select.queryGroup(Select.java:311) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:613) > at org.h2.command.dml.Query.query(Query.java:297) > at org.h2.command.dml.Query.query(Query.java:267) > at org.h2.command.dml.Query.query(Query.java:36) > at org.h2.command.ddl.Analyze.analyzeTable(Analyze.java:101) > at org.h2.table.RegularTable.analyzeIfRequired(RegularTable.java:404) > at org.h2.table.RegularTable.addRow(RegularTable.java:153) > at org.h2.command.dml.Insert.insertRows(Insert.java:124) > at org.h2.command.dml.Insert.update(Insert.java:84) > at org.h2.command.CommandContainer.update(CommandContainer.java:73) > at org.h2.command.Command.executeUpdate(Command.java:226) > ... 6 more > 12-22 00:08:31 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > 12-22 00:08:32 jdbc[2]: exception > org.h2.jdbc.JdbcBatchUpdateException: The database has been closed [90098-162] > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > 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.message.DbException.get(DbException.java:135) > at org.h2.engine.Database.checkPowerOff(Database.java:433) > at org.h2.command.Command.executeUpdate(Command.java:237) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155) > at H2Test.doWork(H2Test.java:55) > at H2Test.main(H2Test.java:23) > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] > org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: > Insert into StagedBag values(?, ?, ?, ?, ?, ?, ?, ?, ?, > > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > [90108-162] > > > On Thu, Dec 22, 2011 at 4:58 PM, Vinaya Kumar Thimmappa > <[email protected] <mailto:[email protected]>> > wrote: > > Hello Thomas, > > Thanks for the information.I was running this on Windows 7. is there > limit on file size in on this OS ? > > I re-ran the same code with a different JVM flavour(earlier used sun jdk > 1.6.0) which is available on ubuntu > latest version and it worked fine. > > > vinaya > > On Thu, Dec 22, 2011 at 1:17 PM, Thomas Mueller > <[email protected] > <mailto:[email protected]>> wrote: > > Hi, > > The exception message only says the database was closed. Could you > also post the contents of the file > h2Test.trace.db? Maybe it contains more info. > > H2 supports larger databases (see the FAQ), but possibly the file > system you use only supports files up to 8 > GB size. In that case, you can use the 'Split File System' - see the > docs (Advanced - Split File System). > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google > Groups "H2 Database" group. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To unsubscribe from this group, send email to > [email protected] > <mailto:h2-database%[email protected]>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
