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

[mathiasleroy]

Same here. I tried to

• switch to the release version,
• switch project,
• rebuild.

This is new since today for me.

[LeonardoMantovani]

Same error on IDEA after updating the IDE and the plugin to the latest version

[priyashpatil]

There are some improvements being made in code indexing these should be resolved sooner. For a workaround see if there is any popup for rebuilding the index if not then deleting the ~/.continue/index folder should fix the issue (after deleting make sure to reindex by clicking on the indexing indicator or CMD+Shift+P -> Continue: Codebase force re-index).

[woq]

There are some improvements being made in code indexing these should be resolved sooner. For a workaround see if there is any popup for rebuilding the index if not then deleting the ~/.continue/index folder should fix the issue (after deleting make sure to reindex by clicking on the indexing indicator or CMD+Shift+P -> Continue: Codebase force re-index).

The same error occurred. When I directly clicked "Rebuild" in Pycharm and Webstorm, the problem could not be solved. According to your solution, after deleting the index, this problem was solved.

[appinteractive]

There are some improvements being made in code indexing these should be resolved sooner. For a workaround see if there is any popup for rebuilding the index if not then deleting the ~/.continue/index folder should fix the issue (after deleting make sure to reindex by clicking on the indexing indicator or CMD+Shift+P -> Continue: Codebase force re-index).

Hey @priyashpatil thanks for replying, sadly as mentioned in the description, deleting the index does not help as the same error occurs again very quickly.

So fingers crossed 🤞 for the improvements in the next version

[sestinj]

This should now be solved in the latest EAP release and VS Code version 0.9.202. I'll wait to close the issue however until we've had time to verify that this is not happening for anyone in version 0.0.65

[Patrick-Erichsen]

This issue appears to have regressed in JetBrains: https://github.com/continuedev/continue/issues/2320

[appinteractive]

For me it seems to be gone