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

m-guo · 2024-07-02T13:05:46Z

📦 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

lobehubbot · 2024-07-02T13:06:01Z

👀 @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。我们会尽快调查此事，并尽快回复您。请确保您已经提供了尽可能多的背景信息。

arvinxx · 2024-07-02T13:32:50Z

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

lobehubbot · 2024-07-02T13:33:01Z

Where is the search broken? I can search it

m-guo · 2024-07-02T13:51:19Z

command + K 搜索

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

shog86 · 2024-07-05T07:14:31Z

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

xwydq · 2024-07-08T10:42:37Z

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

$ 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

是什么原因

m-guo · 2024-07-11T13:56:49Z

在话题搜索框里可以进行全文检索。版本 v1.3.5

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

shog86 · 2024-07-11T23:37:58Z

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

lobehubbot · 2024-07-11T23:38:09Z

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.

m-guo · 2024-07-12T01:11:07Z

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

lobehubbot · 2024-07-12T01:11:20Z

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

Aliang-code · 2024-08-01T09:34:31Z

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

lobehubbot · 2024-08-01T09:34:44Z

This should be specified

#Specify Postgres database driver as node
DATABASE_DRIVER=node

m-guo · 2024-08-01T09:57:45Z

应该是要指定这个

# 指定 Postgres database driver 为 node
DATABASE_DRIVER=node

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

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

lobehubbot · 2024-08-01T09:57:58Z

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.

m-guo · 2024-08-02T02:43:03Z

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

lobehubbot · 2024-08-02T02:43:15Z

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.

arvinxx · 2024-08-02T05:43:00Z

是 bug ，我近期修下

lobehubbot · 2024-08-02T05:43:12Z

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

80imike · 2024-09-02T05:56:44Z

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

部署环境为 docker

CloudPassenger · 2024-09-12T13:10:56Z

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

arvinxx · 2024-09-12T13:42:18Z

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

lobehubbot · 2024-09-12T13:42:31Z

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

80imike · 2024-09-23T05:26:10Z

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

lobehubbot · 2024-09-23T05:26:23Z

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.

zcsunt · 2024-10-15T03:07:38Z

same problem

80imike · 2024-10-19T03:51:40Z

再来看看，期待早日修复

lobehubbot · 2024-10-19T03:51:53Z

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

m-guo · 2024-10-25T07:59:37Z

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

lobehubbot · 2024-10-25T07:59:51Z

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

80imike · 2024-11-08T14:29:22Z

这个 bug 修复优先级有点低呀，这都 4 个月了还没有修

lobehubbot · 2024-11-08T14:29:35Z

The priority of fixing this bug is a bit low. It has not been fixed for more than 4 months.

arvinxx · 2024-11-09T04:08:02Z

@80imike 这个月后半月弄下，其实也困扰我😅

lobehubbot · 2024-11-09T04:08:14Z

@80imike I got it done in the second half of this month, it actually bothers me too😅

lobehubbot · 2024-11-19T03:32:51Z

✅ @m-guo

This issue is closed, If you have any questions, you can comment and reply.
此问题已经关闭。如果您有任何问题，可以留言并回复。

lobehubbot · 2024-11-19T03:41:43Z

🎉 This issue has been resolved in version 1.32.1 🎉

The release is available on:

Your semantic-release bot 📦🚀

m-guo · 2024-11-19T04:21:42Z

1.32.1 版本还是无法全文检索，只解决了搜索助手的名字：

lobehubbot · 2024-11-19T04:21:56Z

Version 1.32.1 still cannot search full text, only the name of the search assistant is solved:

arvinxx · 2024-11-19T04:29:40Z

@cy948 是不是可以考虑把 message 的 content 检索也加上？

lobehubbot · 2024-11-19T04:29:51Z

@cy948 Is it possible to consider adding the content search of message?

cy948 · 2024-11-19T04:54:22Z

@arvinxx 按照目前的实现，如果直接搜消息内容全文可能会有性能问题。可能得先建全文索引才能做。

lobehubbot · 2024-11-19T04:54:34Z

@arvinxx According to the current implementation, there may be performance issues if you directly search the full text of the message content. You may have to build a full-text index before you can do it.

m-guo · 2024-11-27T02:44:40Z

除了不能全文检索，现在除了可以在第一个内部搜索，其余的助手内部检索功能也失效了：

lobehubbot · 2024-11-27T02:44:52Z

In addition to not being able to search the full text, now except for the first internal search, the rest of the assistant's internal search functions are also invalid:

m-guo added the 🐛 Bug Something isn't working | 缺陷 label Jul 2, 2024

github-project-automation bot added this to Lobe Chat Routine Jul 2, 2024

github-project-automation bot moved this to Roadmap - Chat 1.x in Lobe Chat Routine Jul 2, 2024

m-guo changed the title ~~[Bug] 部署服务端数据库模式下不能本地数据库那行全文检索了~~ [Bug] 部署服务端数据库模式不能全文检索了 Jul 2, 2024

arvinxx self-assigned this Aug 2, 2024

arvinxx mentioned this issue Nov 19, 2024

🐛 fix: keyword search for chat history & sessions #4725

Merged

8 tasks

arvinxx closed this as completed in #4725 Nov 19, 2024

github-project-automation bot moved this from Roadmap - Chat 1.x to Done in Lobe Chat Routine Nov 19, 2024

lobehubbot added the released label Nov 19, 2024

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

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

Comments

m-guo commented Jul 2, 2024

📦 Environment

📌 Version

💻 Operating System

🌐 Browser

🐛 Bug Description

📷 Recurrence Steps

🚦 Expected Behavior

📝 Additional Information

lobehubbot commented Jul 2, 2024

arvinxx commented Jul 2, 2024

lobehubbot commented Jul 2, 2024

m-guo commented Jul 2, 2024

shog86 commented Jul 5, 2024

xwydq commented Jul 8, 2024 • edited Loading

m-guo commented Jul 11, 2024 • edited Loading

shog86 commented Jul 11, 2024 • edited Loading

lobehubbot commented Jul 11, 2024

m-guo commented Jul 12, 2024

lobehubbot commented Jul 12, 2024

Aliang-code commented Aug 1, 2024

lobehubbot commented Aug 1, 2024

m-guo commented Aug 1, 2024

lobehubbot commented Aug 1, 2024

m-guo commented Aug 2, 2024

lobehubbot commented Aug 2, 2024

arvinxx commented Aug 2, 2024

lobehubbot commented Aug 2, 2024

80imike commented Sep 2, 2024 • edited Loading

CloudPassenger commented Sep 12, 2024

arvinxx commented Sep 12, 2024

lobehubbot commented Sep 12, 2024

80imike commented Sep 23, 2024

lobehubbot commented Sep 23, 2024

zcsunt commented Oct 15, 2024

80imike commented Oct 19, 2024

lobehubbot commented Oct 19, 2024

m-guo commented Oct 25, 2024

lobehubbot commented Oct 25, 2024

80imike commented Nov 8, 2024 • edited Loading

lobehubbot commented Nov 8, 2024

arvinxx commented Nov 9, 2024

lobehubbot commented Nov 9, 2024

lobehubbot commented Nov 19, 2024

lobehubbot commented Nov 19, 2024

m-guo commented Nov 19, 2024

lobehubbot commented Nov 19, 2024

arvinxx commented Nov 19, 2024

lobehubbot commented Nov 19, 2024

cy948 commented Nov 19, 2024

lobehubbot commented Nov 19, 2024

m-guo commented Nov 27, 2024

lobehubbot commented Nov 27, 2024

xwydq commented Jul 8, 2024 •

edited

Loading

m-guo commented Jul 11, 2024 •

edited

Loading

shog86 commented Jul 11, 2024 •

edited

Loading

80imike commented Sep 2, 2024 •

edited

Loading

80imike commented Nov 8, 2024 •

edited

Loading