starred/karakeep

Fork 0

mirror of https://github.com/karakeep-app/karakeep.git synced 2026-04-25 07:56:05 +03:00

[GH-ISSUE #944] AI tag generation fails with ollama #623

New issue

Closed

opened 2026-03-02 11:51:23 +03:00 by kerem · 2 comments

kerem commented

2026-03-02 11:51:23 +03:00

Owner

Originally created by @L0sWach0s on GitHub (Jan 28, 2025).
Original GitHub issue: https://github.com/karakeep-app/karakeep/issues/944

Describe the Bug

When I try to generate tags, I always get the following error.

hoarder              | 2025-01-28T17:56:10.119Z error: **[inference][137] inference job failed: SqliteError: no such column:** customPrompts.attachedBy
hoarder              | SqliteError: no such column: customPrompts.attachedBy
hoarder              |     at Database.prepare (/app/apps/workers/node_modules/.pnpm/better-sqlite3@11.3.0/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
hoarder              |     at BetterSQLiteSession.prepareQuery (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/better-sqlite3/session.cjs:42:30)
hoarder              |     at QueryPromise._prepare (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:119:81)
hoarder              |     at QueryPromise.executeRaw (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:159:17)
hoarder              |     at QueryPromise.execute (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:162:17)
hoarder              |     at QueryPromise.then (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/query-promise.cjs:44:17)
hoarder              |     at runNextTicks (node:internal/process/task_queues:65:5)
hoarder              |     at listOnTimeout (node:internal/timers:555:9)
hoarder              |     at process.processTimers (node:internal/timers:529:7)

The AI based summary is working fine.

My AI Settings are:
OLLAMA_KEEP_ALIVE=5m
INFERENCE_TEXT_MODEL=llama3.2:3b
INFERENCE_LANG=german
INFERENCE_JOB_TIMEOUT_SEC=300
EMBEDDING_TEXT_MODEL=joanfm/jina-embeddings-v2-base-de
INFERENCE_IMAGE_MODEL=llava-llama3

and I recognized, that the models joanfm/jina-embeddings-v2-base-de ans llama-llama3 were not loaded at anytime.

Steps to Reproduce

Import a Link / Text / picture
look in the log ;)

Expected Behaviour

the tags will be generated

Screenshots or Additional Context

No response

Device Details

Docker container

Exact Hoarder Version

Hoarder v0.21.0, ollama version is 0.5.7

Have you checked the troubleshooting guide?

I have checked the troubleshooting guide and I haven't found a solution to my problem

Originally created by @L0sWach0s on GitHub (Jan 28, 2025). Original GitHub issue: https://github.com/karakeep-app/karakeep/issues/944 ### Describe the Bug When I try to generate tags, I always get the following error. ``` hoarder | 2025-01-28T17:56:10.119Z error: **[inference][137] inference job failed: SqliteError: no such column:** customPrompts.attachedBy hoarder | SqliteError: no such column: customPrompts.attachedBy hoarder | at Database.prepare (/app/apps/workers/node_modules/.pnpm/better-sqlite3@11.3.0/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) hoarder | at BetterSQLiteSession.prepareQuery (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/better-sqlite3/session.cjs:42:30) hoarder | at QueryPromise._prepare (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:119:81) hoarder | at QueryPromise.executeRaw (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:159:17) hoarder | at QueryPromise.execute (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/sqlite-core/query-builders/query.cjs:162:17) hoarder | at QueryPromise.then (/app/apps/workers/node_modules/.pnpm/drizzle-orm@0.38.3_better-sqlite3@11.3.0/node_modules/drizzle-orm/query-promise.cjs:44:17) hoarder | at runNextTicks (node:internal/process/task_queues:65:5) hoarder | at listOnTimeout (node:internal/timers:555:9) hoarder | at process.processTimers (node:internal/timers:529:7) ``` The AI based summary is working fine. My AI Settings are: OLLAMA_KEEP_ALIVE=5m INFERENCE_TEXT_MODEL=llama3.2:3b INFERENCE_LANG=german INFERENCE_JOB_TIMEOUT_SEC=300 EMBEDDING_TEXT_MODEL=joanfm/jina-embeddings-v2-base-de INFERENCE_IMAGE_MODEL=llava-llama3 and I recognized, that the models joanfm/jina-embeddings-v2-base-de ans llama-llama3 were not loaded at anytime. ### Steps to Reproduce 1. Import a Link / Text / picture 2. look in the log ;) ### Expected Behaviour the tags will be generated ### Screenshots or Additional Context _No response_ ### Device Details Docker container ### Exact Hoarder Version Hoarder v0.21.0, ollama version is 0.5.7 ### Have you checked the troubleshooting guide? - [x] I have checked the troubleshooting guide and I haven't found a solution to my problem

kerem closed this issue

2026-03-02 11:51:24 +03:00

kerem commented

2026-03-02 11:51:24 +03:00

Author

Owner

@kamtschatka commented on GitHub (Jan 31, 2025):

looks like there was an issue with your database migration and a column is missing. Is this a new setup, or did you go through some upgrades before? Are you maybe still running with 2 hoarder containers? (web and worker)

@kamtschatka commented on GitHub (Jan 31, 2025): looks like there was an issue with your database migration and a column is missing. Is this a new setup, or did you go through some upgrades before? Are you maybe still running with 2 hoarder containers? (web and worker)

kerem commented

2026-03-02 11:51:24 +03:00

Author

Owner

@L0sWach0s commented on GitHub (Jan 31, 2025):

Thanks for the hint!
I don't know why the inconsistency occurred in my database but after reinitializing the little lama does it's job quite well!

Thanks a lot!

@L0sWach0s commented on GitHub (Jan 31, 2025): Thanks for the hint! I don't know why the inconsistency occurred in my database but after reinitializing the little lama does it's job quite well! Thanks a lot!

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/karakeep#623

No description provided.

Rows
Columns