How is it possible to know which data in the DB took the most size and delete it? My guess is it’s “openrpa_instances” but deleting its records doesn’t reduce current database usage.
Connect to database using mongodb Compass that will help you to understand storage usage
how are you measuring that ?
when you delete something it goes into the log ( or journal for mongodb ) so if you are looking at the disk, it will not have any effect until you do a backup of the database and run a compact.
Hey, what is the connection URI for database connection when using Compass to connect to openIAP db?
You can find that in docker file. Database name is always openflow
I’m asking about the app.openiap.io website. My openiap is hosted there. I want to free space and I need to connect to the DB. Is it possible to connect to my account’s mongoDB on the openiap website? what’s the connection string?
If it’s not possible to connect directly, then how can I free up some space from the website UI? I removed everything from “openrpa_instances” entities but it takes multiple hour for space to get free.
No, mongodb for app.openiap.io is not public.
Disk Space is calculated once a day.
You can click the grafana link to see what collections contains data that was used to, doing last scan.
If most of the space is used in _hist collections, then please let me know, then i can purge that manually. For security reasons, you cannot delete data from _hist collections yourself … I will add a setting and a button button to do that in the web interface at some point, but right now that can only be done directly in the database.
Thanks. Is it possible to disable logging workflow execution records in “openrpa_instances”? It takes a lot of space and I have to delete it every day.
There are a few options, see
And OpenRPA configuration | OpenIAP Documentation
Like skip_online_state and disable_instance_store