Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0 : Forums : PythonAnywhere

Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0

I'm running a flask api to talk to my pdf at the code level, but it's giving me this error:

The imports I use are:

from flask import Flask, request, jsonify, make_response, send_file
import os
import base64
from time import sleep
import shutil
from werkzeug.utils import secure_filename
from langchain.document_loaders import PyMuPDFLoader, TextLoader
from langchain.text_splitter import RecursiveCharacterTextSplitter
from langchain.vectorstores import Chroma
from langchain.embeddings import OpenAIEmbeddings
from langchain.chat_models import ChatOpenAI
from langchain.chains import RetrievalQA

Exception on /process [POST]
Traceback (most recent call last):
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/flask/app.py", line 2190, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/flask/app.py", line 1486, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(view_args)
  File "/home/payconautomacoes/mysite/flask_app.py", line 72, in process
    vectordb = Chroma.from_documents(documents=texts, embedding=embeddings, persist_directory=persist_directory)
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/langchain/vectorstores/chroma.py", line 592, in from_documents
    return cls.from_texts(
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/langchain/vectorstores/chroma.py", line 547, in from_texts
    chroma_collection = cls(
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/langchain/vectorstores/chroma.py", line 81, in __init__
    import chromadb
  File "/home/payconautomacoes/.local/lib/python3.10/site-packages/chromadb/__init__.py", line 36, in <module>
    raise RuntimeError(
RuntimeError: #033[91m***Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0***.#033[0m
033[94mPlease visit https://docs.trychroma.com/troubleshooting#sqlite to learn how to upgrade.#033[0m

payconautomacoes | 2 posts | Aug. 1, 2023, 10:42 p.m. | permalink

I solve the problem following the following tutorial already shown in the error. my lack of attention

payconautomacoes | 2 posts | Aug. 1, 2023, 10:49 p.m. | permalink

Glad to hear you got that working!

pafk | 2973 posts | PythonAnywhere staff | Aug. 2, 2023, 9:56 a.m. | permalink

Hi @payconautomacoes How did you do that in pythonanywhere?

this might be from a recent upgrade of Langchain it was working here before, but not anymore, I note that there are some options in the webpage, but Is not quite clear for me as a hobbyist

monitorcasalab | 6 posts | Sept. 10, 2023, 3:38 a.m. | permalink

I think you're right; our most recent system image has SQLite version 3.31, so if you're getting an error from Langchain saying that it needs a more recent version, but it did work before, then it's likely that Langchain have made a new release that's causing the problem.

I've done a bit of digging around on Google, and if the error you're getting relates to Chroma, it might help if you try running

 pip install pysqlite3-binary

Could you let us know if that helps?

giles | 11788 posts | PythonAnywhere staff | Sept. 10, 2023, 1:16 p.m. | permalink

it does work, this solves the issue, thanks so much

the problem is that previous database files using previous versions of Chroma don't work anymore

monitorcasalab | 6 posts | Sept. 11, 2023, 11:59 a.m. | permalink

For software that relies on a backend database, there is usually a way to upgrade databases from old versions. Check the Chroma documentation to see if there is a way to upgrade the database.

glenn | 9498 posts | PythonAnywhere staff | Sept. 12, 2023, 8:36 a.m. | permalink

No this does not solve the issue

iksen | 1 post | Sept. 15, 2023, 10:29 a.m. | permalink

Then perhaps the old database is just not useable.

glenn | 9498 posts | PythonAnywhere staff | Sept. 15, 2023, 5:06 p.m. | permalink