org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-173]

Stack Overflow | kaskelotti | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Grails accessing H2 TCP server hangs

    Stack Overflow | 3 years ago | kaskelotti
    org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-173]
  2. 0

    Problem with JDBC Url (h2 server mode)

    Google Groups | 3 years ago | Stefan Beigel
    org.h2.jdbc.JdbcSQLException: A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:tcp://localhost//data". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-178] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=344&build=178>) at org.h2.message.DbException.get(DbException.java:178<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=178&build=178>) at org.h2.engine.ConnectionInfo.getName(ConnectionInfo.java:392<http://h2database.com/html/source.html?file=org/h2/engine/ConnectionInfo.java&line=392&build=178>) at org.h2.engine.Engine.openSession(Engine.java:42<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=42&build=178>) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=142&build=178>) at org.h2.engine.Engine.createSession(Engine.java:125<http://h2database.com/html/source.html?file=org/h2/engine/Engine.java&line=125&build=178>)
  3. 0

    Out Of Memory Error: Java heap space

    Google Groups | 8 years ago | Alexander.Sirenko
    org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: SCRIPT [90108-169] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=169>) at org.h2.message.DbException.get(DbException.java:158<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=158&build=169>) at org.h2.command.Command.executeQuery(Command.java:195<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=195&build=169>) at org.h2.server.TcpServerThread.process(TcpServerThread.java:308<http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.java&line=308&build=169>)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Corrupted Database - unable to recover

    Google Groups | 5 years ago | beetle
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT * FROM JESIG [50000-155] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=327&build=155>) at org.h2.message.DbException.get(DbException.java:156<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=156&build=155>) at org.h2.command.Command.executeQuery(Command.java:185<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=185&build=155>) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:173<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=173&build=155>) at org.h2.server.web.WebApp.getResult(WebApp.java:1304<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1304&build=155>) at org.h2.server.web.WebApp.query(WebApp.java:994<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=994&build=155>) at org.h2.server.web.WebApp$1.next(WebApp.java:960<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=960&build=155>) at org.h2.server.web.WebThread.process(WebThread.java:166<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=166&build=155>)
  6. 0

    add identity an primary key after filling

    Google Groups | 9 years ago | kavenchuk
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table SYS [50200-69] at org.h2.message.Message.getSQLException(Message.java:91 <http://h2database.com/html/source.html?file=org/h2/message/Message.java&line=91&build=69>) at org.h2.message.Message.getSQLException(Message.java:95 at org.h2.message.Message.getSQLException(Message.java:73 <http://h2database.com/html/source.html?file=org/h2/message/Message.java&line=73&build=69>) at org.h2.table.TableData.lock(TableData.java:377 at org.h2.engine.Database.removeMeta(Database.java:698 <http://h2database.com/html/source.html?file=org/h2/engine/Database.java&line=698&build=69>) at org.h2.engine.Database.update(Database.java:1112 at org.h2.schema.Sequence.flush(Sequence.java:104 <http://h2database.com/html/source.html?file=org/h2/schema/Sequence.java&line=104&build=69>) at org.h2.table.Column.updateSequenceIfRequired(Column.java:269 at org.h2.table.Column.validateConvertUpdateSequence(Column.java:251 <http://h2database.com/html/source.html?file=org/h2/table/Column.java&line=251&build=69>) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:469 at org.h2.command.dml.Insert.update(Insert.java:117 <http://h2database.com/html/source.html?file=org/h2/command/dml/Insert.java&line=117&build=69>) at <http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAlterColumn.java&line=368&build=69>) at org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:316 <http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAlterColumn.java&line=316&build=69>) org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:152 <http://h2database.com/html/source.html?file=org/h2/command/ddl/AlterTableAlterColumn.java&line=152&build=69>) at org.h2.command.CommandContainer.update(CommandContainer.java:69 <http://h2database.com/html/source.html?file=org/h2/command/CommandContainer.java&line=69&build=69>) at org.h2.command.Command.executeUpdate(Command.java:197 at org.h2.server.TcpServerThread.process(TcpServerThread.java:248 <http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.java&line=248&build=69>) at org.h2.server.TcpServerThread.run(TcpServerThread.java:104

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      Connection is broken: "unexpected status 16777216" [90067-173]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      JdbcConnection.getTransactionIsolation
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
      2. org.h2.message.DbException.get(DbException.java:171)
      3. org.h2.message.DbException.get(DbException.java:148)
      4. org.h2.engine.SessionRemote.done(SessionRemote.java:594)
      5. org.h2.command.CommandRemote.prepare(CommandRemote.java:65)
      6. org.h2.command.CommandRemote.<init>(CommandRemote.java:45)
      7. org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:449)
      8. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1142)
      9. org.h2.jdbc.JdbcConnection.getTransactionIsolation(JdbcConnection.java:756)
      9 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. org.apache.tomcat
      DisposableConnectionFacade.invoke
      1. org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
      2. org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
      3. org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
      3 frames
    5. com.sun.proxy
      $Proxy32.getTransactionIsolation
      1. com.sun.proxy.$Proxy32.getTransactionIsolation(Unknown Source)
      1 frame
    6. Spring Framework
      LazyConnectionDataSourceProxy.<init>
      1. org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.checkDefaultConnectionProperties(LazyConnectionDataSourceProxy.java:191)
      2. org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:164)
      3. org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.<init>(LazyConnectionDataSourceProxy.java:106)
      3 frames
    7. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      4 frames
    8. Spring Beans
      AbstractAutowireCapableBeanFactory.doCreateBean
      1. org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
      2. org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
      3. org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
      4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
      5. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
      6. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
      6 frames
    9. Grails
      ReloadAwareAutowireCapableBeanFactory.doCreateBean
      1. org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
      1 frame
    10. Spring Beans
      AbstractAutowireCapableBeanFactory.doCreateBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
      6. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
      7. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
      8. org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:637)
      9. org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
      10. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075)
      11. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979)
      12. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
      12 frames
    11. Grails
      ReloadAwareAutowireCapableBeanFactory.doCreateBean
      1. org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
      1 frame
    12. Spring Beans
      AbstractAutowireCapableBeanFactory.doCreateBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
      6. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
      7. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
      8. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
      9. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
      10. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      10 frames
    13. Grails
      ReloadAwareAutowireCapableBeanFactory.doCreateBean
      1. org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
      1 frame
    14. Spring Beans
      AbstractAutowireCapableBeanFactory.doCreateBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
      6. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:320)
      7. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107)
      8. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1417)
      9. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)
      10. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      10 frames
    15. Grails
      ReloadAwareAutowireCapableBeanFactory.doCreateBean
      1. org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
      1 frame
    16. Spring Beans
      AbstractBeanFactory.getBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
      5 frames
    17. Grails
      TransactionManagerPostProcessor.setBeanFactory
      1. org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.initialize(TransactionManagerPostProcessor.java:74)
      2. org.codehaus.groovy.grails.orm.support.TransactionManagerPostProcessor.setBeanFactory(TransactionManagerPostProcessor.java:52)
      2 frames
    18. Spring Beans
      AbstractAutowireCapableBeanFactory.doCreateBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1532)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1500)
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
      3 frames
    19. Grails
      ReloadAwareAutowireCapableBeanFactory.doCreateBean
      1. org.codehaus.groovy.grails.commons.spring.ReloadAwareAutowireCapableBeanFactory.doCreateBean(ReloadAwareAutowireCapableBeanFactory.java:127)
      1 frame
    20. Spring Beans
      AbstractBeanFactory.getBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)
      5 frames
    21. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:720)
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
      2 frames
    22. Grails
      GrailsContextLoader.initWebApplicationContext
      1. org.codehaus.groovy.grails.commons.spring.DefaultRuntimeSpringConfiguration.getApplicationContext(DefaultRuntimeSpringConfiguration.java:156)
      2. org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:169)
      3. org.codehaus.groovy.grails.commons.spring.GrailsRuntimeConfigurator.configure(GrailsRuntimeConfigurator.java:127)
      4. org.codehaus.groovy.grails.web.context.GrailsConfigUtils.configureWebApplicationContext(GrailsConfigUtils.java:122)
      5. org.codehaus.groovy.grails.web.context.GrailsContextLoader.initWebApplicationContext(GrailsContextLoader.java:108)
      5 frames
    23. Spring
      ContextLoaderListener.contextInitialized
      1. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
      1 frame
    24. Glassfish Core
      ContainerBase$StartChild.call
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
      2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
      3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      4. org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
      5. org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
      5 frames
    25. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
      5. java.lang.Thread.run(Thread.java:662)
      5 frames