9:52 a.m.
JdbcSQLException: "Database is already closed" on server shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:54 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Jozef Hartinger updated AS7-2045:
---------------------------------
Attachment: standalone-persistent.xml
test.war
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:58 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Jozef Hartinger commented on AS7-2045:
--------------------------------------
Note the following:
* on 7.0.1 the db records remain in the database (are available once the AS is started
again)
* on 7.0.2 the db records are not available once the AS is started again, which is
expected (perhaps the tables are dropped actually). Nevertheless, the exception in the
server log still remains.
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:38 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Brian Stansberry updated AS7-2045:
----------------------------------
Assignee: Jesper Pedersen
Component/s: JCA
I'm manually doing the auto-assign thing. :)
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Jesper Pedersen
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:48 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Jesper Pedersen updated AS7-2045:
---------------------------------
Assignee: Scott Marlow (was: Jesper Pedersen)
Component/s: JPA / Hibernate
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Scott Marlow
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:12 p.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-2045:
-----------------------------------
Is this only a problem with ctrl-c or does it happen when you shutdown the AS with
jboss-admin?
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Scott Marlow
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:18 p.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-2045:
-----------------------------------
It sounds like the H2 shutdown handler is probably getting invoked.
Since this is for demo only, not production, you might try their suggestion of adding
"DB_CLOSE_ON_EXIT=FALSE" to the db url.
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Scott Marlow
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:20 p.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Scott Marlow reassigned AS7-2045:
---------------------------------
Assignee: Jozef Hartinger (was: Scott Marlow)
Try ";DB_CLOSE_ON_EXIT=FALSE" as mentioned in comments.
More information on H2 and DB_CLOSE_ON_EXIT is here
http://www.h2database.com/html/features.html#do_not_close_on_exit
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:18 p.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Jason Greene closed AS7-2045.
-----------------------------
Resolution: Done
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Assignee: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:17 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Juraj Huska reopened AS7-2045:
------------------------------
Assignee: (was: Jozef Hartinger)
I am experiencing the same issue with RichFaces showcase application. I have described my
problems in RF-11905.
The workaround proposed here works, however without it it does not. The closing issue here
indicates that it was fixed and should work without workaround, is it so ?
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:58 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-2045:
-----------------------------------
Since no one has changed any code (as far as I know), related to this bug, the above
(";DB_CLOSE_ON_EXIT=FALSE") workaround is still needed (since the shutdown hook
is running before the PersistenceUnit service is shutdown).
One possible code change, would be to replace the current H2 database, with a service
based database (perhaps also H2) that shuts down after the JCA connection pool is closed
(after all dependencies on datasources are released).
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:11 a.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Scott Marlow commented on AS7-2045:
-----------------------------------
Anyway, I don't think this jira shouldn't of been reopened. Instead, start a
discussion on forums/email.
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:59 p.m.
[
https://issues.jboss.org/browse/AS7-2045?page=com.atlassian.jira.plugin.s...
]
Stuart Douglas closed AS7-2045.
-------------------------------
Resolution: Done
Please do not re-open JIRA's against released versions. Create a new issue instead.
JdbcSQLException: "Database is already closed" on server
shutdown
-----------------------------------------------------------------
Key: AS7-2045
URL: https://issues.jboss.org/browse/AS7-2045
Project: Application Server 7
Issue Type: Bug
Components: JCA, JPA / Hibernate
Affects Versions: 7.0.2.Final
Reporter: Jozef Hartinger
Priority: Critical
Fix For: 7.1.0.Beta1
Attachments: standalone-persistent.xml, test.war
An application that uses the "create-drop" Hibernate ddl strategy fails do
undeploy properly on shutdown when a persistent (non-in-memory) database is used. Shutdown
log below.
This issue is critical for the demo applications on *openshift express* (which uses
persistent setup for the built-in database) where redeploy is expected to get the
application to the default state.
To reproduce:
# Use the attached standalone-persistent.xml profile (the only change is redefinition of
the built-in datasource URL to jdbc:h2:${jboss.server.data.dir}/test;DB_CLOSE_DELAY=-1)
# Deploy the attached application
# Start the server with the persistent profile (./standalone.sh
--server-config=../standalone/configuration/standalone-persistent.xml)
# Stop the server (Ctrl+C)
# You should see the exception below
{noformat}
16:42:43,982 INFO [org.jboss.as.logging] Restored bootstrap log handlers
16:42:44,003 INFO [org.jboss.jpa] stopping Persistence Unit Service
'test.war#booking'
16:42:44,005 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00227:Running hbm2ddl
schema export
16:42:44,014 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00231:Schema export
unsuccessful: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable
automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL)
[90121-145]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1333)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1308)
at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:364)
at
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:810)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1567)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.createStatement(WrappedConnection.java:295)
at
org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:54)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:354)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:305)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:301)
at org.hibernate.internal.SessionFactoryImpl.close(SessionFactoryImpl.java:1288)
at
org.hibernate.ejb.EntityManagerFactoryImpl.close(EntityManagerFactoryImpl.java:126)
at
org.jboss.as.jpa.service.PersistenceUnitService.stop(PersistenceUnitService.java:88)
[jboss-as-jpa-7.0.2.Final.jar:7.0.2.Final]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.stopService(ServiceControllerImpl.java:1909)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
org.jboss.msc.service.ServiceControllerImpl$StopTask.run(ServiceControllerImpl.java:1872)
[jboss-msc-1.0.1.GA.jar:1.0.1.GA]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[:1.6.0_24]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[:1.6.0_24]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_24]
16:42:44,018 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] HHH00230:Schema export
complete
16:42:44,022 INFO [com.arjuna.ats.jbossatx] ARJUNA32018: Destroying
TransactionManagerService
16:42:44,028 INFO [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery
manager
16:42:44,030 INFO [org.jboss.as.server.deployment] Stopped deployment test.war in 68ms
16:42:44,032 INFO [org.jboss.as] JBoss AS 7.0.2.Final "Arc" stopped in 66ms
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4631
days inactive
4749
days old
12 comments
11 participants
participants (11)
-
Brian Stansberry (Updated) (JIRA) -
Jason Greene (Closed) (JIRA)
-
Jesper Pedersen (Updated) (JIRA)
-
Jozef Hartinger (Commented) (JIRA)
-
Jozef Hartinger (Created) (JIRA)
-
Jozef Hartinger (Updated) (JIRA)
-
Juraj Huska (JIRA)
-
Scott Marlow (Assigned) (JIRA)
-
Scott Marlow (Commented) (JIRA)
-
Scott Marlow (JIRA)
-
Stuart Douglas (JIRA)