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
Burt Beckwith made changes -
Field Original Value New Value
Workflow Grails [ 62282 ] Grails2 [ 63964 ]
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.
Burt Beckwith made changes -
Workflow Grails2 [ 63964 ] jira [ 75885 ]
Burt Beckwith made changes -
Workflow jira [ 75885 ] Grails2 [ 84626 ]
Peter Ledbrook made changes -
Last Reviewed 01/Jan/10
Peter Ledbrook made changes -
Workflow Grails2 [ 84626 ] jira [ 93066 ]
Peter Ledbrook made changes -
Workflow jira [ 93066 ] Grails2 [ 101234 ]
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
Graeme Rocher made changes -
Assignee Graeme Rocher [ graemerocher ]
Graeme Rocher made changes -
Fix Version/s 2.1 [ 12801 ]
Priority Major [ 3 ] Critical [ 2 ]
Graeme Rocher made changes -
Status Open [ 1 ] In Progress [ 3 ]
Graeme Rocher made changes -
Fix Version/s 2.1 [ 13117 ]
Fix Version/s 2.1-RC1 [ 12801 ]
Graeme Rocher made changes -
Fix Version/s 2.1 [ 13125 ]
Fix Version/s 2.1-RC2 [ 13117 ]
Graeme Rocher made changes -
Fix Version/s 2.1 [ 13133 ]
Fix Version/s 2.1-RC3 [ 13125 ]
Graeme Rocher made changes -
Fix Version/s 2.2 [ 13093 ]
Fix Version/s 2.1 [ 13133 ]
Graeme Rocher made changes -
Fix Version/s 2.3 [ 13311 ]
Fix Version/s 2.2-RC1 [ 13093 ]
Repository Branch Revision Date Author/Committer Message
Grails Core 2.1.x 28da49a... 2012-10-30 07:10:17 -0700 Peter Ledbrook / Peter Ledbrook Fix GRAILS-7885: quit grails console when all windows closed.

The 'console' command now checks every 3 seconds whether any windows are still
open. Once they are all closed, it exits. This saves the user having to do a
Ctrl-C every time (which is not always possible or easy).
Files Changed
MODIFY scripts/Console.groovy

Repository Branch Revision Date Author/Committer Message
Grails Core 2.2.x 28da49a... 2012-10-30 07:10:17 -0700 Peter Ledbrook / Peter Ledbrook Fix GRAILS-7885: quit grails console when all windows closed.

The 'console' command now checks every 3 seconds whether any windows are still
open. Once they are all closed, it exits. This saves the user having to do a
Ctrl-C every time (which is not always possible or easy).
Files Changed
MODIFY scripts/Console.groovy

Repository Branch Revision Date Author/Committer Message
Grails Core master 28da49a... 2012-10-30 07:10:17 -0700 Peter Ledbrook / Peter Ledbrook Fix GRAILS-7885: quit grails console when all windows closed.

The 'console' command now checks every 3 seconds whether any windows are still
open. Once they are all closed, it exits. This saves the user having to do a
Ctrl-C every time (which is not always possible or easy).
Files Changed
MODIFY scripts/Console.groovy

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 ?
Graeme Rocher made changes -
Fix Version/s 2.3-M2 [ 13457 ]
Fix Version/s 2.3-M1 [ 13311 ]

People

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

Dates

  • Created:
    Updated:
    Last Reviewed: