Issues search result is incorrect #27540
Comments
|
Do you enable another search engine or just using the default bleve engine? |
|
I am also a programmer and proficient in Go, able to compile Gitea myself, but I am unfamiliar with Gitea and need someone to teach me where to add logs so that I can debug it. Alternatively, can anyone tell me how to print the SQL execution logs of the database so that I can analyze if there are any SQL errors? 我也是程序员， 也会 golang, 可以自已编译 gitea, 但我对 gitea 不了解， 需要有人教我在什么地方加日志， 这样我可以调试一下 或者谁能告诉我如何打印数据库的 sql 执行日志， 我好分析一下是不是 sql 错了 |
No enable another search engine, and just using the default db engine |
|
2023/10/09 20:49:21 ...dexer/issues/util.go:170:pushIssueIndexerQueue() [W] It seems that issue indexer is slow and the queue is full. Please check the issue indexer or increase the queue size. |
|
GetIssueIDsByRepoID() return context deadline exceeded |
https://docs.gitea.com/next/administration/config-cheat-sheet?_highlight=cheat#log-log for print detailed logs and gitea/custom/conf/app.example.ini Line 392 in 28ead9e for SQL query logs. |
|
问题解决了， 原因是下面的函数 func updateRepoIndexer(ctx context.Context, repoID int64) error { 我们有一个 repo 中的 issue 很多有 6000 多个， GetIssueIDsByRepoID() 后， 将每一个 id 作为参数调用 updateIssueIndexer 时出错了， 返回了 context.DeadlineExceeded 出错原因是 queue 满了， 要命的是 updateRepoIndexer() 会不停的被重新调用，不停地出错。 解决方法是配置中添加下面的行就好了， 只要确保 queue length 大于 repo 中的 issue 数目一般就不会出错 [queue.issue_indexer] 总结， 是我配置的不合理， 但是我仍然认为 这是一个 bug, 因为它的后果太严重了 改进代码如下 func updateRepoIndexer(ctx context.Context, repoID int64) error {
ids, err := issue_model.GetIssueIDsByRepoID(ctx, repoID)
if err != nil {
return fmt.Errorf("issue_model.GetIssueIDsByRepoID: %w", err)
}
for _, id := range ids {
for {
err := updateIssueIndexer(id)
if err == nil {
break
}
if !errors.Is(context.DeadlineExceeded) {
return err
}
// 在这里加入重试， 同时 check ctx.Done() 就不会影响退出。
select {
case <- ctx.Done():
return err
case <- time.After(1* time.Minute):
}
}
}
return nil
} |
|
@wolfogre Could you have time to take a look at this? |
|
The root problem is that indexing all issues of a repository could be a big task, and it could cause a blocking. So we use a queue to cache the task. But what if the queue was full? I noticed this case and added the warning log in the last refactoring to help users know this (the old code just ignore it): So the best solution is increasing the size of queue (just like the log said). @mei-rune Thanks for your advice. I have indeed found some logic that could be improved. I will submit a patch later. Please note that if the queue size is insufficient, index loss is still possible. BTW, @lng2020 please note that the default issue indexer is not DB, it's bleve. |
|
@wolfogre 你的理解正确， 我希望不能因为我的 queue 长度导致这么大问题， 我发了上面的补丁尝试解决问题，我对 gitea 架构不熟悉， 仅解决了眼前的问题， 不确定对全局是否有影响。 |
Backport #27555 by @wolfogre It should be OK to increase the default queue length since the default type is "level". IMO, the old default length (100) is a little too small. See #27540 (comment) IIRC, a larger length could lead to more memory usage only when the type is "channel," but it's an obscure case. Otherwise, it's just a limit (for "level" or "redis"). Co-authored-by: Jason Song <i@wolfogre.com>
Description
Issues search result is incorrect, 搜索结果不正确，如下图中有记录包含"固资"
search results, 我用 "固资" 搜索时返回空
https://xxxx/xxxxx/test/issues?type=all&state=open&labels=&milestone=0&project=0&assignee=0&poster=0&q=%E5%9B%BA%E8%B5%84
日志中无出错记录。
Gitea Version
1.21.0+rc0-44-g7ea7f2b37 built with GNU Make 4.3, go1.21.1 : bindata, sqlite, sqlite_unlock_notify
Can you reproduce the bug on the Gitea demo site?
Yes
Log Gist
No response
Screenshots
No response
Git Version
2.30.0, Wire Protocol Version 2 Enabled
Operating System
windows 2016
How are you running Gitea?
run as windows service
Database
SQLite
The text was updated successfully, but these errors were encountered: