Could not extract Resultset error on bahmni 0.93

Ask OpenMRS
1

I am encountering a “Could not extract result set” error on Bahmni 0.93. The issue seems to be resolved temporarily by restarting the MySQL service, but the error reoccurs after a few days. What could be causing this problem?

image
image1426×520 35.4 KB

3

Here is the OpenMRS log when the error occurs.

openmrs log.txt (1.1 KB)

I have made some changes to the MySQL configuration.

my.cnf.txt (810 Bytes)

Any suggestions would be greatly appreciated. @angshuonline @mohant @rahu1ramesh

4

Seems like a performance issue. Can you try to identify some patterns ? Like a specific user action or some scheduler running. Also check if some form submission is causing this issue

5

Thank you for your feedback. I have added SET GLOBAL max_allowed_packet=1073741824 inside MySQL, and I have been monitoring the issue since last week. This change may have resolved the issue.