Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: code_snippets.path, code_snippets.cacheKey...

[appinteractive]

Before submitting your bug report

• [X] I believe this is a bug. I'll try to join the Continue Discord for questions
• [X] I'm not able to find an open issue that reports the same bug
• [X] I've seen the troubleshooting guide on the Continue Docs

Relevant environment info

- OS: macOS 14.5 
- Continue: v0.8.46
- IDE: VS Code
- Model: Codestral + Claude 3.5 Sonnet
- config.json:
  
{
  "models": [
    {
      "title": "Codestral",
      "provider": "mistral",
      "model": "codestral-latest",
      "apiKey": "***"
    },
    {
      "model": "claude-3-5-sonnet-20240620",
      "contextLength": 200000,
      "title": "Claude 3.5 Sonnet",
      "apiKey": "***",
      "provider": "anthropic"
    },
    {
      "title": "Llama 3",
      "provider": "ollama",
      "model": "llama3"
    },
    {
      "title": "Ollama",
      "provider": "ollama",
      "model": "AUTODETECT"
    }
  ],
  "tabAutocompleteModel": {
    "title": "Codestral",
    "provider": "mistral",
    "model": "codestral-latest",
    "apiKey": "***"
  },
  "customCommands": [
    {
      "name": "test",
      "prompt": "{{{ input }}}\n\nWrite a comprehensive set of unit tests for the selected code. It should setup, run tests that check for correctness including important edge cases, and teardown. Ensure that the tests are complete and sophisticated. Give the tests just as chat output, don't edit any file.",      "description": "Write unit tests for highlighted code"
    }
  ],
  "allowAnonymousTelemetry": false
}

Description

I do always get this error in a project, and the deletion of the index (~/.continue/index) does not help as it will crash again.

#2078 and #2100 seem to be similar, but not exactly the same.

To reproduce

Try to use continue in a project, and after some time the index starts to fail and does not recover.

Log output

no logs found, neigter in vscode nore in the ~/.continue/ dir