Closed Nulhiedbriks closed 1 year ago
tglman
commented
1 year ago Hi,
There are two more options to handle this case: storage.autoCloseAfterDelay and storage.autoCloseDelay, so if you add to the orientdb-server-config.xml
<entry value="true" name="storage.autoCloseAfterDelay" />
<entry value="1" name="storage.autoCloseDelay" />This will cause a database that is not used for more than 1 minute to be closed with all the relative files.
Bye
Nulhiedbriks
commented
1 year ago Hi, thanks for the reply.
i tried with this config in orientdb-server-config.xml
<properties>
<entry value="true" name="db.custom.support"/>
<entry value="200000" name="storage.openFiles.limit"/>
<entry value="10000" name="network.maxConcurrentSessions"/>
<entry value="false" name="profiler.enabled"/>
<entry value="true" name="storage.useWAL"/>
<entry value="true" name="storage.autoCloseAfterDelay" />
<entry value="1" name="storage.autoCloseDelay" />
<entry value="/home/webcod2320/WAL" name="storage.wal.path"/>
<!-- PROFILER: configures the profiler as <seconds-for-snapshot>,<archive-snapshot-size>,<summary-size> -->
<entry name="profiler.enabled" value="false"/>
<!-- <entry name="profiler.config" value="30,10,10" /> -->
</properties>but it's still doesn't work, the database is still opened.
In docs there is no mention of storage.autoCloseAfterDelay and storage.autoCloseDelay (my search https://orientdb.com/docs/last/admin/Configuration.html).
Should i use a previous version of OrientDB ?
Another question about the distributed mode. I tried with a few DBs (55) for testing and when i start the dserver.sh all the databases are opened. It will be a problem for me if there is no way to control this ?
tglman
commented
1 year ago Hi,
if you are using OrientDB in distributed mode, it do not support autoclosing of database as today, this is because to make sure everything is aligned we do open and check all the databases continuously, so that configuration it does not have effect.
Nulhiedbriks
commented
1 year ago Hi,
Thanks for these answers. The configuration works on a non-distributed mode :)
OrientDB Version: 3.2.18
Java Version: openjdk 1.8.0_362-ea
OS: centOS 7
Hi, I work with a large number of database (actually 10364 : 1 DB/user). Using NodeJS/ODB Studio for DB manipulations.
When i close a DB (user disconnect) i close the DB. The problem is files are still open while DB is no more used. The number of opened files reach the max (set to ~ 260 000) and the only issue is to shutdown the server and restart (Not viable for a production env).
When using the automatic backup, the problem is the same. Files are still opened.
I search how to close these files but nothing worked. Any issue ?
Thank you in advance,
Expected behavior
Closing files when closing a DB
Actual behavior
Files are still opened after closing a DB
Steps to reproduce
/config/orientdb-server-config.xml: I tried differents values forstorage.useWAL,file.lockand the deprecatedkeepStorageI also see a
<storages>tag but no idea how to work with this.Example of a single database
\databases\1HN: after OrientJS pooled sessions closed / Disconnected from Studio / Closed fromconsole.sh