Re: [Geoserver-users] 2.6 pink tiles

2014-10-09 Thread Rahkonen Jukka (Tike)
Hi,

From which version did you update? Tell also a bit more about the environment: 
Linux/Windows, 32 or 64 bit, java version, with or without native JAI and 
which file format in tiles?

Pink tiles mean no tile at all in that place and the reason may be timeout in 
seeding process or some other failure. If you create png tiles on Windows it 
can be for example related to 
http://thread.gmane.org/gmane.comp.gis.geoserver.user/43732

About seeding/reseeding having no effect, how did you test that? The OpenLayers 
map that opens from the layer preview does not read tiles from the cache even 
if the cache is seeded because the WMS GetMaps which this app is sending do not 
match with extents of tiles in the cache. Therefore seeding does not remove 
pink tiles from layer preview. The other viewer that opens through 
http://localhost:8080/geoserver/gwc/demo/ does hit the cache and after 
successful seeding it should not show pink tiles. At least this is how I 
understand the situation.

-Jukka Rahkonen-



Ismail, Mark wrote:

Hi

I upgraded to 2.6 today and am having some problems with my base maps

They are loading much slower and I am getting quite a few pink tiles

Assuming it was something to do with the geowebcache I have wiped it and am 
trying to regenerate the tiles

The tasks are starting then when you click refresh they disappear and a few 
files are appearing in the cache but it is not completing

I have tried seed and reseed with no luck

Any tips / tricks to get it working in 2.6 ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council  *  Westmorland Road  * Huyton * L36 9GL

Save time - use the IT Service Desk Self Servehttp://kmbcselfservice/ 
Application

This e-mail and any attachments are confidential. It may contain privileged 
information and is intended for the named recipient(s) only. It must not be 
distributed without consent. If you are not one of the intended recipients, 
please notify the sender immediately and do not disclose, distribute, or retain 
this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual 
sender, and not of Knowsley MBC. Legally binding obligations can only be 
created for, or be entered into on behalf of, Knowsley MBC by duly authorised 
officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any 
direct or consequential loss arising from the use, or reliance on, this e-mail 
or its contents. We believe but do not warrant that this e-mail and any 
attachments are virus free. You must therefore take full responsibility for 
virus checking and no responsibility is accepted for loss or damage arising 
from viruses or changes made to this message after it was sent. Knowsley MBC 
reserves the right to monitor and/or record all e-mail communications through 
its network in accordance with relevant legislation.
--
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] 2.6 pink tiles

2014-10-09 Thread Ismail, Mark
Hi

I updated from version 2.5.2 on windows server 2008 64bit  which was using 
apache tomcat 8.09 and jre-8u11-windows-i586
I upgraded apache to 8.14 and the jre to jre-8u20-windows-i586 to fix a 
security vulnerability
I am using native jai and the tiles are in png8

While I had to rebuild apache I decided to upgrade geoserver at the same time

I have my data folder on the local c drive - the server is a Vmware server. The 
data folder included a 21gb cache of my 5 ordnance survey base maps as layer 
groups

I decided that reseed wasn't working by emptying one the of layers using tile 
caching / tile layers  empty option and then reseeding.
I opened the cache folder where there were no tiles and hit reseed
The reseed form opened with  300k ish tiles to do and said it had done a few 
hundred - by checking the folder I could see the files there
When you hit refresh on the seed form to update progress the job disappears, 
the cache folder still only has a few files in it

I tried this on a few layers with exactly the same result.

I spent some time this morning monitoring the network traffic and managed to 
find an error :-

?xml version=1.0 encoding=UTF-8 standalone=no?!DOCTYPE 
ServiceExceptionReport SYSTEM 
http://geolive.knowsley.gov.uk:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd;
 ServiceExceptionReport version=1.1.1ServiceException
  Internal error
Error occurred getting table name list.
ORA-01000: maximum open cursors exceeded

/ServiceException/ServiceExceptionReport

All my data is stored in oracle - I am using the new 2.6 oracle jar file

I right clicked and did show picture a few times on the missing pink tile that 
generated the above error and it appeared
http://geolive.knowsley.gov.uk:8080/geoserver/Geostore/wms?LAYERS=OS%20MasterFORMAT=image%2Fpng8SERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=SRS=EPSG%3A27700BBOX=346585.83789474,391167.5004644,347294.07541796,391875.73798762WIDTH=256HEIGHT=256

it would seem to be an issue with the oracle connection to my data

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council  *  Westmorland Road  * Huyton * L36 9GL

Save time - use the IT Service Desk Self Servehttp://kmbcselfservice/ 
Application

From: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi]
Sent: 09 October 2014 08:10
To: Ismail, Mark; geoserver mailing list (geoserver-users@lists.sourceforge.net)
Subject: Re: 2.6 pink tiles

Hi,

From which version did you update? Tell also a bit more about the environment: 
Linux/Windows, 32 or 64 bit, java version, with or without native JAI and 
which file format in tiles?

Pink tiles mean no tile at all in that place and the reason may be timeout in 
seeding process or some other failure. If you create png tiles on Windows it 
can be for example related to 
http://thread.gmane.org/gmane.comp.gis.geoserver.user/43732

About seeding/reseeding having no effect, how did you test that? The OpenLayers 
map that opens from the layer preview does not read tiles from the cache even 
if the cache is seeded because the WMS GetMaps which this app is sending do not 
match with extents of tiles in the cache. Therefore seeding does not remove 
pink tiles from layer preview. The other viewer that opens through 
http://localhost:8080/geoserver/gwc/demo/ does hit the cache and after 
successful seeding it should not show pink tiles. At least this is how I 
understand the situation.

-Jukka Rahkonen-



Ismail, Mark wrote:

Hi

I upgraded to 2.6 today and am having some problems with my base maps

They are loading much slower and I am getting quite a few pink tiles

Assuming it was something to do with the geowebcache I have wiped it and am 
trying to regenerate the tiles

The tasks are starting then when you click refresh they disappear and a few 
files are appearing in the cache but it is not completing

I have tried seed and reseed with no luck

Any tips / tricks to get it working in 2.6 ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council  *  Westmorland Road  * Huyton * L36 9GL

Save time - use the IT Service Desk Self Servehttp://kmbcselfservice/ 
Application

This e-mail and any attachments are confidential. It may contain privileged 
information and is intended for the named recipient(s) only. It must not be 
distributed without consent. If you are not one of the intended recipients, 
please notify the sender immediately and do not disclose, distribute, or retain 
this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual 
sender, and not of Knowsley MBC. Legally binding obligations can only be 
created for, or be entered into on behalf of, Knowsley MBC by duly authorised 
officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any 
direct or consequential loss arising from the use, or reliance on, this e-mail 
or its contents. We believe but do not warrant that this 

Re: [Geoserver-users] 2.6 pink tiles

2014-10-09 Thread Andrea Aime
On Thu, Oct 9, 2014 at 10:42 AM, Ismail, Mark mark.ism...@knowsley.gov.uk
wrote:

  Hi



 I updated from version 2.5.2 on windows server 2008 64bit  which was using
 apache tomcat 8.09 and jre-8u11-windows-i586

 I upgraded apache to 8.14 and the jre to jre-8u20-windows-i586 to fix a
 security vulnerability

 I am using native jai and the tiles are in png8


Hmm... Java 8 is not tested with GeoServer.




 While I had to rebuild apache I decided to upgrade geoserver at the same
 time



 I have my data folder on the local c drive – the server is a Vmware
 server. The data folder included a 21gb cache of my 5 ordnance survey base
 maps as layer groups



 I decided that reseed wasn’t working by emptying one the of layers using
 tile caching / tile layers  empty option and then reseeding.

 I opened the cache folder where there were no tiles and hit reseed

 The reseed form opened with  300k ish tiles to do and said it had done a
 few hundred – by checking the folder I could see the files there

 When you hit refresh on the seed form to update progress the job
 disappears, the cache folder still only has a few files in it



 I tried this on a few layers with exactly the same result.



 I spent some time this morning monitoring the network traffic and managed
 to find an error :-



 ?xml version=1.0 encoding=UTF-8 standalone=no?!DOCTYPE
 ServiceExceptionReport SYSTEM 
 http://geolive.knowsley.gov.uk:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd;
 ServiceExceptionReport version=1.1.1ServiceException

   Internal error

 Error occurred getting table name list.

 ORA-01000: maximum open cursors exceeded



 /ServiceException/ServiceExceptionReport


Ah, this is a well known problem with Oracle, not much we can do on our
side, Oracle prepared statements keep
cursors open, prepared statements are associated to connections,
we keep connections open in the pool because opening a new one with Oracle
is _very_ expensive
(there is a long thread on this topic, maybe one or two year ago, in this
mailing list).

What you can do to limit the issue is to either tune your Oracle
installation to allow more cursors to be opened,
or go in the GeoServer store configuration and reduce the number of
prepared statements kept open per
connection (the default if 50), eventually also reduce the number of
connections in the pool

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

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

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

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

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



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

---
--
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311iu=/4140/ostg.clktrk___
Geoserver-users mailing 

Re: [Geoserver-users] 2.6 pink tiles

2014-10-09 Thread Ismail, Mark
I have fixed the pink tile issue by replacing ojdbc7.jar with ojdbc6.jar and 
changing to jre7

Which is the one I was using with 2.5.2

The issue now is the seeding / wms loading is very slow (approx 30% of normal 
loading speed)

I uninstalled 2.6.0 and went back to 2.5.2 and speeds are back to normal

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council  •  Westmorland Road  • Huyton • L36 9GL

Save time – use the IT Service Desk Self Servehttp://kmbcselfservice/ 
Application

From: andrea.a...@gmail.commailto:andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of Andrea Aime
Sent: 09 October 2014 10:00
To: Ismail, Mark
Cc: Rahkonen Jukka (Tike); geoserver mailing, list 
(geoserver-users@lists.sourceforge.netmailto:geoserver-users@lists.sourceforge.net)
Subject: Re: [Geoserver-users] 2.6 pink tiles

On Thu, Oct 9, 2014 at 10:42 AM, Ismail, Mark 
mark.ism...@knowsley.gov.ukmailto:mark.ism...@knowsley.gov.uk wrote:
Hi

I updated from version 2.5.2 on windows server 2008 64bit  which was using 
apache tomcat 8.09 and jre-8u11-windows-i586
I upgraded apache to 8.14 and the jre to jre-8u20-windows-i586 to fix a 
security vulnerability
I am using native jai and the tiles are in png8

Hmm... Java 8 is not tested with GeoServer.


While I had to rebuild apache I decided to upgrade geoserver at the same time

I have my data folder on the local c drive – the server is a Vmware server. The 
data folder included a 21gb cache of my 5 ordnance survey base maps as layer 
groups

I decided that reseed wasn’t working by emptying one the of layers using tile 
caching / tile layers  empty option and then reseeding.
I opened the cache folder where there were no tiles and hit reseed
The reseed form opened with  300k ish tiles to do and said it had done a few 
hundred – by checking the folder I could see the files there
When you hit refresh on the seed form to update progress the job disappears, 
the cache folder still only has a few files in it

I tried this on a few layers with exactly the same result.

I spent some time this morning monitoring the network traffic and managed to 
find an error :-

?xml version=1.0 encoding=UTF-8 standalone=no?!DOCTYPE 
ServiceExceptionReport SYSTEM 
http://geolive.knowsley.gov.uk:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd;
 ServiceExceptionReport version=1.1.1ServiceException
  Internal error
Error occurred getting table name list.
ORA-01000: maximum open cursors exceeded

/ServiceException/ServiceExceptionReport

Ah, this is a well known problem with Oracle, not much we can do on our side, 
Oracle prepared statements keep
cursors open, prepared statements are associated to connections,
we keep connections open in the pool because opening a new one with Oracle is 
_very_ expensive
(there is a long thread on this topic, maybe one or two year ago, in this 
mailing list).

What you can do to limit the issue is to either tune your Oracle installation 
to allow more cursors to be opened,
or go in the GeoServer store configuration and reduce the number of prepared 
statements kept open per
connection (the default if 50), eventually also reduce the number of 
connections in the pool

Cheers
Andrea

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

Ing. Andrea Aime
@geowolf
Technical Lead

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

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


AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

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



The information in this message and/or attachments, is intended solely for the 
attention and use of the named addressee(s) and may be confidential or 
proprietary in nature or covered by the provisions of privacy act (Legislative 
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in 
accord with its purpose, any disclosure, reproduction, copying, distribution, 
or either dissemination, either whole or partial, is strictly forbidden except 
previous formal approval of the named addressee(s). If you are not the intended 
recipient, please contact immediately the sender by telephone, fax or e-mail 
and delete the information in this message that has

Re: [Geoserver-users] 2.6 pink tiles

2014-10-08 Thread Jonathan Moules
Hi Mark,
It sounds like your issue isn’t with GeoWebCache but layers further down the 
stack (i.e. why seed/reseed don’t work).

Do WMS requests work? What error messages do they produce when you open the 
image itself directly in the browser (rather than through a OpenLayers client, 
which is what’s interpreting the errors and turning them into pink tiles)?

Also if you take a look at the log file (geoserver.log), that will likely have 
a number of ERROR level events in to indicate what the problem may be.

Cheers,
Jonathan




From: Ismail, Mark [mailto:mark.ism...@knowsley.gov.uk]
Sent: Wednesday, October 08, 2014 3:01 PM
To: geoserver mailing list (geoserver-users@lists.sourceforge.net)
Subject: [Geoserver-users] 2.6 pink tiles

Hi

I upgraded to 2.6 today and am having some problems with my base maps

They are loading much slower and I am getting quite a few pink tiles

Assuming it was something to do with the geowebcache I have wiped it and am 
trying to regenerate the tiles

The tasks are starting then when you click refresh they disappear and a few 
files are appearing in the cache but it is not completing

I have tried seed and reseed with no luck

Any tips / tricks to get it working in 2.6 ?

Mark Ismail
Principal IT Officer
Tel: 0151 443 3021
Knowsley Council  •  Westmorland Road  • Huyton • L36 9GL

Save time – use the IT Service Desk Self Servehttp://kmbcselfservice/ 
Application

This e-mail and any attachments are confidential. It may contain privileged 
information and is intended for the named recipient(s) only. It must not be 
distributed without consent. If you are not one of the intended recipients, 
please notify the sender immediately and do not disclose, distribute, or retain 
this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual 
sender, and not of Knowsley MBC. Legally binding obligations can only be 
created for, or be entered into on behalf of, Knowsley MBC by duly authorised 
officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any 
direct or consequential loss arising from the use, or reliance on, this e-mail 
or its contents. We believe but do not warrant that this e-mail and any 
attachments are virus free. You must therefore take full responsibility for 
virus checking and no responsibility is accepted for loss or damage arising 
from viruses or changes made to this message after it was sent. Knowsley MBC 
reserves the right to monitor and/or record all e-mail communications through 
its network in accordance with relevant legislation.


This message has been scanned for viruses by 
MailControlhttp://www.mailcontrol.com/, a service from BlackSpider Technology

Click 
herehttps://www.mailcontrol.com/sr/RQo1XBrSrPPGX2PQPOmvUqy!8K4P2+30BvY0pE5K2O3WE7+yHkkZO7HMmaV05UyNVvQoUpK7BqiNI5tH4SJ!Mg==
 to report this email as spam.





HR Wallingford and its subsidiaries uses faxes and emails for confidential and 
legally privileged business communications. They do not of themselves create 
legal commitments. Disclosure to parties other than addressees requires our 
specific consent. We are not liable for unauthorised disclosures nor reliance 
upon them.
If you have received this message in error please advise us immediately and 
destroy all copies of it.

HR Wallingford Limited
Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
Registered in England No. 02562099


--
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users