Hi, I use H2 1.3.176 (last stable). The following exception was thrown while executing multiple database operations in parallel, maybe it could helpful for you to apply a fix. Unfortunately, I cannot provide a testcase for this.
java.sql.SQLException: Folgende SQL-Anweisung konnte nicht ausgeführt werden: create trigger if not exists REPORT_567.ACTUALRESULTS_23_ADTRIGGER AFTER DELETE on REPORT_567.ACTUALRESULTS_23 call "com.rapidrep.kernel.internaldb.h2.triggers.AfterDeleteTrigger" at com.rapidrep.kernel.internaldb.common.InternalDatabaseLayer.executeSQLInInternalDB(InternalDatabaseLayer.java:1101) at com.rapidrep.kernel.internaldb.common.InternalDatabaseLayer.executeSQLInInternalDB(InternalDatabaseLayer.java:1069) at com.rapidrep.kernel.internaldb.common.InternalDatabaseLayer.createTriggers(InternalDatabaseLayer.java:1207) at com.rapidrep.kernel.internaldb.common.InternalDatabaseLayer.createTableFunctionForScript(InternalDatabaseLayer.java:1193) [...] Caused by: org.h2.jdbc.JdbcSQLException: Fehler beim Erzeugen des Triggers "ACTUALRESULTS_23_ADTRIGGER", Klasse "com.rapidrep.kernel.internaldb.h2.triggers.AfterDeleteTrigger", Grund: "com.rapidrep.kernel.internaldb.h2.triggers.AfterDeleteTrigger"; siehe Ursache für Details Error creating or initializing trigger "ACTUALRESULTS_23_ADTRIGGER" object, class "com.rapidrep.kernel.internaldb.h2.triggers.AfterDeleteTrigger", cause: "org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: ""java.util.ConcurrentModificationException"" General error: ""java.util.ConcurrentModificationException""; SQL statement: SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION [50000-176]"; see root cause for details; SQL statement: create trigger if not exists REPORT_567.ACTUALRESULTS_23_ADTRIGGER AFTER DELETE on REPORT_567.ACTUALRESULTS_23 call "com.rapidrep.kernel.internaldb.h2.triggers.AfterDeleteTrigger" [90043-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:167) at org.h2.schema.TriggerObject.load(TriggerObject.java:77) at org.h2.schema.TriggerObject.setTriggerClassName(TriggerObject.java:92) at org.h2.command.ddl.CreateTrigger.update(CreateTrigger.java:110) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:254) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:186) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160) at com.rapidrep.kernel.internaldb.common.InternalDatabaseLayer.executeSQLInInternalDB(InternalDatabaseLayer.java:1093) ... 11 more Caused by: org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: "java.util.ConcurrentModificationException" General error: "java.util.ConcurrentModificationException"; SQL statement: SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATALOG, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_SCHEMA, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_TABLE, SOURCE_DATA_TYPE, CASE WHEN SEQUENCE_NAME IS NULL THEN CAST(? AS VARCHAR) ELSE CAST(? AS VARCHAR) END IS_AUTOINCREMENT, CAST(SOURCE_DATA_TYPE AS VARCHAR) SCOPE_CATLOG FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND COLUMN_NAME LIKE ? ESCAPE ? ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION [50000-176] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) at org.h2.message.DbException.get(DbException.java:167) at org.h2.message.DbException.convert(DbException.java:294) at org.h2.command.Command.executeQuery(Command.java:209) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:109) at org.h2.jdbc.JdbcDatabaseMetaData.getColumns(JdbcDatabaseMetaData.java:285) at org.h2.tools.TriggerAdapter.init(TriggerAdapter.java:70) at org.h2.schema.TriggerObject.load(TriggerObject.java:72) ... 18 more Caused by: java.util.ConcurrentModificationException at java.util.HashMap$HashIterator.nextEntry(Unknown Source) at java.util.HashMap$ValueIterator.next(Unknown Source) at org.h2.engine.Database.getAllTablesAndViews(Database.java:1466) at org.h2.table.MetaTable.getAllTables(MetaTable.java:610) at org.h2.table.MetaTable.generateRows(MetaTable.java:721) at org.h2.index.MetaIndex.find(MetaIndex.java:51) at org.h2.index.BaseIndex.find(BaseIndex.java:128) at org.h2.index.IndexCursor.find(IndexCursor.java:160) at org.h2.table.TableFilter.next(TableFilter.java:330) at org.h2.command.dml.Select.queryFlat(Select.java:533) at org.h2.command.dml.Select.queryWithoutCache(Select.java:646) at org.h2.command.dml.Query.query(Query.java:323) at org.h2.command.dml.Query.query(Query.java:291) at org.h2.command.dml.Query.query(Query.java:37) at org.h2.command.CommandContainer.query(CommandContainer.java:91) at org.h2.command.Command.executeQuery(Command.java:197) ... 22 more Kind regards, Christoff Schmitz F I N A R I S Financial Software Partner GmbH Sömmerringstrasse 23 60322 Frankfurt am Main Fon: +49 (0)69 / 254 98 - 24 Mobile: +49 (0)176 / 206 34 186 Fax: +49 (0)69 / 254 98 - 50 eMail: mailto:christoff.schm...@finaris.de www: http://www.finaris.de und http://www.rapidrep.com From: "Benedikt Waldvogel" <m...@bwaldvogel.de> To: h2-database@googlegroups.com Date: 20.11.2014 09:21 Subject: Re: [h2] 1.4.181 BLOB related issue Sent by: h2-database@googlegroups.com Hi, On Wed, November 19, 2014 10:25, Thomas Mueller wrote: > To avoid having to change the test case, could you add > ";trace_level_system_out=3" to the database URL, and then send me / post > the resulting output? This should include all the JDBC API calls. That way > it should be quite easy to write a pure JDBC test case. Or append > ";trace_level_file=3" and then send the <databaseName>.trace.db file. please find a trace on https://paste.ee/p/Ri7xi Let me know when you need more info. Best, Benedikt -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. ================================================================================================================ Disclaimer The information contained in this e - mail and any attachments ( together the "message") is intended for the addressee only and may contain confidential and/or privileged information. If you have received the message by mistake please delete it and notify the sender and do not copy or distribute it or disclose its contents to anyone. FINARIS Financial Software Partner GmbH, Sömmerringstr. 23, 60322 Frankfurt/Main, Germany Registered at Frankfurt/Main, HRB 52873, Managing Directors: Dipl. Inf. Hermann Friebel, Dipl. Ing. Kai Bächle, Dipl. Inf. Werner Märkl ================================================================================================================ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
