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.
