evvolabs
neo
Joined: 12/11/2014 18:15:23
Messages: 1
Offline
|
Hi,
We are getting quartz shared memory error quite often , we even increased Oracle database SGA to 3GB , but still issue is not resolved .
Please help.
Java version: 1.6
Oracle : 11g
Websphere: 8.5.0.2
Quartz version:2.1.5
Error:
org.quartz.JobPersistenceException: Couldn't remove trigger: ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DELETE FROM QUARTZ_BLOB_TRIG...","sga heap(1,0)","kglsim heap")
[See nested exception: java.sql.SQLException: ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DELETE FROM QUARTZ_BLOB_TRIG...","sga heap(1,0)","kglsim heap")
]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.removeTrigger(JobStoreSupport.java:1447)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3033)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$44.execute(JobStoreSupport.java:3017)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$46.execute(JobStoreSupport.java:3777)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3811)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3773)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3013)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1753)
at org.quartz.core.JobRunShell.run(JobRunShell.java:281)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: java.sql.SQLException: ORA-04031: unable to allocate 4000 bytes of shared memory ("shared pool","DELETE FROM QUARTZ_BLOB_TRIG...","sga heap(1,0)","kglsim heap")
Thanks,
chetan
|