Rohit,
Regarding the DB size, are you doing some cleaning from time to tome (visitors
and such stuff) like
http://web.archive.org/web/20070224121213/ofbizwiki.go-integral.com/Wiki.jsp?page=Pg_monitoring#section-Pg_monitoring-CleaningTheDatabaseFromUnimportantData
There have been some fix recently applied for DB connection and memory issues. That's why I asked your version. Though this problem
were supposed to appear (mostly) in cluster mode.
I'm not aware of current issues in this area. I'm afraid you will have to dig
in futher...
Jacques
From: "rohit" <rohitksur...@yahoo.com>
Hi Jacques,
I am currently using the svn 884373. I had updated a few days hoping
something may work but it did not. Prior to it i was using the SVN of
something around 79000, when i had the same problem.
Rohit
Jacques Le Roux wrote:
Which Release.revision are you using ?
Jacques
From: "rohit" <rohitksur...@yahoo.com>
Hi,
I am using Postgres database with my ofbiz installation on linux.
Recently i
started getting database problems with ofbiz.
Firstly, i see that more than a few database connections are made by
ofbiz.
Earlier, there were 3 - 4 running processes showing the database
connection,
but now i have more than 20 connections from ofbiz to the postsgres
database. Most of the connections are in idle state, but they occupy a
lot
of memory and have terribly slowed ofbiz.
Secondly, the database size is increasing much faster than the actual
data.
For eg. when i export the data as SQL file, the file size is 800 MB,
however the database folder, folder that contains the files for the
database, is more than 25 GB.
I am quiet at a loss regarding the problem. Is there a problem with ofbiz
or
is it the problem with the database.
I will appreciate if someone, can throw some more light on it.
Thanks
Rohit
--
View this message in context:
http://n4.nabble.com/How-to-do-Ofbiz-Database-Maintenance-tp788517p788517.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
--
View this message in context:
http://n4.nabble.com/How-to-do-Ofbiz-Database-Maintenance-tp788517p788750.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
