Skip to main content
Version: dev

Installation FAQ

Q1: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file​

make sure you pull latest code or create directory with mkdir pilot/data

Q2: The model keeps getting killed.​

your GPU VRAM size is not enough, try replace your hardware or replace other llms.

Q3: How to access website on the public network​

You can try to use gradio's network to achieve.

import secrets
from gradio import networking
token=secrets.token_urlsafe(32)
local_port=5670
url = networking.setup_tunnel('0.0.0.0', local_port, token)
print(f'Public url: {url}')
time.sleep(60 * 60 * 24)

Open url with your browser to see the website.

Q4: (Windows) execute pip install -e . error​

The error log like the following:

× python setup.py bdist_wheel did not run successfully.
  │ exit code: 1
  ╰─> [11 lines of output]
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build\lib.win-amd64-cpython-310
      creating build\lib.win-amd64-cpython-310\cchardet
      copying src\cchardet\version.py -> build\lib.win-amd64-cpython-310\cchardet
      copying src\cchardet\__init__.py -> build\lib.win-amd64-cpython-310\cchardet
      running build_ext
      building 'cchardet._cchardet' extension
      error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
      [end of output]

Download and install Microsoft C++ Build Tools from visual-cpp-build-tools

Q5: Torch not compiled with CUDA enabled​

2023-08-19 16:24:30 | ERROR | stderr |     raise AssertionError("Torch not compiled with CUDA enabled")
2023-08-19 16:24:30 | ERROR | stderr | AssertionError: Torch not compiled with CUDA enabled
  1. Install CUDA Toolkit
  2. Reinstall PyTorch start-locally with CUDA support.

Q6: How to migrate meta table chat_history and connect_config from duckdb to sqlite​

 python docker/examples/metadata/duckdb2sqlite.py

Q7: How to migrate meta table chat_history and connect_config from duckdb to mysql​

1. update your mysql username and password in docker/examples/metadata/duckdb2mysql.py
2.  python docker/examples/metadata/duckdb2mysql.py

Q8: How to manage and migrate my database​

You can use the command of dbgpt db migration to manage and migrate your database.

See the following command for details.

dbgpt db migration --help

First, you need to create a migration script(just once unless you clean it). This command with create a alembic directory in your pilot/meta_data directory and a initial migration script in it.

dbgpt db migration init

Then you can upgrade your database with the following command.

dbgpt db migration upgrade

Every time you change the model or pull the latest code from DB-GPT repository, you need to create a new migration script.


dbgpt db migration migrate -m "your message"

Then you can upgrade your database with the following command.

dbgpt db migration upgrade

Q9: alembic.util.exc.CommandError: Target database is not up to date.​

Solution 1:

Run the following command to upgrade the database.

dbgpt db migration upgrade

Solution 2:

Run the following command to clean the migration script and migration history.

dbgpt db migration clean -y

Solution 3:

If you have already run the above command, but the error still exists, you can try the following command to clean the migration script, migration history and your data. warning: This command will delete all your data!!! Please use it with caution.

dbgpt db migration clean --drop_all_tables -y --confirm_drop_all_tables

or

rm -rf pilot/meta_data/alembic/versions/*
rm -rf pilot/meta_data/alembic/dbgpt.db