ERROR [geoserver.rest] - Duplicate Rule

[pierreyvesturquin]

Expected Behavior

When uploading a layer in Geonode or synchronising it from Geoserver, auto generated GeoFence data rules for users and groups allows services queries.

Actual Behavior

When uploading a layer in Geonode interface or synchronising it from Geoserver, error message in Geoserver's logs:

ERROR [geoserver.rest] - Duplicate Rule Rule[id:null pri:111074 role:ROLE_VIEWER srv:WFS req:GETFEATUREWITHLOCK ws:geonode l:my_layer acc:DENY]
org.geoserver.geofence.core.dao.DuplicateKeyException: Duplicate Rule Rule[id:null pri:111074 role:ROLE_VIEWER srv:WFS req:GETFEATUREWITHLOCK ws:geonode l:my_layer acc:DENY]

This layer's priority number rule doesn't exists in database.

Layer is uploaded but can't be reach with "visualize dataset" button: 404 error. Impossible to configure it (styles, groups...).

No differences after cleaning all layers and workspaces, reset styles and execute admin commands find_geoserver_broken_layers, clean_oprhan_obj_perms.

Similars issues:
Geofence
Geofence/Geoserver

Steps to Reproduce the Problem

1. Upload dataset (add ressource)
2. Visualize dataset button -> error 404

Specifications

• GeoNode version: 2.20.6
• Installation type (vanilla, geonode-project): vanilla
• Installation method (manual, docker): Docker
• Platform: Debian 11
• Additional details: