Skip to main content
Version: v0.6.0

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