Hi Darius,
Did you intentionally make one lower and the other upper case? Or it does
not matter?
{MVCC=TRUE vs MVCC=true}
On Wed, May 16, 2012 at 2:25 AM, Darius Jazayeri <djazay...@gmail.com>wrote:
> Hi All,
>
> I just discovered a particular limitation to H2 for our junit tests, and a
> workaround, that I thought I'd share.
>
> I was trying to write a complex integration test for the moduledistro
> module as a BaseModuleContextSensitiveTest. In the test I write a GP
> telling it to use a temporary folder to store modules (instead of
> clobbering my ~/.OpenMRS/modules), and then the code I call also ends up
> reading the GP table several times.
>
> I get error output like this in the console:
>
> ERROR - JDBCExceptionReporter.logExceptions(234) |2012-05-15 16:12:20,755|
> Timeout trying to lock table "GLOBAL_PROPERTY"; SQL statement:
> select this_.property as property33_0_, this_.property_value as
> property2_33_0_, this_.description as descript3_33_0_, this_.datatype as
> datatype33_0_, this_.datatype_config as datatype5_33_0_,
> this_.preferred_handler as preferred6_33_0_, this_.handler_config as
> handler7_33_0_, this_.uuid as uuid33_0_ from global_property this_ where
> lower(this_.property)=? [50200-135]
> ERROR - JDBCExceptionReporter.logExceptions(234) |2012-05-15 16:12:22,773|
> Timeout trying to lock table "GLOBAL_PROPERTY"; SQL statement:
> select this_.property as property33_0_, this_.property_value as
> property2_33_0_, this_.description as descript3_33_0_, this_.datatype as
> datatype33_0_, this_.datatype_config as datatype5_33_0_,
> this_.preferred_handler as preferred6_33_0_, this_.handler_config as
> handler7_33_0_, this_.uuid as uuid33_0_ from global_property this_ where
> lower(this_.property)=? [50200-135]
> ERROR - ModuleFactory.notifySuperUsersAboutModuleFailure(305) |2012-05-15
> 16:12:22,862| Unable to send an alert to the super users
> org.springframework.transaction.UnexpectedRollbackException: Transaction
> rolled back because it has been marked as rollback-only
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:717)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
> at $Proxy57.notifySuperUsers(Unknown Source)
> at
> org.openmrs.module.ModuleFactory.notifySuperUsersAboutModuleFailure(ModuleFactory.java:302)
> at
> org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:605)
> at org.openmrs.api.context.Daemon$1.run(Daemon.java:57)
> ERROR - JDBCExceptionReporter.logExceptions(234) |2012-05-15 16:12:24,871|
> Timeout trying to lock table "GLOBAL_PROPERTY"; SQL statement:
> select this_.property as property33_0_, this_.property_value as
> property2_33_0_, this_.description as descript3_33_0_, this_.datatype as
> datatype33_0_, this_.datatype_config as datatype5_33_0_,
> this_.preferred_handler as preferred6_33_0_, this_.handler_config as
> handler7_33_0_, this_.uuid as uuid33_0_ from global_property this_ where
> lower(this_.property)=? [50200-135]
>
>
> Some of the stack trace is:
>
> java.lang.RuntimeException: Failed to start module metadatasharing because
> of: Error while trying to start module
> could not execute query
>
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
>
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
>
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> org.hibernate.loader.Loader.doList(Loader.java:2536)
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
> org.hibernate.loader.Loader.list(Loader.java:2271)
> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
> org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
> org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
> **
> org.openmrs.api.db.hibernate.HibernateAdministrationDAO.getGlobalPropertyObject(HibernateAdministrationDAO.java:264)
> **
> org.openmrs.api.impl.AdministrationServiceImpl.getGlobalPropertyObject(AdministrationServiceImpl.java:662)
> (snip)
> $Proxy44.getGlobalPropertyObject(Unknown Source)
> ** org.openmrs.module.ModuleFactory.runDiff(ModuleFactory.java:669)
> **
> org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:538)
> ** org.openmrs.api.context.Daemon$1.run(Daemon.java:57)
>
> Via
> http://stackoverflow.com/questions/4162557/timeout-error-trying-to-lock-table-in-h2I
> found
> http://www.h2database.com/html/advanced.html#mvcc .
>
> Quick summary: you can tell H2 via the database URL that you want to
> enable Multi-Version Concurrency Control (MySQL uses this in INNODB tables,
> but H2 sadly does not enable it by default).
>
> The workaround: add this snippet to your unit test (that extends
> BaseModuleContextSensitiveTest:
>
> @Override
> public Properties getRuntimeProperties() {
> Properties props = super.getRuntimeProperties();
> String url = props.getProperty(Environment.URL);
> if (url.contains("jdbc:h2:") && !url.contains(";MVCC=TRUE")) {
> props.setProperty(Environment.URL, url + ";MVCC=true");
> }
> return props;
> }
>
>
> After adding this snippet I no longer get that error. (Though sadly I get
> a different one, due to not being able to execute the sqldiff for a module
> I'm loading.) Hopefully it helps someone someday.
>
> Cheers,
> Darius
> ------------------------------
> Click here to
> unsubscribe<lists...@listserv.iupui.edu?body=SIGNOFF%20openmrs-devel-l>from
> OpenMRS Developers' mailing list
--
If we keep uppermost in our minds the unkind and unjust acts of others, we
shall find it impossible to love them as Christ has loved us; but if our
thoughts dwell upon the wondrous love and pity of Christ for us, the same
spirit will flow out to others.
_________________________________________
To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to
lists...@listserv.iupui.edu with "SIGNOFF openmrs-devel-l" in the body (not
the subject) of your e-mail.
[mailto:lists...@listserv.iupui.edu?body=SIGNOFF%20openmrs-devel-l]
