[Geoserver-devel] Monitoring hibernate module: does it have a maintainer?

GeoServer GeoServer Developer
1

Hi,
wondering if the module above still has a maintainer or not?
GeoSolutions has a stake in the core monitoring module and we have been
making changes/improvements to it in recent times, but the hibernate module
seems to have received zero recent updates, if we except a few changes that
kept it building.

So… is there a maintainer for it? If not, what about we drop it down to community module status?
(or even remove it, if no one is interested in it?)

Cheers
Andrea

···

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

2

Ciao Andrea,
I would be +1 to remove rather than to send more unsupported stuff to
the community modules.

If there are no strong objections on the devel list, I would probably
ask on the users list as well but, again, even if we don't have it
afde away directly I would wait a few months and then do it anyway
(even if we move it momentarily to community so that people can go for
an alternative).

Regards,
Simone Giannecchini

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

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via di Montramito 3/A
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 Tue, Apr 17, 2018 at 8:12 PM, Andrea Aime
<andrea.aime@anonymised.com> wrote:

Hi,
wondering if the module above still has a maintainer or not?
GeoSolutions has a stake in the core monitoring module and we have been
making changes/improvements to it in recent times, but the hibernate module
seems to have received zero recent updates, if we except a few changes that
kept it building.

So... is there a maintainer for it? If not, what about we drop it down to
community module status?
(or even remove it, if no one is interested in it?)

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

3

Hi,

We do use it and to my knowledge it is working fine at present. I'm not saying we will definitely continue to use it but is it possible the lack of updates is just because it isn't broken?

Anyway, I can't volunteer as I still haven't managed to get any training to up my confidence level and so I'm still not actively developing as I was hoping to be.

Paul

-----Original Message-----
From: Simone Giannecchini [mailto:simone.giannecchini@…1268…]
Sent: 17 April 2018 22:20
To: Andrea Aime <andrea.aime@...1268...>
Cc: Geoserver-devel <geoserver-devel@lists.sourceforge.net>
Subject: Re: [Geoserver-devel] Monitoring hibernate module: does it have a maintainer?

Ciao Andrea,
I would be +1 to remove rather than to send more unsupported stuff to the community modules.

If there are no strong objections on the devel list, I would probably ask on the users list as well but, again, even if we don't have it afde away directly I would wait a few months and then do it anyway (even if we move it momentarily to community so that people can go for an alternative).

Regards,
Simone Giannecchini

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

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via di Montramito 3/A
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 Tue, Apr 17, 2018 at 8:12 PM, Andrea Aime <andrea.aime@...1268...> wrote:

Hi,
wondering if the module above still has a maintainer or not?
GeoSolutions has a stake in the core monitoring module and we have
been making changes/improvements to it in recent times, but the
hibernate module seems to have received zero recent updates, if we
except a few changes that kept it building.

So... is there a maintainer for it? If not, what about we drop it down
to community module status?
(or even remove it, if no one is interested in it?)

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

----------------------------------------------------------------------
-------- Check out the vibrant tech community on one of the world's
most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
"This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation."

4

On Wed, Apr 18, 2018 at 10:03 AM, Paul Wittle <P.Wittle@anonymised.com>
wrote:

Hi,

We do use it and to my knowledge it is working fine at present. I'm not
saying we will definitely continue to use it but is it possible the lack of
updates is just because it isn't broken?

Hum.. how do you use it? We tried it, after a few million requests it ends
up locking GeoServer up as the time for insert in the DB becomes bigger
than the
time for the request itself. Do you clean up the db periodically with some
script to keep the tables small?
I'm proposing removal/downgrade because every time we do changes in the
core module we also have to try out the hibernate bit, and it's something
we know it's not working (at least for us, in high traffic situations).

Cheers
Andrea

--

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

5

Hi Paul,
no maintainer showed up, but you have an interest in the module, so I believe we should
move it down to community land, and maybe keep it in the nightly build.

I’m still curious as to how you use the monitoring hibernate module without killing the server performance,
anything you want to share with us? :slight_smile:

Cheers
Andrea

···

On Wed, Apr 18, 2018 at 10:18 AM, Andrea Aime <andrea.aime@anonymised.com> wrote:

–

On Wed, Apr 18, 2018 at 10:03 AM, Paul Wittle <P.Wittle@anonymised.com> wrote:

Hi,

We do use it and to my knowledge it is working fine at present. I’m not saying we will definitely continue to use it but is it possible the lack of updates is just because it isn’t broken?

Hum… how do you use it? We tried it, after a few million requests it ends up locking GeoServer up as the time for insert in the DB becomes bigger than the
time for the request itself. Do you clean up the db periodically with some script to keep the tables small?
I’m proposing removal/downgrade because every time we do changes in the core module we also have to try out the hibernate bit, and it’s something
we know it’s not working (at least for us, in high traffic situations).

Cheers

Andrea

–

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

6

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the extension definitely breaks Geoserver from infact version 2.12 for us.

On performance, we have’t performed any tests and we have’t cleaned the database since we started using it for monitoring close to 10 Geoserver instances.

I would imagine it adds costs in request time as it has to write to the database every request data.

···

On Wed, Apr 25, 2018 at 10:26 AM, Andrea Aime <andrea.aime@anonymised.com> wrote:

Hi Paul,
no maintainer showed up, but you have an interest in the module, so I believe we should
move it down to community land, and maybe keep it in the nightly build.

I’m still curious as to how you use the monitoring hibernate module without killing the server performance,
anything you want to share with us? :slight_smile:

Cheers

Andrea

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

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

Kind regards,
Steve Omondi

On Wed, Apr 18, 2018 at 10:18 AM, Andrea Aime <andrea.aime@anonymised.com> wrote:

–

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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 Wed, Apr 18, 2018 at 10:03 AM, Paul Wittle <P.Wittle@anonymised.com> wrote:

Hi,

We do use it and to my knowledge it is working fine at present. I’m not saying we will definitely continue to use it but is it possible the lack of updates is just because it isn’t broken?

Hum… how do you use it? We tried it, after a few million requests it ends up locking GeoServer up as the time for insert in the DB becomes bigger than the
time for the request itself. Do you clean up the db periodically with some script to keep the tables small?
I’m proposing removal/downgrade because every time we do changes in the core module we also have to try out the hibernate bit, and it’s something
we know it’s not working (at least for us, in high traffic situations).

Cheers

Andrea

–

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

7

On Wed, Apr 25, 2018 at 11:09 AM, Steve Omondi <steve.omondi@anonymised.com>
wrote:

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the
extension definitely breaks Geoserver from infact version 2.12 for us.

Sad to hear... but one more reason to drop the module out of supported
status, since nobody would look into it.

On performance, we have't performed any tests and we have't cleaned the
database since we started using it for monitoring close to 10 Geoserver
instances.
I would imagine it adds costs in request time as it has to write to the
database every request data.

The database write gets slower and slower over time as the cost for
checking primary key uniqueness increases. Once you hit the millions of
entries,
in our tests, that time becomes comparable (or bigger, for GWC requests)
than the request processing itself, making monitoring-hibernate a liability.

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

8

That is interesting and I have certainly seen some evidence of some of the errors which may be what Steve is referring to. I’m not sure I’d go as far as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in our database. These run a series of summary statistics which we then keep so we avoid any potential cost in that regard but we do get a wealth of very useful historical usage information when it is running.

We have also been developing methods which use the Tomcat access logs and FME / Power BI so I guess we will just have to switch to those if the plugin is not supported.

Paul

···

On Wed, Apr 25, 2018 at 11:09 AM, Steve Omondi <steve.omondi@…4677…> wrote:

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the extension definitely breaks Geoserver from infact version 2.12 for us.

Sad to hear… but one more reason to drop the module out of supported status, since nobody would look into it.

On performance, we have’t performed any tests and we have’t cleaned the database since we started using it for monitoring close to 10 Geoserver instances.

I would imagine it adds costs in request time as it has to write to the database every request data.

The database write gets slower and slower over time as the cost for checking primary key uniqueness increases. Once you hit the millions of entries,

in our tests, that time becomes comparable (or bigger, for GWC requests) than the request processing itself, making monitoring-hibernate a liability.

Cheers

Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

9

On Mon, Apr 30, 2018 at 10:55 AM, Paul Wittle <P.Wittle@anonymised.com>
wrote:

That is interesting and I have certainly seen some evidence of some of the
errors which may be what Steve is referring to. I’m not sure I’d go as far
as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in
our database. These run a series of summary statistics which we then keep
so we avoid any potential cost in that regard but we do get a wealth of
very useful historical usage information when it is running.

Ah, makes sense.

We have also been developing methods which use the Tomcat access logs and
FME / Power BI so I guess we will just have to switch to those if the
plugin is not supported.

Only the hibernate portion will, monitoring-core with dump to log file is
here to stay. I invite you to have a look at it, as it provides the same
information as the hibernate tables,
so you can figure out the layers, bbox, and what not, without having to
worry if requests are GET or POST

At this point it's clear nobody is stepping up to maintain the module, so
I'll proceed with the pull request to downgrade the module to community
land soon
(community, not removal, as there is evidence of some users for it)

Cheers
Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

10

Hi,

I think that sounds extremely fair to me Andrea; I’m just sorry I’ve still not had the time to get going on development properly.

Anyway, thanks as usual for your work with these lists, you do a great job keeping on top of everything!

Cheers,

Paul

···

On Mon, Apr 30, 2018 at 10:55 AM, Paul Wittle <P.Wittle@…4807…> wrote:

That is interesting and I have certainly seen some evidence of some of the errors which may be what Steve is referring to. I’m not sure I’d go as far as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in our database. These run a series of summary statistics which we then keep so we avoid any potential cost in that regard but we do get a wealth of very useful historical usage information when it is running.

Ah, makes sense.

We have also been developing methods which use the Tomcat access logs and FME / Power BI so I guess we will just have to switch to those if the plugin is not supported.

Only the hibernate portion will, monitoring-core with dump to log file is here to stay. I invite you to have a look at it, as it provides the same information as the hibernate tables,

so you can figure out the layers, bbox, and what not, without having to worry if requests are GET or POST

At this point it’s clear nobody is stepping up to maintain the module, so I’ll proceed with the pull request to downgrade the module to community land soon

(community, not removal, as there is evidence of some users for it)

Cheers

Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

11

And here we go with the pull request pulling the plug:

https://github.com/geoserver/geoserver/pull/2881

Cheers
Andrea

···

On Tue, Apr 17, 2018 at 8:12 PM, Andrea Aime <andrea.aime@anonymised.com> wrote:

Hi,
wondering if the module above still has a maintainer or not?
GeoSolutions has a stake in the core monitoring module and we have been
making changes/improvements to it in recent times, but the hibernate module
seems to have received zero recent updates, if we except a few changes that
kept it building.

So… is there a maintainer for it? If not, what about we drop it down to community module status?
(or even remove it, if no one is interested in it?)

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

–

Regards,

Andrea Aime

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

12

Hi Paul,
A little late to the thread, but if you want to do log analysis for how your service has been used with no performance penalties, you may be interested in Logacity - https://www.logacity.co.uk/
It comes with a pretty and “manager-proof” interface.
(Disclaimer - I’m the developer.)
Cheers,
Jonathan

···

On 2018-04-30 09:55, Paul Wittle via Geoserver-devel wrote:

That is interesting and I have certainly seen some evidence of some of the errors which may be what Steve is referring to. I’m not sure I’d go as far as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in our database. These run a series of summary statistics which we then keep so we avoid any potential cost in that regard but we do get a wealth of very useful historical usage information when it is running.

We have also been developing methods which use the Tomcat access logs and FME / Power BI so I guess we will just have to switch to those if the plugin is not supported.

Paul

From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: 25 April 2018 10:45
To: Steve Omondi steve.omondi@anonymised.com
Cc: Paul Wittle P.Wittle@anonymised.com; Geoserver-devel geoserver-devel@lists.sourceforge.net; Simone Giannecchini simone.giannecchini@anonymised.com
Subject: Re: [Geoserver-devel] Monitoring hibernate module: does it have a maintainer?

On Wed, Apr 25, 2018 at 11:09 AM, Steve Omondi <steve.omondi@anonymised.com> wrote:

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the extension definitely breaks Geoserver from infact version 2.12 for us.

Sad to hear… but one more reason to drop the module out of supported status, since nobody would look into it.

On performance, we have’t performed any tests and we have’t cleaned the database since we started using it for monitoring close to 10 Geoserver instances.

I would imagine it adds costs in request time as it has to write to the database every request data.

The database write gets slower and slower over time as the cost for checking primary key uniqueness increases. Once you hit the millions of entries,

in our tests, that time becomes comparable (or bigger, for GWC requests) than the request processing itself, making monitoring-hibernate a liability.

Cheers

Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! [http://sdm.link/slashdot](http://sdm.link/slashdot)

_______________________________________________
Geoserver-devel mailing list
[Geoserver-devel@lists.sourceforge.net](mailto:Geoserver-devel@anonymised.comsourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-devel](https://lists.sourceforge.net/lists/listinfo/geoserver-devel)
13

Hi Jonathan,

I’ve looked at Logacity and the Demo and I’m very interested in it and knowing how it works exactly.

How would I set this up?

···

On Sat, May 19, 2018 at 10:17 PM, Jonathan Moules <jonathan-lists@anonymised.com> wrote:

Hi Paul,
A little late to the thread, but if you want to do log analysis for how your service has been used with no performance penalties, you may be interested in Logacity - https://www.logacity.co.uk/
It comes with a pretty and “manager-proof” interface.
(Disclaimer - I’m the developer.)
Cheers,
Jonathan

On 2018-04-30 09:55, Paul Wittle via Geoserver-devel wrote:

That is interesting and I have certainly seen some evidence of some of the errors which may be what Steve is referring to. I’m not sure I’d go as far as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in our database. These run a series of summary statistics which we then keep so we avoid any potential cost in that regard but we do get a wealth of very useful historical usage information when it is running.

We have also been developing methods which use the Tomcat access logs and FME / Power BI so I guess we will just have to switch to those if the plugin is not supported.

Paul

From: andrea.aime@anonymised.com3… [mailto:andrea.aime@anonymised.com03…] On Behalf Of Andrea Aime
Sent: 25 April 2018 10:45
To: Steve Omondi steve.omondi@anonymised.com
Cc: Paul Wittle P.Wittle@anonymised.com; Geoserver-devel geoserver-devel@anonymised.comsourceforge.net; Simone Giannecchini simone.giannecchini@anonymised.comsolutions.it
Subject: Re: [Geoserver-devel] Monitoring hibernate module: does it have a maintainer?

On Wed, Apr 25, 2018 at 11:09 AM, Steve Omondi <steve.omondi@anonymised.com> wrote:

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the extension definitely breaks Geoserver from infact version 2.12 for us.

Sad to hear… but one more reason to drop the module out of supported status, since nobody would look into it.

On performance, we have’t performed any tests and we have’t cleaned the database since we started using it for monitoring close to 10 Geoserver instances.

I would imagine it adds costs in request time as it has to write to the database every request data.

The database write gets slower and slower over time as the cost for checking primary key uniqueness increases. Once you hit the millions of entries,

in our tests, that time becomes comparable (or bigger, for GWC requests) than the request processing itself, making monitoring-hibernate a liability.

Cheers

Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! [http://sdm.link/slashdot](http://sdm.link/slashdot)

_______________________________________________
Geoserver-devel mailing list
[Geoserver-devel@anonymised.com366...sourceforge.net](mailto:Geoserver-devel@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-devel](https://lists.sourceforge.net/lists/listinfo/geoserver-devel)

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

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

Kind regards,
Steve Omondi

14

Hi Steve,
The details are heading a little off-topic for the GeoServer-Dev list, but I’ll answer here as it does relate a little to the monitoring plugin.

Basically the GeoServer Servlet Container (usually Tomcat, but can be Jetty etc) will by default log all requests ever made to it (as does a load-balancing proxy which could also be used). Most of these requests are GET requests, and so you end up with a log file filled with lines that look like these:

10.50.17.135 - - [17/Jun/2013:06:30:05 +0000] “GET /geoserver/gwc/service/tms/1.0.0/Warks_Full/11/1160/695.png HTTP/1.1” 200 10883 “” “Mozilla/4.0”

10.50.17.135 - - [17/Jun/2013:06:30:08 +0000] “GET /geoserver/ows?LAYERS=OS_Rasters%3A25000_Colour&TRANSPARENT=TRUE&FORMAT=image%2Fpng&STYLES=raster&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&SRS=EPSG%3A27700&BBOX=415744,248729.6,416102.4,249088&WIDTH=256&HEIGHT=256 HTTP/1.1” 200 7631 “” “Mozilla/4.0”

Logacity analyses these lines (mostly the request portion) to figure out what layers / projections / etc are being requested.

It basically solves half of the problem the monitoring module deals with, but with absolutely no performance penalty as it uses the logs that you’re already creating. Its weakness as compared to the monitoring module is that because it’s not integrated into GeoServer, it can only monitor what gets logged, and it’s not real-time (it’s next-day). POST requests don’t get logged by default, but those are usually only WPS and some more complex WFS requests, so not much is missed.

Let me know if you have any more questions and we can talk off-list.
Cheers,
Jonathan

···

On 2018-05-21 06:53, Steve Omondi wrote:

Hi Jonathan,

I’ve looked at Logacity and the Demo and I’m very interested in it and knowing how it works exactly.

How would I set this up?

Kind regards,
Steve Omondi

On Sat, May 19, 2018 at 10:17 PM, Jonathan Moules <jonathan-lists@anonymised.com> wrote:

Hi Paul,
A little late to the thread, but if you want to do log analysis for how your service has been used with no performance penalties, you may be interested in Logacity - https://www.logacity.co.uk/
It comes with a pretty and “manager-proof” interface.
(Disclaimer - I’m the developer.)
Cheers,
Jonathan

On 2018-04-30 09:55, Paul Wittle via Geoserver-devel wrote:

That is interesting and I have certainly seen some evidence of some of the errors which may be what Steve is referring to. I’m not sure I’d go as far as ‘break’ but certainly it may be introducing some bugs.

With regard to speed, we clean out the tables daily using procedures in our database. These run a series of summary statistics which we then keep so we avoid any potential cost in that regard but we do get a wealth of very useful historical usage information when it is running.

We have also been developing methods which use the Tomcat access logs and FME / Power BI so I guess we will just have to switch to those if the plugin is not supported.

Paul

From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: 25 April 2018 10:45
To: Steve Omondi steve.omondi@anonymised.com
Cc: Paul Wittle P.Wittle@anonymised.com; Geoserver-devel geoserver-devel@anonymised.comsourceforge.net; Simone Giannecchini <simone.giannecchini@anonymised.com95…solutions.it>
Subject: Re: [Geoserver-devel] Monitoring hibernate module: does it have a maintainer?

On Wed, Apr 25, 2018 at 11:09 AM, Steve Omondi <steve.omondi@anonymised.com.> wrote:

Hi Andrea,

We use Monitor Hibernate and lately we upgraded to Geoserver 2.13 and the extension definitely breaks Geoserver from infact version 2.12 for us.

Sad to hear… but one more reason to drop the module out of supported status, since nobody would look into it.

On performance, we have’t performed any tests and we have’t cleaned the database since we started using it for monitoring close to 10 Geoserver instances.

I would imagine it adds costs in request time as it has to write to the database every request data.

The database write gets slower and slower over time as the cost for checking primary key uniqueness increases. Once you hit the millions of entries,

in our tests, that time becomes comparable (or bigger, for GWC requests) than the request processing itself, making monitoring-hibernate a liability.

Cheers

Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! [http://sdm.link/slashdot](http://sdm.link/slashdot)

_______________________________________________
Geoserver-devel mailing list
[Geoserver-devel@anonymised.comsourceforge.net](mailto:Geoserver-devel@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-devel](https://lists.sourceforge.net/lists/listinfo/geoserver-devel)

------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world’s most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-devel mailing list Geoserver-devel@anonymised.comsourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel

15

On Mon, May 21, 2018 at 12:11 PM, Jonathan Moules <
jonathan-lists@anonymised.com> wrote:

It basically solves half of the problem the monitoring module deals with,
but with absolutely no performance penalty as it uses the logs that you're
already creating. Its weakness as compared to the monitoring module is that
because it's not integrated into GeoServer, it can only monitor what gets
logged, and it's not real-time (it's next-day). POST requests don't get
logged by default, but those are usually only WPS and some more complex WFS
requests, so not much is missed.

Hi Jonathan,
you could actually make it work with monitoring in audit mode, which
creates log files with a structure of your choosing, in asynch mode, so no
significant perf penalty either, and
grabbing info also from POST requests (you could, for example turn them
back into GET lookalikes).
That's what we normally do with the audit mode, the only difference is that
we feed the resulting logs into the ELK stack instead, and build a
dashboard that way.

Just thinking out loud :slight_smile:

Cheers
Andrea

==

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

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
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.

16

Hi Andrea,
Your insights are always welcome.
I think you actually told me the same thing at FOSS4G a couple of years ago when we talked about it, I’ve just not gotten around to delving into it; it is somewhere on my todo list… :slight_smile:

The downside to that enhancement though is that it requires yet more setup, configuration, and maintenance. I’m trying to go for simple to deploy/maintain with this: just point it at your extant logs, tweak the config file, set up a cron job, start the python web-server and you’re done.

Cheers,
Jonathan

···

On 2018-05-21 11:32, Andrea Aime wrote:

On Mon, May 21, 2018 at 12:11 PM, Jonathan Moules <jonathan-lists@anonymised.com> wrote:

It basically solves half of the problem the monitoring module deals with, but with absolutely no performance penalty as it uses the logs that you’re already creating. Its weakness as compared to the monitoring module is that because it’s not integrated into GeoServer, it can only monitor what gets logged, and it’s not real-time (it’s next-day). POST requests don’t get logged by default, but those are usually only WPS and some more complex WFS requests, so not much is missed.

Hi Jonathan,
you could actually make it work with monitoring in audit mode, which creates log files with a structure of your choosing, in asynch mode, so no significant perf penalty either, and
grabbing info also from POST requests (you could, for example turn them back into GET lookalikes).
That’s what we normally do with the audit mode, the only difference is that we feed the resulting logs into the ELK stack instead, and build a dashboard that way.

Just thinking out loud :slight_smile:

Cheers
Andrea

==

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) 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 m essages 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.