Hi,
H2 v1.3.169;
Connection
URL:
jdbc:h2:mem:my_db;CACHE_SIZE=8192000;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=10000;LOG=0;UNDO_LOG=0
I'm experiencing issue with "SHOW TABLES" query.
Every day I see the following exceptions in my logs (my application
actively creates and deletes tables):
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.util.ConcurrentModificationException"; SQL statement:
SHOW TABLES [50000-168]
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:281)
at org.h2.command.Command.executeQuery(Command.java:195)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 35 more
Caused by: java.util.ConcurrentModificationException
at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)
at java.util.HashMap$ValueIterator.next(HashMap.java:822)
at java.util.AbstractCollection.toArray(AbstractCollection.java:124)
at java.util.ArrayList.<init>(ArrayList.java:131)
at org.h2.util.New.arrayList(New.java:71)
at org.h2.schema.Schema.getAllTablesAndViews(Schema.java:513)
at org.h2.engine.Database.getAllTablesAndViews(Database.java:1350)
at org.h2.table.MetaTable.getAllTables(MetaTable.java:573)
at org.h2.table.MetaTable.generateRows(MetaTable.java:635)
at org.h2.index.MetaIndex.find(MetaIndex.java:45)
at org.h2.index.BaseIndex.find(BaseIndex.java:102)
at org.h2.index.IndexCursor.find(IndexCursor.java:145)
at org.h2.table.TableFilter.next(TableFilter.java:322)
at org.h2.command.dml.Select.queryFlat(Select.java:513)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
at org.h2.command.dml.Query.query(Query.java:307)
at org.h2.command.dml.Query.query(Query.java:277)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:86)
at org.h2.command.Command.executeQuery(Command.java:191)
... 40 more
Could you please take a look?
Thanks,
Victor
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/XVI4s1LnWSsJ.
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.
