Re: [h2] XA commit-unlockAll - Unexpected code path

[Noel Grandin]

In general the XA stuff is not well tested. The first thing would be to
reduce it to a standalone test case.​

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] XA commit-unlockAll - Unexpected code path

[Martin Lichtin]

Seeing following exception after upgrading from 196 to 197:

Caused by: org.h2.jdbc.JdbcSQLException: General error: 
"java.lang.RuntimeException: Unexpected code path"; SQL statement:
COMMIT TRANSACTION 
XID_1096044365_3139322e3136382e35362e312e746d31343531_33626532396263332d613865662d343861382d616466352d313433386261336163303838
 
[5-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:307)
at org.h2.command.Command.executeUpdate(Command.java:274)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:399)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:165)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Unexpected code path
at org.h2.message.DbException.throwInternalError(DbException.java:254)
at org.h2.message.DbException.throwInternalError(DbException.java:267)
at org.h2.engine.Session.unlockAll(Session.java:985)
at org.h2.engine.Session.endTransaction(Session.java:760)
at org.h2.engine.Session.commit(Session.java:708)
at org.h2.engine.Session.setPreparedTransaction(Session.java:1179)
at 
org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:70)
at org.h2.command.CommandContainer.update(CommandContainer.java:102)
at org.h2.command.Command.executeUpdate(Command.java:261)
... 3 more

at 
org.h2.engine.SessionRemote.done(SessionRemote.java:623)[182:org.h2:1.4.197]
at 
org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:237)[182:org.h2:1.4.197]
at 
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233)[182:org.h2:1.4.197]
at 
org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205)[182:org.h2:1.4.197]
at 
org.h2.jdbcx.JdbcXAConnection.commit(JdbcXAConnection.java:349)[182:org.h2:1.4.197]
... 27 more

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] After upgrade to 1.4.97 from 1.4.96 produces the following exception : org.h2.jdbc.JdbcSQLException: Table "SYNONYMS" not found;

[Meni Hillel]

Thanks! Confirmed. Once both client and sever are on same version issue
goes away.

On Fri, Apr 13, 2018 at 2:44 AM, Noel Grandin  wrote:

> there is a bug (which is fixed on master) if you mix and match different
> versions client and server side.
>
> If you upgrade the client to 1.4.197, this problem should go away.
>
>

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] Re: Very slow execution with subquery and connection parameter LAZY_QUERY_EXECUTION=1

[Pavel]

I created pull request:

https://github.com/h2database/h2database/pull/1060


On Thursday, April 12, 2018 at 8:25:50 AM UTC-4, Evgenij Ryazanov wrote:
>
> Hello.
>
> It's better to use GitHub for contributions. Pull requests are tested 
> automacally and GitHub provides a good interace to review and discuss 
> submitted changes.
>
> https://github.com/h2database/h2database
> http://www.h2database.com/html/build.html#providing_patches
>

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] After upgrade to 1.4.97 from 1.4.96 produces the following exception : org.h2.jdbc.JdbcSQLException: Table "SYNONYMS" not found;

[Noel Grandin]

there is a bug (which is fixed on master) if you mix and match different 
versions client and server side.

If you upgrade the client to 1.4.197, this problem should go away.

--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] After upgrade to 1.4.97 from 1.4.96 produces the following exception : org.h2.jdbc.JdbcSQLException: Table "SYNONYMS" not found;

[Meni Hillel]

org.h2.jdbc.JdbcSQLException: Table "SYNONYMS" not found; SQL statement:
SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_CAT, 
TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION, SQL FROM 
(SELECT SYNONYM_CATALOG TABLE_CAT, SYNONYM_SCHEMA TABLE_SCHEM, SYNONYM_NAME 
as TABLE_NAME, TYPE_NAME AS TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, 
TYPE_NAME TYPE_SCHEM, TYPE_NAME AS TYPE_NAME, TYPE_NAME 
SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, NULL AS SQL FROM 
INFORMATION_SCHEMA.SYNONYMS WHERE SYNONYM_CATALOG LIKE ? ESCAPE ? AND 
SYNONYM_SCHEMA LIKE ? ESCAPE ? AND SYNONYM_NAME LIKE ? ESCAPE ? AND (true)  
UNION SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, 
TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, 
TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM 
INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND 
TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TRUE) ) 
ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME [42102-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.schema.Schema.getTableOrView(Schema.java:456)
at org.h2.command.Parser.readTableOrView(Parser.java:5535)
at org.h2.command.Parser.readTableFilter(Parser.java:1266)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1946)
at org.h2.command.Parser.parseSelectSimple(Parser.java:2095)
at org.h2.command.Parser.parseSelectSub(Parser.java:1940)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1755)
at org.h2.command.Parser.readTableFilter(Parser.java:1190)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1946)
at org.h2.command.Parser.parseSelectSimple(Parser.java:2095)
at org.h2.command.Parser.parseSelectSub(Parser.java:1940)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1755)
at org.h2.command.Parser.parseSelect(Parser.java:1743)
at org.h2.command.Parser.parsePrepared(Parser.java:449)
at org.h2.command.Parser.parse(Parser.java:321)
at org.h2.command.Parser.parse(Parser.java:293)
at org.h2.command.Parser.prepareCommand(Parser.java:258)
at org.h2.engine.Session.prepareLocal(Session.java:578)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:264)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
at java.lang.Thread.run(Thread.java:748)

at org.h2.engine.SessionRemote.done(SessionRemote.java:623)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:85)
at org.h2.command.CommandRemote.(CommandRemote.java:51)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:493)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:76)
at 
org.h2.jdbc.JdbcConnection.prepareAutoCloseStatement(JdbcConnection.java:330)
at org.h2.jdbc.JdbcDatabaseMetaData.getTables(JdbcDatabaseMetaData.java:195)

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.