Troubleshooting with installing ODK aggregate

Hi ODK forum,

i am re-installing ODK Aggregate on the same PC (WINDOWS OS) as used before due to the former user not having saved credentials of the ODK super user. As i installed tomcat 8, postgreSQL 11 and ODK. I ran into a problem after finishing all the ODK readme steps.

ODK is listed in the tomcat serverlist. But it is not starting due to an error. The logs give the following error:
12-Jun-2019 14:57:35.194 WARNING [http-nio-8080-exec-35] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ODKAggregate] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

I added the catalina logs in the attachments. catalina_logs.txt (20.3 KB) Does anyone have a good way to fix this error?

Kind regards,

Thomas

Hi,

Have you tried with Tomcat 9.0.21? I always had issue with Tomcat 7 and 8 series. On your current installation, have you tried to stop the server, restart the PC and start the server?

Hope one of these steps will help you in resolving your issue.

Welcome to the ODK forum, @Thomas_E! We're glad you're here. When you get a chance, please Introduce yourself here!. I'd also encourage you to add a real picture as your avatar because it helps build community!

Thanks,
Imran

Hi,

Thanks Imran for the quick reply. I immediately tried your solve but unfortunetaly the same problem still occurs with tomcat 9. if anyone else has a better solution please let me know.

12-Jun-2019 16:35:09.937 WARNING [http-nio-8080-exec-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ODKAggregate] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

KR,

Thomas

@Thomas_E Your logs, unfortunately, don't have a lot of good hints. There are a lot of variables here and what would help is if you could start with the component versions we recommend -- Tomcat 8 and PostgreSQL 9.4 and see if that works.

If you need something up quickly, https://docs.opendatakit.org/aggregate-vm/ gets you an install pretty quickly.

1 Like