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.