[GeoNetwork-users] DB connections aren't reused

GeoNetwork GeoNetwork User
1

Hello list,

Our GeoNetwork harvests two different servers (another GeoNetwork and an
ESRI GeoPortal), and each time it opens two new DB connections. When the
pool is full, I get errors like :

These are the DB connexion parameters :

There is no firewall between GeoNetwork and the postgresql server (they're
not on the same server, but both servers are in the same network). I just
tried the last 4 parameters in case it would help but it doesn't.

GeoNetwork's version is 2.10.3-0, deployed in tomcat6 with java6.

Any idea what's going on ? Or how I could get more information on why it
doesn't reuse the connections ?

Alain

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

2

Hi Alain,

I am having similar issues with the same error message. I suspect the error
message does not truly point to the problem. Did you find a solutions?

Cheers,
Byron

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5140385.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

3

Hello Byron,

I didn't find any solution to this problem. The postgresql server sees the
connections still open, but somehow GeoNetwork thinks they're closed.

The workaround I found is to restart GeoNetwork every 2 or 3 days using
crontab. I know it's not clean, but I didn't find anything else.

Have a nice day,

Alain

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5140411.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

4

Alain,

I notice that you did not set "maxOpenPreparedStatements" as suggested at:
http://geonetwork-opensource.org/manuals/2.10.3/eng/users/admin/advanced-configuration/index.html#database-configuration.

I have done so in my situation and copied the rest of the optional
connection parameters to be the same as yours. It will be a couple of days
before we know if this fixes it, but I will keep you posted.

Cheers,
Byron

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5140619.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

5

Thanks for the info. I tried to change it too and deactivated the crontab
job, I'll see if it helps.

Alain

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5140685.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

6

Well it ran for longer before falling over - about a week. Will look into
this further in the next couple of days.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5142829.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

7

On my side it didn't change anything, sorry.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5143481.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

8

Should be fixed in 2.10.4 - check out Harvesters consuming database connections · Issue #535 · geonetwork/core-geonetwork · GitHub

Cheers,
Simon
________________________________________
From: ByronCinNZ [cochranes4@anonymised.com]
Sent: Wednesday, 28 May 2014 8:36 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] DB connections aren't reused

Well it ran for longer before falling over - about a week. Will look into
this further in the next couple of days.

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5142829.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

9

Thanks Simon (and Byron),

I'll install it and test when the 2.10.4 is out.

Note: I'm still on 2.10.3 and after running a few harvesting jobs, I don't
see any "IDLE in transaction" when running ps -eaf | grep postgres, even if
I have several open connections in GeoNetwork web interface > Administration

System Information > Open Connections.

Have a nice day,

Alain

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5143903.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

10

SimonPigot wrote

Hi acangi,

Can you let me know whether you are using the JNDI pool please? If not,
please try with that (not sure if it will make any difference but it is
important to know which pool you are using). I would recommend the JNDI
pool if you're not using it.

Cheers,
Simon

I have always been using the default ApacheDBCPool.

I changed to JNDI pool, see config.xml (with my previous config commented
out) :

And my /etc/tomcat6/context.xml :

After restarting tomcat, I get an error :

Any idea ?

Alain

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/DB-connections-aren-t-reused-tp5132202p5146216.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.