No more resources available in pool (max=100)

[Yasmeen Shabana]

Hi

my PiApport server stopped working suddenly and it gives this error message

"The Picapport server is currently not available. Fotos stored localy can be viewed."

so I ran the troubleshooting tool from the PicApport software and I found these error detals

"ERROR@ 10:28:56.676 Exception Error PhotoCrawler.DirectoryConsumer.run: com.orientechnologies.common.concur.lock.OLockException: No more resources available in pool (max=100). Requested resource: null"

doing some research it seems this is a programming error / bug when database.close() is not used / not executed

see full conversation here

https://groups.google.com/g/orient-database/c/iKppawMpius

as a solution one can extend the max pool but I do not know how to put this parameter in PicApport or what is the parameter argument should be

I tried to put this -Dnetwork.maxConcurrentSessions=5000 in the .ini file but it did not work

any suggestions are welcome

[Sven Söhnel]

Maybe the db.pool parameter?:
I use:
java -Ddb.pool.max=1000...

[Yasmeen Shabana]

Which file did you add this parameter to? Was it the .ini file or the .properties file? And what is the exact syntax?

I tried to put your suggestion in the picapport.l4j.ini file but it didn't work.

And the server started giving error that files are read only which also when searched, it seems a database error because the max pool issue

Also it seems Picapport uses OrientDB and this max pool value is shown in the config dump file called dbconfig.txt but this is just a dump file so the config must be somewhere else.

Appreciate your help

[Yasmeen Shabana]

hi

so i tried your suggestion again because it made sense and with some help form the info I could find online about OrientDB, I was able to make it.

the downside is that I had to delete the ORientDB folder and also remove my photos from picapport then add them again. 

I tried restart the server and restart the app and even restart the whole machine but only after to avoid deleting the DB and remove/re-add my photos but none of that worked.

anyway just posting the solution here for anyone who might need it or can improve it

[Sven Söhnel]

Sorry for late reply!

If I understand you well, it is working now?

The "only" bad thing was the requirement to rebuild the database, right?

I was learning it the same way, find the Infos about start parameters for the OrientDB.

As I did it in a test environment I did not even try to do that without rebuild the database,

so I could not even give a suggestion, sorry.

Kind Regards

[Yasmeen Shabana]

Hi

You actually helpped me because your line worked and you,are right, it works now but it needed to delete the exisitn database folder and import all my photos again. Luckily Picapport is very fast and doesn't delete any original photo files 😊

Thsnk you