[
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