phernandez ec9b2c4046 fix: strip NUL bytes from content before PostgreSQL search indexing ...

rclone preallocation on virtual filesystems (e.g. Google Drive File Stream)
pads markdown files with \x00 bytes (rclone/rclone#6801), which PostgreSQL
rejects with CharacterNotInRepertoireError during search indexing.

Three-pronged fix:
- 🛡️ Primary: _strip_nul() in SearchService.index_entity_markdown() sanitizes
  content_stems, content_snippet, and observation/relation content before
  building SearchIndexRow objects
- 🛡️ Secondary: _strip_nul_from_row() in PostgresSearchRepository.bulk_index_items()
  as a safety net before INSERT
- 🔧 Prevention: --local-no-preallocate flag added to rclone sync and bisync
  commands to prevent the padding at the source

Fixes #548

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Signed-off-by: phernandez <paul@basicmachines.co>

2026-02-20 11:44:13 -06:00

..

test_context_service.py

feat: Add project_id to Relation and Observation for efficient project-scoped queries

2025-12-01 21:54:56 -06:00

test_directory_service.py

feat: Optimize directory operations for 10-100x performance improvement (#350)

2025-10-11 09:11:46 -05:00

test_entity_service_disable_permalinks.py

feat: add directory support to move_note and delete_note tools (#518)

2026-01-26 19:52:10 -06:00

test_entity_service.py

Add metadata filter tests and fix fast write external_id

2026-01-31 15:27:05 -06:00

test_file_service.py

test: remove stdlib mocks, strengthen integration coverage (#489)

2026-01-02 14:22:01 -06:00

test_initialization_cloud_mode_branches.py

fix: prevent CLI commands from hanging on exit (Python 3.14) (#505)

2026-01-11 16:47:35 -06:00

test_initialization.py

fix: prevent CLI commands from hanging on exit (Python 3.14) (#505)

2026-01-11 16:47:35 -06:00

test_link_resolver.py

feat: fast edit entities, refactors for webui, enhance search (#532)

2026-01-31 15:16:52 -06:00

test_project_removal_bug.py

fix: prevent nested project paths to avoid data conflicts (#338)

2025-10-07 09:44:39 -05:00

test_project_service_operations.py

fix: prevent CLI commands from hanging on exit (Python 3.14) (#505)

2026-01-11 16:47:35 -06:00

test_project_service.py

fix: check config default_project only in local mode for remove_project (#523)

2026-01-24 12:53:44 -06:00

test_search_service.py

fix: strip NUL bytes from content before PostgreSQL search indexing

2026-02-20 11:44:13 -06:00