shailesh gavathe ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A80ce2ac0-4a48-4346-bcfd-85b663e00856 ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-10453?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) GEOS-10453 ( https://osgeo-org.atlassian.net/browse/GEOS-10453?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) Unable to add postgis layer ( https://osgeo-org.atlassian.net/browse/GEOS-10453?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) Issue Type: Bug Affects Versions: 2.21-RC Assignee: Unassigned Attachments: error geoserver.JPG Components: PostGIS Created: 07/Apr/22 11:34 PM Environment: Build Information * GeoServer Version2.21-CLOUD Git Revision0c208205392e25211a6709e40d2913bc9c1a1be5 Build Date03-Mar-2022 19:21 GeoTools Version27-SNAPSHOT (rev 0d475aea085891ae470eeb71fdd5b0aba20f947f) GeoWebCache Version1.21-SNAPSHOT (rev fde9defd9b2157364d498135b2bb88b5853a208a/fde9defd9b2157364d498135b2bb88b5853a208a) * PostGIS: PostgreSQL 14.2 Priority: Medium Reporter: shailesh gavathe ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A80ce2ac0-4a48-4346-bcfd-85b663e00856 ) Hello, Deployed the helm chart ( https://github.com/camptocamp/helm-geoserver-cloud into K3d under local environment. Able to load the sample data into one of the postgis pod using https://docs.geoserver.org/stable/en/user/data/database/postgis.html. I am also able to connect to it with web-ui. But when I try to publish the postgis layer, I see some weird error like below * *PreparedStatementCallback; SQL [insert into object (oid, type_id, id, blob) values (DEFAULT, ?, ?, ?)]; ERROR: duplicate key value violates unique constraint "object_id_idx" Detail: Key (id)=(LayerInfoImpl-50880b76-906b-40eb-9e64-285fa198a421) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "object_id_idx" Detail: Key (id)=(LayerInfoImpl-50880b76-906b-40eb-9e64-285fa198a421) already exists.* Not sure, how to resolve this. Went back into nyc table but don’t see any unique value constraint object_id_idx Thank you, ( https://osgeo-org.atlassian.net/browse/GEOS-10453#add-comment?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10453#add-comment?atlOrigin=eyJpIjoiMzE3NDgyNmQ4OTgxNDk2ZmE0OWJlZWI2ZDcwNTIyYmEiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100198- sha1:6f7fe5b )
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
