Database Connections made by OLAP

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Database Connections made by OLAP

ian tabangay
Hi. I have deployed an ofbiz application (end of May build) on CentOS 5 with
Postgresql 8.1 as my database. Only after a few minutes, I noticed that the
OLAP creates alot of database connections to the point of no db connection
can be established anymore. As comparison, I have just restarted Ofbiz and
Postgres yesterday at around 4pm, I saw that there are already 68 idle
database connections, only 2 of which are used for the ofbiz database, and
the rest for ofbizolap. Ofbiz is very lightly used. Is this normal?

Ian Tabangay
Reply | Threaded
Open this post in threaded view
|

Re: Database Connections made by OLAP

Jacques Le Roux
Administrator
I don't see any problems like that. Anyway, if you don't need OLAP simply comment it out in entityengine.xml...

Jacques

From: "ian tabangay" <[hidden email]>

> Hi. I have deployed an ofbiz application (end of May build) on CentOS 5 with
> Postgresql 8.1 as my database. Only after a few minutes, I noticed that the
> OLAP creates alot of database connections to the point of no db connection
> can be established anymore. As comparison, I have just restarted Ofbiz and
> Postgres yesterday at around 4pm, I saw that there are already 68 idle
> database connections, only 2 of which are used for the ofbiz database, and
> the rest for ofbizolap. Ofbiz is very lightly used. Is this normal?
>
> Ian Tabangay
>
Reply | Threaded
Open this post in threaded view
|

Re: Database Connections made by OLAP

rajsaini
I experienced the similar problem with 240+ connection limit on
PostgreSQL 8.3 and two OFbiz instances. I did not investigate the real
cause of the problem.

Raj

Jacques Le Roux wrote:

> I don't see any problems like that. Anyway, if you don't need OLAP
> simply comment it out in entityengine.xml...
>
> Jacques
>
> From: "ian tabangay" <[hidden email]>
>> Hi. I have deployed an ofbiz application (end of May build) on CentOS
>> 5 with
>> Postgresql 8.1 as my database. Only after a few minutes, I noticed
>> that the
>> OLAP creates alot of database connections to the point of no db
>> connection
>> can be established anymore. As comparison, I have just restarted
>> Ofbiz and
>> Postgres yesterday at around 4pm, I saw that there are already 68 idle
>> database connections, only 2 of which are used for the ofbiz
>> database, and
>> the rest for ofbizolap. Ofbiz is very lightly used. Is this normal?
>>
>> Ian Tabangay
>>
>