Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG]重启会有大BUG严重影响使用 #197

Open
taiyi747 opened this issue Jul 25, 2024 · 4 comments
Open

[BUG]重启会有大BUG严重影响使用 #197

taiyi747 opened this issue Jul 25, 2024 · 4 comments

Comments

@taiyi747
Copy link

描述问题
Shell 脚本安装voce,配置好之后,重启时数据库读取出问题
如何复现
复现步骤举例:

  1. Shell 脚本安装voce
  2. 配置好voce
  3. /etc/init.d/vocechat-server.sh stop
  4. /etc/init.d/vocechat-server.sh start

预期结果
2024-07-25T10:46:16.272820Z INFO vocechat_server: load configuration file. current_dir=/root/vocechat-server path=config/config.toml
2024-07-25T10:46:16.273051Z INFO vocechat_server::server: open sqlite db. dsn="sqlite:./data/db/db.sqlite"
2024-07-25T10:46:16.276380Z INFO vocechat_server::server: open message db. path="./data/msg"
2024-07-25T10:46:16.417400Z ERROR vocechat_server: failed to create server. error=error occurred while decoding column 1: mismatched types; Rust type alloc::string::String (as SQL type TEXT) is not compatible with SQL type INTEGER

环境信息

  • 操作系统: centos8.5
  • 浏览器 edge

附加信息
联系方式,备注,等等,可不填

@gvhn11111
Copy link

same in docker

@RoeWade
Copy link

RoeWade commented Sep 12, 2024

看起来是数据库版本和程序版本不兼容导致的,尝试使用
yum install sqlite3
cd data/db
sqlite3 db.sqlite
.tables
.schema user

安装最新版本 https://doc.voce.chat/install/install-by-shell 试一下?
我刚才测试 CentOS 8 通过 shell 安装,然后反复重启进程,和重启系统,没有复现这个问题。
如有需要可以联系我协助您排查。

@suhan1996
Copy link
Contributor

可以再试试,如果还有问题请告知

@zsr-lukezhang
Copy link

same in docker

But I don't get this bug by executing the script

docker run -d --restart=always -p 3000:3000 --name vocechat-server privoce/vocechat-server:latest

Please try it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants