1. What is the problem? Be very detailed.
Hey guys ,ODK has been misbehaving,where it keeps crashing and we have to restart the tomcat service every time to restart aggregate for it to work.It may work for a few minutes then it stops working.The problem has been too severe that I cannot even pull files through aggregate or add any new forms as it gives different errors at different times.sometimes the error can be the site took too long to respond or problem persisting data or accessing data.Currently if I restart the tomcat service my aggregate is blank without any data.
2. What app or server are you using and on what device and operating system? Include version numbers.
I am running on :
Tomcat 9.0
My SQL 6.3
3. What you have you tried to fix the problem?
I have been restarting the tomcat service,I also tried deleting some forms in the database which had been entered twice with the same ID but the problem persists.Checking the logs this is the most persistent statement
Feb 26, 2020 9:23:24 AM org.opendatakit.aggregate.task.WatchdogWorkerImpl checkTasks
INFO: ---------------------BEGIN Watchdog
Feb 26, 2020 9:23:55 AM org.opendatakit.aggregate.util.BackendActionsTable logValues
INFO: incoming- last Fetch: -1582698235804 [S: -53902293 Eq: -1582698235804 Fs: -1582698235804] futureMillis: 30000
Feb 26, 2020 9:24:24 AM org.apache.commons.dbcp2.BasicDataSource onSwallowException
WARNING: An internal object pool swallowed an Exception.
4. What steps can we take to reproduce the problem?
Just try accessing the public subdomain address,you get this site can't be reached.
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
I gave the logs and screenshots
localhost_access_log.2020-02-25.txt (35.4 KB)
catalina.2020-02-25.log.txt (103.6 KB) localhost.2020-02-25.log.txt (2.4 KB) localhost_access_log.2020-02-25.txt (35.4 KB) tomcat9-stderr.2020-02-25.log.txt (2.2 MB)
