Hi Thomas, Thank you for your answer, however it does not apply here. The whole project is built via Maven and H2 definition is only provided in master pom.xml file. It means that both server and fitnesse tests are sharing the same Maven artifact. I saw your suggestion about incompatibilities in other topics, so I verified that there is only one version of the jar file used for the server and the client. Please advice what else can lead to this error and how to get more detailed logging from server side?
Thanks, Michał On Wednesday, August 12, 2015 at 6:01:47 PM UTC+2, Thomas Mueller wrote: > > Hi, > > I guess the H2 version on the client is incompatible with the server > version. In theory this should work (the protocol version is negotiated > when connecting), however I know there was a bug where an incompatibility > was introduced. > > Regards, > Thomas > > On Tuesday, August 11, 2015, Michal Wojcik <[email protected] > <javascript:>> wrote: > >> Hi, >> >> I have problem with H2 database working in server mode. It happens very >> often, that my Fitnesse tests are failing with the error "Connection is >> broken: "unexpected status 16842752" [90067-187]". >> "16842752" is only example, there were also values like 256, 50, 5, etc. >> >> Please advice what is the reason of this behavior. >> >> >> >> The same problem was with older versions of H2 - 1.3.146 >> Database is working in TCP mode with data stored in memory (however for >> file based database the error was too). Following command is used to start >> it >> java -Dh2 -Xmx1024M -Dcom.sun.management.jmxremote -classpath >> "/C:/Users/00000/.m2/repository/com/h2database/h2/1.4.187/h2-1.4.187.jar" >> org.h2.tools.Server -tcp -tcpAllowOthers -tcpPort 33025 >> >> Tests are executed on Windows 7 64 bit and Java version is 1.7.60 >> >> Application is accessing two databases hosted on one H2 server. >> Connection strings are: >> jdbc:h2:tcp://localhost:33025/mem:brap;MVCC=TRUE;MODE=Oracle;JMX=TRUE >> jdbc:h2:tcp://localhost:33025/mem:AAdb;MVCC=TRUE;MODE=Oracle;JMX=TRUE >> >> Sample call stack is: >> [14:36:27,537] [main] ERROR - org.hibernate.transaction.JDBCTransaction - >> JDBC begin failed >> org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status >> 16842752" [90067-187] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.message.DbException.get(DbException.java:179) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.message.DbException.get(DbException.java:155) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.engine.SessionRemote.done(SessionRemote.java:637) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:251) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:226) >> ~[h2-1.4.187.jar:1.4.187] >> at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:432) >> ~[h2-1.4.187.jar:1.4.187] >> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) ~[na:na] >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> ~[na:1.7.0_60] >> at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_60] >> at >> org.springframework.jdbc.datasource.SingleConnectionDataSource$CloseSuppressingInvocationHandler.invoke(SingleConnectionDataSource.java:352) >> >> ~[spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at com.sun.proxy.$Proxy64.setAutoCommit(Unknown Source) ~[na:na] >> at >> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:91) >> ~[hibernate-core-3.3.1.GA.jar:3.3.1.GA] >> at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353) >> [hibernate-core-3.3.1.GA.jar:3.3.1.GA] >> at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38) >> [hibernate-entitymanager-3.4.0.GA.jar:3.4.0.GA] >> at >> org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70) >> >> [spring-orm-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:59) >> >> [spring-orm-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377) >> >> [spring-orm-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) >> >> [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) >> >> [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) >> >> [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) >> >> [spring-tx-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) >> >> [spring-aop-3.1.1.RELEASE.jar:3.1.1.RELEASE] >> at >> com.xx.apd.prm.datamodel.dao.HbmCityDao$$EnhancerByCGLIB$$83cbc731.retrieveByCode(<generated>) >> >> [cglib-2.2.jar:na] >> at >> com.xx.apd.prm.fixtures.setup.AddAirportFixture.findCityByCityCode(AddAirportFixture.java:71) >> >> [classes/:na] >> at >> com.xx.apd.prm.fixtures.setup.AddAirportFixture.addAirport(AddAirportFixture.java:53) >> >> [classes/:na] >> at >> com.xx.apd.prm.fixtures.setup.AddAirportFixture.execute(AddAirportFixture.java:45) >> >> [classes/:na] >> at >> com.xx.apd.prm.fixtures.setup.AddPnrcAirportFixture.execute(AddPnrcAirportFixture.java:14) >> >> [classes/:na] >> at fit.ColumnFixture.doRow(ColumnFixture.java:27) >> [fitnesse-20121220.jar:na] >> at fit.Fixture.doRows(Fixture.java:160) [fitnesse-20121220.jar:na] >> at fit.ColumnFixture.doRows(ColumnFixture.java:18) >> [fitnesse-20121220.jar:na] >> at fit.Fixture.doTable(Fixture.java:154) [fitnesse-20121220.jar:na] >> at fit.Fixture.interpretFollowingTables(Fixture.java:120) >> [fitnesse-20121220.jar:na] >> at fit.Fixture.interpretTables(Fixture.java:106) >> [fitnesse-20121220.jar:na] >> at fit.Fixture.doTables(Fixture.java:80) [fitnesse-20121220.jar:na] >> at fit.FitServer.process(FitServer.java:81) [fitnesse-20121220.jar:na] >> at fit.FitServer.run(FitServer.java:56) [fitnesse-20121220.jar:na] >> at fit.FitServer.main(FitServer.java:41) [fitnesse-20121220.jar:na] >> >> -- >> 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 [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
