[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Quartz 2.1.5 Shared memory error  XML
Forum Index -> Quartz
Author Message
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
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team