OpenMRS 1.9.0 RC4 Released

[Daniel Kayiwa]

Greetings to everyone!!!

I am happy to announce the release of OpenMRS 1.9.0 RC4 (Fourth Release Candidate) which you can get from the downloads page. This is just a bug fix, in the core and some bundled modules, over the previously released RC3. See changes since the third release candidate in the release notes.

You are encouraged to use the Release Testing Helper module to test this fourth release candidate using your existing data. Read more about it from: Release Testing Helper Module, and download it from here.

As you test this release candidate, if you find any bugs, report them in our ticket tracking system.

We are anxiously looking forward to your testing feedback as we get even closer to the official 1.9.0 release in a couple of days.

To the 71 developers, plus those who have tested the previous releases, and all who have, in various ways, contributed towards this release, please accept a warm and joyful hug from the community!

Daniel Kayiwa
On Behalf of the OpenMRS community

--
The greatest want of the world is the want of men—men who will not be bought or sold, men who in their inmost souls are true and honest, men who do not fear to call sin by its right name, men whose conscience is as true to duty as the needle to the pole, men who will stand for the right though the heavens fall. 

[James Arbaugh]

I upgraded our test database to OpenMRS 1.9.0 RC4 without error.  The critical ticket I created for RC3 (TRUNK-3333) appears to be fixed.  It looks like you could release OpenMRS 1.9.

 

Thanks,

James

---

Click here to unsubscribe from OpenMRS Implementers' mailing list

[Saptarshi Purkayastha]

When upgrading from 1.8.3 to 1.9RC4, the patientflags cannot start.

It throws the following error for me:

WARN - ModuleFactory.startModuleInternal(603) |2012-06-04 15:44:39,987| Error while trying to start module: patientflags

org.openmrs.api.db.DAOException: Error while running sql: CREATE TABLE patientflags_tag_role (

tag_id int(11) NOT NULL,

role

varchar(50) NOT NULL,

KEY tag_id (tag_id),

KEY role (role),

CONSTRAINT

FOREIGN KEY (tag_id) REFERENCES patientflags_tag (tag_id),

CONSTRAINT

FOREIGN KEY (role) REFERENCES role (role)

) ENGINE=InnoDB DEFAULT

CHARSET=utf8 . Message: Can't create table 'openmrs.patientflags_tag_role' (errno: 150)

at org.openmrs.util.DatabaseUtil.executeSQL(DatabaseUtil.java:139)

at org.openmrs.api.db.hibernate.HibernateAdministrationDAO.executeSQL(HibernateAdministrationDAO.java:340)

at org.openmrs.api.impl.AdministrationServiceImpl.executeSQL(AdministrationServiceImpl.java:798)

at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at $Proxy22.executeSQL(Unknown Source)

at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at $Proxy42.executeSQL(Unknown Source)

at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at $Proxy42.executeSQL(Unknown Source)

at org.openmrs.module.ModuleFactory.runDiff(ModuleFactory.java:694)

at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:538)

at org.openmrs.api.context.Daemon$1.run(Daemon.java:57)

Caused by: java.sql.SQLException: Can't create table 'openmrs.patientflags_tag_role' (errno: 150)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

at org.openmrs.util.DatabaseUtil.executeSQL(DatabaseUtil.java:118)

... 41 more

OpenMRS starts fine, but it is a problem that the bundled module didn't start.

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

-- OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org

[James Arbaugh]

Hi Saptarshi,

 

We are running the Patient Flags module, version 1.3.4.  We didn’t see this error when upgrading from OpenMRS 1.8.3 to 1.9RC4.  Hopefully someone can help you find the cause (and solution).

 

Thanks,

James

[Saptarshi Purkayastha]

James,

You already had the module installed. I didnt have the module installed and got it as part of the bundled module.

Thus, it tried to create the schema for the first time and failed.

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

[Daniel Kayiwa]

Saptarshi,

Could you try run that sql statement directly on your database and tell us what happens?

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.

[Michael Seaton]

PIH Rwanda has also successfully tested upgrading it's 1.6 database to 1.9, and has not found any significant show-stopper issue that would prevent us from upgrading to 1.9.  We plan to do so shortly after it's release, hopefully this week.

Mike

[Saptarshi Purkayastha]

Nope even directly doesn't work on my MySQL installation... and its because I dont have the patientflags_tag (tag_id) in my database??

Does everyone else have that table??

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

[Ben Wolfe]

This can only happen if the global property patientflags.database_version is set to 1.0.0 or higher because the patientflags_tag table is added with that version in the sqldiff of the patientflags module.

If you are upgrading, did you ever install patientflags but then delete all the tables?

If this is a clean installation, then we have something wrong with our setup scripts (like a patientflags GP snuck in)

Either way, the solution is to delete all patientflags* tables and delete all patientflags* global properties.  Then reinstall the module a-fresh.

Ben

[Saptarshi Purkayastha]

For clean, blank 1.9RC4 installation, I get the same error.

Does that also not happen for anyone else??

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

[Ben Wolfe]

I just downloaded the RC4 and ran it with both the advanced setup (with demo data) and the starter MVP setup.  The patientflags module loads correctly for each of them.

Is there anything in your logs about why its failing?  What db and version are you using?

Ben