Two problems after migrating OpenMRS with NCD from Ubuntu to Redhat

[Hui Xiao]

I found two problems after migrating OpenMRS based NCD application from Ubuntu to RedHat Linux.

 

The first one has something to do with mysql query cache, which worked as expected in Ubutu, but not in Redhat even though mysql settings appear the same (e.g. query_cache_type = 1,  query_cache_limit  = 1M,  query_cache_size = 32M) in both environment. As a result, query of the users table is much slower in Redhat than in Ubuntu as the users table contains hundreds of thousands of records and is queried every time a message arrives for login purpose.

 

The other issue has something to do with the display of the “Manage Scheduled Reports” page after clicking on any listed item. The following internal error occurred that did not in the Ubuntu installation:

 

An Internal Error has Occurred

org.apache.jasper.JasperException

Unable to compile class for JSP:

 

An error occurred at line: 169 in the generated java file

The code of method _jspService(HttpServletRequest, HttpServletResponse) is exceeding the 65535 bytes limit

 

 ……………………………..

 

Yes, the jsp page is big, but why does it work in Ubuntu but not in Redhat? (I tried changing the mappedfile property to false in tomcat web.xml as suggested by a google post as a workaround. This workaround seems to work for tomcat7 but not for tomcat6 in Redhat).

 

Here’s the version of OS, mysql and tomcat on these two machines:

 

Redhat Server:

Red Hat Enterprise Linux Server release 6.2 (Santiago)

mysql  Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1

Server version: Apache Tomcat/6.0.35

 

Ubuntu Server:

Ubuntu 8.04.3 LTS \n \l

mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

Server version: Apache Tomcat/6.0.20

 

Any comments or suggestions would be greatly appreciated!

 

Thanks,

Hui Xiao

[Saptarshi Purkayastha]

have u tried pre-compiling JSPs??

I've seen this issue with tomcat, but it doesn't happen all the time when loading the page... does it??

---
Regards,
Saptarshi PURKAYASTHA

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

--

OpenMRS Developers: http://go.openmrs.org/dev
Post: d...@openmrs.org
Unsubscribe: dev+uns...@openmrs.org
*** OpenMRS has moved from Subversion to Git. Read more: http://go.openmrs.org/git ***
 
 

[Hui Xiao]

Thank you Saptarshi for your reply. I didn't try pre-compiling JSPs.I'll try that as my next step. And this error does happen all the time after I migrated NCD from ubuntu to Redhat.

 

Regards,

Hui Xiao