Hello,
I’m currently facing an issue when attempting to delete all data from an index by specifying a namespace in Python. The code snippet I’m using to perform this operation is:
index.delete(delete_all=True, namespace="ns1")
However, when executing this command, I encounter the following error:
HTTP response headers: HTTPHeaderDict({'Date': 'Mon, 04 Mar 2024 17:09:26 GMT', 'Content-Type': 'application/json', 'Content-Length': '229', 'Connection': 'keep-alive', 'x-pinecone-request-latency-ms': '67', 'x-pinecone-request-id': '1500958508836270997', 'x-envoy-upstream-service-time': '65', 'server': 'envoy'})
HTTP response body: {"code":2,"message":"pinecone-commons/src/request_log/store/postgres.rs:727 -\u003e An error occurred while trying to contact Postgres: error returned from database: cannot execute INSERT in a read-only transaction","details":[]}
Has anyone encountered a similar issue or does anyone have insights on how to resolve this error? I’m looking for advice on how to successfully delete all data from an index by namespace.
Any guidance or suggestions from the community would be greatly appreciated!