Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fails to insert embeddings into postgres #1197

Closed
2 tasks done
nikhilp0 opened this issue Mar 28, 2024 · 3 comments
Closed
2 tasks done

Fails to insert embeddings into postgres #1197

nikhilp0 opened this issue Mar 28, 2024 · 3 comments
Assignees
Labels
bug Something isn't working

Comments

@nikhilp0
Copy link

nikhilp0 commented Mar 28, 2024

Describe the bug
Fails to insert embeddings into postgres

Please describe your setup

  • How did you install memgpt?
    • git clone
  • Describe your setup
    • Windows
    • CLI

Screenshots

(.venv) PS C:\Users\...\pythonProject1> memgpt load directory --name test --input-dir C:\src\test--recursive --extensions .txt,.md,.pdf,.html
Loading config from C:\Users\...
Loading files: 100%|███████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 1752/1752 [00:00<00:00, 1819.13file/s]
Failed to load data from provided information.
(pg8000.dbapi.ProgrammingError) {'S': 'ERROR', 'V': 'ERROR', 'C': '21000', 'M': 'ON CONFLICT DO UPDATE command cannot affect row a second time', 'H': 'Ensure that no rows proposed for insertion within the same command have duplicate constrained values.', 'F': 'nodeModifyTable.c', 'L': '2570', 'R': 'ExecOnConflictUpdate'}

Additional context
Add any other context about the problem here.

MemGPT Config
Please attach your ~/.memgpt/config file or copy past it below.

[defaults]
preset = memgpt_chat
persona = sam_pov
human = cs_phd

[model]
model = gpt-4-1106-preview
model_endpoint = https://.....openai.azure.com
model_endpoint_type = azure
context_window = 128000

[embedding]
embedding_endpoint_type = azure
embedding_endpoint = https://......openai.azure.com
embedding_model = text-embedding-ada-002
embedding_dim = 1536
embedding_chunk_size = 300

[archival_storage]
type = postgres
path = C:\Users\...
uri = postgresql+pg8000://postgres:postgres@localhost:5432/postgres

[recall_storage]
type = postgres
path = C:\Users\...
uri = postgresql+pg8000://postgres:postgres@localhost:5432/postgres

[metadata_storage]
type = postgres
path = C:\Users\...
uri = postgresql+pg8000://postgres:postgres@localhost:5432/postgres

[version]
memgpt_version = 0.3.7

[client]
anon_clientid = 00000000-0000-0000-0000-000000000000

@sarahwooders sarahwooders self-assigned this Apr 1, 2024
@sarahwooders sarahwooders added the bug Something isn't working label Apr 1, 2024
@sarahwooders
Copy link
Collaborator

Would you be able to share the files (you can DM me on discord) so I can reproduce this?

@nikhil-pandey
Copy link
Contributor

Will reach out in discord

@sarahwooders
Copy link
Collaborator

Closed by #1205

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants