|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Indicia Development → Distribution Map 3
Hi,
I'm trying to get the Distribution Map 3 report to work but no dots are showing - this is the case on sites using the BRC live warehouse and the test warehouse. On the live warehouse, I also can't get the third option to not show on the legend...
Any advice?
Many thanks,
Fiona
Hi Fiona,
I am trying with the test warehouse. Using Firebug I can see that the layers have been requested but we are waiting forever to get a response. Restarting the GeoServer service has made it work. I have been seeing problems with GeoServer on the test warehouse for a couple of weeks but have not had any reports of problems with warehouse1.
When switching between the two servers remember there are changes in taxon meaning id which might trip you up.
Deleting the Layer Caption removes a layer. Is that what you want to do?
Jim Bacon.
I've given this form a quick check against a local geoserver and all seems well.
John
Hi John
There are errors in the GeoServer log indicating that the connections to PostgreSQL are failing sometimes on the test warehouse. PostgreSQL is showing a number of connections as '<IDLE> in transaction'. I have seen in the past that when there are many such connections, GeoServer is no longer able to connect.
Testwarehouse is running GeoServer 2.1.3 against PostgreSQL 8.3 with JavaRE 1.7.0_07.
Warehouse1 is running GeoServer 2.1.2 against PostgreSQL 9.1 with JavaRE 1.7.0_01
Latest release of GeoServer is 2.1.4 and PostgreSQL is 9.2
If the problem on the testwarehouse persists, an upgrade to PostgreSQL would be my first proposal, especially since you have indicated that would benefit the development of Indicia as well. Iwould also consider the test server a much better test bed if it were actually running the same versions of code as the live server.
Jim Bacon
Thanks Jim and John,
Yes, I had tripped over on the taxon meaning id. Yes, I just needed to delete the Layer Caption!
I have checked the site that is using the test warehouse and the dots now appear, although there is a delay in them loading. I will now switch back on both to use indicia:cache_occurrences as I believe this is best practice to reduce the load on the server?
Fiona
Hi
I am observing that there are now 10 connections to PostgreSQL in the '<IDLE> in transaction' state and that GeoServer on testwarehouse has stopped responding again. The GeoServer configuration for the indicia datastore limits the maximum connections to 10 and all further transactions from GeoServer are halted until a connection becomes available. The connections are being left in transaction due to some fault.
Having set a GeoServer property called "validate connections" for the indicia datastore and retried a request to GeoServer, all of the 'in transaction' connections have been removed and a response is obtained. Maybe that will help things along for a while.
Jim Bacon.
Today GeoServer on testwarehouse has got so stroppy that it is not even showing its web interface let alone responding to map requests. I have restarted the service and it will be happy again for a while. Clearly more work required but I am just off on a fortnight's holiday.
Jim Bacon.
Possibly unrelated but I notice that the scheduled_tasks runs on the hour on testwarehouse and just took 2.5 minutes using 100% processor capacity stopping web page requests from being serviced during that time. That sort of behaviour has been prevented on warehouse1, I hasten to add, but I'm not sure how that was achieved.
Jim Bacon.
Forum → Indicia Development → Distribution Map 3
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.