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.

Sign up for GitHub

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

Jump to bottom

When rebuilding the index, it is prompted that the block cannot be found #9271

Closed
3 tasks done
Temacc0531 opened this issue Sep 26, 2023 · 4 comments
Closed
3 tasks done

When rebuilding the index, it is prompted that the block cannot be found #9271

Temacc0531 opened this issue Sep 26, 2023 · 4 comments

Comments

@Temacc0531
Copy link

Temacc0531 commented Sep 26, 2023 •
edited

Is there an existing issue for this?

  • I have searched the existing issues

Can the issue be reproduced with the default theme (daylight/midnight)?

  • I was able to reproduce the issue with the default theme

Could the issue be due to extensions?

  • I've ruled out the possibility that the extension is causing the problem.

Describe the problem

刚刚安装完v2.10.7，启动软件，进入主界面，重建索引，提示找不到块，但是索引好像还是正常重建了

然后我等跑完又重新点了再一次重建索引，好像又没有这个提示了，不知道具体里面有没有什么问题😂

Expected result

重建索引存在块缺失时，稳定报错

Screenshot or screen recording presentation

No response

Version environment

- Version: v2.10.7
- Operating System: Windows 11

Log file

siyuan.log

More information

No response
@zxhd863943427
Copy link
Contributor

zxhd863943427 commented Sep 26, 2023 •
edited by 88250

使用以下sql嵌入块查找缺失块：

select *
from blocks
where id in (
        select block_id
        from refs
        where not def_block_id in (
                select id
                from blocks
            )
    )

注意缺失可能是因为你关闭了对应的笔记本。

@Temacc0531
Copy link
Author

确实找到了有部分块缺失了，但是怎么这个报错后面再次重建索引又不出现了？😂

@88250
Copy link
Member

88250 commented Sep 27, 2023

出现 未找到块 的提示是因为鼠标悬浮了引用后或者进行块打开操作后系统发现块找不到触发的，重建索引时应该不会提示才对，我先关闭了，请后续继续留意观察，如果能有稳定重现的步骤就更好了，谢谢。

@88250 88250 closed this as completed Sep 27, 2023
@Temacc0531
Copy link
Author

出现 未找到块 的提示是因为鼠标悬浮了引用后或者进行块打开操作后系统发现块找不到触发的

应该不是，我查出来是一篇很古老的文章里面引用的（根本没有打开），我后续再留意一下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@88250 @zxhd863943427 @Temacc0531