eikek / eikek/docspell

Periodic query tasks fail

Open
#3,287 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Elm
Stars
2.3k
Forks
184
Avg merge
8h 2m
Merged PRs (30d)
4

Description

Hei there.

My periodic queries in which I try to send E-Mails listing all items of a bookmarked search query are failing with the following error:

```
Sa.. 7. März 2026, 22:59: Loaded bookmark '3N4TNhZJCSc-2HQiCyTdPjX-JKLSkd9QAzj-RTakvm2nsLq': Some(Right((& due<=today;+7d f:erledigt="false" )))
Sa.. 7. März 2026, 22:59: Using bookmark: Right((& due<=today;+7d f:erledigt="false" ))
Sa.. 7. März 2026, 22:59: Running query: Query(Fix(AccountInfo(CollectiveId(1),Ident(),Ident(dD52JQvu3K4-oRtaJMnZeyF-9WvTJkJK1XN-ZrusKTqwWf),Ident()),Some(ValidItemStates),None),QueryExpr(Some(AndExpr(NonEmptyList(SimpleExpr(Lte,DateProperty(DueDate,Calc(Today,Plus,P7D))), CustomFieldMatch(erledigt,Eq,false))))))
Sa.. 7. März 2026, 22:59: Job FbutKfTF7.../1/periodic-query-notify2/Low execution failed. Retrying later.: The column index is out of range: 13, number of columns: 12.
```

In the job executor logs I find:

```
2026-03-07T21:59:49.663286844Z 2026.03.07 22:59:49:0000 [io-comp...] [ERROR] docspell.store.impl.DoobieLogging.run:27 - SQL processing failed: SELECT useremail.id, useremail.uid, useremail.name, useremail.smtp_host, useremail.smtp_port, useremail.smtp_user, useremail.smtp_password, useremail.smtp_ssl, useremail.smtp_certcheck, useremail.mail_from, useremail.mail_replyto, useremail.created FROM useremail WHERE useremail.id = ? (NonBatch(List(Ident(ErL2PH2XNEP-eh8EUtWZcsJ-DZRhhP3Dhte-UFisEr5UAgk))))
2026-03-07T21:59:49.663341810Z org.postgresql.util.PSQLException: The column index is out of range: 13, number of columns: 12.
```

I run Docspell 0.43.0 with a Postgres database.

I tried to recreate my SMTP settings, but ran into #3099.

Any help with this would be greatly appreciated.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.