Re: [Geoserver-users] Response time of WMS-Requests with PointSymbolizer ExternalGraphic Format image/gif or png sometimes extremly slow

[Blome, Guido (62-24)]

Hi Andrea,

yes we have a xmx setting of 8G. A gc problem was my first thought too,  but 
the Total time threads are stopped by the gc are normaly 30 ms and the slowest 
100 ms. The whole Application Time of the gc is varying between 7000 and 1000 
ms.
During that operations Vektorlayer are serverd with a constant response time of 
~ 90 ms.  There are no breaks with 5000 ms.
Assuming the problem is a gc Problem, why are only PointSymbolizers with gif or 
png showing outbreaks in Request durations with 5000 ms and PolygonSymbolizer 
and Raster not ?

Cheers, Guido

---

Von: Andrea Aime [mailto:andrea.a...@geo-solutions.it]
Gesendet: Sonntag, 11. November 2018 09:25
An: Blome, Guido (62-24)
Cc: GeoServer Mailing List List
Betreff: Re: [Geoserver-users] Response time of WMS-Requests with 
PointSymbolizer ExternalGraphic Format image/gif or png sometimes extremly slow

Hi,
weird... it might be a garbage collection related issue... did you give 
GeoServer a very large heap, e.g., more than 4GB?
In that case you might have to tune the garbage collector to reduce GC pauses, 
they can get pretty long with a large heap.

I did a quick test with multiple requests locally, with a style using a PNG 
external graphic, the slowest one is 30% slower than the fastest one.
For reference:


http://www.opengis.net/sld 
http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd;
   xmlns="http://www.opengis.net/sld; 
xmlns:ogc="http://www.opengis.net/ogc;
   xmlns:xlink="http://www.w3.org/1999/xlink; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>

  


  circle
  

  circle
  

  
http://maps.google.com/mapfiles/kml/shapes/placemark_circle.png; />
image/png
  
  32

  


  

  



Cheers
Andrea


On Fri, Nov 9, 2018 at 3:59 PM Blome, Guido (62-24) 
mailto:guido.bl...@bonn.de>> wrote:
Hi List,

we have published several WMS layers with Point Data out of a 
PostgreSQL/postgis Datastore using SLD with
 image/gif or image/png.
In most of the requests they are working very fast with response times between 
12- 50 ms but every tenth  thirtieth Request, in a Scenario with one request 
per second, there is a response time of ~ 5000 ms with the same or similar 
request.

This behavior doesn`t appear when using vector based formats like 
image/svg+xml or   

We are using those WMS symbol layers as overlays on top of WMTS/TMS, delivered 
by GeowebCache, that are very fast and so those 5000 ms request are very 
disruptive in our application behavior.

I have tested the behavior with Oracle Corporation: 1.8.0_171 (OpenJDK 64-Bit 
Server VM) and Geoserver 2.12.2 and 2.14.0.

Does someone know how we can turn of those 5000ms responses ?
Where does this behavior come from ?

Best regards, Guido

Guido Blome

Bundesstadt Bonn
Amt für Bodenmanagement und Geoinformation
Sachgebietsleiter Geodateninfrastruktur

Stadthaus, Berliner Platz 2, 53111 Bonn
Telefon +49(0)2 28.77 3009
Telefax +49(0)2 28.77 2618
E-Mail guido.bl...@bonn.de
Internet www.bonn.de







Bleiben Sie mit unseren städtischen Newslettern auf dem Laufenden. Alle 
Informationen zum Abo finden Sie auf 
www.bonn.de/@newsletter
Recyclingpapierfreundlichste Stadt Deutschlands 2010 bis 2018.
Bitte prüfen Sie, ob diese Mail wirklich ausgedruckt werden muss.


___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


--

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 
--- Con riferimento alla 
normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento 
generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza 
inerente alla presente email (il suo contenuto, gli 

Re: [Geoserver-users] Response time of WMS-Requests with PointSymbolizer ExternalGraphic Format image/gif or png sometimes extremly slow

[Andrea Aime]

Hi,
I have no quick answer to that, it would take some analysis with a profiler
(as said, not happening on my machine, even using an external graphic).
If you're in quick need of help I'd suggest to check
http://geoserver.org/support/

Cheers
Andrea


On Tue, Nov 13, 2018 at 5:38 PM Blome, Guido (62-24) 
wrote:

> Hi Andrea,
>
>
>
> yes we have a xmx setting of 8G. A gc problem was my first thought too,
>  but the Total time threads are stopped by the gc are normaly 30 ms and the
> slowest 100 ms. The whole Application Time of the gc is varying between
> 7000 and 1000 ms.
>
> During that operations Vektorlayer are serverd with a constant response
> time of ~ 90 ms.  There are no breaks with 5000 ms.
>
> Assuming the problem is a gc Problem, why are only PointSymbolizers with
> gif or png showing outbreaks in Request durations with 5000 ms and
> PolygonSymbolizer and Raster not ?
>
>
>
> Cheers, Guido
>
>
>
> ---
>
>
>
> *Von:* Andrea Aime [mailto:andrea.a...@geo-solutions.it]
> *Gesendet:* Sonntag, 11. November 2018 09:25
> *An:* Blome, Guido (62-24)
> *Cc:* GeoServer Mailing List List
> *Betreff:* Re: [Geoserver-users] Response time of WMS-Requests with
> PointSymbolizer ExternalGraphic Format image/gif or png sometimes extremly
> slow
>
>
>
> Hi,
>
> weird... it might be a garbage collection related issue... did you give
> GeoServer a very large heap, e.g., more than 4GB?
>
> In that case you might have to tune the garbage collector to reduce GC
> pauses, they can get pretty long with a large heap.
>
>
>
> I did a quick test with multiple requests locally, with a style using a
> PNG external graphic, the slowest one is 30% slower than the fastest one.
>
> For reference:
>
>
>
> 
>
> 
>xsi:schemaLocation="http://www.opengis.net/sld
> http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd;
>
>xmlns="http://www.opengis.net/sld; xmlns:ogc="
> http://www.opengis.net/ogc;
>
>xmlns:xlink="http://www.w3.org/1999/xlink;
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;>
>
>
>
>   
>
> 
>
> 
>
>   circle
>
>   
>
> 
>
>   circle
>
>   
>
> 
>
>   
>
> 
> xlink:type="simple"
>
> xlink:href="
> http://maps.google.com/mapfiles/kml/shapes/placemark_circle.png; />
>
> image/png
>
>   
>
>   32
>
> 
>
>   
>
> 
>
>
>
>   
>
> 
>
>   
>
> 
>
>
>
>
>
> Cheers
>
> Andrea
>
>
>
>
>
> On Fri, Nov 9, 2018 at 3:59 PM Blome, Guido (62-24) 
> wrote:
>
> Hi List,
>
> we have published several WMS layers with Point Data out of a
> PostgreSQL/postgis Datastore using SLD with   
>  image/gif or image/png.
> In most of the requests they are working very fast with response times
> between 12- 50 ms but every tenth  thirtieth Request, in a Scenario with
> one request per second, there is a response time of ~ 5000 ms with the same
> or similar request.
>
> This behavior doesn`t appear when using vector based formats like
> image/svg+xml or   
>
> We are using those WMS symbol layers as overlays on top of WMTS/TMS,
> delivered by GeowebCache, that are very fast and so those 5000 ms request
> are very disruptive in our application behavior.
>
> I have tested the behavior with Oracle Corporation: 1.8.0_171 (OpenJDK
> 64-Bit Server VM) and Geoserver 2.12.2 and 2.14.0.
>
> Does someone know how we can turn of those 5000ms responses ?
> Where does this behavior come from ?
>
> Best regards, Guido
>
> Guido Blome
>
> Bundesstadt Bonn
> Amt für Bodenmanagement und Geoinformation
> Sachgebietsleiter Geodateninfrastruktur
>
> Stadthaus, Berliner Platz 2, 53111 Bonn
> Telefon +49(0)2 28.77 3009
> Telefax +49(0)2 28.77 2618
> E-Mail guido.bl...@bonn.de
> Internet www.bonn.de
>
>
>
>
>
>
>
> Bleiben Sie mit unseren städtischen Newslettern auf dem Laufenden. Alle
> Informationen zum Abo finden Sie auf www.bonn.de/@newsletter<
> http://www.bonn.de/@newsletter>
> Recyclingpapierfreundlichste Stadt Deutschlands 2010 bis 2018.
> Bitte prüfen Sie, ob diese Mail wirklich ausgedruckt werden muss.
>
>
> ___
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines:
> http://geoserver.org/comm/userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
>
>
> --
>
> 

Re: [Geoserver-users] Geoserver, App-Schema and Hale Studio

[Nuno Oliveira]

Hi,
Quick answer: you can achieve what you want with GeoServer App-Schema:
 * 
https://docs.geoserver.org/latest/en/user/data/app-schema/mapping-file.html#attributes-with-cardinality-1-n
 * 
https://docs.geoserver.org/latest/en/user/data/app-schema/feature-chaining.html#multi-valued-properties-by-reference-xlink-href
... but I don't think you can do it with HALE integration. I will
double check what is going on ... not sure when I will have time to do
it.
Hope it helps,
Nuno Oliveira
On Tue, 2018-11-13 at 15:24 +, Jonas Nygaard Pedersen wrote:
> Hi list,
>  
> I’m trying to do a transformation of two tables from Postgres (see
> below) to a target XML schema (http://inspire.ec.europa.eu/schemas/pl
> u/4.0/PlannedLandUse.xsd).
> Most of my data is in one table (plu_spatialplan) where the columns
> can be directly renamed in an one-to-one relationship.

> 
> But I have a few targets in the XML schema (e.g. SpatialPlan.member.href) 
> which have a 0-to-many relationship. To handle this situation I create a join 
> in hale studio between my main table (plu_spatialplan) and the table
>  plu_zoningelement_member, which has the values that should be mapped to the 
> SpatialPlan.member.href target.
> 
>  
> 
> This all seems to work just fine in Hale Studio. And if I output the 
> transformed data as GML, everything again seems fine.
> 
> But when I export the alignment to Geoserver (as an Application Schema) via 
> the Direct Upload option, I get a new dialogue, which requires me to chain 
> the two tables (they are already joined in Hale Studio context).
> 

> 
> In this dialogue the plu_spatialplan table has the CONTAINER role and the 
> plu_zoningelement_member table has the NESTED role, which seems right, as I 
> want each row in plu_spatialplan data to hold more than one element
>  from plu_zoningelement_member.
> 
>  
> 
> But when choosing the Target Type I do not have the option to choose 
> SpatialPlan.member.href as the Target Type. In fact I can’t choose anything 
> but SpatialPlan.ordinance.OrdinanceValue, which doesn’t seem to have any
>  relation at all to the join I’m performing.
> 
>  
> 
> So I’m stuck and would love to hear from anyone having experience mapping 
> INSPIRE data in Hale Studio, using two or more tables with a join and 
> uploading the alignment to Geoserver/Application-Schema
> 
>  
> 
>  
> 
> CREATE TABLE plu_spatialplan
> 
> (
> 
>   gmlid character varying(4000),
> 
>   inspireid_localid character varying(4000) NOT NULL,
> 
>   inspireid_namespace character(61),
> 
>   extent1 geometry,
> 
>   officialtitle character varying(51),
> 
>   levelofspatialplan character(69),
> 
>   plantypename character(64),
> 
>   beginlifespanversion timestamp(6) with time zone,
> 
>   endlifespanversion character(17),
> 
>   validfrom timestamp(0) without time zone,
> 
>   validto character(17),
> 
>   alternativetitle character varying(37),
> 
>   processstepgeneral character(71),
> 
>   backgroundmap character(17),
> 
>   ordinancedate timestamp(0) without time zone,
> 
>   ordinancereference character(16),
> 
>   CONSTRAINT plu_spatialplan_pkey PRIMARY KEY (inspireid_localid)
> 
> )
> 
>  
> 
> CREATE TABLE plu_zoningelement_member
> 
> (
> 
>   plan_inspireid_localid character(36),
> 
>   member_href character varying(4000),
> 
>   CONSTRAINT plu_zoningelement_member_plan_inspireid_localid_fkey FOREIGN KEY 
> (plan_inspireid_localid)
> 
>   REFERENCES plu_spatialplan (inspireid_localid)
> 

> 
> )
> 
>  
> 
> Regards,
> 
> Jonas
> 
>  
> 
>  
> 
>  
> 




> ___
> Geoserver-users mailing list
> 
> Please make sure you read the following two resources before posting to this 
> list:
> - Earning your support instead of buying it, but Ian Turton: 
> http://www.ianturton.com/talks/foss4g.html#/
> 
> - The GeoServer user list posting guidelines: 
> http://geoserver.org/comm/userlist-guidelines.html
> 
> 
> If you want to request a feature or an improvement, also see this: 
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
> 
> 
> 
> 
Geoserver-users@lists.sourceforge.net> 
https://lists.sourceforge.net/lists/listinfo/geoserver-users> 

-- 
Regards,
Nuno Oliveira
==
GeoServer Professional Services from the
experts! 
Visit http://goo.gl/it488V for more information.
==

Nuno Miguel Carvalho Oliveira
@nmcoliveira
Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:      +39 0584 1660272

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

---

Con riferimento alla normativa sul trattamento dei dati 
personali (Reg. UE 2016/679 - Regolamento generale sulla 
protezione dei dati “GDPR”), si precisa che ogni 
circostanza inerente alla presente email (il suo contenuto, 
gli eventuali allegati, etc.) è un dato la cui conoscenza 
è riservata al/i 

[Geoserver-users] Geoserver, App-Schema and Hale Studio

[Jonas Nygaard Pedersen]

Hi list,

I'm trying to do a transformation of two tables from Postgres (see below) to a 
target XML schema 
(http://inspire.ec.europa.eu/schemas/plu/4.0/PlannedLandUse.xsd).
Most of my data is in one table (plu_spatialplan) where the columns can be 
directly renamed in an one-to-one relationship.
But I have a few targets in the XML schema (e.g. SpatialPlan.member.href) which 
have a 0-to-many relationship. To handle this situation I create a join in hale 
studio between my main table (plu_spatialplan) and the table 
plu_zoningelement_member, which has the values that should be mapped to the 
SpatialPlan.member.href target.

This all seems to work just fine in Hale Studio. And if I output the 
transformed data as GML, everything again seems fine.
But when I export the alignment to Geoserver (as an Application Schema) via the 
Direct Upload option, I get a new dialogue, which requires me to chain the two 
tables (they are already joined in Hale Studio context).
In this dialogue the plu_spatialplan table has the CONTAINER role and the 
plu_zoningelement_member table has the NESTED role, which seems right, as I 
want each row in plu_spatialplan data to hold more than one element from 
plu_zoningelement_member.

But when choosing the Target Type I do not have the option to choose 
SpatialPlan.member.href as the Target Type. In fact I can't choose anything but 
SpatialPlan.ordinance.OrdinanceValue, which doesn't seem to have any relation 
at all to the join I'm performing.

So I'm stuck and would love to hear from anyone having experience mapping 
INSPIRE data in Hale Studio, using two or more tables with a join and uploading 
the alignment to Geoserver/Application-Schema


CREATE TABLE plu_spatialplan
(
  gmlid character varying(4000),
  inspireid_localid character varying(4000) NOT NULL,
  inspireid_namespace character(61),
  extent1 geometry,
  officialtitle character varying(51),
  levelofspatialplan character(69),
  plantypename character(64),
  beginlifespanversion timestamp(6) with time zone,
  endlifespanversion character(17),
  validfrom timestamp(0) without time zone,
  validto character(17),
  alternativetitle character varying(37),
  processstepgeneral character(71),
  backgroundmap character(17),
  ordinancedate timestamp(0) without time zone,
  ordinancereference character(16),
  CONSTRAINT plu_spatialplan_pkey PRIMARY KEY (inspireid_localid)
)

CREATE TABLE plu_zoningelement_member
(
  plan_inspireid_localid character(36),
  member_href character varying(4000),
  CONSTRAINT plu_zoningelement_member_plan_inspireid_localid_fkey FOREIGN KEY 
(plan_inspireid_localid)
  REFERENCES plu_spatialplan (inspireid_localid)
)

Regards,
Jonas



___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Rasters showing correctly in layer preview, but won't load in QGIS through WMS

[Ville Koivisto]

Hi Andrea,

 

Answer to the question was special letters (Scandinavian) in Name property of 
the layers in question. Geoserver was able to preview as usual, but QGIS 
complained about an invalid token. 

 

Best regards,

 

Ville Koivisto

+35840 701 4283

GIS Expert

Suomen kuntotekniikka Oy



 

From: Andrea Aime  
Sent: Monday, November 12, 2018 3:10 PM
To: ville.koivi...@kuntotekniikka.fi
Cc: GeoServer Mailing List List 
Subject: Re: [Geoserver-users] Rasters showing correctly in layer preview, but 
won't load in QGIS through WMS

 

Hi Ville,

not sure, but I would open a ticket with:

*   sample data
*   the wms request involved
*   the full stack trace (please no omissions, every part of it is 
important, from beginning to end)

Cheers

Andrea

 

 

On Mon, Nov 12, 2018 at 1:50 PM Ville Koivisto 
mailto:ville.koivi...@kuntotekniikka.fi> > 
wrote:

Dear list, 

 

I have an issue, summed up in the message title. I have two rasters, one 
ortophoto and one planning map which show correctly in layer preview in 
Geoserver. The problem is that when I try to retrieve them via WMS in QGIS, I 
can find them but they won’t load. I have the same exact rasters in another 
geoserver, and on a different server altogether, and from there I can retrieve 
them to QGIS. There is a slight version difference, 2.13.2 vs. 2.13.0. 

 

Another raster is an image pyramid and another geotiff. I guess format is not 
the issue, since behavior is shared between them. 

 

WMS is enabled, workspace is enable and WMS is checked as a service. 

 

I have following error messages in log (attached relevant log):

 

2018-11-12 14:18:47,584 ERROR [geoserver.ows] - 

org.geoserver.platform.ServiceException: Error rendering coverage on the fast 
path

.

.

.

 

Caused by: org.geoserver.platform.ServiceException: 
java.lang.IllegalArgumentException: The reference geometry must be either 
Polygon, MultiPolygon, or a polygonal PreparedGeometry

.

.

.

 

Any advice from where to start troubleshooting?

 

Best regards,

 

Ville Koivisto

+35840 701 4283

GIS Expert

Suomen kuntotekniikka Oy



 

___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net 
 
https://lists.sourceforge.net/lists/listinfo/geoserver-users




 

-- 

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 
--- Con riferimento alla 
normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento 
generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza 
inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è 
un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo 
scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, 
ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene 
notizia. This email is intended only for the person or entity to which it is 
addressed and may contain information that is privileged, confidential or 
otherwise protected from disclosure. We remind that - as provided by European 
Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or 
the information herein by anyone other than the intended recipient is 
prohibited. If you have received this email by mistake, please notify us 
immediately by telephone or e-mail. 

___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users