Avni-server Java upgrade

[mahalakshme]

Need:

OpenJDK 8 is maintained by RedHat. They will support Java 8 until 2026: https://access.redhat.com/articles/1299013

For Java 8, Oracle has announced it is offering ‘Extended Support’ up until December 2030. Extend Support is Oracle’s way of extending the shelf life of Premier beyond its deadline.

For this service, organizations using Oracle Java pay an additional fee: an extra 10% on the existing support fee in year one, an extra 20% in year two, and another 20% in year three, etc.

Analysis:

11, 17, 21 are the 3 Java LTS versions.

AC:

Upgrade server to Java 21 (if this is not possible, developer can decide to upgrade it to a different version) which is the latest LTS version and make sure all features(esp., sync) works as expected.

• requires springboot 3.2
• upgrade usages of Java language and API
• upgrade usages of SpringBoot API
• upgrade dependencies and libraries

Out of scope:

ETL and integration-server are in Java 17. Hence they need not be upgraded now.

Sheet to note down issues encountered during Dev/ Review / Testing of Avni-server Java upgrade to version21

https://docs.google.com/spreadsheets/d/1IJMxsy-unLrtBbhqUC9y2YQgQ51YieDCmG_iZHaDqds/edit?usp=sharing

[himeshr]

For upgradation of Hateoas to new version, which would be needed once we upgrade the springboot version, do refer to following docs:

• https://github.com/spring-projects/spring-hateoas/blob/main/etc/migrate-to-1.0.sh
• https://spring.io/blog/2019/03/05/spring-hateoas-1-0-m1-released

[petmongrels]

Things to sanity test

• creation of rpm
• check auth (done)
• custom UUID in mobile app api response is correct (done)
• security, auth, spring related abstract classes have been removed now (done)
• keycloak based auth (done)
• glific integration (test on staging)
• read queries should not result in update queries (done)
• spring batch (done)
• rule server integration (done)
• media app (test on staging)
• mobile app sync (done)
• mobile app save entities and upload sync (done)
• ETL process (done)
• external api (done)
• EH Cache (done)

To Do

• merge from master

Specific code changes to complete

• org.avni.server.web.TransactionDataSyncTest#sync is not passing

major changes

• jakarta from javax
• hibernate user type approach change
• use of java.time.LocalDateTime
• ehcache

others

• how is this used - org.avni.server.web.FormController#getFormsByProgram
• rearrange properties in application.properties

notes

• /resource/? doesn't work, one has to be /resource?
• The configurers are interface but they have a lot of default empty method

[himeshr]

Tasks to do:

• Deploy on staging the 11.0 code for server and webapp //done
• Ensure following are working fine:

Done

Keycloak, minio, metadata-connector,

Pending

Glific-rest-client, External APIs, Query API, etl, integration, media-server/webapp, int-admin-app and rules-server

[himeshr]

Avni-server JDK upgradation steps to be used for Prerelease and Prod Avni servers

Steps to clean up old JDK

-To uninstall OpenJDK (if installed). First check which OpenJDK packages are installed.

sudo dpkg --list | grep -i jdk

• To remove openjdk:

sudo apt-get purge openjdk*

• Uninstall OpenJDK related packages.

sudo apt-get purge icedtea-* openjdk-*

• Check that all OpenJDK packages have been removed.

sudo dpkg --list | grep -i jdk

Steps to install JDK 21

In Avni-infra repo, modify the Make command corresponding to the Env, in configure/Makefile as follows:

deploy-avni-server-staging: ... --extra-vars '{"install_jdk":"true","java_apt_package":"openjdk-21-jdk",...}' //Done
deploy-avni-server-prod: ... --extra-vars '{"install_jdk":"true","java_apt_package":"openjdk-21-jdk",...}' // TODO when prod go-live
deploy-avni-server-prerelease: ... --extra-vars '{"install_jdk":"true","java_apt_package":"openjdk-21-jdk",...}' //TODO when prerelease is switched to jdk 21 

Trigger Deploy of Avni-server 11.0 branch jar to targeted environment server

[himeshr]

Steps to setup Postgres client 16 on Ubuntu (Reference)

Remove old postgres client

sudo apt-get remove -y postgresql-client

First, update the package index and install required packages:

sudo apt update
sudo apt install gnupg2 wget nano

Add the PostgreSQL 16 repository:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Import the repository signing key:

curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg

Update the package list:

sudo apt update

Install postgres-16 client

sudo apt-get install -y postgresql-client-16

[himeshr]

Update avni-server Opts to use jdk21 property names

Refer to commit and do similar change to env-vars file in avni-infra

[AchalaBelokar]

• After creating organisation message is not displaying that organisation created successfully ....