Issue with Deleting All Data from Index by Namespace


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/ -\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!

Probably caused by some pinecone issues. Works now without any updates :slight_smile:

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.