[Geoserver-devel] [JIRA] (GEOS-8714) WFS-NG resultset cleanup tracking floods the logs with queries

Andrea Aime (JIRA) Mon, 23 Apr 2018 03:41:05 -0700

Title: Message Title

Andrea Aime created an issue

Issue Type:	Bug
Assignee:	Unassigned
Components:	Community modules
Created:	23/Apr/18 12:40 PM
Priority:	Medium
Reporter:	Andrea Aime

When the NSG WFS plugin is configured the GeoTools developer logging is harder to use than usual due to the constant stream of queries issued by the plugin to clean up outdated pageable results:

````
2018-04-23 12:33:21,565 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2018-04-23 12:33:21,565 DEBUG [org.geotools.filter] - exporting LogicFilter
2018-04-23 12:33:21,565 DEBUG [org.geotools.filter] - exporting SQL ComparisonFilter
2018-04-23 12:33:21,565 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:21,565 DEBUG [org.geotools.filter] - exporting LiteralExpression
2018-04-23 12:33:21,565 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:21,566 DEBUG [org.geotools.jdbc] - SELECT "fid","ID","created","updated" FROM "RESULT_SET" WHERE ("updated" < 1524479001564 AND "updated" IS NOT NULL )
2018-04-23 12:33:21,566 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2018-04-23 12:33:21,566 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2018-04-23 12:33:21,566 DEBUG [org.geotools.filter] - exporting LogicFilter
2018-04-23 12:33:21,566 DEBUG [org.geotools.filter] - exporting SQL ComparisonFilter
2018-04-23 12:33:21,566 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:21,567 DEBUG [org.geotools.filter] - exporting LiteralExpression
2018-04-23 12:33:21,567 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:21,567 DEBUG [org.geotools.jdbc] - Removing feature(s): DELETE FROM "RESULT_SET" WHERE ("updated" < 1524479001564 AND "updated" IS NOT NULL )
2018-04-23 12:33:21,567 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2018-04-23 12:33:22,568 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2018-04-23 12:33:22,569 DEBUG [org.geotools.filter] - exporting LogicFilter
2018-04-23 12:33:22,569 DEBUG [org.geotools.filter] - exporting SQL ComparisonFilter
2018-04-23 12:33:22,569 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:22,569 DEBUG [org.geotools.filter] - exporting LiteralExpression
2018-04-23 12:33:22,569 DEBUG [org.geotools.filter] - exporting PropertyName
2018-04-23 12:33:22,569 DEBUG [org.geotools.jdbc] - SELECT "fid","ID","created","updated" FROM "RESULT_SET" WHERE ("updated" < 1524479002567 AND "updated" IS NOT NULL )
2018-04-23 12:33:22,569 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
````

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira

------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

[Geoserver-devel] [JIRA] (GEOS-8714) WFS-NG resultset cleanup tracking floods the logs with queries

Reply via email to