Grails

The 'console' command hangs when Groovy console is closed

Details

  • Type: Bug Bug
  • Status: In Progress In Progress
  • Priority: Critical Critical
  • Resolution: Unresolved
  • Affects Version/s: 2.0-M1
  • Fix Version/s: 2.3-M2
  • Component/s: None
  • Labels:
    None

Description

In a 2.0 project, run the grails console command. Now quit the console. The command stays running in the background and can only be stopped with a Ctrl-C. That's not fun if you're in interactive mode since it drops you back to your OS terminal!

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Raviteja added a comment -

I have faced a much weirder issue. I haven't closed grails console properly while I was using 1.3.7 and it(GUI) never was visible again.

Show
Raviteja added a comment - I have faced a much weirder issue. I haven't closed grails console properly while I was using 1.3.7 and it(GUI) never was visible again.
Hide
Permalink
Philippe RT added a comment -

Hello,

I've got the same issue too.

I play with GORM, and sometimes, the script hang. So I stop it and I have the exception :

2012-03-16 08:44:18,876 [Thread-52] ERROR util.JDBCExceptionReporter - Cannot get a connection, general error
2012-03-16 08:44:18,899 [Thread-52] ERROR util.JDBCExceptionReporter - Cannot get a connection, general error
Exception thrown

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not inspect JDBC autocommit mode; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, general error; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, general error
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:512)
at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:506)
at org.springframework.orm.hibernate3.HibernateOperations$get.call(Unknown Source)
at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231)
at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231)
at $Proxy20.doInHibernate(Unknown Source)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231)
at fr.compagniedesalpes.jdv.Application.read(Application.groovy)
at fr.compagniedesalpes.jdv.Application$read.call(Unknown Source)
at ConsoleScript10.run(ConsoleScript10:3)
at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231)
at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, general error
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:118)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
at $Proxy16.getAutoCommit(Unknown Source)
at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:212)
at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:287)
at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:595)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1010)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 15 more
Caused by: java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:502)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1115)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 26 more

After, the console stops to work. When I want to close it, it hangs.

If it can help...

Thanks.

Show
Philippe RT added a comment - Hello, I've got the same issue too. I play with GORM, and sometimes, the script hang. So I stop it and I have the exception : 2012-03-16 08:44:18,876 [Thread-52] ERROR util.JDBCExceptionReporter - Cannot get a connection, general error 2012-03-16 08:44:18,899 [Thread-52] ERROR util.JDBCExceptionReporter - Cannot get a connection, general error Exception thrown org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not inspect JDBC autocommit mode; uncategorized SQLException for SQL [???] ; SQL state [null] ; error code [0] ; Cannot get a connection, general error; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, general error at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:512) at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:506) at org.springframework.orm.hibernate3.HibernateOperations$get.call(Unknown Source) at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231) at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231) at $Proxy20.doInHibernate(Unknown Source) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231) at fr.compagniedesalpes.jdv.Application.read(Application.groovy) at fr.compagniedesalpes.jdv.Application$read.call(Unknown Source) at ConsoleScript10.run(ConsoleScript10:3) at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231) at com.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1231) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, general error at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:118) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224) at $Proxy16.getAutoCommit(Unknown Source) at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:212) at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:287) at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:595) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1010) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998) at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 15 more Caused by: java.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:502) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1115) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) ... 26 more After, the console stops to work. When I want to close it, it hangs. If it can help... Thanks.
Hide
Permalink
Imran Sarwar added a comment -

I'm facing the same issue as Philippe, and it happens too often

Thanks

Show
Imran Sarwar added a comment - I'm facing the same issue as Philippe, and it happens too often Thanks
Hide
Permalink
Peter Ledbrook added a comment -

For those having problems with SQL exceptions, are you running with grails -reloading console?

Show
Peter Ledbrook added a comment - For those having problems with SQL exceptions, are you running with grails -reloading console ?

People

  • Assignee:
    Graeme Rocher
    Reporter:
    Peter Ledbrook
Vote (4)
Watch (2)

Dates

  • Created:
    Updated:
    Last Reviewed: