Bug 1346761

Summary:

org.h2.jdbc.JdbcSQLException: The database has been closed

Product:

[Other] RHQ Project

Reporter:

sana <safoora.sana>

Component:

Database

Assignee:

Nobody <nobody>

Status:

NEW ---

QA Contact:

Severity:

high

Docs Contact:

Priority:

unspecified

Version:

4.13

CC:

hrupp, safoora.sana

Target Milestone:

---

Flags:

safoora.sana: needinfo?

Target Release:

---

Hardware:

x86_64

OS:

Linux

Whiteboard:

Fixed In Version:

Doc Type:

No Doc Update

Doc Text:

undefined

Story Points:

---

Clone Of:

Environment:

Last Closed:

Type:

Bug

Regression:

---

Mount Type:

---

Documentation:

---

CRM:

Verified Versions:

Category:

---

oVirt Team:

---

RHEL 7.3 requirements from Atomic Host:

Cloudforms Team:

---

Target Upstream Version:

Embargoed:

Attachments:

Description	Flags
Agent Log	none

Description sana 2016-06-15 10:07:11 UTC

Created attachment 1168301 [details]
Agent Log

Description of problem:
In the agent.log there are continuous Exceptions as "Database has been closed "  and its not able to query the database where as when connected through H2 console, i am able to query the results successfully.I suppose the connection of H2 DB was lost.
When i restarted the rhq-agent there were no exceptions.It was normal.


Following is the stack trace:
2016-06-01 17:44:47,983 ERROR [ResourceContainer.invoker.daemon-2] (itpf.monitoring.ddc.datastore.DatastoreImplementation)- Unable to get byte count for metric: svc-1-impexpserv_TOR_os position: 1 directory: 010616
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-187]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.engine.Database.checkPowerOff(Database.java:496)
        at org.h2.command.Command.executeQuery(Command.java:221)
        at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:79)
        at com.ericsson.oss.itpf.monitoring.ddc.datastore.DatastoreImplementation.getBiteCount(DatastoreImplementation.java:40)
        at com.ericsson.oss.itpf.monitoring.ddc.parsing.instr.InstrMeasurementProvider.getLatestMeasurements(InstrMeasurementProvider.java:51)
        at com.ericsson.oss.itpf.monitoring.plugins.instr.InstrApplicationComponent.getValues(InstrApplicationComponent.java:71)
        at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocation.call(ResourceContainer.java:759)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
2016-06-01 17:44:48,915 ERROR [ResourceContainer.invoker.daemon-2] (itpf.monitoring.ddc.datastore.DatastoreImplementation)- Unable to set byte count for metric: svc-1-impexpserv_TOR_com.ericsson.oss.services.cm.cmreader.ejb.instrumentation.cm-reader:type=InstrumentatedBean position: 15 directory: 010616
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-187]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.engine.Database.checkPowerOff(Database.java:496)
        at org.h2.command.Command.executeQuery(Command.java:221)
        at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:79)
        at com.ericsson.oss.itpf.monitoring.ddc.datastore.DatastoreImplementation.setBiteCount(DatastoreImplementation.java:53)
        at com.ericsson.oss.itpf.monitoring.ddc.parsing.instr.InstrMeasurementProvider.getLatestMeasurements(InstrMeasurementProvider.java:80)
        at com.ericsson.oss.itpf.monitoring.plugins.instr.InstrApplicationComponent.getValues(InstrApplicationComponent.java:71)
        at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocation.call(ResourceContainer.java:759)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)

Even if this is not affecting any functionality it should be fixed because it compromise the troubleshooting analysis becase all the logs are filled up with this exceptions and important messages can be lost.
Beside that the logs files keeps increasing unnecessarily. 


Version-Release number of selected component (if applicable):
H2 JAR Version -  h2-1.4.187.jar

Actual results:


Expected results:


Additional info: