Skip to content
New issue

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

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

Already on GitHub? # 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

@github-project-automation github-project-automation bot moved this from To triage to Done in 🐛 MemGPT issue tracker Apr 3, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants