[GeoNetwork-devel] Losing indexing / db connections failing

GeoNetwork GeoNetwork Developer
,
1

I tried the users list and got no response so am hoping someone on the developer side can assist >

Is this a known issue? and/or if you can think of something we can do for troubleshooting (see first email below for details).

My system administrator tells me that the issue is: "Something holds up db connections and never lets it go. So the following connections will be rejected. GN uses default DBCP connection pool of Tomcat, which is very robust. I suspect it could be a bug of GN."

This is on version 2.8. It has been very stable for over a year and now this is starting. When it first started I needed to reboot about every week or two -- now it is failing within a couple of hours.

Kathy
_____________________________________
Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

________________________________________
From: Kathy Koch [kkoch@anonymised.com]
Sent: Thursday, August 14, 2014 10:31 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Losing indexing

I am using GN 2.8 and recently (last 2 months) it started losing its indexing -- a search will show only a small number of records or it will not search at all and give an error -- such that I have to do a restart after which point everything comes back (is searchable) and works as it should. It seems to be happening more and more frequently. I don't see anything in the logs that give me a clue other than when geoserver is unable to access the index.

I'm not sure what to even check for to troubleshoot. This is a production database and pretty urgent so if anyone has a suggestion please let me know. TIA

Kathy

------------------------------------------------------------------------------
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

2

Hi Kathy,

Yes, there is a known bug solved in 2.10 relayed to this. Can you test with latest stable (2.10.x) and see if this is solved?

If after trying with 2.10 it still fails, maybe it is related to the database configuration. Are you using postgres or postgis?

María.

El 18/08/2014 16:49, “Kathy Koch” <kkoch@anonymised.com> escribió:

I tried the users list and got no response so am hoping someone on the developer side can assist >

Is this a known issue? and/or if you can think of something we can do for troubleshooting (see first email below for details).

My system administrator tells me that the issue is: “Something holds up db connections and never lets it go. So the following connections will be rejected. GN uses default DBCP connection pool of Tomcat, which is very robust. I suspect it could be a bug of GN.”

This is on version 2.8. It has been very stable for over a year and now this is starting. When it first started I needed to reboot about every week or two – now it is failing within a couple of hours.

Kathy

Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

From: Kathy Koch [kkoch@anonymised.com]
Sent: Thursday, August 14, 2014 10:31 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Losing indexing

I am using GN 2.8 and recently (last 2 months) it started losing its indexing – a search will show only a small number of records or it will not search at all and give an error – such that I have to do a restart after which point everything comes back (is searchable) and works as it should. It seems to be happening more and more frequently. I don’t see anything in the logs that give me a clue other than when geoserver is unable to access the index.

I’m not sure what to even check for to troubleshoot. This is a production database and pretty urgent so if anyone has a suggestion please let me know. TIA

Kathy

GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

3

Can you point me to the information about the bug?

I don’t have 2.10 loaded so testing is not a simple thing and before I take that leap would like more documentation.

I am using postgres for the database.

Thanks!

Kathy

Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

From: María Arias de Reyna [delawen@anonymised.com31…]
Sent: Monday, August 18, 2014 4:06 PM
To: Kathy Koch
Cc: Devel geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Losing indexing / db connections failing

Hi Kathy,

Yes, there is a known bug solved in 2.10 relayed to this. Can you test with latest stable (2.10.x) and see if this is solved?

If after trying with 2.10 it still fails, maybe it is related to the database configuration. Are you using postgres or postgis?

María.

El 18/08/2014 16:49, “Kathy Koch” <kkoch@anonymised.com> escribió:

I tried the users list and got no response so am hoping someone on the developer side can assist >

Is this a known issue? and/or if you can think of something we can do for troubleshooting (see first email below for details).

My system administrator tells me that the issue is: “Something holds up db connections and never lets it go. So the following connections will be rejected. GN uses default DBCP connection pool of Tomcat, which is very robust. I suspect it could be a bug of GN.”

This is on version 2.8. It has been very stable for over a year and now this is starting. When it first started I needed to reboot about every week or two – now it is failing within a couple of hours.

Kathy

Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

From: Kathy Koch [kkoch@anonymised.com]
Sent: Thursday, August 14, 2014 10:31 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Losing indexing

I am using GN 2.8 and recently (last 2 months) it started losing its indexing – a search will show only a small number of records or it will not search at all and give an error – such that I have to do a restart after which point everything comes back (is searchable) and works as it should. It seems to be happening more and more frequently. I don’t see anything in the logs that give me a clue other than when geoserver is unable to access the index.

I’m not sure what to even check for to troubleshoot. This is a production database and pretty urgent so if anyone has a suggestion please let me know. TIA

Kathy

GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

4

On Mon, Aug 18, 2014 at 10:47 PM, Kathy Koch <kkoch@anonymised.com> wrote:

Can you point me to the information about the bug?

I don’t have 2.10 loaded so testing is not a simple thing and before I take that leap would like more documentation.

I am using postgres for the database.

Thanks!

Hi,

Using postgres is a good start.

The bug I am talking about was detected and fixed for the cases where the database is not “close” (networkingly speaking) to the geonetwork instance. It became worse if there was some firewall or router that handles connections in the middle.

The commit is here:

https://github.com/geonetwork/core-geonetwork/commit/07d489d32a2eedd318227567d33017932144064b

Regards,
María.

Can you point me to the information about the bug?

I don’t have 2.10 loaded so testing is not a simple thing and before I take that leap would like more documentation.

I am using postgres for the database.

Thanks!

Kathy

Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

From: María Arias de Reyna [delawen@anonymised.com]
Sent: Monday, August 18, 2014 4:06 PM
To: Kathy Koch
Cc: Devel geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Losing indexing / db connections failing

Hi Kathy,

Yes, there is a known bug solved in 2.10 relayed to this. Can you test with latest stable (2.10.x) and see if this is solved?

If after trying with 2.10 it still fails, maybe it is related to the database configuration. Are you using postgres or postgis?

María.

El 18/08/2014 16:49, “Kathy Koch” <kkoch@anonymised.com> escribió:

I tried the users list and got no response so am hoping someone on the developer side can assist >

Is this a known issue? and/or if you can think of something we can do for troubleshooting (see first email below for details).

My system administrator tells me that the issue is: “Something holds up db connections and never lets it go. So the following connections will be rejected. GN uses default DBCP connection pool of Tomcat, which is very robust. I suspect it could be a bug of GN.”

This is on version 2.8. It has been very stable for over a year and now this is starting. When it first started I needed to reboot about every week or two – now it is failing within a couple of hours.

Kathy

Kathy Koch
Data Curator
Contractor (LimnoTech / GLOS)
501 Avis Drive, Ann Arbor, MI 48108
Office: 734-332-1200 email:kkoch@anonymised.com
LimnoTech www.limno.com

From: Kathy Koch [kkoch@anonymised.com]
Sent: Thursday, August 14, 2014 10:31 AM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Losing indexing

I am using GN 2.8 and recently (last 2 months) it started losing its indexing – a search will show only a small number of records or it will not search at all and give an error – such that I have to do a restart after which point everything comes back (is searchable) and works as it should. It seems to be happening more and more frequently. I don’t see anything in the logs that give me a clue other than when geoserver is unable to access the index.

I’m not sure what to even check for to troubleshoot. This is a production database and pretty urgent so if anyone has a suggestion please let me know. TIA

Kathy

GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork