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

GeoServer GeoServer Developer
1

Andrea Aime created an issue

GeoServer / BugGEOS-8714

WFS-NG resultset cleanup tracking floods the logs with queries

Issue Type:

BugBug

Assignee:

Unassigned

Components:

Community modules

Created:

23/Apr/18 12:40 PM

Priority:

MediumMedium

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

Add Comment

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

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100082-sha1:256645f)

Atlassian logo