Hello.
I have database with several tables, some having about 50000 rows and
one of them has (native h2) fulltext search index on one of its
columns.
This is how I can reproduce the exception that I am getting:
- creating all database from scratch and inserting there some data
- closing the connection
- connecting to database again and inserting there again some data (so
little as few hundreds is sufficient)
- the exception (shown below) is thrown
- exception occurs both in server and embedded mode
- exception doesn't occur when MVCC is used
- exception doesn't occur when I don't create the fulltext search
index on the table
- also doesn't occur with small number of inserts (50 or so) on the
2nd connection
- also doesn't occur when inserting all of the data in the same
connection
Here is the trace log:
05-01 16:36:01 jdbc[1]: exception
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.RuntimeException: Unexpected code path"; SQL statement:
INSERT INTO FT.MAP(ROWID, WORDID) VALUES(?, ?) [50000-152]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.command.Command.executeUpdate(Command.java:216)
at
org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:
181)
at org.h2.fulltext.FullText$FullTextTrigger.insert(FullText.java:933)
at org.h2.fulltext.FullText$FullTextTrigger.fire(FullText.java:896)
at org.h2.schema.TriggerObject.fireRow(TriggerObject.java:203)
at org.h2.table.Table.fireRow(Table.java:867)
at org.h2.table.Table.fireAfterRow(Table.java:858)
at org.h2.command.dml.Insert.insertRows(Insert.java:128)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:212)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.RuntimeException: Unexpected code path
at org.h2.message.DbException.throwInternalError(DbException.java:
226)
at org.h2.message.DbException.throwInternalError(DbException.java:
239)
at org.h2.engine.Session.log(Session.java:613)
at org.h2.command.dml.Insert.insertRows(Insert.java:127)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:212)
... 13 more
I doesn't understand what the exception means...
I can provide trace log of INFO or DEBUG level if needed...
Regards,
Mnicky
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
