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