Re: [Geoserver-users] 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 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
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
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
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
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