Grails Domains: Get by Id not found

Question

I have a Job (using Quartz)

A Service method which uses get (for a Domain class)

The problem is: sometimes (1 in a 1000) the domain's get(X) method returns null even if the row with id X exists.

If I use executeQuery or findByX the same problem happens.

Datasource has cache disabled.

Any suggestions?

Are you `flushing` the `save()` of the domain if it is in scope of the Quartz Schedule? — dmahapatro, Apr 29 '13 at 21:13
Can you share the portion of service where the domain is persisted and fetched? Quartz `execute()` will also be helpful. — dmahapatro, Apr 30 '13 at 01:24
Is it in debug or runtime? Where do you see, in IDEA watches? — Mr. Cat, Apr 30 '13 at 08:08
This problem occurs in all environments (production too). I'm not using idea, just sublime text. My database is oracle — VMOrtega, May 02 '13 at 03:30
Was this issue ever resolved? I'm running into something similar. Unfortunately @moskiteau's recommendation didn't work for me. — McStretch, Apr 23 '15 at 22:24

score 0 · Answer 1 · answered May 14 '13 at 12:50

We had the same problem with Quartz. The problem is that Quartz thread keep a connection that is not flushed. To the workaround is to use this in you job:

def session = sessionFactory.getCurrentSession()
session.flush()
session.clear()

Grails Domains: Get by Id not found

1 Answers1