grails - Write operations are not allowed in read-only mode (FlushMode.MANUAL): -
grails 1.3.7
we have service method merges 2 users. there quite few pieces because of amount of data quite bit of reading, updating, , writing. have transactional=true in service. understand default flushmode grails auto. , understand error message means.
however, doesn't happen locally , doesn't happen in our staging environment. of running identical version of mysql identical privileges (password exception).
i know can change default flushmode behavior i'm hesitant since can't duplicate behavior on environment production. right i'm wondering if there cause wouldn't related flushmode?
the verbatim error message is:
org.springframework.dao.invaliddataaccessapiusageexception: write operations not allowed in read-only mode (flushmode.manual): turn session flushmode.commit/auto or remove 'readonly' marker transaction definition.
i'm seeing errors similar these in grails 1.3.7 application well. in case, back-end db having lock contention issues cause app throw cannotacquirelockexception. after hitting 1 of these we'd see lots of exact same invaliddataaccessapiusageexceptions you're seeing (coincidentally, happened in our prod environment, not dev or test)
you may want check ensure prod db user has access locking features in mysql, , check other database-related exceptions may actual root cause.
Comments
Post a Comment