lobe-chat [Bug] 部署服务端数据库模式不能全文检索了

📦 Environment

Vercel

📌 Version

v1.2.3

💻 Operating System

macOS

🌐 Browser

Chrome

🐛 Bug Description

服务端数据库模式下不能本地数据库那行全文检索了，连话题也无法搜索了

📷 Recurrence Steps

No response

🚦 Expected Behavior

No response

📝 Additional Information

No response

Jul 02 '24 13:07 m-guo

👀 @m-guo

Thank you for raising an issue. We will investigate into the matter and get back to you as soon as possible. Please make sure you have given us as much context as possible.
非常感谢您提交 issue。我们会尽快调查此事，并尽快回复您。请确保您已经提供了尽可能多的背景信息。

Jul 02 '24 13:07 lobehubbot

哪里的搜索挂了？我可以搜的呀

Jul 02 '24 13:07 arvinxx

Where is the search broken? I can search it

Jul 02 '24 13:07 lobehubbot

command + K 搜索 Screenshot 2024-07-02 at 21 48 43

我部署的环境可以在多端设备上同步数据，文字和图片都同步过去了；但是搜索框单个字符都搜索不到。

Jul 02 '24 13:07 m-guo

我Vercel服务端部署的，确实搜不出来，对话内容和助手名字都搜不出来

Jul 05 '24 07:07 shog86

请问服务端数据库模式部署时一直报错：

$ bun run db:migrate
$ MIGRATION_DB=1 tsx scripts/migrateServerDB/index.ts
❌ Database migrate failed: ErrorEvent {
  [Symbol(kTarget)]: WebSocket {
    _events: [Object: null prototype] {
      error: [Function],
      message: [Function],
      close: [Function],
      open: [Function]
    },
    _eventsCount: 4,
    _maxListeners: undefined,
    _binaryType: 'arraybuffer',
    _closeCode: 1006,
    _closeFrameReceived: false,
    _closeFrameSent: false,
    _closeMessage: <Buffer >,
    _closeTimer: null,
    _errorEmitted: true,
    _extensions: {},
    _paused: false,
    _protocol: '',
    _readyState: 3,
    _receiver: null,
    _sender: null,
    _socket: null,
    _bufferedAmount: 0,
    _isServer: false,
    _redirects: 0,
    _autoPong: true,
    _url: 'wss://35.232.28.18/v2',
    _req: null,
    [Symbol(shapeMode)]: false,
    [Symbol(kCapture)]: false
  },
  [Symbol(kType)]: 'error',
  [Symbol(kError)]: Error: unable to verify the first certificate
      at TLSSocket.onConnectSecure (node:_tls_wrap:1674:34)
      at TLSSocket.emit (node:events:518:28)
      at TLSSocket._finishInit (node:_tls_wrap:1085:8)
      at ssl.onhandshakedone (node:_tls_wrap:871:12) {
    code: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE'
  },
  [Symbol(kMessage)]: 'unable to verify the first certificate'
}
error: script "db:migrate" exited with code 1
error: script "build-migrate-db" exited with code 1
error: script "postbuild" exited with code 1
Error: Command "bun run build" exited with 1

是什么原因

Jul 08 '24 10:07 xwydq

Screenshot 2024-07-11 at 21 54 52 在话题搜索框里可以进行全文检索。版本 v1.3.5

我的部署环境完全使用官方文档的步骤和用到的服务（数据库）。

Jul 11 '24 13:07 m-guo

这儿搜索是有结果的，但你在助手列表那里（也就是首页）搜索有结果吗，我就搜看到的助手名字（里的一个词）都没任何结果显示

Jul 11 '24 23:07 shog86

Do you have any results for your search? I just searched for the name of the assistant (one word in it) but no results were displayed.

Jul 11 '24 23:07 lobehubbot

没有啊，这个单子原本就是反馈这个问题的，我这个只是补充下信息。

Jul 12 '24 01:07 m-guo

No, this list was originally for feedback on this issue. I am just adding information.

Jul 12 '24 01:07 lobehubbot

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

Aug 01 '24 09:08 Aliang-code

This should be specified

#Specify Postgres database driver as node
DATABASE_DRIVER=node

Aug 01 '24 09:08 lobehubbot

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

我的情况确实是没有配置这个，翻了下文档，是应该添加这个环境变量。

但是我添加完，然后重新部署之后还是无法搜索，一样的现象。

Aug 01 '24 09:08 m-guo

This should be specified

# Specify Postgres database driver as node
DATABASE_DRIVER=node

In my case, this was indeed not configured. After reading the documentation, I found that this environment variable should be added.

But after I added it and redeployed it, I still couldn't search, the same phenomenon.

Aug 01 '24 09:08 lobehubbot

我使用的 Vercel 提供的那个 Vercel Postgres，这个应该不需要配置DATABASE_DRIVER，所以还是不知道哪里的问题。

Aug 02 '24 02:08 m-guo

The Vercel Postgres provided by Vercel that I use should not need to be configured with DATABASE_DRIVER, so I still don’t know what the problem is.

Aug 02 '24 02:08 lobehubbot

是 bug ，我近期修下

Aug 02 '24 05:08 arvinxx

It's a bug, I'll fix it soon

Aug 02 '24 05:08 lobehubbot

v1.15.6 这个 bug 依旧存在，现在是还没有修复吗？ @arvinxx

部署环境为 docker

Sep 02 '24 05:09 80imike

The same problem occurs in my senerio, using Vercel + Neon Postgres deployment

Sep 12 '24 13:09 CloudPassenger

@80imike @CloudPassenger 还没修，近期修复

Sep 12 '24 13:09 arvinxx

@80imike @CloudPassenger Not fixed yet, will be fixed soon

Sep 12 '24 13:09 lobehubbot

这个问题 1.9.22 还没有修复呀，期待尽快修复，没有搜索的确不方便

Sep 23 '24 05:09 80imike

This problem has not been fixed in 1.9.22. We hope it will be fixed as soon as possible. It is really inconvenient not to search.

Sep 23 '24 05:09 lobehubbot

same problem

Oct 15 '24 03:10 zcsunt

再来看看，期待早日修复

Oct 19 '24 03:10 80imike

Let’s take another look and look forward to an early fix.

Oct 19 '24 03:10 lobehubbot

期待早日修复，还是很重要的功能的。

Oct 25 '24 07:10 m-guo

Looking forward to an early fix, it is still a very important function.

Oct 25 '24 07:10 lobehubbot