[GeoNetwork-users] Geonetwork v2.4.2 - Getting MySQL Exception: "Lock wait timeout exceeded"

Hi List,

After installing Geonetwork v2.4.2, I'm getting the following error after
executing a few searches with the application:

The requested operation could not be performed.
SQLException : Lock wait timeout exceeded; try restarting transaction

After we get this error, the application is really slow and seems to be
having problem connecting to the database. I have to kill all geonetwork's
connection threads in MySQL Administrator to be able to use the application
correctly… until I get the error again.

Our metadata was all successfully added by Batch Import. Geonetwork v2.4.2
is installed in the following environment:

JRE 1.6
Tomcat 6
MySQL 5.5

Anyone having the same problem?

Thanks,
Kevin

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3972903.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

hi Kevin,

we had a problem that is *maybe* similar -- no more connections available
for our Postgres DB.

I've discussed this with Simon Pigot and Jose Garcia, and they've come up
with a fix in the new, asynchronous handling of updating popularity after
viewing/editing metadata - resources were not closed there, and now they
are.

This seems to have fixed it in our TEST environment although I cannot yet
say for sure as it's too new and we need to test more.

The fix was committed to trunk. It was not committed to the 2.4.x branch
until *now*, as I just did it. You could try building the 2.4.x branch and
see if your problem is solved. If you do, please let us know !

Kind regards
Heikki Doeleman

On Mon, Nov 9, 2009 at 2:24 PM, Kevin Boudreau <kevin.boudreau@anonymised.com>wrote:

Hi List,

After installing Geonetwork v2.4.2, I'm getting the following error after
executing a few searches with the application:

The requested operation could not be performed.
SQLException : Lock wait timeout exceeded; try restarting transaction

After we get this error, the application is really slow and seems to be
having problem connecting to the database. I have to kill all geonetwork's
connection threads in MySQL Administrator to be able to use the application
correctly… until I get the error again.

Our metadata was all successfully added by Batch Import. Geonetwork v2.4.2
is installed in the following environment:

JRE 1.6
Tomcat 6
MySQL 5.5

Anyone having the same problem?

Thanks,
Kevin

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3972903.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

heikki wrote:

hi Kevin,

we had a problem that is *maybe* similar -- no more connections available
for our Postgres DB.

I've discussed this with Simon Pigot and Jose Garcia, and they've come up
with a fix in the new, asynchronous handling of updating popularity after
viewing/editing metadata - resources were not closed there, and now they
are.

I have filed a bug related to database concurrency errors that I see whenever I attempt to harvest more than one target at the same time using mckoi or MySQL. Hopefully, this fix will also address the concurrency problem.

This seems to have fixed it in our TEST environment although I cannot yet
say for sure as it's too new and we need to test more.

The fix was committed to trunk. It was not committed to the 2.4.x branch
until *now*, as I just did it. You could try building the 2.4.x branch and
see if your problem is solved. If you do, please let us know !

Kind regards
Heikki Doeleman

On Mon, Nov 9, 2009 at 2:24 PM, Kevin Boudreau <kevin.boudreau@anonymised.com>wrote:

Hi List,

After installing Geonetwork v2.4.2, I'm getting the following error after
executing a few searches with the application:

The requested operation could not be performed.
SQLException : Lock wait timeout exceeded; try restarting transaction

After we get this error, the application is really slow and seems to be
having problem connecting to the database. I have to kill all geonetwork's
connection threads in MySQL Administrator to be able to use the application
correctly… until I get the error again.

Our metadata was all successfully added by Batch Import. Geonetwork v2.4.2
is installed in the following environment:

JRE 1.6
Tomcat 6
MySQL 5.5

Anyone having the same problem?

Thanks,
Kevin

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3972903.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

--
Douglas D. Nebert
Senior Advisor for Geospatial Technology, System-of-Systems Architect
FGDC Secretariat T:703 648 4151 F:703 648-5755 C:703 459-5860

Thank you for the quick response.

Do you have documentation on how to get this 2.4.x branch and build it
properly.

I usually download the installer from the website.

I have Eclipse installed and from the info found on the website I connected
with CVS to the following location:

Server: geonetwork.cvs.sourceforge.net
Repository folder: /cvsroot/geonetwork
User name: anonymous

But I'm not sure which one is the one you mentioned.

Thanks

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973590.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

Think you have to use SVN instead of CSV.
If I´m wrong please anybody correct me.

regrds
Sarah

Kevin Boudreau wrote:

Thank you for the quick response.

Do you have documentation on how to get this 2.4.x branch and build it
properly.

I usually download the installer from the website.

I have Eclipse installed and from the info found on the website I
connected with CVS to the following location:

Server: geonetwork.cvs.sourceforge.net
Repository folder: /cvsroot/geonetwork
User name: anonymous

But I'm not sure which one is the one you mentioned.

Thanks

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

yes, use SVN, not CVS.

The 2.4.x branch is at
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x.

After downloading, type "ant" in a command prompt in the location
<download-location>/installer. It produces an executable installer kiek the
one you're used to downloading.

Kind regards
Heikki Doeleman

On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com> wrote:

Think you have to use SVN instead of CSV.
If I´m wrong please anybody correct me.

regrds
Sarah

Kevin Boudreau wrote:
>
> Thank you for the quick response.
>
> Do you have documentation on how to get this 2.4.x branch and build it
> properly.
>
> I usually download the installer from the website.
>
> I have Eclipse installed and from the info found on the website I
> connected with CVS to the following location:
>
> Server: geonetwork.cvs.sourceforge.net
> Repository folder: /cvsroot/geonetwork
> User name: anonymous
>
> But I'm not sure which one is the one you mentioned.
>
> Thanks
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

The latest code from the SVN 2.4.x branch seems to have fixed the problem.

Thank you for your help!

Heikki Doeleman wrote:

yes, use SVN, not CVS.

The 2.4.x branch is at
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x.

After downloading, type "ant" in a command prompt in the location
<download-location>/installer. It produces an executable installer kiek
the
one you're used to downloading.

Kind regards
Heikki Doeleman

On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com> wrote:

Think you have to use SVN instead of CSV.
If I´m wrong please anybody correct me.

regrds
Sarah

Kevin Boudreau wrote:
>
> Thank you for the quick response.
>
> Do you have documentation on how to get this 2.4.x branch and build it
> properly.
>
> I usually download the installer from the website.
>
> I have Eclipse installed and from the info found on the website I
> connected with CVS to the following location:
>
> Server: geonetwork.cvs.sourceforge.net
> Repository folder: /cvsroot/geonetwork
> User name: anonymous
>
> But I'm not sure which one is the one you mentioned.
>
> Thanks
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and
focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

thank you for lettings us know your result !

Kind regards
Heikki Doeleman

On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau <kevin.boudreau@anonymised.com>wrote:

The latest code from the SVN 2.4.x branch seems to have fixed the problem.

Thank you for your help!

Heikki Doeleman wrote:
>
> yes, use SVN, not CVS.
>
> The 2.4.x branch is at
> https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
.
>
> After downloading, type "ant" in a command prompt in the location
> <download-location>/installer. It produces an executable installer kiek
> the
> one you're used to downloading.
>
> Kind regards
> Heikki Doeleman
>
>
>
> On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com> wrote:
>
>>
>> Think you have to use SVN instead of CSV.
>> If I´m wrong please anybody correct me.
>>
>> regrds
>> Sarah
>>
>>
>> Kevin Boudreau wrote:
>> >
>> > Thank you for the quick response.
>> >
>> > Do you have documentation on how to get this 2.4.x branch and build it
>> > properly.
>> >
>> > I usually download the installer from the website.
>> >
>> > I have Eclipse installed and from the info found on the website I
>> > connected with CVS to the following location:
>> >
>> > Server: geonetwork.cvs.sourceforge.net
>> > Repository folder: /cvsroot/geonetwork
>> > User name: anonymous
>> >
>> > But I'm not sure which one is the one you mentioned.
>> >
>> > Thanks
>> >
>> >
>>
>> --
>> View this message in context:
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>
>>
>>
------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> 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
>>
>
------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and
focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> 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
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

Hi list,

I would like to know if this problem concerns only version 2.4.2?
I am using v. 2.4.2 and PG and have this same problem.
I was thinking changing PG for MySQL but I see that's not a good idea.
So now I am thinking changing my GNO version.
I remember not having this problem with version 2.4. What can I expect with
version 2.4.1?

Thanks.
Pierre

A. K. L. Cheung wrote:

The latest SVN cured the same problem in my implementation as well!

Only that I still need to change the GEOSERVER_DATA_DIR thing...

Thanks!

Alan

Heikki Doeleman wrote:

thank you for lettings us know your result !

Kind regards
Heikki Doeleman

On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau
<kevin.boudreau@anonymised.com>wrote:

The latest code from the SVN 2.4.x branch seems to have fixed the
problem.

Thank you for your help!

Heikki Doeleman wrote:
>
> yes, use SVN, not CVS.
>
> The 2.4.x branch is at
>
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
.
>
> After downloading, type "ant" in a command prompt in the location
> <download-location>/installer. It produces an executable installer
kiek
> the
> one you're used to downloading.
>
> Kind regards
> Heikki Doeleman
>
>
>
> On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com> wrote:
>
>>
>> Think you have to use SVN instead of CSV.
>> If I´m wrong please anybody correct me.
>>
>> regrds
>> Sarah
>>
>>
>> Kevin Boudreau wrote:
>> >
>> > Thank you for the quick response.
>> >
>> > Do you have documentation on how to get this 2.4.x branch and build
it
>> > properly.
>> >
>> > I usually download the installer from the website.
>> >
>> > I have Eclipse installed and from the info found on the website I
>> > connected with CVS to the following location:
>> >
>> > Server: geonetwork.cvs.sourceforge.net
>> > Repository folder: /cvsroot/geonetwork
>> > User name: anonymous
>> >
>> > But I'm not sure which one is the one you mentioned.
>> >
>> > Thanks
>> >
>> >
>>
>> --
>> View this message in context:
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>
>>
>>
------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> 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
>>
>
------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and
focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> 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
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and
focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and
focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100506.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

hello Pierre,

as far as I can tell the fix applies to a function that was introduced in
2.4. I guess you do not want to work with an unreleased version you'd need
to build yourself, hence this question?

Kind regards
Heikki Doeleman

On Wed, Dec 2, 2009 at 4:49 PM, pierre vernier
<pierre.vernier@anonymised.com>wrote:

Hi list,

I would like to know if this problem concerns only version 2.4.2?
I am using v. 2.4.2 and PG and have this same problem.
I was thinking changing PG for MySQL but I see that's not a good idea.
So now I am thinking changing my GNO version.
I remember not having this problem with version 2.4. What can I expect with
version 2.4.1?

Thanks.
Pierre

A. K. L. Cheung wrote:
>
> The latest SVN cured the same problem in my implementation as well!
>
> Only that I still need to change the GEOSERVER_DATA_DIR thing...
>
> Thanks!
>
> Alan
>
>
> Heikki Doeleman wrote:
>>
>> thank you for lettings us know your result !
>>
>> Kind regards
>> Heikki Doeleman
>>
>>
>>
>> On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau
>> <kevin.boudreau@anonymised.com>wrote:
>>
>>>
>>> The latest code from the SVN 2.4.x branch seems to have fixed the
>>> problem.
>>>
>>> Thank you for your help!
>>>
>>>
>>> Heikki Doeleman wrote:
>>> >
>>> > yes, use SVN, not CVS.
>>> >
>>> > The 2.4.x branch is at
>>> >
>>>
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
>>> .
>>> >
>>> > After downloading, type "ant" in a command prompt in the location
>>> > <download-location>/installer. It produces an executable installer
>>> kiek
>>> > the
>>> > one you're used to downloading.
>>> >
>>> > Kind regards
>>> > Heikki Doeleman
>>> >
>>> >
>>> >
>>> > On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com> wrote:
>>> >
>>> >>
>>> >> Think you have to use SVN instead of CSV.
>>> >> If I´m wrong please anybody correct me.
>>> >>
>>> >> regrds
>>> >> Sarah
>>> >>
>>> >>
>>> >> Kevin Boudreau wrote:
>>> >> >
>>> >> > Thank you for the quick response.
>>> >> >
>>> >> > Do you have documentation on how to get this 2.4.x branch and
build
>>> it
>>> >> > properly.
>>> >> >
>>> >> > I usually download the installer from the website.
>>> >> >
>>> >> > I have Eclipse installed and from the info found on the website I
>>> >> > connected with CVS to the following location:
>>> >> >
>>> >> > Server: geonetwork.cvs.sourceforge.net
>>> >> > Repository folder: /cvsroot/geonetwork
>>> >> > User name: anonymous
>>> >> >
>>> >> > But I'm not sure which one is the one you mentioned.
>>> >> >
>>> >> > Thanks
>>> >> >
>>> >> >
>>> >>
>>> >> --
>>> >> View this message in context:
>>> >>
>>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>>> >> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>> >>
>>> >>
>>> >>
>>>
------------------------------------------------------------------------------
>>> >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>> >> 30-Day
>>> >> trial. Simplify your report design, integration and deployment - and
>>> >> focus
>>> >> on
>>> >> what you do best, core application coding. Discover what's new with
>>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> >> _______________________________________________
>>> >> 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
>>> >>
>>> >
>>>
------------------------------------------------------------------------------
>>> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>> > 30-Day
>>> > trial. Simplify your report design, integration and deployment - and
>>> focus
>>> > on
>>> > what you do best, core application coding. Discover what's new with
>>> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> > _______________________________________________
>>> > 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
>>> >
>>> >
>>>
>>> --
>>> View this message in context:
>>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
>>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>>
>>>
>>>
------------------------------------------------------------------------------
>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>> 30-Day
>>> trial. Simplify your report design, integration and deployment - and
>>> focus
>>> on
>>> what you do best, core application coding. Discover what's new with
>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> _______________________________________________
>>> 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
>>>
>>
------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> 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
>>
>>
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100506.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

Hi Heikki,

It's not that I don't want to work with an unreleased version I'd need to
build myself but rather that I didn't manage to as I am not very familiar
with eclipse.
This is why I was thinking downgrading my version.

Pierre

Heikki Doeleman wrote:

hello Pierre,

as far as I can tell the fix applies to a function that was introduced in
2.4. I guess you do not want to work with an unreleased version you'd need
to build yourself, hence this question?

Kind regards
Heikki Doeleman

On Wed, Dec 2, 2009 at 4:49 PM, pierre vernier
<pierre.vernier@anonymised.com>wrote:

Hi list,

I would like to know if this problem concerns only version 2.4.2?
I am using v. 2.4.2 and PG and have this same problem.
I was thinking changing PG for MySQL but I see that's not a good idea.
So now I am thinking changing my GNO version.
I remember not having this problem with version 2.4. What can I expect
with
version 2.4.1?

Thanks.
Pierre

A. K. L. Cheung wrote:
>
> The latest SVN cured the same problem in my implementation as well!
>
> Only that I still need to change the GEOSERVER_DATA_DIR thing...
>
> Thanks!
>
> Alan
>
>
> Heikki Doeleman wrote:
>>
>> thank you for lettings us know your result !
>>
>> Kind regards
>> Heikki Doeleman
>>
>>
>>
>> On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau
>> <kevin.boudreau@anonymised.com>wrote:
>>
>>>
>>> The latest code from the SVN 2.4.x branch seems to have fixed the
>>> problem.
>>>
>>> Thank you for your help!
>>>
>>>
>>> Heikki Doeleman wrote:
>>> >
>>> > yes, use SVN, not CVS.
>>> >
>>> > The 2.4.x branch is at
>>> >
>>>
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
>>> .
>>> >
>>> > After downloading, type "ant" in a command prompt in the location
>>> > <download-location>/installer. It produces an executable installer
>>> kiek
>>> > the
>>> > one you're used to downloading.
>>> >
>>> > Kind regards
>>> > Heikki Doeleman
>>> >
>>> >
>>> >
>>> > On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com>
wrote:
>>> >
>>> >>
>>> >> Think you have to use SVN instead of CSV.
>>> >> If I´m wrong please anybody correct me.
>>> >>
>>> >> regrds
>>> >> Sarah
>>> >>
>>> >>
>>> >> Kevin Boudreau wrote:
>>> >> >
>>> >> > Thank you for the quick response.
>>> >> >
>>> >> > Do you have documentation on how to get this 2.4.x branch and
build
>>> it
>>> >> > properly.
>>> >> >
>>> >> > I usually download the installer from the website.
>>> >> >
>>> >> > I have Eclipse installed and from the info found on the website
I
>>> >> > connected with CVS to the following location:
>>> >> >
>>> >> > Server: geonetwork.cvs.sourceforge.net
>>> >> > Repository folder: /cvsroot/geonetwork
>>> >> > User name: anonymous
>>> >> >
>>> >> > But I'm not sure which one is the one you mentioned.
>>> >> >
>>> >> > Thanks
>>> >> >
>>> >> >
>>> >>
>>> >> --
>>> >> View this message in context:
>>> >>
>>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>>> >> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>> >>
>>> >>
>>> >>
>>>
------------------------------------------------------------------------------
>>> >> Let Crystal Reports handle the reporting - Free Crystal Reports
2008
>>> >> 30-Day
>>> >> trial. Simplify your report design, integration and deployment -
and
>>> >> focus
>>> >> on
>>> >> what you do best, core application coding. Discover what's new
with
>>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> >> _______________________________________________
>>> >> 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
>>> >>
>>> >
>>>
------------------------------------------------------------------------------
>>> > Let Crystal Reports handle the reporting - Free Crystal Reports
2008
>>> > 30-Day
>>> > trial. Simplify your report design, integration and deployment -
and
>>> focus
>>> > on
>>> > what you do best, core application coding. Discover what's new with
>>> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> > _______________________________________________
>>> > 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
>>> >
>>> >
>>>
>>> --
>>> View this message in context:
>>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
>>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>>
>>>
>>>
------------------------------------------------------------------------------
>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>>> 30-Day
>>> trial. Simplify your report design, integration and deployment - and
>>> focus
>>> on
>>> what you do best, core application coding. Discover what's new with
>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>>> _______________________________________________
>>> 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
>>>
>>
------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> 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
>>
>>
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100506.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100639.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

okay,

in that case: you do not need to work with Eclipse at all, it is quite a
simple few steps you could take.

You need an SVN client; if you are on Windows, I recommend TortoiseSVN,
which is free.

Using the SVN client you can download the source code. In this case you'd
need to point it to the SVN repository at
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x. No
need to authenticate or anything, just download the latest sources from
there (called "HEAD" in SVN).

Then to build it, you need to have Ant installed. Then you can now make your
own build by opening a command prompt (DOS) and going to the directory
<downloaded-sources>/installer, and there type "ant" (maybe you need to
specify the full path to "ant.bat", which is in the directory where you
installed Ant).

Now the build should be running, it may take some 10 minutes. When finished,
there's a directory <downloaded-sources>/geonetwork-2.4.2 where you find the
executable installer.

Hopefully this helps,
kind regards
Heikki Doeleman

On Wed, Dec 2, 2009 at 5:11 PM, pierre vernier
<pierre.vernier@anonymised.com>wrote:

Hi Heikki,

It's not that I don't want to work with an unreleased version I'd need to
build myself but rather that I didn't manage to as I am not very familiar
with eclipse.
This is why I was thinking downgrading my version.

Pierre

Heikki Doeleman wrote:
>
> hello Pierre,
>
> as far as I can tell the fix applies to a function that was introduced in
> 2.4. I guess you do not want to work with an unreleased version you'd
need
> to build yourself, hence this question?
>
> Kind regards
> Heikki Doeleman
>
>
>
> On Wed, Dec 2, 2009 at 4:49 PM, pierre vernier
> <pierre.vernier@anonymised.com>wrote:
>
>>
>> Hi list,
>>
>> I would like to know if this problem concerns only version 2.4.2?
>> I am using v. 2.4.2 and PG and have this same problem.
>> I was thinking changing PG for MySQL but I see that's not a good idea.
>> So now I am thinking changing my GNO version.
>> I remember not having this problem with version 2.4. What can I expect
>> with
>> version 2.4.1?
>>
>> Thanks.
>> Pierre
>>
>>
>>
>>
>>
>> A. K. L. Cheung wrote:
>> >
>> > The latest SVN cured the same problem in my implementation as well!
>> >
>> > Only that I still need to change the GEOSERVER_DATA_DIR thing...
>> >
>> > Thanks!
>> >
>> > Alan
>> >
>> >
>> > Heikki Doeleman wrote:
>> >>
>> >> thank you for lettings us know your result !
>> >>
>> >> Kind regards
>> >> Heikki Doeleman
>> >>
>> >>
>> >>
>> >> On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau
>> >> <kevin.boudreau@anonymised.com>wrote:
>> >>
>> >>>
>> >>> The latest code from the SVN 2.4.x branch seems to have fixed the
>> >>> problem.
>> >>>
>> >>> Thank you for your help!
>> >>>
>> >>>
>> >>> Heikki Doeleman wrote:
>> >>> >
>> >>> > yes, use SVN, not CVS.
>> >>> >
>> >>> > The 2.4.x branch is at
>> >>> >
>> >>>
>>
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
>> >>> .
>> >>> >
>> >>> > After downloading, type "ant" in a command prompt in the location
>> >>> > <download-location>/installer. It produces an executable installer
>> >>> kiek
>> >>> > the
>> >>> > one you're used to downloading.
>> >>> >
>> >>> > Kind regards
>> >>> > Heikki Doeleman
>> >>> >
>> >>> >
>> >>> >
>> >>> > On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com>
>> wrote:
>> >>> >
>> >>> >>
>> >>> >> Think you have to use SVN instead of CSV.
>> >>> >> If I´m wrong please anybody correct me.
>> >>> >>
>> >>> >> regrds
>> >>> >> Sarah
>> >>> >>
>> >>> >>
>> >>> >> Kevin Boudreau wrote:
>> >>> >> >
>> >>> >> > Thank you for the quick response.
>> >>> >> >
>> >>> >> > Do you have documentation on how to get this 2.4.x branch and
>> build
>> >>> it
>> >>> >> > properly.
>> >>> >> >
>> >>> >> > I usually download the installer from the website.
>> >>> >> >
>> >>> >> > I have Eclipse installed and from the info found on the website
>> I
>> >>> >> > connected with CVS to the following location:
>> >>> >> >
>> >>> >> > Server: geonetwork.cvs.sourceforge.net
>> >>> >> > Repository folder: /cvsroot/geonetwork
>> >>> >> > User name: anonymous
>> >>> >> >
>> >>> >> > But I'm not sure which one is the one you mentioned.
>> >>> >> >
>> >>> >> > Thanks
>> >>> >> >
>> >>> >> >
>> >>> >>
>> >>> >> --
>> >>> >> View this message in context:
>> >>> >>
>> >>>
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>> >>> >> Sent from the GeoNetwork users mailing list archive at
Nabble.com.
>> >>> >>
>> >>> >>
>> >>> >>
>> >>>
>>
------------------------------------------------------------------------------
>> >>> >> Let Crystal Reports handle the reporting - Free Crystal Reports
>> 2008
>> >>> >> 30-Day
>> >>> >> trial. Simplify your report design, integration and deployment -
>> and
>> >>> >> focus
>> >>> >> on
>> >>> >> what you do best, core application coding. Discover what's new
>> with
>> >>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> >> _______________________________________________
>> >>> >> 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
>> >>> >>
>> >>> >
>> >>>
>>
------------------------------------------------------------------------------
>> >>> > Let Crystal Reports handle the reporting - Free Crystal Reports
>> 2008
>> >>> > 30-Day
>> >>> > trial. Simplify your report design, integration and deployment -
>> and
>> >>> focus
>> >>> > on
>> >>> > what you do best, core application coding. Discover what's new
with
>> >>> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> > _______________________________________________
>> >>> > 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
>> >>> >
>> >>> >
>> >>>
>> >>> --
>> >>> View this message in context:
>> >>>
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
>> >>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>> >>>
>> >>>
>> >>>
>>
------------------------------------------------------------------------------
>> >>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> >>> 30-Day
>> >>> trial. Simplify your report design, integration and deployment - and
>> >>> focus
>> >>> on
>> >>> what you do best, core application coding. Discover what's new with
>> >>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> _______________________________________________
>> >>> 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
>> >>>
>> >>
>>
------------------------------------------------------------------------------
>> >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> >> 30-Day
>> >> trial. Simplify your report design, integration and deployment - and
>> >> focus on
>> >> what you do best, core application coding. Discover what's new with
>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >> _______________________________________________
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100506.html
>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>
>>
>>
------------------------------------------------------------------------------
>> Join us December 9, 2009 for the Red Hat Virtual Experience,
>> a free event focused on virtualization and cloud computing.
>> Attend in-depth sessions from your desk. Your couch. Anywhere.
>> http://p.sf.net/sfu/redhat-sfdev2dev
>> _______________________________________________
>> 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
>>
>
------------------------------------------------------------------------------
> Join us December 9, 2009 for the Red Hat Virtual Experience,
> a free event focused on virtualization and cloud computing.
> Attend in-depth sessions from your desk. Your couch. Anywhere.
> http://p.sf.net/sfu/redhat-sfdev2dev
> _______________________________________________
> 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
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100639.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

Heikki,

It worked! thank you so much!

I am now installing GNO from the new installer created from sources. I will
test later if the problem with the database (PG in my case) is gone.

Again thank you for your time and advices!
Pierre

Heikki Doeleman wrote:

okay,

in that case: you do not need to work with Eclipse at all, it is quite a
simple few steps you could take.

You need an SVN client; if you are on Windows, I recommend TortoiseSVN,
which is free.

Using the SVN client you can download the source code. In this case you'd
need to point it to the SVN repository at
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x.
No
need to authenticate or anything, just download the latest sources from
there (called "HEAD" in SVN).

Then to build it, you need to have Ant installed. Then you can now make
your
own build by opening a command prompt (DOS) and going to the directory
<downloaded-sources>/installer, and there type "ant" (maybe you need to
specify the full path to "ant.bat", which is in the directory where you
installed Ant).

Now the build should be running, it may take some 10 minutes. When
finished,
there's a directory <downloaded-sources>/geonetwork-2.4.2 where you find
the
executable installer.

Hopefully this helps,
kind regards
Heikki Doeleman

On Wed, Dec 2, 2009 at 5:11 PM, pierre vernier
<pierre.vernier@anonymised.com>wrote:

Hi Heikki,

It's not that I don't want to work with an unreleased version I'd need to
build myself but rather that I didn't manage to as I am not very familiar
with eclipse.
This is why I was thinking downgrading my version.

Pierre

Heikki Doeleman wrote:
>
> hello Pierre,
>
> as far as I can tell the fix applies to a function that was introduced
in
> 2.4. I guess you do not want to work with an unreleased version you'd
need
> to build yourself, hence this question?
>
> Kind regards
> Heikki Doeleman
>
>
>
> On Wed, Dec 2, 2009 at 4:49 PM, pierre vernier
> <pierre.vernier@anonymised.com>wrote:
>
>>
>> Hi list,
>>
>> I would like to know if this problem concerns only version 2.4.2?
>> I am using v. 2.4.2 and PG and have this same problem.
>> I was thinking changing PG for MySQL but I see that's not a good idea.
>> So now I am thinking changing my GNO version.
>> I remember not having this problem with version 2.4. What can I expect
>> with
>> version 2.4.1?
>>
>> Thanks.
>> Pierre
>>
>>
>>
>>
>>
>> A. K. L. Cheung wrote:
>> >
>> > The latest SVN cured the same problem in my implementation as well!
>> >
>> > Only that I still need to change the GEOSERVER_DATA_DIR thing...
>> >
>> > Thanks!
>> >
>> > Alan
>> >
>> >
>> > Heikki Doeleman wrote:
>> >>
>> >> thank you for lettings us know your result !
>> >>
>> >> Kind regards
>> >> Heikki Doeleman
>> >>
>> >>
>> >>
>> >> On Mon, Nov 16, 2009 at 1:33 PM, Kevin Boudreau
>> >> <kevin.boudreau@anonymised.com>wrote:
>> >>
>> >>>
>> >>> The latest code from the SVN 2.4.x branch seems to have fixed the
>> >>> problem.
>> >>>
>> >>> Thank you for your help!
>> >>>
>> >>>
>> >>> Heikki Doeleman wrote:
>> >>> >
>> >>> > yes, use SVN, not CVS.
>> >>> >
>> >>> > The 2.4.x branch is at
>> >>> >
>> >>>
>>
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.4.x
>> >>> .
>> >>> >
>> >>> > After downloading, type "ant" in a command prompt in the
location
>> >>> > <download-location>/installer. It produces an executable
installer
>> >>> kiek
>> >>> > the
>> >>> > one you're used to downloading.
>> >>> >
>> >>> > Kind regards
>> >>> > Heikki Doeleman
>> >>> >
>> >>> >
>> >>> >
>> >>> > On Mon, Nov 9, 2009 at 4:28 PM, Sarah_S <Sarah_flip@anonymised.com>
>> wrote:
>> >>> >
>> >>> >>
>> >>> >> Think you have to use SVN instead of CSV.
>> >>> >> If I´m wrong please anybody correct me.
>> >>> >>
>> >>> >> regrds
>> >>> >> Sarah
>> >>> >>
>> >>> >>
>> >>> >> Kevin Boudreau wrote:
>> >>> >> >
>> >>> >> > Thank you for the quick response.
>> >>> >> >
>> >>> >> > Do you have documentation on how to get this 2.4.x branch and
>> build
>> >>> it
>> >>> >> > properly.
>> >>> >> >
>> >>> >> > I usually download the installer from the website.
>> >>> >> >
>> >>> >> > I have Eclipse installed and from the info found on the
website
>> I
>> >>> >> > connected with CVS to the following location:
>> >>> >> >
>> >>> >> > Server: geonetwork.cvs.sourceforge.net
>> >>> >> > Repository folder: /cvsroot/geonetwork
>> >>> >> > User name: anonymous
>> >>> >> >
>> >>> >> > But I'm not sure which one is the one you mentioned.
>> >>> >> >
>> >>> >> > Thanks
>> >>> >> >
>> >>> >> >
>> >>> >>
>> >>> >> --
>> >>> >> View this message in context:
>> >>> >>
>> >>>
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p3973681.html
>> >>> >> Sent from the GeoNetwork users mailing list archive at
Nabble.com.
>> >>> >>
>> >>> >>
>> >>> >>
>> >>>
>>
------------------------------------------------------------------------------
>> >>> >> Let Crystal Reports handle the reporting - Free Crystal Reports
>> 2008
>> >>> >> 30-Day
>> >>> >> trial. Simplify your report design, integration and deployment
-
>> and
>> >>> >> focus
>> >>> >> on
>> >>> >> what you do best, core application coding. Discover what's new
>> with
>> >>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> >> _______________________________________________
>> >>> >> 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
>> >>> >>
>> >>> >
>> >>>
>>
------------------------------------------------------------------------------
>> >>> > Let Crystal Reports handle the reporting - Free Crystal Reports
>> 2008
>> >>> > 30-Day
>> >>> > trial. Simplify your report design, integration and deployment -
>> and
>> >>> focus
>> >>> > on
>> >>> > what you do best, core application coding. Discover what's new
with
>> >>> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> > _______________________________________________
>> >>> > 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
>> >>> >
>> >>> >
>> >>>
>> >>> --
>> >>> View this message in context:
>> >>>
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4011750.html
>> >>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>> >>>
>> >>>
>> >>>
>>
------------------------------------------------------------------------------
>> >>> Let Crystal Reports handle the reporting - Free Crystal Reports
2008
>> >>> 30-Day
>> >>> trial. Simplify your report design, integration and deployment -
and
>> >>> focus
>> >>> on
>> >>> what you do best, core application coding. Discover what's new
with
>> >>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >>> _______________________________________________
>> >>> 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
>> >>>
>> >>
>>
------------------------------------------------------------------------------
>> >> Let Crystal Reports handle the reporting - Free Crystal Reports
2008
>> >> 30-Day
>> >> trial. Simplify your report design, integration and deployment -
and
>> >> focus on
>> >> what you do best, core application coding. Discover what's new with
>> >> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> >> _______________________________________________
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>>
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100506.html
>> Sent from the GeoNetwork users mailing list archive at Nabble.com.
>>
>>
>>
------------------------------------------------------------------------------
>> Join us December 9, 2009 for the Red Hat Virtual Experience,
>> a free event focused on virtualization and cloud computing.
>> Attend in-depth sessions from your desk. Your couch. Anywhere.
>> http://p.sf.net/sfu/redhat-sfdev2dev
>> _______________________________________________
>> 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
>>
>
------------------------------------------------------------------------------
> Join us December 9, 2009 for the Red Hat Virtual Experience,
> a free event focused on virtualization and cloud computing.
> Attend in-depth sessions from your desk. Your couch. Anywhere.
> http://p.sf.net/sfu/redhat-sfdev2dev
> _______________________________________________
> 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
>
>

--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4100639.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
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

--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4103040.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

Thank you for your explanations.

Having installed the 2.4.2 version I have had the same timeout problems and
slow response times as described above. I am using a MySQL database. I
compiled and installed the 2.4.x (head) version from the repositiries and it
solved the problems. Now I wonder...

1. The 2.4.x version is not released and I dont know what kind of trouble
this could possibly result in?
2. I could use an earlier version of GeoNetwork, but I am not sure how far I
should go back (2.4.0?)
3. Would it be possible to only replace the "not functional" coding in the
2.4.2 installation.

Any ideas or recommendation would be mostly welcome.
Kind regards
Hans
--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4674401.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

hi Hans,

1. Yes, it's not a release version. However I think several bugs in the
GN242 release have been fixed, so that chances are the GN24x-HEAD is
actually better than the last release. Some of the "bigger" and more risky
changes for the next release usually go first in trunk. Of course it is
always possible that there are undetected new bugs, you never know.

2. I think you'd need to go back to GN2.2 in that case

3. Sure, you could grab the source of the GN242 release and apply only this
fix to that.

If I were you I'd take the chance and use GN24x-HEAD, while noting the SVN
revision number you use.

My 2¢,

kind regards
Heikki Doeleman

On Thu, Mar 4, 2010 at 3:01 PM, Hans Mose Jensen <hans.jensen@anonymised.com>wrote:

Thank you for your explanations.

Having installed the 2.4.2 version I have had the same timeout problems and
slow response times as described above. I am using a MySQL database. I
compiled and installed the 2.4.x (head) version from the repositiries and
it
solved the problems. Now I wonder...

1. The 2.4.x version is not released and I dont know what kind of trouble
this could possibly result in?
2. I could use an earlier version of GeoNetwork, but I am not sure how far
I
should go back (2.4.0?)
3. Would it be possible to only replace the "not functional" coding in the
2.4.2 installation.

Any ideas or recommendation would be mostly welcome.
Kind regards
Hans
--
View this message in context:
http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4674401.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
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

Thanks Heikki
for your advice and fast reply

I think I will follow your advice and use the head version.

Best regards
Hans
--
View this message in context: http://n2.nabble.com/Geonetwork-v2-4-2-Getting-MySQL-Exception-Lock-wait-timeout-exceeded-tp3972903p4674634.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.