We have recently upgraded KenyaEMR to run on platform 2.4.0. We are currently experiencing failing lucene indexing on certain patient records and that affects searching and even reporting. The trace can be found at pastebin.
We have investigated the issue and it points to something related to mysql connector for java 8. Has anyone experienced something similar, and how did you go about it?
Our setup has the following:
Ubuntu 20.04
Tomcat 9
MySQL 5.6
Java 11
Update: I have appended serverTimezone=UTC to the mysql connection string (according to known limitations documentation) and indexing can pass. Searching and reports now work fine although we are still not confident as this could come with some time loss. More updates to follow.
Just for troubleshooting purposes, without doing anything to the mysql connection string, are you able to delete the lucene folder from the application data folder and try again?
Hey @jdick, @bett was able to resolve this by downgrading the MySQL connector to mysql-connector 5.1.x in openmrs core 2.4. So far we haven’t experienced any issues with indexing or search.