Periodic query tasks fail
- 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
Assessment
This issue has not been assessed yet.