[Geoserver-devel] [JIRA] (GEOS-10453) Unable to add postgis layer

GeoServer GeoServer Developer
,
1

shailesh gavathe created an issue

GeoServer / BugGEOS-10453

Unable to add postgis layer

Issue Type:

BugBug

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:

MediumMedium

Reporter:

shailesh gavathe

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,

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#100198-sha1:6f7fe5b)

Atlassian logo