hibernate - How to save without locking all the tables on grails -

i have domain class using domain class property city:

class tracker {     string name, value;     city city;     int hits;     date date; } 

and insert or update values using tracker.save(); in long job procedure.

that working fine except when want update on city domain class while tracker saving something. , says lock wait timeout exceeded; try restarting transaction. stacktrace follows: message: lock wait timeout exceeded; try restarting transaction

i don't make changes in city when saving tracker, think hibernate thinks , lock city domain too.

try tracker.save(flush: true) or flush session after updates:

def sessionfactory sessionfactory.currentsession.flush()