How to do Ofbiz Database Maintenance.

[rohit]

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

[Jacques Le Roux]

Which Release.revision are you using ?

Jacques

From: "rohit" <[hidden email]>

> 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.
>

[rohit]

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" <[e-mail]>
> 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.
>

[Jacques Le Roux]

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" <[hidden email]>

> 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" <[hidden email]>
>>> 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.
>