I can chime in to give some more information about what @Renuchand_CR is mentioning:
The ee_information query seem to be related to the online license verification that strapi implements, here’s a PR:
(Line 64 of packages/core/strapi/ee/index.js file)
So, I did some digging and testing and ended up putting the following configurations in config/admin.js and config/server.js of our strapi project:
I also removed every mention of the STRAPI_LICENSE variable in our env and added one (I think not needed) new env variable STRAPI_DISABLE_EE as true.
With these changes, that ee_information query does not trigger. We haven’t tested this yet as we are gathering more information still, but it’s important to mention that this started to happen after the upgrade from strapi 4.5.5 to 4.10.5; Also our DB seem to be choking with 20 sessions opened at any given moment and it takes time for them to go down.
These configs also were implemented in config/database.js but they did not help at all, so we reverted them:
Edit: My suspicion, (if this is really related to the license query) is that maybe as our license is expired and we have not updated the datum of the new license (we don’t seem to have it at hand yet) then… the service is retrying multiple times? but we’re not sure this is the real main issue.
It seems like our license has expired and no plans of renewing it in sight? So… taking that into consideration, does the suggestion above seems like something feasible? or do you see any other change needed different from disabling the license check?