[Geoserver-devel] Oracle performance problems after upgrade from 2.4 to 2.6

Hi,

We were running 2.4.3 here with some Oracle layers, all doing fine.
Geoserver in Tomcat 7.0.56 on Windows (JRE7)
It's a Oracle spatial 10.2.0.5.0 db on a different (linux?) server.

We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
performance is much lower compared to 2.4.3
A test table with one record, performance from 0.5 goes up to several
seconds.

Tested by downgrading to 2.4.3 again, and performance is back again.

In both situations (2.4 and 2.6) I enabled verbose logging with the
following result: attached as log.txt

I'm not an experienced log reader for geoserver logs, but to me it looks
like that with 2.6 several connections are made (compared to 2.4) adding
up to several seconds (for this table with one geometry in it)...

Can somebody help me with this, or confirm behaviour like this?

Both geoservers have their own oracle extentions.
Testing by swapping geoserver-dirs in the webapps dir.

TIA & Regards,

Richard Duivenvoorde

(attachments)

log.txt (17.2 KB)

n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde <rdmailings@anonymised.com>
wrote:

Hi,

We were running 2.4.3 here with some Oracle layers, all doing fine.
Geoserver in Tomcat 7.0.56 on Windows (JRE7)
It's a Oracle spatial 10.2.0.5.0 db on a different (linux?) server.

We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
performance is much lower compared to 2.4.3
A test table with one record, performance from 0.5 goes up to several
seconds.

Tested by downgrading to 2.4.3 again, and performance is back again.

In both situations (2.4 and 2.6) I enabled verbose logging with the
following result: attached as log.txt

I'm not an experienced log reader for geoserver logs, but to me it looks
like that with 2.6 several connections are made (compared to 2.4) adding
up to several seconds (for this table with one geometry in it)...

Can somebody help me with this, or confirm behaviour like this?

Yes, we know, we have a fix. Can you try 2.6.x nightlies?
http://ares.boundlessgeo.com/geoserver/2.6.x/

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalitĂ  indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalitĂ  diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

On 23-10-14 16:57, Andrea Aime wrote:

n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde
    We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
    performance is much lower compared to 2.4.3

    Can somebody help me with this, or confirm behaviour like this?

Yes, we know, we have a fix. Can you try 2.6.x nightlies?
http://ares.boundlessgeo.com/geoserver/2.6.x/

Ouch, yes, that is better... see the log.txt attached.

Good that it is fixed, should have test this here earlier :frowning:

Any planning for a 2.6.1 release ?

Thanks,

Richard Duivenvoorde

(attachments)

log.txt (9.09 KB)

On Thu, Oct 23, 2014 at 5:27 PM, Richard Duivenvoorde <rdmailings@anonymised.com.>
wrote:

On 23-10-14 16:57, Andrea Aime wrote:
> n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde
> We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
> performance is much lower compared to 2.4.3
>
> Can somebody help me with this, or confirm behaviour like this?
>
> Yes, we know, we have a fix. Can you try 2.6.x nightlies?
> http://ares.boundlessgeo.com/geoserver/2.6.x/

Ouch, yes, that is better... see the log.txt attached.

Good that it is fixed, should have test this here earlier :frowning:

Any planning for a 2.6.1 release ?

The regular release is planned for next month, Jody kind of wanted to
make a emergency 2.6.1, but not sure if/when that is going to happen.

I've been trying to make 2.5.3 since the beginning of the week but I'm
so stuffed of work that I'm having troubles getting it done, so I can
relate....

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalitĂ  indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalitĂ  diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

https://github.com/geoserver/geoserver/wiki/Release-Schedule

indicative but informative :slight_smile:

Regards,
Simone Giannecchini

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate.
Il loro utilizzo è consentito esclusivamente al destinatario del
messaggio, per le finalitĂ  indicate nel messaggio stesso. Qualora
riceviate questo messaggio senza esserne il destinatario, Vi preghiamo
cortesemente di darcene notizia via e-mail e di procedere alla
distruzione del messaggio stesso, cancellandolo dal Vostro sistema.
Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalitĂ 
diverse, costituisce comportamento contrario ai principi dettati dal
D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely
for the attention and use of the named addressee(s) and may be
confidential or proprietary in nature or covered by the provisions of
privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New
Data Protection Code).Any use not in accord with its purpose, any
disclosure, reproduction, copying, distribution, or either
dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the
intended recipient, please contact immediately the sender by
telephone, fax or e-mail and delete the information in this message
that has been received in error. The sender does not give any warranty
or accept liability as the content, accuracy or completeness of sent
messages and accepts no responsibility for changes made after they
were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.

On Thu, Oct 23, 2014 at 5:27 PM, Richard Duivenvoorde
<rdmailings@anonymised.com> wrote:

On 23-10-14 16:57, Andrea Aime wrote:

n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde
    We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
    performance is much lower compared to 2.4.3

    Can somebody help me with this, or confirm behaviour like this?

Yes, we know, we have a fix. Can you try 2.6.x nightlies?
http://ares.boundlessgeo.com/geoserver/2.6.x/

Ouch, yes, that is better... see the log.txt attached.

Good that it is fixed, should have test this here earlier :frowning:

Any planning for a 2.6.1 release ?

Thanks,

Richard Duivenvoorde

------------------------------------------------------------------------------

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Yeah this is why we requested help testing RC1 :frowning:

I am not sure if I should “release” a nightly, or checkout 2.6.0, apply the one fix (anyone have a link) and call it 2.6.1.

Jody

···

Jody Garnett

On Thu, Oct 23, 2014 at 8:27 AM, Richard Duivenvoorde <rdmailings@anonymised.com> wrote:

On 23-10-14 16:57, Andrea Aime wrote:

n Thu, Oct 23, 2014 at 4:36 PM, Richard Duivenvoorde
We upgraded to 2.6.0 (and still doing fine :slight_smile: ), but Oracle layers
performance is much lower compared to 2.4.3

Can somebody help me with this, or confirm behaviour like this?

Yes, we know, we have a fix. Can you try 2.6.x nightlies?
http://ares.boundlessgeo.com/geoserver/2.6.x/

Ouch, yes, that is better… see the log.txt attached.

Good that it is fixed, should have test this here earlier :frowning:

Any planning for a 2.6.1 release ?

Thanks,

Richard Duivenvoorde



Geoserver-devel mailing list
Geoserver-devel@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

On Thu, Oct 23, 2014 at 7:33 PM, Jody Garnett <jody.garnett@anonymised.com>
wrote:

Yeah this is why we requested help testing RC1 :frowning:

I am not sure if I should "release" a nightly, or checkout 2.6.0, apply
the one fix (anyone have a link) and call it 2.6.1.

The fix is here:
https://github.com/geotools/geotools/commit/e6b7c70cf7b8a1bfe17356f83a6d5fa52782bfe1

If we do this, and I believe it's sensible, I'd call it 2.6.0.1, and have
2.6.0 downloads disappear in thin air.

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalitĂ  indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalitĂ  diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

Agreed: GeoTools 12.0.1 and GeoServer 2.6.0.1.

Richard if I make these artifacts are you in position to confirm the fix works (before I update the blog post and source forge downloads?)

···

Jody Garnett

On Thu, Oct 23, 2014 at 10:35 AM, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Thu, Oct 23, 2014 at 7:33 PM, Jody Garnett <jody.garnett@anonymised.com> wrote:

Yeah this is why we requested help testing RC1 :frowning:

I am not sure if I should “release” a nightly, or checkout 2.6.0, apply the one fix (anyone have a link) and call it 2.6.1.

The fix is here: https://github.com/geotools/geotools/commit/e6b7c70cf7b8a1bfe17356f83a6d5fa52782bfe1

If we do this, and I believe it’s sensible, I’d call it 2.6.0.1, and have 2.6.0 downloads disappear in thin air.

Cheers

Andrea

–

==

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

==

Ing. Andrea Aime

@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.


On 23-10-14 19:43, Jody Garnett wrote:

Agreed: GeoTools 12.0.1 and GeoServer 2.6.0.1.

Richard if I make these artifacts are you in position to confirm the fix
works (before I update the blog post and source forge downloads?)

Not untill next week thursday I'm afraid. The rest of the week I'm not
in the neighborhood of Windows and Oracle servers.
But the nightly was definitely working again.
But if you want I'm happy to test a new 2.6.0.1 or 2.6.1 first thing
next thursday.

Anybody else willing/able to test this?

Regards,

Richard Duivenvoorde

ps if I'm the only affected one, it's OK for me to just wait till the
next official release
(https://github.com/geoserver/geoserver/wiki/Release-Schedule), I'll use
the nighly for now then...

I will keep muddling along, I will try and get someone to test the release artifacts before it is announced. So if is not announced by next thursday you are welcome to volunteer :slight_smile:

···

Jody Garnett

On Thu, Oct 23, 2014 at 12:05 PM, Richard Duivenvoorde <richard@anonymised.com> wrote:

On 23-10-14 19:43, Jody Garnett wrote:

Agreed: GeoTools 12.0.1 and GeoServer 2.6.0.1.

Richard if I make these artifacts are you in position to confirm the fix
works (before I update the blog post and source forge downloads?)

Not untill next week thursday I’m afraid. The rest of the week I’m not
in the neighborhood of Windows and Oracle servers.
But the nightly was definitely working again.
But if you want I’m happy to test a new 2.6.0.1 or 2.6.1 first thing
next thursday.

Anybody else willing/able to test this?

Regards,

Richard Duivenvoorde

ps if I’m the only affected one, it’s OK for me to just wait till the
next official release
(https://github.com/geoserver/geoserver/wiki/Release-Schedule), I’ll use
the nighly for now then…