Hi, we have severe problems with ObjectDB crashing frequently. We can’t find the exact cause but we suspect several things.
We use 2.5.3_03 version and we use it in production. The same setup in test environment hasn’t have these kind of problems
First crash occurred when network went down and database lost connection with the JBOSS AS, several restarts got it up and running finally. It seems when the database loses network connection it shutdowns but we cant be sure.
Usualy database stops once a day with no apperent reason.
Second cause we suspect is the number of network connections to the database, initial count was 500 but it wasn’t enough and we increased it to 5000 but after that system performance degraded significantly. It started to crash less frequently
Q1. Is it necessary to implement closing of connection after every commit we make by the user?
Q2. Our JBOSS AS frequently exceeds heap memory limit, could this cause problems with DB
Q3. Is there any command to check if the database is running from command prompt?
Did anyone had similar problems