=== כשל בטעינת קישורי ספר 2026-10-21T22:17:23.773279 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 1, 0, 200
book: בראשית
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:17:36.613519 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 2, 0, 200
book: שמות
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:22:43.705430 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 1, 0, 200
book: בראשית
window: 0-200

Stack:


=== Indexing failures 2026-10-21T22:32:53.715540 ===
Version: 0.9.98+99800
Duration: 932s
Completed: true
Processed: 10939/10939
Indexed: 10938
Failures: 1
Retryable: 0
Warnings: 0

--- Failure 1 ---
Kind: pdfUnsupported
Retryable: false
Book: ספר השיחות תרצ_ו-חורף ה_ש_ת
Path: C:\Users\קרית מלך רב\Desktop\ספרים\חסידות\06 אדמו''ר הריי''ץ\ספר השיחות\ספר השיחות תרצ_ו-חורף ה_ש_ת.pdf
Error: PdfException: Failed to load PDF document (FPDF_ERR_FORMAT: 3).
Stack:
#0      PdfrxEntryFunctionsImpl._openByFunc (package:pdfrx_engine/src/native/pdfrx_pdfium.dart:866)
<asynchronous suspension>
#1      PdfFontFallback.openFile (package:otzaria/pdf_book/utils/pdf_font_fallback.dart:36)
<asynchronous suspension>
#2      Future.timeout.<anonymous closure> (dart:async/future_impl.dart:1061)
<asynchronous suspension>
#3      IndexingRepository._extractPdfPages (package:otzaria/indexing/repository/indexing_repository.dart:1082)
<asynchronous suspension>
#4      IndexingRepository.extractPdfPagesGuarded (package:otzaria/indexing/repository/indexing_repository.dart:1040)
<asynchronous suspension>
#5      PdfExtractionPrefetcher._start.<anonymous closure> (package:otzaria/indexing/utils/pdf_extraction_prefetcher.dart:152)
<asynchronous suspension>


=== כשל בטעינת קישורי ספר 2026-10-21T22:35:19.680332 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 2, 0, 200
book: שמות
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:35:28.340604 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 65, 0, 200
book: משנה נדרים
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:35:36.506651 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 65, 0, 200
book: משנה נדרים
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:37:33.876990 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 69, 0, 200
book: משנה קידושין
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T22:37:37.501851 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 69, 0, 200
book: משנה קידושין
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:13:09.145204 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 69, 0, 200
book: משנה קידושין
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:16:33.422440 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 1, 0, 200
book: בראשית
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:22:11.655982 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 1, 0, 200
book: בראשית
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:22:14.178446 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 69, 0, 200
book: משנה קידושין
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:22:15.347983 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 65, 0, 200
book: משנה נדרים
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:24:30.511940 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 65, 0, 200
book: משנה נדרים
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:24:48.905186 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 103, 0, 200
book: ברכות
window: 0-200

Stack:


=== כשל בטעינת קישורי ספר 2026-10-21T23:24:57.997069 ===
Version: 0.9.98+99800
Exception: Bad state: SqliteException(11): while selecting from statement, database disk image is malformed, database disk image is malformed (code 11)
  Causing statement:         WITH win(id, bookId) AS (
          SELECT id, bookId FROM line
          WHERE bookId = ? AND lineIndex BETWEEN ? AND ?
        ),
        anchors(linkId, anchorLineId) AS (
          SELECT l.id, l.sourceLineId FROM win w
          CROSS JOIN link l
            ON l.sourceLineId = w.id AND +l.sourceBookId = w.bookId
          
        )
        SELECT
          sl.lineIndex as sourceLineIndex,
          tl.lineIndex as targetLineIndex,
          tl.heRef as targetLineHeRef,
          tb.title as targetBookTitle,
          tb.categoryId as targetCategoryId,
          tb.id as targetBookId,
          NULL as targetFileType,
          NULL as targetRangeEndHeRef,
          NULL as targetRangeEndLineIndex,
          NULL as anchorCharStart,
          NULL as anchorCharEnd,
          NULL as anchorLabel,
          NULL as anchorSpans,
          NULL as anchorLinkedCharStart,
          NULL as anchorLinkedCharEnd,
          ct.name as connectionTypeName
        FROM anchors a
        JOIN link l ON l.id = a.linkId
        JOIN line sl ON sl.id = a.anchorLineId
        JOIN line tl ON l.targetLineId = tl.id
        JOIN book tb ON l.targetBookId = tb.id
        LEFT JOIN connection_type ct ON l.connectionTypeId = ct.id
        
        
        WHERE 1=1
          AND (ct.name IS NULL OR ct.name NOT IN ('COMMENTARY', 'SUPER_COMMENTARY', 'TARGUM', 'MIDRASH', 'PARSHANUT', 'DIBUR_HAMATCHIL', 'ELUCIDATION', 'EXPLICATION', 'FOOTNOTES'))
          
        ORDER BY sl.lineIndex, tb.orderIndex
      , parameters: 104, 0, 200
book: שבת
window: 0-200

Stack: